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 <[email protected]> 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" <[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:
>>
>>> 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
>
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
