Pandora FMS Community

[SOLVED]Rescon server

Joaquin · 16 jul 2012, 14:26 · 33 mensajes · 100 visitas

  1. Sorry,Click on the message "all servers down" and make a capture of the page it generates. Could you also attach the .log and .error from pandora server which are by default in: /var/log/pandora/pandora_server.log /var/log/pandora/pandora_server.error Regards

  2. Sorry,Click on the message "all servers down" and make a capture of the page it generates.

    The message is:"There are no servers configured into the database"

    Could you also attach the .log and .error from pandora server which are by default in: /var/log/pandora/pandora_server.log /var/log/pandora/pandora_server.error

    /var/log/pandora/pandora_server.log
    2012-07-16 10:45:23 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-16 10:45:23 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-16 10:45:24 nms-EB1501P [V1] [E] 'nms-EB1501P': DBI connect('pandora:localhost:3306','pandora',...) failed: Access denied for user 'pandora'@'localhost' (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 86
    
    2012-07-16 10:45:24 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 10:45:30 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-16 10:45:30 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-16 10:45:30 nms-EB1501P [V1] [E] 'nms-EB1501P': DBI connect('pandora:localhost:3306','pandora',...) failed: Access denied for user 'pandora'@'localhost' (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 86
    
    2012-07-16 10:45:30 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 10:46:11 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-16 10:46:11 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-16 10:46:11 nms-EB1501P [V1] [E] 'nms-EB1501P': DBI connect('pandora:localhost:3306','pandora',...) failed: Access denied for user 'pandora'@'localhost' (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 86
    
    2012-07-16 10:46:11 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 10:51:42 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-16 10:51:42 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-16 11:01:15 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' Shutdown by signal 
    2012-07-16 11:01:22 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-16 11:01:22 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-16 15:19:19 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' Shutdown by signal 
    2012-07-16 15:19:44 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-16 15:19:44 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-16 17:58:28 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' Shutdown by signal 
    2012-07-16 17:58:36 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-16 17:58:36 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-16 18:00:37 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 354.
    
    2012-07-16 18:00:37 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 18:00:38 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 400.
    
    2012-07-16 18:00:38 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 18:00:39 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    
    2012-07-16 18:00:39 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 18:00:39 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    
    2012-07-16 18:00:39 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 18:00:39 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 354.
    
    2012-07-16 18:00:39 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-16 18:00:39 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' Shutdown by signal 
    2012-07-16 18:00:39 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    
    2012-07-16 18:00:39 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:05:09 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-17 09:05:09 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-17 09:22:31 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:22:31 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:22:31 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:22:31 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:22:31 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:22:31 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' Shutdown by signal 
    2012-07-17 09:22:31 nms-EB1501P [V1] [E] 'nms-EB1501P': DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    
    2012-07-17 09:22:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' unhandled error.
    2012-07-17 09:24:50 nms-EB1501P [V1] Launching 4.0.2 120626
    2012-07-17 09:24:50 nms-EB1501P [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'nms-EB1501P'
    2012-07-17 09:40:31 nms-EB1501P [V1] Pandora FMS Server 'nms-EB1501P' Shutdown by signal 
    
    
    /var/log/pandora/pandora_server.error
    2012-07-16 10:45:23 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    DBI connect('pandora:localhost:3306','pandora',...) failed: Access denied for user 'pandora'@'localhost' (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 86
    2012-07-16 10:45:30 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    DBI connect('pandora:localhost:3306','pandora',...) failed: Access denied for user 'pandora'@'localhost' (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 86
    2012-07-16 10:46:11 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    DBI connect('pandora:localhost:3306','pandora',...) failed: Access denied for user 'pandora'@'localhost' (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 86
    2012-07-16 10:51:42 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    sh: 1: kill: No such process
    
    2012-07-16 11:01:22 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    sh: 1: kill: No such process
    
    2012-07-16 15:19:44 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    sh: 1: kill: No such process
    
    2012-07-16 17:58:36 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 354.
    DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 400.
    DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    Perl exited with active threads:
    	11 running and unjoined
    	2 finished and unjoined
    	0 running and detached
    2012-07-17 09:05:09 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::st execute failed: Query execution was interrupted at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 377.
    DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/PandoraFMS/DB.pm line 579.
    Perl exited with active threads:
    	13 running and unjoined
    	0 finished and unjoined
    	0 running and detached
    2012-07-17 09:24:50 - nms-EB1501P Starting Pandora FMS Server. Error logging activated.
    

    Regards

  3. There is no connection with the database so the server can't write on it. Is the mysql database on the same machine? If it is parameter dhost on /etc/pandora/pandora_server.conf should be localhost. If it is in other machine it should be the ip from the machine where the database is and pandora user from the machine which is pandora installed  should have permission to access the database from the remote machine. Regards

  4. 
    # dbname: Database name (pandora by default
    
    dbname pandora
    
    # dbuser:  Database user name (pandora by default)
    
    dbuser root
    
    # dbpass: Database password
    
    dbpass root
    
    # dbhost: Database hostname or IP address
    
    dbhost localhost
    

    MySql is running:

    
    nms@nms-EB1501P:~$ sudo /etc/init.d/mysql status
    Rather than invoking init scripts through /etc/init.d, use the service(8)
    utility, e.g. service mysql status
    
    Since the script you are attempting to invoke has been converted to an
    Upstart job, you may also use the status(8) utility, e.g. status mysql
    mysql start/running, process 999
    
  5. Could you attach the file /srv/www/htdocs/pandora_console/include/config.php as well? Regards

  6. /srv/ directory is empty. Regards

  7. Sorry for the confusion. Check /var/www/pandora_console/include/config.php That should be the path if you are using debian. Regards

  8. /var/www/pandora_console/include/config.php :

    I think that the credentials are not right for MySql. What do you think?

  9. Hi You have to change your configuration in pandora_server.conf with the values in your "/var/www/pandora_console/include/config.php" file. so in dbuser you have to put pandora and in bdpass fcpknkvp and I think with this changed you should have access to the database. Regards

  10. /var/www/pandora_console/include/config.php :

    I think that the credentials are not right for MySql. What do you think?

    The credentials,as Jartal already told,are wrong on pandora_server.conf,you have to put the same as in the config.php. So it will result: # dbname: Database name (pandora by default dbname pandora2 # dbuser:  Database user name (pandora by default) dbuser pandora # dbpass: Database password dbpass fcpknkvp # dbhost: Database hostname or IP address dbhost localhost Regards

  11. At the moment your pandora_server was using a different database (pandora) meanwhile pandora_console is using database pandora2 Regards

  12. Ok thanks it's running. Thanks.

  13. Then I will mark it as solved. :) Regards.

Entra en tu cuenta para publicar.