Diferencias

Muestra las diferencias entre dos versiones de la página.

--- unattended_installations:installation_icinga_2 [2015/04/02 14:00] – [Setting up Icinga Web 2] macho
+++ unattended_installations:installation_icinga_2 [2022/11/02 17:58] (actual) – editor externo 127.0.0.1
@@ Línea 81: / Línea 81: @@
 After creating the database you can import the Icinga 2 IDO schema using the following command:
   # mysql -u root -p icinga < /usr/share/icinga2-ido-mysql/schema/mysql.sql
+The mysql.sql not contain the table structure to store users and preferences, so inside the database icinga have to create that structure  to prevent errors when the configuration via web.
+  CREATE TABLE `icingaweb_group`(
+  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `parent` varchar(64) COLLATE utf8_unicode_ci NULL DEFAULT NULL,
+  `ctime` timestamp NULL DEFAULT NULL,
+  `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`name`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  CREATE TABLE `icingaweb_group_membership`(
+  `group_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `username` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `ctime` timestamp NULL DEFAULT NULL,
+  `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`group_name`,`username`),
+  CONSTRAINT `fk_icingaweb_group_membership_icingaweb_group` FOREIGN KEY (`group_name`)
+  REFERENCES `icingaweb_group` (`name`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  CREATE TABLE `icingaweb_user`(
+  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `active` tinyint(1) NOT NULL,
+  `password_hash` varbinary(255) NOT NULL,
+  `ctime` timestamp NULL DEFAULT NULL,
+  `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`name`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  CREATE TABLE `icingaweb_user_preference`(
+  `username` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `section` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `value` varchar(255) NOT NULL,
+  `ctime` timestamp NULL DEFAULT NULL,
+  `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`username`,`section`,`name`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 **Enabling the IDO MySQL module**