@Simon Taeuber: ORF uses a couple of ANSI-ish SQL commands for the Honeypot database like
INSERT INTO HoneypotBlacklist
(IpAddress, LastUpdateTime)
VALUES
(?, ?)
and many more like that (SELECT, UPDATE). I am not familiar with MySQL, but I think you can turn on SQL logging in MySQL to see what commands are issued exactly and this can point toward the command that fails.
A lot depends on the ODBC/OLE driver. ORF uses predefined SQL strings with positional parameters to safely access the database via ADO. The data types used in commands are adDate and adVarChar, there could be compatibility issues here.
You mentioned that the Manage Database dialog in ORF shows the correct record count - was the database populated by ORF? If ORF can add records, but cannot query/update them, that can be a useful information to determine which command fails.
INSERT INTO HoneypotBlacklist
(IpAddress, LastUpdateTime)
VALUES
(?, ?)
and many more like that (SELECT, UPDATE). I am not familiar with MySQL, but I think you can turn on SQL logging in MySQL to see what commands are issued exactly and this can point toward the command that fails.
A lot depends on the ODBC/OLE driver. ORF uses predefined SQL strings with positional parameters to safely access the database via ADO. The data types used in commands are adDate and adVarChar, there could be compatibility issues here.
You mentioned that the Manage Database dialog in ORF shows the correct record count - was the database populated by ORF? If ORF can add records, but cannot query/update them, that can be a useful information to determine which command fails.
Peter Karsai (ORF Team)
(April 9, 2011)
in response to this post
in response to this post
is there a possibility to use MySql as external Database?
i use this connection string:
Driver={MySQL ODBC 5.1 Driver};Server=server01.xxx.xxx;Database=orfdb; User=xxx;Password=xxx;Option=3;
ORF can read from Database ( under manage Database it shows the correct Record count) but if a record is tried to add there is an error as follows:
Unexpected Honeypot Test error. EVariantInvalidOpError "Invalid variant operation".
My Question: Which SQL command is send by ORF to validate /add a Record.
Maybe i'm able to develop a interface to translate this data to be compatible with MySql.
kind regards
Simon