Author Topic: another error (Read 1860 times)

Galadriell · « **on:** October 19, 2005, 05:21:52 am »

Ok. I finally figured out how to make a user, and did so. I got the AO extensions error, and removed

if(!extension_loaded("sockets"))
{
die("AOChat class needs the Sockets extension to work.\n");
}

from the AOchat.php.
Made all of the configurations. Put the php.exe and all the files included with it from this site in the same folder.

Created the database in mysql. Assigned everything to the user name I created. And now I get an error looking like this:

[Keine Verbindung zur Datenbank!] (Client does not support authentication protocol requested by server; consider upgrading MySQL client) Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Files\bebot\MySQL.php on line 36

Ive checked every thread on this forum, and found nothing that can help me. I see links sending me every which way, and when I get to the last link it doesnt help me at all because Im new to this:P so can someone plz help me?

I followed every step in the faq guide and in the guide that came with the bot

Xenixa · « **Reply #1 on:** October 19, 2005, 07:48:41 am »

In short:

Inside the \MySQL\MySQL Server 4.1\my.ini file

make the lines below look like:

#Start without grant tables. This gives all users FULL ACCESS to all tables!
skip-grant-tables
#Use old password encryption method (needed for 4.0 and older clients).
#old-passwords

Khalem · « **Reply #2 on:** October 20, 2005, 04:03:55 pm »

Alternatively, you need to get a hold of a php 4.x (preferably, i belive there might be some issues with php5 and bebot, not sure offhand) version that comes with an updated MySQL client library.

There was a client <-> server protocol change in MySQL 4.1. Clients older than 4.1.0 will not be able to understand the new protocol.

Zacix · « **Reply #3 on:** October 20, 2005, 04:24:31 pm »

Did you execute this SQL:
UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
WHERE Host = 'some_host' AND User = 'some_user';

FLUSH PRIVILEGES;

The error is probably because MySQL 4.1 and upwards has changed its password encryption or something. The above SQL should make it so it works like 4.0 again (which I think BeBot used when it first was developed).