PHP Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database! SQLSTATE[28000] [1045] Access denied for user 'phpipam'@'localhost' (using password: YES)' in /var/www/html/phpipam/functions/classes/class.PDO.php:159

[bhanuprasadanukonti]

We are trying to do Automatic host availability and discovery check by following this document https://phpipam.net/news/automatic-host-availability-check/.

Here is the full error related to php script:

/usr/bin/php /var/www/html/phpipam/functions/scripts/pingCheck.php PHP Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database! SQLSTATE[28000] [1045] Access denied for user 'phpipam'@'localhost' (using password: YES)' in /var/www/html/phpipam/functions/classes/class.PDO.php:159 Stack trace: #0 /var/www/html/phpipam/functions/classes/class.PDO.php(1053): DB->connect() #1 /var/www/html/phpipam/functions/classes/class.PDO.php(298): Database_PDO->connect() #2 /var/www/html/phpipam/functions/classes/class.Common.php(236): DB->escape('id') #3 /var/www/html/phpipam/functions/classes/class.Common.php(411): Common_functions->fetch_object('settings', 'id', 1) #4 /var/www/html/phpipam/functions/classes/class.Log.php(292): Common_functions->get_settings() #5 /var/www/html/phpipam/functions/classes/class.Subnets.php(120): Logging->__construct(Object(Database_PDO)) #6 /var/www/html/phpipam/functions/scripts/pingCheck.php(38): Subnets->__construct(Object(Database_PDO)) #7 {main} thrown in /var/www/html/phpipam/functions/classes/class.PDO.php on line 159

Any help is appreciated.

[NinjaAway]

Hello, I was on the same problem for almost a day... The solution for me was simple, I writted incorrectly the environments variables : IPAM_DATABASE_HOST. Check yours and with that, the name of your value. Is it correct too ? It could be the same with IPAM_DATABASE_PASS. Do not put any quotes on your password. (inside the phpipam-cron container variables)

• IPAM_DATABASE_USER=phpipam
• IPAM_DATABASE_PASS=phpipampassword

Cheers.