Navigation

kaygroth · #1 29th March 2006, 18:12

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

falko · #2 29th March 2006, 19:48

What's the exact error message?
Please post the output of

Code:

netstat -tap

and

Code:

ps aux|grep -i mysql

kaygroth · #3 30th March 2006, 12:37

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

falko · #4 30th March 2006, 15:14

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

wdwm · #5 2nd April 2006, 11:20

[QUOTE=falko]You must disable --skip-networking for MySQL. Edit /etc/sysconfig/mysqld and remove --skip-networking from the Variable MYSQLD_OPTIONS:

Code: