Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th May 2006, 18:51
skin skin is offline
Junior Member
 
Join Date: May 2006
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Default 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.

Last edited by skin; 8th May 2006 at 19:32.
Reply With Quote
Sponsored Links
  #2  
Old 8th May 2006, 23:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Have a look here: http://www.howtoforge.com/forums/sho...r1.example.com
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 10th May 2006, 20:56
skin skin is offline
Junior Member
 
Join Date: May 2006
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.
Reply With Quote
  #4  
Old 10th May 2006, 23:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 11th May 2006, 16:07
skin skin is offline
Junior Member
 
Join Date: May 2006
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Default

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!

Last edited by skin; 11th May 2006 at 16:42.
Reply With Quote
  #6  
Old 11th May 2006, 16:13
skin skin is offline
Junior Member
 
Join Date: May 2006
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.

Last edited by skin; 11th May 2006 at 16:47.
Reply With Quote
  #7  
Old 11th May 2006, 18:05
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
 
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistic not working mzo Installation/Configuration 49 20th April 2011 12:19
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 20:49
Perfect Xen 3.0 setup for Debian gurneyzap HOWTO-Related Questions 4 26th March 2006 11:30
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 10:01
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 02:30


All times are GMT +2. The time now is 21:12.


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