PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user...... about aowow HOT 14 CLOSED

'woltk'@'localhost' wrath of lich the king
... sicher..?

Yes very safe and "woltk" is the database username I use the TC WoltK 3.3.5 core

...ganz sicher..?

from aowow.

'woltk'@'localhost'
wrath of lich the king

... sicher..?

from aowow.

'woltk'@'localhost' wrath of lich the king

... sicher..?

Yes very safe and "woltk" is the database username
I use the TC WoltK 3.3.5 core

TrinityCore rev. cb0104ca2988+ 2024-05-05 20:05:15 +0200 (release branch) (Unix, RelWithDebInfo, Static)

Had to switch to Debian 12 to be able to compile the last update
The Last Update require Debian 12

I can successfully execute the test script under the shell. It contains the same access data as I use for your Aowow.
You could also provide me with such a test script to test the database connection, but my script is simple and therefore meaningful enough that the problem is not my fault.

PHP 8.3.6 (cli) (built: Apr 12 2024 12:51:02) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.3.6, Copyright (c) Zend Technologies
with Zend OPcache v8.3.6, Copyright (c), by Zend Technologies

from aowow.

Is this supposed to be a joke?

from aowow.

Is this supposed to be a joke?

Your SQL username is woltk but the correct abbreviation for "Wrath of the Lich King" is wotlk. This might be the spelling mistake that causes your problem.

from aowow.

Your SQL username is woltk but the correct abbreviation for "Wrath of the Lich King" is wotlk. This might be the spelling mistake that causes your problem.

No, it can't because my test script runs the same way and establishes the database connection.

Here are both scripts as a screenshot, they contain the same username

from aowow.

#0 /var/www/vhosts/XXX/XXX/aowow/includes/libs/DbSimple/Mysqli.php(59): mysqli_connect()

In the current version of aowow there is no mysqli_connect() call on that line. See

from aowow.

So you really have an egregious typo in your mysql username and can't be arsed to say: "yes, i have an egregious typo in my mysql username."

does your password contain chars that would be changed by urlencode()

from aowow.

#0 /var/www/vhosts/XXX/XXX/aowow/includes/libs/DbSimple/Mysqli.php(59): mysqli_connect()

In the current version of aowow there is no mysqli_connect() call on that line. See

aowow/includes/libs/DbSimple/Mysqli.php

Line 59 in 937bec3

} else if (isset($dsn['host']) ) {

Can you try updating?

@iTob191

I've now downloaded the latest version, but the error remains. No connection

13:37:30  [ERR]   E_USER_ERROR - Access denied for user 'woltk'@'localhost' (using password: YES) at /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php line 30 @ /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php:89
13:37:30  [ERR]   E_USER_ERROR - Access denied for user 'woltk'@'localhost' (using password: YES) at /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php line 30 @ /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php:89
13:37:30  [ERR]   E_USER_ERROR - Access denied for user 'woltk'@'localhost' (using password: YES) at /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php line 30 @ /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php:89
13:37:30  [ERR]   E_USER_ERROR - Access denied for user 'woltk'@'localhost' (using password: YES) at /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php line 30 @ /var/www/vhosts/XXX/XXX/aowow/includes/database.class.php:89

from aowow.

So you really have an egregious typo in your mysql username and can't be arsed to say: "yes, i have an egregious typo in my mysql username."

does your password contain chars that would be changed by urlencode()

Yes, numbers, letters and special characters like a password should be.

from aowow.

not all special chars would trigger urlencode. Be more speciffic or just remove the function call for yourself.

https://github.com/Sarjuuk/aowow/blob/master/includes/database.class.php#L21

from aowow.

not all special chars would trigger urlencode. Be more speciffic or just remove the function call for yourself.

https://github.com/Sarjuuk/aowow/blob/master/includes/database.class.php#L21

i use letters, numbers and as special character !!

from aowow.

Ok, I have now generated a different password for the user without special characters. The database connection can now be established.

There may be a note in the overview in the instructions that problems can occur with special characters

from aowow.

I pointed you at the probable cause of your issues and instead of confirming whether urlencode is the issue you chose to use an insecure password.

Yeah, i'm done.

from aowow.