Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problems creating db, schema and populating data
#1
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);

[Image: dot_green.png]
Connection with Database
[Image: dot_green.png]
Creating database 'pandora'
[Image: dot_green.png]
Opening database 'pandora'
[Image: dot_red.png]
Creating schema
[Image: dot_red.png]
Populating database
[Image: dot_green.png]
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

[Image: dot_green.png]
Write permissions to save config file in './include'
[Image: dot_green.png]
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.
 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