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: BQ_BEGIN 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. BQ_BEGIN 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 *** BQ_END 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. BQ_BEGIN I have a RD db backup from a previous system... can I impose it to this setup, if so, how? BQ_END 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 BQ_BEGIN 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: BQ_BEGIN Pedro, On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto < [email protected] > wrote: BQ_BEGIN 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... BQ_END 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 BQ_BEGIN On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry < [email protected] > wrote: BQ_BEGIN 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: BQ_BEGIN 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 BQ_END BQ_END _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev BQ_END -- Enjoy great Bahamian Music at: Bahamain Or Nuttin - http://www.bahamianornuttin.com BQ_END BQ_END -- Enjoy great Bahamian Music at: Bahamain Or Nuttin - http://www.bahamianornuttin.com BQ_END _______________________________________________ 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
