Can anyone assist in the following when running the console install.php? When logging directly into MySQL and then manually creating db pandora, creating the schema using /var/www/html/pandora_console/pandoradb.sql, I get numerous 1101 errors complaining about tables that can't have default values. I also have some 1215's mixed in stating it Cannot add foreign key constraint. Really not sure what to do at this point.... Ubuntu 18.04 PHP7.2 PandoraFMS 7.0NG_732 CREATING DATABASE AND DEFAULT CONFIGURATION FILE CREATE TABLE IF NOT EXISTS `tusuario` ( `id_user` varchar(60) NOT NULL default '0', `fullname` varchar(255) NOT NULL, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `middlename` varchar(255) NOT NULL, `password` varchar(45) default NULL, `comments` varchar(200) default NULL, `last_connect` bigint(20) NOT NULL default '0', `registered` bigint(20) NOT NULL default '0', `email` varchar(100) default NULL, `phone` varchar(100) default NULL, `is_admin` tinyint(1) unsigned NOT NULL default '0', `language` varchar(10) default NULL, `timezone` varchar(50) default '', `block_size` int(4) NOT NULL DEFAULT 20, `id_skin` int(10) unsigned NOT NULL DEFAULT 0, `disabled` int(4) NOT NULL DEFAULT 0, `shortcut` tinyint(1) DEFAULT 0, `shortcut_data` text, `section` TEXT NOT NULL, `data_section` TEXT NOT NULL, `force_change_pass` tinyint(1) unsigned NOT NULL default 0, `last_pass_change` DATETIME NOT NULL DEFAULT 0, `last_failed_login` DATETIME NOT NULL DEFAULT 0, `failed_attempt` int(4) NOT NULL DEFAULT 0, `login_blocked` tinyint(1) unsigned NOT NULL default 0, `metaconsole_access` enum('basic','advanced') default 'basic', `not_login` tinyint(1) unsigned NOT NULL DEFAULT 0, `metaconsole_agents_manager` tinyint(1) unsigned NOT NULL default 0, `metaconsole_assigned_server` int(10) unsigned NOT NULL default 0, `metaconsole_access_node` tinyint(1) unsigned NOT NULL default 0, `strict_acl` tinyint(1) unsigned NOT NULL DEFAULT 0, `id_filter` int(10) unsigned NULL default NULL, `session_time` int(10) signed NOT NULL default 0, `default_event_filter` int(10) unsigned NOT NULL default 0, `autorefresh_white_list` text not null default '', `time_autorefresh` int(5) unsigned NOT NULL default '30', `default_custom_view` int(10) unsigned NULL default '0', CONSTRAINT `fk_filter_id` FOREIGN KEY (`id_filter`) REFERENCES tevent_filter (`id_filter`) ON DELETE SET NULL, UNIQUE KEY `id_user` (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; _-- -- INSERT INTO `tmodule_inventory` (`id_module_inventory`, `id_os`, `name`, `description`, `interpreter`, `data_format`, `code`, `block_mode`) VALUES (1,1,'CPU','CPU','/usr/bin/perl','Model;Company;Speed','IyEvdXNyL2Jpbi9wZXJsDQojIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIw0KIyBwYW5kb3JhX2NwdS5wbA0KIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMNCiMgQ29weXJpZ2h0IChjKSAyMDA4IFJhbW9uIE5vdm9hLCBybm92b2FAYXJ0aWNhLmVzDQojICAgICAgICAgICAoYykgMjAwOCBBcnRpY2EgU29sdWNpb25lcyBUZWNub2xvZ2ljYXMgUy5MDQojDQojIFRoaXMgcHJvZ3JhbSBpcyBmcmVlIHNvZnR3YXJlOyB5b3UgY2FuIHJlZGlzdHJpYnV0ZSBpdCBhbmQvb3INCiMgbW9kaWZ5IGl0IHVuZGVyIHRoZSB0ZXJtcyBvZiB0aGUgR05VIEdlbmVyYWwgUHVibGljIExpY2Vuc2UNCiMgYXMgcHVibGlzaGVkIGJ5IHRoZSBGcmVlIFNvZnR3YXJlIEZvdW5kYXRpb247IHZlcnNpb24gMi4NCiMNCiMgVGhpcyBwcm9ncmFtIGlzIGRpc3RyaWJ1dGVkIGluIHRoZSBob3BlIHRoYXQgaXQgd2lsbCBiZSB1c2VmdWwsDQojIGJ1dCBXSVRIT1VUIEFOWSBXQVJSQU5UWTsgd2l0aG91dCBldmVuIHRoZSBpbXBsaWVkIHdhcnJhbnR5IG9mDQojIE1FUkNIQU5UQUJJTElUWSBvciBGSVRORVNTIEZPUiBBIFBBUlRJQ1VMQVIgUFVSUE9TRS4gIFNlZSB0aGUNCiMgR05VIEdlbmVyYWwgUHVibGljIExpY2Vuc2UgZm9yIG1vcmUgZGV0YWlscy4NCiMgWW91IHNob3VsZCBoYXZlIHJlY2VpdmVkIGEgY29weSBvZiB0aGUgR05VIEdlbmVyYWwgUHVibGljIExpY2Vuc2UNCiMgYWxvbmcgd2l0aCB0aGlzIHByb2dyYW07IGlmIG5vdCwgd3JpdGUgdG8gdGhlIEZyZWUgU29mdHdhcmUNCiMgRm91bmRhdGlvbiwgSW5jLiwgNTEgRnJhbmtsaW4gU3RyZWV0LCBGaWZ0aCBGbG9vciwgQm9zdG9uLCBNQSAgMDIxMTAtMTMwMSwgVVNBLg0KIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMNCg0KdXNlIHN0cmljdDsNCnVzZSB3YXJuaW5nczsNCg0KIyBDaGVjayBmb3Igc3NoDQpteSAkc3NoX2NsaWVudCA9ICJzc2giOw0KaWYgKHN5c3RlbSgiJHNzaF9jbGllbnQgLXYgPiAvZGV2L251bGwgMj4mMSIpID4+IDggIT0gMjU1KSB7DQoJcHJpbnQgIltlcnJvcl0gJHNzaF9jbGllbnQgbm90IGZvdW5kLlxuIjsNCglleGl0IDE7DQp9DQoNCmlmICgkI0FSR1YgPCAxKSB7DQoJcHJpbnQgIlVzYWdlOiAkMCA8dGFyZ2V0IGlwPiA8dXNlcm5hbWU+XG4iOw0KCWV4aXQgMTsNCn0NCg0KbXkgJHRhcmdldF9pcCA9ICRBUkdWWzBdOw0KbXkgJHVzZXJuYW1lID0gJEFSR1ZbMV07DQoNCiMgUmV0cmlldmUgQ1BVIGRhdGENCm15ICgkbW9kZWwsICR2ZW5kb3IsICRzcGVlZCk7DQpteSBAY3B1X2luZm8gPSBgJHNzaF9jbGllbnQgJHVzZXJuYW1lXEAkdGFyZ2V0X2lwICJjYXQgL3Byb2MvY3B1aW5mbyJgOw0KZm9yZWFjaCBteSAkbGluZSAoQGNwdV9pbmZvKSB7DQoJaWYgKCRsaW5lID1+IC9tb2RlbCBuYW1lXHMrOlxzKyguKikvKSB7DQoJCSRtb2RlbCA9ICQxOw0KCX0gZWxzaWYgKCRsaW5lID1+IC92ZW5kb3JfaWRccys6XHMrKC4qKS8pIHsNCgkJJHZlbmRvciA9ICQxOw0KCX0gZWxzaWYgKCRsaW5lID1+IC9jcHUgTUh6XHMrOlxzKyguKikvKSB7DQoJCSRzcGVlZCA9ICQxOw0KCX0NCn0NCiANCnJldHVybiAxIGlmICgkbW9kZWwgZXEgJycgfHwgJHZlbmRvciBlcSAnJyB8fCAkc3BlZWQgZXEgJycpOw0KcHJpbnQgIiRtb2RlbDskdmVuZG9yOyIgLiBzcHJpbnRmICgiJS4wZiIsICRzcGVlZCkgLiAiIE1IelxuIjsNCg0KZXhpdCAwOw0K',0); _
Connection with Database
Creating database 'pandora'
Opening database 'pandora'
Creating schema
Populating database
Established privileges for user pandora. A new random password has been generated: kkemqcht Please write it down, you will need to setup your Pandora FMS server, editing the /etc/pandora/pandora_server.conf file
Write permissions to save config file in './include'
Created new config file at 'include/config.php' There were some problems. Installation was not completed. Please correct failures before trying again. All database schemes created in this step have been dropped.
Problems creating db, schema and populating data
dmcclain · 28 mar 2019, 17:36 · 13 mensajes · 94 visitas
- Inicio del debate
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.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.Good morning, dmcclain Please, try to update your Pandora FMS installation. We are currently running the version 733 with MR 26. https://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Anexo_Upgrade Let us know if this helps to solve your problem. Kind regards, Eduardo.
Can anyone assist in the following when running the console install.php? When logging directly into MySQL and then manually creating db pandora, creating the schema using /var/www/html/pandora_console/pandoradb.sql, I get numerous 1101 errors complaining about tables that can't have default values. I also have some 1215's mixed in stating it Cannot add foreign key constraint. Really not sure what to do at this point.... Ubuntu 18.04 PHP7.2 PandoraFMS 7.0NG_732 CREATING DATABASE AND DEFAULT CONFIGURATION FILE CREATE TABLE IF NOT EXISTS `tusuario` ( `id_user` varchar(60) NOT NULL default '0', `fullname` varchar(255) NOT NULL, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `middlename` varchar(255) NOT NULL, `password` varchar(45) default NULL, `comments` varchar(200) default NULL, `last_connect` bigint(20) NOT NULL default '0', `registered` bigint(20) NOT NULL default '0', `email` varchar(100) default NULL, `phone` varchar(100) default NULL, `is_admin` tinyint(1) unsigned NOT NULL default '0', `language` varchar(10) default NULL, `timezone` varchar(50) default '', `block_size` int(4) NOT NULL DEFAULT 20, `id_skin` int(10) unsigned NOT NULL DEFAULT 0, `disabled` int(4) NOT NULL DEFAULT 0, `shortcut` tinyint(1) DEFAULT 0, `shortcut_data` text, `section` TEXT NOT NULL, `data_section` TEXT NOT NULL, `force_change_pass` tinyint(1) unsigned NOT NULL default 0, `last_pass_change` DATETIME NOT NULL DEFAULT 0, `last_failed_login` DATETIME NOT NULL DEFAULT 0, `failed_attempt` int(4) NOT NULL DEFAULT 0, `login_blocked` tinyint(1) unsigned NOT NULL default 0, `metaconsole_access` enum('basic','advanced') default 'basic', `not_login` tinyint(1) unsigned NOT NULL DEFAULT 0, `metaconsole_agents_manager` tinyint(1) unsigned NOT NULL default 0, `metaconsole_assigned_server` int(10) unsigned NOT NULL default 0, `metaconsole_access_node` tinyint(1) unsigned NOT NULL default 0, `strict_acl` tinyint(1) unsigned NOT NULL DEFAULT 0, `id_filter` int(10) unsigned NULL default NULL, `session_time` int(10) signed NOT NULL default 0, `default_event_filter` int(10) unsigned NOT NULL default 0, `autorefresh_white_list` text not null default '', `time_autorefresh` int(5) unsigned NOT NULL default '30', `default_custom_view` int(10) unsigned NULL default '0', CONSTRAINT `fk_filter_id` FOREIGN KEY (`id_filter`) REFERENCES tevent_filter (`id_filter`) ON DELETE SET NULL, UNIQUE KEY `id_user` (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; _-- -- INSERT INTO `tmodule_inventory` (`id_module_inventory`, `id_os`, `name`, `description`, `interpreter`, `data_format`, `code`, `block_mode`) VALUES (1,1,'CPU','CPU','/usr/bin/perl','Model;Company;Speed','IyEvdXNyL2Jpbi9wZXJsDQojIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIw0KIyBwYW5kb3JhX2NwdS5wbA0KIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMNCiMgQ29weXJpZ2h0IChjKSAyMDA4IFJhbW9uIE5vdm9hLCBybm92b2FAYXJ0aWNhLmVzDQojICAgICAgICAgICAoYykgMjAwOCBBcnRpY2EgU29sdWNpb25lcyBUZWNub2xvZ2ljYXMgUy5MDQojDQojIFRoaXMgcHJvZ3JhbSBpcyBmcmVlIHNvZnR3YXJlOyB5b3UgY2FuIHJlZGlzdHJpYnV0ZSBpdCBhbmQvb3INCiMgbW9kaWZ5IGl0IHVuZGVyIHRoZSB0ZXJtcyBvZiB0aGUgR05VIEdlbmVyYWwgUHVibGljIExpY2Vuc2UNCiMgYXMgcHVibGlzaGVkIGJ5IHRoZSBGcmVlIFNvZnR3YXJlIEZvdW5kYXRpb247IHZlcnNpb24gMi4NCiMNCiMgVGhpcyBwcm9ncmFtIGlzIGRpc3RyaWJ1dGVkIGluIHRoZSBob3BlIHRoYXQgaXQgd2lsbCBiZSB1c2VmdWwsDQojIGJ1dCBXSVRIT1VUIEFOWSBXQVJSQU5UWTsgd2l0aG91dCBldmVuIHRoZSBpbXBsaWVkIHdhcnJhbnR5IG9mDQojIE1FUkNIQU5UQUJJTElUWSBvciBGSVRORVNTIEZPUiBBIFBBUlRJQ1VMQVIgUFVSUE9TRS4gIFNlZSB0aGUNCiMgR05VIEdlbmVyYWwgUHVibGljIExpY2Vuc2UgZm9yIG1vcmUgZGV0YWlscy4NCiMgWW91IHNob3VsZCBoYXZlIHJlY2VpdmVkIGEgY29weSBvZiB0aGUgR05VIEdlbmVyYWwgUHVibGljIExpY2Vuc2UNCiMgYWxvbmcgd2l0aCB0aGlzIHByb2dyYW07IGlmIG5vdCwgd3JpdGUgdG8gdGhlIEZyZWUgU29mdHdhcmUNCiMgRm91bmRhdGlvbiwgSW5jLiwgNTEgRnJhbmtsaW4gU3RyZWV0LCBGaWZ0aCBGbG9vciwgQm9zdG9uLCBNQSAgMDIxMTAtMTMwMSwgVVNBLg0KIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMNCg0KdXNlIHN0cmljdDsNCnVzZSB3YXJuaW5nczsNCg0KIyBDaGVjayBmb3Igc3NoDQpteSAkc3NoX2NsaWVudCA9ICJzc2giOw0KaWYgKHN5c3RlbSgiJHNzaF9jbGllbnQgLXYgPiAvZGV2L251bGwgMj4mMSIpID4+IDggIT0gMjU1KSB7DQoJcHJpbnQgIltlcnJvcl0gJHNzaF9jbGllbnQgbm90IGZvdW5kLlxuIjsNCglleGl0IDE7DQp9DQoNCmlmICgkI0FSR1YgPCAxKSB7DQoJcHJpbnQgIlVzYWdlOiAkMCA8dGFyZ2V0IGlwPiA8dXNlcm5hbWU+XG4iOw0KCWV4aXQgMTsNCn0NCg0KbXkgJHRhcmdldF9pcCA9ICRBUkdWWzBdOw0KbXkgJHVzZXJuYW1lID0gJEFSR1ZbMV07DQoNCiMgUmV0cmlldmUgQ1BVIGRhdGENCm15ICgkbW9kZWwsICR2ZW5kb3IsICRzcGVlZCk7DQpteSBAY3B1X2luZm8gPSBgJHNzaF9jbGllbnQgJHVzZXJuYW1lXEAkdGFyZ2V0X2lwICJjYXQgL3Byb2MvY3B1aW5mbyJgOw0KZm9yZWFjaCBteSAkbGluZSAoQGNwdV9pbmZvKSB7DQoJaWYgKCRsaW5lID1+IC9tb2RlbCBuYW1lXHMrOlxzKyguKikvKSB7DQoJCSRtb2RlbCA9ICQxOw0KCX0gZWxzaWYgKCRsaW5lID1+IC92ZW5kb3JfaWRccys6XHMrKC4qKS8pIHsNCgkJJHZlbmRvciA9ICQxOw0KCX0gZWxzaWYgKCRsaW5lID1+IC9jcHUgTUh6XHMrOlxzKyguKikvKSB7DQoJCSRzcGVlZCA9ICQxOw0KCX0NCn0NCiANCnJldHVybiAxIGlmICgkbW9kZWwgZXEgJycgfHwgJHZlbmRvciBlcSAnJyB8fCAkc3BlZWQgZXEgJycpOw0KcHJpbnQgIiRtb2RlbDskdmVuZG9yOyIgLiBzcHJpbnRmICgiJS4wZiIsICRzcGVlZCkgLiAiIE1IelxuIjsNCg0KZXhpdCAwOw0K',0); _
Connection with Database
Creating database 'pandora'
Opening database 'pandora'
Creating schema
Populating database
Established privileges for user pandora. A new random password has been generated: kkemqcht Please write it down, you will need to setup your Pandora FMS server, editing the /etc/pandora/pandora_server.conf file
Write permissions to save config file in './include'
Created new config file at 'include/config.php' There were some problems. Installation was not completed. Please correct failures before trying again. All database schemes created in this step have been dropped.Hello dmcclain, Check if in my.cnf file exists this line: sql_mode=NO_ENGINE_SUBSTITUTION.STRICT_TRANS_TABLES and edit it as follows: sql_mode='' Please, tell us if that was the problem. Regards.
My.cnf does not contain a sql_mode= line. It only has the two includedir /etc/mysql/conf.d and mysql.conf.d.
My.cnf does not contain a sql_mode= line. It only has the two includedir /etc/mysql/conf.d and mysql.conf.d.
Greetings, dmcclain If your file doesn't contain the line my partner told you, you'll have to create it yourself.
[mysqld] sql_mode= ""Please be sure that the line "sql_mode" is included in "mysqld" tag. Let us know if this works. And do not forget to update your Pandora FMS installation, please. Regards, Eduardo.
Eduardo and Jose, Thanks for the assistance. Adding the mysql tag did not work, however, installing the 733 version did work. That problem is resolved, however,.... I have a netflow probe setup in the network and it is forwarding to PandoraFMS. In the /var/spool/pandora/data_in/netflow folder, I have nfcapd running and creating multiple nfcapd.timestamp files. I have verified using nfdump -R to see flows. I've enabled netflow in general setup and have validated the default paths in netflow window for capture files and paths to nfcapd, nfdump and nfexpire. When I try to look at netflow in the netflow live, without changing any setting here, I click on 'draw' and I don't get any information. It says "No data to show". Since nfcapd is running as root, I went back to the spool folder and changed owner to pandora.www-data for the files it placed there, thinking it was a permissions issue. That didn't help either.
Eduardo and Jose, Thanks for the assistance. Adding the mysql tag did not work, however, installing the 733 version did work. That problem is resolved, however,.... I have a netflow probe setup in the network and it is forwarding to PandoraFMS. In the /var/spool/pandora/data_in/netflow folder, I have nfcapd running and creating multiple nfcapd.timestamp files. I have verified using nfdump -R to see flows. I've enabled netflow in general setup and have validated the default paths in netflow window for capture files and paths to nfcapd, nfdump and nfexpire. When I try to look at netflow in the netflow live, without changing any setting here, I click on 'draw' and I don't get any information. It says "No data to show". Since nfcapd is running as root, I went back to the spool folder and changed owner to pandora.www-data for the files it placed there, thinking it was a permissions issue. That didn't help either.
Hello dmcclain, We,ve just tested the Netflow Live Viewer (packets installed in CentOS Pandora FMS ISO) and it works with no problems. Please, send us a screenshot of the result of command: nfdump -R /var/spool/pandora/data_in/netflow Do the netflow explorer and other netflow options show any data?
Eduardo and Jose, Thanks for the assistance. Adding the mysql tag did not work, however, installing the 733 version did work. That problem is resolved, however,.... I have a netflow probe setup in the network and it is forwarding to PandoraFMS. In the /var/spool/pandora/data_in/netflow folder, I have nfcapd running and creating multiple nfcapd.timestamp files. I have verified using nfdump -R to see flows. I've enabled netflow in general setup and have validated the default paths in netflow window for capture files and paths to nfcapd, nfdump and nfexpire. When I try to look at netflow in the netflow live, without changing any setting here, I click on 'draw' and I don't get any information. It says "No data to show". Since nfcapd is running as root, I went back to the spool folder and changed owner to pandora.www-data for the files it placed there, thinking it was a permissions issue. That didn't help either.
Hello dmcclain, We,ve just tested the Netflow Live Viewer (packets installed in CentOS Pandora FMS ISO) and it works with no problems. Please, send us a screenshot of the result of command: nfdump -R /var/spool/pandora/data_in/netflow Do the netflow explorer and other netflow options show any data?
Yes, netflow files were flowing and mutliple files into data_in/netflow, nfdump parsed them as well and provided all the statistics. Found that the pandora_server was crashing. Everytime I'd restart the server, I'd check the status and it would be inactive. I went back and did a complete fresh install of Ubuntu 18.04, reloaded all the dependencies, php7.2 mysql8, etc., installed the new 733 console and had green indicators through all the steps, but it then gave me the common non descript failure error when trying to build schema and failed. I went back to my.cnf, updated the [mysqld] mysql= " " and no difference.
Ok, where do I go from here?? I've tried the multiple fixes reported in communities including mysql= "" and no engine substitution. There is no usable information in any of the logs that tells me what the failures were incurred. What next for troubleshooting and getting this running? Pandora 733 MySQL-8.0.15 PHP 7.2 Install step 5 of 6 CREATING DATABASE AND DEFAULT CONFIGURATION FILE Connection with Database Creating database 'pandora' There were some problems. Installation was not completed. Please correct failures before trying again. All database schemes created in this step have been dropped. Pandora FMS is an Open Source Software project registered at SourceForge
Ok, where do I go from here?? I've tried the multiple fixes reported in communities including mysql= "" and no engine substitution. There is no usable information in any of the logs that tells me what the failures were incurred. What next for troubleshooting and getting this running? Pandora 733 MySQL-8.0.15 PHP 7.2 Install step 5 of 6 CREATING DATABASE AND DEFAULT CONFIGURATION FILE Connection with Database Creating database 'pandora' There were some problems. Installation was not completed. Please correct failures before trying again. All database schemes created in this step have been dropped. Pandora FMS is an Open Source Software project registered at SourceForge
Greetings, dmcclain Have you been able to take a screenshot of the command my partner asked you for? It would be extremely useful to identify the problem you have. On the other hand, Pandora FMS is currently running and tested under MySQL v 5.7.19 so newer versions might have compatibility problems. Kind regards, Eduardo.
I previously stated that the collector was functioning and I confirmed it was running and collecting NetFlow data by installing another NetFlow project that can provide the data and insight I was looking for from Pandora. I'll come back to this when I have more time to dedicate, but after a week, I have other duties that need my immediate attention. It is likely the MySQL8 that I loaded.
I previously stated that the collector was functioning and I confirmed it was running and collecting NetFlow data by installing another NetFlow project that can provide the data and insight I was looking for from Pandora. I'll come back to this when I have more time to dedicate, but after a week, I have other duties that need my immediate attention. It is likely the MySQL8 that I loaded.
Greetings, dmcclain We regret any inconvenience this may have caused. Let us know when you have the time to install a previous version of MySQL to see the problem solved. Best regards, Eduardo.
Entra en tu cuenta para publicar.
