Every command you enter in the MySQL shell must end with a semi colon. Otherwise the shell thinks you're continuing the statement, and will issue another prompt to get the remaining text (that's the "->" at the start of the line). If you forget the semi-colon, you can enter it at that continuation prompt.
I didn't check all of the messages: are you running as a client/server, where the MySQL server is on another machine? If that's the case, you may be having a problem with MySQL authorizations. On Wed, Jul 12, 2017 at 7:48 AM Pedro Picoto <[email protected]> wrote: > *When you see the mysql> prompt. That Is where you type show databases and* > *press enter. It should return all the database that exist on your > server.* > > Noooooob here... > > But... here's what I get: > > mysql> show databases > -> > > Nothing else... > ############################################################## > > On the /etc/rd.conf I have this values: > > > [mySQL] > ; The connection parameters for the MySQL server. > Hostname=localhost > Loginname=rduser > Password=letmein > Database=Rivendell > Driver=QMYSQL3 > > Are these OK or should they be different? They seem to be defaults... > > > > > > > > > > > > > On Wed, Jul 12, 2017 at 2:49 PM, Todd Baker <[email protected]> wrote: > >> Dear Pedro, >> >> You seem to have logged into mysql correctly here ...I assume you gave it >> a password (WITH PASSWORD) >> and you got in - because thats when you get the Welcome message...... >> >> >> ----------------------------------------------------------------------------- >> > pedro@pedro-home ~ $ mysql -u root -p >> Enter password: (WITH PASSWORD) >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 15 >> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu) >> >> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights >> reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> affiliates. Other names may be trademarks of their respective >> owners. >> >> Type 'help;' or '\h' for help. Type '\c' to clear the current input >> statement. >> >> mysql> >> > >> ------------------------------------------------------------------------------------------------------ >> >> When you see the mysql> prompt. That Is where you type show databases and >> press enter. It should return all the database that exist on your server. >> >> Are you getting in with a password or am I confused about your output.... >> Todd >> >> >> >> ------------------------------ >> *From: *"Pedro Picoto" <[email protected]> >> *To: *"Todd Baker" <[email protected]> >> *Cc: *"drew Roberts" <[email protected]>, "User discussion about the >> Rivendell Radio Automation System" < >> [email protected]> >> *Sent: *Wednesday, July 12, 2017 9:29:36 AM >> > >> *Subject: *Re: [RDD] Rivendell v2.16.0 >> > >> Todd, thanks for the input. >> I do believe that I'm making a pretty mess around this. >> >> I actually removed/purged mysql and reinstalled it with "sudo apt -y >> install apache2 mysql-server" >> The usual DOS look password request popped and I introduced/reintroduced >> the password wich is the same (my option) I'm using on my # >> >> ################################################################################## >> Here is the current status: >> >> pedro@pedro-home ~ $ systemctl status mysql.service >> ● mysql.service - MySQL Community Server >> Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor >> preset: en >> Active: active (running) since Qua 2017-07-12 13:24:45 WEST; 17min ago >> Process: 22931 ExecStartPost=/usr/share/mysql/mysql-systemd-start post >> (code=e >> Process: 22921 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre >> (code=exi >> Main PID: 22930 (mysqld) >> CGroup: /system.slice/mysql.service >> └─22930 /usr/sbin/mysqld >> >> Jul 12 13:24:44 pedro-home systemd[1]: Starting MySQL Community Server... >> Jul 12 13:24:45 pedro-home systemd[1]: Started MySQL Community Server. >> Jul 12 13:39:04 pedro-home systemd[1]: Started MySQL Community Server. >> ########################################################################l >> >> pedro@pedro-home ~ $ mysqladmin -p -u root version >> Enter password: (WITH PASSWORD) >> mysqladmin Ver 8.42 Distrib 5.7.18, for Linux on x86_64 >> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights >> reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> affiliates. Other names may be trademarks of their respective >> owners. >> >> Server version 5.7.18-0ubuntu0.16.04.1 >> Protocol version 10 >> Connection Localhost via UNIX socket >> UNIX socket /var/run/mysqld/mysqld.sock >> Uptime: 14 min 36 sec >> >> Threads: 1 Questions: 12 Slow queries: 0 Opens: 115 Flush tables: 1 >> Open tables: 34 Queries per second avg: 0.013 >> >> ############################################################################################## >> >> pedro@pedro-home ~ $ mysql> show databases >> ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using >> password: NO) >> >> #################################################################################################### >> >> pedro@pedro-home ~ $ mysql -u root -p >> Enter password: (WITH PASSWORD) >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 15 >> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu) >> >> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights >> reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> affiliates. Other names may be trademarks of their respective >> owners. >> >> Type 'help;' or '\h' for help. Type '\c' to clear the current input >> statement. >> >> mysql> >> >> #################################################################################################### >> >> >> pedro@pedro-home ~ $ mysql -u root -p >> Enter password: (BLANK) >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >> password: NO) >> >> ##################################################################################################### >> >> >> >> >> I might be wrong but can this be Ubuntu messing around? >> >> >> >> >> >> >> >> >> >> On Wed, Jul 12, 2017 at 12:37 PM, Todd Baker <[email protected]> wrote: >> >>> Dear Pedro, >>> Just want to chime in to make sure we are on the right page (same >>> page?). >>> >>> There is a difference between the System root user, and the mysql root >>> user. The >>> default password for root when you create a new mysql server is NOTHING >>> (null). >>> >>> So, if you are using a brand new installation of mysql and you type >>> mysql -u root -p >>> Enter Password <Press Enter Here> >>> >>> If it is brand new - and you press enter (no password) - you should get >>> something like >>> Welcome to MySql (blah Blah).. (or Welcome to MaraidDB (blah >>> Blah)...on my machine). >>> Note: No Password when it is brand new install >>> >>> So, if you are getting a password challenge, and null (no password) >>> doesn't work, >>> probably not a brand new installation of mysql - me thinks. >>> >>> If blank password does work, then type >>> show databases and try to do what Drew said below. >>> >>> Hope you have success.. >>> >>> Todd Baker >>> ------------------------------ >>> *From: *"Pedro Picoto" <[email protected]> >>> *To: *"drew Roberts" <[email protected]> >>> *Cc: *"User discussion about the Rivendell Radio Automation System" < >>> [email protected]> >>> *Sent: *Wednesday, July 12, 2017 12:00:21 AM >>> *Subject: *Re: [RDD] Rivendell v2.16.0 >>> >>> My bad!!! >>> >>> Upon mysql -u root -p: >>> I'VE entered my root password and NOW I got the "mysql: [Warning] Using >>> a password on the command line interface can be insecure. >>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >>> password: YES)" >>> *AND this is new to me. B4 I had the list of \* commands.* >>> Meanwhile: >>> On /etc/rd.conf I have this: >>> >>> [mySQL] >>> ; The connection parameters for the MySQL server. >>> Hostname=localhost >>> Loginname=rduser >>> Password=letmein >>> Database=Rivendell >>> Driver=QMYSQL3 >>> >>> Regarding Matthew's suggestion... will a RH script run on Debian >>> (Ubuntu)? >>> >>> It's 5am here... i have to take some rest. Thank you all! >>> >>> >>> >>> On Wed, Jul 12, 2017 at 3:37 AM, drew Roberts <[email protected]> wrote: >>> >>>> Pedro, >>>> >>>> On Tue, Jul 11, 2017 at 8:49 PM, Pedro Picoto <[email protected]> >>>> wrote: >>>> >>>>> Back home... here's what I've got: >>>>> >>>>> Upon sql> show databases. >>>>> ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using >>>>> password: NO) >>>>> >>>>> Upon mysql -u root -p get a password request wich shows: >>>>> >>>> >>>> Pedro, I think you are giving incomplete information which may cause >>>> trouble. >>>> >>>> You say you get a password request but you don't indicate that you >>>> enter one. I am assuming that you did. If not, tell us because that may >>>> imply something else. >>>> >>>> >>>> >>>>> Welcome to the MySQL monitor. Commands end with ; or \g. >>>>> Your MySQL connection id is 25 >>>>> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu) >>>>> >>>>> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights >>>>> reserved. >>>>> >>>>> Oracle is a registered trademark of Oracle Corporation and/or its >>>>> affiliates. Other names may be trademarks of their respective >>>>> owners. >>>>> >>>>> Upon mysql> \r: >>>>> >>>>> Connection id: 27 >>>>> Current database: *** NONE *** >>>>> >>>> >>>> at this point, enter: >>>> >>>> show databases; -> like so: >>>> >>>> mysql> show databases; >>>> >>>> Look for Rivendell as I explained. >>>> >>>> If you see it, drop it, exit mysql, and then run rdadmin. >>>> >>>> Enter root and the root password I assumed you entered above. >>>> >>>> This will create a Rivendell database. >>>> >>>> Go back into mysql: >>>> >>>> mysql -u root -p >>>> >>>> enter that assumed root password, then: >>>> >>>> show databases; >>>> >>>> and now you should see Rivendell >>>> >>>> Let us know either way. >>>> >>>>> >>>>> I have a RD db backup from a previous system... can I impose it to >>>>> this setup, if so, how? >>>>> >>>> >>>> If we get to success as above, we can test that the test tone plays and >>>> then work on restoring an old database. >>>> >>>> all the best, >>>> >>>> drew >>>> >>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> pedro-home pedro # mysql -u root -p >>>>> Enter password: >>>>> Welcome to the MySQL monitor. Commands end with ; or \g. >>>>> Your MySQL connection id is 25 >>>>> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu) >>>>> >>>>> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights >>>>> reserved. >>>>> >>>>> Oracle is a registered trademark of Oracle Corporation and/or its >>>>> affiliates. Other names may be trademarks of their respective >>>>> owners. >>>>> >>>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input >>>>> statement. >>>>> >>>>> >>>>> >>>>> On Tue, Jul 11, 2017 at 10:07 PM, drew Roberts <[email protected]> >>>>> wrote: >>>>> >>>>>> Pedro, >>>>>> >>>>>> On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto <[email protected] >>>>>> > wrote: >>>>>> >>>>>>> I'm not at my pc... from memory when I " mysql -uroot -p" I'm not >>>>>>> asked for any password. All I get is a sort o list of "\*" commands... >>>>>>> >>>>>> >>>>>> That would mean there is not root password for mysql. >>>>>> >>>>>> try: >>>>>> >>>>>> mysql> show databases; >>>>>> >>>>>> do you see a Rivendell database? >>>>>> >>>>>> If so, and this machine has never been running before, and if perhaps >>>>>> you have backup from another system, drop it and run rdadmin. >>>>>> >>>>>> When it runs, try putting in root as a user and leaving the password >>>>>> blank. >>>>>> >>>>>> Then come back and see if you have a Rivendell database. >>>>>> >>>>>> all the best, >>>>>> >>>>>> drew >>>>>> >>>>>>> >>>>>>> On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry <[email protected] >>>>>>> > wrote: >>>>>>> >>>>>>>> >>>>>>>> Do you have all the relevant MySQL packages installed? >>>>>>>> >>>>>>>> Have you assigned a password to the MySQL root user? >>>>>>>> >>>>>>>> What happens if you type: >>>>>>>> >>>>>>>> mysql -uroot -p[whatever] >>>>>>>> >>>>>>>> If that comand works, you should be able to give mysqladmin 'root' >>>>>>>> and whatever password you assigned the MySQL root user, and it should >>>>>>>> create a database. >>>>>>>> >>>>>>>> >>>>>>>> Rob >>>>>>>> >>>>>>>> -- >>>>>>>> Я там, где ребята толковые, >>>>>>>> Я там, где плакаты "Вперёд", >>>>>>>> Где песни рабочие новые >>>>>>>> Страна трудовая поёт. >>>>>>>> >>>>>>>> >>>>>>>> On Tue, 11 Jul 2017, Pedro Picoto wrote: >>>>>>>> >>>>>>>> Long time no see... >>>>>>>>> Since the end(?) of Tryphon's Ubuntu "just add water" Rivendell >>>>>>>>> fork I have >>>>>>>>> "quit" from RD... untill I start missing it. >>>>>>>>> I'm on a stage of compiling from source on a already running Mint >>>>>>>>> 18.1. >>>>>>>>> >>>>>>>>> I'm using this tutorial: >>>>>>>>> http://rivendell.tryphon.org/wiki/UbuntuXenial >>>>>>>>> >>>>>>>>> Issues so far: >>>>>>>>> - RDADMIN: "Unable to connect to mysql", thus unable to create a >>>>>>>>> new DB. >>>>>>>>> >>>>>>>>> Also: >>>>>>>>> pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp >>>>>>>>> opendb.cpp.patch >>>>>>>>> patching file /rdadmin/opendb.cpp >>>>>>>>> Hunk #1 FAILED at 240. >>>>>>>>> patch: **** Can't reopen file /rdadmin/opendb.cpp : No such file or >>>>>>>>> directory >>>>>>>>> >>>>>>>>> pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp >>>>>>>>> createdb.cpp-instance.patch >>>>>>>>> patching file /rdadmin/createdb.cpp >>>>>>>>> Hunk #1 FAILED at 1241. >>>>>>>>> Hunk #2 FAILED at 1353. >>>>>>>>> Hunk #3 FAILED at 1773. >>>>>>>>> Hunk #4 FAILED at 1808. >>>>>>>>> patch: **** Can't reopen file /rdadmin/createdb.cpp : No such file >>>>>>>>> or >>>>>>>>> directory >>>>>>>>> >>>>>>>>> I don't know if the patch problem (wich I might be doing something >>>>>>>>> wrong) >>>>>>>>> can be related to the "Unable to connect to mysql" >>>>>>>>> >>>>>>>>> QUESTION; What should be the (RDADMIN) Username and password for a >>>>>>>>> compiled >>>>>>>>> from source? I'm using "root/root" with no success >>>>>>>>> >>>>>>>>> >>>>>>>>> The database is apparentely ok. I've checked on the terminal it >>>>>>>>> with no >>>>>>>>> errors returned. >>>>>>>>> >>>>>>>>> Hints?... TIA! >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Fri, Jun 2, 2017 at 1:47 PM, Fred Gleason < >>>>>>>>> [email protected]> >>>>>>>>> wrote: >>>>>>>>> On behalf of the entire Rivendell development team, I'm >>>>>>>>> pleased >>>>>>>>> to announce the availability of Rivendell v2.16.0. >>>>>>>>> Rivendell is >>>>>>>>> a full-featured radio automation system targeted for use in >>>>>>>>> professional broadcast environments. It is available under >>>>>>>>> the >>>>>>>>> GNU General Public License. >>>>>>>>> >>>>>>>>> From the NEWS file:*** snip snip *** >>>>>>>>> Changes: >>>>>>>>> Audio Store Hashing. Rivendell now automatically generates a >>>>>>>>> SHA1 >>>>>>>>> hash >>>>>>>>> for each file in the audio store and records this value in the >>>>>>>>> database, >>>>>>>>> thus permitting automated recovery of audio in the event of >>>>>>>>> loss or >>>>>>>>> damage >>>>>>>>> to the audio store's filesystem directory. See the >>>>>>>>> --relink-audio >>>>>>>>> option >>>>>>>>> in the rddbcheck(8) man page for details. >>>>>>>>> >>>>>>>>> Kernel GPIO. Added switcher support for Kernel GPIO devices, >>>>>>>>> such >>>>>>>>> as >>>>>>>>> the GPIO interface on the Raspberry Pi 2 and 3. >>>>>>>>> >>>>>>>>> Modbus TCP. Added switcher support for Modbus TCP devices. >>>>>>>>> >>>>>>>>> RDConvert. Added an rdconvert(1) utility, >>>>>>>>> >>>>>>>>> User Authentication. It is now possible to delegate >>>>>>>>> authentication >>>>>>>>> of >>>>>>>>> Rivendell users by means of a PAM module, thus permitting >>>>>>>>> 'single >>>>>>>>> sign-on' >>>>>>>>> integration with systems such as ActiveDirectory and FreeIPA. >>>>>>>>> >>>>>>>>> Web API. Added various methods to the Rivendell Web API to >>>>>>>>> permit >>>>>>>>> integration with external audio and log editors. >>>>>>>>> >>>>>>>>> Various other bug fixes. See the ChangeLog for details. >>>>>>>>> >>>>>>>>> Database Update: >>>>>>>>> This version of Rivendell uses database schema version 263, and >>>>>>>>> will >>>>>>>>> automatically upgrade any earlier versions. To see the current >>>>>>>>> schema >>>>>>>>> version prior to upgrade, see RDAdmin->SystemInfo. >>>>>>>>> >>>>>>>>> As always, be sure to run RDAdmin immediately after upgrading to >>>>>>>>> allow >>>>>>>>> any necessary changes to the database schema to be applied. >>>>>>>>> >>>>>>>>> *** snip snip *** >>>>>>>>> >>>>>>>>> Further information, screenshots and download links are available >>>>>>>>> at: >>>>>>>>> >>>>>>>>> http://www.rivendellaudio.org >>>>>>>>> >>>>>>>>> Cheers! >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> |----------------------------------------------------------------------| >>>>>>>>> | Frederick F. Gleason, Jr. | Chief Developer >>>>>>>>> >>>>>>>>> | >>>>>>>>> | | Paravel Systems >>>>>>>>> >>>>>>>>> | >>>>>>>>> >>>>>>>>> |----------------------------------------------------------------------| >>>>>>>>> | I look at it this way: if the station doesn't receive at least >>>>>>>>> one >>>>>>>>> | >>>>>>>>> | bomb threat a week, it means that we're not reaching our >>>>>>>>> audience. >>>>>>>>> | >>>>>>>>> | -- Keith Leach >>>>>>>>> >>>>>>>>> | >>>>>>>>> >>>>>>>>> |----------------------------------------------------------------------| >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Rivendell-dev mailing list >>>>>>>>> [email protected] >>>>>>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Rivendell-dev mailing list >>>>>>> [email protected] >>>>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Enjoy great *Bahamian Music* at: >>>>>> Bahamain Or Nuttin - http://www.bahamianornuttin.com >>>>>> <http://www.bahamianornuttin.com/> >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Enjoy great *Bahamian Music* at: >>>> Bahamain Or Nuttin - http://www.bahamianornuttin.com >>>> <http://www.bahamianornuttin.com/> >>>> >>> >>> >>> _______________________________________________ >>> Rivendell-dev mailing list >>> [email protected] >>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>> >> >> _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
