[Snort-users] mysql_error: Access denied for user: 'snort at ...7159...' (Using password: YES)

Sujit Pal sujit.pal at ...3147...
Sat Oct 12 08:42:02 EDT 2002


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= --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 at ...7159... which is my client system .
Where is the command taking the PASSWORD YES from.

[root at ...2306... 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 =
database:   sensor name = snort:eth1

database: mysql_error: Access denied for user: 'snort at ...7159...' (Using
password: YES)
Fatal Error, Quitting..


More information about the Snort-users mailing list