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: Setting up MySql  (Read 7377 times)

0 Members and 1 Guest are viewing this topic.

MatHack

  • Guest
Re: Setting up MySql
« Reply #15 on: February 13, 2006, 01:07:20 am »
$server = "localhost";

Offline Balneator

  • BeBot Rookie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: Setting up MySql
« 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  ???

Offline Balneator

  • BeBot Rookie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: Setting up MySql
« 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
« Last Edit: February 13, 2006, 12:09:10 pm by Balneator »

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Setting up MySql
« Reply #18 on: February 13, 2006, 12:39:29 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.

Offline Balneator

  • BeBot Rookie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: Setting up MySql
« Reply #19 on: February 13, 2006, 02:53:56 pm »
yep sorry i missed that, blinkers on  ;D 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
« Last Edit: February 13, 2006, 02:58:37 pm by Balneator »

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: Setting up MySql
« 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.
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

Offline Balneator

  • BeBot Rookie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: Setting up MySql
« 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

Offline Balneator

  • BeBot Rookie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: Setting up MySql
« 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  ???

Offline Balneator

  • BeBot Rookie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: Setting up MySql
« 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 :/

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Re: Setting up MySql
« Reply #24 on: February 14, 2006, 04:29:11 am »
BeBot Founder and Fixer Kingpin

Offline Balneator

  • BeBot Rookie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: Setting up MySql
« Reply #25 on: February 14, 2006, 11:43:43 am »
Thanks that fixed it for me

Offline eracet1

  • BeBot User
  • **
  • Posts: 20
  • Karma: +0/-0
Re: Setting up MySql
« 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.


Offline buff

  • BeBot User
  • **
  • Posts: 36
  • Karma: +0/-0
Re: Setting up MySql
« 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.

 

* 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: 175
  • 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