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
