collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18366
  • stats Total Topics: 2501
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Greetings  (Read 6942 times)

0 Members and 1 Guest are viewing this topic.

Offline sokapi

  • BeBot Rookie
  • *
  • Posts: 2
  • Karma: +0/-0
Greetings
« 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

Offline Blondengy

  • BeBot Creator and Founder
  • BeBot Hero
  • ******
  • Posts: 51
  • Karma: +0/-0
Greetings
« Reply #1 on: January 04, 2005, 03:49:56 am »
Windows? Linux? What php version? (If linux what php4-mysql version?)

Need a few more infos here to help you. ;)

Offline sokapi

  • BeBot Rookie
  • *
  • Posts: 2
  • Karma: +0/-0
Greetings
« Reply #2 on: January 04, 2005, 03:34:50 pm »
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";
?>

Offline Zevita

  • BeBot Rookie
  • *
  • Posts: 1
  • Karma: +0/-0
Greetings
« Reply #3 on: January 07, 2005, 04:28:40 pm »
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

Offline Sputnik

  • BeBot Rookie
  • *
  • Posts: 14
  • Karma: +0/-0
Greetings
« Reply #4 on: January 19, 2005, 10:47:42 pm »
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.

Offline Jasper2002

  • BeBot Rookie
  • *
  • Posts: 6
  • Karma: +0/-0
Greetings
« Reply #5 on: March 16, 2005, 09:51:35 am »
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.

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Greetings
« Reply #6 on: March 24, 2005, 10:18:05 pm »
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.
BeBot Founder and Fixer Kingpin

Offline Ltes

  • BeBot User
  • **
  • Posts: 34
  • Karma: +0/-0
    • http://www.ltes.cjb.net/
Greetings
« Reply #7 on: April 25, 2005, 03:44:09 am »
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 :)


[size=18]Ltes

*RK2*[/size]

Offline Pudz

  • BeBot Rookie
  • *
  • Posts: 3
  • Karma: +0/-0
Greetings
« Reply #8 on: June 02, 2005, 05:16:10 pm »
anybody on?

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm ]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am ]

* Who's Online
  • Dot Guests: 397
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal