Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st September 2007, 00:14
giganet giganet is offline
Senior Member
 
Join Date: Aug 2007
Location: California
Posts: 243
Thanks: 116
Thanked 1 Time in 1 Post
Send a message via AIM to giganet
Arrow System Notifies Admin of mysqld Not Running

In the last few days I have seen the following notifies sent by the server:
Code:
Warning: service mysqld not running (server: giganetwireless.com)!

Message generated at September 20, 2007, 14:30.
This message is received every half hour by the admin email account.
After receiving the notifiy on a few ocassions I have run '/etc/init.d/mysql status' which returns
Quote:
mailman@giganetwireless:~$ /etc/init.d/mysql status
Password:
/usr/bin/mysqladmin Ver 8.41 Distrib 5.0.22, for pc-linux-gnu on i486
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 5.0.22-Debian_0ubuntu6.06.3-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 day 6 min 48 sec

Threads: 1 Questions: 7430 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 64 Queries per second avg: 0.086
All mysql related functions appear to be functioning during these notifies.

Thank you for the help...

Regards
Reply With Quote
Sponsored Links
  #2  
Old 21st September 2007, 08:09
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,457
Thanks: 813
Thanked 5,230 Times in 4,099 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
The Following User Says Thank You to till For This Useful Post:
giganet (22nd September 2007)
  #3  
Old 21st September 2007, 19:31
giganet giganet is offline
Senior Member
 
Join Date: Aug 2007
Location: California
Posts: 243
Thanks: 116
Thanked 1 Time in 1 Post
Send a message via AIM to giganet
Arrow

Thank you Till

The output of 'netstat -tap | grep mysql'
Quote:
After roughly a 20 second pause after initiating the command the system returns nothing at all then returns to the ready prompt
Regards
Reply With Quote
  #4  
Old 22nd September 2007, 12:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,723 Times in 2,563 Posts
Default

Can you log in to MySQL like this?

Code:
mysql -u root -p
__________________
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
The Following User Says Thank You to falko For This Useful Post:
giganet (22nd September 2007)
  #5  
Old 22nd September 2007, 22:09
giganet giganet is offline
Senior Member
 
Join Date: Aug 2007
Location: California
Posts: 243
Thanks: 116
Thanked 1 Time in 1 Post
Send a message via AIM to giganet
Arrow

Thank you Falko

Yes I am able to log into mysql.
No errors or anything at login...


Regards
Reply With Quote
  #6  
Old 23rd September 2007, 19:21
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,723 Times in 2,563 Posts
Default

And do
Code:
mysql -h 127.0.0.1 -u root -p
and
Code:
mysql -h localhost -u root -p
work as well? What's in /etc/mysql/my.cnf and /etc/hosts?
__________________
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
The Following User Says Thank You to falko For This Useful Post:
giganet (25th September 2007)
  #7  
Old 24th September 2007, 05:26
andresb andresb is offline
Junior Member
 
Join Date: Jan 2007
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Default Seems like socket connection

This is my guess, I've been receiving these messages since I retouched my.cnf.

If you set skip-networking in my.cnf the service checker assumes the mysql server is down, even if it's working.
Reply With Quote
The Following User Says Thank You to andresb For This Useful Post:
giganet (25th September 2007)
  #8  
Old 24th September 2007, 09:43
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,457
Thanks: 813
Thanked 5,230 Times in 4,099 Posts
Default

Quote:
Originally Posted by andresb
This is my guess, I've been receiving these messages since I retouched my.cnf.

If you set skip-networking in my.cnf the service checker assumes the mysql server is down, even if it's working.
Tha's correct. Networking should be enabled for ISPConfig. If you want to prevent exernal access, you should use:

Code:
bind-address           = 127.0.0.1
instead.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
giganet (25th September 2007)
  #9  
Old 25th September 2007, 06:29
giganet giganet is offline
Senior Member
 
Join Date: Aug 2007
Location: California
Posts: 243
Thanks: 116
Thanked 1 Time in 1 Post
Send a message via AIM to giganet
Wink

Thank you Falko, Andre & Till...

I am able to log when running 'mysql -h localhost -u root -p'

I just edited '/etc/mysql/my.cnf' skip-networking enabled and the bind address uncommented.
After restarting mysql I am still unable to log onto mysql using 'mysql -h 127.0.0.1 -u root -p'.
Will wait to see if the system emails warns cease.

'my.cnf contents'
Code:
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.22-Debian_0ubuntu6.06.3-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 3 min 45 sec

Threads: 1  Questions: 217  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 64  Queries per second avg: 0.964
mailman@giganetwireless:~$ sudo vi /etc/mysql/my.cnf
log_bin                 = /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M

#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1


#
# * IMPORTANT: Additional settings that can override those from this file!
#
!includedir /etc/mysql/conf.d/
Thank you all very much for your time and help.

Regards
Reply With Quote
  #10  
Old 25th September 2007, 09:17
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,457
Thanks: 813
Thanked 5,230 Times in 4,099 Posts
 
Default

Quote:
I am able to log when running 'mysql -h localhost -u root -p'
If you can login like this, then everything should be fine now.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
giganet (25th September 2007)
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
Changing IP on running system jlaughy Installation/Configuration 8 3rd April 2009 12:35
services not running - mysqld fbnewtz Installation/Configuration 23 28th March 2007 15:48
Rename folder -> create new folder equals contents of old folder BlueStream General 20 15th December 2006 03:32
:D All recieved mails goes to the system admin user ??help Mounir Installation/Configuration 8 31st July 2006 12:22


All times are GMT +2. The time now is 22:23.


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