Failed to connect to database

[malldom]

Good day,

I have been using ASL for a year now and today after formatting my server and re-installing ASL, i was unable to connect to the ASL web console.

upon opening the site i get the following issue

Code: Select all

9998	4	ASLW::init	Defined constants	(debug output)

61	3	ASLW::init	Failed to connect to database '(1045) Access denied for user '*****'@'localhost' (using password: YES)'	

Warning: ASLW::app_exit(): Couldn't fetch mysqli in /var/asl/www/lib/php/ASLW.php on line 213

Warning: mysqli::kill(): Couldn't fetch mysqli in /var/asl/www/lib/php/ASLW.php on line 213

Warning: mysqli::close(): Couldn't fetch mysqli in /var/asl/www/lib/php/ASLW.php on line 214
3

I checked the config in '/etc/asl/config' and everything seems normal.

Also, when i run the 'aum upgrade' i get the following error

Errors were encountered:

L CODE SOURCE MESSAGE
- ---- ----------------------------- ------------------------------------------
2 5 AUM::upgrade Failed to delete file /var/asl/data/updates-data
2 9901 ASLCommon::cmd_system ERROR: '/var/asl/bin/load-geoip-db (1)'

Appreciate your assistance and i want to thank you for such an awesome product that i'm glad to have gotten ^_^

[scott]

Looks like the username & password there arent valid. You could re-initialize the DB with:

/var/asl/bin/database-setup

It should prompt you for admin credentials to reset the account.

[malldom]

Hey scott,

I tried running the database-setup command and it informed me the 'password' contained characters other than numbers and letters (im surprised it didn't display that issue when the error first showed up, maybe something that can be added for future versions?) so I changed the password to an accepted one and now it works.

Thanks for your assistance