Rescue

Discussion in 'Installation/Configuration' started by Nolan, Jan 16, 2015.

  1. Nolan

    Nolan Member

    Hi,
    So, I was trying test the ispconfig rescue system, and I did "service mysql stop" to see if it would restart it. This is running on Debian 7 and the latest version of ISPconfig.

    However, in the Cron log, I'm seeing:
    Fri Jan 16 15:32:01 EST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62
    Fri Jan 16 15:32:01 EST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Fri Jan 16 15:32:01 EST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Fri Jan 16 15:32:02 EST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Fri Jan 16 15:32:02 EST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Fri Jan 16 15:32:03 EST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Fri Jan 16 15:32:03 EST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Fri Jan 16 15:32:04 EST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Fri Jan 16 15:32:04 EST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72

    Any ideas?
    Edit: I should also mention that it didn't restart the mysql service.
     
    Last edited: Jan 16, 2015
    Nolan, Jan 16, 2015
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Please add it to the bugtracker so we can check that for the 3.1 release.
     
    till, Jan 19, 2015
    #2
  3. sidbyron

    sidbyron Member

    Hi I have the same issue:

    Mon Feb 2 08:52:02 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62
    Mon Feb 2 08:52:02 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:02 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:03 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:03 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:04 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:04 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:05 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:05 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:06 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:06 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:07 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:07 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:08 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:08 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:09 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:09 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    Mon Feb 2 08:52:10 CST 2015 DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Mon Feb 2 08:52:10 CST 2015 PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
     
    sidbyron, Feb 15, 2015
    #3
  4. Mat38

    Mat38 New Member

    I have the same issue. But I haven't done any maintenance operation...

    Code:
    mardi 29 septembre 2015, 17:31:27 (UTC+0200) PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
mardi 29 septembre 2015, 17:31:32 (UTC+0200) DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mardi 29 septembre 2015, 17:31:32 (UTC+0200) PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
mardi 29 septembre 2015, 17:31:32 (UTC+0200) PHP Warning: mysqli::close(): Couldn't fetch db in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 82
mardi 29 septembre 2015, 17:32:05 (UTC+0200) PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62
mardi 29 septembre 2015, 17:32:05 (UTC+0200) DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mardi 29 septembre 2015, 17:32:06 (UTC+0200) PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
mardi 29 septembre 2015, 17:32:06 (UTC+0200) DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mardi 29 septembre 2015, 17:32:07 (UTC+0200) PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
mardi 29 septembre 2015, 17:32:07 (UTC+0200) DB::__construct Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mardi 29 septembre 2015, 17:32:08 (UTC+0200) PHP Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
     
    Mat38, Oct 6, 2015
    #4
  5. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    Is your mysql-server running? Can you access mysql with the settings from /usr/local/ispconfig/server/lib/mysql_clientdb.conf ?
     
    florian030, Oct 6, 2015
    #5
  6. Mat38

    Mat38 New Member

    Yes, of course, my server mysql is running and all my sql services seems to work perfectly...
    Yes, I can access mysql with the settings from /usr/local/ispconfig/server/lib/mysql_clientdb.conf.
    For information, logs provided in my previous post are coming from ispconfig/cron.log
     
    Mat38, Oct 6, 2015
    #6

Share This Page