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 12th August 2010, 18:15
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 17 Times in 14 Posts
Default MySQL doesn't work after reboot

I'm using an OpenVZ container and every time that I reboot the server, MySQL stops working.

Now a simple /etc/init.d/mysql restart fixes it, but this is incredibly annoying.

When trying to acces MySQL after a reboot I get:

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

/var/run/mysqld doesn't exist until after I reboot the service.
Reply With Quote
Sponsored Links
  #2  
Old 13th August 2010, 01:52
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 17 Times in 14 Posts
Default

I'm baffled. I've tried:

1. Adding mysql to rc.d:

Code:
update-rc.d mysql defaults
update-rc.d: warning: /etc/init.d/mysql missing LSB information
update-rc.d: see <http://wiki.debian.org/LSBInitScripts>
 Adding system startup for /etc/init.d/mysql ...
   /etc/rc0.d/K20mysql -> ../init.d/mysql
   /etc/rc1.d/K20mysql -> ../init.d/mysql
   /etc/rc6.d/K20mysql -> ../init.d/mysql
   /etc/rc2.d/S20mysql -> ../init.d/mysql
   /etc/rc3.d/S20mysql -> ../init.d/mysql
   /etc/rc4.d/S20mysql -> ../init.d/mysql
   /etc/rc5.d/S20mysql -> ../init.d/mysql
I've tried editing /etc/init/mysql.conf to add my interface adapter (which happens to be venet0

Code:
start on (net-device-up IFACE=venet0
          and local-filesystems
          and runlevel [2345])
stop on runlevel [016]
And still no luck! There doesn't seem to be anything really in the error logs, and my.cnf looks like this:

Code:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user		= mysql
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit	= 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1

log_error                = /var/log/mysql/error.log

# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
#log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * 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!
#
# * 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

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
And just for kicks, here's /var/log/mysql/error.log:

Code:
100812 15:39:32 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100812 15:39:32  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100812 15:39:32  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100812 15:39:32  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100812 15:39:32  InnoDB: Started; log sequence number 0 0
100812 15:39:32  InnoDB: Starting shutdown...
100812 15:39:33  InnoDB: Shutdown completed; log sequence number 0 44233
100812 15:39:33 [Note] Plugin 'FEDERATED' is disabled.
100812 15:39:33  InnoDB: Started; log sequence number 0 44233
100812 15:39:33  InnoDB: Starting shutdown...
100812 15:39:35  InnoDB: Shutdown completed; log sequence number 0 44233
100812 15:39:35 [Note] Plugin 'FEDERATED' is disabled.
100812 15:39:35  InnoDB: Started; log sequence number 0 44233
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
100812 15:39:35 [ERROR] Aborting

100812 15:39:35  InnoDB: Starting shutdown...
100812 15:39:36  InnoDB: Shutdown completed; log sequence number 0 44233
100812 15:39:36 [Note] /usr/sbin/mysqld: Shutdown complete

100812 15:39:36 [Note] Plugin 'FEDERATED' is disabled.
100812 15:39:36  InnoDB: Started; log sequence number 0 44233
100812 15:39:36  InnoDB: Starting shutdown...
100812 15:39:37  InnoDB: Shutdown completed; log sequence number 0 44233
100812 15:39:37 [Note] Plugin 'FEDERATED' is disabled.
100812 15:39:37  InnoDB: Started; log sequence number 0 44233
ERROR: 1050  Table 'plugin' already exists
100812 15:39:37 [ERROR] Aborting

100812 15:39:37  InnoDB: Starting shutdown...
100812 15:39:39  InnoDB: Shutdown completed; log sequence number 0 44233
100812 15:39:39 [Note] /usr/sbin/mysqld: Shutdown complete

100812 15:39:39 [Note] Plugin 'FEDERATED' is disabled.
100812 15:39:39  InnoDB: Started; log sequence number 0 44233
100812 15:39:39 [Note] Event Scheduler: Loaded 0 events
100812 15:39:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100812 15:40:18 [Note] /usr/sbin/mysqld: Normal shutdown

100812 15:40:18 [Note] Event Scheduler: Purging the queue. 0 events
100812 15:40:18  InnoDB: Starting shutdown...
100812 15:40:19  InnoDB: Shutdown completed; log sequence number 0 44233
100812 15:40:19 [Note] /usr/sbin/mysqld: Shutdown complete

100812 15:40:19 [Note] Plugin 'FEDERATED' is disabled.
100812 15:40:19  InnoDB: Started; log sequence number 0 44233
100812 15:40:19 [Note] Event Scheduler: Loaded 0 events
100812 15:40:19 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100812 16:00:11 [Note] /usr/sbin/mysqld: Normal shutdown

100812 16:00:11 [Note] Event Scheduler: Purging the queue. 0 events
100812 16:00:11  InnoDB: Starting shutdown...
100812 16:00:12  InnoDB: Shutdown completed; log sequence number 0 44233
100812 16:00:12 [Note] /usr/sbin/mysqld: Shutdown complete

100812 16:00:12 [Note] Plugin 'FEDERATED' is disabled.
100812 16:00:12  InnoDB: Started; log sequence number 0 44233
100812 16:00:12 [Note] Event Scheduler: Loaded 0 events
100812 16:00:12 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100812 16:13:26 [Note] /usr/sbin/mysqld: Normal shutdown

100812 16:13:26 [Note] Event Scheduler: Purging the queue. 0 events
100812 16:13:26  InnoDB: Starting shutdown...
100812 16:13:26  InnoDB: Shutdown completed; log sequence number 0 44233
100812 16:13:26 [Note] /usr/sbin/mysqld: Shutdown complete

100812 16:15:53 [Note] Plugin 'FEDERATED' is disabled.
100812 16:15:53  InnoDB: Started; log sequence number 0 44233
100812 16:15:53 [Note] Event Scheduler: Loaded 0 events
100812 16:15:53 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100812 20:43:08 [Note] /usr/sbin/mysqld: Normal shutdown

100812 20:43:08 [Note] Event Scheduler: Purging the queue. 0 events
100812 20:43:08  InnoDB: Starting shutdown...
100812 20:43:11  InnoDB: Shutdown completed; log sequence number 0 169887
100812 20:43:11 [Note] /usr/sbin/mysqld: Shutdown complete

100812 20:45:55 [Note] Plugin 'FEDERATED' is disabled.
100812 20:45:55  InnoDB: Started; log sequence number 0 169887
100812 20:45:55 [Note] Event Scheduler: Loaded 0 events
100812 20:45:55 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100812 23:41:01 [Note] /usr/sbin/mysqld: Normal shutdown

100812 23:41:01 [Note] Event Scheduler: Purging the queue. 0 events
100812 23:41:01  InnoDB: Starting shutdown...
100812 23:41:02  InnoDB: Shutdown completed; log sequence number 0 169887
100812 23:41:02 [Note] /usr/sbin/mysqld: Shutdown complete

100812 23:43:02 [Note] Plugin 'FEDERATED' is disabled.
100812 23:43:02  InnoDB: Started; log sequence number 0 169887
100812 23:43:02 [ERROR] Can't start server : Bind on unix socket: No such file or directory
100812 23:43:02 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
100812 23:43:02 [ERROR] Aborting

100812 23:43:02  InnoDB: Starting shutdown...
100812 23:43:03  InnoDB: Shutdown completed; log sequence number 0 169887
100812 23:43:03 [Note] mysqld: Shutdown complete

100812 23:43:07 [Note] Plugin 'FEDERATED' is disabled.
100812 23:43:07  InnoDB: Started; log sequence number 0 169887
100812 23:43:07 [ERROR] Can't start server : Bind on unix socket: No such file or directory
100812 23:43:07 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
100812 23:43:07 [ERROR] Aborting

100812 23:43:07  InnoDB: Starting shutdown...
100812 23:43:08  InnoDB: Shutdown completed; log sequence number 0 169887
100812 23:43:08 [Note] mysqld: Shutdown complete

100812 23:43:34 [Note] Plugin 'FEDERATED' is disabled.
100812 23:43:34  InnoDB: Started; log sequence number 0 169887
100812 23:43:34 [Note] Event Scheduler: Loaded 0 events
100812 23:43:34 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100812 23:48:01 [Note] /usr/sbin/mysqld: Normal shutdown

100812 23:48:01 [Note] Event Scheduler: Purging the queue. 0 events
100812 23:48:01  InnoDB: Starting shutdown...
100812 23:48:03  InnoDB: Shutdown completed; log sequence number 0 169887
100812 23:48:03 [Note] /usr/sbin/mysqld: Shutdown complete

100812 23:49:21 [Note] Plugin 'FEDERATED' is disabled.
100812 23:49:21  InnoDB: Started; log sequence number 0 169887
100812 23:49:21 [Note] Event Scheduler: Loaded 0 events
100812 23:49:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Reply With Quote
  #3  
Old 13th August 2010, 08:47
vogelor vogelor is offline
ISPConfig Developer
 
Join Date: Jan 2007
Location: Wernau, Germany
Posts: 219
Thanks: 42
Thanked 34 Times in 24 Posts
Default

Sorry, i cant help you in your case. i can only tel you, that i am using mysql in OpenVz too and it works fine at several server.

maybe a

aptitude purge mysql
aptitude install mysql

will help

ATTENTION: if you do this, your will lose your data, so make a backup before!
__________________
Der neue Luxus heißt Zeit, nicht Geld!

Firma : http://www.muv.com, http://www.computerandservice.de
Privat : http://www.vogelor.de
Reply With Quote
  #4  
Old 13th August 2010, 15:44
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

How much free space do you have in your VM?
__________________
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 13th August 2010, 20:24
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 17 Times in 14 Posts
Default

@Falko:
Code:
root@CW-WS2:~# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/simfs             20G  1.8G   19G   9% /
varrun                512M   80K  512M   1% /var/run
varlock               512M     0  512M   0% /var/lock
@vogelor, this is the second openvz container I run that has the same problem, I don't think that reinstalling mysql will help.
Reply With Quote
  #6  
Old 14th August 2010, 15:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Looks ok. What does
Code:
cat /proc/user_beancounters
show?
__________________
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 14th August 2010, 18:43
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 17 Times in 14 Posts
Default

Code:
root@CW-WS2:~# cat /proc/user_beancounters
Version: 2.5
       uid  resource                     held              maxheld              barrier                limit              failcnt
    33050:  kmemsize                 19053795             22830537             67108864             67108864                    0
            lockedpages                     0                 1006                 1024                 1024                    0
            privvmpages                240824               263369               262144               262144                  380
            shmpages                     3983                 7929               102400               102400                    0
            dummy                           0                    0                    0                    0                    0
            numproc                        92                  114                  640                  640                    0
            physpages                  127816               182223                    0  9223372036854775807                    0
            vmguarpages                     0                    0               131072  9223372036854775807                    0
            oomguarpages               127834               182223               104857  9223372036854775807                    0
            numtcpsock                     27                   64                 1024                 1024                    0
            numflock                       15                   27                 2048                 2048                    0
            numpty                          1                    3                   64                   64                    0
            numsiginfo                      0                   18                 1024                 1024                    0
            tcpsndbuf                  419536              1034600              5368709             10737418                    0
            tcprcvbuf                  405504              3468144              5368709             10737418                    0
            othersockbuf               266928               439808              2684354              5368709                    0
            dgramrcvbuf                     0               114752              1342177              2684354                    0
            numothersock                  156                  220                 1024                 1024                    0
            dcachesize                      0                    0              8053063             12582912                    0
            numfile                      2279                 2990                32768                32768                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                      30                   35                 1536                 1536                    0
Reply With Quote
  #8  
Old 15th August 2010, 18:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
privvmpages 240824 263369 262144 262144 380
I think you should give the VM more memory.
__________________
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
  #9  
Old 15th August 2010, 19:46
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 17 Times in 14 Posts
Default

Alright, I upgraded my package to one with more memory, but it still doesn't start at boot.
Reply With Quote
  #10  
Old 15th August 2010, 23:29
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 17 Times in 14 Posts
 
Default

Fixed it!

Change /etc/init/mysql.conf from this:
Code:
start on (net-device-up
          and local-filesystems
          and runlevel [2345])
stop on runlevel [016]
to this:
Code:
start on (local-filesystems
          and runlevel [2345])
stop on runlevel [016]
Reply With Quote
The Following User Says Thank You to bswinnerton For This Useful Post:
falko (16th August 2010)
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
Mail server using Postfix, Dovecot, Mysql... Postfix virtual maps doesn't work?? tarasbuljba HOWTO-Related Questions 33 28th May 2010 14:33
Unable to connect to mysql server Can't connect to local MySQL server through socket c7p Installation/Configuration 11 21st July 2009 10:27
virtual mail boxes setup satimis Server Operation 3 25th January 2007 18:32
Can't Remote Access mysql 4.1 dedibox Installation/Configuration 2 24th August 2006 10:32
how to make php to work with mysql (php installed with apt-get, (no mysql support) grafik Installation/Configuration 3 15th May 2006 23:18


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


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