Snort mailing list archives

RE: ACID Error: Error (p) connecting to DB


From: "Paul Pearston" <paul.pearston () btinternet com>
Date: Mon, 5 May 2003 20:55:23 +0100

I think so. I can access my database using the following commands, which
matches the alert_user, alert_password and alert_dbname variables set
with acid_config.php, without receiving an error:
 
Mysql -u snort -psn0rt snort
Mysql>Select * from event;
 
 
Admittedly, it's the first time that I have used MySQL, PHP and ACID,
however, I have been following these instructions:
 
 http://www.superhac.com/docs/snort_enterprise.pdf
 
I did, however, install MySQL v4.1 server and client as opposed to v4.0
as documented in the above instructions. And, MySQL 3.23 shared
libraries as there are dependency problems with the v4.0/v4.1 with
RedHat 9 as per the instructions.
 
Should I downgrade to MySQL v4.0?
 
Thanks,
 
Paul
 
 
-----Original Message-----
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of Michael
Steele
Sent: 05 May 2003 19:16
To: 'Paul Pearston'; snort-users () lists sourceforge net
Subject: RE: [Snort-users] ACID Error: Error (p) connecting to DB
 
Paul,
 
Have you configured your acid_conf.php file, and does it reflect your
configuration?
 
 -Michael
 
-----Original Message-----
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of Paul
Pearston
Sent: Monday, May 05, 2003 8:54 AM
To: snort-users () lists sourceforge net
Subject: [Snort-users] ACID Error: Error (p) connecting to DB
 
Hi,
I get the following error when I attempted to access the ACID Console
(https://localhost/acid/index.html) for the first time:
 
 
Warning: Client does not support authentication protocol requested by
server. Consider upgrading MySQL client in
/var/www/html/adodb/drivers/adodb-mysql.inc.php on line 229
Error (p)connecting to DB : snort@localhost:3306 
Check the DB connection variables in acid_conf.php 
               = $alert_dbname   : MySQL database name where the alerts
are stored 
               = $alert_host     : host where the database is stored
               = $alert_port     : port where the database is stored
               = $alert_user     : username into the database
               = $alert_password : password for the username
              
Database ERROR:Client does not support authentication protocol requested
by server. Consider upgrading MySQL client
I can connect to the snort db locally within mysql, however, not from
ACID. Any assistance would be greatly appreciated?
 
Thanks,
 
Paul

Current thread: