Can't start PAndoraFMS 3.2.1

[ofirst]

hi,

I installed openSuSUE 11.4 LINUX with basic system.
Added 5 packages that Pandora server rpm required, and installed PandoraFMS as an rpm.
When I try to start Pandora, I get the message -

"DBI connect ..... failed: can't connect to MYSQL server on x.x.x.x  through socket '/var/run/mysql/mysql.sock' (2)  at /usr/lib/perl5/PandoraFMS/DB.pm line 69"

Any idea what i am missing ?

Thanks for help,

Ofir.

[tpalacios]

Welcome,

Please check these lines in your server config file, located in /etc/pandora/pandora_server.conf by default:

Code:

# Database credentials. A VERY important configuration.
# This must be the same credentials used by your Pandora FMS Console
# but could be different if your console is not running in the same
# host than the server. Check your console setup in /include/config.php

# dbname: Database name (pandora by default

dbname pandora

# dbuser:  Database user name (pandora by default)

dbuser pandora

# dbpass: Database password

dbpass yourpass

# dbhost: Database hostname or IP address

dbhost yourhost

Compare this pass with the pass included in /srv/www/htdocs/pandora/include/config.php (this is the absolute path of /include/config.php by default in openSuSE)

If they're not the same, replace the pass in the pandora_server.conf with the one in /include/config.php

Else, also check you are using the right address for your database (if your pandora database and your pandora server are located in the same machine, dbhost should be localhost)

If your problem persists, please activate verbosity 10 option (located right below the code I've just posted) so you can get a fully detailed log of these errors.

Attach these logs and provide us with additional info regarding your problem, so we can diagnose your problem more efficiently.

Feel free to add screenshots as well, as long as your remove all the sensitive and personal information you don't want to show.

Greetings.

[ofirst]

Hi,
Thanks for your help !
Because I installed a minimal system, I forgot to install some important  packages,  so I don't have the file you mentioned " /srv/www/htdocs/pandora/include/config.php " .

Could you mention the most important packages  to include in the installation, so the Pandora server  would work  when installed as one server, on a running SuSE system  ?

Thx again,

Ofir
 

[tpalacios]

Sure! ;)

Here you are:

Installing Pandora FMS on SuSE

Regards.

[ofirst]

Hi,

Still not working..... :(
I have installed all packages for openSuSE 11.4.
I have Apache2 server (httpd2) running.
I have MySQL database running.
I have tentacle server running.

I installed the Pandora_console --> but I have problems with the connection to the data base.
I installed th pandora server, and when I started it, I got the errors with the connection to the data base.
I don't have a file   "/srv/www/htdocs/pandora/include/config.php"    for some reason ....(?)
I attach print screen from my installation  process.

Thanks for hlping me.

Ofir.

[tpalacios]

Code:

find / | grep /include/config.php

Write this to find out where your /include/config.php is located.

Once you find it, open it and compare it with the pandora_server.conf dbpass field like I told you before.

Other than that, you must keep in mind the order of installation should be:

1st) Pandora Console
2nd) Pandora Server

Otherwise you will have this problem again.

Try doing:

Code:

sudo mysql -u pandora -p

And write the password you have in /include/config.php

It should let you access the database... Otherwise you should change your pandora dbpass.

Regards.

[ofirst]

Hi,

As I wrote before -  for some reason I don't have the file  /include/config.php   on the system.
I tried your command,  and also:  "find  /   -name  config.php -print "    - nothing found !
Some package maybe not installed correctly ...?

I installed the Pandora server even when the Pandora console did not  finish installation correctly.

Any idea ? , should I  uninstall the Pandora server?
Any way - may be I need to install other  php  packages ?

Thanks.

[tpalacios]

Best way would be to uninstall server and console and follow the installation manual.

Code:

rpm -e pandorafms_agent
rpm -e pandorafms_console
rpm -e pandorafms_server

If your problem persists even installing it step by step like the manual says... please provide us detailed information and some screenshots regarding how did you install it to see if there's something missing.

Before installing anything, make sure you have installed ALL the repositories needed.

And never install Pandora Server without making sure your Pandora Console has been installed successfully.

Greetings.