PipelineFX Forum

Qube! => Installation and Configuration => Topic started by: Scot Brew on August 24, 2009, 09:01:23 PM

Title: Troubleshooting: "Can't Contact Database"
Post by: Scot Brew on August 24, 2009, 09:01:23 PM
If you see this error:
"Can't Contact Database: Host 'localhost.localdomain' is not allowed to connect to this MySQL server"

This error sometimes occurs in a Red Hat installation. The Red Hat host table fully-qualifies localhost as localhost.localdomain, a host that is not in the user database that is installed with MySQL. Follow these instructions:

1.   Login (as root) to the Supervisor host:
# ssh -l root supervisor_host
2.   Access your MySQL server, you may need to enter an admin pass-word:
# mysql --user=root mysql
3.   Grant all privileges to root@localhost.localdomain:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost.localdomain WITH GRANT OPTION;  mysql> quit
4.   Restart the Supervisor:
# /sbin/service supervisor restart