Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problems creating db, schema and populating data
#2
Additional, if it may help guide advice, suggestions and recommendations.

Since I had the db password generated, went ahead and dpkg installed server, modified dbpass with the password generated and then manually logged into mysql with 'pandora' and the password. Ran pandoradb.sql and pandoradb_data.sql using source cmd. It generated the errors mentioned above, 1101 and 1215 during pandoradb.sql and when running pandoradb_data.sql I get "Error 1146 Table 'padora.tmodule_inventory' doesn't exist" and 'pandora.tnews', 'pandora.tlocal_component', 'pandora.tpolicies', 'pandora.tpolicy_alerts', pandora.tpolicy_modules', 'pandora.tskin', 'pandora.tprofile_view' and pandora.tnotification_source_user'.


Restarted mysql anyway, went on with trying to start the FMS server and in pandora_server.error:
2019-03-28 17:27:06 - pandorafms Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 4979.
DBD::mysql::db do failed: Data truncated for column 'data' at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
DBD::mysql::db do failed: Data truncated for column 'data' at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
12 running and unjoined
1 finished and unjoined
0 running and detached


In pandora_server.log:
2019-03-28 17:27:06 pandorafms [V1] Launching 7.0NG.732 190227
2019-03-28 17:27:06 pandorafms [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 0, Server Threshold at
5 sec, verbosity at 3, Alert Threshold at 60, ServerName is 'pandorafms'
2019-03-28 17:27:06 pandorafms [V1] [*] Pandora FMS Enterprise module not available.
2019-03-28 17:27:07 pandorafms [V1] [E] wmic not found. Pandora FMS WMI Server needs a DCOM/WMI client.
2019-03-28 17:27:07 pandorafms [V1] [*] Netflow daemon disabled.
2019-03-28 17:27:07 pandorafms [V1] [E] 'pandorafms': DBD::mysql::db do failed: Data truncated for column 'data' at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 875.

2019-03-28 17:27:07 pandorafms [V1] Pandora FMS Server 'pandorafms' unhandled error.
2019-03-28 17:27:07 pandorafms [V1] [E] 'pandorafms': 25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.

2019-03-28 17:27:07 pandorafms [V1] Pandora FMS Server 'pandorafms' unhandled error.
2019-03-28 17:27:07 pandorafms [V3] Warmup mode for unknown modules started.
2019-03-28 17:27:07 pandorafms [V1] [E] 'pandorafms': DBD::mysql::db do failed: Data truncated for column 'data' at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 875.

2019-03-28 17:27:07 pandorafms [V1] Pandora FMS Server 'pandorafms' unhandled error.
2019-03-28 17:27:07 pandorafms [V1] [E] 'pandorafms': 25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.

2019-03-28 17:27:07 pandorafms [V1] Pandora FMS Server 'pandorafms' unhandled error.
 Reply

(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes