[Snort-users] (no subject)

Ian Macdonald secsnort at ...5528...
Thu Aug 8 19:55:03 EDT 2002

My guess would be that you are not accessing the right database or the
create mysql sql did not complete sucessfully.

You might want to try logging into mysql with something like

mysql -p -u root

then switch to your snort database

use snort;

then show all the table

show tables;

That shoud give you an idea on what exists in your database


On Thu, 8 Aug 2002, herris at ...6560... wrote:

> Hello.
> I installed snort-1.8.7-win32.exe but am having problems. I did a search of
> the mailing list archives and only found 1 post that was of the same issue.
> The one reply to it did not seem to fix the problem and truthfully does not
> seem to address what the real problem is.
> Below is the error I get trying to run snort.
> 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..
> I used the 1.8.7 source to get the create_mysql table entries.
> Not sure what is going on and I am not a mysql expert but I think the
> problem is the brackets around schema.
> Anyone else ran into this issue and gotten it resolved?
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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

More information about the Snort-users mailing list