Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende Überarbeitung | ||
| centos:cacti_c6:app_1 [18.07.2012 07:39. ] – [MySQL Definitionen] 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:// | ||
| + | |||