Page 1 of 1

Failed to connect to database

Posted: Sun Apr 20, 2014 1:34 pm
by 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 ^_^

Re: Failed to connect to database

Posted: Sun Apr 20, 2014 4:19 pm
by 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.

Re: Failed to connect to database

Posted: Mon Apr 21, 2014 12:38 am
by 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 :D