Piwik Login Error

I was in my Piwik admin about 10 days ago (been a bit busy with blizzards since then!). Now I can’t login.I haven’t made any changes. I looked in cPanel and the db is still there.

“Table: piwik_archive_blob_2010_02” had 29 records added in 1 second and there’s nothing after that. No new data in the tables, no later dates, and no new tables. I’ve certainly seen data the past couple months but I don’t see it now.

The error log shows a bunch of errors in Dec then nothing until Mar 08. I didn’t have any problems in Dec. The directories in Piwik are all dated Dec 23 so there haven’t been any changes lately. The log is freaking huge, 1.5 MB, most from the past few days. I deleted the error log file from the webserver but it still won’t load.

Here’s what I get when I go to the my page:

Declaration of Piwik_Log_APICall::log() should be compatible with that of Piwik_Log::log()
in ‘/mysite/piwik/core/Log/APICall.php’ at the line 52
#0 Piwik_ErrorHandler(2048, Declaration of Piwik_Log_APICall::log() should be compatible with that of Piwik_Log::log(), /mysite/piwik/core/Log/APICall.php, 52, Array ()) called at [(null):0]
#1 Piwik::createLogObject() called at [/mysite/piwik/core/Piwik.php:965]
#2 Piwik::createLogObject() called at [/mysite/piwik/core/FrontController.php:233]
#3 Piwik_FrontController->init() called at [/mysite/piwik/index.php:51]

Here is the point in the error log showing the last errors in Dec and the beginning new ones in March.

[27-Dec-2009 09:09:01] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Error query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away’ in /mysite/piwik/core/Tracker/Db.php:204

Stack trace:

#0 /mysite/piwik/core/Tracker/Visit.php(526): Piwik_Tracker_Db->query(‘INSERT INTO piw…’, Array)

#1 /mysite/piwik/core/Tracker/Visit.php(343): Piwik_Tracker_Visit->handleNewVisit()

#2 /mysite/piwik/core/Tracker.php(72): Piwik_Tracker_Visit->handle()

#3 /mysite/piwik/piwik.php(46): Piwik_Tracker->main()

#4 {main}

thrown in /mysite/piwik/core/Tracker/Db.php on line 204

[27-Dec-2009 09:12:02] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Error query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away’ in /mysite/piwik/core/Tracker/Db.php:204

Stack trace:

#0 /mysite/piwik/core/Tracker/Visit.php(526): Piwik_Tracker_Db->query(‘INSERT INTO piw…’, Array)

#1 /mysite/piwik/core/Tracker/Visit.php(343): Piwik_Tracker_Visit->handleNewVisit()

#2 /mysite/piwik/core/Tracker.php(72): Piwik_Tracker_Visit->handle()

#3 /mysite/piwik/piwik.php(46): Piwik_Tracker->main()

#4 {main}

thrown in /mysite/piwik/core/Tracker/Db.php on line 204

[29-Dec-2009 08:57:09] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Error query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away’ in /mysite/piwik/core/Tracker/Db.php:204

Stack trace:

#0 /mysite/piwik/core/Tracker/Visit.php(526): Piwik_Tracker_Db->query(‘INSERT INTO piw…’, Array)

#1 /mysite/piwik/core/Tracker/Visit.php(343): Piwik_Tracker_Visit->handleNewVisit()

#2 /mysite/piwik/core/Tracker.php(72): Piwik_Tracker_Visit->handle()

#3 /mysite/piwik/piwik.php(46): Piwik_Tracker->main()

#4 {main}

thrown in /mysite/piwik/core/Tracker/Db.php on line 204

[29-Dec-2009 09:12:10] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Error query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away’ in /mysite/piwik/core/Tracker/Db.php:204

Stack trace:

#0 /mysite/piwik/core/Tracker/Visit.php(526): Piwik_Tracker_Db->query(‘INSERT INTO piw…’, Array)

#1 /mysite/piwik/core/Tracker/Visit.php(343): Piwik_Tracker_Visit->handleNewVisit()

#2 /mysite/piwik/core/Tracker.php(72): Piwik_Tracker_Visit->handle()

#3 /mysite/piwik/piwik.php(46): Piwik_Tracker->main()

#4 {main}

thrown in /mysite/piwik/core/Tracker/Db.php on line 204

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:39:13] PHP Fatal error: Class ‘PDO’ not found in /mysite/piwik/core/Tracker/Db.php on line 87

[08-Mar-2010 18:48:22] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:48:22] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:48:22] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:48:22] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:48:22] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:48:22] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:48:22] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin: cannot open shared object file: No such file or directory in Unknown on line 0

[08-Mar-2010 18:48:22] PHP Fatal error: Class ‘PDO’ not found in /mysite/piwik/core/Tracker/Db.php on line 87

The log messages are non-fatal and have been addressed in SVN. This will be in the upcoming 0.5.5 release. If you can’t wait, you can grab a snapshot from http://dev.piwik.org/trac/changeset/1908/t…&format=zip

It looks like the login error is your hosting provider’s fault. Apparently, your host has updated your web server’s version of PHP – I’m guessing 5.3.2. This pdo_mysql error message means your php configuration is broken:

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0

Being able to connect to the database is a critical requirement for Piwik. No pdo_mysql extension means no database connection.

Thank you !! I’m on HostGator. I’ll contact them

[quote=vipsoft @ Mar 13 2010, 01:42 AM]The log messages are non-fatal and have been addressed in SVN. This will be in the upcoming 0.5.5 release. If you can’t wait, you can grab a snapshot from dev.piwik.org/trac/changeset/1908/t…&format=zip

It looks like the login error is your hosting provider’s fault. Apparently, your host has updated your web server’s version of PHP – I’m guessing 5.3.2. This pdo_mysql error message means your php configuration is broken:

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0

Being able to connect to the database is a critical requirement for Piwik. No pdo_mysql extension means no database connection.[/quote]

Yeah, HG updated php to 5.2.13 on their shared servers about a week ago.

Hostgator asked me what version I’m running. How can I tell when it won’t load? style_emoticons/<#EMO_DIR#>/blink.gif

Are you saying HG support doesn’t understand what this error message means?

[08-Mar-2010 18:39:13] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0