Unable to connect to mysql server

[wabz]

I am using till's Perfect server setup on suse 11.1 and i get the following error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Till can u update the links to some of the rpm from open suse resipotory. some say errors file not found

[till]

Please post the output of:

netstat -tap

Till can u update the links to some of the rpm from open suse resipotory. some say errors file not found

SuSE is constantly changing the names, I've updated them already a few times. I will lookup the names again and update them.....

[wabz]

login as: root
Using keyboard-interactive authentication.
Password:
Last login: Thu Jul 23 12:08:00 2009
Have a lot of fun...
mail:~ # netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost:vid *:* LISTEN 3561/famd
tcp 0 0 localhost:10024 *:* LISTEN 3590/amavisd (maste
tcp 0 0 *:sunrpc *:* LISTEN 2731/rpcbind
tcp 0 0 mail:domain *:* LISTEN 3506/named
tcp 0 0 mail:domain *:* LISTEN 3506/named
tcp 0 0 mail.uwasnet.org:domain *:* LISTEN 3506/named
tcp 0 0 localhost:domain *:* LISTEN 3506/named
tcp 0 0 *:ftp *:* LISTEN 3453/pure-ftpd (SER
tcp 0 0 *:ssh *:* LISTEN 3476/sshd
tcp 0 0 localhost:ipp *:* LISTEN 3559/cupsd
tcp 0 0 *:smtp *:* LISTEN 3834/master
tcp 0 0 localhost:953 *:* LISTEN 3506/named
tcp 0 0 mail:ssh 192.168.1.6:solera-lpn ESTABLISHED 4457/0
tcp 0 0 *:imaps *:* LISTEN 2829/couriertcpd
tcp 0 0 *op3s *:* LISTEN 2867/couriertcpd
tcp 0 0 *op3 *:* LISTEN 2848/couriertcpd
tcp 0 0 *:imap *:* LISTEN 2809/couriertcpd
tcp 0 0 *:sunrpc *:* LISTEN 2731/rpcbind
tcp 0 0 *:www-http *:* LISTEN 3768/httpd2-prefork
tcp 0 0 *:domain *:* LISTEN 3506/named
tcp 0 0 *:ftp *:* LISTEN 3453/pure-ftpd (SER
tcp 0 0 *:ssh *:* LISTEN 3476/sshd
tcp 0 0 localhost:ipp *:* LISTEN 3559/cupsd
tcp 0 0 *:smtp *:* LISTEN 3834/master
tcp 0 0 localhost:953 *:* LISTEN 3506/named
mail:~ #

Till can i give you the login information for the server and you help me have a perfect server running ispconfig. I have a deadline of next week monday to have the organisation website, portal and mail running. please help me.

[dzudzu]

i think your mysql server isn't started at all

[wabz]

login as: root
Using keyboard-interactive authentication.
Password:
Last login: Thu Jul 23 12:23:53 2009 from 192.168.1.6
Have a lot of fun...
mail:~ # yast2
mail:~ # /etc/init.d/mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
done
mail:~ # netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost:10024 *:* LISTEN 3597/amavisd (maste
tcp 0 0 localhost:wpgs *:* LISTEN 3572/famd
tcp 0 0 *:sunrpc *:* LISTEN 2721/rpcbind
tcp 0 0 mail:domain *:* LISTEN 3502/named
tcp 0 0 mail:domain *:* LISTEN 3502/named
tcp 0 0 mail.uwasnet.org:domain *:* LISTEN 3502/named
tcp 0 0 localhost:domain *:* LISTEN 3502/named
tcp 0 0 *:ftp *:* LISTEN 3295/pure-ftpd (SER
tcp 0 0 *:ssh *:* LISTEN 3286/sshd
tcp 0 0 localhost:ipp *:* LISTEN 3571/cupsd
tcp 0 0 *:smtp *:* LISTEN 3833/master
tcp 0 0 localhost:953 *:* LISTEN 3502/named
tcp 0 0 mail:ssh 192.168.1.6:nmsserver ESTABLISHED 4455/0
tcp 0 0 mail:smtp web46402.mail.sp1:40258 ESTABLISHED 4421/smtpd
tcp 0 0 *:imaps *:* LISTEN 2819/couriertcpd
tcp 0 0 *op3s *:* LISTEN 2856/couriertcpd
tcp 0 0 *op3 *:* LISTEN 2837/couriertcpd
tcp 0 0 *:imap *:* LISTEN 2800/couriertcpd
tcp 0 0 *:sunrpc *:* LISTEN 2721/rpcbind
tcp 0 0 *:www-http *:* LISTEN 3767/httpd2-prefork
tcp 0 0 *:domain *:* LISTEN 3502/named
tcp 0 0 *:ftp *:* LISTEN 3295/pure-ftpd (SER
tcp 0 0 *:ssh *:* LISTEN 3286/sshd
tcp 0 0 *:smtp *:* LISTEN 3833/master
tcp 0 0 localhost:953 *:* LISTEN 3502/named
mail:~ #

[dzudzu]

try these nad post outputs:

/usr/sbin/mysqld

mysqld_safe &
/usr/bin/mysqld_safe
/usr/bin/mysqld_safe --user=mysql &

after that check if there are mysql processes that are hung

ps -ef | grep mysql

and kill them if there are,

try again /etc/init.d/mysql start

and post

tail -50 /var/log/messages

[wabz]

i have just reinstalled the mysql....now i have another problem....in the process of changing my password after login into ispconfig 3.0.1 a co-worker typed in a password and he cant remember it or email used. is there a way apart from the password lost that we can recover the admin password...when logged into the suse 11.1 box

[dzudzu]

look here

this post

[wabz]

How do i use the phpmyadmin to do that? Then secondly is there a user manual for using ispconfig 3.0.1? I am new to all this stuff.....need to recover the admin password and have a website up in like 2hrs time....pls help me...coz it seems phpmyadmin doesnt work.....cant i just log into the mysql database and change....pls show me how and the table to change

[dzudzu]

you log in with phpmyadmin and then on the left side you select ispconfig db witch is by default dbispconfig after that you press SQL tab in the main window and then it says:

Run SQL query/queries on database dbispconfig:

and this is where you type next:

update sys_user set passwort = md5('newpassword') WHERE username = 'usernameyouchange';

in this case it's the admin so you set admin there

let me know what you done