Author Topic: Setting up MySql (Read 7007 times)

MatHack · « **Reply #15 on:** February 13, 2006, 01:07:20 am »

$server = "localhost";

Balneator · « **Reply #16 on:** February 13, 2006, 11:16:08 am »

ok removed the % and it still throws me the same error, i just can't see where it's going wrong

Balneator · « **Reply #17 on:** February 13, 2006, 12:07:01 pm »

ok completely ripped out the entire thing and started again this time on php4 at first i got the same error as Gwitz, seemed to get past that by setting up the user permissions in SQLyog, but now i get "client does not support authentication protocol requested by server" any ideas?

edit: using the files posted by xenixa here: ftp://xen.afraid.org/bebot_files/bebot-php441.zip

Alreadythere · « **Reply #18 on:** February 13, 2006, 12:39:29 pm »

Quote from: Khalem on December 26, 2005, 03:08:52 pm

This will be what you're looking for:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

The mysql library that comes with your php is most likely a 4.0 version which means it doesn't understand the new password format in MySQL 4.1 and newer.
That webpage details the ways to get around it.

Check the link out, it should be what you need for that error.

Balneator · « **Reply #19 on:** February 13, 2006, 02:53:56 pm »

yep sorry i missed that, blinkers on

now i have the same problem as listed here: http://bebot.link/index.php/topic,33.0.html but i'm on windows so the aokex thing doesn't work for me :/

edit: using the updated AOchat-1171

Xenixa · « **Reply #20 on:** February 13, 2006, 08:53:18 pm »

If you're using PHP4 and that AOChat.php 1.17.1 you should most definatley not be getting any AOKex error. That extention isn't even referenced in 1.17.1. Sounds like you may have the newer copy from Auno installed some where in the bots path and the bot is trying to use it.

Basic Files that should be in the Bots root folder(don't confuse root with the root of the drive):

php.exe
php4ts.dll
php_bz2.dll
php_sockets.dll
php.ini
AOChat.php
Bot.php
main.php
MySQL.php
start.php

Make sure no copies of those files exsist in any of the folders under the Bots root folder.
BTW php4ts.dll isn't really needed on NT rigs but I leave it anyway. Actually I have it commented from loading in my php.ini file.

Balneator · « **Reply #21 on:** February 13, 2006, 09:19:42 pm »

it loads all the modules etc and then i get "Aochat: not expecting login" all the files seem fine all there no copies

Balneator · « **Reply #22 on:** February 13, 2006, 10:49:02 pm »

strange thing is in notepad the formatting in aochat seems very strange, large block of scrambled text. Seems to open ok in wordpad thoough

Balneator · « **Reply #23 on:** February 14, 2006, 12:37:52 am »

fixed the formatting and double checked the log in details etc and still nothing seems to befuddle everyone i talk to about it too :/

Khalem · « **Reply #24 on:** February 14, 2006, 04:29:11 am »

Please try the following php files in place of the ones you have now:
http://svn.shadow-realm.org:7100/svn/BeBot/trunk/php.exe
http://svn.shadow-realm.org:7100/svn/BeBot/trunk/php4ts.dll

Balneator · « **Reply #25 on:** February 14, 2006, 11:43:43 am »

Thanks that fixed it for me

eracet1 · « **Reply #26 on:** March 30, 2006, 05:17:39 pm »

I have been trying to get Bebot 0.2.3 to run.
I try Start.bat and seems to have problems getting connected to Mysql.
I installed normal SQL, and also tried Administrator.
When trying ot connect to MySql Server Instance on the Administrator it says cannot connect.
Using settings
ServerHost : Localhost Port 3306

Is this what I want to use?
And is Username and Password an AO one?

Please help me with this.

buff · « **Reply #27 on:** March 31, 2006, 06:22:50 am »

you will need to install MySQL server and it can be download from website free.
go google it and u will have the server version one to download
once you install MySQL 5 server it will ask you to configure instance and setup password for it
the default user name for it will be root and password will be whatever you put it
that user name and password will be what you wanna use in MySQL.conf for ur bebot.