I installed ISPConfig, everything was working well. I added a second hard drive that is much larger than the other. So far, so good. I copied all of the files in /var to the new larger hard drive, mounted the new hard drive as /var and get the following error when I try to log in to ISPConfig: Code: Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77 Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77 Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php:77) in /home/admispconfig/ispconfig/web/login/login.php on line 60 I ran umount /var for now. Can anyone tell me where I went wrong? Thanks.
Please restart mysql, do you get any errors? Have you preserved all permissions as you copied the files?
I restarted with /var unmounted and now I can't access the ISPConfig login. I deleted the second hard drive from fstab and restarted. It didn't give any errors, but I still couldn't access ISPConfig. I added the hard drive to fstab again, restarted mysql and got the following: Code: root@mail:~# mount /dev/sda1 on / type ext3 (rw,errors=remount-ro,usrquota,grpquota) proc on /proc type proc (rw,noexec,nosuid,nodev) /sys on /sys type sysfs (rw,noexec,nosuid,nodev) varrun on /var/run type tmpfs (rw,noexec,nosuid,nodev,mode=0755) varlock on /var/lock type tmpfs (rw,noexec,nosuid,nodev,mode=1777) procbususb on /proc/bus/usb type usbfs (rw) udev on /dev type tmpfs (rw,mode=0755) devshm on /dev/shm type tmpfs (rw) devpts on /dev/pts type devpts (rw,gid=5,mode=620) lrm on /lib/modules/2.6.20-15-generic/volatile type tmpfs (rw) binfmt_misc on /proc/sys/fs/binfmt_misc type binfmt_misc (rw) /dev/sdb1 on /var type ext3 (rw,errors=remount-ro) Code: root@mail:~# /etc/init.d/mysql restart * Stopping MySQL database server mysqld ...done. * Starting MySQL database server mysqld ...fail! root@mail:~# One thing I did differently from the instructions on this thread http://www.howtoforge.com/forums/showthread.php?t=13547&highlight=hard+drive . . . I did not stop ISPConfig before copying. I copied it using the following command: cp -Rp /var/* /tempVar Code: root@mail:/# /etc/init.d/ispconfig_server restart Shutting down ISPConfig system... /root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running ISPConfig system stopped! Starting ISPConfig system... /root/ispconfig/httpd/bin/apachectl startssl: httpd could not be started Could not connect to MySQL server!ISPConfig system is now up and running! root@mail:/#
This has all nothing to do with ISPConfig. Your problem is that mysql is not working and as long as mysql is not working, you can not start ISPConfig. Have a look at your mysql and syslog and fix the mysql problem to be able to use ISPConfig again.
How can I diagnose the problem with mysql? Here is what I found in /var/log/syslog: Code: Jul 1 07:46:36 mail postfix/pickup[13549]: warning: connect #1 to subsystem public/cleanup: Connection refused Jul 1 07:46:46 mail postfix/pickup[13549]: warning: connect #2 to subsystem public/cleanup: Connection refused Jul 1 07:46:56 mail postfix/pickup[13549]: warning: connect #3 to subsystem public/cleanup: Connection refused Jul 1 07:47:06 mail postfix/pickup[13549]: warning: connect #4 to subsystem public/cleanup: Connection refused Jul 1 07:47:16 mail postfix/pickup[13549]: warning: connect #5 to subsystem public/cleanup: Connection refused Jul 1 07:47:26 mail postfix/pickup[13549]: warning: connect #6 to subsystem public/cleanup: Connection refused Jul 1 07:47:36 mail postfix/pickup[13549]: warning: connect #7 to subsystem public/cleanup: Connection refused Jul 1 07:47:46 mail postfix/pickup[13549]: warning: connect #8 to subsystem public/cleanup: Connection refused Jul 1 07:47:56 mail postfix/pickup[13549]: warning: connect #9 to subsystem public/cleanup: Connection refused Jul 1 07:48:06 mail postfix/pickup[13549]: warning: connect #10 to subsystem public/cleanup: Connection refused Jul 1 07:48:16 mail postfix/pickup[13549]: fatal: connect #11 to subsystem public/cleanup: Connection refused Code: root@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:2208 *:* LISTEN 4667/hpiod tcp 0 0 *:mysql *:* LISTEN 5810/mysqld tcp 0 0 *:www *:* LISTEN 5445/apache2 tcp 0 0 *:ftp *:* LISTEN 5630/proftpd: (acce tcp 0 0 mail.mydomain.co:domain *:* LISTEN 5595/named tcp 0 0 localhost:domain *:* LISTEN 5595/named tcp 0 0 localhost:ipp *:* LISTEN 4637/cupsd tcp 0 0 localhost:953 *:* LISTEN 5595/named tcp 0 0 *:smtp *:* LISTEN 5547/master tcp 0 0 *:https *:* LISTEN 5445/apache2 tcp 0 0 localhost:2207 *:* LISTEN 4672/python tcp 17 0 localhost:smtp localhost:3113 CLOSE_WAIT - tcp6 0 0 *:imaps *:* LISTEN 4909/couriertcpd tcp6 0 0 *:pop3s *:* LISTEN 4951/couriertcpd tcp6 0 0 *:pop3 *:* LISTEN 4926/couriertcpd tcp6 0 0 *:imap2 *:* LISTEN 4882/couriertcpd tcp6 0 0 *:domain *:* LISTEN 5595/named tcp6 0 0 *:ssh *:* LISTEN 5105/sshd tcp6 0 0 ip6-localhost:953 *:* LISTEN 5595/named tcp6 0 0 *:smtp *:* LISTEN 5547/master tcp6 0 2112 server1.mydomain.com:ssh c-67-186-198-183.:65199 ESTABLISHED16494/0 Code: root@mail:~# ls -l /home/admispconfig/ispconfig/lib/ total 68 -rwxr-xr-x 1 admispconfig admispconfig 5967 2007-06-30 10:30 app.inc.php -rwxr-xr-x 1 admispconfig admispconfig 1768 2007-06-30 10:30 banner.inc.php drwxr-xr-x 2 admispconfig admispconfig 4096 2007-06-30 10:34 classes -rw------- 1 admispconfig admispconfig 7029 2007-06-30 10:30 config.inc.php -rwxr-xr-x 1 admispconfig admispconfig 354 2007-06-30 10:30 copyright.inc.php -rwxr-xr-x 1 admispconfig admispconfig 7480 2007-06-30 10:30 go_info.inc.php drwxr-xr-x 2 admispconfig admispconfig 4096 2007-06-30 09:14 help -rwxr-xr-x 1 admispconfig admispconfig 324 2007-06-30 10:30 index.php drwxr-xr-x 2 admispconfig admispconfig 4096 2007-06-30 09:14 lang drwxr-xr-x 2 admispconfig admispconfig 4096 2007-06-30 09:14 plugins -rwxr-xr-x 1 admispconfig admispconfig 5 2007-06-30 10:30 preload.inc.php -rwxr-xr-x 1 admispconfig admispconfig 10992 2007-06-30 10:30 session.inc.php root@mail:~#
Your mysqld is running but it seems not be able to accept connections. Please stop mysql with its init script. If there is still a mysql process running when you check with netstat, then kill the mysql process with the "kill" command and start mysql again.
I tried stopping and it was still running. I used the command "killall mysql" which stopped it. I then started mysql and restarted ISPConfig. I got the same error when restarting ISPConfig, and I still can't access the control panel on port 81. This happened when I rebooted the machine. Or did I mess up the tables when I copied everything from one drive to the other? I didn't stop mysql or ISPConfig before copying everything; however, it worked fine until I rebooted. Code: root@mail:~# killall mysqld root@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:2208 *:* LISTEN 4667/hpiod tcp 0 0 *:www *:* LISTEN 683/apache2 tcp 0 0 *:ftp *:* LISTEN 5630/proftpd: (acce tcp 0 0 mail.mydomain.co:domain *:* LISTEN 5595/named tcp 0 0 localhost:domain *:* LISTEN 5595/named tcp 0 0 localhost:ipp *:* LISTEN 4637/cupsd tcp 0 0 localhost:953 *:* LISTEN 5595/named tcp 0 0 *:smtp *:* LISTEN 821/smtpd tcp 0 0 *:https *:* LISTEN 683/apache2 tcp 0 0 localhost:2207 *:* LISTEN 4672/python tcp 17 0 localhost:smtp localhost:3113 CLOSE_WAIT - tcp6 0 0 *:imaps *:* LISTEN 4909/couriertcpd tcp6 0 0 *:pop3s *:* LISTEN 4951/couriertcpd tcp6 0 0 *:pop3 *:* LISTEN 4926/couriertcpd tcp6 0 0 *:imap2 *:* LISTEN 4882/couriertcpd tcp6 0 0 *:domain *:* LISTEN 5595/named tcp6 0 0 *:ssh *:* LISTEN 5105/sshd tcp6 0 0 ip6-localhost:953 *:* LISTEN 5595/named tcp6 0 0 *:smtp *:* LISTEN 821/smtpd tcp6 0 2592 mail.mydomain.com:ssh rockland-router3.:50028 ESTABLISHED728/0 Code: root@mail:~# /etc/init.d/mysql start * Starting MySQL database server mysqld ...done. * Checking for corrupt, not cleanly closed and upgrade needing tables. Code: root@mail:~# /etc/init.d/ispconfig_server restart Shutting down ISPConfig system... /root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running ISPConfig system stopped! Starting ISPConfig system... /root/ispconfig/httpd/bin/apachectl startssl: httpd could not be started ISPConfig system is now up and running! Code: root@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:2208 *:* LISTEN 4667/hpiod tcp 0 0 *:mysql *:* LISTEN 899/mysqld tcp 0 0 *:www *:* LISTEN 683/apache2 tcp 0 0 mail.mydomain.co:domain *:* LISTEN 1158/named tcp 0 0 localhost:domain *:* LISTEN 1158/named tcp 0 0 *:ftp *:* LISTEN 5630/proftpd: (acce tcp 0 0 localhost:ipp *:* LISTEN 4637/cupsd tcp 0 0 localhost:953 *:* LISTEN 1158/named tcp 0 0 *:smtp *:* LISTEN 1204/smtpd tcp 0 0 *:https *:* LISTEN 683/apache2 tcp 0 0 localhost:2207 *:* LISTEN 4672/python tcp 0 0 localhost:ftp localhost:1716 TIME_WAIT - tcp 0 0 localhost:1570 localhost:www TIME_WAIT - tcp 17 0 localhost:smtp localhost:3113 CLOSE_WAIT - tcp6 0 0 *:imaps *:* LISTEN 4909/couriertcpd tcp6 0 0 *:pop3s *:* LISTEN 4951/couriertcpd tcp6 0 0 *:pop3 *:* LISTEN 4926/couriertcpd tcp6 0 0 *:imap2 *:* LISTEN 4882/couriertcpd tcp6 0 0 *:domain *:* LISTEN 1158/named tcp6 0 0 *:ssh *:* LISTEN 5105/sshd tcp6 0 0 ip6-localhost:953 *:* LISTEN 1158/named tcp6 0 0 *:smtp *:* LISTEN 1204/smtpd tcp6 0 3024 mail.mydomain.com:ssh rockland-router3.:50028 ESTABLISHED728/0
root@mail:~# vim /root/ispconfig/httpd/logs/error_log: Code: [Sat Jun 30 10:30:25 2007] [error] mod_ssl: Init: Unable to read server certificate from file /root/ispconfig/httpd/conf/ssl.crt/server.crt (OpenSSL library error follows) [Sat Jun 30 10:30:25 2007] [error] OpenSSL: error:0D06B08E:asn1 encoding routines:ASN1_D2I_READ_BIO:not enough data [Sat Jun 30 23:09:26 2007] [error] mod_ssl: Init: Unable to read server certificate from file /root/ispconfig/httpd/conf/ssl.crt/server.crt (OpenSSL library error follows) [Sat Jun 30 23:09:26 2007] [error] OpenSSL: error:0D06B08E:asn1 encoding routines:ASN1_D2I_READ_BIO:not enough data [Sat Jun 30 23:14:17 2007] [error] mod_ssl: Init: Unable to read server certificate from file /root/ispconfig/httpd/conf/ssl.crt/server.crt (OpenSSL library error follows) [Sat Jun 30 23:14:17 2007] [error] OpenSSL: error:0D06B08E:asn1 encoding routines:ASN1_D2I_READ_BIO:not enough data [Sat Jun 30 23:19:36 2007] [error] mod_ssl: Init: Unable to read server certificate from file /root/ispconfig/httpd/conf/ssl.crt/server.crt (OpenSSL library error follows) [Sat Jun 30 23:19:36 2007] [error] OpenSSL: error:0D06B08E:asn1 encoding routines:ASN1_D2I_READ_BIO:not enough data [Sat Jun 30 23:34:32 2007] [error] mod_ssl: Init: Unable to read server certificate from file /root/ispconfig/httpd/conf/ssl.crt/server.crt (OpenSSL library error follows) [Sat Jun 30 23:34:32 2007] [error] OpenSSL: error:0D06B08E:asn1 encoding routines:ASN1_D2I_READ_BIO:not enough data [Sat Jun 30 23:42:56 2007] [error] mod_ssl: Init: Unable to read server certificate from file /root/ispconfig/httpd/conf/ssl.crt/server.crt (OpenSSL library error follows) [Sat Jun 30 23:42:56 2007] [error] OpenSSL: error:0D06B08E:asn1 encoding routines:ASN1_D2I_READ_BIO:not enough data [Mon Jul 2 07:28:28 2007] [error] mod_ssl: Init: Unable to read server certificate from file /root/ispconfig/httpd/conf/ssl.crt/server.crt (OpenSSL library error follows) [Mon Jul 2 07:28:28 2007] [error] OpenSSL: error:0D06B08E:asn1 encoding routines:ASN1_D2I_READ_BIO:not enough data
Your SSL certificate is corrupt. Please create a new one: http://www.howtoforge.com/forums/showthread.php?t=121
