1
0
-1
3 answers
- 10-1
It looks like the app cannot connect to the database.
Have you changed your DB credentials? If so, edit /usr/local/open-audit/app/Config/Database.json
If not, are you running PHP between 7.4 and 8.2?
Add your comment... - 10-1
"Access denied for user"...
After you created your db user account, did you grant access to your DB to the user?
If no, see give the user access to the database here: How To Install or Upgrade Open-AudIT (Linux)
Add your comment... - 10-1
Yes of course i did not used default credentials so i changed them after installed open-audit the first time.
Add your comment...
Overview
Content Tools
search
attachments
weblink
advanced
After upgrading from 4.4.2 to 5.0.1 on debian 12 i got "We seem to have hit a snag" message on the UI and the following errors in the log:
ERROR - 2023-11-30 00:58:26 --> Error connecting to the database: mysqli_sql_exception: Access denied for user 'openaudit'@'localhost' (using password: YES) in /usr/local/open-audit/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:185 Stack trace: #0 /usr/local/open-audit/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(185): mysqli->real_connect() #1 /usr/local/open-audit/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect() #2 /usr/local/open-audit/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize() #3 /usr/local/open-audit/app/Config/OpenAudit.php(33): CodeIgniter\Database\BaseConnection->query() #4 /usr/local/open-audit/app/Controllers/BaseController.php(72): Config\OpenAudit->__construct() #5 /usr/local/open-audit/vendor/codeigniter4/framework/system/CodeIgniter.php(892): App\Controllers\BaseController->initController() #6 /usr/local/open-audit/vendor/codeigniter4/framework/system/CodeIgniter.php(485): CodeIgniter\CodeIgniter->createController() #7 /usr/local/open-audit/vendor/codeigniter4/framework/system/CodeIgniter.php(353): CodeIgniter\CodeIgniter->handleRequest() #8 /usr/local/open-audit/public/index.php(84): CodeIgniter\CodeIgniter->run() #9 {main} Next CodeIgniter\Database\Exceptions\DatabaseException: Access denied for user '****'@'localhost' (using password: YES) in /usr/local/open-audit/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:229 Stack trace: #0 /usr/local/open-audit/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect() #1 /usr/local/open-audit/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize() #2 /usr/local/open-audit/app/Config/OpenAudit.php(33): CodeIgniter\Database\BaseConnection->query() #3 /usr/local/open-audit/app/Controllers/BaseController.php(72): Config\OpenAudit->__construct() #4 /usr/local/open-audit/vendor/codeigniter4/framework/system/CodeIgniter.php(892): App\Controllers\BaseController->initController() #5 /usr/local/open-audit/vendor/codeigniter4/framework/system/CodeIgniter.php(485): CodeIgniter\CodeIgniter->createController() #6 /usr/local/open-audit/vendor/codeigniter4/framework/system/CodeIgniter.php(353): CodeIgniter\CodeIgniter->handleRequest() #7 /usr/local/open-audit/public/index.php(84): CodeIgniter\CodeIgniter->run() #8 {main} CRITICAL - 2023-11-30 00:58:26 --> Unable to connect to the database. Main connection [MySQLi]: Access denied for user '****'@'localhost' (using password: YES) in SYSTEMPATH/Database/BaseConnection.php on line 427. 1 SYSTEMPATH/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize() 2 APPPATH/Config/OpenAudit.php(33): CodeIgniter\Database\BaseConnection->query() 3 APPPATH/Controllers/BaseController.php(72): Config\OpenAudit->__construct() 4 SYSTEMPATH/CodeIgniter.php(892): App\Controllers\BaseController->initController() 5 SYSTEMPATH/CodeIgniter.php(485): CodeIgniter\CodeIgniter->createController() 6 SYSTEMPATH/CodeIgniter.php(353): CodeIgniter\CodeIgniter->handleRequest() 7 FCPATH/index.php(84): CodeIgniter\CodeIgniter->run()