*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 <bak...@rfa.org> 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" <pedro.pic...@gmail.com>
> *To: *"Todd Baker" <bak...@rfa.org>
> *Cc: *"drew Roberts" <zotz...@gmail.com>, "User discussion about the
> Rivendell Radio Automation System" <rivendell-dev@lists.rivendellaudio.org
> >
> *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 <bak...@rfa.org> 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" <pedro.pic...@gmail.com>
>> *To: *"drew Roberts" <zotz...@gmail.com>
>> *Cc: *"User discussion about the Rivendell Radio Automation System" <
>> rivendell-dev@lists.rivendellaudio.org>
>> *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 <zotz...@gmail.com> wrote:
>>
>>> Pedro,
>>>
>>> On Tue, Jul 11, 2017 at 8:49 PM, Pedro Picoto <pedro.pic...@gmail.com>
>>> 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 <zotz...@gmail.com>
>>>> wrote:
>>>>
>>>>> Pedro,
>>>>>
>>>>> On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto <pedro.pic...@gmail.com>
>>>>> 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 <41001...@interpring.com>
>>>>>> 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 <
>>>>>>>> fr...@paravelsystems.com>
>>>>>>>> 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
>>>>>>>> Rivendell-dev@lists.rivendellaudio.org
>>>>>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Rivendell-dev mailing list
>>>>>> Rivendell-dev@lists.rivendellaudio.org
>>>>>> 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
>> Rivendell-dev@lists.rivendellaudio.org
>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>
>
>
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
