Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problems creating db, schema and populating data
#4
(03-28-2019, 01:36 PM)dmcclain Wrote: 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.

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.
 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