Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende Überarbeitung | ||
centos:cacti_c6:app_1 [16.07.2012 22:08. ] – django | centos:cacti_c6:app_1 [31.10.2023 18:53. ] (aktuell) – Externe Bearbeitung 127.0.0.1 | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | ====== Cacti Installation und Grundkonfiguration unter CentOS 6.x ====== | ||
+ | {{: | ||
+ | |||
+ | Die Installation und Konfiguration von **Cacti** gestaltet sich relativ einfach. | ||
+ | |||
+ | ===== Installation ===== | ||
+ | Dank des bereits eingebundenen Repoository [[centos: | ||
+ | # yum install cacti -y | ||
+ | |||
+ | ===== Paketinhalte ===== | ||
+ | Was uns das Programmpakete **cacti** alles mitgebracht hat, können wir uns am einfachsten mit Hilfde des Befehls **rpm** mit der Option //-qil// ansehen. | ||
+ | # rpm -qil cacti | ||
+ | |||
+ | < | ||
+ | Version | ||
+ | Release | ||
+ | Install Date: Mon 16 Jul 2012 01:32:23 PM CEST Build Host: lisse.hasselt.wieers.com | ||
+ | Group : Applications/ | ||
+ | Size : 5677614 | ||
+ | Signature | ||
+ | Packager | ||
+ | URL : https:// | ||
+ | Summary | ||
+ | Description : | ||
+ | Cacti is a complete frontend to RRDTool. It stores all of the necessary | ||
+ | information to create graphs and populate them with data in a MySQL | ||
+ | database. | ||
+ | |||
+ | The frontend is completely PHP driven. Along with being able to maintain | ||
+ | graphs, data sources, and round robin archives in a database, Cacti also | ||
+ | handles the data gathering. There is SNMP support for those used to | ||
+ | creating traffic graphs with MRTG. | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | ===== VHost Definition ===== | ||
+ | Das **rpm** bringt uns zwar eine Apche-Konfigurationsdatei mit, die wir aber so nicht nutzen wollen, da wir für cacti einen eigenen VHost verwenden werden. Wir ergänzen also unsere VHost-Definition **/ | ||
+ | # vim / | ||
+ | |||
+ | <code apache vhost.conf> | ||
+ | # | ||
+ | # cacti.nausch.org | ||
+ | # | ||
+ | < | ||
+ | ServerAdmin webmaster@nausch.org | ||
+ | ServerName cacti.nausch.org: | ||
+ | ServerAlias cacti.nausch.org *.cacti.nausch.org | ||
+ | ServerPath / | ||
+ | DocumentRoot "/ | ||
+ | < | ||
+ | Options FollowSymLinks | ||
+ | AllowOverride all | ||
+ | Order Allow,Deny | ||
+ | Allow from all | ||
+ | AddType application/ | ||
+ | php_flag magic_quotes_gpc on | ||
+ | php_flag track_vars on | ||
+ | DirectoryIndex index.php | ||
+ | Options -Indexes | ||
+ | </ | ||
+ | ErrorLog logs/ | ||
+ | CustomLog logs/ | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | Anschließend geben wir unseren neune VHost unserem Webserver bekannt, in dem wir diesen 1x durchstarten. | ||
+ | # service httpd restart | ||
+ | |||
+ | |||
+ | ===== MySQL Definitionen ===== | ||
+ | Die Konfiguration unseres Cacti-Servers wird in einer MySQL-Datenbanktabelle vorgehalten. Die Konfiguration der nötigen Tabellen nehmen wir mit Hilfe der von cacti mitgelieferten Schematas vor. | ||
+ | |||
+ | - **Datenbank anlegen** \\ Als erstes legen wir die Datenbank an. MySQL frägt uns bei den nachfolgenden Definitionen nach dem Passwort unseres mysql-Superusers **root**. < | ||
+ | Welcome to the MySQL monitor. | ||
+ | Your MySQL connection id is 37 | ||
+ | Server version: 5.1.61 Source distribution | ||
+ | |||
+ | Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. | ||
+ | |||
+ | Oracle is a registered trademark of Oracle Corporation and/or its | ||
+ | affiliates. Other names may be trademarks of their respective | ||
+ | owners. | ||
+ | |||
+ | Type ' | ||
+ | |||
+ | mysql> create database cacti; | ||
+ | Query OK, 1 row affected (0.01 sec) | ||
+ | </ | ||
+ | - **neuen Benutzer anlegen** \\ Mit folgendem Befehl legen wir uns einen neuen Nutzer an:< | ||
+ | Query OK, 0 rows affected (0.00 sec) | ||
+ | |||
+ | mysql> | ||
+ | Query OK, 0 rows affected (0.00 sec) | ||
+ | |||
+ | mysql> </ | ||
+ | - **Benutzerprivilegien setzen und zuweisen** \\ Anschließend setzen wir die Benutzerrechte unseres gerade angelegten Datenbanknutzers. < | ||
+ | Query OK, 0 rows affected (0.01 sec) | ||
+ | |||
+ | mysql></ | ||
+ | Query OK, 0 rows affected (0.01 sec) | ||
+ | |||
+ | mysql></ | ||
+ | - **Rechte des Nutzers in der Datenbank neu laden** \\ Im letzten Schritt laden wir nun die Rechte unseres neuen Datenbankusers.< | ||
+ | Query OK, 0 rows affected (0.00 sec) | ||
+ | |||
+ | mysql></ | ||
+ | - **mySQL-Datenbankverbindung beenden** \\ Unsere Konfiguration unseres neuen Datenbanknutzers ist hiermit beendet und wir können die Verbindung zur Datenbank wieder schließen.< | ||
+ | Bye | ||
+ | </ | ||
+ | - **SQL-Template anpassen** \\ Bevor wir nun die notwendigen Tabellen mit Hilfe des mitgelieferten Templatefiles anlegen, passen wir dies nun noch kurz an. < | ||
+ | -- | ||
+ | -- Django : 2012-07-16 Datenbank auswählen | ||
+ | -- | ||
+ | |||
+ | use cacti; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `cdef` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE cdef ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | name varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `cdef` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO cdef VALUES (3,' | ||
+ | INSERT INTO cdef VALUES (4,' | ||
+ | INSERT INTO cdef VALUES (12,' | ||
+ | INSERT INTO cdef VALUES (2,' | ||
+ | INSERT INTO cdef VALUES (14,' | ||
+ | INSERT INTO cdef VALUES (15,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `cdef_items` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE cdef_items ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | cdef_id mediumint(8) unsigned NOT NULL default ' | ||
+ | sequence mediumint(8) unsigned NOT NULL default ' | ||
+ | type tinyint(2) NOT NULL default ' | ||
+ | value varchar(150) NOT NULL default '', | ||
+ | PRIMARY KEY (id), | ||
+ | KEY cdef_id (cdef_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `cdef_items` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO cdef_items VALUES (7,' | ||
+ | INSERT INTO cdef_items VALUES (9,' | ||
+ | INSERT INTO cdef_items VALUES (8,' | ||
+ | INSERT INTO cdef_items VALUES (10,' | ||
+ | INSERT INTO cdef_items VALUES (11,' | ||
+ | INSERT INTO cdef_items VALUES (12,' | ||
+ | INSERT INTO cdef_items VALUES (13,' | ||
+ | INSERT INTO cdef_items VALUES (14,' | ||
+ | INSERT INTO cdef_items VALUES (15,' | ||
+ | INSERT INTO cdef_items VALUES (16,' | ||
+ | INSERT INTO cdef_items VALUES (18,' | ||
+ | INSERT INTO cdef_items VALUES (19,' | ||
+ | INSERT INTO cdef_items VALUES (20,' | ||
+ | INSERT INTO cdef_items VALUES (21,' | ||
+ | INSERT INTO cdef_items VALUES (22,' | ||
+ | INSERT INTO cdef_items VALUES (23,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `colors` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE colors ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hex varchar(6) NOT NULL default '', | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `colors` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO colors VALUES (1,' | ||
+ | INSERT INTO colors VALUES (2,' | ||
+ | INSERT INTO colors VALUES (4,' | ||
+ | INSERT INTO colors VALUES (5,' | ||
+ | INSERT INTO colors VALUES (6,' | ||
+ | INSERT INTO colors VALUES (7,' | ||
+ | INSERT INTO colors VALUES (8,' | ||
+ | INSERT INTO colors VALUES (9,' | ||
+ | INSERT INTO colors VALUES (10,' | ||
+ | INSERT INTO colors VALUES (11,' | ||
+ | INSERT INTO colors VALUES (12,' | ||
+ | INSERT INTO colors VALUES (13,' | ||
+ | INSERT INTO colors VALUES (14,' | ||
+ | INSERT INTO colors VALUES (15,' | ||
+ | INSERT INTO colors VALUES (16,' | ||
+ | INSERT INTO colors VALUES (17,' | ||
+ | INSERT INTO colors VALUES (18,' | ||
+ | INSERT INTO colors VALUES (19,' | ||
+ | INSERT INTO colors VALUES (20,' | ||
+ | INSERT INTO colors VALUES (21,' | ||
+ | INSERT INTO colors VALUES (22,' | ||
+ | INSERT INTO colors VALUES (24,' | ||
+ | INSERT INTO colors VALUES (25,' | ||
+ | INSERT INTO colors VALUES (26,' | ||
+ | INSERT INTO colors VALUES (27,' | ||
+ | INSERT INTO colors VALUES (28,' | ||
+ | INSERT INTO colors VALUES (29,' | ||
+ | INSERT INTO colors VALUES (30,' | ||
+ | INSERT INTO colors VALUES (31,' | ||
+ | INSERT INTO colors VALUES (33,' | ||
+ | INSERT INTO colors VALUES (34,' | ||
+ | INSERT INTO colors VALUES (35,' | ||
+ | INSERT INTO colors VALUES (36,' | ||
+ | INSERT INTO colors VALUES (37,' | ||
+ | INSERT INTO colors VALUES (38,' | ||
+ | INSERT INTO colors VALUES (39,' | ||
+ | INSERT INTO colors VALUES (40,' | ||
+ | INSERT INTO colors VALUES (41,' | ||
+ | INSERT INTO colors VALUES (42,' | ||
+ | INSERT INTO colors VALUES (43,' | ||
+ | INSERT INTO colors VALUES (44,' | ||
+ | INSERT INTO colors VALUES (45,' | ||
+ | INSERT INTO colors VALUES (46,' | ||
+ | INSERT INTO colors VALUES (47,' | ||
+ | INSERT INTO colors VALUES (48,' | ||
+ | INSERT INTO colors VALUES (49,' | ||
+ | INSERT INTO colors VALUES (50,' | ||
+ | INSERT INTO colors VALUES (51,' | ||
+ | INSERT INTO colors VALUES (52,' | ||
+ | INSERT INTO colors VALUES (53,' | ||
+ | INSERT INTO colors VALUES (54,' | ||
+ | INSERT INTO colors VALUES (55,' | ||
+ | INSERT INTO colors VALUES (56,' | ||
+ | INSERT INTO colors VALUES (57,' | ||
+ | INSERT INTO colors VALUES (58,' | ||
+ | INSERT INTO colors VALUES (59,' | ||
+ | INSERT INTO colors VALUES (60,' | ||
+ | INSERT INTO colors VALUES (61,' | ||
+ | INSERT INTO colors VALUES (62,' | ||
+ | INSERT INTO colors VALUES (63,' | ||
+ | INSERT INTO colors VALUES (64,' | ||
+ | INSERT INTO colors VALUES (65,' | ||
+ | INSERT INTO colors VALUES (66,' | ||
+ | INSERT INTO colors VALUES (67,' | ||
+ | INSERT INTO colors VALUES (68,' | ||
+ | INSERT INTO colors VALUES (69,' | ||
+ | INSERT INTO colors VALUES (70,' | ||
+ | INSERT INTO colors VALUES (71,' | ||
+ | INSERT INTO colors VALUES (72,' | ||
+ | INSERT INTO colors VALUES (73,' | ||
+ | INSERT INTO colors VALUES (74,' | ||
+ | INSERT INTO colors VALUES (75,' | ||
+ | INSERT INTO colors VALUES (76,' | ||
+ | INSERT INTO colors VALUES (77,' | ||
+ | INSERT INTO colors VALUES (78,' | ||
+ | INSERT INTO colors VALUES (79,' | ||
+ | INSERT INTO colors VALUES (80,' | ||
+ | INSERT INTO colors VALUES (81,' | ||
+ | INSERT INTO colors VALUES (82,' | ||
+ | INSERT INTO colors VALUES (83,' | ||
+ | INSERT INTO colors VALUES (84,' | ||
+ | INSERT INTO colors VALUES (85,' | ||
+ | INSERT INTO colors VALUES (86,' | ||
+ | INSERT INTO colors VALUES (87,' | ||
+ | INSERT INTO colors VALUES (88,' | ||
+ | INSERT INTO colors VALUES (89,' | ||
+ | INSERT INTO colors VALUES (90,' | ||
+ | INSERT INTO colors VALUES (91,' | ||
+ | INSERT INTO colors VALUES (92,' | ||
+ | INSERT INTO colors VALUES (93,' | ||
+ | INSERT INTO colors VALUES (94,' | ||
+ | INSERT INTO colors VALUES (95,' | ||
+ | INSERT INTO colors VALUES (96,' | ||
+ | INSERT INTO colors VALUES (97,' | ||
+ | INSERT INTO colors VALUES (98,' | ||
+ | INSERT INTO colors VALUES (99,' | ||
+ | INSERT INTO colors VALUES (100,' | ||
+ | INSERT INTO colors VALUES (101,' | ||
+ | INSERT INTO colors VALUES (102,' | ||
+ | INSERT INTO colors VALUES (103,' | ||
+ | INSERT INTO colors VALUES (104,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_input` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_input ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | name varchar(200) NOT NULL default '', | ||
+ | input_string varchar(255) default NULL, | ||
+ | type_id tinyint(2) NOT NULL default ' | ||
+ | PRIMARY KEY (id), | ||
+ | KEY name (name) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_input` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_input VALUES (1,' | ||
+ | INSERT INTO data_input VALUES (2,' | ||
+ | INSERT INTO data_input VALUES (3,' | ||
+ | INSERT INTO data_input VALUES (4,' | ||
+ | INSERT INTO data_input VALUES (5,' | ||
+ | INSERT INTO data_input VALUES (6,' | ||
+ | INSERT INTO data_input VALUES (7,' | ||
+ | INSERT INTO data_input VALUES (8,' | ||
+ | INSERT INTO data_input VALUES (9,' | ||
+ | INSERT INTO data_input VALUES (10,' | ||
+ | INSERT INTO data_input VALUES (11,' | ||
+ | INSERT INTO data_input VALUES (12,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_input_data` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_input_data ( | ||
+ | data_input_field_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_template_data_id mediumint(8) unsigned NOT NULL default ' | ||
+ | t_value char(2) default NULL, | ||
+ | value text, | ||
+ | PRIMARY KEY (data_input_field_id, | ||
+ | KEY t_value (t_value) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_input_data` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (22, | ||
+ | INSERT INTO data_input_data VALUES (22, | ||
+ | INSERT INTO data_input_data VALUES (22, | ||
+ | INSERT INTO data_input_data VALUES (22, | ||
+ | INSERT INTO data_input_data VALUES (29, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (33, | ||
+ | INSERT INTO data_input_data VALUES (32, | ||
+ | INSERT INTO data_input_data VALUES (31, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (14, | ||
+ | INSERT INTO data_input_data VALUES (13, | ||
+ | INSERT INTO data_input_data VALUES (12, | ||
+ | INSERT INTO data_input_data VALUES (37, | ||
+ | INSERT INTO data_input_data VALUES (36, | ||
+ | INSERT INTO data_input_data VALUES (35, | ||
+ | INSERT INTO data_input_data VALUES (37, | ||
+ | INSERT INTO data_input_data VALUES (36, | ||
+ | INSERT INTO data_input_data VALUES (35, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (22, | ||
+ | INSERT INTO data_input_data VALUES (22, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (1, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (2, | ||
+ | INSERT INTO data_input_data VALUES (3, | ||
+ | INSERT INTO data_input_data VALUES (4, | ||
+ | INSERT INTO data_input_data VALUES (5, | ||
+ | INSERT INTO data_input_data VALUES (6, | ||
+ | INSERT INTO data_input_data VALUES (20, | ||
+ | INSERT INTO data_input_data VALUES (20, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_input_fields` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_input_fields ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | data_input_id mediumint(8) unsigned NOT NULL default ' | ||
+ | name varchar(200) NOT NULL default '', | ||
+ | data_name varchar(50) NOT NULL default '', | ||
+ | input_output char(3) NOT NULL default '', | ||
+ | update_rra char(2) default ' | ||
+ | sequence smallint(5) NOT NULL default ' | ||
+ | type_code varchar(40) default NULL, | ||
+ | regexp_match varchar(200) default NULL, | ||
+ | allow_nulls char(2) default NULL, | ||
+ | PRIMARY KEY (id), | ||
+ | KEY data_input_id (data_input_id), | ||
+ | KEY type_code (type_code) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_input_fields` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_input_fields VALUES (1,' | ||
+ | INSERT INTO data_input_fields VALUES (2,' | ||
+ | INSERT INTO data_input_fields VALUES (3,' | ||
+ | INSERT INTO data_input_fields VALUES (4,' | ||
+ | INSERT INTO data_input_fields VALUES (5,' | ||
+ | INSERT INTO data_input_fields VALUES (6,' | ||
+ | INSERT INTO data_input_fields VALUES (7,' | ||
+ | INSERT INTO data_input_fields VALUES (8,' | ||
+ | INSERT INTO data_input_fields VALUES (9,' | ||
+ | INSERT INTO data_input_fields VALUES (10,' | ||
+ | INSERT INTO data_input_fields VALUES (11,' | ||
+ | INSERT INTO data_input_fields VALUES (12,' | ||
+ | INSERT INTO data_input_fields VALUES (13,' | ||
+ | INSERT INTO data_input_fields VALUES (14,' | ||
+ | INSERT INTO data_input_fields VALUES (15,' | ||
+ | INSERT INTO data_input_fields VALUES (16,' | ||
+ | INSERT INTO data_input_fields VALUES (17,' | ||
+ | INSERT INTO data_input_fields VALUES (18,' | ||
+ | INSERT INTO data_input_fields VALUES (19,' | ||
+ | INSERT INTO data_input_fields VALUES (20,' | ||
+ | INSERT INTO data_input_fields VALUES (21,' | ||
+ | INSERT INTO data_input_fields VALUES (22,' | ||
+ | INSERT INTO data_input_fields VALUES (23,' | ||
+ | INSERT INTO data_input_fields VALUES (24,' | ||
+ | INSERT INTO data_input_fields VALUES (25,' | ||
+ | INSERT INTO data_input_fields VALUES (26,' | ||
+ | INSERT INTO data_input_fields VALUES (27,' | ||
+ | INSERT INTO data_input_fields VALUES (28,' | ||
+ | INSERT INTO data_input_fields VALUES (29,' | ||
+ | INSERT INTO data_input_fields VALUES (30,' | ||
+ | INSERT INTO data_input_fields VALUES (31,' | ||
+ | INSERT INTO data_input_fields VALUES (32,' | ||
+ | INSERT INTO data_input_fields VALUES (33,' | ||
+ | INSERT INTO data_input_fields VALUES (34,' | ||
+ | INSERT INTO data_input_fields VALUES (35,' | ||
+ | INSERT INTO data_input_fields VALUES (36,' | ||
+ | INSERT INTO data_input_fields VALUES (37,' | ||
+ | INSERT INTO data_input_fields VALUES (38,' | ||
+ | INSERT INTO data_input_fields VALUES (39,' | ||
+ | INSERT INTO data_input_fields VALUES (40,' | ||
+ | INSERT INTO data_input_fields VALUES (41,' | ||
+ | INSERT INTO data_input_fields VALUES (42,' | ||
+ | INSERT INTO data_input_fields VALUES (43,' | ||
+ | INSERT INTO data_input_fields VALUES (44,' | ||
+ | INSERT INTO data_input_fields VALUES (45,' | ||
+ | INSERT INTO data_input_fields VALUES (46,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_local` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_local ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | data_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | snmp_query_id mediumint(8) NOT NULL default ' | ||
+ | snmp_index varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_local` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_local VALUES (3, | ||
+ | INSERT INTO data_local VALUES (4, | ||
+ | INSERT INTO data_local VALUES (5, | ||
+ | INSERT INTO data_local VALUES (6, | ||
+ | INSERT INTO data_local VALUES (7, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_template` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_template ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | name varchar(150) NOT NULL default '', | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_template` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_template VALUES (3,' | ||
+ | INSERT INTO data_template VALUES (4,' | ||
+ | INSERT INTO data_template VALUES (5,' | ||
+ | INSERT INTO data_template VALUES (6,' | ||
+ | INSERT INTO data_template VALUES (7,' | ||
+ | INSERT INTO data_template VALUES (8,' | ||
+ | INSERT INTO data_template VALUES (9,' | ||
+ | INSERT INTO data_template VALUES (10,' | ||
+ | INSERT INTO data_template VALUES (11,' | ||
+ | INSERT INTO data_template VALUES (13,' | ||
+ | INSERT INTO data_template VALUES (15,' | ||
+ | INSERT INTO data_template VALUES (16,' | ||
+ | INSERT INTO data_template VALUES (17,' | ||
+ | INSERT INTO data_template VALUES (18,' | ||
+ | INSERT INTO data_template VALUES (19,' | ||
+ | INSERT INTO data_template VALUES (20,' | ||
+ | INSERT INTO data_template VALUES (22,' | ||
+ | INSERT INTO data_template VALUES (23,' | ||
+ | INSERT INTO data_template VALUES (24,' | ||
+ | INSERT INTO data_template VALUES (25,' | ||
+ | INSERT INTO data_template VALUES (26,' | ||
+ | INSERT INTO data_template VALUES (27,' | ||
+ | INSERT INTO data_template VALUES (30,' | ||
+ | INSERT INTO data_template VALUES (31,' | ||
+ | INSERT INTO data_template VALUES (32,' | ||
+ | INSERT INTO data_template VALUES (33,' | ||
+ | INSERT INTO data_template VALUES (34,' | ||
+ | INSERT INTO data_template VALUES (35,' | ||
+ | INSERT INTO data_template VALUES (36,' | ||
+ | INSERT INTO data_template VALUES (37,' | ||
+ | INSERT INTO data_template VALUES (38,' | ||
+ | INSERT INTO data_template VALUES (39,' | ||
+ | INSERT INTO data_template VALUES (40,' | ||
+ | INSERT INTO data_template VALUES (41,' | ||
+ | INSERT INTO data_template VALUES (42,' | ||
+ | INSERT INTO data_template VALUES (43,' | ||
+ | INSERT INTO data_template VALUES (44,' | ||
+ | INSERT INTO data_template VALUES (45,' | ||
+ | INSERT INTO data_template VALUES (46,' | ||
+ | INSERT INTO data_template VALUES (47,' | ||
+ | INSERT INTO data_template VALUES (48,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_template_data` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_template_data ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | local_data_template_data_id mediumint(8) unsigned NOT NULL default ' | ||
+ | local_data_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_input_id mediumint(8) unsigned NOT NULL default ' | ||
+ | t_name char(2) default NULL, | ||
+ | name varchar(250) NOT NULL default '', | ||
+ | name_cache varchar(255) NOT NULL default '', | ||
+ | data_source_path varchar(255) default NULL, | ||
+ | t_active char(2) default NULL, | ||
+ | active char(2) default NULL, | ||
+ | t_rrd_step char(2) default NULL, | ||
+ | rrd_step mediumint(8) unsigned NOT NULL default ' | ||
+ | t_rra_id char(2) default NULL, | ||
+ | PRIMARY KEY (id), | ||
+ | KEY local_data_id (local_data_id), | ||
+ | KEY data_template_id (data_template_id), | ||
+ | KEY data_input_id (data_input_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_template_data` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_template_data VALUES (3, | ||
+ | INSERT INTO data_template_data VALUES (4, | ||
+ | INSERT INTO data_template_data VALUES (5, | ||
+ | INSERT INTO data_template_data VALUES (6, | ||
+ | INSERT INTO data_template_data VALUES (7, | ||
+ | INSERT INTO data_template_data VALUES (8, | ||
+ | INSERT INTO data_template_data VALUES (9, | ||
+ | INSERT INTO data_template_data VALUES (10, | ||
+ | INSERT INTO data_template_data VALUES (11, | ||
+ | INSERT INTO data_template_data VALUES (13, | ||
+ | INSERT INTO data_template_data VALUES (15, | ||
+ | INSERT INTO data_template_data VALUES (16, | ||
+ | INSERT INTO data_template_data VALUES (17, | ||
+ | INSERT INTO data_template_data VALUES (18, | ||
+ | INSERT INTO data_template_data VALUES (19, | ||
+ | INSERT INTO data_template_data VALUES (20, | ||
+ | INSERT INTO data_template_data VALUES (22, | ||
+ | INSERT INTO data_template_data VALUES (23, | ||
+ | INSERT INTO data_template_data VALUES (24, | ||
+ | INSERT INTO data_template_data VALUES (25, | ||
+ | INSERT INTO data_template_data VALUES (26, | ||
+ | INSERT INTO data_template_data VALUES (27, | ||
+ | INSERT INTO data_template_data VALUES (30, | ||
+ | INSERT INTO data_template_data VALUES (31, | ||
+ | INSERT INTO data_template_data VALUES (32, | ||
+ | INSERT INTO data_template_data VALUES (33, | ||
+ | INSERT INTO data_template_data VALUES (34, | ||
+ | INSERT INTO data_template_data VALUES (35, | ||
+ | INSERT INTO data_template_data VALUES (36, | ||
+ | INSERT INTO data_template_data VALUES (37, | ||
+ | INSERT INTO data_template_data VALUES (38, | ||
+ | INSERT INTO data_template_data VALUES (39, | ||
+ | INSERT INTO data_template_data VALUES (40, | ||
+ | INSERT INTO data_template_data VALUES (41, | ||
+ | INSERT INTO data_template_data VALUES (55, | ||
+ | INSERT INTO data_template_data VALUES (56, | ||
+ | INSERT INTO data_template_data VALUES (57, | ||
+ | INSERT INTO data_template_data VALUES (58, | ||
+ | INSERT INTO data_template_data VALUES (59, | ||
+ | INSERT INTO data_template_data VALUES (62, | ||
+ | INSERT INTO data_template_data VALUES (63, | ||
+ | INSERT INTO data_template_data VALUES (64, | ||
+ | INSERT INTO data_template_data VALUES (65, | ||
+ | INSERT INTO data_template_data VALUES (66, | ||
+ | INSERT INTO data_template_data VALUES (68, | ||
+ | INSERT INTO data_template_data VALUES (69, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_template_data_rra` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_template_data_rra ( | ||
+ | data_template_data_id mediumint(8) unsigned NOT NULL default ' | ||
+ | rra_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (data_template_data_id, | ||
+ | KEY data_template_data_id (data_template_data_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_template_data_rra` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_template_data_rra VALUES (3,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (3,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (3,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (3,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (4,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (4,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (4,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (4,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (5,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (5,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (5,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (5,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (6,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (6,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (6,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (6,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (7,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (7,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (7,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (7,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (8,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (8,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (8,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (8,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (9,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (9,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (9,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (9,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (10,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (10,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (10,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (10,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (11,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (11,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (11,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (11,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (13,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (13,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (13,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (13,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (15,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (15,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (15,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (15,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (16,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (16,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (16,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (16,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (17,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (17,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (17,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (17,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (18,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (18,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (18,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (18,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (19,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (19,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (19,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (19,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (20,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (20,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (20,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (20,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (22,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (22,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (22,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (22,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (23,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (23,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (23,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (23,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (24,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (24,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (24,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (24,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (25,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (25,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (25,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (25,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (26,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (26,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (26,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (26,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (27,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (27,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (27,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (27,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (30,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (30,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (30,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (30,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (31,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (31,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (31,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (31,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (32,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (32,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (32,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (32,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (33,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (33,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (33,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (33,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (34,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (34,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (34,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (34,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (35,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (35,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (35,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (35,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (36,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (36,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (36,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (36,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (37,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (37,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (37,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (37,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (38,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (38,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (38,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (38,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (39,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (39,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (39,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (39,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (40,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (40,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (40,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (40,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (41,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (41,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (41,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (41,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (55,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (55,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (55,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (55,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (56,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (56,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (56,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (56,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (57,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (57,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (57,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (57,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (58,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (58,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (58,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (58,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (59,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (59,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (59,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (59,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (62,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (62,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (62,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (62,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (63,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (63,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (63,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (63,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (64,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (64,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (64,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (64,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (65,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (65,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (65,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (65,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (66,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (66,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (66,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (66,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (68,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (68,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (68,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (68,4); | ||
+ | INSERT INTO data_template_data_rra VALUES (69,1); | ||
+ | INSERT INTO data_template_data_rra VALUES (69,2); | ||
+ | INSERT INTO data_template_data_rra VALUES (69,3); | ||
+ | INSERT INTO data_template_data_rra VALUES (69,4); | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `data_template_rrd` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE data_template_rrd ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | local_data_template_rrd_id mediumint(8) unsigned NOT NULL default ' | ||
+ | local_data_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | t_rrd_maximum char(2) default NULL, | ||
+ | rrd_maximum varchar(20) NOT NULL default ' | ||
+ | t_rrd_minimum char(2) default NULL, | ||
+ | rrd_minimum varchar(20) NOT NULL default ' | ||
+ | t_rrd_heartbeat char(2) default NULL, | ||
+ | rrd_heartbeat mediumint(6) NOT NULL default ' | ||
+ | t_data_source_type_id char(2) default NULL, | ||
+ | data_source_type_id smallint(5) NOT NULL default ' | ||
+ | t_data_source_name char(2) default NULL, | ||
+ | data_source_name varchar(19) NOT NULL default '', | ||
+ | t_data_input_field_id char(2) default NULL, | ||
+ | data_input_field_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (id), | ||
+ | UNIQUE KEY `duplicate_dsname_contraint` (`local_data_id`, | ||
+ | KEY local_data_id (local_data_id), | ||
+ | KEY data_template_id (data_template_id), | ||
+ | KEY local_data_template_rrd_id (local_data_template_rrd_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `data_template_rrd` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO data_template_rrd VALUES (3,' | ||
+ | INSERT INTO data_template_rrd VALUES (4,' | ||
+ | INSERT INTO data_template_rrd VALUES (5,' | ||
+ | INSERT INTO data_template_rrd VALUES (6,' | ||
+ | INSERT INTO data_template_rrd VALUES (7,' | ||
+ | INSERT INTO data_template_rrd VALUES (8,' | ||
+ | INSERT INTO data_template_rrd VALUES (9,' | ||
+ | INSERT INTO data_template_rrd VALUES (10,' | ||
+ | INSERT INTO data_template_rrd VALUES (11,' | ||
+ | INSERT INTO data_template_rrd VALUES (12,' | ||
+ | INSERT INTO data_template_rrd VALUES (13,' | ||
+ | INSERT INTO data_template_rrd VALUES (14,' | ||
+ | INSERT INTO data_template_rrd VALUES (16,' | ||
+ | INSERT INTO data_template_rrd VALUES (18,' | ||
+ | INSERT INTO data_template_rrd VALUES (19,' | ||
+ | INSERT INTO data_template_rrd VALUES (20,' | ||
+ | INSERT INTO data_template_rrd VALUES (21,' | ||
+ | INSERT INTO data_template_rrd VALUES (22,' | ||
+ | INSERT INTO data_template_rrd VALUES (23,' | ||
+ | INSERT INTO data_template_rrd VALUES (25,' | ||
+ | INSERT INTO data_template_rrd VALUES (26,' | ||
+ | INSERT INTO data_template_rrd VALUES (27,' | ||
+ | INSERT INTO data_template_rrd VALUES (28,' | ||
+ | INSERT INTO data_template_rrd VALUES (29,' | ||
+ | INSERT INTO data_template_rrd VALUES (30,' | ||
+ | INSERT INTO data_template_rrd VALUES (33,' | ||
+ | INSERT INTO data_template_rrd VALUES (34,' | ||
+ | INSERT INTO data_template_rrd VALUES (35,' | ||
+ | INSERT INTO data_template_rrd VALUES (36,' | ||
+ | INSERT INTO data_template_rrd VALUES (37,' | ||
+ | INSERT INTO data_template_rrd VALUES (38,' | ||
+ | INSERT INTO data_template_rrd VALUES (39,' | ||
+ | INSERT INTO data_template_rrd VALUES (40,' | ||
+ | INSERT INTO data_template_rrd VALUES (42,' | ||
+ | INSERT INTO data_template_rrd VALUES (43,' | ||
+ | INSERT INTO data_template_rrd VALUES (44,' | ||
+ | INSERT INTO data_template_rrd VALUES (46,' | ||
+ | INSERT INTO data_template_rrd VALUES (47,' | ||
+ | INSERT INTO data_template_rrd VALUES (48,' | ||
+ | INSERT INTO data_template_rrd VALUES (49,' | ||
+ | INSERT INTO data_template_rrd VALUES (50,' | ||
+ | INSERT INTO data_template_rrd VALUES (51,' | ||
+ | INSERT INTO data_template_rrd VALUES (52,' | ||
+ | INSERT INTO data_template_rrd VALUES (53,' | ||
+ | INSERT INTO data_template_rrd VALUES (54,' | ||
+ | INSERT INTO data_template_rrd VALUES (55,' | ||
+ | INSERT INTO data_template_rrd VALUES (56,' | ||
+ | INSERT INTO data_template_rrd VALUES (76,' | ||
+ | INSERT INTO data_template_rrd VALUES (78,' | ||
+ | INSERT INTO data_template_rrd VALUES (79,' | ||
+ | INSERT INTO data_template_rrd VALUES (80,' | ||
+ | INSERT INTO data_template_rrd VALUES (81,' | ||
+ | INSERT INTO data_template_rrd VALUES (84,'', | ||
+ | INSERT INTO data_template_rrd VALUES (85,'', | ||
+ | INSERT INTO data_template_rrd VALUES (86,'', | ||
+ | INSERT INTO data_template_rrd VALUES (87,'', | ||
+ | INSERT INTO data_template_rrd VALUES (88,'', | ||
+ | INSERT INTO data_template_rrd VALUES (89,'', | ||
+ | INSERT INTO data_template_rrd VALUES (90,'', | ||
+ | INSERT INTO data_template_rrd VALUES (92,' | ||
+ | INSERT INTO data_template_rrd VALUES (95,' | ||
+ | INSERT INTO data_template_rrd VALUES (96,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_local` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_local ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | snmp_query_id mediumint(8) NOT NULL default ' | ||
+ | snmp_index varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (id), | ||
+ | KEY host_id (host_id), | ||
+ | KEY graph_template_id (graph_template_id), | ||
+ | KEY snmp_query_id (snmp_query_id), | ||
+ | KEY snmp_index (snmp_index) | ||
+ | ) ENGINE=MyISAM COMMENT=' | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_local` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_local VALUES (1, | ||
+ | INSERT INTO graph_local VALUES (2, | ||
+ | INSERT INTO graph_local VALUES (3, | ||
+ | INSERT INTO graph_local VALUES (4, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_template_input` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_template_input ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | name varchar(255) NOT NULL default '', | ||
+ | description text, | ||
+ | column_name varchar(50) NOT NULL default '', | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM COMMENT=' | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_template_input` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_template_input VALUES (3,' | ||
+ | INSERT INTO graph_template_input VALUES (4,' | ||
+ | INSERT INTO graph_template_input VALUES (5,' | ||
+ | INSERT INTO graph_template_input VALUES (6,' | ||
+ | INSERT INTO graph_template_input VALUES (7,' | ||
+ | INSERT INTO graph_template_input VALUES (8,' | ||
+ | INSERT INTO graph_template_input VALUES (9,' | ||
+ | INSERT INTO graph_template_input VALUES (10,' | ||
+ | INSERT INTO graph_template_input VALUES (11,' | ||
+ | INSERT INTO graph_template_input VALUES (12,' | ||
+ | INSERT INTO graph_template_input VALUES (13,' | ||
+ | INSERT INTO graph_template_input VALUES (14,' | ||
+ | INSERT INTO graph_template_input VALUES (15,' | ||
+ | INSERT INTO graph_template_input VALUES (16,' | ||
+ | INSERT INTO graph_template_input VALUES (17,' | ||
+ | INSERT INTO graph_template_input VALUES (18,' | ||
+ | INSERT INTO graph_template_input VALUES (19,' | ||
+ | INSERT INTO graph_template_input VALUES (20,' | ||
+ | INSERT INTO graph_template_input VALUES (21,' | ||
+ | INSERT INTO graph_template_input VALUES (22,' | ||
+ | INSERT INTO graph_template_input VALUES (23,' | ||
+ | INSERT INTO graph_template_input VALUES (24,' | ||
+ | INSERT INTO graph_template_input VALUES (25,' | ||
+ | INSERT INTO graph_template_input VALUES (26,' | ||
+ | INSERT INTO graph_template_input VALUES (27,' | ||
+ | INSERT INTO graph_template_input VALUES (30,' | ||
+ | INSERT INTO graph_template_input VALUES (31,' | ||
+ | INSERT INTO graph_template_input VALUES (32,' | ||
+ | INSERT INTO graph_template_input VALUES (33,' | ||
+ | INSERT INTO graph_template_input VALUES (34,' | ||
+ | INSERT INTO graph_template_input VALUES (35,' | ||
+ | INSERT INTO graph_template_input VALUES (36,' | ||
+ | INSERT INTO graph_template_input VALUES (37,' | ||
+ | INSERT INTO graph_template_input VALUES (38,' | ||
+ | INSERT INTO graph_template_input VALUES (39,' | ||
+ | INSERT INTO graph_template_input VALUES (40,' | ||
+ | INSERT INTO graph_template_input VALUES (41,' | ||
+ | INSERT INTO graph_template_input VALUES (42,' | ||
+ | INSERT INTO graph_template_input VALUES (44,' | ||
+ | INSERT INTO graph_template_input VALUES (45,' | ||
+ | INSERT INTO graph_template_input VALUES (46,' | ||
+ | INSERT INTO graph_template_input VALUES (47,' | ||
+ | INSERT INTO graph_template_input VALUES (48,' | ||
+ | INSERT INTO graph_template_input VALUES (49,' | ||
+ | INSERT INTO graph_template_input VALUES (51,' | ||
+ | INSERT INTO graph_template_input VALUES (52,' | ||
+ | INSERT INTO graph_template_input VALUES (53,' | ||
+ | INSERT INTO graph_template_input VALUES (54,' | ||
+ | INSERT INTO graph_template_input VALUES (55,' | ||
+ | INSERT INTO graph_template_input VALUES (56,' | ||
+ | INSERT INTO graph_template_input VALUES (57,' | ||
+ | INSERT INTO graph_template_input VALUES (58,' | ||
+ | INSERT INTO graph_template_input VALUES (59,' | ||
+ | INSERT INTO graph_template_input VALUES (60,' | ||
+ | INSERT INTO graph_template_input VALUES (61,' | ||
+ | INSERT INTO graph_template_input VALUES (62,' | ||
+ | INSERT INTO graph_template_input VALUES (63,' | ||
+ | INSERT INTO graph_template_input VALUES (64,' | ||
+ | INSERT INTO graph_template_input VALUES (65,' | ||
+ | INSERT INTO graph_template_input VALUES (66,' | ||
+ | INSERT INTO graph_template_input VALUES (67,' | ||
+ | INSERT INTO graph_template_input VALUES (68,' | ||
+ | INSERT INTO graph_template_input VALUES (69,' | ||
+ | INSERT INTO graph_template_input VALUES (70,' | ||
+ | INSERT INTO graph_template_input VALUES (71,' | ||
+ | INSERT INTO graph_template_input VALUES (72,' | ||
+ | INSERT INTO graph_template_input VALUES (73,' | ||
+ | INSERT INTO graph_template_input VALUES (74,' | ||
+ | INSERT INTO graph_template_input VALUES (75,' | ||
+ | INSERT INTO graph_template_input VALUES (76,' | ||
+ | INSERT INTO graph_template_input VALUES (77,' | ||
+ | INSERT INTO graph_template_input VALUES (78,' | ||
+ | INSERT INTO graph_template_input VALUES (79,' | ||
+ | INSERT INTO graph_template_input VALUES (80,' | ||
+ | INSERT INTO graph_template_input VALUES (81,' | ||
+ | INSERT INTO graph_template_input VALUES (82,' | ||
+ | INSERT INTO graph_template_input VALUES (83,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_template_input_defs` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_template_input_defs ( | ||
+ | graph_template_input_id mediumint(8) unsigned NOT NULL default ' | ||
+ | graph_template_item_id int(12) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (graph_template_input_id, | ||
+ | KEY graph_template_input_id (graph_template_input_id) | ||
+ | ) ENGINE=MyISAM COMMENT=' | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_template_input_defs` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_template_input_defs VALUES (3,9); | ||
+ | INSERT INTO graph_template_input_defs VALUES (3,10); | ||
+ | INSERT INTO graph_template_input_defs VALUES (3,11); | ||
+ | INSERT INTO graph_template_input_defs VALUES (3,12); | ||
+ | INSERT INTO graph_template_input_defs VALUES (4,13); | ||
+ | INSERT INTO graph_template_input_defs VALUES (4,14); | ||
+ | INSERT INTO graph_template_input_defs VALUES (4,15); | ||
+ | INSERT INTO graph_template_input_defs VALUES (4,16); | ||
+ | INSERT INTO graph_template_input_defs VALUES (5,21); | ||
+ | INSERT INTO graph_template_input_defs VALUES (5,22); | ||
+ | INSERT INTO graph_template_input_defs VALUES (5,23); | ||
+ | INSERT INTO graph_template_input_defs VALUES (5,24); | ||
+ | INSERT INTO graph_template_input_defs VALUES (6,17); | ||
+ | INSERT INTO graph_template_input_defs VALUES (6,18); | ||
+ | INSERT INTO graph_template_input_defs VALUES (6,19); | ||
+ | INSERT INTO graph_template_input_defs VALUES (6,20); | ||
+ | INSERT INTO graph_template_input_defs VALUES (7,45); | ||
+ | INSERT INTO graph_template_input_defs VALUES (7,46); | ||
+ | INSERT INTO graph_template_input_defs VALUES (7,47); | ||
+ | INSERT INTO graph_template_input_defs VALUES (7,48); | ||
+ | INSERT INTO graph_template_input_defs VALUES (8,49); | ||
+ | INSERT INTO graph_template_input_defs VALUES (8,50); | ||
+ | INSERT INTO graph_template_input_defs VALUES (8,51); | ||
+ | INSERT INTO graph_template_input_defs VALUES (8,52); | ||
+ | INSERT INTO graph_template_input_defs VALUES (9,45); | ||
+ | INSERT INTO graph_template_input_defs VALUES (10,49); | ||
+ | INSERT INTO graph_template_input_defs VALUES (11,53); | ||
+ | INSERT INTO graph_template_input_defs VALUES (11,54); | ||
+ | INSERT INTO graph_template_input_defs VALUES (11,55); | ||
+ | INSERT INTO graph_template_input_defs VALUES (11,56); | ||
+ | INSERT INTO graph_template_input_defs VALUES (12,57); | ||
+ | INSERT INTO graph_template_input_defs VALUES (12,58); | ||
+ | INSERT INTO graph_template_input_defs VALUES (12,59); | ||
+ | INSERT INTO graph_template_input_defs VALUES (12,60); | ||
+ | INSERT INTO graph_template_input_defs VALUES (13,53); | ||
+ | INSERT INTO graph_template_input_defs VALUES (14,57); | ||
+ | INSERT INTO graph_template_input_defs VALUES (15,61); | ||
+ | INSERT INTO graph_template_input_defs VALUES (15,62); | ||
+ | INSERT INTO graph_template_input_defs VALUES (15,63); | ||
+ | INSERT INTO graph_template_input_defs VALUES (15,64); | ||
+ | INSERT INTO graph_template_input_defs VALUES (16,61); | ||
+ | INSERT INTO graph_template_input_defs VALUES (17,61); | ||
+ | INSERT INTO graph_template_input_defs VALUES (18,65); | ||
+ | INSERT INTO graph_template_input_defs VALUES (18,66); | ||
+ | INSERT INTO graph_template_input_defs VALUES (18,67); | ||
+ | INSERT INTO graph_template_input_defs VALUES (18,68); | ||
+ | INSERT INTO graph_template_input_defs VALUES (19,65); | ||
+ | INSERT INTO graph_template_input_defs VALUES (20,69); | ||
+ | INSERT INTO graph_template_input_defs VALUES (20,70); | ||
+ | INSERT INTO graph_template_input_defs VALUES (21,71); | ||
+ | INSERT INTO graph_template_input_defs VALUES (21,72); | ||
+ | INSERT INTO graph_template_input_defs VALUES (22,73); | ||
+ | INSERT INTO graph_template_input_defs VALUES (22,74); | ||
+ | INSERT INTO graph_template_input_defs VALUES (23,76); | ||
+ | INSERT INTO graph_template_input_defs VALUES (23,77); | ||
+ | INSERT INTO graph_template_input_defs VALUES (23,78); | ||
+ | INSERT INTO graph_template_input_defs VALUES (23,79); | ||
+ | INSERT INTO graph_template_input_defs VALUES (24,76); | ||
+ | INSERT INTO graph_template_input_defs VALUES (25,80); | ||
+ | INSERT INTO graph_template_input_defs VALUES (25,81); | ||
+ | INSERT INTO graph_template_input_defs VALUES (26,82); | ||
+ | INSERT INTO graph_template_input_defs VALUES (26,83); | ||
+ | INSERT INTO graph_template_input_defs VALUES (27,84); | ||
+ | INSERT INTO graph_template_input_defs VALUES (27,85); | ||
+ | INSERT INTO graph_template_input_defs VALUES (30,95); | ||
+ | INSERT INTO graph_template_input_defs VALUES (30,96); | ||
+ | INSERT INTO graph_template_input_defs VALUES (30,97); | ||
+ | INSERT INTO graph_template_input_defs VALUES (30,98); | ||
+ | INSERT INTO graph_template_input_defs VALUES (31,99); | ||
+ | INSERT INTO graph_template_input_defs VALUES (31,100); | ||
+ | INSERT INTO graph_template_input_defs VALUES (31,101); | ||
+ | INSERT INTO graph_template_input_defs VALUES (31,102); | ||
+ | INSERT INTO graph_template_input_defs VALUES (32,29); | ||
+ | INSERT INTO graph_template_input_defs VALUES (32,30); | ||
+ | INSERT INTO graph_template_input_defs VALUES (32,31); | ||
+ | INSERT INTO graph_template_input_defs VALUES (32,32); | ||
+ | INSERT INTO graph_template_input_defs VALUES (33,33); | ||
+ | INSERT INTO graph_template_input_defs VALUES (33,34); | ||
+ | INSERT INTO graph_template_input_defs VALUES (33,35); | ||
+ | INSERT INTO graph_template_input_defs VALUES (33,36); | ||
+ | INSERT INTO graph_template_input_defs VALUES (34,37); | ||
+ | INSERT INTO graph_template_input_defs VALUES (34,38); | ||
+ | INSERT INTO graph_template_input_defs VALUES (34,39); | ||
+ | INSERT INTO graph_template_input_defs VALUES (34,40); | ||
+ | INSERT INTO graph_template_input_defs VALUES (35,103); | ||
+ | INSERT INTO graph_template_input_defs VALUES (35,104); | ||
+ | INSERT INTO graph_template_input_defs VALUES (35,105); | ||
+ | INSERT INTO graph_template_input_defs VALUES (35,106); | ||
+ | INSERT INTO graph_template_input_defs VALUES (36,107); | ||
+ | INSERT INTO graph_template_input_defs VALUES (36,108); | ||
+ | INSERT INTO graph_template_input_defs VALUES (36,109); | ||
+ | INSERT INTO graph_template_input_defs VALUES (36,110); | ||
+ | INSERT INTO graph_template_input_defs VALUES (37,111); | ||
+ | INSERT INTO graph_template_input_defs VALUES (37,112); | ||
+ | INSERT INTO graph_template_input_defs VALUES (37,113); | ||
+ | INSERT INTO graph_template_input_defs VALUES (37,114); | ||
+ | INSERT INTO graph_template_input_defs VALUES (38,115); | ||
+ | INSERT INTO graph_template_input_defs VALUES (38,116); | ||
+ | INSERT INTO graph_template_input_defs VALUES (38,117); | ||
+ | INSERT INTO graph_template_input_defs VALUES (38,118); | ||
+ | INSERT INTO graph_template_input_defs VALUES (39,119); | ||
+ | INSERT INTO graph_template_input_defs VALUES (39,120); | ||
+ | INSERT INTO graph_template_input_defs VALUES (39,121); | ||
+ | INSERT INTO graph_template_input_defs VALUES (39,122); | ||
+ | INSERT INTO graph_template_input_defs VALUES (40,123); | ||
+ | INSERT INTO graph_template_input_defs VALUES (40,124); | ||
+ | INSERT INTO graph_template_input_defs VALUES (40,125); | ||
+ | INSERT INTO graph_template_input_defs VALUES (40,126); | ||
+ | INSERT INTO graph_template_input_defs VALUES (41,127); | ||
+ | INSERT INTO graph_template_input_defs VALUES (41,128); | ||
+ | INSERT INTO graph_template_input_defs VALUES (41,129); | ||
+ | INSERT INTO graph_template_input_defs VALUES (41,130); | ||
+ | INSERT INTO graph_template_input_defs VALUES (42,131); | ||
+ | INSERT INTO graph_template_input_defs VALUES (42,132); | ||
+ | INSERT INTO graph_template_input_defs VALUES (42,133); | ||
+ | INSERT INTO graph_template_input_defs VALUES (42,134); | ||
+ | INSERT INTO graph_template_input_defs VALUES (44,119); | ||
+ | INSERT INTO graph_template_input_defs VALUES (45,139); | ||
+ | INSERT INTO graph_template_input_defs VALUES (45,140); | ||
+ | INSERT INTO graph_template_input_defs VALUES (45,141); | ||
+ | INSERT INTO graph_template_input_defs VALUES (45,142); | ||
+ | INSERT INTO graph_template_input_defs VALUES (46,139); | ||
+ | INSERT INTO graph_template_input_defs VALUES (47,143); | ||
+ | INSERT INTO graph_template_input_defs VALUES (47,144); | ||
+ | INSERT INTO graph_template_input_defs VALUES (47,145); | ||
+ | INSERT INTO graph_template_input_defs VALUES (47,146); | ||
+ | INSERT INTO graph_template_input_defs VALUES (48,147); | ||
+ | INSERT INTO graph_template_input_defs VALUES (48,148); | ||
+ | INSERT INTO graph_template_input_defs VALUES (48,149); | ||
+ | INSERT INTO graph_template_input_defs VALUES (48,150); | ||
+ | INSERT INTO graph_template_input_defs VALUES (49,151); | ||
+ | INSERT INTO graph_template_input_defs VALUES (49,152); | ||
+ | INSERT INTO graph_template_input_defs VALUES (49,153); | ||
+ | INSERT INTO graph_template_input_defs VALUES (49,154); | ||
+ | INSERT INTO graph_template_input_defs VALUES (51,159); | ||
+ | INSERT INTO graph_template_input_defs VALUES (51,160); | ||
+ | INSERT INTO graph_template_input_defs VALUES (51,161); | ||
+ | INSERT INTO graph_template_input_defs VALUES (51,162); | ||
+ | INSERT INTO graph_template_input_defs VALUES (52,163); | ||
+ | INSERT INTO graph_template_input_defs VALUES (52,164); | ||
+ | INSERT INTO graph_template_input_defs VALUES (52,165); | ||
+ | INSERT INTO graph_template_input_defs VALUES (52,166); | ||
+ | INSERT INTO graph_template_input_defs VALUES (53,172); | ||
+ | INSERT INTO graph_template_input_defs VALUES (53,173); | ||
+ | INSERT INTO graph_template_input_defs VALUES (53,174); | ||
+ | INSERT INTO graph_template_input_defs VALUES (53,175); | ||
+ | INSERT INTO graph_template_input_defs VALUES (54,167); | ||
+ | INSERT INTO graph_template_input_defs VALUES (54,169); | ||
+ | INSERT INTO graph_template_input_defs VALUES (54,170); | ||
+ | INSERT INTO graph_template_input_defs VALUES (54,171); | ||
+ | INSERT INTO graph_template_input_defs VALUES (55,180); | ||
+ | INSERT INTO graph_template_input_defs VALUES (55,181); | ||
+ | INSERT INTO graph_template_input_defs VALUES (55,182); | ||
+ | INSERT INTO graph_template_input_defs VALUES (55,183); | ||
+ | INSERT INTO graph_template_input_defs VALUES (56,184); | ||
+ | INSERT INTO graph_template_input_defs VALUES (56,185); | ||
+ | INSERT INTO graph_template_input_defs VALUES (56,186); | ||
+ | INSERT INTO graph_template_input_defs VALUES (56,187); | ||
+ | INSERT INTO graph_template_input_defs VALUES (57,188); | ||
+ | INSERT INTO graph_template_input_defs VALUES (57,189); | ||
+ | INSERT INTO graph_template_input_defs VALUES (57,190); | ||
+ | INSERT INTO graph_template_input_defs VALUES (57,191); | ||
+ | INSERT INTO graph_template_input_defs VALUES (58,192); | ||
+ | INSERT INTO graph_template_input_defs VALUES (58,193); | ||
+ | INSERT INTO graph_template_input_defs VALUES (58,194); | ||
+ | INSERT INTO graph_template_input_defs VALUES (58,195); | ||
+ | INSERT INTO graph_template_input_defs VALUES (59,196); | ||
+ | INSERT INTO graph_template_input_defs VALUES (59,197); | ||
+ | INSERT INTO graph_template_input_defs VALUES (59,198); | ||
+ | INSERT INTO graph_template_input_defs VALUES (59,199); | ||
+ | INSERT INTO graph_template_input_defs VALUES (60,200); | ||
+ | INSERT INTO graph_template_input_defs VALUES (60,201); | ||
+ | INSERT INTO graph_template_input_defs VALUES (60,202); | ||
+ | INSERT INTO graph_template_input_defs VALUES (60,203); | ||
+ | INSERT INTO graph_template_input_defs VALUES (61,204); | ||
+ | INSERT INTO graph_template_input_defs VALUES (61,205); | ||
+ | INSERT INTO graph_template_input_defs VALUES (61,206); | ||
+ | INSERT INTO graph_template_input_defs VALUES (61,207); | ||
+ | INSERT INTO graph_template_input_defs VALUES (62,208); | ||
+ | INSERT INTO graph_template_input_defs VALUES (62,209); | ||
+ | INSERT INTO graph_template_input_defs VALUES (62,210); | ||
+ | INSERT INTO graph_template_input_defs VALUES (62,211); | ||
+ | INSERT INTO graph_template_input_defs VALUES (63,212); | ||
+ | INSERT INTO graph_template_input_defs VALUES (63,213); | ||
+ | INSERT INTO graph_template_input_defs VALUES (63,214); | ||
+ | INSERT INTO graph_template_input_defs VALUES (63,215); | ||
+ | INSERT INTO graph_template_input_defs VALUES (64,216); | ||
+ | INSERT INTO graph_template_input_defs VALUES (64,217); | ||
+ | INSERT INTO graph_template_input_defs VALUES (64,218); | ||
+ | INSERT INTO graph_template_input_defs VALUES (64,219); | ||
+ | INSERT INTO graph_template_input_defs VALUES (65,307); | ||
+ | INSERT INTO graph_template_input_defs VALUES (65,308); | ||
+ | INSERT INTO graph_template_input_defs VALUES (65,309); | ||
+ | INSERT INTO graph_template_input_defs VALUES (65,310); | ||
+ | INSERT INTO graph_template_input_defs VALUES (66,303); | ||
+ | INSERT INTO graph_template_input_defs VALUES (66,304); | ||
+ | INSERT INTO graph_template_input_defs VALUES (66,305); | ||
+ | INSERT INTO graph_template_input_defs VALUES (66,306); | ||
+ | INSERT INTO graph_template_input_defs VALUES (67,315); | ||
+ | INSERT INTO graph_template_input_defs VALUES (67,316); | ||
+ | INSERT INTO graph_template_input_defs VALUES (67,317); | ||
+ | INSERT INTO graph_template_input_defs VALUES (67,318); | ||
+ | INSERT INTO graph_template_input_defs VALUES (68,315); | ||
+ | INSERT INTO graph_template_input_defs VALUES (69,319); | ||
+ | INSERT INTO graph_template_input_defs VALUES (69,320); | ||
+ | INSERT INTO graph_template_input_defs VALUES (69,321); | ||
+ | INSERT INTO graph_template_input_defs VALUES (69,322); | ||
+ | INSERT INTO graph_template_input_defs VALUES (70,319); | ||
+ | INSERT INTO graph_template_input_defs VALUES (71,323); | ||
+ | INSERT INTO graph_template_input_defs VALUES (71,324); | ||
+ | INSERT INTO graph_template_input_defs VALUES (71,325); | ||
+ | INSERT INTO graph_template_input_defs VALUES (71,326); | ||
+ | INSERT INTO graph_template_input_defs VALUES (72,323); | ||
+ | INSERT INTO graph_template_input_defs VALUES (73,358); | ||
+ | INSERT INTO graph_template_input_defs VALUES (73,359); | ||
+ | INSERT INTO graph_template_input_defs VALUES (73,360); | ||
+ | INSERT INTO graph_template_input_defs VALUES (73,361); | ||
+ | INSERT INTO graph_template_input_defs VALUES (74,362); | ||
+ | INSERT INTO graph_template_input_defs VALUES (74,363); | ||
+ | INSERT INTO graph_template_input_defs VALUES (74,364); | ||
+ | INSERT INTO graph_template_input_defs VALUES (74,365); | ||
+ | INSERT INTO graph_template_input_defs VALUES (75,366); | ||
+ | INSERT INTO graph_template_input_defs VALUES (75,367); | ||
+ | INSERT INTO graph_template_input_defs VALUES (75,368); | ||
+ | INSERT INTO graph_template_input_defs VALUES (75,369); | ||
+ | INSERT INTO graph_template_input_defs VALUES (75,371); | ||
+ | INSERT INTO graph_template_input_defs VALUES (75,372); | ||
+ | INSERT INTO graph_template_input_defs VALUES (76,373); | ||
+ | INSERT INTO graph_template_input_defs VALUES (76,374); | ||
+ | INSERT INTO graph_template_input_defs VALUES (76,375); | ||
+ | INSERT INTO graph_template_input_defs VALUES (76,376); | ||
+ | INSERT INTO graph_template_input_defs VALUES (76,383); | ||
+ | INSERT INTO graph_template_input_defs VALUES (77,377); | ||
+ | INSERT INTO graph_template_input_defs VALUES (77,378); | ||
+ | INSERT INTO graph_template_input_defs VALUES (77,379); | ||
+ | INSERT INTO graph_template_input_defs VALUES (77,380); | ||
+ | INSERT INTO graph_template_input_defs VALUES (77,384); | ||
+ | INSERT INTO graph_template_input_defs VALUES (78,385); | ||
+ | INSERT INTO graph_template_input_defs VALUES (78,386); | ||
+ | INSERT INTO graph_template_input_defs VALUES (78,387); | ||
+ | INSERT INTO graph_template_input_defs VALUES (78,388); | ||
+ | INSERT INTO graph_template_input_defs VALUES (78,393); | ||
+ | INSERT INTO graph_template_input_defs VALUES (79,389); | ||
+ | INSERT INTO graph_template_input_defs VALUES (79,390); | ||
+ | INSERT INTO graph_template_input_defs VALUES (79,391); | ||
+ | INSERT INTO graph_template_input_defs VALUES (79,392); | ||
+ | INSERT INTO graph_template_input_defs VALUES (79,394); | ||
+ | INSERT INTO graph_template_input_defs VALUES (80,403); | ||
+ | INSERT INTO graph_template_input_defs VALUES (80,404); | ||
+ | INSERT INTO graph_template_input_defs VALUES (80,405); | ||
+ | INSERT INTO graph_template_input_defs VALUES (80,406); | ||
+ | INSERT INTO graph_template_input_defs VALUES (81,407); | ||
+ | INSERT INTO graph_template_input_defs VALUES (81,408); | ||
+ | INSERT INTO graph_template_input_defs VALUES (81,409); | ||
+ | INSERT INTO graph_template_input_defs VALUES (81,410); | ||
+ | INSERT INTO graph_template_input_defs VALUES (82,407); | ||
+ | INSERT INTO graph_template_input_defs VALUES (83,407); | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_templates` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_templates ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash char(32) NOT NULL default '', | ||
+ | name char(255) NOT NULL default '', | ||
+ | PRIMARY KEY (id), | ||
+ | KEY name (name) | ||
+ | ) ENGINE=MyISAM COMMENT=' | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_templates` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_templates VALUES (34,' | ||
+ | INSERT INTO graph_templates VALUES (2,' | ||
+ | INSERT INTO graph_templates VALUES (3,' | ||
+ | INSERT INTO graph_templates VALUES (4,' | ||
+ | INSERT INTO graph_templates VALUES (5,' | ||
+ | INSERT INTO graph_templates VALUES (6,' | ||
+ | INSERT INTO graph_templates VALUES (7,' | ||
+ | INSERT INTO graph_templates VALUES (8,' | ||
+ | INSERT INTO graph_templates VALUES (9,' | ||
+ | INSERT INTO graph_templates VALUES (10,' | ||
+ | INSERT INTO graph_templates VALUES (11,' | ||
+ | INSERT INTO graph_templates VALUES (12,' | ||
+ | INSERT INTO graph_templates VALUES (13,' | ||
+ | INSERT INTO graph_templates VALUES (14,' | ||
+ | INSERT INTO graph_templates VALUES (15,' | ||
+ | INSERT INTO graph_templates VALUES (16,' | ||
+ | INSERT INTO graph_templates VALUES (17,' | ||
+ | INSERT INTO graph_templates VALUES (18,' | ||
+ | INSERT INTO graph_templates VALUES (19,' | ||
+ | INSERT INTO graph_templates VALUES (20,' | ||
+ | INSERT INTO graph_templates VALUES (21,' | ||
+ | INSERT INTO graph_templates VALUES (22,' | ||
+ | INSERT INTO graph_templates VALUES (23,' | ||
+ | INSERT INTO graph_templates VALUES (24,' | ||
+ | INSERT INTO graph_templates VALUES (25,' | ||
+ | INSERT INTO graph_templates VALUES (26,' | ||
+ | INSERT INTO graph_templates VALUES (27,' | ||
+ | INSERT INTO graph_templates VALUES (28,' | ||
+ | INSERT INTO graph_templates VALUES (29,' | ||
+ | INSERT INTO graph_templates VALUES (30,' | ||
+ | INSERT INTO graph_templates VALUES (31,' | ||
+ | INSERT INTO graph_templates VALUES (32,' | ||
+ | INSERT INTO graph_templates VALUES (33,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_templates_gprint` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_templates_gprint ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | name varchar(100) NOT NULL default '', | ||
+ | gprint_text varchar(255) default NULL, | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_templates_gprint` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_templates_gprint VALUES (2,' | ||
+ | INSERT INTO graph_templates_gprint VALUES (3,' | ||
+ | INSERT INTO graph_templates_gprint VALUES (4,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_templates_graph` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_templates_graph ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | local_graph_template_graph_id mediumint(8) unsigned NOT NULL default ' | ||
+ | local_graph_id mediumint(8) unsigned NOT NULL default ' | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | t_image_format_id char(2) default ' | ||
+ | image_format_id tinyint(1) NOT NULL default ' | ||
+ | t_title char(2) default ' | ||
+ | title varchar(255) NOT NULL default '', | ||
+ | title_cache varchar(255) NOT NULL default '', | ||
+ | t_height char(2) default ' | ||
+ | height mediumint(8) NOT NULL default ' | ||
+ | t_width char(2) default ' | ||
+ | width mediumint(8) NOT NULL default ' | ||
+ | t_upper_limit char(2) default ' | ||
+ | upper_limit varchar(20) NOT NULL default ' | ||
+ | t_lower_limit char(2) default ' | ||
+ | lower_limit varchar(20) NOT NULL default ' | ||
+ | t_vertical_label char(2) default ' | ||
+ | vertical_label varchar(200) default NULL, | ||
+ | t_slope_mode char(2) default ' | ||
+ | slope_mode char(2) default ' | ||
+ | t_auto_scale char(2) default ' | ||
+ | auto_scale char(2) default NULL, | ||
+ | t_auto_scale_opts char(2) default ' | ||
+ | auto_scale_opts tinyint(1) NOT NULL default ' | ||
+ | t_auto_scale_log char(2) default ' | ||
+ | auto_scale_log char(2) default NULL, | ||
+ | t_scale_log_units char(2) default ' | ||
+ | scale_log_units char(2) default NULL, | ||
+ | t_auto_scale_rigid char(2) default ' | ||
+ | auto_scale_rigid char(2) default NULL, | ||
+ | t_auto_padding char(2) default ' | ||
+ | auto_padding char(2) default NULL, | ||
+ | t_base_value char(2) default ' | ||
+ | base_value mediumint(8) NOT NULL default ' | ||
+ | t_grouping char(2) default ' | ||
+ | grouping char(2) NOT NULL default '', | ||
+ | t_export char(2) default ' | ||
+ | export char(2) default NULL, | ||
+ | t_unit_value char(2) default ' | ||
+ | unit_value varchar(20) default NULL, | ||
+ | t_unit_exponent_value char(2) default ' | ||
+ | unit_exponent_value varchar(5) NOT NULL default '', | ||
+ | PRIMARY KEY (id), | ||
+ | KEY local_graph_id (local_graph_id), | ||
+ | KEY graph_template_id (graph_template_id), | ||
+ | KEY title_cache (title_cache) | ||
+ | ) ENGINE=MyISAM COMMENT=' | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_templates_graph` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_templates_graph VALUES (2, | ||
+ | INSERT INTO graph_templates_graph VALUES (3, | ||
+ | INSERT INTO graph_templates_graph VALUES (4, | ||
+ | INSERT INTO graph_templates_graph VALUES (5, | ||
+ | INSERT INTO graph_templates_graph VALUES (6, | ||
+ | INSERT INTO graph_templates_graph VALUES (7, | ||
+ | INSERT INTO graph_templates_graph VALUES (8, | ||
+ | INSERT INTO graph_templates_graph VALUES (9, | ||
+ | INSERT INTO graph_templates_graph VALUES (10, | ||
+ | INSERT INTO graph_templates_graph VALUES (11, | ||
+ | INSERT INTO graph_templates_graph VALUES (12, | ||
+ | INSERT INTO graph_templates_graph VALUES (13, | ||
+ | INSERT INTO graph_templates_graph VALUES (14, | ||
+ | INSERT INTO graph_templates_graph VALUES (15, | ||
+ | INSERT INTO graph_templates_graph VALUES (16, | ||
+ | INSERT INTO graph_templates_graph VALUES (17, | ||
+ | INSERT INTO graph_templates_graph VALUES (18, | ||
+ | INSERT INTO graph_templates_graph VALUES (19, | ||
+ | INSERT INTO graph_templates_graph VALUES (20, | ||
+ | INSERT INTO graph_templates_graph VALUES (21, | ||
+ | INSERT INTO graph_templates_graph VALUES (22, | ||
+ | INSERT INTO graph_templates_graph VALUES (23, | ||
+ | INSERT INTO graph_templates_graph VALUES (24, | ||
+ | INSERT INTO graph_templates_graph VALUES (25, | ||
+ | INSERT INTO graph_templates_graph VALUES (34, | ||
+ | INSERT INTO graph_templates_graph VALUES (35, | ||
+ | INSERT INTO graph_templates_graph VALUES (36, | ||
+ | INSERT INTO graph_templates_graph VALUES (37, | ||
+ | INSERT INTO graph_templates_graph VALUES (38, | ||
+ | INSERT INTO graph_templates_graph VALUES (39, | ||
+ | INSERT INTO graph_templates_graph VALUES (40, | ||
+ | INSERT INTO graph_templates_graph VALUES (41, | ||
+ | INSERT INTO graph_templates_graph VALUES (42, | ||
+ | INSERT INTO graph_templates_graph VALUES (43, | ||
+ | INSERT INTO graph_templates_graph VALUES (44, | ||
+ | INSERT INTO graph_templates_graph VALUES (45, | ||
+ | INSERT INTO graph_templates_graph VALUES (47, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_templates_item` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_templates_item ( | ||
+ | id int(12) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | local_graph_template_item_id int(12) unsigned NOT NULL default ' | ||
+ | local_graph_id mediumint(8) unsigned NOT NULL default ' | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | task_item_id mediumint(8) unsigned NOT NULL default ' | ||
+ | color_id mediumint(8) unsigned NOT NULL default ' | ||
+ | alpha char(2) default ' | ||
+ | graph_type_id tinyint(3) NOT NULL default ' | ||
+ | cdef_id mediumint(8) unsigned NOT NULL default ' | ||
+ | consolidation_function_id tinyint(2) NOT NULL default ' | ||
+ | text_format varchar(255) default NULL, | ||
+ | value varchar(255) default NULL, | ||
+ | hard_return char(2) default NULL, | ||
+ | gprint_id mediumint(8) unsigned NOT NULL default ' | ||
+ | sequence mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (id), | ||
+ | KEY graph_template_id (graph_template_id), | ||
+ | KEY local_graph_id (local_graph_id), | ||
+ | KEY task_item_id (task_item_id) | ||
+ | ) ENGINE=MyISAM COMMENT=' | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_templates_item` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_templates_item VALUES (9,' | ||
+ | INSERT INTO graph_templates_item VALUES (10,' | ||
+ | INSERT INTO graph_templates_item VALUES (11,' | ||
+ | INSERT INTO graph_templates_item VALUES (12,' | ||
+ | INSERT INTO graph_templates_item VALUES (13,' | ||
+ | INSERT INTO graph_templates_item VALUES (14,' | ||
+ | INSERT INTO graph_templates_item VALUES (15,' | ||
+ | INSERT INTO graph_templates_item VALUES (16,' | ||
+ | INSERT INTO graph_templates_item VALUES (17,' | ||
+ | INSERT INTO graph_templates_item VALUES (18,' | ||
+ | INSERT INTO graph_templates_item VALUES (19,' | ||
+ | INSERT INTO graph_templates_item VALUES (20,' | ||
+ | INSERT INTO graph_templates_item VALUES (21,' | ||
+ | INSERT INTO graph_templates_item VALUES (22,' | ||
+ | INSERT INTO graph_templates_item VALUES (23,' | ||
+ | INSERT INTO graph_templates_item VALUES (24,' | ||
+ | INSERT INTO graph_templates_item VALUES (25,' | ||
+ | INSERT INTO graph_templates_item VALUES (26,' | ||
+ | INSERT INTO graph_templates_item VALUES (27,' | ||
+ | INSERT INTO graph_templates_item VALUES (28,' | ||
+ | INSERT INTO graph_templates_item VALUES (29,' | ||
+ | INSERT INTO graph_templates_item VALUES (30,' | ||
+ | INSERT INTO graph_templates_item VALUES (31,' | ||
+ | INSERT INTO graph_templates_item VALUES (32,' | ||
+ | INSERT INTO graph_templates_item VALUES (33,' | ||
+ | INSERT INTO graph_templates_item VALUES (34,' | ||
+ | INSERT INTO graph_templates_item VALUES (35,' | ||
+ | INSERT INTO graph_templates_item VALUES (36,' | ||
+ | INSERT INTO graph_templates_item VALUES (37,' | ||
+ | INSERT INTO graph_templates_item VALUES (38,' | ||
+ | INSERT INTO graph_templates_item VALUES (39,' | ||
+ | INSERT INTO graph_templates_item VALUES (40,' | ||
+ | INSERT INTO graph_templates_item VALUES (41,' | ||
+ | INSERT INTO graph_templates_item VALUES (42,' | ||
+ | INSERT INTO graph_templates_item VALUES (43,' | ||
+ | INSERT INTO graph_templates_item VALUES (44,' | ||
+ | INSERT INTO graph_templates_item VALUES (45,' | ||
+ | INSERT INTO graph_templates_item VALUES (46,' | ||
+ | INSERT INTO graph_templates_item VALUES (47,' | ||
+ | INSERT INTO graph_templates_item VALUES (48,' | ||
+ | INSERT INTO graph_templates_item VALUES (49,' | ||
+ | INSERT INTO graph_templates_item VALUES (50,' | ||
+ | INSERT INTO graph_templates_item VALUES (51,' | ||
+ | INSERT INTO graph_templates_item VALUES (52,' | ||
+ | INSERT INTO graph_templates_item VALUES (53,' | ||
+ | INSERT INTO graph_templates_item VALUES (54,' | ||
+ | INSERT INTO graph_templates_item VALUES (55,' | ||
+ | INSERT INTO graph_templates_item VALUES (56,' | ||
+ | INSERT INTO graph_templates_item VALUES (57,' | ||
+ | INSERT INTO graph_templates_item VALUES (58,' | ||
+ | INSERT INTO graph_templates_item VALUES (59,' | ||
+ | INSERT INTO graph_templates_item VALUES (60,' | ||
+ | INSERT INTO graph_templates_item VALUES (61,' | ||
+ | INSERT INTO graph_templates_item VALUES (62,' | ||
+ | INSERT INTO graph_templates_item VALUES (63,' | ||
+ | INSERT INTO graph_templates_item VALUES (64,' | ||
+ | INSERT INTO graph_templates_item VALUES (65,' | ||
+ | INSERT INTO graph_templates_item VALUES (66,' | ||
+ | INSERT INTO graph_templates_item VALUES (67,' | ||
+ | INSERT INTO graph_templates_item VALUES (68,' | ||
+ | INSERT INTO graph_templates_item VALUES (69,' | ||
+ | INSERT INTO graph_templates_item VALUES (70,' | ||
+ | INSERT INTO graph_templates_item VALUES (71,' | ||
+ | INSERT INTO graph_templates_item VALUES (72,' | ||
+ | INSERT INTO graph_templates_item VALUES (73,' | ||
+ | INSERT INTO graph_templates_item VALUES (74,' | ||
+ | INSERT INTO graph_templates_item VALUES (75,' | ||
+ | INSERT INTO graph_templates_item VALUES (76,' | ||
+ | INSERT INTO graph_templates_item VALUES (77,' | ||
+ | INSERT INTO graph_templates_item VALUES (78,' | ||
+ | INSERT INTO graph_templates_item VALUES (79,' | ||
+ | INSERT INTO graph_templates_item VALUES (80,' | ||
+ | INSERT INTO graph_templates_item VALUES (81,' | ||
+ | INSERT INTO graph_templates_item VALUES (82,' | ||
+ | INSERT INTO graph_templates_item VALUES (83,' | ||
+ | INSERT INTO graph_templates_item VALUES (84,' | ||
+ | INSERT INTO graph_templates_item VALUES (85,' | ||
+ | INSERT INTO graph_templates_item VALUES (86,' | ||
+ | INSERT INTO graph_templates_item VALUES (95,' | ||
+ | INSERT INTO graph_templates_item VALUES (96,' | ||
+ | INSERT INTO graph_templates_item VALUES (97,' | ||
+ | INSERT INTO graph_templates_item VALUES (98,' | ||
+ | INSERT INTO graph_templates_item VALUES (99,' | ||
+ | INSERT INTO graph_templates_item VALUES (100,' | ||
+ | INSERT INTO graph_templates_item VALUES (101,' | ||
+ | INSERT INTO graph_templates_item VALUES (102,' | ||
+ | INSERT INTO graph_templates_item VALUES (103,' | ||
+ | INSERT INTO graph_templates_item VALUES (104,' | ||
+ | INSERT INTO graph_templates_item VALUES (105,' | ||
+ | INSERT INTO graph_templates_item VALUES (106,' | ||
+ | INSERT INTO graph_templates_item VALUES (107,' | ||
+ | INSERT INTO graph_templates_item VALUES (108,' | ||
+ | INSERT INTO graph_templates_item VALUES (109,' | ||
+ | INSERT INTO graph_templates_item VALUES (110,' | ||
+ | INSERT INTO graph_templates_item VALUES (111,' | ||
+ | INSERT INTO graph_templates_item VALUES (112,' | ||
+ | INSERT INTO graph_templates_item VALUES (113,' | ||
+ | INSERT INTO graph_templates_item VALUES (114,' | ||
+ | INSERT INTO graph_templates_item VALUES (115,' | ||
+ | INSERT INTO graph_templates_item VALUES (116,' | ||
+ | INSERT INTO graph_templates_item VALUES (117,' | ||
+ | INSERT INTO graph_templates_item VALUES (118,' | ||
+ | INSERT INTO graph_templates_item VALUES (119,' | ||
+ | INSERT INTO graph_templates_item VALUES (120,' | ||
+ | INSERT INTO graph_templates_item VALUES (121,' | ||
+ | INSERT INTO graph_templates_item VALUES (122,' | ||
+ | INSERT INTO graph_templates_item VALUES (123,' | ||
+ | INSERT INTO graph_templates_item VALUES (124,' | ||
+ | INSERT INTO graph_templates_item VALUES (125,' | ||
+ | INSERT INTO graph_templates_item VALUES (126,' | ||
+ | INSERT INTO graph_templates_item VALUES (127,' | ||
+ | INSERT INTO graph_templates_item VALUES (128,' | ||
+ | INSERT INTO graph_templates_item VALUES (129,' | ||
+ | INSERT INTO graph_templates_item VALUES (130,' | ||
+ | INSERT INTO graph_templates_item VALUES (131,' | ||
+ | INSERT INTO graph_templates_item VALUES (132,' | ||
+ | INSERT INTO graph_templates_item VALUES (133,' | ||
+ | INSERT INTO graph_templates_item VALUES (134,' | ||
+ | INSERT INTO graph_templates_item VALUES (139,' | ||
+ | INSERT INTO graph_templates_item VALUES (140,' | ||
+ | INSERT INTO graph_templates_item VALUES (141,' | ||
+ | INSERT INTO graph_templates_item VALUES (142,' | ||
+ | INSERT INTO graph_templates_item VALUES (143,' | ||
+ | INSERT INTO graph_templates_item VALUES (144,' | ||
+ | INSERT INTO graph_templates_item VALUES (145,' | ||
+ | INSERT INTO graph_templates_item VALUES (146,' | ||
+ | INSERT INTO graph_templates_item VALUES (147,' | ||
+ | INSERT INTO graph_templates_item VALUES (148,' | ||
+ | INSERT INTO graph_templates_item VALUES (149,' | ||
+ | INSERT INTO graph_templates_item VALUES (150,' | ||
+ | INSERT INTO graph_templates_item VALUES (151,' | ||
+ | INSERT INTO graph_templates_item VALUES (152,' | ||
+ | INSERT INTO graph_templates_item VALUES (153,' | ||
+ | INSERT INTO graph_templates_item VALUES (154,' | ||
+ | INSERT INTO graph_templates_item VALUES (171,' | ||
+ | INSERT INTO graph_templates_item VALUES (170,' | ||
+ | INSERT INTO graph_templates_item VALUES (169,' | ||
+ | INSERT INTO graph_templates_item VALUES (167,' | ||
+ | INSERT INTO graph_templates_item VALUES (159,' | ||
+ | INSERT INTO graph_templates_item VALUES (160,' | ||
+ | INSERT INTO graph_templates_item VALUES (161,' | ||
+ | INSERT INTO graph_templates_item VALUES (162,' | ||
+ | INSERT INTO graph_templates_item VALUES (163,' | ||
+ | INSERT INTO graph_templates_item VALUES (164,' | ||
+ | INSERT INTO graph_templates_item VALUES (165,' | ||
+ | INSERT INTO graph_templates_item VALUES (166,' | ||
+ | INSERT INTO graph_templates_item VALUES (172,' | ||
+ | INSERT INTO graph_templates_item VALUES (173,' | ||
+ | INSERT INTO graph_templates_item VALUES (174,' | ||
+ | INSERT INTO graph_templates_item VALUES (175,' | ||
+ | INSERT INTO graph_templates_item VALUES (176,' | ||
+ | INSERT INTO graph_templates_item VALUES (177,' | ||
+ | INSERT INTO graph_templates_item VALUES (178,' | ||
+ | INSERT INTO graph_templates_item VALUES (179,' | ||
+ | INSERT INTO graph_templates_item VALUES (180,' | ||
+ | INSERT INTO graph_templates_item VALUES (181,' | ||
+ | INSERT INTO graph_templates_item VALUES (182,' | ||
+ | INSERT INTO graph_templates_item VALUES (183,' | ||
+ | INSERT INTO graph_templates_item VALUES (184,' | ||
+ | INSERT INTO graph_templates_item VALUES (185,' | ||
+ | INSERT INTO graph_templates_item VALUES (186,' | ||
+ | INSERT INTO graph_templates_item VALUES (187,' | ||
+ | INSERT INTO graph_templates_item VALUES (188,' | ||
+ | INSERT INTO graph_templates_item VALUES (189,' | ||
+ | INSERT INTO graph_templates_item VALUES (190,' | ||
+ | INSERT INTO graph_templates_item VALUES (191,' | ||
+ | INSERT INTO graph_templates_item VALUES (192,' | ||
+ | INSERT INTO graph_templates_item VALUES (193,' | ||
+ | INSERT INTO graph_templates_item VALUES (194,' | ||
+ | INSERT INTO graph_templates_item VALUES (195,' | ||
+ | INSERT INTO graph_templates_item VALUES (196,' | ||
+ | INSERT INTO graph_templates_item VALUES (197,' | ||
+ | INSERT INTO graph_templates_item VALUES (198,' | ||
+ | INSERT INTO graph_templates_item VALUES (199,' | ||
+ | INSERT INTO graph_templates_item VALUES (200,' | ||
+ | INSERT INTO graph_templates_item VALUES (201,' | ||
+ | INSERT INTO graph_templates_item VALUES (202,' | ||
+ | INSERT INTO graph_templates_item VALUES (203,' | ||
+ | INSERT INTO graph_templates_item VALUES (204,' | ||
+ | INSERT INTO graph_templates_item VALUES (205,' | ||
+ | INSERT INTO graph_templates_item VALUES (206,' | ||
+ | INSERT INTO graph_templates_item VALUES (207,' | ||
+ | INSERT INTO graph_templates_item VALUES (208,' | ||
+ | INSERT INTO graph_templates_item VALUES (209,' | ||
+ | INSERT INTO graph_templates_item VALUES (210,' | ||
+ | INSERT INTO graph_templates_item VALUES (211,' | ||
+ | INSERT INTO graph_templates_item VALUES (212,' | ||
+ | INSERT INTO graph_templates_item VALUES (213,' | ||
+ | INSERT INTO graph_templates_item VALUES (214,' | ||
+ | INSERT INTO graph_templates_item VALUES (215,' | ||
+ | INSERT INTO graph_templates_item VALUES (216,' | ||
+ | INSERT INTO graph_templates_item VALUES (217,' | ||
+ | INSERT INTO graph_templates_item VALUES (218,' | ||
+ | INSERT INTO graph_templates_item VALUES (219,' | ||
+ | INSERT INTO graph_templates_item VALUES (303,' | ||
+ | INSERT INTO graph_templates_item VALUES (304,' | ||
+ | INSERT INTO graph_templates_item VALUES (305,' | ||
+ | INSERT INTO graph_templates_item VALUES (306,' | ||
+ | INSERT INTO graph_templates_item VALUES (307,' | ||
+ | INSERT INTO graph_templates_item VALUES (308,' | ||
+ | INSERT INTO graph_templates_item VALUES (309,' | ||
+ | INSERT INTO graph_templates_item VALUES (310,' | ||
+ | INSERT INTO graph_templates_item VALUES (317,' | ||
+ | INSERT INTO graph_templates_item VALUES (316,' | ||
+ | INSERT INTO graph_templates_item VALUES (315,' | ||
+ | INSERT INTO graph_templates_item VALUES (318,' | ||
+ | INSERT INTO graph_templates_item VALUES (319,' | ||
+ | INSERT INTO graph_templates_item VALUES (320,' | ||
+ | INSERT INTO graph_templates_item VALUES (321,' | ||
+ | INSERT INTO graph_templates_item VALUES (322,' | ||
+ | INSERT INTO graph_templates_item VALUES (323,' | ||
+ | INSERT INTO graph_templates_item VALUES (324,' | ||
+ | INSERT INTO graph_templates_item VALUES (325,' | ||
+ | INSERT INTO graph_templates_item VALUES (326,' | ||
+ | INSERT INTO graph_templates_item VALUES (373,' | ||
+ | INSERT INTO graph_templates_item VALUES (335,'', | ||
+ | INSERT INTO graph_templates_item VALUES (336,'', | ||
+ | INSERT INTO graph_templates_item VALUES (337,'', | ||
+ | INSERT INTO graph_templates_item VALUES (338,'', | ||
+ | INSERT INTO graph_templates_item VALUES (339,'', | ||
+ | INSERT INTO graph_templates_item VALUES (340,'', | ||
+ | INSERT INTO graph_templates_item VALUES (341,'', | ||
+ | INSERT INTO graph_templates_item VALUES (342,'', | ||
+ | INSERT INTO graph_templates_item VALUES (343,'', | ||
+ | INSERT INTO graph_templates_item VALUES (344,'', | ||
+ | INSERT INTO graph_templates_item VALUES (345,'', | ||
+ | INSERT INTO graph_templates_item VALUES (346,'', | ||
+ | INSERT INTO graph_templates_item VALUES (347,'', | ||
+ | INSERT INTO graph_templates_item VALUES (348,'', | ||
+ | INSERT INTO graph_templates_item VALUES (349,'', | ||
+ | INSERT INTO graph_templates_item VALUES (350,'', | ||
+ | INSERT INTO graph_templates_item VALUES (351,'', | ||
+ | INSERT INTO graph_templates_item VALUES (352,'', | ||
+ | INSERT INTO graph_templates_item VALUES (353,'', | ||
+ | INSERT INTO graph_templates_item VALUES (354,'', | ||
+ | INSERT INTO graph_templates_item VALUES (355,'', | ||
+ | INSERT INTO graph_templates_item VALUES (356,'', | ||
+ | INSERT INTO graph_templates_item VALUES (357,'', | ||
+ | INSERT INTO graph_templates_item VALUES (358,' | ||
+ | INSERT INTO graph_templates_item VALUES (359,' | ||
+ | INSERT INTO graph_templates_item VALUES (360,' | ||
+ | INSERT INTO graph_templates_item VALUES (361,' | ||
+ | INSERT INTO graph_templates_item VALUES (362,' | ||
+ | INSERT INTO graph_templates_item VALUES (363,' | ||
+ | INSERT INTO graph_templates_item VALUES (364,' | ||
+ | INSERT INTO graph_templates_item VALUES (365,' | ||
+ | INSERT INTO graph_templates_item VALUES (366,' | ||
+ | INSERT INTO graph_templates_item VALUES (367,' | ||
+ | INSERT INTO graph_templates_item VALUES (368,' | ||
+ | INSERT INTO graph_templates_item VALUES (369,' | ||
+ | INSERT INTO graph_templates_item VALUES (370,' | ||
+ | INSERT INTO graph_templates_item VALUES (371,' | ||
+ | INSERT INTO graph_templates_item VALUES (372,' | ||
+ | INSERT INTO graph_templates_item VALUES (374,' | ||
+ | INSERT INTO graph_templates_item VALUES (375,' | ||
+ | INSERT INTO graph_templates_item VALUES (376,' | ||
+ | INSERT INTO graph_templates_item VALUES (377,' | ||
+ | INSERT INTO graph_templates_item VALUES (378,' | ||
+ | INSERT INTO graph_templates_item VALUES (379,' | ||
+ | INSERT INTO graph_templates_item VALUES (380,' | ||
+ | INSERT INTO graph_templates_item VALUES (383,' | ||
+ | INSERT INTO graph_templates_item VALUES (384,' | ||
+ | INSERT INTO graph_templates_item VALUES (385,' | ||
+ | INSERT INTO graph_templates_item VALUES (386,' | ||
+ | INSERT INTO graph_templates_item VALUES (387,' | ||
+ | INSERT INTO graph_templates_item VALUES (388,' | ||
+ | INSERT INTO graph_templates_item VALUES (389,' | ||
+ | INSERT INTO graph_templates_item VALUES (390,' | ||
+ | INSERT INTO graph_templates_item VALUES (391,' | ||
+ | INSERT INTO graph_templates_item VALUES (392,' | ||
+ | INSERT INTO graph_templates_item VALUES (393,' | ||
+ | INSERT INTO graph_templates_item VALUES (394,' | ||
+ | INSERT INTO graph_templates_item VALUES (403,' | ||
+ | INSERT INTO graph_templates_item VALUES (404,' | ||
+ | INSERT INTO graph_templates_item VALUES (405,' | ||
+ | INSERT INTO graph_templates_item VALUES (406,' | ||
+ | INSERT INTO graph_templates_item VALUES (407,' | ||
+ | INSERT INTO graph_templates_item VALUES (408,' | ||
+ | INSERT INTO graph_templates_item VALUES (409,' | ||
+ | INSERT INTO graph_templates_item VALUES (410,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_tree` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_tree ( | ||
+ | id smallint(5) unsigned NOT NULL auto_increment, | ||
+ | sort_type tinyint(3) unsigned NOT NULL default ' | ||
+ | name varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_tree` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_tree VALUES (1, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `graph_tree_items` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE graph_tree_items ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | graph_tree_id smallint(5) unsigned NOT NULL default ' | ||
+ | local_graph_id mediumint(8) unsigned NOT NULL default ' | ||
+ | rra_id smallint(8) unsigned NOT NULL default ' | ||
+ | title varchar(255) default NULL, | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | order_key varchar(100) NOT NULL default ' | ||
+ | host_grouping_type tinyint(3) unsigned NOT NULL default ' | ||
+ | sort_children_type tinyint(3) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (id), | ||
+ | KEY graph_tree_id (graph_tree_id), | ||
+ | KEY host_id (host_id), | ||
+ | KEY local_graph_id (local_graph_id), | ||
+ | KEY order_key (order_key) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `graph_tree_items` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO graph_tree_items VALUES (7, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `host` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE host ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | host_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | description varchar(150) NOT NULL default '', | ||
+ | hostname varchar(250) default NULL, | ||
+ | notes text, | ||
+ | snmp_community varchar(100) default NULL, | ||
+ | snmp_version tinyint(1) unsigned NOT NULL default ' | ||
+ | snmp_username varchar(50) default NULL, | ||
+ | snmp_password varchar(50) default NULL, | ||
+ | snmp_auth_protocol char(5) default '', | ||
+ | snmp_priv_passphrase varchar(200) default '', | ||
+ | snmp_priv_protocol char(6) default '', | ||
+ | snmp_context varchar(64) default '', | ||
+ | snmp_port mediumint(5) unsigned NOT NULL default ' | ||
+ | snmp_timeout mediumint(8) unsigned NOT NULL default ' | ||
+ | availability_method smallint(5) unsigned NOT NULL default ' | ||
+ | ping_method smallint(5) unsigned default ' | ||
+ | ping_port int(12) unsigned default ' | ||
+ | ping_timeout int(12) unsigned default ' | ||
+ | ping_retries int(12) unsigned default ' | ||
+ | max_oids int(12) unsigned default ' | ||
+ | device_threads tinyint(2) unsigned NOT NULL DEFAULT ' | ||
+ | disabled char(2) default NULL, | ||
+ | status tinyint(2) NOT NULL default ' | ||
+ | status_event_count mediumint(8) unsigned NOT NULL default ' | ||
+ | status_fail_date datetime NOT NULL default ' | ||
+ | status_rec_date datetime NOT NULL default ' | ||
+ | status_last_error varchar(255) default '', | ||
+ | min_time decimal(10, | ||
+ | max_time decimal(10, | ||
+ | cur_time decimal(10, | ||
+ | avg_time decimal(10, | ||
+ | total_polls int(12) unsigned default ' | ||
+ | failed_polls int(12) unsigned default ' | ||
+ | availability decimal(8, | ||
+ | PRIMARY KEY (id), | ||
+ | KEY disabled (disabled) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `host` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO `host` VALUES (1, 8, ' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `host_graph` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE host_graph ( | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (host_id, | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `host_graph` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO host_graph VALUES (1,8); | ||
+ | INSERT INTO host_graph VALUES (1,9); | ||
+ | INSERT INTO host_graph VALUES (1,10); | ||
+ | INSERT INTO host_graph VALUES (1,12); | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `host_snmp_cache` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE host_snmp_cache ( | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | snmp_query_id mediumint(8) unsigned NOT NULL default ' | ||
+ | field_name varchar(50) NOT NULL default '', | ||
+ | field_value varchar(255) default NULL, | ||
+ | snmp_index varchar(255) NOT NULL default '', | ||
+ | oid TEXT NOT NULL, | ||
+ | present tinyint NOT NULL DEFAULT ' | ||
+ | PRIMARY KEY (host_id, | ||
+ | KEY host_id (host_id, | ||
+ | KEY snmp_index (snmp_index), | ||
+ | KEY field_name (field_name), | ||
+ | KEY field_value (field_value), | ||
+ | KEY snmp_query_id (snmp_query_id), | ||
+ | KEY present (present) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `host_snmp_cache` | ||
+ | -- | ||
+ | |||
+ | |||
+ | -- | ||
+ | -- Table structure for table `host_snmp_query` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE host_snmp_query ( | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | snmp_query_id mediumint(8) unsigned NOT NULL default ' | ||
+ | sort_field varchar(50) NOT NULL default '', | ||
+ | title_format varchar(50) NOT NULL default '', | ||
+ | reindex_method tinyint(3) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (host_id, | ||
+ | KEY host_id (host_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `host_snmp_query` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO host_snmp_query VALUES (1, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `host_template` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE host_template ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | name varchar(100) NOT NULL default '', | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `host_template` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO host_template VALUES (1,' | ||
+ | INSERT INTO host_template VALUES (3,' | ||
+ | INSERT INTO host_template VALUES (4,' | ||
+ | INSERT INTO host_template VALUES (5,' | ||
+ | INSERT INTO host_template VALUES (6,' | ||
+ | INSERT INTO host_template VALUES (7,' | ||
+ | INSERT INTO host_template VALUES (8,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `host_template_graph` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE host_template_graph ( | ||
+ | host_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (host_template_id, | ||
+ | KEY host_template_id (host_template_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `host_template_graph` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO host_template_graph VALUES (3,4); | ||
+ | INSERT INTO host_template_graph VALUES (3,11); | ||
+ | INSERT INTO host_template_graph VALUES (3,13); | ||
+ | INSERT INTO host_template_graph VALUES (5,18); | ||
+ | INSERT INTO host_template_graph VALUES (6,14); | ||
+ | INSERT INTO host_template_graph VALUES (6,16); | ||
+ | INSERT INTO host_template_graph VALUES (6,17); | ||
+ | INSERT INTO host_template_graph VALUES (6,30); | ||
+ | INSERT INTO host_template_graph VALUES (7,28); | ||
+ | INSERT INTO host_template_graph VALUES (7,29); | ||
+ | INSERT INTO host_template_graph VALUES (8,8); | ||
+ | INSERT INTO host_template_graph VALUES (8,9); | ||
+ | INSERT INTO host_template_graph VALUES (8,10); | ||
+ | INSERT INTO host_template_graph VALUES (8,12); | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `host_template_snmp_query` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE host_template_snmp_query ( | ||
+ | host_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | snmp_query_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (host_template_id, | ||
+ | KEY host_template_id (host_template_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `host_template_snmp_query` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO host_template_snmp_query VALUES (1,1); | ||
+ | INSERT INTO host_template_snmp_query VALUES (3,1); | ||
+ | INSERT INTO host_template_snmp_query VALUES (3,2); | ||
+ | INSERT INTO host_template_snmp_query VALUES (4,1); | ||
+ | INSERT INTO host_template_snmp_query VALUES (4,3); | ||
+ | INSERT INTO host_template_snmp_query VALUES (5,1); | ||
+ | INSERT INTO host_template_snmp_query VALUES (6,1); | ||
+ | INSERT INTO host_template_snmp_query VALUES (6,4); | ||
+ | INSERT INTO host_template_snmp_query VALUES (6,7); | ||
+ | INSERT INTO host_template_snmp_query VALUES (7,1); | ||
+ | INSERT INTO host_template_snmp_query VALUES (7,8); | ||
+ | INSERT INTO host_template_snmp_query VALUES (7,9); | ||
+ | INSERT INTO host_template_snmp_query VALUES (8,6); | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `plugin_config` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `plugin_config` ( | ||
+ | `id` int(8) NOT NULL auto_increment, | ||
+ | `directory` varchar(32) NOT NULL default '', | ||
+ | `name` varchar(64) NOT NULL default '', | ||
+ | `status` tinyint(2) NOT NULL default ' | ||
+ | `author` varchar(64) NOT NULL default '', | ||
+ | `webpage` varchar(255) NOT NULL default '', | ||
+ | `version` varchar(8) NOT NULL default '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `status` (`status`), | ||
+ | KEY `directory` (`directory`) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `plugin_hooks` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `plugin_hooks` ( | ||
+ | `id` int(8) NOT NULL auto_increment, | ||
+ | `name` varchar(32) NOT NULL default '', | ||
+ | `hook` varchar(64) NOT NULL default '', | ||
+ | `file` varchar(255) NOT NULL default '', | ||
+ | `function` varchar(128) NOT NULL default '', | ||
+ | `status` int(8) NOT NULL default ' | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `hook` (`hook`), | ||
+ | KEY `status` (`status`) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `plugin_realms` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `plugin_realms` ( | ||
+ | `id` int(8) NOT NULL auto_increment, | ||
+ | `plugin` varchar(32) NOT NULL default '', | ||
+ | `file` text NOT NULL, | ||
+ | `display` varchar(64) NOT NULL default '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `plugin` (`plugin`) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `plugin_db_changes` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `plugin_db_changes` ( | ||
+ | `id` int(10) NOT NULL auto_increment, | ||
+ | `plugin` varchar(16) NOT NULL default '', | ||
+ | `table` varchar(64) NOT NULL default '', | ||
+ | `column` varchar(64) NOT NULL, | ||
+ | `method` varchar(16) NOT NULL default '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `plugin` (`plugin`), | ||
+ | KEY `method` (`method`) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | REPLACE INTO `plugin_realms` VALUES (1, ' | ||
+ | INSERT INTO `plugin_hooks` VALUES (1, ' | ||
+ | INSERT INTO `plugin_hooks` VALUES (2, ' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `poller` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE poller ( | ||
+ | id smallint(5) unsigned NOT NULL auto_increment, | ||
+ | hostname varchar(250) NOT NULL default '', | ||
+ | ip_address int(11) unsigned NOT NULL default ' | ||
+ | last_update datetime NOT NULL default ' | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `poller_command` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE poller_command ( | ||
+ | poller_id smallint(5) unsigned NOT NULL default ' | ||
+ | time datetime NOT NULL default ' | ||
+ | action tinyint(3) unsigned NOT NULL default ' | ||
+ | command varchar(200) NOT NULL default '', | ||
+ | PRIMARY KEY (poller_id, | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `poller_item` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE poller_item ( | ||
+ | local_data_id mediumint(8) unsigned NOT NULL default ' | ||
+ | poller_id smallint(5) unsigned NOT NULL default ' | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | action tinyint(2) unsigned NOT NULL default ' | ||
+ | present tinyint NOT NULL DEFAULT ' | ||
+ | hostname varchar(250) NOT NULL default '', | ||
+ | snmp_community varchar(100) NOT NULL default '', | ||
+ | snmp_version tinyint(1) unsigned NOT NULL default ' | ||
+ | snmp_username varchar(50) NOT NULL default '', | ||
+ | snmp_password varchar(50) NOT NULL default '', | ||
+ | snmp_auth_protocol varchar(5) NOT NULL default '', | ||
+ | snmp_priv_passphrase varchar(200) NOT NULL default '', | ||
+ | snmp_priv_protocol varchar(6) NOT NULL default '', | ||
+ | snmp_context varchar(64) default '', | ||
+ | snmp_port mediumint(5) unsigned NOT NULL default ' | ||
+ | snmp_timeout mediumint(8) unsigned NOT NULL default ' | ||
+ | rrd_name varchar(19) NOT NULL default '', | ||
+ | rrd_path varchar(255) NOT NULL default '', | ||
+ | rrd_num tinyint(2) unsigned NOT NULL default ' | ||
+ | rrd_step mediumint(8) NOT NULL default ' | ||
+ | rrd_next_step mediumint(8) NOT NULL default ' | ||
+ | arg1 TEXT default NULL, | ||
+ | arg2 varchar(255) default NULL, | ||
+ | arg3 varchar(255) default NULL, | ||
+ | PRIMARY KEY (local_data_id, | ||
+ | KEY local_data_id (local_data_id), | ||
+ | KEY host_id (host_id), | ||
+ | KEY rrd_next_step (rrd_next_step), | ||
+ | KEY action (action), | ||
+ | KEY present (present) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `poller_output` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE poller_output ( | ||
+ | local_data_id mediumint(8) unsigned NOT NULL default ' | ||
+ | rrd_name varchar(19) NOT NULL default '', | ||
+ | time datetime NOT NULL default ' | ||
+ | output text NOT NULL, | ||
+ | PRIMARY KEY (local_data_id, | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `poller_reindex` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE poller_reindex ( | ||
+ | host_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_query_id mediumint(8) unsigned NOT NULL default ' | ||
+ | action tinyint(3) unsigned NOT NULL default ' | ||
+ | present tinyint NOT NULL DEFAULT ' | ||
+ | op char(1) NOT NULL default '', | ||
+ | assert_value varchar(100) NOT NULL default '', | ||
+ | arg1 varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (host_id, | ||
+ | KEY present (present) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `poller_time` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE poller_time ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | pid int(11) unsigned NOT NULL default ' | ||
+ | poller_id smallint(5) unsigned NOT NULL default ' | ||
+ | start_time datetime NOT NULL default ' | ||
+ | end_time datetime NOT NULL default ' | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `rra` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE rra ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | name varchar(100) NOT NULL default '', | ||
+ | x_files_factor double NOT NULL default ' | ||
+ | steps mediumint(8) default ' | ||
+ | rows int(12) NOT NULL default ' | ||
+ | timespan int(12) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `rra` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO rra VALUES (1,' | ||
+ | INSERT INTO rra VALUES (2,' | ||
+ | INSERT INTO rra VALUES (3,' | ||
+ | INSERT INTO rra VALUES (4,' | ||
+ | INSERT INTO rra VALUES (5,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `rra_cf` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE rra_cf ( | ||
+ | rra_id mediumint(8) unsigned NOT NULL default ' | ||
+ | consolidation_function_id smallint(5) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (rra_id, | ||
+ | KEY rra_id (rra_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `rra_cf` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO rra_cf VALUES (1,1); | ||
+ | INSERT INTO rra_cf VALUES (1,3); | ||
+ | INSERT INTO rra_cf VALUES (2,1); | ||
+ | INSERT INTO rra_cf VALUES (2,3); | ||
+ | INSERT INTO rra_cf VALUES (3,1); | ||
+ | INSERT INTO rra_cf VALUES (3,3); | ||
+ | INSERT INTO rra_cf VALUES (4,1); | ||
+ | INSERT INTO rra_cf VALUES (4,3); | ||
+ | INSERT INTO rra_cf VALUES (5,1); | ||
+ | INSERT INTO rra_cf VALUES (5,3); | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `settings` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE settings ( | ||
+ | name varchar(50) NOT NULL default '', | ||
+ | value varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (name) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `settings` | ||
+ | -- | ||
+ | |||
+ | |||
+ | -- | ||
+ | -- Table structure for table `settings_graphs` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE settings_graphs ( | ||
+ | user_id smallint(8) unsigned NOT NULL default ' | ||
+ | name varchar(50) NOT NULL default '', | ||
+ | value varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (user_id, | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `settings_graphs` | ||
+ | -- | ||
+ | |||
+ | |||
+ | -- | ||
+ | -- Table structure for table `settings_tree` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE settings_tree ( | ||
+ | user_id mediumint(8) unsigned NOT NULL default ' | ||
+ | graph_tree_item_id mediumint(8) unsigned NOT NULL default ' | ||
+ | status tinyint(1) NOT NULL default ' | ||
+ | PRIMARY KEY (user_id, | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `settings_tree` | ||
+ | -- | ||
+ | |||
+ | |||
+ | -- | ||
+ | -- Table structure for table `snmp_query` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE snmp_query ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | xml_path varchar(255) NOT NULL default '', | ||
+ | name varchar(100) NOT NULL default '', | ||
+ | description varchar(255) default NULL, | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_input_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (id), | ||
+ | KEY name (name) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `snmp_query` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO snmp_query VALUES (1,' | ||
+ | INSERT INTO snmp_query VALUES (2,' | ||
+ | INSERT INTO snmp_query VALUES (3,' | ||
+ | INSERT INTO snmp_query VALUES (4,' | ||
+ | INSERT INTO snmp_query VALUES (6,' | ||
+ | INSERT INTO snmp_query VALUES (7,' | ||
+ | INSERT INTO snmp_query VALUES (8,' | ||
+ | INSERT INTO snmp_query VALUES (9,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `snmp_query_graph` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE snmp_query_graph ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | snmp_query_id mediumint(8) unsigned NOT NULL default ' | ||
+ | name varchar(100) NOT NULL default '', | ||
+ | graph_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `snmp_query_graph` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO snmp_query_graph VALUES (2,' | ||
+ | INSERT INTO snmp_query_graph VALUES (3,' | ||
+ | INSERT INTO snmp_query_graph VALUES (4,' | ||
+ | INSERT INTO snmp_query_graph VALUES (6,' | ||
+ | INSERT INTO snmp_query_graph VALUES (7,' | ||
+ | INSERT INTO snmp_query_graph VALUES (8,' | ||
+ | INSERT INTO snmp_query_graph VALUES (9,' | ||
+ | INSERT INTO snmp_query_graph VALUES (10,' | ||
+ | INSERT INTO snmp_query_graph VALUES (11,' | ||
+ | INSERT INTO snmp_query_graph VALUES (13,' | ||
+ | INSERT INTO snmp_query_graph VALUES (14,' | ||
+ | INSERT INTO snmp_query_graph VALUES (15,' | ||
+ | INSERT INTO snmp_query_graph VALUES (16,' | ||
+ | INSERT INTO snmp_query_graph VALUES (17,' | ||
+ | INSERT INTO snmp_query_graph VALUES (18,' | ||
+ | INSERT INTO snmp_query_graph VALUES (19,' | ||
+ | INSERT INTO snmp_query_graph VALUES (20,' | ||
+ | INSERT INTO snmp_query_graph VALUES (21,' | ||
+ | INSERT INTO snmp_query_graph VALUES (22,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `snmp_query_graph_rrd` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE snmp_query_graph_rrd ( | ||
+ | snmp_query_graph_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_template_rrd_id mediumint(8) unsigned NOT NULL default ' | ||
+ | snmp_field_name varchar(50) NOT NULL default ' | ||
+ | PRIMARY KEY (snmp_query_graph_id, | ||
+ | KEY data_template_rrd_id (data_template_rrd_id), | ||
+ | KEY snmp_query_graph_id (snmp_query_graph_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `snmp_query_graph_rrd` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO snmp_query_graph_rrd VALUES (2, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (3, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (3, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (4, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (2, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (6, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (6, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (7, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (7, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (8, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (8, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (9, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (9, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (10, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (10, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (10, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (11, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (11, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (2, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (2, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (13, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (14, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (14, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (13, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (4, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (15, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (16, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (16, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (15, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (17, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (18, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (18, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (19, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (20, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (20, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (21, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (21, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (22, | ||
+ | INSERT INTO snmp_query_graph_rrd VALUES (22, | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `snmp_query_graph_rrd_sv` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE snmp_query_graph_rrd_sv ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | snmp_query_graph_id mediumint(8) unsigned NOT NULL default ' | ||
+ | data_template_id mediumint(8) unsigned NOT NULL default ' | ||
+ | sequence mediumint(8) unsigned NOT NULL default ' | ||
+ | field_name varchar(100) NOT NULL default '', | ||
+ | text varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (id), | ||
+ | KEY snmp_query_graph_id (snmp_query_graph_id), | ||
+ | KEY data_template_id (data_template_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `snmp_query_graph_rrd_sv` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (10,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (11,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (12,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (13,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (14,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (30,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (29,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (80,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (85,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (84,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (83,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (32,'', | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (49,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (50,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (51,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (52,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (54,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (55,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (56,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (57,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (59,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (60,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (61,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (62,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (69,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (70,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (72,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (73,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (74,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (75,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (76,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (77,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (78,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (79,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (81,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (82,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (86,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (88,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (89,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (90,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (91,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (92,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (93,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (94,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (95,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (96,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (97,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (98,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (99,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (100,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (101,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (102,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (103,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (104,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (105,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (106,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (107,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (108,' | ||
+ | INSERT INTO snmp_query_graph_rrd_sv VALUES (109,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `snmp_query_graph_sv` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE snmp_query_graph_sv ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | hash varchar(32) NOT NULL default '', | ||
+ | snmp_query_graph_id mediumint(8) unsigned NOT NULL default ' | ||
+ | sequence mediumint(8) unsigned NOT NULL default ' | ||
+ | field_name varchar(100) NOT NULL default '', | ||
+ | text varchar(255) NOT NULL default '', | ||
+ | PRIMARY KEY (id), | ||
+ | KEY snmp_query_graph_id (snmp_query_graph_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `snmp_query_graph_sv` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO snmp_query_graph_sv VALUES (7,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (5,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (6,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (11,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (12,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (14,'', | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (15,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (16,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (17,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (18,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (19,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (20,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (21,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (22,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (23,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (24,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (25,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (26,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (27,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (28,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (29,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (30,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (31,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (32,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (33,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (34,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (35,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (36,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (38,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (39,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (40,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (41,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (42,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (43,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (44,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (45,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (46,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (47,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (48,' | ||
+ | INSERT INTO snmp_query_graph_sv VALUES (49,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `user_auth` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE user_auth ( | ||
+ | id mediumint(8) unsigned NOT NULL auto_increment, | ||
+ | username varchar(50) NOT NULL default ' | ||
+ | password varchar(50) NOT NULL default ' | ||
+ | realm mediumint(8) NOT NULL default ' | ||
+ | full_name varchar(100) default ' | ||
+ | must_change_password char(2) default NULL, | ||
+ | show_tree char(2) default ' | ||
+ | show_list char(2) default ' | ||
+ | show_preview char(2) NOT NULL default ' | ||
+ | graph_settings char(2) default NULL, | ||
+ | login_opts tinyint(1) NOT NULL default ' | ||
+ | policy_graphs tinyint(1) unsigned NOT NULL default ' | ||
+ | policy_trees tinyint(1) unsigned NOT NULL default ' | ||
+ | policy_hosts tinyint(1) unsigned NOT NULL default ' | ||
+ | policy_graph_templates tinyint(1) unsigned NOT NULL default ' | ||
+ | enabled char(2) NOT NULL DEFAULT ' | ||
+ | PRIMARY KEY (id), | ||
+ | KEY username (username), | ||
+ | KEY realm (realm), | ||
+ | KEY enabled (enabled) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `user_auth` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO user_auth VALUES (1,' | ||
+ | INSERT INTO user_auth VALUES (3,' | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `user_auth_perms` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE user_auth_perms ( | ||
+ | user_id mediumint(8) unsigned NOT NULL default ' | ||
+ | item_id mediumint(8) unsigned NOT NULL default ' | ||
+ | type tinyint(2) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (user_id, | ||
+ | KEY user_id (user_id, | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `user_auth_perms` | ||
+ | -- | ||
+ | |||
+ | |||
+ | -- | ||
+ | -- Table structure for table `user_auth_realm` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE user_auth_realm ( | ||
+ | realm_id mediumint(8) unsigned NOT NULL default ' | ||
+ | user_id mediumint(8) unsigned NOT NULL default ' | ||
+ | PRIMARY KEY (realm_id, | ||
+ | KEY user_id (user_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `user_auth_realm` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO user_auth_realm VALUES (1,1); | ||
+ | INSERT INTO user_auth_realm VALUES (2,1); | ||
+ | INSERT INTO user_auth_realm VALUES (3,1); | ||
+ | INSERT INTO user_auth_realm VALUES (4,1); | ||
+ | INSERT INTO user_auth_realm VALUES (5,1); | ||
+ | INSERT INTO user_auth_realm VALUES (7,1); | ||
+ | INSERT INTO user_auth_realm VALUES (7,3); | ||
+ | INSERT INTO user_auth_realm VALUES (8,1); | ||
+ | INSERT INTO user_auth_realm VALUES (9,1); | ||
+ | INSERT INTO user_auth_realm VALUES (10,1); | ||
+ | INSERT INTO user_auth_realm VALUES (11,1); | ||
+ | INSERT INTO user_auth_realm VALUES (12,1); | ||
+ | INSERT INTO user_auth_realm VALUES (13,1); | ||
+ | INSERT INTO user_auth_realm VALUES (14,1); | ||
+ | INSERT INTO user_auth_realm VALUES (15,1); | ||
+ | INSERT INTO user_auth_realm VALUES (16,1); | ||
+ | INSERT INTO user_auth_realm VALUES (17,1); | ||
+ | INSERT INTO user_auth_realm VALUES (101,1); | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `user_log` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE user_log ( | ||
+ | username varchar(50) NOT NULL default ' | ||
+ | user_id mediumint(8) NOT NULL default ' | ||
+ | time datetime NOT NULL default ' | ||
+ | result tinyint(1) NOT NULL default ' | ||
+ | ip varchar(40) NOT NULL default '', | ||
+ | PRIMARY KEY (username, | ||
+ | KEY username (username), | ||
+ | KEY user_id (user_id) | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `user_log` | ||
+ | -- | ||
+ | |||
+ | |||
+ | -- | ||
+ | -- Table structure for table `version` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE version ( | ||
+ | cacti char(20) default NULL | ||
+ | ) ENGINE=MyISAM; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `version` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO version VALUES (' | ||
+ | </ | ||
+ | - **Datenbanktabellen anlegen** \\ Zu guter Letzt, legen wir nun die Datenbanktabellen mit dem Template-Datei an. < | ||
+ | Enter password:</ | ||
+ | |||
+ | ===== PHP-Konfiguration ===== | ||
+ | Das gerade definierte Passwort für unseren MySQL-Datenbankzugang, | ||
+ | # vim / | ||
+ | <file php config.php> | ||
+ | <?php | ||
+ | /* | ||
+ | | ||
+ | | Copyright (C) 2004-2012 The Cacti Group | | ||
+ | | ||
+ | | This program is free software; you can redistribute it and/ | ||
+ | | modify it under the terms of the GNU General Public License | ||
+ | | as published by the Free Software Foundation; either version 2 | | ||
+ | | of the License, or (at your option) any later version. | ||
+ | | ||
+ | | This program is distributed in the hope that it will be useful, | ||
+ | | but WITHOUT ANY WARRANTY; without even the implied warranty of | | ||
+ | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | ||
+ | | GNU General Public License for more details. | ||
+ | | ||
+ | | Cacti: The Complete RRDTool-based Graphing Solution | ||
+ | | ||
+ | | This code is designed, written, and maintained by the Cacti Group. See | | ||
+ | | about.php and/or the AUTHORS file for specific developer information. | ||
+ | | ||
+ | | https:// | ||
+ | | ||
+ | */ | ||
+ | |||
+ | /* make sure these values refect your actual database/ | ||
+ | $database_type = " | ||
+ | $database_default = " | ||
+ | $database_hostname = " | ||
+ | $database_username = " | ||
+ | $database_password = " | ||
+ | $database_port = " | ||
+ | $database_ssl = false; | ||
+ | |||
+ | /* | ||
+ | Edit this to point to the default URL of your Cacti install | ||
+ | ex: if your cacti install as at https:// | ||
+ | would be set to /cacti/ | ||
+ | */ | ||
+ | //$url_path = "/ | ||
+ | // Django : 2012-07-16 - Document-Root setzen | ||
+ | $url_path = "/"; | ||
+ | |||
+ | /* Default session name - Session name must contain alpha characters */ | ||
+ | // | ||
+ | |||
+ | ?> | ||
+ | </ | ||
+ | |||
+ | Zum regelmäßigen Sammeln der Daten wird alle 5 Minuten das Pollerscript // | ||
+ | <file bash / | ||
+ | </ | ||
+ | |||
+ | <file php / | ||
+ | /* | ||
+ | | ||
+ | | Copyright (C) 2004-2012 The Cacti Group | | ||
+ | | ||
+ | | This program is free software; you can redistribute it and/ | ||
+ | | modify it under the terms of the GNU General Public License | ||
+ | | as published by the Free Software Foundation; either version 2 | | ||
+ | | of the License, or (at your option) any later version. | ||
+ | | ||
+ | | This program is distributed in the hope that it will be useful, | ||
+ | | but WITHOUT ANY WARRANTY; without even the implied warranty of | | ||
+ | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | ||
+ | | GNU General Public License for more details. | ||
+ | | ||
+ | | Cacti: The Complete RRDTool-based Graphing Solution | ||
+ | | ||
+ | | This code is designed, written, and maintained by the Cacti Group. See | | ||
+ | | about.php and/or the AUTHORS file for specific developer information. | ||
+ | | ||
+ | | https:// | ||
+ | | ||
+ | */ | ||
+ | |||
+ | /* tick use required as of PHP 4.3.0 to accomodate signal handling */ | ||
+ | declare(ticks = 1); | ||
+ | |||
+ | function sig_handler($signo) { | ||
+ | switch ($signo) { | ||
+ | case SIGTERM: | ||
+ | case SIGINT: | ||
+ | cacti_log(" | ||
+ | |||
+ | $running_processes = db_fetch_assoc(" | ||
+ | |||
+ | if (sizeof($running_processes)) { | ||
+ | foreach($running_processes as $process) { | ||
+ | if (function_exists(" | ||
+ | cacti_log(" | ||
+ | posix_kill($process[" | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | |||
+ | db_execute(" | ||
+ | |||
+ | exit; | ||
+ | break; | ||
+ | default: | ||
+ | /* ignore all other signals */ | ||
+ | } | ||
+ | } | ||
+ | |||
+ | /* do NOT run this script through a web browser */ | ||
+ | if (!isset($_SERVER[" | ||
+ | die("< | ||
+ | } | ||
+ | |||
+ | /* we are not talking to the browser */ | ||
+ | $no_http_headers = true; | ||
+ | |||
+ | /* start initialization section */ | ||
+ | include(dirname(__FILE__) . "/ | ||
+ | include_once($config[" | ||
+ | include_once($config[" | ||
+ | include_once($config[" | ||
+ | include_once($config[" | ||
+ | |||
+ | /* initialize some variables */ | ||
+ | $force = FALSE; | ||
+ | $debug = FALSE; | ||
+ | |||
+ | /* process calling arguments */ | ||
+ | $parms = $_SERVER[" | ||
+ | array_shift($parms); | ||
+ | |||
+ | if (sizeof($parms)) { | ||
+ | foreach($parms as $parameter) { | ||
+ | @list($arg, $value) = @explode(" | ||
+ | |||
+ | switch ($arg) { | ||
+ | case " | ||
+ | case " | ||
+ | $debug = TRUE; | ||
+ | |||
+ | break; | ||
+ | case " | ||
+ | $force = TRUE; | ||
+ | |||
+ | break; | ||
+ | case " | ||
+ | case " | ||
+ | case " | ||
+ | case " | ||
+ | display_help(); | ||
+ | exit(0); | ||
+ | default: | ||
+ | echo " | ||
+ | display_help(); | ||
+ | exit(1); | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | |||
+ | /* install signal handlers for UNIX only */ | ||
+ | if (function_exists(" | ||
+ | pcntl_signal(SIGTERM, | ||
+ | pcntl_signal(SIGINT, | ||
+ | } | ||
+ | |||
+ | api_plugin_hook(' | ||
+ | |||
+ | /* record the start time */ | ||
+ | list($micro, | ||
+ | $poller_start | ||
+ | $overhead_time = 0; | ||
+ | |||
+ | /* get number of polling items from the database */ | ||
+ | $poller_interval = read_config_option(" | ||
+ | |||
+ | /* retreive the last time the poller ran */ | ||
+ | $poller_lastrun = read_config_option(' | ||
+ | |||
+ | /* get the current cron interval from the database */ | ||
+ | $cron_interval = read_config_option(" | ||
+ | |||
+ | if ($cron_interval != 60) { | ||
+ | $cron_interval = 300; | ||
+ | } | ||
+ | |||
+ | /* see if the user wishes to use process leveling */ | ||
+ | $process_leveling = read_config_option(" | ||
+ | |||
+ | /* retreive the number of concurrent process settings */ | ||
+ | $concurrent_processes = read_config_option(" | ||
+ | |||
+ | /* assume a scheduled task of either 60 or 300 seconds */ | ||
+ | if (isset($poller_interval)) { | ||
+ | $poller_runs | ||
+ | $sql_where = " | ||
+ | |||
+ | define(" | ||
+ | }else{ | ||
+ | $sql_where = ""; | ||
+ | $poller_runs | ||
+ | define(" | ||
+ | } | ||
+ | |||
+ | $num_polling_items = db_fetch_cell(" | ||
+ | if (isset($concurrent_processes) && $concurrent_processes > 1) { | ||
+ | $items_perhost | ||
+ | FROM poller_item | ||
+ | $sql_where | ||
+ | GROUP BY host_id | ||
+ | ORDER BY host_id" | ||
+ | } | ||
+ | |||
+ | if (isset($items_perhost) && sizeof($items_perhost)) { | ||
+ | $items_per_process | ||
+ | |||
+ | if ($items_per_process == 0) { | ||
+ | $process_leveling = " | ||
+ | } | ||
+ | }else{ | ||
+ | $process_leveling | ||
+ | } | ||
+ | |||
+ | /* some text formatting for platform specific vocabulary */ | ||
+ | if ($config[" | ||
+ | $task_type = " | ||
+ | }else{ | ||
+ | $task_type = " | ||
+ | } | ||
+ | |||
+ | if (read_config_option(' | ||
+ | $poller_seconds_sincerun = " | ||
+ | if (isset($poller_lastrun)) { | ||
+ | $poller_seconds_sincerun = $seconds - $poller_lastrun; | ||
+ | } | ||
+ | |||
+ | cacti_log(" | ||
+ | } | ||
+ | |||
+ | /* our cron can run at either 1 or 5 minute intervals */ | ||
+ | if ($poller_interval <= 60) { | ||
+ | $min_period = " | ||
+ | }else{ | ||
+ | $min_period = " | ||
+ | } | ||
+ | |||
+ | /* get to see if we are polling faster than reported by the settings, if so, exit */ | ||
+ | if ((isset($poller_lastrun) && isset($poller_interval) && $poller_lastrun > 0) && (!$force)) { | ||
+ | /* give the user some flexibility to run a little moe often */ | ||
+ | if ((($seconds - $poller_lastrun)*1.3) < MAX_POLLER_RUNTIME) { | ||
+ | if (read_config_option(' | ||
+ | cacti_log(" | ||
+ | } | ||
+ | exit; | ||
+ | } | ||
+ | } | ||
+ | |||
+ | /* check to see whether we have the poller interval set lower than the poller is actually ran, if so, issue a warning */ | ||
+ | if ((($seconds - $poller_lastrun - 5) > MAX_POLLER_RUNTIME) && ($poller_lastrun > 0)) { | ||
+ | cacti_log(" | ||
+ | } | ||
+ | |||
+ | db_execute(" | ||
+ | |||
+ | /* let PHP only run 1 second longer than the max runtime, plus the poller needs lot's of memory */ | ||
+ | ini_set(" | ||
+ | ini_set(" | ||
+ | |||
+ | $poller_runs_completed = 0; | ||
+ | $poller_items_total | ||
+ | $polling_hosts | ||
+ | |||
+ | while ($poller_runs_completed < $poller_runs) { | ||
+ | /* record the start time for this loop */ | ||
+ | list($micro, | ||
+ | $loop_start = $seconds + $micro; | ||
+ | |||
+ | /* calculate overhead time */ | ||
+ | if ($overhead_time == 0) { | ||
+ | $overhead_time = $loop_start - $poller_start; | ||
+ | } | ||
+ | |||
+ | /* initialize counters for script file handling */ | ||
+ | $host_count = 1; | ||
+ | |||
+ | /* initialize file creation flags */ | ||
+ | $change_proc = false; | ||
+ | |||
+ | /* initialize file and host count pointers */ | ||
+ | $started_processes = 0; | ||
+ | $first_host | ||
+ | $last_host | ||
+ | |||
+ | /* update web paths for the poller */ | ||
+ | db_execute(" | ||
+ | |||
+ | /* obtain some defaults from the database */ | ||
+ | $poller | ||
+ | $max_threads = read_config_option(" | ||
+ | |||
+ | /* initialize poller_time and poller_output tables, check poller_output for issues */ | ||
+ | $running_processes = db_fetch_cell(" | ||
+ | if ($running_processes) { | ||
+ | cacti_log(" | ||
+ | } | ||
+ | db_execute(" | ||
+ | |||
+ | $issues_limit = 20; | ||
+ | $issues = db_fetch_assoc(" | ||
+ | $count = db_fetch_cell(" | ||
+ | if (sizeof($issues)) { | ||
+ | $issue_list = ""; | ||
+ | foreach($issues as $issue) { | ||
+ | $issue_list .= (strlen($issue_list) ? ", " : "" | ||
+ | } | ||
+ | |||
+ | if ($count > $issues_limit) { | ||
+ | $issue_list .= ", Additional Issues Remain. | ||
+ | } | ||
+ | |||
+ | cacti_log(" | ||
+ | db_execute(" | ||
+ | } | ||
+ | |||
+ | /* mainline */ | ||
+ | if (read_config_option(" | ||
+ | /* determine the number of hosts to process per file */ | ||
+ | $hosts_per_process = ceil(sizeof($polling_hosts) / $concurrent_processes ); | ||
+ | |||
+ | $items_launched | ||
+ | |||
+ | /* exit poller if spine is selected and file does not exist */ | ||
+ | if (($poller == " | ||
+ | cacti_log(" | ||
+ | exit; | ||
+ | } | ||
+ | |||
+ | /* Determine Command Name */ | ||
+ | if ($poller == " | ||
+ | $command_string = read_config_option(" | ||
+ | $extra_args | ||
+ | $method | ||
+ | $total_procs | ||
+ | chdir(dirname(read_config_option(" | ||
+ | }else if ($config[" | ||
+ | $command_string = read_config_option(" | ||
+ | $extra_args | ||
+ | $method | ||
+ | $total_procs | ||
+ | }else{ | ||
+ | $command_string = read_config_option(" | ||
+ | $extra_args | ||
+ | $method | ||
+ | $total_procs | ||
+ | } | ||
+ | |||
+ | $extra_args = api_plugin_hook_function (' | ||
+ | |||
+ | /* Populate each execution file with appropriate information */ | ||
+ | foreach ($polling_hosts as $item) { | ||
+ | if ($host_count == 1) { | ||
+ | $first_host = $item[" | ||
+ | } | ||
+ | |||
+ | if ($process_leveling != " | ||
+ | if ($host_count == $hosts_per_process) { | ||
+ | $last_host | ||
+ | $change_proc | ||
+ | } | ||
+ | }else{ | ||
+ | if (isset($items_perhost[$item[" | ||
+ | $items_launched += $items_perhost[$item[" | ||
+ | } | ||
+ | |||
+ | if (($items_launched >= $items_per_process) || | ||
+ | (sizeof($items_perhost) == $concurrent_processes)) { | ||
+ | $last_host | ||
+ | /* if this is the dummy entry for externally updated data sources | ||
+ | * that are not related to any host (host id = 0), do NOT change_proc */ | ||
+ | $change_proc | ||
+ | $items_launched = 0; | ||
+ | } | ||
+ | } | ||
+ | |||
+ | $host_count ++; | ||
+ | |||
+ | if ($change_proc) { | ||
+ | exec_background($command_string, | ||
+ | usleep(100000); | ||
+ | |||
+ | $host_count | ||
+ | $change_proc | ||
+ | $first_host | ||
+ | $last_host | ||
+ | |||
+ | $started_processes++; | ||
+ | } /* end change_process */ | ||
+ | } /* end for each */ | ||
+ | |||
+ | /* launch the last process */ | ||
+ | if ($host_count > 1) { | ||
+ | $last_host = $item[" | ||
+ | |||
+ | exec_background($command_string, | ||
+ | usleep(100000); | ||
+ | |||
+ | $started_processes++; | ||
+ | } | ||
+ | |||
+ | /* insert the current date/time for graphs */ | ||
+ | db_execute(" | ||
+ | |||
+ | if ($poller == " | ||
+ | $max_threads = " | ||
+ | } | ||
+ | |||
+ | /* open a pipe to rrdtool for writing */ | ||
+ | $rrdtool_pipe = rrd_init(); | ||
+ | |||
+ | $rrds_processed = 0; | ||
+ | $poller_finishing_dispatched = FALSE; | ||
+ | while (1) { | ||
+ | $finished_processes = db_fetch_cell(" | ||
+ | |||
+ | if ($finished_processes >= $started_processes) { | ||
+ | /* all scheduled pollers are finished */ | ||
+ | if ($poller_finishing_dispatched === FALSE) { | ||
+ | api_plugin_hook(' | ||
+ | $poller_finishing_dispatched = TRUE; | ||
+ | } | ||
+ | $rrds_processed = $rrds_processed + process_poller_output($rrdtool_pipe, | ||
+ | |||
+ | log_cacti_stats($loop_start, | ||
+ | sizeof($polling_hosts), | ||
+ | |||
+ | break; | ||
+ | }else { | ||
+ | if (read_config_option(" | ||
+ | print " | ||
+ | } | ||
+ | |||
+ | $rrds_processed = $rrds_processed + process_poller_output($rrdtool_pipe); | ||
+ | |||
+ | /* end the process if the runtime exceeds MAX_POLLER_RUNTIME */ | ||
+ | if (($poller_start + MAX_POLLER_RUNTIME) < time()) { | ||
+ | cacti_log(" | ||
+ | |||
+ | log_cacti_stats($loop_start, | ||
+ | sizeof($polling_hosts), | ||
+ | |||
+ | break; | ||
+ | }else{ | ||
+ | usleep(500); | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | |||
+ | rrd_close($rrdtool_pipe); | ||
+ | |||
+ | /* process poller commands */ | ||
+ | if (db_fetch_cell(" | ||
+ | $command_string = read_config_option(" | ||
+ | $extra_args = "-q \"" | ||
+ | exec_background($command_string, | ||
+ | } else { | ||
+ | /* no re-index or Rechache present on this run | ||
+ | * in case, we have more PCOMMANDS than recaching, this has to be moved to poller_commands.php | ||
+ | * but then we'll have to call it each time to make sure, stats are updated */ | ||
+ | db_execute(" | ||
+ | } | ||
+ | |||
+ | /* graph export */ | ||
+ | if ((read_config_option(" | ||
+ | (read_config_option(" | ||
+ | $command_string = read_config_option(" | ||
+ | $extra_args = "-q \"" | ||
+ | exec_background($command_string, | ||
+ | } | ||
+ | |||
+ | if ($method == " | ||
+ | chdir(read_config_option(" | ||
+ | } | ||
+ | }else if (read_config_option(' | ||
+ | cacti_log(" | ||
+ | } | ||
+ | |||
+ | $poller_runs_completed++; | ||
+ | |||
+ | /* record the start time for this loop */ | ||
+ | list($micro, | ||
+ | $loop_end | ||
+ | $loop_time = $loop_end - $loop_start; | ||
+ | |||
+ | if ($loop_time < $poller_interval) { | ||
+ | if ($poller_runs_completed == 1) { | ||
+ | $sleep_time = $poller_interval - $loop_time - $overhead_time; | ||
+ | } else { | ||
+ | $sleep_time = $poller_interval - $loop_time; | ||
+ | } | ||
+ | |||
+ | /* log some nice debug information */ | ||
+ | if (read_config_option(' | ||
+ | echo " | ||
+ | echo "Sleep Time is: " . round($sleep_time, | ||
+ | echo "Total Time is: " . round($loop_end - $poller_start, | ||
+ | } | ||
+ | |||
+ | /* sleep the appripriate amount of time */ | ||
+ | if ($poller_runs_completed < $poller_runs) { | ||
+ | api_plugin_hook(' | ||
+ | usleep($sleep_time * 1000000); | ||
+ | api_plugin_hook(' | ||
+ | } | ||
+ | }else if (read_config_option(' | ||
+ | cacti_log(" | ||
+ | } | ||
+ | } | ||
+ | |||
+ | function log_cacti_stats($loop_start, | ||
+ | $hosts_per_process, | ||
+ | |||
+ | /* take time and log performance data */ | ||
+ | list($micro, | ||
+ | $loop_end = $seconds + $micro; | ||
+ | |||
+ | $cacti_stats = sprintf( | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | round($loop_end-$loop_start, | ||
+ | $method, | ||
+ | $concurrent_processes, | ||
+ | $max_threads, | ||
+ | $num_hosts, | ||
+ | $hosts_per_process, | ||
+ | $num_polling_items, | ||
+ | $rrds_processed); | ||
+ | |||
+ | cacti_log(" | ||
+ | |||
+ | /* insert poller stats into the settings table */ | ||
+ | db_execute(" | ||
+ | } | ||
+ | |||
+ | function display_help() { | ||
+ | echo "Cacti Poller Version " . db_fetch_cell(" | ||
+ | echo "A simple command line utility to run the Cacti Poller.\n\n"; | ||
+ | echo " | ||
+ | echo " | ||
+ | echo " | ||
+ | echo " | ||
+ | } | ||
+ | |||
+ | api_plugin_hook(' | ||
+ | |||
+ | ?> | ||
+ | </ | ||
+ | |||
+ | Dieses Script starten wir nun probehalber manuell. | ||
+ | # php / | ||
+ | |||
+ | Unter Umständen wirft das Script einige Fehler wie folgt. | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | Hierzu tragen wir in der Konfigurationsdatei von PHP // | ||
+ | # vim / | ||
+ | <code php>;;;;;;;;;;;;;;;;;;; | ||
+ | ; Module Settings ; | ||
+ | ;;;;;;;;;;;;;;;;;;; | ||
+ | |||
+ | [Date] | ||
+ | ; Defines the default timezone used by the date functions | ||
+ | ; https:// | ||
+ | date.timezone = " | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== Cacti - Setup ===== | ||
+ | Die Erstkonfiguration von Cacti erfolgt nunmehr direkt über den Browser unserer Wahl. Unseren zuvor definierten neuen Vhost [[https:// | ||
+ | $ firefox https:// | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Mit einem //beherzten " | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Auch diesen Punkt // | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Tja, und fast sind wir schon am Ende. Dass wir hier **Finish** anwählen, versteht sich so gut wie von selbst. ;-) | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Mit der Konfiguration sind wir soweit durch, was nun folgt ist noch die Anmeldung als User **admin** mit dem Passwort **admin**. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Das Ändern dieses Passwortes erfolgt nun im vorletzten Schritt. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Nach der Änderung des Defaultpasswortes gelangen wir zur Cacti-Hauptseite. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Nun können wir uns an die [[centos: | ||
+ | |||
+ | ====== Links ====== | ||
+ | * **[[centos: | ||
+ | * **[[wiki: | ||
+ | * **[[https:// | ||
+ | |||