installation

dmac

Hi,
I am on the install page: www...../setup/install.php
After completing all the steps, and db account details etc.
I keep getting this error on install:

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'userXXXXX'@'localhost' (using password: YES) in /home/XXX/public_html/include/mysqli.php:69 Stack trace: #0 /home/XXX/public_html/include/mysqli.php(69): mysqli->real_connect() #1 /home/XXX/public_html/setup/inc/class.installer.php(94): db_connect() #2 /home/XXX/public_html/setup/install.php(52): Installer->install() #3 {main} thrown in /home/XXX/public_html/include/mysqli.php on line 69

bootstrap.php:
ini_set('display_errors',1);
ini_set('display_startup_errors',1);

Ful privileges are already set on that user, for that db.
This was using the default php extensions, but after issues, i tried to disable some, to see if it made any difference.
mysqli
mysqlnd
nd_mysqli
nd_pdo_mysql
pdo
pdo_mysql

Im thinking some php extensions be be interfering?
I've tried disabling some, can anyone advice?
This is on a fresh cPanel account, on cloudlinux.
osTicket v1.18.2
PHP 8.2

Thank you.

KevinTheJedi

dmac

I do not believe it is related to any plugins, etc. The error states Access denied for user 'userXXXXX'@'localhost' (using password: YES). This simply means the given credentials were incorrect. Now if you know for 100% certain that the credentials are correct then it's likely you are not using MySQL native password. You see, osTicket doesn't support the latest encrypted type password from MySQL; instead it requires the original native password format. All that to say if you are using the latest password format you simply need to convert the password back to mysql_native_password.

Cheers.