PDA

View Full Version : Installed but cant start > DB Error: connect failed


z3eed
10-30-2008, 01:51 PM
After all is installed and even done the "startup-settings" and plugin confirmation on the web where all seems to work I get this error!

[DB Centreon connexion] DB Error: connect failed

Anyone that can direct me to the issue?
mySQL and Apache2 is working just fine.
During startup-settings it even showed me the tables from the SQL.

Please help me to get it to work.

Regards // z3eed

z3eed
10-30-2008, 04:26 PM
Now I got it to work... I think.

I had to manually change the settings in DBconnect.php and DBOdsConnect.php.

So now I can login.

Now its just to make sure that everything else is working.

Regards // z3eed

z3eed
10-30-2008, 04:28 PM
Had to change the user/passwords manually in DBconnect.php and DBOdsConnect.php.

Lets see if every thing else is working?

Regards // z3eed

xoroz
11-04-2008, 06:59 PM
I just wrote in my blog, the solution to troubleshoot this problem
http://felipeferreira.net/?p=60

Centreon defaults are wrong, so every new install will fail.
Why not change the default parameters of:
ndo2db.cfg
Socket Type: UNIX
Socket Name: /usr/local/nagios/var/ndo.sock
[DATABASE,tab]
change the wrong default (ndo) to nagios
Database Name: nagios

ndomod.cfg
Change to UNIX, and correctly set the Output and Buffer
Output should point to the ndo.sock file (default : /usr/local/nagios/var/ndo.sock )
Buffer should point to ndomod.tmp file (default : /usr/local/nagios/var/ndomod.tmp )

“Connection Error to NDO DataBase !”
1. Check ndomod.cfg, verify the mysql credentials are valid and if user has permissions.
2. Check if the ndo.sock file exists and what PID it has by doing fuser ndo.sock
3. If the ndo.sock has no PID then you probably have ndomod.cfg socket type TCP (WRONG) change it to UNIX and problem solved!
4. Could also be a permission problem on the ndo.sock file.
5. By default Centreon sets ndo to use TCP, it should be UNIX.

more here:
http://felipeferreira.net/?p=60