@Solaris42 opened this Issue on November 29th 2019

Hi,

since the last update all cronjob are not working to archive the reports.
Also all outgoing links are not tracked.
If I user toe option “archive the report while using browser” i get this error message:
Access denied for user ‘dbxxxxxx’@’%’ to database ‘dbxxxxxx’ - in plugin Goals

As I finde out while covering database to new version or in archive.php the correctly server address is Not taken. ----‘dbxxxx’@‘%’----- right should be -----dbxxxx’@‘localhost’----
Some bug read instead of host name "%"!
If I downgraded to 3.11 and all is working fine!

Cheers
Ralf

@tsteur commented on November 29th 2019 Member

Do you know if you are using Mysqli or PDO? Have you maybe configured a socket?

@Solaris42 commented on November 29th 2019

Hi Thomas,

I’m using Mysqli.

Regards
Ralf

Am 29.11.2019 um 08:56 schrieb Thomas Steur <notifications@github.com>:

Do you know if you are using Mysqli or PDO? Have you maybe configured a socket?


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub https://github.com/matomo-org/matomo/issues/15206?email_source=notifications&email_token=AN47HM4W6JXZTZXK2YNFKJLQWDDL7A5CNFSM4JS4AYV2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFOEOKA#issuecomment-559695656, or unsubscribe https://github.com/notifications/unsubscribe-auth/AN47HM4T3MHU2UIWMEGJOR3QWDDL7ANCNFSM4JS4AYVQ.


Ralf Siedhoff - Musician - Composer
Döllstädtstraße 13 | 99423 Weimar
Mobil: 0(049)177-2010114 | Fon: 0(049) 3643-216939
E-Mail: r.sie@gmx.de
Internet: www.ralf-siedhoff.de | www.bosque-magico.de
new videos on youtube -
https://www.youtube.com/channel/UCkwKpJ0Dt9MEBj7poy8jRvA

Out now: New Album „Tu Tiempo“, available here:

Spotify: https://open.spotify.com/album/1WIwMUTUB0NXqFzKklApZB?si=eMDrQ-gkTHO6Cqd2YrwFtQ
iTunes & Apple Music - https://itunes.apple.com/us/album/tu-tiempo/1438566282?ls=1&app=itunes
Amazon - https://www.amazon.de/Bosque-Mágico-Tiempo-Ralf-Siedhoff/dp/B07JVF7MD9/ref=sr_1_9?ie=UTF8&qid=1540541936&sr=8-9&keywords=Bosque+Magico
Amazon Music - https://www.amazon.de/Bosque-Mágico-Tu-Tiempo/dp/B07L1B9LL2/ref=sr_1_1?ie=UTF8&qid=1546876278&sr=8-1&keywords=tu+tiempo
JPC - https://www.jpc.de/jpcng/classic/detail/-/art/bosque-magico-tu-tiempo/hnum/8789330
HRA - https://www.highresaudio.com/de/album/view/mtqnd7/bosque-ma-gico-tu-tiempo

@tsteur commented on November 29th 2019 Member

Can you check your config/config.php file if there is a socket configured for the database?

@Solaris42 commented on November 29th 2019

Hi Thomas,

I don’t find it!
Here my Config:

; <?php exit; ?> DO NOT REMOVE THIS LINE
; file automatically generated or modified by Matomo; you can manually override the default values in global.ini.php by redefining them in this file.
[database]
host = "mysql.localhost"
username = „xxxxxxx"
password = "xxxxxxx"
dbname = "xxxxxxx"
tablesprefix = "piwik"
adapter = "MYSQLI"

[General]
assume_secure_protocol = 1
proxy_client_headers[] = "HTTP_X_FORWARDED_FOR"
salt = „xxxxxxxxxxx"
trusted_hosts[] = "www.wavelogo.de"
force_ssl = 1

[PluginsInstalled]
PluginsInstalled[] = "Diagnostics"
PluginsInstalled[] = "Login"
PluginsInstalled[] = "CoreAdminHome"
PluginsInstalled[] = "UsersManager"
PluginsInstalled[] = "SitesManager"
PluginsInstalled[] = "Installation"
PluginsInstalled[] = "Monolog"
PluginsInstalled[] = "Intl"
PluginsInstalled[] = "CorePluginsAdmin"
PluginsInstalled[] = "CoreHome"
PluginsInstalled[] = "WebsiteMeasurable"
PluginsInstalled[] = "IntranetMeasurable"
PluginsInstalled[] = "CoreVisualizations"
PluginsInstalled[] = "Proxy"
PluginsInstalled[] = "API"
PluginsInstalled[] = "ExamplePlugin"
PluginsInstalled[] = "Widgetize"
PluginsInstalled[] = "Transitions"
PluginsInstalled[] = "LanguagesManager"
PluginsInstalled[] = "Actions"
PluginsInstalled[] = "Dashboard"
PluginsInstalled[] = "MultiSites"
PluginsInstalled[] = "Referrers"
PluginsInstalled[] = "UserLanguage"
PluginsInstalled[] = "DevicesDetection"
PluginsInstalled[] = "Goals"
PluginsInstalled[] = "Ecommerce"
PluginsInstalled[] = "SEO"
PluginsInstalled[] = "Events"
PluginsInstalled[] = "UserCountry"
PluginsInstalled[] = "GeoIp2"
PluginsInstalled[] = "VisitsSummary"
PluginsInstalled[] = "VisitFrequency"
PluginsInstalled[] = "VisitTime"
PluginsInstalled[] = "VisitorInterest"
PluginsInstalled[] = "ExampleAPI"
PluginsInstalled[] = "RssWidget"
PluginsInstalled[] = "Feedback"
PluginsInstalled[] = "TwoFactorAuth"
PluginsInstalled[] = "CoreUpdater"
PluginsInstalled[] = "CoreConsole"
PluginsInstalled[] = "ScheduledReports"
PluginsInstalled[] = "UserCountryMap"
PluginsInstalled[] = "Live"
PluginsInstalled[] = "CustomVariables"
PluginsInstalled[] = "PrivacyManager"
PluginsInstalled[] = "ImageGraph"
PluginsInstalled[] = "Annotations"
PluginsInstalled[] = "MobileMessaging"
PluginsInstalled[] = "Overlay"
PluginsInstalled[] = "SegmentEditor"
PluginsInstalled[] = "Insights"
PluginsInstalled[] = "Morpheus"
PluginsInstalled[] = "Contents"
PluginsInstalled[] = "BulkTracking"
PluginsInstalled[] = "Resolution"
PluginsInstalled[] = "DevicePlugins"
PluginsInstalled[] = "Heartbeat"
PluginsInstalled[] = "Marketplace"
PluginsInstalled[] = "ProfessionalServices"
PluginsInstalled[] = "UserId"
PluginsInstalled[] = "CustomPiwikJs"
PluginsInstalled[] = "Tour"

Am 29.11.2019 um 09:48 schrieb Thomas Steur <notifications@github.com>:

socket


Ralf Siedhoff - Musician - Composer
Döllstädtstraße 13 | 99423 Weimar
Mobil: 0(049)177-2010114 | Fon: 0(049) 3643-216939
E-Mail: r.sie@gmx.de
Internet: www.ralf-siedhoff.de | www.bosque-magico.de
new videos on youtube -
https://www.youtube.com/channel/UCkwKpJ0Dt9MEBj7poy8jRvA

Out now: New Album „Tu Tiempo“, available here:

Spotify: https://open.spotify.com/album/1WIwMUTUB0NXqFzKklApZB?si=eMDrQ-gkTHO6Cqd2YrwFtQ
iTunes & Apple Music - https://itunes.apple.com/us/album/tu-tiempo/1438566282?ls=1&app=itunes
Amazon - https://www.amazon.de/Bosque-Mágico-Tiempo-Ralf-Siedhoff/dp/B07JVF7MD9/ref=sr_1_9?ie=UTF8&qid=1540541936&sr=8-9&keywords=Bosque+Magico
Amazon Music - https://www.amazon.de/Bosque-Mágico-Tu-Tiempo/dp/B07L1B9LL2/ref=sr_1_1?ie=UTF8&qid=1546876278&sr=8-1&keywords=tu+tiempo
JPC - https://www.jpc.de/jpcng/classic/detail/-/art/bosque-magico-tu-tiempo/hnum/8789330
HRA - https://www.highresaudio.com/de/album/view/mtqnd7/bosque-ma-gico-tu-tiempo

@tassoman commented on November 29th 2019 Contributor

host = "mysql.localhost"

Looks like should be only localhost

@tsteur commented on November 29th 2019 Member

@Solaris42 any chance you could change this line https://github.com/matomo-org/matomo/pull/15166/files#diff-eda1d8d06c3a480082a428c24cebf762R349 in libs/Zend/Db/Adapter/Mysqli.php to $socket = null; just for a test?

I doubt it will make a difference but that's the only change I can think of so far that may cause this. Have you tried if it works with 3.12? I suppose you did update to 3.13 originally?

@Solaris42 commented on November 29th 2019

Hi Thomas,

this is the line in my Mysqli.php:

    $_isConnected = <a class='mention' href='https://github.com/mysqli_real_connect'>@mysqli_real_connect</a>(
        $this->_connection,
        $this->_config['host'],
        $this->_config['username'],
        $this->_config['password'],
        $this->_config['dbname'],
        $port,
        $socket = null,
        $enable_ssl ? $flags : null
    );

should I change to:

$socket = !empty($this->_config['unix_socket']) ? $this->_config['unix_socket'] : null;
// Suppress connection warnings here.
// Throw an exception instead.
$_isConnected = @mysqli_real_connect(
$this->_connection,
$this->_config['host'],
$this->_config['username'],
$this->_config['password'],
$this->_config['dbname'],
$port,
$socket = null,
$socket,
$enable_ssl ? $flags : null
);

I will have not really time the next days to check this, because I have o install a dummy version with 3.12. with a copy of the database because downgrading I need to change back some parameters in Database.
Now It’s working fine after downgrading to 3.11.!
Perhaps beginning of next week I can check this out!

Thanks

Ralf

Am 29.11.2019 um 21:55 schrieb Thomas Steur <notifications@github.com>:

$socket = null


Ralf Siedhoff - Musician - Composer
Döllstädtstraße 13 | 99423 Weimar
Mobil: 0(049)177-2010114 | Fon: 0(049) 3643-216939
E-Mail: r.sie@gmx.de
Internet: www.ralf-siedhoff.de | www.bosque-magico.de
new videos on youtube -
https://www.youtube.com/channel/UCkwKpJ0Dt9MEBj7poy8jRvA

Out now: New Album „Tu Tiempo“, available here:

Spotify: https://open.spotify.com/album/1WIwMUTUB0NXqFzKklApZB?si=eMDrQ-gkTHO6Cqd2YrwFtQ
iTunes & Apple Music - https://itunes.apple.com/us/album/tu-tiempo/1438566282?ls=1&app=itunes
Amazon - https://www.amazon.de/Bosque-Mágico-Tiempo-Ralf-Siedhoff/dp/B07JVF7MD9/ref=sr_1_9?ie=UTF8&qid=1540541936&sr=8-9&keywords=Bosque+Magico
Amazon Music - https://www.amazon.de/Bosque-Mágico-Tu-Tiempo/dp/B07L1B9LL2/ref=sr_1_1?ie=UTF8&qid=1546876278&sr=8-1&keywords=tu+tiempo
JPC - https://www.jpc.de/jpcng/classic/detail/-/art/bosque-magico-tu-tiempo/hnum/8789330
HRA - https://www.highresaudio.com/de/album/view/mtqnd7/bosque-ma-gico-tu-tiempo

@tsteur commented on November 29th 2019 Member

It seems like you are still using Matomo 3.12 actually so what I thought would be the issue doesn't seem to be the issue

@mattab commented on December 5th 2019 Member

If you have this issue please check that your Mysql user has the CREATE TEMPORARY TABLES permission / grant, see for example the GRANT query in https://matomo.org/faq/how-to-install/faq_23484/

-> Can you please confirm if you still have the issue after adding CREATE TEMPORARY TABLES permission?

fyi we'll hopefully make this error message more clear in the future https://github.com/matomo-org/matomo/issues/15237

@Solaris42 commented on December 8th 2019

Hi Thomas,

so success. I tried with a upgrade to 3.13. with a dummy database….get the das error:
Access denied for user ‘dbxxxxxx’@’%’ to database ‘dbxxxxxx’ - in plugin Goals

It’s only working with version 13.11. after upgrade not….

Have a nice Day

Ralf

Am 30.11.2019 um 00:12 schrieb Ralf Siedhoff <r.sie@gmx.de>:

Hi Thomas,

this is the line in my Mysqli.php:

    $_isConnected = <a class='mention' href='https://github.com/mysqli_real_connect'>@mysqli_real_connect</a>(
        $this->_connection,
        $this->_config['host'],
        $this->_config['username'],
        $this->_config['password'],
        $this->_config['dbname'],
        $port,
        $socket = null,
        $enable_ssl ? $flags : null
    );

should I change to:

$socket = !empty($this->_config['unix_socket']) ? $this->_config['unix_socket'] : null;
// Suppress connection warnings here.
// Throw an exception instead.
$_isConnected = @mysqli_real_connect(
$this->_connection,
$this->_config['host'],
$this->_config['username'],
$this->_config['password'],
$this->_config['dbname'],
$port,
$socket = null,
$socket,
$enable_ssl ? $flags : null
);

I will have not really time the next days to check this, because I have o install a dummy version with 3.12. with a copy of the database because downgrading I need to change back some parameters in Database.
Now It’s working fine after downgrading to 3.11.!
Perhaps beginning of next week I can check this out!

Thanks

Ralf

Am 29.11.2019 um 21:55 schrieb Thomas Steur <notifications@github.com <mailto:notifications@github.com>>:

$socket = null


Ralf Siedhoff - Musician - Composer
Döllstädtstraße 13 | 99423 Weimar
Mobil: 0(049)177-2010114 | Fon: 0(049) 3643-216939
E-Mail: r.sie@gmx.de <mailto:r.sie@gmx.de>
Internet: www.ralf-siedhoff.de | www.bosque-magico.de
new videos on youtube -
https://www.youtube.com/channel/UCkwKpJ0Dt9MEBj7poy8jRvA

Out now: New Album „Tu Tiempo“, available here:

Spotify: https://open.spotify.com/album/1WIwMUTUB0NXqFzKklApZB?si=eMDrQ-gkTHO6Cqd2YrwFtQ
iTunes & Apple Music - https://itunes.apple.com/us/album/tu-tiempo/1438566282?ls=1&app=itunes
Amazon - https://www.amazon.de/Bosque-Mágico-Tiempo-Ralf-Siedhoff/dp/B07JVF7MD9/ref=sr_1_9?ie=UTF8&qid=1540541936&sr=8-9&keywords=Bosque+Magico
Amazon Music - https://www.amazon.de/Bosque-Mágico-Tu-Tiempo/dp/B07L1B9LL2/ref=sr_1_1?ie=UTF8&qid=1546876278&sr=8-1&keywords=tu+tiempo
JPC - https://www.jpc.de/jpcng/classic/detail/-/art/bosque-magico-tu-tiempo/hnum/8789330
HRA - https://www.highresaudio.com/de/album/view/mtqnd7/bosque-ma-gico-tu-tiempo


Ralf Siedhoff - Musician - Composer
Döllstädtstraße 13 | 99423 Weimar
Mobil: 0(049)177-2010114 | Fon: 0(049) 3643-216939
E-Mail: r.sie@gmx.de
Internet: www.ralf-siedhoff.de | www.bosque-magico.de
new videos on youtube -
https://www.youtube.com/channel/UCkwKpJ0Dt9MEBj7poy8jRvA

Out now: New Album „Tu Tiempo“, available here:

Spotify: https://open.spotify.com/album/1WIwMUTUB0NXqFzKklApZB?si=eMDrQ-gkTHO6Cqd2YrwFtQ
iTunes & Apple Music - https://itunes.apple.com/us/album/tu-tiempo/1438566282?ls=1&app=itunes
Amazon - https://www.amazon.de/Bosque-Mágico-Tiempo-Ralf-Siedhoff/dp/B07JVF7MD9/ref=sr_1_9?ie=UTF8&qid=1540541936&sr=8-9&keywords=Bosque+Magico
Amazon Music - https://www.amazon.de/Bosque-Mágico-Tu-Tiempo/dp/B07L1B9LL2/ref=sr_1_1?ie=UTF8&qid=1546876278&sr=8-1&keywords=tu+tiempo
JPC - https://www.jpc.de/jpcng/classic/detail/-/art/bosque-magico-tu-tiempo/hnum/8789330
HRA - https://www.highresaudio.com/de/album/view/mtqnd7/bosque-ma-gico-tu-tiempo

@tsteur commented on December 8th 2019 Member

@Solaris42 I'm quite certain this is due to missing 'create temporary table' permission on your mysql user. Have a look at https://github.com/matomo-org/matomo/issues/15237

Let me know if this doesn't help you but adding this permission should fix the issue

@Solaris42 commented on December 9th 2019

Hi Thomas,

this is confusing me. You wrote
"@Solaris42 https://github.com/Solaris42 I'm quite certain this is due to missing 'create temporary table' permission on your mysql user. Have a look at #15237 https://github.com/matomo-org/matomo/issues/15237
But this feature will be removed soon from MySQL…..
I contact my web host to get the information about the mysql permission.
As I understand matomo changed the database handling with update to 3.12.? Because with version 3.11. all is working well.
If not, my logic tell me, its seems to be a bug…...

Regards Ralf

Am 08.12.2019 um 19:53 schrieb Thomas Steur <notifications@github.com>:

create temporary table


Ralf Siedhoff - Musician - Composer
Döllstädtstraße 13 | 99423 Weimar
Mobil: 0(049)177-2010114 | Fon: 0(049) 3643-216939
E-Mail: r.sie@gmx.de
Internet: www.ralf-siedhoff.de | www.bosque-magico.de
new videos on youtube -
https://www.youtube.com/channel/UCkwKpJ0Dt9MEBj7poy8jRvA

Out now: New Album „Tu Tiempo“, available here:

Spotify: https://open.spotify.com/album/1WIwMUTUB0NXqFzKklApZB?si=eMDrQ-gkTHO6Cqd2YrwFtQ
iTunes & Apple Music - https://itunes.apple.com/us/album/tu-tiempo/1438566282?ls=1&app=itunes
Amazon - https://www.amazon.de/Bosque-Mágico-Tiempo-Ralf-Siedhoff/dp/B07JVF7MD9/ref=sr_1_9?ie=UTF8&qid=1540541936&sr=8-9&keywords=Bosque+Magico
Amazon Music - https://www.amazon.de/Bosque-Mágico-Tu-Tiempo/dp/B07L1B9LL2/ref=sr_1_1?ie=UTF8&qid=1546876278&sr=8-1&keywords=tu+tiempo
JPC - https://www.jpc.de/jpcng/classic/detail/-/art/bosque-magico-tu-tiempo/hnum/8789330
HRA - https://www.highresaudio.com/de/album/view/mtqnd7/bosque-ma-gico-tu-tiempo

@tsteur commented on December 9th 2019 Member

As I understand matomo changed the database handling with update to 3.12.? Because with version 3.11. all is working well.

Exactly, we changed this in 3.12 to fix a bug in Matomo and to improve performance. There is a workaround otherwise see https://github.com/matomo-org/matomo/issues/15130#issuecomment-551252343

@Solaris42 commented on December 9th 2019

Hi Thomas,

so my web host changed this database setup to 'create temporary table' permission on your mysql user. It’s not standard setup.
But since this change all is working fine!
So perhaps you shout give more clear informations about such deep changes in future.
Usually I trust blind the updates…

But anyway , it’s working now! Thanks for your help!

Ralf

Am 09.12.2019 um 08:24 schrieb Thomas Steur <notifications@github.com>:

As I understand matomo changed the database handling with update to 3.12.? Because with version 3.11. all is working well.

Exactly, we changed this in 3.12 to fix a bug in Matomo and to improve performance. There is a workaround otherwise see #15130 (comment) https://github.com/matomo-org/matomo/issues/15130#issuecomment-551252343

You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub https://github.com/matomo-org/matomo/issues/15206?email_source=notifications&email_token=AN47HM3O4OTGUJTMFO3EEL3QXXXDTA5CNFSM4JS4AYV2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEGIDXCI#issuecomment-563100553, or unsubscribe https://github.com/notifications/unsubscribe-auth/AN47HM3GJRGU5LSDMJOO2STQXXXDTANCNFSM4JS4AYVQ.


Ralf Siedhoff - Musician - Composer
Döllstädtstraße 13 | 99423 Weimar
Mobil: 0(049)177-2010114 | Fon: 0(049) 3643-216939
E-Mail: r.sie@gmx.de
Internet: www.ralf-siedhoff.de | www.bosque-magico.de
new videos on youtube -
https://www.youtube.com/channel/UCkwKpJ0Dt9MEBj7poy8jRvA

Out now: New Album „Tu Tiempo“, available here:

Spotify: https://open.spotify.com/album/1WIwMUTUB0NXqFzKklApZB?si=eMDrQ-gkTHO6Cqd2YrwFtQ
iTunes & Apple Music - https://itunes.apple.com/us/album/tu-tiempo/1438566282?ls=1&app=itunes
Amazon - https://www.amazon.de/Bosque-Mágico-Tiempo-Ralf-Siedhoff/dp/B07JVF7MD9/ref=sr_1_9?ie=UTF8&qid=1540541936&sr=8-9&keywords=Bosque+Magico
Amazon Music - https://www.amazon.de/Bosque-Mágico-Tu-Tiempo/dp/B07L1B9LL2/ref=sr_1_1?ie=UTF8&qid=1546876278&sr=8-1&keywords=tu+tiempo
JPC - https://www.jpc.de/jpcng/classic/detail/-/art/bosque-magico-tu-tiempo/hnum/8789330
HRA - https://www.highresaudio.com/de/album/view/mtqnd7/bosque-ma-gico-tu-tiempo

This Issue was closed on December 8th 2019
Powered by GitHub Issue Mirror