AW: problem logging to mysql database

["Poppi, Sandro" <Sandro.Poppi () wacker com>]

According to the error message you get I would suggest

GRANT ALL on snort.* to snort@localhost identified by password xxxx

This is because if you access the db from localhost you won't use your
hostname but localhost and this has to be adjusted in mysql. If you access
the db from another pc on your network you would have to add snort@hostname
in mysql.

HTH,
Sandro

> i have been running snort for a while now , having it  log to 
> syslog and
> using swatch to monitor stuff, i needed something more granular and
> scalable. therefore i decided to use mysql database using 
> both demarc and
> acid and later decide on which one i prefer. I have demarc 
> running o.k and
> acid running fine. But i have consistenly had problem with 
> mysql, i have
> flushed privileges and recreated database manytimes to no avail. I am
> running mysql and snort on a multihomed server. could the 
> problem be that am
> trying to access the database on localhost, Beacuse the error 
> am getting is
> something  like this " ACCESS DENIED, ACCESS FOR USER 
> SNORT@LOCALHOST USING
> PASSWORD YES FAILED. if so, since i only have one machine how 
> do i access
> the database from localhost or how does one go about solving 
> this problem. i
> have tried this statement in mysql GRANT ALL on snort.* to 
> snort@my_domain
> identified by password XXXXXX, it still did not work. Also 
> when i try to log
> in to demarc as anonymous i get the above error message, even 
> though i have
> edited the conf to allow anonmous user as admin. that makes 
> me think my
> problem is only with mysql. I plan to spend tonite reading 
> MYSQL manual, but
> any help you from the list would be greatly appreciated.
>
>
> Molayo Salako.   CISSP
> Network Security Engineer
> Goamerica communications
> E:osalako () corp goamerica net 
>
> "imagination is more important than knowledge"   -Al Einstein 
>
>
> _______________________________________________
> 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

_______________________________________________
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