Scheduler: Access denied for user ''@'localhost'

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
rvhelp
Posts: 24
Joined: 06 Sep 2022, 08:43

Scheduler: Access denied for user ''@'localhost'

Post by rvhelp » 20 Oct 2022, 11:00

After updating to the latest Aimeos version, this shedular no longer works.

Image
An exception occurred in the driver: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (with password: NO).
Local Configuration:

'DB' => [
'Connections' => [
'Default' => [
'charset' => 'utf8',
'dbname' => 'name',
'driver' => 'mysqli',
'host' => 'localhost',
'password' => 'pw',
'port' => 3306,
'user' => 'name',
],
],
],

User avatar
aimeos
Administrator
Posts: 7896
Joined: 01 Jan 1970, 00:00

Re: Scheduler: Access denied for user ''@'localhost'

Post by aimeos » 20 Oct 2022, 15:26

Did you overwrite the Resources/Private/Config/resource.php file in your project-specific Aimeos TYPO3 extension?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

rvhelp
Posts: 24
Joined: 06 Sep 2022, 08:43

Re: Scheduler: Access denied for user ''@'localhost'

Post by rvhelp » 21 Oct 2022, 07:23

No - if i dump $defaultConnection['user'] or 'dbname' in the aimeos resource.php I get the correct database user and database name.

User avatar
aimeos
Administrator
Posts: 7896
Joined: 01 Jan 1970, 00:00

Re: Scheduler: Access denied for user ''@'localhost'

Post by aimeos » 21 Oct 2022, 07:30

Your "plugin.tx_aimeos.settings.resource.email.*" settings cause this problem because they also replace the existing "resource" config subtree. Use the "Advanced Aimeos scheduler" instead, where you can enter e-mail addresses in separate fields.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

rvhelp
Posts: 24
Joined: 06 Sep 2022, 08:43

Re: Scheduler: Access denied for user ''@'localhost'

Post by rvhelp » 21 Oct 2022, 08:43

In the Advanced Planner, there are no tasks in the selection list?

Image

rvhelp
Posts: 24
Joined: 06 Sep 2022, 08:43

Re: Scheduler: Access denied for user ''@'localhost'

Post by rvhelp » 21 Oct 2022, 09:53

The tasks are missing even if I create a new normal Aimeos task.

User avatar
aimeos
Administrator
Posts: 7896
Joined: 01 Jan 1970, 00:00

Re: Scheduler: Access denied for user ''@'localhost'

Post by aimeos » 21 Oct 2022, 11:05

We don't see that problem in our test installation.
Please check what could be the problem.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

rvhelp
Posts: 24
Joined: 06 Sep 2022, 08:43

Re: Scheduler: Access denied for user ''@'localhost'

Post by rvhelp » 21 Oct 2022, 14:57

Okay, i will try. Could you give me a hint how I could best check this respectively where?

If i disable my plugin extention the list is no longer empty.

User avatar
aimeos
Administrator
Posts: 7896
Joined: 01 Jan 1970, 00:00

Re: Scheduler: Access denied for user ''@'localhost'

Post by aimeos » 24 Oct 2022, 17:24

Maybe your class uses an old method call with is not available any more.
Check the list of breaking changes and adapt your custom code:
https://aimeos.org/docs/latest/changelog/2022.x/
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply