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 14th January 2011, 00:57
aldo aldo is offline
HowtoForge Supporter
 
Join Date: Jan 2011
Posts: 98
Thanks: 34
Thanked 3 Times in 3 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 14th January 2011, 07:16
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

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
Reply With Quote
  #3  
Old 14th January 2011, 09:25
aldo aldo is offline
HowtoForge Supporter
 
Join Date: Jan 2011
Posts: 98
Thanks: 34
Thanked 3 Times in 3 Posts
Default

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.
Reply With Quote
  #4  
Old 14th January 2011, 10:01
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default

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
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe

Last edited by DKLeader; 14th January 2011 at 10:05.
Reply With Quote
  #5  
Old 14th January 2011, 10:13
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

Have you got phpmyadmin installed and can you log into that?
Reply With Quote
  #6  
Old 14th January 2011, 10:23
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

You could try downgrading to your previous version of mysql-server like this:

What is the output of
apt-cache showpkg mysql-server
Reply With Quote
  #7  
Old 14th January 2011, 10:51
Franz Franz is offline
Senior Member
 
Join Date: Jul 2009
Location: Cakovec
Posts: 117
Thanks: 7
Thanked 24 Times in 18 Posts
Send a message via Skype™ to Franz
Default

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
__________________
my PAGE
VoIP
my IT help blog
Reply With Quote
  #8  
Old 14th January 2011, 17:16
aldo aldo is offline
HowtoForge Supporter
 
Join Date: Jan 2011
Posts: 98
Thanks: 34
Thanked 3 Times in 3 Posts
Default

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
Reply With Quote
  #9  
Old 15th January 2011, 01:35
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

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

...
Reply With Quote
  #10  
Old 16th January 2011, 20:14
aldo aldo is offline
HowtoForge Supporter
 
Join Date: Jan 2011
Posts: 98
Thanks: 34
Thanked 3 Times in 3 Posts
 
Default

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]:
Reply With Quote
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
F11 courier-imap fails. Nachogrande General 6 1st November 2010 17:55
Forbidden 403; Samba access; config of maildeamon fawkes Installation/Configuration 4 14th January 2010 18:16
squirrelmail and postfix witoszek General 12 1st December 2009 18:07
Postfix can't received email from exterior astra2000 Server Operation 5 17th October 2009 23:26
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19


All times are GMT +2. The time now is 18:04.


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