unable to login after updating to 3.0.3.2

Discussion in 'Installation/Configuration' started by aldo, Jan 14, 2011.

  1. aldo

    aldo New Member HowtoForge Supporter

    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
     
  2. CSsab

    CSsab New Member

    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 :)
     
  3. aldo

    aldo New Member HowtoForge Supporter

    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.
     
  4. DKLeader

    DKLeader New Member

    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
     
    Last edited: Jan 14, 2011
  5. CSsab

    CSsab New Member

    Have you got phpmyadmin installed and can you log into that?
     
  6. CSsab

    CSsab New Member

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

    What is the output of
    apt-cache showpkg mysql-server
     
  7. Franz

    Franz Member

    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
     
  8. aldo

    aldo New Member HowtoForge Supporter

    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
     
  9. CSsab

    CSsab New Member

    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

    ...
     
  10. aldo

    aldo New Member HowtoForge Supporter

    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]: 
     
  11. CSsab

    CSsab New Member

    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..
     
    Last edited: Jan 17, 2011
  12. aldo

    aldo New Member HowtoForge Supporter

    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.
     
  13. CSsab

    CSsab New Member

    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.
     
  14. aldo

    aldo New Member HowtoForge Supporter

    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?
     
    Last edited: Jan 17, 2011
  15. CSsab

    CSsab New Member

    You likely do have this file - do this:

    cd /var/run/mysqld

    then type

    ls

    and you should see it there
     
  16. aldo

    aldo New Member HowtoForge Supporter

    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
     

Share This Page