Snort Forums Archive

Archive Home » Third Party Tools » ACID and MySql

Please note that the categories listed below represent an archived version of our forums pages. To view the current version and be able to post and reply to threads, please register and login here to go to the full forums pages.

[ Notice: Full Version of This Topic ]

ACID and MySql

Posted by khic on April 06, 2005 21:08:41

HI!
I am quite inexperienced with all of this and I am trying to set my NIDS system (Snort, ACID, MySql).When trying to connect with ACID to MYSql database and i get several warnings and errors:

"Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\adodb\drivers\adodb-mysql.inc.php on line 356
Error (p)connecting to DB : snort_db@localhost
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"

Of course, I checked all the passwords in my acid.conf.ini file and they are ok. Is there maybe a problem in incorrect versions - I have installed
Addodb 461 version, and MYsql 4.1 on my WIN XP PRO.

Thx in advance

Karlo

Posted by digitalmentor on April 13, 2005 19:31:21

I dont know if this helps but I found this on a postnuke forum so i thought i would post it here maybe it will help you out:

http://forums.postnuke.com/index.php?name=PNphpBB2&file=viewtopic&t=34134&highlight=mysql+authentication

SNIP>>>>>
I just hit this myself today while re-installing one of my test setups. A little research on google shows that this is caused by the use of mysql 4.1.x. The 4.1.x releases of mysql use a different password authentication methodlogy to earlier releases. All client libraries either have to be upgraded to use this new methodlogy or the dbms downgraded to use the older methodlogy.

For reference see

http://bugs.php.net/bug.php?id=30586&edit=1
http://dev.mysql.com/doc/mysql/en/Old_client.html

<<<<<<<

Posted by chris on April 14, 2005 04:01:46

There is a page about this issue, on the mysql site, you can use the command 'OLD_password'
in mysql command line to set the password so that the ACID client can access the dbase..
the mysql page is here.
http://dev.mysql.com/doc/mysql/en/old-client.html
this should allow ACID to connect to the database..
Hope this helps.
;-)