A few days ago I installed version 3.0.3.2 and everything was ok. Tonight I installed some updates for Debian 5 lenny and ISPconfig3 version returned to 3.0.3.1. I then rerun the upgrade for ISPconfig3 with ispconfig_update.sh. I was asked what to do about /etc/mysql/my.conf; I view our differences pressing "D" key than I accepted the new file with "Y" key. Too bad. Now I no longer have access to ISPconfig3. It looks like a mysql problem. Have I a chance to fix it? Thanks and best regards. aldo
Can you remember what the differences were? What does /etc/mysql/my.conf look like now? cat /etc/mysql/my.cnf When stuff is updating and asking me about changes - if I am not sure I open up another terminal and take a closer look even make a backup eg: cp /etc/mysql/my.cnf /etc/mysql/my.cnf-BEFORE This sounds like something that could be easily fixed
Thank you CSsab. I have another installation very similar and that is working. Comparing /etc/mysql/my.conf with it the only differences was: #bind-address = 127.0.0.1 that was uncommented and skip-bdb that there wasn't. But nothing seems changed after modification. Restarting mysql fails. The error.log is empty. Restarting apache report in log: Code: [Fri Jan 14 08:52:14 2011] [notice] caught SIGTERM, shutting down DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 257 [Fri Jan 14 08:52:16 2011] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec) [Fri Jan 14 08:52:16 2011] [notice] Digest: generating secret for digest authentication ... [Fri Jan 14 08:52:16 2011] [notice] Digest: done DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 257 [Fri Jan 14 08:52:16 2011] [notice] Apache/2.2.9 (Debian) DAV/2 PHP/5.2.17-0.dotdeb.0 with Suhosin-Patch mod_ruby/1.2.6 Ruby/1.8.7(2008-08-11) mod_ssl/2.2.9 OpenSSL/0.9.8g configured -- resuming normal operations It is not so easy to fix for me.
Can you connect to the database with Code: mysql -u root -p or if you know the ispconfig pass then try Code: mysql -u ispconfig -p EDITED : "Forget the above - saw you wrote you could not start mysql" Also take a look in Code: /var/log/syslog Saw on my Lenny that some errors were logged there. See in /etc/mysql if there is a my.cnf~ - this would be the old my.cnf - unless you have changed stuff after the failure
You could try downgrading to your previous version of mysql-server like this: What is the output of apt-cache showpkg mysql-server
I upgraded my server to new version of mysql and all working OK. check in Code: /var/log/syslog for error when you restart mysql server with Code: /etc/init.d/mysql restart
Thank you all for your support. in /var/log/syslog i can see: after /etc/init.d/mysql restart Code: Jan 14 16:52:05 testserver2 /etc/init.d/mysql[4281]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jan 14 16:52:05 testserver2 /etc/init.d/mysql[4281]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Jan 14 16:52:05 testserver2 /etc/init.d/mysql[4281]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Jan 14 16:52:05 testserver2 /etc/init.d/mysql[4281]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jan 14 16:52:05 testserver2 /etc/init.d/mysql[4281]: phpMyAdmin is installed but trying to login to a DB i get (sorry is italian): Code: #2002 - Il server non risponde (o il socket del server locale MySQL non รจ correttamente configurato) After executing apt-cache showpkg mysql-server i get Code: Package: mysql-server Versions: 5.1.54-0.dotdeb.0 (/var/lib/apt/lists/packages.dotdeb.org_dists_stable_all_binary-i386_Packages) (/var/lib/dpkg/status) Description Language: File: /var/lib/apt/lists/packages.dotdeb.org_dists_stable_all_binary-i386_Packages MD5: d329ffe7c38828e4851d67433ebbf1f2 5.0.51a-24+lenny4 (/var/lib/apt/lists/mir1.ovh.net_debian_dists_lenny_main_binary-i386_Packages) (/var/lib/apt/lists/security.debian.org_dists_lenny_updates_main_binary-i386_Packages) Description Language: File: /var/lib/apt/lists/mir1.ovh.net_debian_dists_lenny_main_binary-i386_Packages MD5: 2da03510b5e53fa1fea5c513da5a7017 Reverse Depends: mysql-server-5.1,mysql-server 5.1.54-0.dotdeb.0 mysql-server-5.1,mysql-server 5.1.54-0.dotdeb.0 wordpress,mysql-server 4.0.20-8 rt3.6-db-mysql,mysql-server 4.0.13 phpmyadmin,mysql-server mantis,mysql-server zabbix-server-mysql,mysql-server 4.0.16-2 zabbix-frontend-php,mysql-server 4.0.16-2 wordpress,mysql-server 4.0.20-8 webissues-server,mysql-server webcalendar,mysql-server ukolovnik,mysql-server typo3,mysql-server typo3-src-4.2,mysql-server torrentflux,mysql-server textpattern,mysql-server sympa,mysql-server steam,mysql-server sshproxy-backend-mysql,mysql-server smbind,mysql-server sitebar,mysql-server scuttle,mysql-server sbnc-mysql,mysql-server rsyslog-mysql,mysql-server rt3.6-db-mysql,mysql-server 4.0.13 qsf,mysql-server python-mysqldb,mysql-server postfix-policyd,mysql-server postfix-gld,mysql-server phpmyadmin,mysql-server phpgroupware-0.9.16-core-base,mysql-server phpbb3,mysql-server papercut,mysql-server otrs2,mysql-server ocsinventory-server,mysql-server newpki-server,mysql-server 4.0.16-2 netmrg,mysql-server ndoutils-nagios3-mysql,mysql-server nanourl,mysql-server mysqltuner,mysql-server mysql-server-5.0,mysql-server 5.0.51a-24+lenny4 mysql-server-5.0,mysql-server 5.0.51a-24+lenny4 mysql-client-5.0,mysql-server mylvmbackup,mysql-server mydms,mysql-server mtop,mysql-server moodle,mysql-server mediawiki,mysql-server mediamate,mysql-server mantis,mysql-server mahara,mysql-server libnss-mysql,mysql-server libnss-mysql-bg,mysql-server lxr-cvs,mysql-server knowledgeroot,mysql-server ipplan,mysql-server htcheck,mysql-server gpsdrive,mysql-server ferret,mysql-server dtc-postfix-courier,mysql-server dtc-cyrus,mysql-server dtc-core,mysql-server dtc-common,mysql-server dsyslog-module-mysql,mysql-server libdspam7-drv-mysql,mysql-server drupal6,mysql-server diogenes,mysql-server digitemp,mysql-server cacti,mysql-server bugzilla3,mysql-server blootbot,mysql-server bacula-director-mysql,mysql-server 4.0 auth2db,mysql-server audiolink,mysql-server 4.0.16-2 akonadi-server,mysql-server Dependencies: 5.1.54-0.dotdeb.0 - mysql-server-5.1 (0 (null)) 5.0.51a-24+lenny4 - mysql-server-5.0 (0 (null)) Provides: 5.1.54-0.dotdeb.0 - 5.0.51a-24+lenny4 - Reverse Provides: mysql-server-5.1 5.1.54-0.dotdeb.0 mysql-server-5.0 5.0.51a-24+lenny4
You need to knock back to the lenny stable install of mysql and comment out the dotdeb repository in your sources list. Vi /etc/apt/sources.list comment out the dotdeb repositories apt-get update apt-get upgrade This should do the trick and then check out your mysql-server configuration to make sure the bind address is commented out in my.cnf /etc/init.d/mysql restart ...
Thank you for help but, sorry, not solved. Now apt-cache showpkg mysql-server returns: Code: Package: mysql-server Versions: 5.0.51a-24+lenny5 (/var/lib/apt/lists/security.debian.org_dists_lenny_updates_ma in_binary-i386_Packages) Description Language: File: /var/lib/apt/lists/security.debian.org_dists_lenny_update s_main_binary-i386_Packages MD5: 2da03510b5e53fa1fea5c513da5a7017 5.0.51a-24+lenny4 (/var/lib/apt/lists/mir1.ovh.net_debian_dists_lenny_main_binar y-i386_Packages) Description Language: it File: /var/lib/apt/lists/mir1.ovh.net_debian_dists_lenny_main_i 18n_Translation-it MD5: 2da03510b5e53fa1fea5c513da5a7017 Description Language: File: /var/lib/apt/lists/mir1.ovh.net_debian_dists_lenny_main_b inary-i386_Packages MD5: 2da03510b5e53fa1fea5c513da5a7017 Reverse Depends: wordpress,mysql-server 4.0.20-8 rt3.6-db-mysql,mysql-server 4.0.13 phpmyadmin,mysql-server mysql-server-5.0,mysql-server 5.0.51a-24+lenny5 mysql-server-5.0,mysql-server 5.0.51a-24+lenny5 mysql-client-5.0,mysql-server mydms,mysql-server mantis,mysql-server zabbix-server-mysql,mysql-server 4.0.16-2 zabbix-frontend-php,mysql-server 4.0.16-2 wordpress,mysql-server 4.0.20-8 webissues-server,mysql-server webcalendar,mysql-server ukolovnik,mysql-server typo3,mysql-server typo3-src-4.2,mysql-server torrentflux,mysql-server textpattern,mysql-server sympa,mysql-server steam,mysql-server sshproxy-backend-mysql,mysql-server smbind,mysql-server sitebar,mysql-server scuttle,mysql-server sbnc-mysql,mysql-server rsyslog-mysql,mysql-server rt3.6-db-mysql,mysql-server 4.0.13 qsf,mysql-server python-mysqldb,mysql-server postfix-policyd,mysql-server postfix-gld,mysql-server phpmyadmin,mysql-server phpgroupware-0.9.16-core-base,mysql-server phpbb3,mysql-server papercut,mysql-server otrs2,mysql-server ocsinventory-server,mysql-server newpki-server,mysql-server 4.0.16-2 netmrg,mysql-server ndoutils-nagios3-mysql,mysql-server nanourl,mysql-server mysqltuner,mysql-server mysql-server-5.0,mysql-server 5.0.51a-24+lenny4 mysql-server-5.0,mysql-server 5.0.51a-24+lenny4 mysql-client-5.0,mysql-server mylvmbackup,mysql-server mydms,mysql-server mtop,mysql-server moodle,mysql-server mediawiki,mysql-server mediamate,mysql-server mantis,mysql-server mahara,mysql-server libnss-mysql,mysql-server libnss-mysql-bg,mysql-server lxr-cvs,mysql-server knowledgeroot,mysql-server ipplan,mysql-server htcheck,mysql-server gpsdrive,mysql-server ferret,mysql-server dtc-postfix-courier,mysql-server dtc-cyrus,mysql-server dtc-core,mysql-server dtc-common,mysql-server dsyslog-module-mysql,mysql-server libdspam7-drv-mysql,mysql-server drupal6,mysql-server diogenes,mysql-server digitemp,mysql-server cacti,mysql-server bugzilla3,mysql-server blootbot,mysql-server bacula-director-mysql,mysql-server 4.0 auth2db,mysql-server audiolink,mysql-server 4.0.16-2 akonadi-server,mysql-server Dependencies: 5.0.51a-24+lenny5 - mysql-server-5.0 (0 (null)) 5.0.51a-24+lenny4 - mysql-server-5.0 (0 (null)) Provides: 5.0.51a-24+lenny5 - 5.0.51a-24+lenny4 - Reverse Provides: mysql-server-5.0 5.0.51a-24+lenny5 mysql-server-5.0 5.0.51a-24+lenny4 Trying restarting mysql, in /var/log/syslog i can see: Code: Jan 16 19:53:27 alpisol2 /etc/init.d/mysql[4738]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jan 16 19:53:27 alpisol2 /etc/init.d/mysql[4738]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Jan 16 19:53:27 alpisol2 /etc/init.d/mysql[4738]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Jan 16 19:53:27 alpisol2 /etc/init.d/mysql[4738]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jan 16 19:53:27 alpisol2 /etc/init.d/mysql[4738]:
Hi aldo, Can you post the outputs of these two commands. find / -name mysql find / -name mysql.sock Here are my outputs from these commands on a Newish Debian Lenny system with ISPConfig running: csweb:~# find / -name mysql.sock csweb:~# find / -name mysql /usr/bin/mysql /usr/lib/perl5/DBD/mysql /usr/lib/perl5/auto/DBD/mysql /usr/share/mysql /etc/init.d/mysql /etc/mysql /var/lib/mysql /var/lib/mysql/mysql /var/log/mysql csweb:~# cd /var/run/mysqld csweb:/var/run/mysqld# ls mysqld.pid mysqld.sock csweb:/var/run/mysqld# cat mysqld.sock cat: mysqld.sock: No such device or address Also here is all uncommented from my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M expire_logs_days = 10 max_binlog_size = 100M skip-bdb [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/ AS ROOT IN A TERMINAL What you can do is make a copy of your own my.cnf file like this: cp /etc/mysql/my.cnf /etc/mysql/my.cnf-BACKUP (Here you should check the language in mysql - yours would be italian i think?) Then remove your my.cnf file like this: rm /etc/mysql/my.cnf Then create a new my.cnf like this vi /etc/mysql/my.cnf Copy the above my.cnf into the new file - save it and close. /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables..
find / -name mysql returns: Code: /var/lib/mysql /var/lib/mysql/mysql /var/log/mysql /var/www/clients/client9/web6/web/includes/database/mysql /usr/include/mysql /usr/share/mysql /usr/bin/mysql /usr/lib/perl5/DBD/mysql /usr/lib/perl5/auto/DBD/mysql /usr/lib/mysql /etc/mysql /etc/init.d/mysql find / -name mysql.sock returns nothing! uncommented my.cnf Code: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M expire_logs_days = 10 max_binlog_size = 100M skip-bdb [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/ Modifying my.cnf changes nothing. Restarting mysql /var/log/syslog reports: Code: Jan 17 10:49:31 alpisol2 /etc/init.d/mysql[4564]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jan 17 10:49:31 alpisol2 /etc/init.d/mysql[4564]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Jan 17 10:49:31 alpisol2 /etc/init.d/mysql[4564]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Jan 17 10:49:31 alpisol2 /etc/init.d/mysql[4564]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jan 17 10:49:31 alpisol2 /etc/init.d/mysql[4564]: I have no mysqld.socks.
The bind address in your my.cnf file is not commented out and it should be like this: #bind-address = 127.0.0.1 This means that you are only listening on the local interface.
When I copied my.cnf it was uncommented but, just before, I tried it commented with the same result. I have no files named mysql.sock. Is it normal?
I have no /var/run/mysqld folder. Searching for mysqld with find / -name mysqld I find only these /var/www/clients/client8/web5/var/run/mysqld /usr/sbin/mysqld