Has the location of the socket changed? Did you try connecting explicitly to the socket that icinga-web (via Doctrine) is trying to use (/var/lib/mysql/mysql.sock)?
https://dev.mysql.com/doc/refman/5.1/en/connecting.html#option_general_socket On 07/28/2014 12:19 PM, Werner van der Merwe wrote: > Good day all, > > Trust someone can shed some light on a strange issue I am having. > > We have Icinga-web running on a SLES server and we did a zypper dup. > > Upgrading of MySQL went fine, although I had to comment out skip-federation > and skip-locking to get the upgrade to work. > > After that, I get the following error from icinga-web: > > A critical exception occured! > Uncaught Doctrine_Connection_Exception thrown: > PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL > server through socket '/var/lib/mysql/mysql.sock' (13) > *Stacktrace:* > #0 > /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Connection/Mysql.php(101): > Doctrine_Connection->connect() > #1 /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Connection.php(1009): > Doctrine_Connection_Mysql->connect() > #2 /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Query/Abstract.php(976): > Doctrine_Connection->execute('SELECT n.sessio...', Array) > #3 > /usr/share/icinga-web/lib/doctrine/lib/Doctrine/Query/Abstract.php(1026): > Doctrine_Query_Abstract->_execute(Array) > #4 > /usr/share/icinga-web/app/modules/AppKit/lib/storage/AppKitDoctrineSessionStorage.class.php(133): > Doctrine_Query_Abstract->execute() > #5 [internal function]: > AppKitDoctrineSessionStorage->sessionRead('hjri8sps2sj727h...') > #6 > /usr/share/icinga-web/lib/agavi/src/storage/AgaviSessionStorage.class.php(132): > session_start() > #7 > /var/cache/icinga-web/config/factories.xml_production_web_3b046d81eca933d9f16b3365d9ddd13114979325.php(76): > AgaviSessionStorage->startup() > #8 > /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(384): > include('/var/cache/icin...') > #9 > /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(3549): > AgaviContext->initialize() > #10 > /var/cache/icinga-web/config/compile.xml_production__d41bc4e7416d79a2859fb497054ab4f5308e2df1.php(370): > AppKitAgaviContext->initialize() > #11 /usr/share/icinga-web/pub/index.php(49): > AgaviContext::getInstance('web') > #12 {main} > > Yet I can log in from the command line with no problems: > /etc/icinga-web : mysql -h localhost -u icinga_web -p icinga_web > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 32 > Server version: 5.5.33 SUSE MySQL package > > Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. > > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement. > > mysql> > > I have tried connecting to 127.0.0.1 as well to bypass the socket. > > Config is as follow: > <ae:parameter > name="dsn">mysql://icinga_web:**********@localhost:3306/icinga_web</ae:parameter> > > Nothing in the MySQL log, but I do see the following in the Apache error > log: > PHP Fatal error: Call to undefined method stdClass::save() in > /usr/share/icinga-web/app/modules/AppKit/lib/storage/AppKitDoctrineSessionStorage.class.php > on line 177 > > Does anyone have any directional pointers for me as I am slightly stumped. > > > > _______________________________________________ > icinga-users mailing list > icinga-users@lists.icinga.org > https://lists.icinga.org/mailman/listinfo/icinga-users > _______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
