OCS NG

lucassimionato
(usa Slackware)

Enviado em 05/11/2009 - 13:31h

Pessoal, terminei a instalação do OCS NG no slackware 12.2 mas quando eu vo fazer a criação da tabela no mysql está me dando o seguinte erro

OCS Inventory Installation

NOTICE: You will not be able to build any deployment package with size greater than 5000 M.
You must raise both post_max_size and upload_max_filesize in your php.ini to encrease this limit.

Please wait, database update may take up to 30 minutes....
ERROR: line 5: query:[ CREATE TABLE accountinfo ( HARDWARE_ID INTEGER NOT NULL, TAG VARCHAR(255) default ''NA'', primary key(HARDWARE_ID), INDEX TAG (TAG) ) ENGINE=INNODB ] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NA'', primary key(HARDWARE_ID), INDEX TAG (TAG) ) ENGINE=INNODB' at line 3 (err:1064)
.
ERROR: line 26: query:[ 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), INDEX NAME (NAME), INDEX `VERSION`(`VERSION`) ) ENGINE=INNODB ] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0'', SOURCE INTEGER default NULL, PRIMARY KEY (ID, HARDWARE_ID), INDEX' at line 10 (err:1064)
........
ERROR: line 55: query:[ INSERT INTO softwares_name_cache(name) SELECT DISTINCT name FROM softwares] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
........
ERROR: line 86: query:[ ALTER TABLE accountinfo DROP PRIMARY KEY] failed
mysql error: Table 'ocsweb.accountinfo' doesn't exist (err:1146)
.
ERROR: line 87: query:[ ALTER TABLE accountinfo ADD COLUMN HARDWARE_ID integer not NULL FIRST] failed
mysql error: Table 'ocsweb.accountinfo' doesn't exist (err:1146)
.
ERROR: line 88: query:[ UPDATE accountinfo SET accountinfo.HARDWARE_ID= (SELECT ID FROM hardware WHERE accountinfo.DEVICEID = hardware.DEVICEID)] failed
mysql error: Table 'ocsweb.accountinfo' doesn't exist (err:1146)
.
ERROR: line 89: query:[ ALTER TABLE accountinfo DROP DEVICEID] failed
mysql error: Table 'ocsweb.accountinfo' doesn't exist (err:1146)
.
ERROR: line 90: query:[ ALTER TABLE accountinfo ADD PRIMARY KEY(HARDWARE_ID)] failed
mysql error: Table 'ocsweb.accountinfo' doesn't exist (err:1146)
.....................................
ERROR: line 173: query:[ ALTER TABLE softwares change ID ID INTEGER] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: line 174: query:[ ALTER TABLE softwares DROP PRIMARY KEY] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: line 175: query:[ ALTER TABLE softwares ADD COLUMN HARDWARE_ID integer not NULL FIRST] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: line 176: query:[ UPDATE softwares SET softwares.HARDWARE_ID= (SELECT ID FROM hardware WHERE softwares.DEVICEID = hardware.DEVICEID)] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: line 177: query:[ ALTER TABLE softwares ADD INDEX ID (ID)] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: line 178: query:[ ALTER TABLE softwares change ID ID INTEGER auto_increment] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: line 179: query:[ ALTER TABLE softwares ADD PRIMARY KEY(HARDWARE_ID,ID)] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: line 180: query:[ ALTER TABLE softwares DROP DEVICEID] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
...........................
ERROR: line 231: query:[ ALTER TABLE softwares CHANGE NAME NAME VARCHAR(255) default NULL] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
..
ERROR: line 244: query:[ ALTER TABLE softwares ADD INDEX `VERSION`(`VERSION`)] failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
......
ERROR: line 251: query:[ DELETE FROM config WHERE name=''GUI_VERSION''] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_VERSION''' at line 1 (err:1064)
.
ERROR: line 252: query:[ DELETE FROM config WHERE name=''IP_MIN_QUALITY''] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IP_MIN_QUALITY''' at line 1 (err:1064)
.
ERROR: line 253: query:[ INSERT INTO config VALUES (''FREQUENCY'', 0, '''', ''Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FREQUENCY'', 0, '''', ''Specify the frequency (days) of inventories. (0: invento' at line 1 (err:1064)
.
ERROR: line 254: query:[ INSERT INTO config VALUES (''PROLOG_FREQ'', 24, '''', ''Specify the frequency (hours) of prolog, on agents'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROLOG_FREQ'', 24, '''', ''Specify the frequency (hours) of prolog, on agents'')' at line 1 (err:1064)
.
ERROR: line 255: query:[ INSERT INTO config VALUES (''IPDISCOVER'', 2, '''', ''Max number of computers per gateway retrieving IP on the network'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IPDISCOVER'', 2, '''', ''Max number of computers per gateway retrieving IP on th' at line 1 (err:1064)
.
ERROR: line 256: query:[ INSERT INTO config VALUES (''INVENTORY_DIFF'', 1, '''', ''Activate/Deactivate inventory incremental writing'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_DIFF'', 1, '''', ''Activate/Deactivate inventory incremental writing''' at line 1 (err:1064)
.
ERROR: line 257: query:[ INSERT INTO config VALUES (''IPDISCOVER_LATENCY'', 100, '''', ''Default latency between two arp requests'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IPDISCOVER_LATENCY'', 100, '''', ''Default latency between two arp requests'')' at line 1 (err:1064)
.
ERROR: line 258: query:[ INSERT INTO config VALUES (''INVENTORY_TRANSACTION'', 1, '''', ''Enable/disable db commit at each inventory section'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_TRANSACTION'', 1, '''', ''Enable/disable db commit at each inventory s' at line 1 (err:1064)
.
ERROR: line 259: query:[ INSERT INTO config VALUES (''REGISTRY'', 0, '''', ''Activates or not the registry query function'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REGISTRY'', 0, '''', ''Activates or not the registry query function'')' at line 1 (err:1064)
.
ERROR: line 260: query:[ INSERT INTO config VALUES (''IPDISCOVER_MAX_ALIVE'', 7, '''',''Max number of days before an Ip Discover computer is replaced'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IPDISCOVER_MAX_ALIVE'', 7, '''',''Max number of days before an Ip Discover compu' at line 1 (err:1064)
.
ERROR: line 261: query:[ INSERT INTO config VALUES (''DEPLOY'', 1, '''', ''Activates or not the automatic deployment option'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEPLOY'', 1, '''', ''Activates or not the automatic deployment option'')' at line 1 (err:1064)
.
ERROR: line 262: query:[ INSERT INTO config VALUES (''UPDATE'', 0, '''', ''Activates or not the update feature'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE'', 0, '''', ''Activates or not the update feature'')' at line 1 (err:1064)
.
ERROR: line 263: query:[ INSERT INTO config VALUES (''TRACE_DELETED'', 0, '''', ''Trace deleted/duplicated computers (Activated by GLPI)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRACE_DELETED'', 0, '''', ''Trace deleted/duplicated computers (Activated by GLP' at line 1 (err:1064)
.
ERROR: line 264: query:[ INSERT INTO config VALUES (''LOGLEVEL'', 0, '''', ''ocs engine loglevel'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOGLEVEL'', 0, '''', ''ocs engine loglevel'')' at line 1 (err:1064)
.
ERROR: line 265: query:[ INSERT INTO config VALUES (''AUTO_DUPLICATE_LVL'', 7, '''', ''Duplicates bitmap'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTO_DUPLICATE_LVL'', 7, '''', ''Duplicates bitmap'')' at line 1 (err:1064)
.
ERROR: line 266: query:[ INSERT INTO config VALUES (''DOWNLOAD'', 0, '''', ''Activate softwares auto deployment feature'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD'', 0, '''', ''Activate softwares auto deployment feature'')' at line 1 (err:1064)
.
ERROR: line 267: query:[ INSERT INTO config VALUES (''DOWNLOAD_CYCLE_LATENCY'', 60, '''', ''Time between two cycles (seconds)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_CYCLE_LATENCY'', 60, '''', ''Time between two cycles (seconds)'')' at line 1 (err:1064)
.
ERROR: line 268: query:[ INSERT INTO config VALUES (''DOWNLOAD_PERIOD_LENGTH'', 10, '''', ''Number of cycles in a period'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_PERIOD_LENGTH'', 10, '''', ''Number of cycles in a period'')' at line 1 (err:1064)
.
ERROR: line 269: query:[ INSERT INTO config VALUES (''DOWNLOAD_FRAG_LATENCY'', 10, '''', ''Time between two downloads (seconds)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_FRAG_LATENCY'', 10, '''', ''Time between two downloads (seconds)'')' at line 1 (err:1064)
.
ERROR: line 270: query:[ INSERT INTO config VALUES (''DOWNLOAD_PERIOD_LATENCY'', 0, '''', ''Time between two periods (seconds)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_PERIOD_LATENCY'', 0, '''', ''Time between two periods (seconds)'')' at line 1 (err:1064)
.
ERROR: line 271: query:[ INSERT INTO config VALUES (''DOWNLOAD_TIMEOUT'', 30, '''', ''Validity of a package (in days)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_TIMEOUT'', 30, '''', ''Validity of a package (in days)'')' at line 1 (err:1064)
.
ERROR: line 272: query:[ INSERT INTO config VALUES (''LOCAL_SERVER'', 0, ''localhost'', ''Server address used for local import'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCAL_SERVER'', 0, ''localhost'', ''Server address used for local import'')' at line 1 (err:1064)
.
ERROR: line 273: query:[ INSERT INTO config VALUES (''LOCAL_PORT'', 80, '''', ''Server port used for local import'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCAL_PORT'', 80, '''', ''Server port used for local import'')' at line 1 (err:1064)
.
ERROR: line 274: query:[ INSERT INTO config VALUES (''DOWNLOAD_PACK_DIR'','''',''/var/lib/ocsinventory-reports'',''Directory for download files'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_PACK_DIR'','''',''/var/lib/ocsinventory-reports'',''Directory for downl' at line 1 (err:1064)
.
ERROR: line 275: query:[ INSERT INTO config VALUES (''IPDISCOVER_IPD_DIR'','''',''/var/lib/ocsinventory-reports'',''Directory for Ipdiscover files'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IPDISCOVER_IPD_DIR'','''',''/var/lib/ocsinventory-reports'',''Directory for Ipdi' at line 1 (err:1064)
.
ERROR: line 276: query:[ 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''),('''')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N/A''),(''(null string)''),(''INVALID''),(''SYS-1234567890''),(''SYS-9876543210'' at line 1 (err:1064)
.
ERROR: line 277: query:[ 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''),('''')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00:00:00:00''),(''FF:FF:FF:FF:FF:FF''),(''44:45:53:54:00:00''),(''44:45:53' at line 1 (err:1064)
.
ERROR: line 278: query:[ INSERT INTO operators VALUES (''admin'',''admin'',''admin'',''admin'',1, ''Default administrator account'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'admin'',''admin'',''admin'',''admin'',1, ''Default administrator account'')' at line 1 (err:1064)
.
ERROR: line 279: query:[ GRANT ALL PRIVILEGES ON ocsweb.* TO ocs IDENTIFIED BY ''ocs''] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ocs''' at line 1 (err:1064)
.
ERROR: line 280: query:[ GRANT ALL PRIVILEGES ON ocsweb.* TO ocs@localhost IDENTIFIED BY ''ocs''] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ocs''' at line 1 (err:1064)
.
ERROR: line 281: query:[ INSERT INTO config VALUES (''GUI_VERSION'', 0, ''5003'', ''Version of the installed GUI and database'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_VERSION'', 0, ''5003'', ''Version of the installed GUI and database'')' at line 1 (err:1064)
.
ERROR: line 284: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''DOWNLOAD_SERVER_URI'','''',''$IP$/local'',''Server url used for group of server'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_SERVER_URI'','''',''$IP$/local'',''Server url used for group of server'' at line 1 (err:1064)
.
ERROR: line 285: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''DOWNLOAD_SERVER_DOCROOT'','''',''d:\\\\tele_ocs'',''Server directory used for group of server'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_SERVER_DOCROOT'','''',''d:\\\\tele_ocs'',''Server directory used for gr' at line 1 (err:1064)
.
ERROR: line 286: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''LOCK_REUSE_TIME'',600,'''',''Validity of a computer\''s lock'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCK_REUSE_TIME'',600,'''',''Validity of a computer\''s lock'')' at line 1 (err:1064)
.
ERROR: line 287: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_DIFF'',1,'''',''Configure engine to update inventory regarding to CHECKSUM agent value (lower DB backend load)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_DIFF'',1,'''',''Configure engine to update inventory regarding to CHEC' at line 1 (err:1064)
.
ERROR: line 288: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_TRANSACTION'',1,'''',''Make engine consider an inventory as a transaction (lower concurency, better disk usage)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_TRANSACTION'',1,'''',''Make engine consider an inventory as a transact' at line 1 (err:1064)
.
ERROR: line 289: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_WRITE_DIFF'',0,'''',''Configure engine to make a differential update of inventory sections (row level). Lower DB backend load, higher frontend load'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_WRITE_DIFF'',0,'''',''Configure engine to make a differential update o' at line 1 (err:1064)
.
ERROR: line 290: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_CACHE_ENABLED'',1,'''',''Enable some stuff to improve DB queries, especially for GUI multicriteria searching system'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_CACHE_ENABLED'',1,'''',''Enable some stuff to improve DB queries, espe' at line 1 (err:1064)
.
ERROR: line 291: query:[ 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'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOWNLOAD_GROUPS_TRACE_EVENTS'',1,'''',''Specify if you want to track packages af' at line 1 (err:1064)
.
ERROR: line 292: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''ENABLE_GROUPS'',1,'''',''Enable the computer\''s groups feature'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENABLE_GROUPS'',1,'''',''Enable the computer\''s groups feature'')' at line 1 (err:1064)
.
ERROR: line 293: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GROUPS_CACHE_OFFSET'',43200,'''',''Random number computed in the defined range. Designed to avoid computing many groups in the same process'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUPS_CACHE_OFFSET'',43200,'''',''Random number computed in the defined range. ' at line 1 (err:1064)
.
ERROR: line 294: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GROUPS_CACHE_REVALIDATE'',43200,'''',''Specify the validity of computer\''s groups (default: compute it once a day - see offset)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUPS_CACHE_REVALIDATE'',43200,'''',''Specify the validity of computer\''s grou' at line 1 (err:1064)
.
ERROR: line 295: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''IPDISCOVER_BETTER_THRESHOLD'',1,'''',''Specify the minimal difference to replace an ipdiscover agent'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IPDISCOVER_BETTER_THRESHOLD'',1,'''',''Specify the minimal difference to replace' at line 1 (err:1064)
.
ERROR: line 296: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''IPDISCOVER_NO_POSTPONE'',0,'''',''Disable the time before a first election (not recommended)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IPDISCOVER_NO_POSTPONE'',0,'''',''Disable the time before a first election (not ' at line 1 (err:1064)
.
ERROR: line 297: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''IPDISCOVER_USE_GROUPS'',1,'''',''Enable groups for ipdiscover (for example, you might want to prevent some groups'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IPDISCOVER_USE_GROUPS'',1,'''',''Enable groups for ipdiscover (for example, you ' at line 1 (err:1064)
.
ERROR: line 298: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GENERATE_OCS_FILES'',0,'''',''Use with ocsinventory-injector, enable the multi entities feature'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GENERATE_OCS_FILES'',0,'''',''Use with ocsinventory-injector, enable the multi e' at line 1 (err:1064)
.
ERROR: line 299: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''OCS_FILES_FORMAT'','''',''OCS'',''Generate either compressed file or clear XML text'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OCS_FILES_FORMAT'','''',''OCS'',''Generate either compressed file or clear XML t' at line 1 (err:1064)
.
ERROR: line 300: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''OCS_FILES_OVERWRITE'',0,'''',''Specify if you want to keep trace of all inventory between to synchronisation with the higher level server'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OCS_FILES_OVERWRITE'',0,'''',''Specify if you want to keep trace of all inventor' at line 1 (err:1064)
.
ERROR: line 301: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''OCS_FILES_PATH'','''',''/tmp'',''Path to ocs files directory (must be writeable)'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OCS_FILES_PATH'','''',''/tmp'',''Path to ocs files directory (must be writeable)' at line 1 (err:1064)
.
ERROR: line 302: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''PROLOG_FILTER_ON'',0,'''',''Enable prolog filter stack'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROLOG_FILTER_ON'',0,'''',''Enable prolog filter stack'')' at line 1 (err:1064)
.
ERROR: line 303: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_FILTER_ENABLED'',0,'''',''Enable core filter system to modify some things "on the fly"'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_FILTER_ENABLED'',0,'''',''Enable core filter system to modify some thi' at line 1 (err:1064)
.
ERROR: line 304: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_FILTER_FLOOD_IP'',0,'''',''Enable inventory flooding filter. A dedicated ipaddress ia allowed to send a new computer only once in this period'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_FILTER_FLOOD_IP'',0,'''',''Enable inventory flooding filter. A dedicat' at line 1 (err:1064)
.
ERROR: line 305: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_FILTER_FLOOD_IP_CACHE_TIME'',300,'''',''Period definition for INVENTORY_FILTER_FLOOD_IP'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_FILTER_FLOOD_IP_CACHE_TIME'',300,'''',''Period definition for INVENTOR' at line 1 (err:1064)
.
ERROR: line 306: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''INVENTORY_FILTER_ON'',0,'''',''Enable inventory filter stack'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVENTORY_FILTER_ON'',0,'''',''Enable inventory filter stack'')' at line 1 (err:1064)
.
ERROR: line 307: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_RAM_MAX'',512,'''',''Filter on RAM for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_RAM_MAX'',512,'''',''Filter on RAM for console page'')' at line 1 (err:1064)
.
ERROR: line 308: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_RAM_MINI'',128,'''',''Filter on RAM for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_RAM_MINI'',128,'''',''Filter on RAM for console page'')' at line 1 (err:1064)
.
ERROR: line 309: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_NOT_VIEW'',3,'''',''Filter on DAY for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_NOT_VIEW'',3,'''',''Filter on DAY for console page'')' at line 1 (err:1064)
.
ERROR: line 310: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_PROC_MINI'',1000,'''',''Filter on Hard Drive for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_PROC_MINI'',1000,'''',''Filter on Hard Drive for console page'')' at line 1 (err:1064)
.
ERROR: line 311: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_DD_MAX'',4000,'''',''Filter on Hard Drive for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_DD_MAX'',4000,'''',''Filter on Hard Drive for console page'')' at line 1 (err:1064)
.
ERROR: line 312: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_PROC_MAX'',3000,'''',''Filter on PROCESSOR for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_PROC_MAX'',3000,'''',''Filter on PROCESSOR for console page'')' at line 1 (err:1064)
.
ERROR: line 313: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_DD_MINI'',500,'''',''Filter on PROCESSOR for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_DD_MINI'',500,'''',''Filter on PROCESSOR for console page'')' at line 1 (err:1064)
.
ERROR: line 314: query:[ insert into config (NAME,IVALUE,TVALUE,COMMENTS) values (''GUI_REPORT_AGIN_MACH'',30,'''',''Filter on lastdate for console page'')] failed
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUI_REPORT_AGIN_MACH'',30,'''',''Filter on lastdate for console page'')' at line 1 (err:1064)
.

MySql config file successfully written (using new ocs account)

Existing database updated

Database engine checking....................

ERROR: Alter query failed
mysql error: Table 'ocsweb.softwares' doesn't exist (err:1146)
.
ERROR: Alter query failed
mysql error: Table 'ocsweb.accountinfo' doesn't exist (err:1146)
...

ERROR: InnoDB conversion failed, install InnoDB mysql engine support on your server
or you will experience severe performance issues.
(Try to uncomment "#skip-innodb" in your mysql config file.)
Reinstall when corrected.


ERROR: HEAP conversion failed, install HEAP mysql engine support on your server
or you will experience severe performance issues.

ERROR: The installer ended unsuccessfully, rerun install.php once problems are corrected

Alguem pode me dar uma luz??

Obrigado