Snort mailing list archives
Re: permission denied for accessing Mysql database
From: Tomasz Piotr Palarz <tpalar1 () uic edu>
Date: Sun, 3 Apr 2005 12:15:01 -0500 (CDT)
Well, it looks like in your SQL statements you set the password to "password", but in your snort.conf you say password=snort . Might want to check that. Tomasz Piotr Palarz Computer Science Undergraduate ACM President 2004-2005 Academic Year University of Illinois at Chicago On Sun, 3 Apr 2005, Juan Fernandez wrote:
Hi, I have a problem logging alerts to a remote mysql ( and Aanval ). I configured the mysql db according to Patrick Harper : mysql mysql> SET PASSWORD FOR root@localhost=PASSWORD('password');Query OK, 0 rows affected (0.25 sec)mysql> create database snort;Query OK, 1 row affected (0.01 sec)mysql> grant INSERT,SELECT on root.* to snort@localhost;Query OK, 0 rows affected (0.02 sec)mysql> SET PASSWORD FOR snort@localhost=PASSWORD('password');Query OK, 0 rows affected (0.25 sec)mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on snort.* to snort@localhost;Query OK, 0 rows affected (0.02 sec)mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on snort.* to snort;Query OK, 0 rows affected (0.02 sec)mysql> exit;ByeThan on snort.conf on the sensor I have this line: output database: alert, mysql, user=snort password=snort dbname=snort host=243.137.60.187 sensor_name=sensjrlan What I try to fire up snort I receive this error in /var/log/messeges: Apr 3 13:04:32 sensjrlan snort: FATAL ERROR: database: mysql_error: Access denied for user 'root'@'n171-185.deltathree.com' (using password: YES) This sensor was logging to a former ACID server.what im trying to do now is to make him log to a new mysql+Aaval server. Any ideas ? Thanks very much ! Juan ------------------------------------------------------- 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://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ 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
------------------------------------------------------- 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://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ 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
Current thread:
- Re: permission denied for accessing Mysql database Tomasz Piotr Palarz (Apr 03)