Re: (no subject)

[Ian Macdonald <secsnort () dirk demon co uk>]

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


Ian

On Thu, 8 Aug 2002, herris () somnambulance org 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 () 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



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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