Lost connection to MySQL server during query...

Discussion in 'Installation/Configuration' started by skin, May 8, 2006.

  1. skin

    skin New Member

    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: May 8, 2006
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

  3. skin

    skin New Member

    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.
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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.
     
  5. skin

    skin New Member

    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: May 11, 2006
  6. skin

    skin New Member

    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: May 11, 2006
  7. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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.
     

Share This Page