Help My Server

Discussion in 'Installation/Configuration' started by szise, Jun 6, 2008.

  1. szise

    szise New Member

    Hello all, this is my first post ,i'm a newbie in linux, my problem is that i have a dedicated server, after restarting the server i have this problem when i try to start mysql :

    ..failed or took more than 6s.

    Please take a look at the syslog.

    /usr/bin/mysqladmin: connect to server at 'localhost' failed

    error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

    Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!


    Can't make it work, is good to know that i have 2 IPs for my server

    The syslog sais, something like this :
    Also in etc/mysql/my.cnf i have this :

    If i change the user to root :

    user = root , the mysql server starts but second IP still doesn't work properly and the domain isn't working too

    Can anyone teach me what to do ? hope to understand , thanks very very much
     
    Last edited: Jun 6, 2008
  2. szise

    szise New Member

    anyone ? even 1 opinion ?
     
  3. falko

    falko Super Moderator ISPConfig Developer

    Which distribution are you using?

    Please switch back to user = mysql in your my.cnf.

    What are the outputs of
    Code:
    ls -la /var/run/mysqld/mysqld.sock
    and
    Code:
    netstat -tap
    ?
     
  4. szise

    szise New Member

    CentOs 5 outside but the chroot where i am now is Debian Sarge :


    first question :


    second :



     
  5. szise

    szise New Member

    i see this now in syslog, many many times :

    Maybe this will be interesting, the DNS Server is Power DNS , when i type :

    receive :

     
  6. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    ls -la /var/run?
     
  7. szise

    szise New Member

    this is the output:

     
  8. falko

    falko Super Moderator ISPConfig Developer

    Can you uncomment these two lines in my.cnf and restart MySQL?

    Code:
    pid-file = /var/run/mysqld/mysqld.pid
    socket = /var/run/mysqld/mysqld.sock
     
  9. szise

    szise New Member

    i paid someone and solved the problem for me , thanks anyway , good tutorials here
     

Share This Page