Re: Snort 1.8.7 windows 2000 MySQL

["Roman Danyliw" <roman () danyliw com>]

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 () ulg ac be> 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 () 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


-------------------------------------------------------
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 () 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