unable to login after updating to 3.0.3.2

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

 

Have you got phpmyadmin installed and can you log into that?

 

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?

 

You likely do have this file - do this:

cd /var/run/mysqld

then type

ls

and you should see it there

 

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