MySQL

Discussion in 'Installation/Configuration' started by kaygroth, Mar 29, 2006.

  1. kaygroth

    kaygroth New Member

    Im trying to install ISPConfig, but im stuck on MySQL, having never used it im at a loss what to do, when installling ISPConfig it tells me to start the DB but i have checked and MySQL is running ok, not sure if i have to create a DB for it to install or not, any help would be accepted with open arms

    oh and im running mandriva 2006 powerpack x64 btw
     
    Last edited: Mar 29, 2006
  2. falko

    falko Super Moderator ISPConfig Developer

    What's the exact error message?
    Please post the output of
    Code:
    netstat -tap
    and
    Code:
    ps aux|grep -i mysql
     
  3. kaygroth

    kaygroth New Member

    ok the error is
    ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.


    netstat -tapand

    (Not all processes could be identified, non-owned process info
    will not be shown, you would have to be root to see it all.)
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
    tcp 0 0 *:netbios-ssn *:* LISTEN -
    tcp 0 0 *:5900 *:* LISTEN -
    tcp 0 0 *:sunrpc *:* LISTEN -
    tcp 0 0 *:http *:* LISTEN -
    tcp 0 0 *:https *:* LISTEN -
    tcp 0 0 *:microsoft-ds *:* LISTEN -
    tcp 0 0 192.168.0.11:55017 imap.plus.net:imap ESTABLISHED 18100/kontactIYmwSa
    tcp 0 0 192.168.0.11:50896 216.239.59.104:http ESTABLISHED 18124/konqueroreju9
    tcp 0 0 192.168.0.11:50900 216.239.59.104:http TIME_WAIT -
    tcp 0 0 192.168.0.11:50902 216.239.59.104:http ESTABLISHED 18121/konquerorlfFd
    tcp 0 0 192.168.0.11:5900 host-80-194-98-133.st:32710 ESTABLISHED -
    tcp 0 0 192.168.0.11:42993 209.50.189.200:http TIME_WAIT -
    tcp 1 1 192.168.0.11:34419 www.howtoforge.com:http CLOSING -
    tcp 1 1 192.168.0.11:34417 www.howtoforge.com:http CLOSING -
    tcp 0 0 192.168.0.11:34413 www.howtoforge.com:http TIME_WAIT -
    tcp 0 0 192.168.0.11:34412 www.howtoforge.com:http TIME_WAIT -
    tcp 0 0 192.168.0.11:34411 www.howtoforge.com:http TIME_WAIT -
    tcp 0 0 192.168.0.11:34410 www.howtoforge.com:http TIME_WAIT -
    tcp 0 0 192.168.0.11:48481 84.53.134.200:http TIME_WAIT -
    tcp 0 0 192.168.0.11:39940 84.53.134.208:http TIME_WAIT -
    tcp 0 0 *:ssh *:* LISTEN


    ps aux|grep -i mysql

    root 18664 0.0 0.1 6740 1356 pts/0 S 12:37 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --skip-networking --pid-file=/var/run/mysqld/mysqld.pid
    mysql 18699 0.0 2.3 130176 23580 pts/0 Sl 12:37 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
     
    Last edited: Mar 30, 2006
  4. falko

    falko Super Moderator ISPConfig Developer

    You must disable --skip-networking for MySQL. Edit /etc/sysconfig/mysqld and remove --skip-networking from the Variable MYSQLD_OPTIONS:
    Code:
    MYSQLD_OPTIONS=""
    Then restart MySQL:
    Code:
    /etc/init.d/mysqld restart
    and try to install ISPConfig again.
    Also have a look at this tutorial: http://www.howtoforge.com/perfect_setup_mandriva_2006
     
  5. wdwm

    wdwm New Member

     
  6. wdwm

    wdwm New Member

    NM found emacs :D
     
  7. falko

    falko Super Moderator ISPConfig Developer

Share This Page