MySql Database Table Creation Errors
I have OpManager 6 installed on a Fedora Core 6 machine. When trying to start the server, by being in the bin directory and issuing ./StartOpManagerServer.sh I get several mysql table creation errors, which appear to be due to the names of the tables. Here are the errors that I am getting:
Exception in creating table
Statement being executed was :create table PollingAttributes( NAME varchar(50), TYPE varchar(10), PROPERTY varchar(20), CONDITION varchar(50), VALUE varchar(100))
syntax error or access violation, message from server: "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 'condition varchar(50), value varchar(100))' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'CONDITION varchar(50), VALUE varchar(100))' at line 1"
Exception in creating table
Statement being executed was :create table TableSpaceStatus ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, TABLESPACENAME VARCHAR(25), STATUS VARCHAR(50), FREEBYTES INTEGER, FREEBLOCKS INTEGER, READS INTEGER, WRITES INTEGER, READTIME BIGINT, WRITETIME BIGINT, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "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 'reads integer, writes integer, readtime bigint, writetime bigint, collec' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'READS INTEGER, WRITES INTEGER, READTIME BIGINT, WRITETIME BIGINT, COLLEC' at line 1"
Exception in creating table
Statement being executed was :create table InstanceStatus ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, DBSIZE BIGINT, AVGEXECS INTEGER, AVGUSERS INTEGER, READS INTEGER, WRITES INTEGER, BLOCKSIZE INTEGER, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "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 'reads integer, writes integer, blocksize integer, collectiontime bigint)' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'READS INTEGER, WRITES INTEGER, BLOCKSIZE INTEGER, COLLECTIONTIME BIGINT)' at line 1"
Exception in creating table
Statement being executed was :create table DataFiles ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, FILE_NAME VARCHAR(100), TABLESPACENAME VARCHAR(25), STATUS VARCHAR(50), CREATEBYTES INTEGER, READS INTEGER, WRITES INTEGER, AVGRDTIME INTEGER, AVGWRTIME INTEGER, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "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 'reads integer, writes integer, avgrdtime integer, avgwrtime integer, col' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'READS INTEGER, WRITES INTEGER, AVGRDTIME INTEGER, AVGWRTIME INTEGER, COL' at line 1"
Which leads to the following error:
All The Tables were not created properly.
Exiting OpManager
I have the database_params.conf file pointing to an external db server and I created the db as acsii_general_bin_ci. Is there a solution to this issue?
Exception in creating table
Statement being executed was :create table PollingAttributes( NAME varchar(50), TYPE varchar(10), PROPERTY varchar(20), CONDITION varchar(50), VALUE varchar(100))
syntax error or access violation, message from server: "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 'condition varchar(50), value varchar(100))' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'CONDITION varchar(50), VALUE varchar(100))' at line 1"
Exception in creating table
Statement being executed was :create table TableSpaceStatus ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, TABLESPACENAME VARCHAR(25), STATUS VARCHAR(50), FREEBYTES INTEGER, FREEBLOCKS INTEGER, READS INTEGER, WRITES INTEGER, READTIME BIGINT, WRITETIME BIGINT, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "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 'reads integer, writes integer, readtime bigint, writetime bigint, collec' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'READS INTEGER, WRITES INTEGER, READTIME BIGINT, WRITETIME BIGINT, COLLEC' at line 1"
Exception in creating table
Statement being executed was :create table InstanceStatus ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, DBSIZE BIGINT, AVGEXECS INTEGER, AVGUSERS INTEGER, READS INTEGER, WRITES INTEGER, BLOCKSIZE INTEGER, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "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 'reads integer, writes integer, blocksize integer, collectiontime bigint)' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'READS INTEGER, WRITES INTEGER, BLOCKSIZE INTEGER, COLLECTIONTIME BIGINT)' at line 1"
Exception in creating table
Statement being executed was :create table DataFiles ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, FILE_NAME VARCHAR(100), TABLESPACENAME VARCHAR(25), STATUS VARCHAR(50), CREATEBYTES INTEGER, READS INTEGER, WRITES INTEGER, AVGRDTIME INTEGER, AVGWRTIME INTEGER, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "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 'reads integer, writes integer, avgrdtime integer, avgwrtime integer, col' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "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 'READS INTEGER, WRITES INTEGER, AVGRDTIME INTEGER, AVGWRTIME INTEGER, COL' at line 1"
Which leads to the following error:
All The Tables were not created properly.
Exiting OpManager
I have the database_params.conf file pointing to an external db server and I created the db as acsii_general_bin_ci. Is there a solution to this issue?