[cvsnt] Re: Auditing with MySql database

[Andy Southby]

Edward,

I tried it and yes I get an error from the %PREFIX% in the SQL. It was I 
while ago when I created the tables but do not remember %PREFIX% being there 
before? Unfortunatly my SQL level is basic to say the least, so I can only 
assume that this script is not suppose to be used standalone or needs an 
environmental 'PREFIX to be defined to a usefull value?

As a solution though you could use the 'Create Tables' button on the 'Audit 
Settings' dialog which works for me. (I used MySQL 5.0 and CVSNT 
2.5.03.2238.)

Good luck,
Andy.

"Edward Patterson" <edward.patterson at benefitfocus.com> wrote in message 
news:mailman.1015.1140126596.17086.cvsnt at cvsnt.org...
I am running CVSNT version 2.5.03.2151 and MySQL version 4.1.7. When
trying to setup the auditing to the database it connects fine but errors
on creating the tables in the database due to an error in the SQL
syntax. According to the auditing tutorial, CVSNT has native support for
MySQL but it does not say for what versions? Has anyone see this
problem?



****************************************************************************************
BENEFITFOCUS.COM CONFIDENTIALITY NOTICE: This electronic message is intended 
only for the individual or entity to which it is addressed and may contain 
information that is confidential and protected by law. Unauthorized review, 
use, disclosure, or dissemination of this communication or its contents in 
any way is prohibited and may be unlawful. If you are not the intended 
recipient or a person responsible for delivering this message to an intended 
recipient, please notify the original sender immediately by e-mail or 
telephone, return the original message to the original sender or to 
bfpostmaster at benefitfocus.com, and destroy all copies or derivations of the 
original message. Thank you.  (BFeComNote Rev. 08/01/2005)
***************************************************************************************