This command looks fine to me, not sure why your database complains about it. Do you have MyISAM engine enabled in the database or only InnoDB? Ps MyISAM is a lot faster that's why we use it for audit trail tables, we don't need transaction support provided by InnoDB.

Please try enabling MyISAM and rerunning the same steps. If that cannot be done for whatever reason, please try creating that table manually. In case if you get similar errors for other tables (the console may try to create couple more tables), please pick their syntax from ODBC trace and create them manually.

In this case, you will need to create db_audit.sys_audit_trail table manually, you already have the DDL for it. In the DDL, please replace keyword TYPE with ENGINE. Everything else should work ok.

Hope that helps.

Mon Nov 28, 2011 1:12 am

paulchang

Joined: 20 Nov 2011Posts: 17Country: Taiwan, Province of China

Hi,
Thanks for the quick reply, can you tell me which DLL need to be searched and replaced with or I should just search everything in Directory "DB audit 4"?

Thanks
Paul
2011.11.28

Mon Nov 28, 2011 1:55 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6573

Hi,

No need to search any DLLs, I meant DDL - the table CREATE statement, DDL (data definition language). This is a one time setup procedure, and it sounds like you've done it already. Please check if everything else works ok. If you have any issues or questions, please let us know.

Thanks

Mon Nov 28, 2011 8:33 am

paulchang

Joined: 20 Nov 2011Posts: 17Country: Taiwan, Province of China

Hi,

There are another message show up after the table had been created, I try the system audit setup again, this time the error is "Unable to create or update audit schema! SQLSTATE=S0001 [Mysql....log] Table 'data_audit_trail' already exists "

Hi,
After I click on the ok button on the error dialog, the setup program quit and it didn't continue to finished what it suppose to do next.

Thanks
Paul
2011.11.29

Tue Nov 29, 2011 1:11 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6573

Please try dropping that table + one other before attempting a new setup
DROP TABLE db_audit.data_audit_trail;
DROP TABLE db_audit.data_audit_columns;

Please let us know if that helps.

Tue Nov 29, 2011 9:36 am

paulchang

Joined: 20 Nov 2011Posts: 17Country: Taiwan, Province of China

Hi,
If I drop the table and begin the setup from begin, It will show the last error " SQLSTATE=37000 ... TYPE=MyISAM at line 13 " which is because of "TYPE" key word not support in Mysql Ver 5.5, But If I manual create these tables, The setup show "SQLSTATE= S0001 .... data_audit_trail already exists".

Therefore,the setup won't continue in either way.

Thanks
Paul
2011.11.30

Tue Nov 29, 2011 9:37 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6573

The Type=MyISAM option is used with sys_audit_trail table. The table you need to drop is data_audit_trail.

Tue Nov 29, 2011 11:38 pm

paulchang

Joined: 20 Nov 2011Posts: 17Country: Taiwan, Province of China

Thank you for the clear the table name which I missed.

Below is the steps I do from the very beginning after clear all of tasked I did before.

First, I connect to mysql database,

Second, I manual created sys_audit_trial, and make sure no db_audit.data_audit_trail and db_audit.data_audit_columns .

Third, I begin system audit setup. After made a choice from list box from operation, I click on "enable system audit", then I got a error which is "SQLSTATE=37000...", If I continue click again on the "enable system audit" again, it will show the error as ""SQLSTATE=S0001... table already exist".

Am I missed somethings?

Thanks
Paul
2011.11.30

Wed Nov 30, 2011 2:07 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6573

A fix will be available in version 5 that will use new ENGINE keyword instead of old TYPE.

Sat Dec 10, 2011 10:53 am

paulchang

Joined: 20 Nov 2011Posts: 17Country: Taiwan, Province of China

Hi,
Thanks for the reply,
About the fix , when will it available , so I can try again?

Thanks
Paul
2011.12.14

Wed Dec 14, 2011 4:09 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6573

I'm sorry I don't know the exact release date at this time. Version 5 is a very significant new release. We are still working on it. DB Audit GUI console is just one of the components in the suite that is going to be updated in version 5.