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

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

Author Topic: cant start bot  (Read 20539 times)

0 Members and 2 Guests are viewing this topic.

Offline clashbot

  • BeBot Expert
  • ****
  • Posts: 295
  • Karma: +0/-0
    • Ascension's Home
Re: cant start bot
« Reply #30 on: June 17, 2008, 09:26:42 pm »
ok, somewhere that user got a little hosed, but you might be able to salvage it, if you configure you mysql.conf to match that....not sure if it will work, but wouldn't be the first time I've taken a sledghammer to a ten-penny nail..

Offline darcek

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
  • Dedicated User
Re: cant start bot
« Reply #31 on: June 17, 2008, 09:32:04 pm »
Seems like this can go on for days doh...
after changing user to darcek insted of darcek@localhost i get the following error :

Client does not support authentication protocol requested by the server ;consider upgrading MySQL client ???

Offline clashbot

  • BeBot Expert
  • ****
  • Posts: 295
  • Karma: +0/-0
    • Ascension's Home
Re: cant start bot
« Reply #32 on: June 17, 2008, 09:35:51 pm »
lol..ok, well now you are heading into the realms of areas I am not good at...

Offline darcek

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
  • Dedicated User
Re: cant start bot
« Reply #33 on: June 17, 2008, 09:38:46 pm »
i dont want realms i just want to activate this bot doh  ::)

Offline clashbot

  • BeBot Expert
  • ****
  • Posts: 295
  • Karma: +0/-0
    • Ascension's Home
Re: cant start bot
« Reply #34 on: June 17, 2008, 09:41:37 pm »
lol..hopefully one of the other guys here can lead you a little better from here...sorry I couldn't help more..but I am not familiar with that problem...

Offline darcek

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
  • Dedicated User
Re: cant start bot
« Reply #35 on: June 17, 2008, 09:45:10 pm »
also getting MySQL error (#0) on query:Cannot connect to the database server!

other stuff that might went wrong:
this line: Type GRANT ALL on databasename.* TO username@localhost;

i typed: GRANT ALL on ao.* TO darcek@localhost;
does that seem ok?

Offline darcek

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
  • Dedicated User
Re: cant start bot
« Reply #36 on: June 17, 2008, 09:46:45 pm »
well time to give up i guss...if anyone else have any insights ide appricate it..and thx clashbot for trying to help me...good night

Offline clashbot

  • BeBot Expert
  • ****
  • Posts: 295
  • Karma: +0/-0
    • Ascension's Home
Re: cant start bot
« Reply #37 on: June 17, 2008, 09:48:32 pm »
yeah the grants look ok

Offline clashbot

  • BeBot Expert
  • ****
  • Posts: 295
  • Karma: +0/-0
    • Ascension's Home
Re: cant start bot
« Reply #38 on: June 17, 2008, 09:49:15 pm »
as long as AO is the database name... and darcek is the user name...

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: cant start bot
« Reply #39 on: June 17, 2008, 11:41:14 pm »
wat os?

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: cant start bot
« Reply #40 on: June 17, 2008, 11:43:59 pm »
if windows
try putting the files inside php_extensions at c:/php5/
not the folder just the files inside

Offline darcek

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
  • Dedicated User
Re: cant start bot
« Reply #41 on: June 18, 2008, 05:35:05 am »
thx for the help but now my problem is not the PHP anymore but mysql...

only thing i can think of is mayby the sql version is too new..so will look for an older version.

the os btw is WIN XP SP3

Offline darcek

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
  • Dedicated User
Re: cant start bot
« Reply #42 on: June 18, 2008, 06:19:36 am »
Amazing..the more i try the more problems show up.... :o
Ive found an earlier version of MySQL v.4.1.9..earlier one i could find atm...started a fresh installation...when writing the line :
CREATE USER darcek@localhost ; ive got an error telling me :ERROR 1064 (42000):you have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use.
 ???
any ideas?

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Re: cant start bot
« Reply #43 on: June 19, 2008, 11:51:51 am »
Seems like this can go on for days doh...
after changing user to darcek insted of darcek@localhost i get the following error :

Client does not support authentication protocol requested by the server ;consider upgrading MySQL client ???

This error is caused by the MySQL client (in this case, your PHP MySQL library) not supporting the newer authentication protocol of the MySQL server.

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

If you are going to downgrade the server, downgrade to 4.1.22, not older.

If you are using the PHP files from BeBot's distribution, using MySQL 5.x should not be an issue at all.
BeBot Founder and Fixer Kingpin

Offline darcek

  • BeBot User
  • **
  • Posts: 29
  • Karma: +0/-0
  • Dedicated User
Re: cant start bot
« Reply #44 on: June 19, 2008, 02:56:17 pm »
Thx for the reply Khal...
ok...so ill go back using te newest SQL...
so i actually should use user only without the @local host?
ill check the thread you posted indept when i reach home..im not giving up yet..and mayby with your help ill be able to pull this out...thx again ;D
Will post again with update after i make all the changes..

 

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


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


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


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 490
  • 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