Re: snort & sql

[César Augusto Rojas Sierra <cesarojs () etb com co>]

Hi, I had the same problem, you must give access from remote sensor to 
the database to the user, I found this in the MySQL manual, and it 
works, now my sensor in Win 98 box can connect to the MySQL server in a 
Linux Box, even I can get the reports using ACID:


As of MySQL Version 3.23, for Host values specifed as IP numbers, you 
can specify a netmask indicating how many address bits to use for the 
network number. For example:

mysql> GRANT ALL PRIVILEGES ON db.*
-> TO david@'192.58.197.0/255.255.255.0';

This will allow everyone to connect from an IP where the following is true:

user_ip & netmask = host_ip.

In the above example all IP:s in the interval 192.58.197.0 - 
192.58.197.255 can connect to the MySQL server.



Good luck



-------------------------------------------------------
This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
for complex code. Debugging C/C++ programs can leave you feeling lost and 
disoriented. TotalView can help you find your way. Available on major UNIX 
and Linux platforms. Try it free. www.etnus.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