Package: ocsinventory-server Severity: wishlist Tags: patch Hello,
Following the bug #512660 I make some changes to let ocsinventory-server create the database. I use dbconfig-common with two SQL scripts: - debian/db/mysql: for a new installation - debian/db/1.02: for an upgrade from 1.01 I don't have a 1.0 and previous version database to make the diffs and I suppose that it's not a serious problem since they are not packaged. The process is not ended for now, I need to modify ocsinventory-reports to automatically create dbconfig.inc.php (with dbconfig-common). I attach a gziped diff, I publish my developpement in a bzr repository at http://www.baby-gnu.org/~nebu/archives/ocsinventory/server/dad/ Regards. -- System Information: Debian Release: squeeze/sid APT prefers unstable APT policy: (500, 'unstable'), (90, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 2.6.30-rc6+hati.1 (SMP w/2 CPU cores; PREEMPT) Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash -- Daniel Dehennin Récupérer ma clef GPG: gpg --keyserver pgp.mit.edu --recv-keys 0x6A2540D1
=== added directory 'debian/db' === added file 'debian/db/1.02' --- debian/db/1.02 1970-01-01 00:00:00 +0000 +++ debian/db/1.02 2009-05-20 10:21:06 +0000 @@ -0,0 +1,271 @@ +-- -*- sql -*- +USE ocsweb; + +-- +-- Create new schema +-- +CREATE TABLE `blacklist_macaddresses` ( + `ID` INTEGER auto_increment, + `MACADDRESS` VARCHAR(255), + PRIMARY KEY (`MACADDRESS`), + KEY `ID` (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `blacklist_serials` ( + `ID` INTEGER auto_increment, + `SERIAL` VARCHAR(255), + PRIMARY KEY (`SERIAL`), + KEY `ID` (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `download_affect_rules` ( + `ID` int(11) NOT NULL auto_increment, + `RULE` int(11) NOT NULL, + `PRIORITY` int(11) NOT NULL, + `CFIELD` varchar(20) collate latin1_general_ci NOT NULL, + `OP` varchar(20) collate latin1_general_ci NOT NULL, + `COMPTO` varchar(20) collate latin1_general_ci NOT NULL, + `SERV_VALUE` varchar(20) collate latin1_general_ci default NULL, + `RULE_NAME` varchar(200) collate latin1_general_ci NOT NULL, + PRIMARY KEY (`ID`) +) ENGINE=MyISAM; + +CREATE TABLE `download_servers` ( + `HARDWARE_ID` int(11) NOT NULL, + `URL` varchar(250) collate latin1_general_ci NOT NULL, + `ADD_PORT` int(11) NOT NULL, + `ADD_REP` varchar(250) collate latin1_general_ci NOT NULL, + `GROUP_ID` int(11) NOT NULL, + PRIMARY KEY (`HARDWARE_ID`) +) ENGINE=MyISAM; + +CREATE TABLE `engine_mutex` ( + `NAME` varchar(255) NOT NULL default '', + `PID` int(11) default NULL, + `TAG` varchar(255) NOT NULL default '', + PRIMARY KEY (`NAME`, `TAG`) +) ENGINE=MEMORY DEFAULT CHARSET=latin1; + +CREATE TABLE `engine_persistent` ( + `ID` int(11) NOT NULL auto_increment, + `NAME` varchar(255) NOT NULL default '', + `IVALUE` int(11) default NULL, + `TVALUE` varchar(255) default NULL, + UNIQUE KEY `NAME` (`NAME`), + KEY `ID` (`ID`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; + +CREATE TABLE `groups` ( + `HARDWARE_ID` integer default NULL, + `REQUEST` longtext, + `CREATE_TIME` INT default 0, + `REVALIDATE_FROM` INT default 0, + PRIMARY KEY (`HARDWARE_ID`) +) ENGINE=MYISAM; + +CREATE TABLE `groups_cache` ( + `HARDWARE_ID` integer NOT NULL default 0, + `GROUP_ID` integer NOT NULL default 0, + `STATIC` integer default 0, + PRIMARY KEY (`HARDWARE_ID`, `GROUP_ID`) +) ENGINE=MYISAM; + +CREATE TABLE `hardware_osname_cache` ( + `ID` INTEGER auto_increment, + `OSNAME` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `prolog_conntrack` ( + `ID` int(11) NOT NULL auto_increment, + `DEVICEID` varchar(255) default NULL, + `TIMESTAMP` int(11) default NULL, + `PID` int(11) default NULL, + KEY `ID` (`ID`), + KEY `DEVICEID` (`DEVICEID`) +) ENGINE=MEMORY; + +CREATE TABLE `softwares_name_cache` ( + `ID` INTEGER auto_increment, + `NAME` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `tags` ( + `Tag` VARCHAR(255) NOT NULL default '', + `Login` VARCHAR(255) NOT NULL default '', + PRIMARY KEY (`Tag`, `Login`), + KEY `Tag` (`Tag`), + KEY `Login` (`Login`) +) ENGINE=MyISAM; + +CREATE TABLE `registry_name_cache` ( + `ID` INTEGER auto_increment, + `NAME` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `registry_regvalue_cache` ( + `ID` INTEGER auto_increment, + `REGVALUE` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + + +-- +-- Update existing schemas +-- + +-- accesslog +ALTER TABLE `accesslog` ADD KEY `USERID` (`USERID`); + +-- devices +ALTER TABLE `devices` ADD KEY `IVALUE` (`IVALUE`); +ALTER TABLE `devices` ADD KEY `NAME` (`NAME`); + +-- download_enable +ALTER TABLE `download_enable` ADD COLUMN `SERVER_ID` INTEGER; +ALTER TABLE `download_enable` ADD COLUMN `GROUP_ID` INTEGER; +ALTER TABLE `download_enable` ADD KEY `FILEID` (`FILEID`); + +-- hardware +ALTER TABLE `hardware` ADD COLUMN `SSTATE` INTEGER default 0; +ALTER TABLE `hardware` CHANGE `QUALITY` `QUALITY` DECIMAL(7,4) default NULL; -- NULL or 0 ? +ALTER TABLE `hardware` ADD KEY `USERID` (`USERID`); +ALTER TABLE `hardware` ADD KEY `WORKGROUP` (`WORKGROUP`); +ALTER TABLE `hardware` ADD KEY `OSNAME` (`OSNAME`); +ALTER TABLE `hardware` ADD KEY `MEMORY` (`MEMORY`); + +-- memories +ALTER TABLE `memories` ADD COLUMN `SERIALNUMBER` VARCHAR(255) default NULL AFTER `NUMSLOTS`; + +-- networks +-- IPSUBNET is 15/255 ? +ALTER TABLE `networks` ADD KEY `IPADDRESS` (`IPADDRESS`); +ALTER TABLE `networks` ADD KEY `IPGATEWAY` (`IPGATEWAY`); + +-- softwares +ALTER TABLE `softwares` ADD KEY `VERSION`(`VERSION`); + +-- storages +ALTER TABLE `storages` ADD COLUMN `SERIALNUMBER` VARCHAR(255) default NULL AFTER `DISKSIZE`; +ALTER TABLE `storages` ADD COLUMN `FIRMWARE` VARCHAR(255) default NULL AFTER `SERIALNUMBER`; + +-- subnet +ALTER TABLE `subnet` ADD KEY `ID` (`ID`); + +-- +-- Insert new values +-- + +-- blacklist_macaddresses +INSERT INTO `blacklist_macaddresses` (`MACADDRESS`) VALUES + ('00:00:00:00:00:00'), + ('FF:FF:FF:FF:FF:FF'), + ('44:45:53:54:00:00'), + ('44:45:53:54:00:01'), + ('00:01:02:7D:9B:1C'), + ('00:08:A1:46:06:35'), + ('00:08:A1:66:E2:1A'), + ('00:09:DD:10:37:68'), + ('00:0F:EA:9A:E2:F0'), + ('00:10:5A:72:71:F3'), + ('00:11:11:85:08:8B'), + ('10:11:11:11:11:11'), + ('44:45:53:54:61:6F'), + (''); + +-- blacklist_serials +INSERT INTO `blacklist_serials` (`SERIAL`) VALUES + ('N/A'), + ('(null string)'), + ('INVALID'), + ('SYS-1234567890'), + ('SYS-9876543210'), + ('SN-12345'), + ('SN-1234567890'), + ('1111111111'), + ('1111111'), + ('1'), + ('0123456789'), + ('12345'), + ('123456'), + ('1234567'), + ('12345678'), + ('123456789'), + ('1234567890'), + ('123456789000'), + ('12345678901234567'), + ('0000000000'), + ('000000000'), + ('00000000'), + ('0000000'), + ('000000'), + ('NNNNNNN'), + ('xxxxxxxxxxx'), + ('EVAL'), + ('IATPASS'), + ('none'), + ('To Be Filled By O.E.M.'), + ('Tulip Computers'), + ('Serial Number xxxxxx'), + ('SN-123456fvgv3i0b8o5n6n7k'), + (''); + +-- config +-- Update GUI_VERSION +UPDATE `config` + SET `TVALUE`='5003', `COMMENTS`='Version of the installed GUI and database' + WHERE NAME='GUI_VERSION'; + +DELETE FROM `config` WHERE NAME='IP_MIN_QUALITY'; + +-- Default new configuration +INSERT INTO `config` (`NAME`, `IVALUE`, `TVALUE`, `COMMENTS`) VALUES + ('DOWNLOAD_GROUPS_TRACE_EVENTS', 1, '', 'Specify if you want to track packages affected to a group on computer''s level'), + ('DOWNLOAD_PACK_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for download files'), + ('DOWNLOAD_SERVER_URI', 0, '$IP$/local', 'Server url used for group of server'), + ('DOWNLOAD_SERVER_DOCROOT', 0, 'd:\\\\tele_ocs', 'Server directory used for group of server'), + ('ENABLE_GROUPS', 1, '', 'Enable the computer''s groups feature'), + ('GENERATE_OCS_FILES', 0, '', 'Use with ocsinventory-injector, enable the multi entities feature'), + ('GUI_REPORT_AGIN_MACH', 30, '', 'Filter on lastdate for console page'), + ('GUI_REPORT_DD_MAX', 4000, '', 'Filter on Hard Drive for console page'), + ('GUI_REPORT_DD_MINI', 500, '', 'Filter on PROCESSOR for console page'), + ('GUI_REPORT_LAST_DIFF', 1, '', 'Difference between LASTDATE and LASTCOME'), + ('GUI_REPORT_NOT_VIEW', 3, '', 'Filter on DAY for console page'), + ('GUI_REPORT_PROC_MAX', 3000, '', 'Filter on PROCESSOR for console page'), + ('GUI_REPORT_PROC_MINI', 1000, '', 'Filter on Hard Drive for console page'), + ('GUI_REPORT_RAM_MAX', 512, '', 'Filter on RAM for console page'), + ('GUI_REPORT_RAM_MINI', 128, '', 'Filter on RAM for console page'), + ('GROUPS_CACHE_OFFSET', 43200, '', 'Random number computed in the defined range. Designed to avoid computing many groups in the same process'), + ('GROUPS_CACHE_REVALIDATE', 43200, '', 'Specify the validity of computer''s groups (default: compute it once a day - see offset)'), + ('IPDISCOVER_BETTER_THRESHOLD', 1, '', 'Specify the minimal difference to replace an ipdiscover agent'), + ('IPDISCOVER_IPD_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for Ipdiscover files'), + ('IPDISCOVER_NO_POSTPONE', 0, '', 'Disable the time before a first election (not recommended)'), + ('IPDISCOVER_USE_GROUPS', 1, '', 'Enable groups for ipdiscover (for example, you might want to prevent some groups'), + ('INVENTORY_CACHE_ENABLED', 1, '', 'Enable some stuff to improve DB queries, especially for GUI multicriteria searching system'), + ('INVENTORY_FILTER_ENABLED', 0, '', 'Enable core filter system to modify some things "on the fly"'), + ('INVENTORY_FILTER_FLOOD_IP', 0, '', 'Enable inventory flooding filter. A dedicated ipaddress ia allowed to send a new computer only once in this period'), + ('INVENTORY_FILTER_FLOOD_IP_CACHE_TIME', 300, '', 'Period definition for INVENTORY_FILTER_FLOOD_IP'), + ('INVENTORY_FILTER_ON', 0, '', 'Enable inventory filter stack'), + ('INVENTORY_WRITE_DIFF', 0, '', 'Configure engine to make a differential update of inventory sections (row level). Lower DB backend load, higher frontend load'), + ('LOCK_REUSE_TIME', 600, '', 'Validity of a computer''s lock'), + ('OCS_FILES_FORMAT', 0, 'OCS', 'Generate either compressed file or clear XML text'), + ('OCS_FILES_OVERWRITE', 0, '', 'Specify if you want to keep trace of all inventory between to synchronisation with the higher level server'), + ('OCS_FILES_PATH', 0, '/tmp', 'Path to ocs files directory (must be writeable)'), + ('PROLOG_FILTER_ON', 0, '', 'Enable prolog filter stack'), + ('SESSION_VALIDITY_TIME', 1, '', 'Validity of a session'); + + +-- Fill the caches +INSERT INTO `registry_name_cache` (`NAME`) SELECT DISTINCT `NAME` FROM `registry`; +INSERT INTO `registry_regvalue_cache` (`REGVALUE`) SELECT DISTINCT `REGVALUE` FROM `registry`; +INSERT INTO `hardware_osname_cache` (`OSNAME`) SELECT DISTINCT `OSNAME` FROM `hardware`; +INSERT INTO `softwares_name_cache` (`NAME`) SELECT DISTINCT `NAME` FROM `softwares`; + +-- +-- Drop useless +-- + +DROP TABLE IF EXISTS `dico_cat`; +DROP TABLE IF EXISTS `tag`; === added file 'debian/db/mysql' --- debian/db/mysql 1970-01-01 00:00:00 +0000 +++ debian/db/mysql 2009-05-20 10:21:06 +0000 @@ -0,0 +1,655 @@ +-- -*- sql -*- +USE ocsweb; + +-- +-- Create Schema +-- +CREATE TABLE `accesslog` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `USERID` VARCHAR(255) default NULL, + `LOGDATE` DATETIME default NULL, + `PROCESSES` TEXT, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`), + KEY `USERID` (`USERID`) +) ENGINE=INNODB ; + +CREATE TABLE `accountinfo` ( + `HARDWARE_ID` INTEGER NOT NULL, + `TAG` VARCHAR(255) default 'NA', + PRIMARY KEY (`HARDWARE_ID`), + KEY `TAG` (`TAG`) +) ENGINE=INNODB ; + +CREATE TABLE `bios` ( + `HARDWARE_ID` INTEGER NOT NULL, + `SMANUFACTURER` VARCHAR(255) default NULL, + `SMODEL` VARCHAR(255) default NULL, + `SSN` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + `BMANUFACTURER` VARCHAR(255) default NULL, + `BVERSION` VARCHAR(255) default NULL, + `BDATE` VARCHAR(255) default NULL, + PRIMARY KEY (`HARDWARE_ID`), + KEY `SSN` (`SSN`) +) ENGINE=INNODB ; + +CREATE TABLE `blacklist_macaddresses` ( + `ID` INTEGER auto_increment, + `MACADDRESS` VARCHAR(255), + PRIMARY KEY (`MACADDRESS`), + KEY `ID` (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `blacklist_serials` ( + `ID` INTEGER auto_increment, + `SERIAL` VARCHAR(255), + PRIMARY KEY (`SERIAL`), + KEY `ID` (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `config` ( + `NAME` VARCHAR(50) NOT NULL, + `IVALUE` INTEGER default NULL, + `TVALUE` VARCHAR(255) default NULL, + `COMMENTS` TEXT, + PRIMARY KEY (`NAME`) +) ENGINE=MYISAM ; + +CREATE TABLE `conntrack` ( + `IP` VARCHAR(255), + `TIMESTAMP` TIMESTAMP default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + PRIMARY KEY (`IP`) +) ENGINE = HEAP; + +CREATE TABLE `controllers` ( + `HARDWARE_ID` INTEGER NOT NULL, + `ID` INTEGER NOT NULL auto_increment, + `MANUFACTURER` VARCHAR(255) default NULL, + `NAME` VARCHAR(255) default NULL, + `CAPTION` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `VERSION` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `deleted_equiv` ( + `DATE` TIMESTAMP default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `DELETED` VARCHAR(255) NOT NULL, + `EQUIVALENT` VARCHAR(255) default NULL +) ENGINE=MYISAM ; + +CREATE TABLE `deploy` ( + `NAME` VARCHAR(255) NOT NULL, + `CONTENT` LONGBLOB NOT NULL, + PRIMARY KEY (`NAME`) +) ENGINE=MYISAM ; + +CREATE TABLE `devices` ( + `HARDWARE_ID` INTEGER NOT NULL, + `NAME` VARCHAR(50) NOT NULL, + `IVALUE` INTEGER default NULL, + `TVALUE` VARCHAR(255) default NULL, + `COMMENTS` TEXT, + KEY `HARDWARE_ID` (`HARDWARE_ID`), + KEY `TVALUE` (`TVALUE`), + KEY `IVALUE` (`IVALUE`), + KEY `NAME` (`NAME`) +) ENGINE=INNODB ; + +CREATE TABLE `devicetype` ( + `ID` INTEGER NOT NULL auto_increment, + `NAME` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`) +) ENGINE=MYISAM ; + +CREATE TABLE `dico_ignored` ( + `EXTRACTED` VARCHAR(255) NOT NULL, + PRIMARY KEY (`EXTRACTED`) +) ENGINE=MYISAM ; + +CREATE TABLE `dico_soft` ( + `EXTRACTED` VARCHAR(255) NOT NULL, + `FORMATTED` VARCHAR(255) NOT NULL, + PRIMARY KEY (`EXTRACTED`) +) ENGINE=MYISAM ; + +CREATE TABLE `download_affect_rules` ( + `ID` int(11) NOT NULL auto_increment, + `RULE` int(11) NOT NULL, + `PRIORITY` int(11) NOT NULL, + `CFIELD` varchar(20) collate latin1_general_ci NOT NULL, + `OP` varchar(20) collate latin1_general_ci NOT NULL, + `COMPTO` varchar(20) collate latin1_general_ci NOT NULL, + `SERV_VALUE` varchar(20) collate latin1_general_ci default NULL, + `RULE_NAME` varchar(200) collate latin1_general_ci NOT NULL, + PRIMARY KEY (`ID`) +) ENGINE=MyISAM; + +CREATE TABLE `download_available` ( + `FILEID` VARCHAR(255) NOT NULL, + `NAME` VARCHAR(255) NOT NULL, + `PRIORITY` INTEGER NOT NULL, + `FRAGMENTS` INTEGER NOT NULL, + `SIZE` INTEGER NOT NULL, + `OSNAME` VARCHAR(255) NOT NULL, + `COMMENT` TEXT, + PRIMARY KEY (`FILEID`) +) ENGINE = INNODB; + +CREATE TABLE `download_enable` ( + `ID` INTEGER NOT NULL auto_increment, + `FILEID` VARCHAR(255) NOT NULL, + `INFO_LOC` VARCHAR(255) NOT NULL, + `PACK_LOC` VARCHAR(255) NOT NULL, + `CERT_PATH` VARCHAR(255), + `CERT_FILE` VARCHAR(255), + `SERVER_ID` INTEGER, + `GROUP_ID` INTEGER, + PRIMARY KEY (`ID`), + KEY `FILEID` (`FILEID`) +) ENGINE = INNODB; + +CREATE TABLE `download_history` ( + `HARDWARE_ID` INTEGER NOT NULL, + `PKG_ID` INTEGER default NULL, + `PKG_NAME` VARCHAR(255), + PRIMARY KEY (`HARDWARE_ID`, `PKG_ID`) +) ENGINE = INNODB; + +CREATE TABLE `download_servers` ( + `HARDWARE_ID` int(11) NOT NULL, + `URL` varchar(250) collate latin1_general_ci NOT NULL, + `ADD_PORT` int(11) NOT NULL, + `ADD_REP` varchar(250) collate latin1_general_ci NOT NULL, + `GROUP_ID` int(11) NOT NULL, + PRIMARY KEY (`HARDWARE_ID`) +) ENGINE=MyISAM; + +CREATE TABLE `drives` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `LETTER` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + `FILESYSTEM` VARCHAR(255) default NULL, + `TOTAL` INTEGER default NULL, + `FREE` INTEGER default NULL, + `NUMFILES` INTEGER default NULL, + `VOLUMN` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `engine_mutex` ( + `NAME` varchar(255) NOT NULL default '', + `PID` int(11) default NULL, + `TAG` varchar(255) NOT NULL default '', + PRIMARY KEY (`NAME`, `TAG`) +) ENGINE=MEMORY DEFAULT CHARSET=latin1; + +CREATE TABLE `engine_persistent` ( + `ID` int(11) NOT NULL auto_increment, + `NAME` varchar(255) NOT NULL default '', + `IVALUE` int(11) default NULL, + `TVALUE` varchar(255) default NULL, + UNIQUE KEY `NAME` (`NAME`), + KEY `ID` (`ID`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; + +CREATE TABLE `files` ( + `NAME` VARCHAR(255) NOT NULL, + `VERSION` VARCHAR(255) NOT NULL, + `OS` VARCHAR(255) NOT NULL, + `CONTENT` LONGBLOB NOT NULL, + PRIMARY KEY (`NAME`, `OS`, `VERSION`) +) ENGINE=MYISAM ; + +CREATE TABLE `groups` ( + `HARDWARE_ID` integer default NULL, + `REQUEST` longtext, + `CREATE_TIME` INT default 0, + `REVALIDATE_FROM` INT default 0, + PRIMARY KEY (`HARDWARE_ID`) +) ENGINE=MYISAM; + +CREATE TABLE `groups_cache` ( + `HARDWARE_ID` integer NOT NULL default 0, + `GROUP_ID` integer NOT NULL default 0, + `STATIC` integer default 0, + PRIMARY KEY (`HARDWARE_ID`, `GROUP_ID`) +) ENGINE=MYISAM; + +CREATE TABLE `hardware` ( + `ID` INTEGER NOT NULL auto_increment, + `DEVICEID` VARCHAR(255) NOT NULL, + `NAME` VARCHAR(255) default NULL, + `WORKGROUP` VARCHAR(255) default NULL, + `USERDOMAIN` VARCHAR(255) default NULL, + `OSNAME` VARCHAR(255) default NULL, + `OSVERSION` VARCHAR(255) default NULL, + `OSCOMMENTS` VARCHAR(255) default NULL, + `PROCESSORT` VARCHAR(255) default NULL, + `PROCESSORS` INTEGER default 0, + `PROCESSORN` SMALLINT default NULL, + `MEMORY` INTEGER default NULL, + `SWAP` INTEGER default NULL, + `IPADDR` VARCHAR(255) default NULL, + `ETIME` DATETIME default NULL, + `LASTDATE` DATETIME default NULL, + `LASTCOME` DATETIME default NULL, + `QUALITY` DECIMAL(7,4) default 0, + `FIDELITY` BIGINT default 1, + `USERID` VARCHAR(255) default NULL, + `TYPE` INTEGER default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `WINCOMPANY` VARCHAR(255) default NULL, + `WINOWNER` VARCHAR(255) default NULL, + `WINPRODID` VARCHAR(255) default NULL, + `WINPRODKEY` VARCHAR(255) default NULL, + `USERAGENT` VARCHAR(50) default NULL, + `CHECKSUM` INTEGER default 131071, + `SSTATE` INTEGER default 0, + PRIMARY KEY (`DEVICEID`, `ID`), + KEY `ID` (`ID`), + KEY `DEVICEID` (`DEVICEID`), + KEY `NAME` (`NAME`), + KEY `CHECKSUM` (`CHECKSUM`), + KEY `USERID` (`USERID`), + KEY `WORKGROUP` (`WORKGROUP`), + KEY `OSNAME` (`OSNAME`), + KEY `MEMORY` (`MEMORY`) +) ENGINE=INNODB ; + +CREATE TABLE `hardware_osname_cache` ( + `ID` INTEGER auto_increment, + `OSNAME` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `inputs` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `TYPE` VARCHAR(255) default NULL, + `MANUFACTURER` VARCHAR(255) default NULL, + `CAPTION` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `INTERFACE` VARCHAR(255) default NULL, + `POINTTYPE` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `locks` ( + `HARDWARE_ID` INTEGER NOT NULL, + `ID` INTEGER DEFAULT NULL, + `SINCE` TIMESTAMP default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + PRIMARY KEY (`HARDWARE_ID`), + KEY `SINCE` (`SINCE`) +) ENGINE=HEAP ; + +CREATE TABLE `memories` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `CAPTION` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `CAPACITY` VARCHAR(255) default NULL, + `PURPOSE` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + `SPEED` VARCHAR(255) default NULL, + `NUMSLOTS` SMALLINT default NULL, + `SERIALNUMBER` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `modems` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `NAME` VARCHAR(255) default NULL, + `MODEL` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `monitors` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `MANUFACTURER` VARCHAR(255) default NULL, + `CAPTION` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + `SERIAL` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `netmap` ( + `IP` VARCHAR(15) NOT NULL, + `MAC` VARCHAR(17) NOT NULL, + `MASK` VARCHAR(15) NOT NULL, + `NETID` VARCHAR(15) NOT NULL, + `DATE` TIMESTAMP NOT NULL default CURRENT_TIMESTAMP, + `NAME` VARCHAR(255) default NULL, + PRIMARY KEY (`MAC`), + KEY `IP` (`IP`), + KEY `NETID` (`NETID`) +) ENGINE=INNODB ; + +CREATE TABLE `networks` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + `TYPEMIB` VARCHAR(255) default NULL, + `SPEED` VARCHAR(255) default NULL, + `MACADDR` VARCHAR(255) default NULL, + `STATUS` VARCHAR(255) default NULL, + `IPADDRESS` VARCHAR(255) default NULL, + `IPMASK` VARCHAR(255) default NULL, + `IPGATEWAY` VARCHAR(255) default NULL, + `IPSUBNET` VARCHAR(255) default NULL, + `IPDHCP` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`), + KEY `MACADDR` (`MACADDR`), + KEY `IPADDRESS` (`IPADDRESS`), + KEY `IPGATEWAY` (`IPGATEWAY`), + KEY `IPSUBNET` (`IPSUBNET`) +) ENGINE=INNODB ; + +CREATE TABLE `network_devices` ( + `ID` INTEGER NOT NULL auto_increment, + `DESCRIPTION` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + `MACADDR` VARCHAR(255) default NULL, + `USER` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`), + KEY `MACADDR` (`MACADDR`) +) ENGINE=MYISAM ; + +CREATE TABLE `operators` ( + `ID` VARCHAR(255) NOT NULL default '', + `FIRSTNAME` VARCHAR(255) default NULL, + `LASTNAME` VARCHAR(255) default NULL, + `PASSWD` VARCHAR(50) default NULL, + `ACCESSLVL` INTEGER default NULL, + `COMMENTS` text, + PRIMARY KEY (`ID`) +) ENGINE=MYISAM ; + +CREATE TABLE `ports` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `TYPE` VARCHAR(255) default NULL, + `NAME` VARCHAR(255) default NULL, + `CAPTION` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `printers` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `NAME` VARCHAR(255) default NULL, + `DRIVER` VARCHAR(255) default NULL, + `PORT` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `prolog_conntrack` ( + `ID` int(11) NOT NULL auto_increment, + `DEVICEID` varchar(255) default NULL, + `TIMESTAMP` int(11) default NULL, + `PID` int(11) default NULL, + KEY `ID` (`ID`), + KEY `DEVICEID` (`DEVICEID`) +) ENGINE=MEMORY; + +CREATE TABLE `regconfig` ( + `ID` INTEGER NOT NULL auto_increment, + `NAME` VARCHAR(255) default NULL, + `REGTREE` INTEGER default NULL, + `REGKEY` text, + `REGVALUE` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`), + KEY `NAME` (`NAME`) +) ENGINE=MYISAM ; + +CREATE TABLE `registry` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `NAME` VARCHAR(255) default NULL, + `REGVALUE` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`), + KEY `NAME` (`NAME`) +) ENGINE=INNODB ; + +CREATE TABLE `registry_name_cache` ( + `ID` INTEGER auto_increment, + `NAME` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `registry_regvalue_cache` ( + `ID` INTEGER auto_increment, + `REGVALUE` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `slots` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `NAME` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `DESIGNATION` VARCHAR(255) default NULL, + `PURPOSE` VARCHAR(255) default NULL, + `STATUS` VARCHAR(255) default NULL, + `PSHARE` tinyint(4) default NULL, + PRIMARY KEY (`HARDWARE_ID`, `ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `softwares` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `PUBLISHER` VARCHAR(255) default NULL, + `NAME` VARCHAR(255) default NULL, + `VERSION` VARCHAR(255) default NULL, + `FOLDER` text, + `COMMENTS` text, + `FILENAME` VARCHAR(255) default NULL, + `FILESIZE` INTEGER default '0', + `SOURCE` INTEGER default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`), + KEY `NAME` (`NAME`), + KEY `VERSION` (`VERSION`) +) ENGINE=INNODB ; + +CREATE TABLE `softwares_name_cache` ( + `ID` INTEGER auto_increment, + `NAME` VARCHAR(255) UNIQUE, + PRIMARY KEY (`ID`) +) ENGINE = MYISAM; + +CREATE TABLE `sounds` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `MANUFACTURER` VARCHAR(255) default NULL, + `NAME` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `storages` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `MANUFACTURER` VARCHAR(255) default NULL, + `NAME` VARCHAR(255) default NULL, + `MODEL` VARCHAR(255) default NULL, + `DESCRIPTION` VARCHAR(255) default NULL, + `TYPE` VARCHAR(255) default NULL, + `DISKSIZE` INTEGER default NULL, + `SERIALNUMBER` VARCHAR(255) default NULL, + `FIRMWARE` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + +CREATE TABLE `subnet` ( + `NETID` VARCHAR(15) NOT NULL, + `NAME` VARCHAR(255), + `ID` INTEGER, + `MASK` VARCHAR(255), + PRIMARY KEY (`NETID`), + KEY `ID` (`ID`) +) ENGINE=MYISAM ; + +CREATE TABLE `tags` ( + `Tag` VARCHAR(255) NOT NULL default '', + `Login` VARCHAR(255) NOT NULL default '', + PRIMARY KEY (`Tag`, `Login`), + KEY `Tag` (`Tag`), + KEY `Login` (`Login`) +) ENGINE=MyISAM; + +CREATE TABLE `videos` ( + `ID` INTEGER NOT NULL auto_increment, + `HARDWARE_ID` INTEGER NOT NULL, + `NAME` VARCHAR(255) default NULL, + `CHIPSET` VARCHAR(255) default NULL, + `MEMORY` VARCHAR(255) default NULL, + `RESOLUTION` VARCHAR(255) default NULL, + PRIMARY KEY (`ID`, `HARDWARE_ID`), + KEY `ID` (`ID`) +) ENGINE=INNODB ; + + +-- +-- Insert default values +-- + +-- administrator +INSERT INTO `operators` (`ID`, `FIRSTNAME`, `LASTNAME`, `PASSWD`, `ACCESSLVL`, `COMMENTS`) VALUES + ('admin', 'admin', 'admin', 'admin', 1, 'Default administrator account'); + +-- configuration +INSERT INTO `config` (`NAME`, `IVALUE`, `TVALUE`, `COMMENTS`) VALUES + ('AUTO_DUPLICATE_LVL', 7, '', 'Duplicates bitmap'), + ('DEPLOY', 1, '', 'Activates or not the automatic deployment option'), + ('DOWNLOAD', 0, '', 'Activate softwares auto deployment feature'), + ('DOWNLOAD_CYCLE_LATENCY', 60, '', 'Time between two cycles (seconds)'), + ('DOWNLOAD_PERIOD_LENGTH', 10, '', 'Number of cycles in a period'), + ('DOWNLOAD_FRAG_LATENCY', 10, '', 'Time between two downloads (seconds)'), + ('DOWNLOAD_GROUPS_TRACE_EVENTS', 1, '', 'Specify if you want to track packages affected to a group on computer''s level'), + ('DOWNLOAD_PACK_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for download files'), + ('DOWNLOAD_PERIOD_LATENCY', 0, '', 'Time between two periods (seconds)'), + ('DOWNLOAD_SERVER_URI', 0, '$IP$/local', 'Server url used for group of server'), + ('DOWNLOAD_SERVER_DOCROOT', 0, 'd:\\\\tele_ocs', 'Server directory used for group of server'), + ('DOWNLOAD_TIMEOUT', 30, '', 'Validity of a package (in days)'), + ('ENABLE_GROUPS', 1, '', 'Enable the computer''s groups feature'), + ('FREQUENCY', 0, '', 'Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'), + ('GENERATE_OCS_FILES', 0, '', 'Use with ocsinventory-injector, enable the multi entities feature'), + ('GUI_REPORT_AGIN_MACH', 30, '', 'Filter on lastdate for console page'), + ('GUI_REPORT_DD_MAX', 4000, '', 'Filter on Hard Drive for console page'), + ('GUI_REPORT_DD_MINI', 500, '', 'Filter on PROCESSOR for console page'), + ('GUI_REPORT_LAST_DIFF', 1, '', 'Difference between LASTDATE and LASTCOME'), + ('GUI_REPORT_NOT_VIEW', 3, '', 'Filter on DAY for console page'), + ('GUI_REPORT_PROC_MAX', 3000, '', 'Filter on PROCESSOR for console page'), + ('GUI_REPORT_PROC_MINI', 1000, '', 'Filter on Hard Drive for console page'), + ('GUI_REPORT_RAM_MAX', 512, '', 'Filter on RAM for console page'), + ('GUI_REPORT_RAM_MINI', 128, '', 'Filter on RAM for console page'), + ('GUI_VERSION', 0, '5003', 'Version of the installed GUI and database'), + ('GROUPS_CACHE_OFFSET', 43200, '', 'Random number computed in the defined range. Designed to avoid computing many groups in the same process'), + ('GROUPS_CACHE_REVALIDATE', 43200, '', 'Specify the validity of computer''s groups (default: compute it once a day - see offset)'), + ('IPDISCOVER', 2, '', 'Max number of computers per gateway retrieving IP on the network'), + ('IPDISCOVER_BETTER_THRESHOLD', 1, '', 'Specify the minimal difference to replace an ipdiscover agent'), + ('IPDISCOVER_IPD_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for Ipdiscover files'), + ('IPDISCOVER_LATENCY', 100, '', 'Default latency between two arp requests'), + ('IPDISCOVER_MAX_ALIVE', 7, '', 'Max number of days before an Ip Discover computer is replaced'), + ('IPDISCOVER_NO_POSTPONE', 0, '', 'Disable the time before a first election (not recommended)'), + ('IPDISCOVER_USE_GROUPS', 1, '', 'Enable groups for ipdiscover (for example, you might want to prevent some groups'), + ('INVENTORY_CACHE_ENABLED', 1, '', 'Enable some stuff to improve DB queries, especially for GUI multicriteria searching system'), + ('INVENTORY_DIFF', 1, '', 'Activate/Deactivate inventory incremental writing'), + ('INVENTORY_FILTER_ENABLED', 0, '', 'Enable core filter system to modify some things "on the fly"'), + ('INVENTORY_FILTER_FLOOD_IP', 0, '', 'Enable inventory flooding filter. A dedicated ipaddress ia allowed to send a new computer only once in this period'), + ('INVENTORY_FILTER_FLOOD_IP_CACHE_TIME', 300, '', 'Period definition for INVENTORY_FILTER_FLOOD_IP'), + ('INVENTORY_FILTER_ON', 0, '', 'Enable inventory filter stack'), + ('INVENTORY_TRANSACTION', 1, '', 'Enable/disable db commit at each inventory section'), + ('INVENTORY_WRITE_DIFF', 0, '', 'Configure engine to make a differential update of inventory sections (row level). Lower DB backend load, higher frontend load'), + ('LOCAL_SERVER', 0, 'localhost', 'Server address used for local import'), + ('LOCAL_PORT', 80, '', 'Server port used for local import'), + ('LOCK_REUSE_TIME', 600, '', 'Validity of a computer''s lock'), + ('LOGLEVEL', 0, '', 'ocs engine loglevel'), + ('OCS_FILES_FORMAT', 0, 'OCS', 'Generate either compressed file or clear XML text'), + ('OCS_FILES_OVERWRITE', 0, '', 'Specify if you want to keep trace of all inventory between to synchronisation with the higher level server'), + ('OCS_FILES_PATH', 0, '/tmp', 'Path to ocs files directory (must be writeable)'), + ('PROLOG_FILTER_ON', 0, '', 'Enable prolog filter stack'), + ('PROLOG_FREQ', 24, '', 'Specify the frequency (hours) of prolog, on agents'), + ('REGISTRY', 0, '', 'Activates or not the registry query function'), + ('SESSION_VALIDITY_TIME', 1, '', 'Validity of a session'), + ('TRACE_DELETED', 0, '', 'Trace deleted/duplicated computers (Activated by GLPI)'), + ('UPDATE', 0, '', 'Activates or not the update feature'); + +-- blacklisted macaddresses +INSERT INTO `blacklist_macaddresses` (`MACADDRESS`) VALUES + ('00:00:00:00:00:00'), + ('FF:FF:FF:FF:FF:FF'), + ('44:45:53:54:00:00'), + ('44:45:53:54:00:01'), + ('00:01:02:7D:9B:1C'), + ('00:08:A1:46:06:35'), + ('00:08:A1:66:E2:1A'), + ('00:09:DD:10:37:68'), + ('00:0F:EA:9A:E2:F0'), + ('00:10:5A:72:71:F3'), + ('00:11:11:85:08:8B'), + ('10:11:11:11:11:11'), + ('44:45:53:54:61:6F'), + (''); + +-- blacklisted serials +INSERT INTO `blacklist_serials` (`SERIAL`) VALUES + ('N/A'), + ('(null string)'), + ('INVALID'), + ('SYS-1234567890'), + ('SYS-9876543210'), + ('SN-12345'), + ('SN-1234567890'), + ('1111111111'), + ('1111111'), + ('1'), + ('0123456789'), + ('12345'), + ('123456'), + ('1234567'), + ('12345678'), + ('123456789'), + ('1234567890'), + ('123456789000'), + ('12345678901234567'), + ('0000000000'), + ('000000000'), + ('00000000'), + ('0000000'), + ('000000'), + ('NNNNNNN'), + ('xxxxxxxxxxx'), + ('EVAL'), + ('IATPASS'), + ('none'), + ('To Be Filled By O.E.M.'), + ('Tulip Computers'), + ('Serial Number xxxxxx'), + ('SN-123456fvgv3i0b8o5n6n7k'), + (''); === modified file 'debian/ocsinventory-server.install' --- debian/ocsinventory-server.install 2009-05-19 05:39:42 +0000 +++ debian/ocsinventory-server.install 2009-05-20 09:17:00 +0000 @@ -1,1 +1,3 @@ debian/conf/ocsinventory.conf usr/share/ocsinventory-server/files +debian/db/mysql usr/share/dbconfig-common/data/ocsinventory-server/install +debian/db/1.02 usr/share/dbconfig-common/data/ocsinventory-server/upgrade/mysql/
pgpXpyFXvRpTc.pgp
Description: PGP signature