HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Lost connection to MySQL server during query... (http://www.howtoforge.com/forums/showthread.php?t=4150)

skin 8th May 2006 18:51

Lost connection to MySQL server during query...
 
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 8th May 2006 23:56

Have a look here: http://www.howtoforge.com/forums/sho...r1.example.com

skin 10th May 2006 20:56

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 10th May 2006 23:48

Quote:

Originally Posted by skin
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...


Quote:

Originally Posted by skin
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.

Quote:

Originally Posted by skin
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 11th May 2006 16:07

Quote:

Originally Posted by falko
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 11th May 2006 16:13

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 11th May 2006 18:05

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.


All times are GMT +2. The time now is 06:39.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.