Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 22nd July 2009, 20:48
wabz wabz is offline
Member
 
Join Date: Jul 2009
Posts: 84
Thanks: 4
Thanked 0 Times in 0 Posts
Default Unable to connect to mysql server

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
Reply With Quote
Sponsored Links
  #2  
Old 23rd July 2009, 10:07
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Please post the output of:

netstat -tap

Quote:
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.....
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 23rd July 2009, 12:16
wabz wabz is offline
Member
 
Join Date: Jul 2009
Posts: 84
Thanks: 4
Thanked 0 Times in 0 Posts
Default netstat -tap output

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.

Last edited by wabz; 23rd July 2009 at 13:13.
Reply With Quote
  #4  
Old 23rd July 2009, 12:33
dzudzu dzudzu is offline
Member
 
Join Date: Jun 2009
Location: Serbia
Posts: 64
Thanks: 1
Thanked 6 Times in 6 Posts
Default

i think your mysql server isn't started at all
__________________
EonTek.rs - System Engineering

dzudzu
Reply With Quote
  #5  
Old 23rd July 2009, 13:52
wabz wabz is offline
Member
 
Join Date: Jul 2009
Posts: 84
Thanks: 4
Thanked 0 Times in 0 Posts
Default see the new output

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:~ #
Reply With Quote
  #6  
Old 23rd July 2009, 14:09
dzudzu dzudzu is offline
Member
 
Join Date: Jun 2009
Location: Serbia
Posts: 64
Thanks: 1
Thanked 6 Times in 6 Posts
Default

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
__________________
EonTek.rs - System Engineering

dzudzu
Reply With Quote
  #7  
Old 23rd July 2009, 14:43
wabz wabz is offline
Member
 
Join Date: Jul 2009
Posts: 84
Thanks: 4
Thanked 0 Times in 0 Posts
Default worked

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
Reply With Quote
  #8  
Old 23rd July 2009, 14:52
dzudzu dzudzu is offline
Member
 
Join Date: Jun 2009
Location: Serbia
Posts: 64
Thanks: 1
Thanked 6 Times in 6 Posts
Default

look here

this post
__________________
EonTek.rs - System Engineering

dzudzu
Reply With Quote
  #9  
Old 23rd July 2009, 15:09
wabz wabz is offline
Member
 
Join Date: Jul 2009
Posts: 84
Thanks: 4
Thanked 0 Times in 0 Posts
Default How do i use phpmyadmin

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

Last edited by wabz; 23rd July 2009 at 15:13.
Reply With Quote
  #10  
Old 23rd July 2009, 15:19
dzudzu dzudzu is offline
Member
 
Join Date: Jun 2009
Location: Serbia
Posts: 64
Thanks: 1
Thanked 6 Times in 6 Posts
 
Default

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
__________________
EonTek.rs - System Engineering

dzudzu
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
User unknown in relay recipient table Taxick Installation/Configuration 12 9th April 2013 12:31
php Apps email not going through palkat General 8 21st September 2011 05:35
Connection dropped by IMAP server gublym Server Operation 5 23rd January 2009 09:47
Rejecting outbound mail tristanlee85 General 11 20th May 2007 17:04
error 2003: Can't connect to MySQL server jorge Installation/Configuration 1 2nd March 2006 06:25


All times are GMT +2. The time now is 08:02.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.