Error: Got invalid response from API request


(n00bster) #1

Seit dem Update auf 2.1.0 bekomme ich diese Fehlermeldung bei der Ausführung des Cron-Jobs. So ganz verstehe ich das leider nicht, kann mir jemand etwas weiterhelfen was da schief rennt?


INFO [2014-03-05 09:16:19] [15297] Error: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using p
INFO [2014-03-05 09:16:19] [15297] Error: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=6&period=week&date=last260&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:15:49] [ac0d5] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [ac0d5] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [ac0d5] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [ac0d5] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:50] [ac0d5] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:50] [ac0d5] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:15:50] [ac0d5] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:15:50] [ac0d5] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:50] [ac0d5] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:50] [ac0d5] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:15:50] [ac0d5] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (u
INFO [2014-03-05 09:16:19] [15297] Error: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=6&period=month&date=last52&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:16:01] [fd2fd] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:01] [fd2fd] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO VisitsSummary[2014-03-05 09:16:02] [fd2fd] Purging temporary archives: skipped.</pre><pre>INFO Actions[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [fd2fd] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: In
INFO [2014-03-05 09:16:19] [15297] Error: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=6&period=year&date=last7&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:02] [0134d] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO VisitsSummary[2014-03-05 09:16:02] [0134d] Purging temporary archives: skipped.</pre>a:7:{i:2008;i:0;i:2009;i:0;i:2010;i:0;i:2011;i:0;i:2012;i:0;i:2013;d:577;i:2014;d:67;}'
INFO [2014-03-05 09:16:19] [15297] Error: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=7&period=week&date=last260&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO VisitsSummary[2014-03-05 09:16:03] [7782b] Purging temporary archives: skipped.</pre><pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:03] [7782b] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid au
INFO [2014-03-05 09:16:19] [15297] Error: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=7&period=month&date=last52&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:13] [649de] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (u
INFO [2014-03-05 09:16:19] [15297] Error: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=7&period=year&date=last7&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:16:14] [02700] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (usi
INFO [2014-03-05 09:16:19] [15297] 7 total errors during this script execution, please investigate and try and fix these errors
INFO [2014-03-05 09:16:19] [15297] ERROR: 7 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://my.site.org/misc/cron/../../index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=mytoken&trigger=archivephp. Response was '<pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Actions[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'myDBname'@'%' (using password: YES)[28000],  Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]</pre><pre>INFO Referrers[2014-03-05 09:15:49] [0ffec] LOAD DATA INFILE failed... Error was: SQLSTATE[28000


#2

Hatte eben das gleiche Problem. Bei mir hat es geholfen die Zeile …

adapter = PDO_MYSQL

… in der config.ini.php aufzunehmen.


(hpa) #3

Danke, ich hatte denselben Fehler und deine Zeile hat ihn behoben, jetzt ist der Sonntag gerettet;)


(hpa) #4

Zu früh gefreut. Der Fehler tritt nach wie vor auf (beim manuellen Test des Archiving hatte er nur nichts zu tun, deshalb kam hier kein Fehler). Als dann der Cronjob aktiv war, trat prompt auch der Fehler wieder auf.
Könnte evtl. ein GRANT FILE on . TO hilfreich sein, evtl. reicht ein GRANT ALL ON piwik.* TO nicht aus? Ich bin jetzt wieder auf meine Vorgängerversion zurückgegangen, weil die Datenmengen recht groß sind und ich nicht allzu viel Zeit mit dem nachträglichen Import der Logs verbringen möchte.


#5

Bei mir tritt der Fehler inzwischen auch wieder auf. Das war nicht die Lösung.


(n00bster) #6

der Fehler ist bei mir auch wieder da, hatte schon vor den Hinweis von Frank die Config um den Adapter Eintrag erweitert aber eben auch nur mit einem Teilerfolg.
So wie es aber aussieht geht bei mir aber nichts an Daten verloren, ich werde derweil mal noch bei dieser Version bleiben. Oder gibt es bei euch gröbere Fehler?


#7

Bis auf die Fehlermeldungen scheint die 2.1 bei mir zu funktionieren.

Ich habe heute noch etwas rumprobiert und den mysqli-Adapter verwendet - seit ein paar Stunden läuft mein Piwik nun ohne Fehlermeldungen.

In der config.ini.php:
adapter = MYSQLI

Zusätzlich habe ich das Verzeichnis “assets” und “templates_c” (beide im temp Verzeichnis) geleert.


(hpa) #8

ich denke, dass der Fehler kommt, wenn der Archive.php Cronjob auf einem anderen Rechner läuft als die Datenbank (viele haben wohl Piwik und Datenbank auf demselben Server). Leider habe ich noch nicht herausgefunden, wie man Piwik mitteilt, kein LOAD DATA INFILE zu benutzen bzw. wie man ihm sagt, dass das Script NICHT auf dem DB Server läuft…


#9

Hat schon jemand eine Lösung?
Es ging doch jahrelang prima, wieso ändert man so eine wichtige Funktion fundamental?


(n00bster) #10

Bei mir war der “config” Zeileneintrag "adapter = MYSQLI " überhaupt nicht vorhanden, das macht es beim Updaten natürlich schon schwieriger den Fehler zu finden. Hier sollte man sich vielleicht was einfallen lassen wie man neue Flags in der Config zu der Bestehenden Config hinzu fügen könnte (oder eben darauf hinweisen).


(Peterbo) #11

Bitte mal versuchen, die Option


[log]
log_writers[] = file

in der config.ini.php zu setzen. Funktioniert dann alles?


#12

Sieht sehr gut aus,


[log]
log_writers[] = file

… scheint das Problem wirklich zu lösen. Klasse, besten Dank.


(n00bster) #13

@Peter Boehlke

der [log] Eintrag sieht gut aus, keine Fehler mehr bei mir in der Cronjob Abarbeitung.
Einzig was noch nervt ist die automatische Erstellung der .htaccess Datei im “misc” Ordner > aber hierzu gibt es schon einen Thread.