mysql connection prob fresh install

Customer support forums for Atomic Protector (formerly Atomic Secured Linux). There is no such thing as a bad question here as long as it pertains to using Atomic Protector. Newbies feel free to get help getting started or asking questions that may be obvious. Regular users are asked to be gentle. :-)
DarkF@der
Forum Regular
Forum Regular
Posts: 313
Joined: Thu May 07, 2009 12:46 pm

mysql connection prob fresh install

Unread post by DarkF@der »

Hello,

I have created a new VPS fresh install of plesk 12.5
Plesk is running fine and i want to install ASL.

When installing i get this error:

Warning: mysql_connect(): failed to connect to db on 127.0.0.1: Host '127.0.0.1' is not allowed to connect to this MySQL server in component/c_asl_mysql.php on line 5
-------------------------------------------------------------------------------
Errors were encountered:

L CODE SOURCE MESSAGE
- ---- ----------------------------- ------------------------------------------
2 800 c_asl::blocklist_get Errors occurred with ASL DB Rotate
2 61 c_asl::blocklist_get Failed to connect to database ''
2 800 c_web::validate Errors occurred with ASL DB Rotate
3 61 c_web::validate Failed to connect to database ''

Checking versions ...

ASL version is current: [PASS]
Updating Application Inventory database to 201502271124: updated [PASS]
Updating Malware/Rootkit rules to 201511251053: updated [PASS]
Updating Threat Intelligence database to 201511261239: updated [PASS]
Updating database: this may take several minutes
ERROR 1130 (HY000): Host '127.0.0.1' is not allowed to connect to this MySQL server
Reloading Threat database: complete [PASS]
Updating Web Application Firewall to 201511261243: updated [PASS]
Updating Host Intrusion Prevention to 201511091720: updated [PASS]
Updating database: this may take several minutes
Update: complete [PASS]
Updating Self Healing modules: updated [PASS]
Updating Brute Force Protection: updated [PASS]
Updating Rootkit Protection: updated [PASS]
Restarting Apache ...
Generating report ...

Finished

if i look in the mysql:

mysql --user=admin --password=`cat /etc/psa/.psa.shadow`
mysql> SELECT host FROM mysql.user WHERE User = 'admin';
+-----------+
| host |
+-----------+
| localhost |
+-----------+
1 row in set (0.00 sec)

If i try to add 127.0.0.1 i will get:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1';
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

:oops: :oops: :oops:

SHOW GRANTS FOR 'admin'@'localhost'\G
*************************** 1. row ***************************
Grants for admin@localhost: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'admin'@'localhost' IDENTIFIED BY PASSWORD '*FD72DF55EC26EA5ED5A3EEF1F1CEEAF118D41616' WITH GRANT OPTION
1 row in set (0.00 sec)


is this someting new from plesk? AKA Odin? How to fix it?
I'm running centos 6.7 on this machine.

Greetz
Post Reply