Re: permission denied for accessing Mysql database

[Tomasz Piotr Palarz <tpalar1 () uic edu>]

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;
>
> > Bye
>
> Than 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