Lost connection to MySQL server during query...

[skin]

I am on this step...

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

in the "The Perfect Setup - Fedora Core 5 (64-bit) - Page 4" install and configure.

I run the command and get this error...

mysqladmin: connect to server at 'mail.my-url.com' failed
error: 'Lost connection to MySQL server during query'
INIT: version 2.86 reloading

You have mail in /var/spool/mail/root
[root@mail named]#


Give a guy a hand, cuz I really am clueless at this point. Maybe it is obvious to one of you... Not me.

[falko]

Have a look here: http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com

[skin]

I should have said, when I am on this step...
Now check that networking is enabled. Run

netstat -tap

It should show a line like this:

tcp 0 0 *:mysql *:* LISTEN 2008/mysqld

I get...

tcp 0 0 *:mysql *:* LISTEN 2521/mysqld

Which is different then it says I should get. I do not understand why.


I have read through the ubuntu post and am trying to understand why or if I should do nothing on this step. From your post I believe that you are saying to not do anything with the
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
command.

So thinking that I should skip that step, I went on.
Now I am on...
Page 5
We must edit /usr/lib64/sasl2/smtpd.conf so that Postfix allows PLAIN and LOGIN logins. It should look like this:

vi /usr/lib64/sasl2/smtpd.conf

pwcheck_method: saslauthd
mech_list: plain login

I get "/usr/lib64/sasl2/smtpd.conf" E212: Can't open file for writing


PS... I am not installing this on a 64bit cpu box. Its just a regular old x86 IBM server. I downloaded the correct iso for sure.

[falko]

netstat -tap

It should show a line like this:

tcp 0 0 *:mysql *:* LISTEN 2008/mysqld

I get...

tcp 0 0 *:mysql *:* LISTEN 2521/mysqld

Which is different then it says I should get. I do not understand why.
You just have a different process ID (PID), that's ok. The output is fine...


I have read through the ubuntu post and am trying to understand why or if I should do nothing on this step. From your post I believe that you are saying to not do anything with the
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
command.

So thinking that I should skip that step, I went on.
Well, your MySQL server is listening on all IP addresses, so you should do this step, but of course, you must replace server1.example.com with your own hostname.

Now I am on...
Page 5
We must edit /usr/lib64/sasl2/smtpd.conf so that Postfix allows PLAIN and LOGIN logins. It should look like this:

vi /usr/lib64/sasl2/smtpd.conf

pwcheck_method: saslauthd
mech_list: plain login

I get "/usr/lib64/sasl2/smtpd.conf" E212: Can't open file for writing


PS... I am not installing this on a 64bit cpu box. Its just a regular old x86 IBM server. I downloaded the correct iso for sure.
If you are on a normal x86 system, then the file is /usr/lib/sasl2/smtpd.conf, not /usr/lib64/sasl2/smtpd.conf.

[skin]

You just have a different process ID (PID), that's ok. The output is fine...




Well, your MySQL server is listening on all IP addresses, so you should do this step, but of course, you must replace server1.example.com with your own hostname.


If you are on a normal x86 system, then the file is /usr/lib/sasl2/smtpd.conf, not /usr/lib64/sasl2/smtpd.conf.

Ok, I did not know that was the process id.

I have replaced server1.example.com with my hostname I think. How can I double check? What command would give me the hostname? *edit* I just entered "hostname" and it came up. So I will double check that.

I tried just the lib directory edited the file just fine.

Thanks for your help Falko!

[skin]

I typed...
mysqladmin -h server1.example.com -u root password yourrootsqlpassword

whereas server1.example.com = mserver.myurl.com
and...
yourrootsqlpassword = my root sql password

I get...
mysqladmin: connect to server at '****.*********-******.com' failed error: 'Lost connection to MySQL server during query'

Should I post my hostname? I really do not want to make myself a glutten for punishment.

[falko]

Skip this step for now. Later when you have phpMyAdmin installed you can check which other hostname you have in the mysql.users table and run the appropriate command to set a password.