BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: sokapi on January 04, 2005, 02:39:08 am
-
Heya's, I thought I'd try and install your bot, and I got as far, as to where the bot is starting up, but keeps spamming the console with
"Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in xxx\MySQL.php on line 36"
I know it can connect to the database as it respond to wrong username and such, I'm currently using MySQL Server 4.1. Any idea how to fix this? As I'm totaly green when it comes to SQL.. :P
-
Windows? Linux? What php version? (If linux what php4-mysql version?)
Need a few more infos here to help you. ;)
-
Useing Windows, and I got that PHP version you had for download. :P 4.3.10 I think it was.
Here's the MySQL.conf, if that helps. :)
<?
$dbase = "ao_test";
$user = "ao_bot";
$pass = "XXX";
$server = "192.168.1.100";
?>
-
Seems I may have similar problem here. Have used other helps that have been posted so far and dowloaded the php files you have posted on the forum here.
I got:
Windows XP, service pack 2
Server: MySQL 4.1.7-nt via TCP/IP
Client: MySQL Client version 5.0.0
Error message I get is:
Warning: mysql_connect(): Client does not support authentication protocol reques
ted by server; consider upgrading MySQL client in C:\Program Files\AObot\BEBot\M
ySQL.php on line 36
[Keine Verbindung zur Datenbank!] (Client does not support authentication protoc
ol requested by server; consider upgrading MySQL client)
I am not very exp in mysql so hope I have gotten the info you need to give in anyhelp.
Best Regards
-
i had the same problem till i downloaded administrator for mysql. And when to start up variables then to security and put a check in use old passwords. Then restarted the server. After that i made the dbase. then made the user with grant all on that database. Then it worked fine.
-
Awesome tip, saved me loads of aggro.
Spent 3 hours trying to migrate the code to support the latest revision of Apache, PHP and MySQL, then found this and reinstalled BeBot and it worked.
Would it be possible to take things like this and have a sticky - Tips post containing these snippets.
-
There was changes related to passwords aswell as client <-> server protocols in MySQL 4.1 from what i can recall, and client libraries not updated to handle these changes are incompactible with MySQL 4.1
Make sure that your php version is compiled against the 4.1 client libraries or you will end up with problems in one way or another for sure.
-
Just adding the snippit here that when i got this error message i had to make a new user for the bot, couldnt just connect using the root error. I dont know if everyone but me knew this but i thought i'd throw it out there :)
-
anybody on?