No login at 01.Nov

Support & Bugs
1

From today i cant login in piwik. Piwik asks the password an then need 30 seconds to give the following error:

<<
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
<<

There is no information in the apache or system error log. It ist piwik 1.9.1 an there are no changes done. Yesterday everything works fine.

Any hints?

Greetings

balbal

2

Surprising! Can you try to enable Database sessions as per: Installation - Analytics Platform - Matomo

3

session files are written in folder “tmp/sessions/” - I think it was a problem with the database.

I imported the piwik database from 30.Okt. and now it works fine.

Greetings balbal

4

Hmm, same problem again now :frowning: > Internal Server Error

I tried your hint to change the session handle to dbtable, but no effect. There is an error in the faq, it is not in the config/config.ini.php file, it is in the config/global.ini.php file.

Any hints?

Greetings
balbal

5

after the login piwik requests “SELECT idarchive FROM archive_numeric_2012_11 WHERE name = ‘locked_9c5bc0a1542e09673c359e8f68f4ced9’ LIMIT 1;” and there is no result!

Next interesting thing is, piwik runs exactly for 12 month (from 11/2011 to 11/2012). Maybe this have something to do with the error?

tbl archive_blob_2011_11…archive_blob_2012_10 are MYISAM, tbl archive_blob_2012_11 is INNODB, same with tbl archive_numeric_2012_11. Is that OK?

Greetings

balbal

6

if i try to run the cron arcive.php there is an error:

[2012-11-01 16:39:01] [bbfe3e33] ERROR: Got invalid response from API request: http://mydomain.de/stat/index.php?module=API&method=API.getDefaultMetricTranslations&format=php&trigger=archivephp. Response was ‘curl_exec: Failed to connect to ff02::2: Das Netzwerk ist nicht erreichbar’

The URl runs in a browser. It looks like IPV6 Broadcast, IPV6 is not configured on the server.

archive.sh runs!

Greetings

balbal

7

I run archive.sh, now it runs. I can log in an view the reports. archive.php will not run since 01. Nov :frowning:

Greetings

balbal

8

archive.php should run. What command are you executing ? it needs to have the --url http://piwik-server/path to work

9

/path/to/piwik/misc/cron/archive.php --url=http://example.org/piwik/

I tried via command line and crone job.

Now I run the archive.sh every hour via cron.

Greetings

balbal

10

/path/to/piwik/misc/cron/archive.php --url=http://example.org/piwik/

it should be

php5 /path/to/piwik/misc/cron/archive.php --url=http://example.org/piwik/

11

it is the same error:

[2012-11-01 16:39:01] [bbfe3e33] ERROR: Got invalid response from API request: http://mydomain.de/stat/index.php?module=API&method=API.getDefaultMetricTranslations&format=php&trigger=archivephp. Response was ‘curl_exec: Failed to connect to ff02::2: Das Netzwerk ist nicht erreichbar’