MySQL is not running!!

Discussion in 'Installation/Configuration' started by iceberg, Aug 25, 2005.

  1. iceberg

    iceberg New Member

    hi all, during installation i got this error

    Code:
    ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.
    
    i am running MySQL server...

    Code:
    # service mysqld status
    mysqld (pid 31869) is running...
    
    and here...

    Code:
    # mysqladmin ping
    mysqld is alive
    
    So, any suggestions??
    Thanks for reading
     
  2. falko

    falko Super Moderator

    Do you see MySQL when you run
    Code:
    netstat -tap
    ? MySQL has to run over TCP, not on local Unix sockets. To change that, edit /etc/my.cnf, comment out skip-networking and restart MySQL.
     
  3. iceberg

    iceberg New Member

    i can't skip-networking in /etc/my.cnf. here is /etc/my.cnf

    Code:
    more /etc/my.cnf
    
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    # Default to using old password format for compatibility with old and
    # shorter password hash.
    # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html
    old_passwords=1
    
    [mysql.server]
    user=mysql
    basedir=/var/lib
    
    [mysqld_safe]
    err-log=/var/log/mysqld/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
     
  4. falko

    falko Super Moderator

    Can you post the output of
    Code:
    netstat -tap
    here?

    Depending on your distribution there might be further configuration files under /etc/sysconfig or /etc/default.
     
  5. iceberg

    iceberg New Member

    Thanks, i figured it out
     
  6. Avatar

    Avatar New Member

    Since I upgraded ISPConfig from 2.1.0 to 2.1.1 today, I get an error by eMail that mysql is not running, every half an hour. But mysql IS running:

    Code:
    # netstat -tap
    tcp        0      0 server.domain:mysql  *:*                     LISTEN     2446/mysqld
    
    I also don't have an "skip-networking" option in my my.cnf, but the new way of binding to localhost isn't active, too:

    Code:
    # Instead of skip-networking the default is now to listen only on
    # localhost which is more compatible and is not less secure.
    bind-address            = 123.456.789.10
    
    The my.cnf seems to be touched during the installation, but I cannot see any changes. I already rebootet the server. No results, I still get the mail.

    It's a debian 3.1 distribution.

    What can I do? :(
    --
    Best regards...
    Ace
     
  7. falko

    falko Super Moderator

    MySQL is bound to listen only on 123.456.789.10 whereas ISPConfig tries to connect to MySQL on 127.0.0.1 to see if it's still running. Either change the IP address to 127.0.0.1 in /etc/mysql/my.cnf, or comment out the bind-address line. In both cases, restart MySQL afterwards.

    No, ISPConfig doesn't touch /etc/mysql/my.cnf. You can have a look at the ISPConfig sources.
     
  8. Avatar

    Avatar New Member

    Hi!

    Thanx! Worked. :)

    I believe you. ;) But maybe then he just didn't complain before. :D
    --
    Best regards...
    Ace
     
  9. bassplayer

    bassplayer New Member

    mysql not runing during install

    I use fresh install Redhat 9.0
    during install it says MySQL not running,
    my> netstat -tap
    tcp 0 0 *:mysql *:* LISTEN 2997/

    my /etc/mycnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    BTW, i dont see php-mysql on my instalation, i cannot find in redhat9 disc,
    is it the problem.
    thanks in advance.
     
  10. falko

    falko Super Moderator

    Is there a special reason why you're using such an old distribution? I suggest you try Fedora 8 or CentOS 5.1 instead.
     
  11. bassplayer

    bassplayer New Member

    Hi Falko,
    I use Old Computer, PIII 500Mhz, 192Mhz Memory, 20GB Hdd
    thats the reason I use RedHat9, I'm Thinking to use CentOS 4.2
    But I'm Affraid the Computer didnot met the requirement,
    Please advice,
    Thanks for the quick reply.
    Regards,
     
  12. falko

    falko Super Moderator

    If you want to use it as a server, I suggest that you try Debian Etch. IT should work well on your hardware. :)
     

Share This Page