External Mysql Database RSS

1

Nice greetings from Austria,

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

by Simon Taeuber 8 years ago
2

@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.

by Peter Karsai (ORF Team) 8 years ago
(in reply to this post)

New comment

Fill in the form below to add a new comment. All fields are required. If you are a registered user on our site, please sign in first.

Nickname:
Email address (will not be published):
Your comment:

ORF Technical Support

Configuring, installing and troubleshooting ORF.

News & Announcements

Your dose of ORF-related news and announcements.

Everything but ORF

Discuss Exchange and system administration with fellow admins.

Feature Test Program

Feature Test Program discussion. Membership is required to visit this forum.

ORF Beta

Join the great bug hunt of the latest test release.

Customer Service

Stay Informed