[Solved] Problems starting Pandora FMS after upgrade to 3.1..

[daniels]

Like it

Up

0

Down

Drop it

::

Hi JeeSee.

  Grant access for your host (pandora3) to the mysql server:

Log in im mysql server as admin and do:
grant all privileges on pandora.* to user@host identified by “senha”;

ex:
grant all privileges on pandora.* to pandora_user@PANDORA3 identified by “G3D9C1”;

Regards.

[JeeSee]

Like it

Up

0

Down

Drop it

::

OK.. I’ve granted the rights for the server itself..
But now I got another error in the logging and Pandora is not starting:

2010-06-02 05:33:57 TYN-PANDORA3 [V1] Launching 3.1rc1 100515
2010-06-02 05:33:57 TYN-PANDORA3 [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 1 sec, verbosity at 10, Alert Threshold at 60, ServerName is 'TYN-PANDORA3'
2010-06-02 05:33:57 TYN-PANDORA3 [V10] Creating audit entry 'Pandora FMS Server Daemon starting' name 'SYSTEM' action 'System'.
2010-06-02 05:33:58 TYN-PANDORA3 [V1] [E] 'TYN-PANDORA3': Can't locate XML/SAX.pm in @INC (@INC contains: /usr/lib/perl5/5.10.0/i586-linux-thread-multi /usr/lib/perl5/5.10.0 /usr/lib/perl5 /usr/lib/perl5/site_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl .) at /usr/lib/perl5/vendor_perl/5.10.0/XML/Simple.pm line 348.

2010-06-02 05:33:58 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' unhandled error.
2010-06-02 05:33:58 TYN-PANDORA3 [V1] [E] 'TYN-PANDORA3': Can't locate XML/SAX.pm in @INC (@INC contains: /usr/lib/perl5/5.10.0/i586-linux-thread-multi /usr/lib/perl5/5.10.0 /usr/lib/perl5 /usr/lib/perl5/site_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl .) at /usr/lib/perl5/vendor_perl/5.10.0/XML/Simple.pm line 348.

2010-06-02 05:33:58 TYN-PANDORA3 [V1] [E] 'TYN-PANDORA3': Can't locate XML/SAX.pm in @INC (@INC contains: /usr/lib/perl5/5.10.0/i586-linux-thread-multi /usr/lib/perl5/5.10.0 /usr/lib/perl5 /usr/lib/perl5/site_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl .) at /usr/lib/perl5/vendor_perl/5.10.0/XML/Simple.pm line 348.

2010-06-02 05:33:58 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' unhandled error.
2010-06-02 05:33:58 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' unhandled error.
2010-06-02 05:33:58 TYN-PANDORA3 [V5] Modified timestamp = 2010-06-02 06:58:24 with timezone_offset = 0

2010-06-02 05:33:58 TYN-PANDORA3 [V5] Modified timestamp = 2010-06-01 22:34:12 with timezone_offset = 0
2010-06-02 05:33:58 TYN-PANDORA3 [V5] Modified timestamp = 2010-05-31 13:43:19 with timezone_offset = 0
Unknown column 'timezone_offset' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 239.

2010-06-02 05:33:58 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' unhandled error.
2010-06-02 05:33:58 TYN-PANDORA3 [V1] [E] 'TYN-PANDORA3': DBD::mysql::db do failed: Unknown column 'timezone_offset' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 239.

2010-06-02 05:33:58 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' unhandled error.
2010-06-02 05:33:58 TYN-PANDORA3 [V1] [E] 'TYN-PANDORA3': DBD::mysql::db do failed: Unknown column 'timezone_offset' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 239.

2010-06-02 05:33:58 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' unhandled error.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 dataserver going UP' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 networkserver going UP' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 reconserver going UP' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 snmpconsole going UP' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 pluginserver going UP' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V1] [E] 'TYN-PANDORA3': DBD::mysql::db do failed: Unknown column 'timezone_offset' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 239.

2010-06-02 05:33:55 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' unhandled error.
2010-06-02 05:33:55 TYN-PANDORA3 [V1] Pandora FMS Server 'TYN-PANDORA3' Shutdown by signal 
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 dataserver going DOWN' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 networkserver going DOWN' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 reconserver going DOWN' for agent ID 0 module ID 0.
2010-06-02 05:33:55 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 snmpconsole going DOWN' for agent ID 0 module ID 0.
2010-06-02 05:33:56 TYN-PANDORA3 [V10] Generating event 'TYN-PANDORA3 pluginserver going DOWN' for agent ID 0 module ID 0.

[JeeSee]

Like it

Up

0

Down

Drop it

::

Installed XML:SAX  with YAST. now the only error is de DB error with ‘timezone_offset’ in ‘field list’…
But still no start of Pandora Server

[rnovoa]

Like it

Up

0

Down

Drop it

::

Hi JeeSee,

Did you upgrade the DB schema?

http://www.openideas.info/wiki/index.php?title=Pandora_3.0:Documentation_en:Anexo_Upgrade#DB_schema

[summa_sp]

Like it

Up

0

Down

Drop it

::

I attempted to use this document to update my database to 3.1, but there is an error in the document.  In several locations you indicate a user name of “root, but the default sql user name in your configuration file is “pandora”.

mysqldump -u root -p pandora > backup_pandora_3.0.sql
mysql -u root -p

[rnovoa]

Like it

Up

0

Down

Drop it

::

What exactly was the problem? You can use any user with enough privileges to perform the upgrade (the mysql root user should be fine).

[Sancho]

Like it

Up

0

Down

Drop it

::

I attempted to use this document to update my database to 3.1, but there is an error in the document.  In several locations you indicate a user name of “root, but the default sql user name in your configuration file is “pandora”.

mysqldump -u root -p pandora > backup_pandora_3.0.sql
mysql -u root -p

Check your current credentials en /etc/pandora/pandora_server.conf

Database should be called “pandora”, and user “pandora”, password will be a random string, this means that commands should be like this:

mysql -u pandora -D pandora -p

and

mysqldump -u pandora -p pandora > file

I’m going to add this to FAQ.

[JeeSee]

Like it

Up

0

Down

Drop it

::

Thanx alot guys/girls!
I got it all working now!