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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th August 2006, 05:24
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default services not running - mysqld

I keep getting the following warning email:

Warning: service mysqld not running (server:


When I login to my server MySQL is running. I am running debian 3.1 I believe. The name of the file in /etc/init.d/ is mysql, not mysqld. However, whenever I do a ps -aux|grep mysqld I find three instances of MySQL running. Everything seems to be running just fine right now also.


Any ideas?
Reply With Quote
Sponsored Links
  #2  
Old 8th August 2006, 09:52
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,249 Times in 4,114 Posts
Default

please post the output of:

netstat -tap | grep mysql
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 10th August 2006, 02:13
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default output of netstat

Here is the output to the above command.


tcp 0 0 *:mysql *:* LISTEN 32098/mysqld

Thanks,

Fred
Reply With Quote
  #4  
Old 11th August 2006, 16:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,732 Times in 2,569 Posts
Default

Looks ok. What's in /etc/hosts? What's the output of
Code:
ps -aux|grep mysql
and
Code:
grep mysql /etc/services
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 11th August 2006, 18:47
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default Results of commands

Here is my /etc/hosts file:

127.0.0.1 localhost.localdomain localhost
1.1.1.1 sp2979a.myhostsdomain.com sp2979a
^ -- Of course this is my real IP.

# The following lines are desirable for IPv6 capable hosts
#::1 ip6-localhost ip6-loopback
#fe00::0 ip6-localnet
#ff00::0 ip6-mcastprefix
#ff02::1 ip6-allnodes
#ff02::2 ip6-allrouters
#ff02::3 ip6-allhosts


Output of ps -aux | grep mysql
root 32061 0.0 0.5 2740 1320 ? S Jul29 0:00 /bin/sh /usr/bin/ mysqld_safe
root 32097 0.0 0.5 2740 1324 ? S Jul29 0:00 /bin/sh /usr/bin/ mysqld_safe
mysql 32098 0.0 6.2 116916 16124 ? S Jul29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/ mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 32099 0.0 0.2 1776 548 ? S Jul29 0:00 logger -p daemon. err -t mysqld_safe -i -t mysqld
root 9217 0.0 0.2 1832 584 pts/3 R+ 12:46 0:00 grep mysql

Output of grep mysql /etc/services

mysql 3306/tcp
mysql 3306/udp


Thanks for the help.

Fred
Reply With Quote
  #6  
Old 12th August 2006, 18:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,732 Times in 2,569 Posts
Default

Looks ok, too.
Did you try and restart the server?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 16th August 2006, 03:13
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default Restart Server

Not yet, but I will. Can you give me an idea of where to look in code and I will see if I can spot the problem. You don't have to tell me exactly, I just don't know which file monitors the services.

Thanks,

Fred
Reply With Quote
  #8  
Old 16th August 2006, 08:48
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,249 Times in 4,114 Posts
Default

The file is:

/root/ispconfig/scripts/shell/check_services.php
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 25th November 2006, 11:55
Mikymike Mikymike is offline
Junior Member
 
Join Date: Nov 2006
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default

Exactly the same problem same mail message in root mailbox

Warning: service mysqld not running (server: server_name)!

Message generated at November 25, 2006, 11:30.

I'm runing latest ISPConfig on a Debian Sarge too with last MySQL5 and PHP5 from dotdeb stable source

But all is runing fine.
Reply With Quote
  #10  
Old 25th November 2006, 14:12
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,249 Times in 4,114 Posts
 
Default

Please make sure your mysql server listens on a TCP socket on 127.0.0.1 too.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Fedora 4 TPS mail problem Hagforce HOWTO-Related Questions 13 10th February 2010 18:23
My mysqld broke domino Server Operation 12 12th October 2008 05:56
MySQL is not running!! iceberg Installation/Configuration 11 3rd January 2008 15:10
ISP Services wouldn't restart any service, possibly Domain Host configuration issue. Kamran Shah Installation/Configuration 20 17th August 2006 17:33
pop3 SSL/TLS not running, smtp+imap TLS/SSL ok st2xo Installation/Configuration 2 2nd February 2006 20:29


All times are GMT +2. The time now is 21:59.


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