Installed ASL and got the following error when going to https://YOUR_SERVERS_IP:30000

Fatal error(s) have been encountered.

Time Source Error
21:36:11 PGUICommon::define_base_configuration DEBUG: Loaded base config data
21:36:11 FATAL init Could not establish mysql connection
Access denied for user 'tortix'@'localhost' (using password: YES)

Well to tell you the truth I've enabled mysql and selected a password ASL didn't like ending with "!"

Then tried to run the Configure/Re-Configure ASL again
# asl -c

Disabled mysql by selecting "no"

# reboot

Same error when i go to https://YOUR_SERVERS_IP:30000

Just to mention before i did all the above i also tried:

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('MY_NEW_PASSWORD') where USER='tortix'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit

# service mysql restart

I've tried to search the forum for the answer with no success...

Please help
thx

You must have mysql support enabled to use the ASL GUI. Disabling mysql is there for users that dont use the GUI.

Enable mysql on install, and run the installer again.

I get the following from the re-install

The OSSEC database password is already set
Error: Your OSSEC database password must consist of only letters and numbers.

Could you please let me know where to change this?

Thank you for the help

I tried this now:

mysql -u root -p
MYSQL ROOT PASSWORD
grant INSERT,SELECT,UPDATE,CREATE,DELETE,EXECUTE on tortix.* to tortix@127.0.0.1;
set password for tortix@127.0.0.1=PASSWORD('MYNEWPASSWORD');
flush privileges;
quit

/etc/init.d/mysqld restart

Same error please help

All good now

# yum remove asl

Re-installed ASL

Just a post for someone else, when you enable mysql in asl -c don't use other characters (ONLY LETTERS AND NUMBERS ARE ALLOWED)

The installation never mentioned that when you type your password....

J