Install DB Audit 4.2.26

An error occurs while the console is trying to create a new table, executing the following command

Code:

CREATE TABLE db_audit.sys_audit_trail (
event_time             datetime not null,
user                   varchar(255),
host_name             varchar(255),
schema_name          varchar(255),
thread_id             int,
log                   char(1),
log_event             char(7),
event_class          varchar(20),
text_data             varchar(20000),
obj_type             varchar(255),
obj_name             varchar(255),
error_code             int) TYPE=MyISAM

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.

Please let us know if that helps.

Hi,
I try to create the table with "... TYPE=MyISAM and it failed. I check mysql 5.5 manual , it seems "TYPE=XXXX" is not support and if I change to " CREATE TABLE db_audit.sys_audit_trail (
event_time datetime not null,
user varchar(255),
host_name varchar(255),
schema_name varchar(255),
thread_id int,
log char(1),
log_event char(7),
event_class varchar(20),
text_data varchar(20000),
obj_type varchar(255),
obj_name varchar(255),
error_code int) engine=MyISAM " It will work,

I am not sure that will you had a version for mysql5.5 ?

Thanks
Paul
2011.11.28

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.

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

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

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 "

I will attach ODBC trac below for your reference.

Thanks
Paul
2011.11.29

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 15 <SQL_ODBC_SQL_CONFORMANCE>
PTR 0x0012E9B0
SWORD 2
SWORD * 0x0012E9AA

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 15 <SQL_ODBC_SQL_CONFORMANCE>
PTR 0x0012E9B0 (1)
SWORD 2
SWORD * 0x0012E9AA (2)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 31 <SQL_MAX_CURSOR_NAME_LEN>
PTR 0x0012E7E0
SWORD 2
SWORD * 0x0012E7E8

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 31 <SQL_MAX_CURSOR_NAME_LEN>
PTR 0x0012E7E0 (18)
SWORD 2
SWORD * 0x0012E7E8 (2)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 38 <SQL_OUTER_JOINS>
PTR 0x024E2FE8
SWORD 512
SWORD * 0x0012E6BC

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 38 <SQL_OUTER_JOINS>
PTR 0x024E2FE8 [ 2] "Y"
SWORD 512
SWORD * 0x0012E6BC (2)

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E6A0

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E6A0 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetTypeInfo
HSTMT 024E29B0
SWORD 11 <SQL_TIMESTAMP>

DB_AUDIT f90-13d8 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD 11 <SQL_TIMESTAMP>

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 3
SWORD 4 <SQL_C_LONG>
PTR 0x0012E6B4
SQLLEN 4
SQLLEN * 0x0012E6B8

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 3
SWORD 4 <SQL_C_LONG>
PTR 0x0012E6B4
SQLLEN 4
SQLLEN * 0x0012E6B8 (1238784)

DB_AUDIT f90-13d8 ENTER SQLFetch
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFetch
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFetch
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E7A4

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E7A4 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E766

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E766 (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B26AC8 [ -3] "SELECT count(1) FROM INFORMATION_SCHEMA.TABLES T WHERE T.TABLE_SCHEMA = 'db_audit' AND T.TABLE_TYPE = 'BASE TABLE' AND T.TABLE_NAME IN ('sys_audit_trail', 'sys_audit_options')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B26AC8 [ -3] "SELECT count(1) FROM INFORMATION_SCHEMA.TABLES T WHERE T.TABLE_SCHEMA = 'db_audit' AND T.TABLE_TYPE = 'BASE TABLE' AND T.TABLE_NAME IN ('sys_audit_trail', 'sys_audit_options')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E1FD0
SWORD 18
SWORD * 0x0012E7D8

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E1FD0 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E7D8 (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E7C8

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E7C8 (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E780

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E780 (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E6F0
SWORD 129
SWORD * 0x0012E6A0
SWORD * 0x0012E692
SQLULEN * 0x0012E6A4
SWORD * 0x0012E6A8
SWORD * 0x0012E6AA

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E6F0 [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E6A0 (8)
SWORD * 0x0012E692 (-5)
SQLULEN * 0x0012E6A4 (19)
SWORD * 0x0012E6A8 (0)
SWORD * 0x0012E6AA (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D698
SQLLEN 44
SQLLEN * 0x01D71428

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D698
SQLLEN 44
SQLLEN * 0x01D71428 (0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E81C
SWORD 4
SWORD * 0x0012E824

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E81C
SWORD 4
SWORD * 0x0012E824 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E818
UWORD * 0x0012E824

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E818 (1)
UWORD * 0x0012E824 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E800

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E800 (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E7A4

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E7A4 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E766

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E766 (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B26C38 [ -3] "SELECT count(1) FROM mysql.func WHERE name in ('db_audit_status', 'db_audit_reset')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B26C38 [ -3] "SELECT count(1) FROM mysql.func WHERE name in ('db_audit_status', 'db_audit_reset')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E2008
SWORD 18
SWORD * 0x0012E7D8

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E2008 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E7D8 (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E7C8

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E7C8 (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E780

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E780 (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E6F0
SWORD 129
SWORD * 0x0012E6A0
SWORD * 0x0012E692
SQLULEN * 0x0012E6A4
SWORD * 0x0012E6A8
SWORD * 0x0012E6AA

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E6F0 [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E6A0 (8)
SWORD * 0x0012E692 (-5)
SQLULEN * 0x0012E6A4 (19)
SWORD * 0x0012E6A8 (0)
SWORD * 0x0012E6AA (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D510
SQLLEN 44
SQLLEN * 0x01D714D8

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D510
SQLLEN 44
SQLLEN * 0x01D714D8 (1315991552)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E81C
SWORD 4
SWORD * 0x0012E824

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E81C
SWORD 4
SWORD * 0x0012E824 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E818
UWORD * 0x0012E824

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E818 (1)
UWORD * 0x0012E824 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E800

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E800 (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E7A4

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E7A4 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E766

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E766 (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B26CA8 [ -3] "SELECT db_audit_status()\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 024E29B0
UCHAR * 0x00B26CA8 [ -3] "SELECT db_audit_status()\ 0"
SDWORD -3

DIAG [37000] [MySQL][ODBC 3.51 Driver][mysqld-5.5.15-log]FUNCTION vms.db_audit_status does not exist (1305)

DB_AUDIT f90-13d8 ENTER SQLErrorW
HENV 00000000
HDBC 024E1830
HSTMT 024E29B0
WCHAR * 0x0012E748 (NYI)
SDWORD * 0x0012E798
WCHAR * 0x0012E348
SWORD 512
SWORD * 0x0012E7A0

DB_AUDIT f90-13d8 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 024E1830
HSTMT 024E29B0
WCHAR * 0x0012E748 (NYI)
SDWORD * 0x0012E798 (1305)
WCHAR * 0x0012E348 [ 87] "[MySQL][ODBC 3.51 Driver][mysqld-5.5.15-log]FUNCTION vms.db_audit_status does not exist"
SWORD 512
SWORD * 0x0012E7A0 (87)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E598

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E598 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E55A

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E55A (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B29F94 [ -3] "SELECT count(1) FROM information_schema.tables WHERE table_schema = 'DB_AUDIT' AND table_name = 'SYS_AUDIT_OPTIONS'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B29F94 [ -3] "SELECT count(1) FROM information_schema.tables WHERE table_schema = 'DB_AUDIT' AND table_name = 'SYS_AUDIT_OPTIONS'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E2040
SWORD 18
SWORD * 0x0012E5CC

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E2040 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E5CC (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E5BC

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E5BC (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E574

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E574 (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E4E4
SWORD 129
SWORD * 0x0012E494
SWORD * 0x0012E486
SQLULEN * 0x0012E498
SWORD * 0x0012E49C
SWORD * 0x0012E49E

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E4E4 [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E494 (8)
SWORD * 0x0012E486 (-5)
SQLULEN * 0x0012E498 (19)
SWORD * 0x0012E49C (0)
SWORD * 0x0012E49E (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D3C0
SQLLEN 44
SQLLEN * 0x01D70D98

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D3C0
SQLLEN 44
SQLLEN * 0x01D70D98 (1953718528)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E610
SWORD 4
SWORD * 0x0012E618

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E610
SWORD 4
SWORD * 0x0012E618 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E60C
UWORD * 0x0012E618

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E60C (1)
UWORD * 0x0012E618 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E5F4

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E5F4 (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E888

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E888 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E84A

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E84A (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B33F5C [ -3] "SELECT count(1) FROM INFORMATION_SCHEMA.TABLES T WHERE T.TABLE_SCHEMA = 'db_audit' AND T.TABLE_TYPE = 'BASE TABLE' AND T.TABLE_NAME IN ('sys_audit_trail', 'sys_audit_options')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B33F5C [ -3] "SELECT count(1) FROM INFORMATION_SCHEMA.TABLES T WHERE T.TABLE_SCHEMA = 'db_audit' AND T.TABLE_TYPE = 'BASE TABLE' AND T.TABLE_NAME IN ('sys_audit_trail', 'sys_audit_options')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E1938
SWORD 18
SWORD * 0x0012E8BC

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E1938 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E8BC (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E8AC

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E8AC (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E864

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E864 (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E7D4
SWORD 129
SWORD * 0x0012E784
SWORD * 0x0012E776
SQLULEN * 0x0012E788
SWORD * 0x0012E78C
SWORD * 0x0012E78E

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E7D4 [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E784 (8)
SWORD * 0x0012E776 (-5)
SQLULEN * 0x0012E788 (19)
SWORD * 0x0012E78C (0)
SWORD * 0x0012E78E (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D6D0
SQLLEN 44
SQLLEN * 0x01D714B8

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D6D0
SQLLEN 44
SQLLEN * 0x01D714B8 (0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E900
SWORD 4
SWORD * 0x0012E908

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E900
SWORD 4
SWORD * 0x0012E908 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E8FC
UWORD * 0x0012E908

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E8FC (1)
UWORD * 0x0012E908 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E8E4

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E8E4 (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E888

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E888 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E84A

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E84A (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B3354C [ -3] "SELECT count(1) FROM mysql.func WHERE name in ('db_audit_status', 'db_audit_reset')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B3354C [ -3] "SELECT count(1) FROM mysql.func WHERE name in ('db_audit_status', 'db_audit_reset')\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E1970
SWORD 18
SWORD * 0x0012E8BC

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E1970 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E8BC (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E8AC

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E8AC (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E864

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E864 (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E7D4
SWORD 129
SWORD * 0x0012E784
SWORD * 0x0012E776
SQLULEN * 0x0012E788
SWORD * 0x0012E78C
SWORD * 0x0012E78E

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E7D4 [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E784 (8)
SWORD * 0x0012E776 (-5)
SQLULEN * 0x0012E788 (19)
SWORD * 0x0012E78C (0)
SWORD * 0x0012E78E (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D548
SQLLEN 44
SQLLEN * 0x01D71438

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D548
SQLLEN 44
SQLLEN * 0x01D71438 (1315991552)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E900
SWORD 4
SWORD * 0x0012E908

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E900
SWORD 4
SWORD * 0x0012E908 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E8FC
UWORD * 0x0012E908

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E8FC (1)
UWORD * 0x0012E908 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E8E4

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E8E4 (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E888

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E888 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E84A

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E84A (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B316C4 [ -3] "SELECT db_audit_status()\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 024E29B0
UCHAR * 0x00B316C4 [ -3] "SELECT db_audit_status()\ 0"
SDWORD -3

DIAG [37000] [MySQL][ODBC 3.51 Driver][mysqld-5.5.15-log]FUNCTION vms.db_audit_status does not exist (1305)

DB_AUDIT f90-13d8 ENTER SQLErrorW
HENV 00000000
HDBC 024E1830
HSTMT 024E29B0
WCHAR * 0x0012E82C (NYI)
SDWORD * 0x0012E87C
WCHAR * 0x0012E42C
SWORD 512
SWORD * 0x0012E884

DB_AUDIT f90-13d8 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 024E1830
HSTMT 024E29B0
WCHAR * 0x0012E82C (NYI)
SDWORD * 0x0012E87C (1305)
WCHAR * 0x0012E42C [ 87] "[MySQL][ODBC 3.51 Driver][mysqld-5.5.15-log]FUNCTION vms.db_audit_status does not exist"
SWORD 512
SWORD * 0x0012E884 (87)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E264

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E264 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E226

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E226 (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B53348 [ -3] "SELECT count(1) FROM mysql.user WHERE user = 'db_audit'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B53348 [ -3] "SELECT count(1) FROM mysql.user WHERE user = 'db_audit'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E1938
SWORD 18
SWORD * 0x0012E298

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E1938 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E298 (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E288

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E288 (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E240

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E240 (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E1B0
SWORD 129
SWORD * 0x0012E160
SWORD * 0x0012E152
SQLULEN * 0x0012E164
SWORD * 0x0012E168
SWORD * 0x0012E16A

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E1B0 [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E160 (8)
SWORD * 0x0012E152 (-5)
SQLULEN * 0x0012E164 (19)
SWORD * 0x0012E168 (0)
SWORD * 0x0012E16A (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D708
SQLLEN 44
SQLLEN * 0x01D70D98

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D708
SQLLEN 44
SQLLEN * 0x01D70D98 (458752)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E2DC
SWORD 4
SWORD * 0x0012E2E4

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E2DC
SWORD 4
SWORD * 0x0012E2E4 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E2D8
UWORD * 0x0012E2E4

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E2D8 (1)
UWORD * 0x0012E2E4 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E2C0

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E2C0 (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E470

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E470 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E432

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E432 (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B53060 [ -3] "SELECT count(1) FROM information_schema.tables WHERE table_schema = 'DB_AUDIT' AND table_name = 'DATA_AUDIT_TRAIL'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B53060 [ -3] "SELECT count(1) FROM information_schema.tables WHERE table_schema = 'DB_AUDIT' AND table_name = 'DATA_AUDIT_TRAIL'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E1970
SWORD 18
SWORD * 0x0012E4A4

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E1970 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E4A4 (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E494

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E494 (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E44C

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E44C (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E3BC
SWORD 129
SWORD * 0x0012E36C
SWORD * 0x0012E35E
SQLULEN * 0x0012E370
SWORD * 0x0012E374
SWORD * 0x0012E376

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E3BC [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E36C (8)
SWORD * 0x0012E35E (-5)
SQLULEN * 0x0012E370 (19)
SWORD * 0x0012E374 (0)
SWORD * 0x0012E376 (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D4D8
SQLLEN 44
SQLLEN * 0x01D71498

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D4D8
SQLLEN 44
SQLLEN * 0x01D71498 (1315991552)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E4E8
SWORD 4
SWORD * 0x0012E4F0

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E4E8
SWORD 4
SWORD * 0x0012E4F0 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E4E4
UWORD * 0x0012E4F0

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E4E4 (1)
UWORD * 0x0012E4F0 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E4CC

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E4CC (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E470

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E470 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E432

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E432 (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B534C8 [ -3] "SELECT count(1) FROM information_schema.tables WHERE table_schema = 'DB_AUDIT' AND table_name = 'DATA_AUDIT_COLUMNS'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B534C8 [ -3] "SELECT count(1) FROM information_schema.tables WHERE table_schema = 'DB_AUDIT' AND table_name = 'DATA_AUDIT_COLUMNS'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E1938
SWORD 18
SWORD * 0x0012E4A4

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E1938 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E4A4 (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E494

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E494 (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E44C

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E44C (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E3BC
SWORD 129
SWORD * 0x0012E36C
SWORD * 0x0012E35E
SQLULEN * 0x0012E370
SWORD * 0x0012E374
SWORD * 0x0012E376

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E3BC [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E36C (8)
SWORD * 0x0012E35E (-5)
SQLULEN * 0x0012E370 (19)
SWORD * 0x0012E374 (0)
SWORD * 0x0012E376 (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D698
SQLLEN 44
SQLLEN * 0x01D71468

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D698
SQLLEN 44
SQLLEN * 0x01D71468 (1315991552)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E4E8
SWORD 4
SWORD * 0x0012E4F0

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E4E8
SWORD 4
SWORD * 0x0012E4F0 (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E4E4
UWORD * 0x0012E4F0

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E4E4 (1)
UWORD * 0x0012E4F0 (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E4CC

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E4CC (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E67C

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E67C ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788
SWORD 100
SWORD * 0x0012E63E

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x024E1788 [ 10] "03.51"
SWORD 100
SWORD * 0x0012E63E (10)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B52FF0 [ -3] "SELECT count(1) FROM information_schema.SCHEMATA WHERE schema_name = 'db_audit'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UCHAR * 0x00B52FF0 [ -3] "SELECT count(1) FROM information_schema.SCHEMATA WHERE schema_name = 'db_audit'\ 0"
SDWORD -3

DB_AUDIT f90-13d8 ENTER SQLGetCursorNameW
HSTMT 024E29B0
WCHAR * 0x024E1970
SWORD 18
SWORD * 0x0012E6B0

DB_AUDIT f90-13d8 EXIT SQLGetCursorNameW with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
WCHAR * 0x024E1970 [ 8] "SQL_"
SWORD 18
SWORD * 0x0012E6B0 (8)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E6A0

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E6A0 (1)

DB_AUDIT f90-13d8 ENTER SQLNumResultCols
HSTMT 024E29B0
SWORD * 0x0012E658

DB_AUDIT f90-13d8 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SWORD * 0x0012E658 (1)

DB_AUDIT f90-13d8 ENTER SQLDescribeCol
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E5C8
SWORD 129
SWORD * 0x0012E578
SWORD * 0x0012E56A
SQLULEN * 0x0012E57C
SWORD * 0x0012E580
SWORD * 0x0012E582

DB_AUDIT f90-13d8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
UCHAR * 0x0012E5C8 [ 8] "count(1)"
SWORD 129
SWORD * 0x0012E578 (8)
SWORD * 0x0012E56A (-5)
SQLULEN * 0x0012E57C (19)
SWORD * 0x0012E580 (0)
SWORD * 0x0012E582 (0)

DB_AUDIT f90-13d8 ENTER SQLBindCol
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D6D0
SQLLEN 44
SQLLEN * 0x01D71428

DB_AUDIT f90-13d8 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1
SWORD 8 <SQL_C_DOUBLE>
PTR 0x01D7D6D0
SQLLEN 44
SQLLEN * 0x01D71428 (11841024)

DB_AUDIT f90-13d8 ENTER SQLGetInfoW
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E6F4
SWORD 4
SWORD * 0x0012E6FC

DB_AUDIT f90-13d8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024E1830
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012E6F4
SWORD 4
SWORD * 0x0012E6FC (4)

DB_AUDIT f90-13d8 ENTER SQLExtendedFetch
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E6F0
UWORD * 0x0012E6FC

DB_AUDIT f90-13d8 EXIT SQLExtendedFetch with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0012E6F0 (1)
UWORD * 0x0012E6FC (0)

DB_AUDIT f90-13d8 ENTER SQLRowCount
HSTMT 024E29B0
SQLLEN * 0x0012E6D8

DB_AUDIT f90-13d8 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
SQLLEN * 0x0012E6D8 (1)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 ENTER SQLAllocStmt
HDBC 024E1830
HSTMT * 0012E6F4

DB_AUDIT f90-13d8 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 024E1830
HSTMT * 0x0012E6F4 ( 0x024e29b0)

DB_AUDIT f90-13d8 ENTER SQLExecDirect
HSTMT 024E29B0
UCHAR * 0x00B53D28 [ -3] "CREATE TABLE db_audit.data_audit_trail (\ d\ a source_db VARCHAR(30) DEFAULT 'N/A' NOT NULL,\ d\ a source_owner VARCHAR(128) NOT NULL,\ d\ a source_table VARCHAR(128) NOT NULL,\ d\ a source_table_alias VARCHAR(128) ,\ d\ a audit_table VARCHAR(30) NOT NULL,\ d\ a audit_trigger VARCHAR(30) NOT NULL,\ d\ a audit_inserts INTEGER DEFAULT 1 NOT NULL,\ d\ a audit_deletes INTEGER DEFAULT 1 NOT NULL,\ d\ a audit_updates INTEGER DEFAULT 1 NOT NULL,\ d\ a audit_notify INTEGER DEFAULT 0 NOT NULL,\ d\ a mail_recipient VARCHAR(255) ,\ d\ a mail_cc VARCHAR(255) ,\ d\ a key_columns VARCHAR(255) ,\ d\ a all_columns INTEGER DEFAULT 1 NOT NULL,\ d\ aPRIMARY KEY (source_db, source_owner, source_table, audit_trigger))\ 0"
SDWORD -3

DB_AUDIT f90-13d8 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 024E29B0
UCHAR * 0x00B53D28 [ -3] "CREATE TABLE db_audit.data_audit_trail (\ d\ a source_db VARCHAR(30) DEFAULT 'N/A' NOT NULL,\ d\ a source_owner VARCHAR(128) NOT NULL,\ d\ a source_table VARCHAR(128) NOT NULL,\ d\ a source_table_alias VARCHAR(128) ,\ d\ a audit_table VARCHAR(30) NOT NULL,\ d\ a audit_trigger VARCHAR(30) NOT NULL,\ d\ a audit_inserts INTEGER DEFAULT 1 NOT NULL,\ d\ a audit_deletes INTEGER DEFAULT 1 NOT NULL,\ d\ a audit_updates INTEGER DEFAULT 1 NOT NULL,\ d\ a audit_notify INTEGER DEFAULT 0 NOT NULL,\ d\ a mail_recipient VARCHAR(255) ,\ d\ a mail_cc VARCHAR(255) ,\ d\ a key_columns VARCHAR(255) ,\ d\ a all_columns INTEGER DEFAULT 1 NOT NULL,\ d\ aPRIMARY KEY (source_db, source_owner, source_table, audit_trigger))\ 0"
SDWORD -3

DIAG [S0001] [MySQL][ODBC 3.51 Driver][mysqld-5.5.15-log]Table 'data_audit_trail' already exists (1050)

DB_AUDIT f90-13d8 ENTER SQLErrorW
HENV 024E2CC8
HDBC 024E1830
HSTMT 024E29B0
WCHAR * 0x0012E698 (NYI)
SDWORD * 0x0012E6E8
WCHAR * 0x0012E298
SWORD 512
SWORD * 0x0012E6F0

DB_AUDIT f90-13d8 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 024E2CC8
HDBC 024E1830
HSTMT 024E29B0
WCHAR * 0x0012E698 (NYI)
SDWORD * 0x0012E6E8 (1050)
WCHAR * 0x0012E298 [ 83] "[MySQL][ODBC 3.51 Driver][mysqld-5.5.15-log]Table 'data_audit_trail' already exists"
SWORD 512
SWORD * 0x0012E6F0 (83)

DB_AUDIT f90-13d8 ENTER SQLCancel
HSTMT 024E29B0

DB_AUDIT f90-13d8 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0

DB_AUDIT f90-13d8 ENTER SQLFreeStmt
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

DB_AUDIT f90-13d8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 024E29B0
UWORD 1 <SQL_DROP>

Does it give you an option to ignore that error and continue?

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

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.

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

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

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

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

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

Thanks
Paul
2011.12.14

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.