[Snort-users] Snort 1.8.7 windows 2000 MySQL

Roman Danyliw roman at ...438...
Tue Aug 13 11:04:03 EDT 2002


There was a bug (which was just fixed in CVS) that caused snort to always use
MS-SQL style SQL (if it was supported) to detect the version number of the DB. 
This condition, occured even when another database type was specified for use
(merely having MS-SQL support compiled in was the sufficient condition).

Either grab the latest copy of snort from CVS, or use an existing binary that
has only the database support you want built in.  Since you are only after
Mysql, snort-1.8.7-Win32_MySQL_Flexresp_release.zip is probably all you need. 
This version does not fix the bug, but it should not arise in this build.

Roman

On Tue, 13 Aug 2002 15:38:43 +0200, "Laurent Grignet" <lgrignet at ...6361...> wrote :

> Hello,
> 
> I try to set up Snort with MySQL.
> I downloaded the binary of snort 1.8.7 with MySQL support.
> 
> -> Version 1.8.7beta5-ODBC-MySQL-MSSQL-FlexRESP-WIN32 (Build 128)
> 
> I downloaded the source 1.8.7 to get the create_mysql script.
> I create the database/user/table...
> Configure the config file...
> 
> But when I launch snort I just have an error message.
> 
> This one :
> database:   sensor name =
> SPE-SERVEUR:\Device\Packet_{BEC43E82-0FA8-49DE-B52F-AD4CEEE60EB7}
> 
> database:     sensor id = 1
> database: mysql_error: You have an error in your SQL syntax near
> '[schema]' at line 1
> database: schema version = 0
> database: The underlying database seems to be running an older version
> of the DB schema.
>           Please re-run the appropriate DB creation script (e.g.
> create_mysql,
>           create_postgresql, create_oracle) located in the contrib\
> directory.
> Fatal Error, Quitting..
> 
> Can someone help me ?
> 
> Thanx
> 
> Laurent
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: Dice - The leading online job board
> for high-tech professionals. Search and apply for tech jobs today!
> http://seeker.dice.com/seeker.epl?rel_code=31
> _______________________________________________
> Snort-users mailing list
> Snort-users at lists.sourceforge.net
> Go to this URL to change user options or unsubscribe:
> https://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users
> 
> 
> 
> 




More information about the Snort-users mailing list