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
