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: 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 *** I have a RD db backup from a previous system... can I impose it to this setup, if so, how? 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/> >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
