RE: Can't get remote sensor to connect to mysql + one more question (Jean Paul Bourget)

[Holger.Woehle () arcor net]

> It has been snort and I tried it as root last.=20
> I am getting this error with snort.
>
> User=3Dsnort pass=3Dsnort db=3Dsnort
>
> Error:=20
>
> Access denied for user snort () snort mta roc arnoldmagnetics com.
>
> Should I look at the database permissions? Or file permissions?
> How do I view database permissions?

Hello,
it has nothing to do with file permissions. As you said in your following E-Mail
you openend up the firewall Port,
thats is of course a mandatory condition to access your database ;-)
Your user snort must at least have the privileges to select,insert and update on
your ids database.
Do the following on your database-server out of your mysql client:
mysql -u root -p
mysql> grant select,insert,update on snort.* to 'snort'@'name or
ipofyouridssensor' identified by 'snort'

Now try a connect from your ids-sensor:
mysql -u snort -h name or ipofyourdatabaseserver -p
mysql>use snort;
mysql>show tables;

regards
holger






-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
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