RE: FW: MySQL error

["Faiz Ahmad Shuja" <faizshuja () yahoo it>]

check the parameters you have set for database connectivity in
snort.conf. it should work if it has proper rights for the database.

-faiz


-----Original Message-----
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of Chris
Sent: Wednesday, June 04, 2003 6:47 PM
To: snort-users () lists sourceforge net
Subject: [Snort-users] FW: MySQL error



I just recompiled snort with mysql support and changed the conf.
However, I am getting an access error.

...
database: compiled support for ( mysql)
database: configured to use mysql
database:         user = snortdba
database: password is set
database: database name = snort
database:          host = 10.10.10.218
database:          port = 3306
database:   sensor name = 10.10.10.64
ERROR: database: mysql_error: Access denied for user:
'snortdba@10.10.10.64' (Using password: YES) ...


now this works:
# mysql -u snortdba -h 10.10.10.218 -p
Enter password: xxxxx

So I know that I am using the right username/password.  Snortdba has
select, insert, update, delete rights on the snort database.

I checked the archives and haven't found anything yet.  Most of them are
from people with the wrong username/password.

Thanks,

Chris Romano




-------------------------------------------------------
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at 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=ort-users

Attachment: smime.p7s
Description: