mysql_error: Access denied for user: 'snort@192.168.1.30' (Using password: YES)

["Sujit Pal" <sujit.pal () verizon net>]

Hi,

I am a first time user. I set up SNORT on a system with Linux 7.3 and mysql
client snort/mysql client).

1) I could not find the latest and good snortd file. Where can I get it or
can someone mail me a copy.

My configuration has two systems .

The Mysql database and acid is on another system (acid/mysql server)

When i connect from the client to the server using command as below the sql
command works.

> mysql --host=192.168.1.55 --user=snort --password=123qwe
iam able to access the database and see tables etc.

But when I try through snort command line it fails to use the database. I
have set the snort.conf file with the option to use the same server , user,
password and database as above. But the snort fails to start properly. It
fails with error mentioned below.
I a have set the passwords for MySql as specified in the Snort Installation
Manual by Steven J Scott.

Do I need to give grants for snort@192.168.1.30 which is my client system .
Where is the command taking the PASSWORD YES from.

**************************************************************************
[root@snort root]# /usr/local/bin/snort -i eth1 -c /etc/snort/snort.conf
Log directory = /var/log/snort

Initializing Network Interface eth1
WARNING: OpenPcap() device eth1 network lookup:
        eth1: no IPv4 address assigned

        --== Initializing Snort ==--
Decoding Ethernet on interface eth1
Initializing Preprocessors!
Initializing Plug-ins!
Initializating Output Plugins!
Parsing Rules file /etc/snort/snort.conf

+++++++++++++++++++++++++++++++++++++++++++++++++++
Initializing rule chains...
No arguments to frag2 directive, setting defaults to:
    Fragment timeout: 60 seconds
    Fragment memory cap: 4194304 bytes
Stream4 config:
    Stateful inspection: ACTIVE
    Session statistics: INACTIVE
    Session timeout: 30 seconds
    Session memory cap: 8388608 bytes
    State alerts: INACTIVE
    Scan alerts: ACTIVE
    Log Flushed Streams: INACTIVE
No arguments to stream4_reassemble, setting defaults:
     Reassemble client: ACTIVE
     Reassemble server: INACTIVE
     Reassemble ports: 21 23 25 53 80 143 110 111 513
     Reassembly alerts: ACTIVE
     Reassembly method: FAVOR_OLD
database: compiled support for ( mysql )
database: configured to use mysql
database:          user = snort
database: password is set
database: database name = snort
database:          host = 192.168.1.55
database:   sensor name = snort:eth1

database: mysql_error: Access denied for user: 'snort@192.168.1.30' (Using
password: YES)
Fatal Error, Quitting..
**************************************************************************

Regards.



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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