Thanks for the reply Simon, It was a weird one - the upgrade to SLES SP3 removed the symlink to the datadir. MySQL started up again and recreated the directories in the default location.
I thought just updating the datadir entry in my.cnf would be enough, but it was not for some reason. I then deleted the newly created directories and created the symlink again and all fine.... It is working, but I am still confused as to why updating the datadir would not be enough On Tue, Jul 29, 2014 at 2:16 PM, Simon Walter <si...@gikaku.com> wrote: > 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 >
_______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
