Re: [RDD] last steps of Rivendell 3 install

[Simon Frech]

Dear Todd,

Thank you very much for this detailed explanation. It makes sense now! You are 
a good teacher!

I opened terminal, logged in as root using su -
then entered the mysql -u root -p
entered the “mylousypassword” 
and was greeted with 
Welcome to the MariaDB monitor, etc.
Server version: 5.5.65-MariaDB MariaDB Server

This means that the setting the password previously was successful, and the DB 
is ready to be used, right? 

I’ve dabbled with Linux for many years, but infrequently, and it seems I have 
to learn the same things over. This is also my first time with CentOS.

Thank you all for your contributions, I really appreciate this kind of 
hand-holding!

Simon


> On May 15, 2020, at 6:13 AM, Todd Baker  wrote:
> 
> Dear Simon,
> 
> Let me answer your root question.  There is a user root in the Linux system. 
> There is also a user root in the MySQL system.
> The user root is considered SuperUser and by default has all privileges (in 
> both systems). 
> 
> They are however two separate entities in that one does not have to be logged 
> into the system's root user to log into the database as root
> (Mysql does not check to see what user in Linux you are).
> 
> Now - the mysql command has parameters.  The -u and then a user name is which 
> user you would like to use.  So, when you
> entered "mysql -u root", it attempts to log you into the Mysql server as the 
> user root. You did not include 
> the -p parameter, so it will not prompt you for a password.
> 
> So - when you did the echo command - you were basically logging into Mysql as 
> root, and changing the user root password to "mylousypassword".
> Previous to issuing that echo command - root had NO password.
> 
> From that moment on you will have to provide your password when logging in as 
> root.
> 
> When you issued the echo command again, you did not provide a password,  
> so it did not let you log into the root user.
> 
> To log into root from now on - you will have to say
> mysql -u root -p
> 
> and  provide a password when prompted. 
> 
> If you leave off -p it assumes the user you are trying to log into has no 
> password
> thus the message (using password:NO).
>  
> Hope that helps.
> 
> Todd Baker
> Radio Free AsiaWashington D.C.
> From: "Simon Frech" 
> To: "Mike Carroll" 
> Cc: "User discussion about the Rivendell Radio Automation System" 
> 
> Sent: Thursday, May 14, 2020 6:58:04 PM
> Subject: Re: [RDD] last steps of Rivendell 3 install
> 
> Interesting, looks like the Mac on which I write this email changes the 
> straight single quote to a curly one in this font. I just realized this as I 
> entered it again here. So this was not likely the problem. 
> 
> So I opened up a terminal but neglected to do “su -“ and was therefore logged 
> in as rd. I entered 
> echo "SET PASSWORD FOR root@localhost = PASSWORD('mylousypassword');" | mysql 
> -u root
> and I received command prompt indicating the command was successful.
> 
> But am I not supposed to be root to execute this command? I changed to root, 
> entered the same command, now I get 
> ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using 
> password: NO)
> 
> Thanks
> 
> On May 14, 2020, at 1:46 PM, Mike Carroll  <mailto:druidl...@gmail.com>> wrote:
> 
> Verify your quotes are correct.  In the command you pasted, the single quote 
> in front of the password phrase is a smart/curly quote, not a single quote 
> like the one after the password phrase.
> 
> The command shell thinks you are entering a long string that needs more than 
> one line, and is prompting you to enter more text.  
> 
> To get out of the prompt, press Control-C.  Or close the window.  Both will 
> work .
> 
> On Thu, May 14, 2020 at 1:18 PM Simon Frech  <mailto:si...@kmud.org>> wrote:
> I finally managed to install CentOS and Rivendell 3 according to the 
> instructions at 
> http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
>  
> <http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html>
> It looks good, very familiar, I haven’t yet got to the point of actually 
> using it or setting up beyond installation.
> 
> I named the host simonserver, so in the terminal I'm logged in as 
> root@simonserver.
> 
> The last instruction in Final Steps is baffling to me.
> 4. Set the MariaDB administrator password with the following command 
> (substitute your password for pwd):
> echo "SET PASSWORD FOR root@localhost = PASSWORD('pwd');" | mysql -u root
> 
> I entered echo "SET PASSWORD FOR root@simonserver = PASSWO

Re: [RDD] last steps of Rivendell 3 install

[Todd Baker]

Dear Simon, 

Let me answer your root question. There is a user root in the Linux system. 
There is also a user root in the MySQL system. 
The user root is considered SuperUser and by default has all privileges (in 
both systems). 

They are however two separate entities in that one does not have to be logged 
into the system's root user to log into the database as root 
(Mysql does not check to see what user in Linux you are). 

Now - the mysql command has parameters. The -u and then a user name is which 
user you would like to use. So, when you 
entered "mysql -u root", it attempts to log you into the Mysql server as the 
user root. You did not include 
the -p parameter, so it will not prompt you for a password. 

So - when you did the echo command - you were basically logging into Mysql as 
root, and changing the user root password to "mylousypassword". 
Previous to issuing that echo command - root had NO password. 

>From that moment on you will have to provide your password when logging in as 
>root. 

When you issued the echo command again, you did not provide a password, 
so it did not let you log into the root user. 

To log into root from now on - you will have to say 
mysql -u root -p 

and provide a password when prompted. 

If you leave off -p it assumes the user you are trying to log into has no 
password 
thus the message (using password:NO). 
Hope that helps. 

Todd Baker 
Radio Free Asia Washington D.C. 

From: "Simon Frech"  
To: "Mike Carroll"  
Cc: "User discussion about the Rivendell Radio Automation System" 
 
Sent: Thursday, May 14, 2020 6:58:04 PM 
Subject: Re: [RDD] last steps of Rivendell 3 install 

Interesting, looks like the Mac on which I write this email changes the 
straight single quote to a curly one in this font. I just realized this as I 
entered it again here. So this was not likely the problem. 

So I opened up a terminal but neglected to do “su -“ and was therefore logged 
in as rd. I entered 
echo "SET PASSWORD FOR root@localhost = PASSWORD('mylousypassword');" | mysql 
-u root 
and I received command prompt indicating the command was successful. 

But am I not supposed to be root to execute this command? I changed to root, 
entered the same command, now I get 
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: 
NO) 

Thanks 




On May 14, 2020, at 1:46 PM, Mike Carroll < [ mailto:druidl...@gmail.com | 
druidl...@gmail.com ] > wrote: 

Verify your quotes are correct. In the command you pasted, the single quote in 
front of the password phrase is a smart/curly quote, not a single quote like 
the one after the password phrase. 

The command shell thinks you are entering a long string that needs more than 
one line, and is prompting you to enter more text. 

To get out of the prompt, press Control-C. Or close the window. Both will work 
. 

On Thu, May 14, 2020 at 1:18 PM Simon Frech < [ mailto:si...@kmud.org | 
si...@kmud.org ] > wrote: 

BQ_BEGIN

I finally managed to install CentOS and Rivendell 3 according to the 
instructions at [ 
http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
 | 
http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
 ] 
It looks good, very familiar, I haven’t yet got to the point of actually using 
it or setting up beyond installation. 

I named the host simonserver, so in the terminal I'm logged in as 
root@simonserver. 

The last instruction in Final Steps is baffling to me. 
4. Set the MariaDB administrator password with the following command 
(substitute your password for pwd ): 


echo "SET PASSWORD FOR root@localhost = PASSWORD(' pwd ');" | mysql -u root 
I entered echo "SET PASSWORD FOR root@simonserver = PASSWORD(‘ k258bq ');" | 
mysql -u root 
but now the Terminal just displays the > below my entry. I must have 
misunderstood. 

What am I doing wrong? 

The instructions are really good, but I’m misreading something. 

Thanks, 

Simon 

___ 
Rivendell-dev mailing list 
[ mailto:Rivendell-dev@lists.rivendellaudio.org | 
Rivendell-dev@lists.rivendellaudio.org ] 
[ http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev | 
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ] 




BQ_END



___ 
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

Re: [RDD] last steps of Rivendell 3 install

[Mike Cox]

Hi.Mike.
You're logging into Mysql as root "mysql -u root" so that means it is run as 
root.

Mike

Mike Cox
Managing Director
The Rosetta Group Ltd

Email: mike@rosetta.group
Website: www.rosetta.group<http://www.rosetta.group>
Phone: 01983 229 229



Have a look at our new cloud phone system at 
www.rosettatelecom.com<http://www.rosettatelecom.com>
See our payment options and pay online by clicking here Pay online


From: rivendell-dev-boun...@lists.rivendellaudio.org 
 on behalf of Simon Frech 

Sent: Thursday, May 14, 2020 11:58:04 PM
To: Mike Carroll 
Cc: Rivendell-dev mailing list 
Subject: Re: [RDD] last steps of Rivendell 3 install

Interesting, looks like the Mac on which I write this email changes the 
straight single quote to a curly one in this font. I just realized this as I 
entered it again here. So this was not likely the problem.

So I opened up a terminal but neglected to do “su -“ and was therefore logged 
in as rd. I entered
echo "SET PASSWORD FOR root@localhost = PASSWORD('mylousypassword');" | mysql 
-u root
and I received command prompt indicating the command was successful.

But am I not supposed to be root to execute this command? I changed to root, 
entered the same command, now I get
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: 
NO)

Thanks

On May 14, 2020, at 1:46 PM, Mike Carroll 
mailto:druidl...@gmail.com>> wrote:

Verify your quotes are correct.  In the command you pasted, the single quote in 
front of the password phrase is a smart/curly quote, not a single quote like 
the one after the password phrase.

The command shell thinks you are entering a long string that needs more than 
one line, and is prompting you to enter more text.

To get out of the prompt, press Control-C.  Or close the window.  Both will 
work .

On Thu, May 14, 2020 at 1:18 PM Simon Frech 
mailto:si...@kmud.org>> wrote:
I finally managed to install CentOS and Rivendell 3 according to the 
instructions at 
http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
It looks good, very familiar, I haven’t yet got to the point of actually using 
it or setting up beyond installation.

I named the host simonserver, so in the terminal I'm logged in as 
root@simonserver.

The last instruction in Final Steps is baffling to me.
4. Set the MariaDB administrator password with the following command 
(substitute your password for pwd):

echo "SET PASSWORD FOR root@localhost = PASSWORD('pwd');" | mysql -u root

I entered echo "SET PASSWORD FOR root@simonserver = PASSWORD(‘k258bq');" | 
mysql -u root
but now the Terminal just displays the > below my entry. I must have 
misunderstood.

What am I doing wrong?

The instructions are really good, but I’m misreading something.

Thanks,

Simon

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org<mailto: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

Re: [RDD] last steps of Rivendell 3 install

[Simon Frech]

Interesting, looks like the Mac on which I write this email changes the 
straight single quote to a curly one in this font. I just realized this as I 
entered it again here. So this was not likely the problem. 

So I opened up a terminal but neglected to do “su -“ and was therefore logged 
in as rd. I entered 
echo "SET PASSWORD FOR root@localhost = PASSWORD('mylousypassword');" | mysql 
-u root
and I received command prompt indicating the command was successful.

But am I not supposed to be root to execute this command? I changed to root, 
entered the same command, now I get 
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: 
NO)

Thanks

> On May 14, 2020, at 1:46 PM, Mike Carroll  wrote:
> 
> Verify your quotes are correct.  In the command you pasted, the single quote 
> in front of the password phrase is a smart/curly quote, not a single quote 
> like the one after the password phrase.
> 
> The command shell thinks you are entering a long string that needs more than 
> one line, and is prompting you to enter more text.  
> 
> To get out of the prompt, press Control-C.  Or close the window.  Both will 
> work .
> 
> On Thu, May 14, 2020 at 1:18 PM Simon Frech  > wrote:
> I finally managed to install CentOS and Rivendell 3 according to the 
> instructions at 
> http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
>  
> 
> It looks good, very familiar, I haven’t yet got to the point of actually 
> using it or setting up beyond installation.
> 
> I named the host simonserver, so in the terminal I'm logged in as 
> root@simonserver.
> 
> The last instruction in Final Steps is baffling to me.
> 4. Set the MariaDB administrator password with the following command 
> (substitute your password for pwd):
> echo "SET PASSWORD FOR root@localhost = PASSWORD('pwd');" | mysql -u root
> 
> I entered echo "SET PASSWORD FOR root@simonserver = PASSWORD(‘k258bq');" | 
> mysql -u root
> but now the Terminal just displays the > below my entry. I must have 
> misunderstood.
> 
> What am I doing wrong? 
> 
> The instructions are really good, but I’m misreading something.
> 
> Thanks,
> 
> Simon
> 
> ___
> 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

Re: [RDD] last steps of Rivendell 3 install

[drew Roberts]

You might want to leave:


*root@localhost*
as is in that line or at least do it twice, once with your adjustment and
once like I suggest. Your box should always be localhost besides whatever
else it is... (In general terms, not in Riv terms.) (That may be ignorant
advice.)

all the best,

drew

On Thu, May 14, 2020 at 4:18 PM Simon Frech  wrote:

> I finally managed to install CentOS and Rivendell 3 according to the
> instructions at
> http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
> It looks good, very familiar, I haven’t yet got to the point of actually
> using it or setting up beyond installation.
>
> I named the host simonserver, so in the terminal I'm logged in as
> root@simonserver.
>
> The last instruction in Final Steps is baffling to me.
> 4. Set the MariaDB administrator password with the following command
> (substitute your password for *pwd*):
>
> *echo "SET PASSWORD FOR root@localhost = PASSWORD('pwd');" | mysql -u root*
> I entered *echo "SET PASSWORD FOR root@simonserver = PASSWORD(‘k258bq');"
> | mysql -u root*
> but now the Terminal just displays the > below my entry. I must have
> misunderstood.
>
> What am I doing wrong?
>
> The instructions are really good, but I’m misreading something.
>
> Thanks,
>
> Simon
>
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>


-- 
Enjoy the *Paradise Island Cam* playing
*Bahamian Or Nuttin* - https://www.paradiseislandcam.com/
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] last steps of Rivendell 3 install

[Mike Carroll]

Verify your quotes are correct.  In the command you pasted, the single
quote in front of the password phrase is a smart/curly quote, not a single
quote like the one after the password phrase.

The command shell thinks you are entering a long string that needs more
than one line, and is prompting you to enter more text.

To get out of the prompt, press Control-C.  Or close the window.  Both will
work .

On Thu, May 14, 2020 at 1:18 PM Simon Frech  wrote:

> I finally managed to install CentOS and Rivendell 3 according to the
> instructions at
> http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
> It looks good, very familiar, I haven’t yet got to the point of actually
> using it or setting up beyond installation.
>
> I named the host simonserver, so in the terminal I'm logged in as
> root@simonserver.
>
> The last instruction in Final Steps is baffling to me.
> 4. Set the MariaDB administrator password with the following command
> (substitute your password for *pwd*):
>
> *echo "SET PASSWORD FOR root@localhost = PASSWORD('pwd');" | mysql -u root*
> I entered *echo "SET PASSWORD FOR root@simonserver = PASSWORD(‘k258bq');"
> | mysql -u root*
> but now the Terminal just displays the > below my entry. I must have
> misunderstood.
>
> What am I doing wrong?
>
> The instructions are really good, but I’m misreading something.
>
> Thanks,
>
> Simon
>
> ___
> 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

[RDD] last steps of Rivendell 3 install

[Simon Frech]

I finally managed to install CentOS and Rivendell 3 according to the 
instructions at 
http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html
 

It looks good, very familiar, I haven’t yet got to the point of actually using 
it or setting up beyond installation.

I named the host simonserver, so in the terminal I'm logged in as 
root@simonserver.

The last instruction in Final Steps is baffling to me.
4. Set the MariaDB administrator password with the following command 
(substitute your password for pwd):
echo "SET PASSWORD FOR root@localhost = PASSWORD('pwd');" | mysql -u root

I entered echo "SET PASSWORD FOR root@simonserver = PASSWORD(‘k258bq');" | 
mysql -u root
but now the Terminal just displays the > below my entry. I must have 
misunderstood.

What am I doing wrong? 

The instructions are really good, but I’m misreading something.

Thanks,

Simon

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev