collapse collapse
Menu
  • Home
  • Archives
    • * User Info
     
     
    Welcome, Guest. Please login or register.
    * Search

    * Board Stats
    • stats Total Members: 989
    • stats Total Posts: 18365
    • stats Total Topics: 2500
    • stats Total Categories: 7
    • stats Total Boards: 35
    • stats Most Online: 1144
    « previous next »
    Pages: 1 2 [3] 4   Go Down

    Author Topic: cant start bot  (Read 40900 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..
    Logged

    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 ???
    Logged

    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...
    Logged

    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  ::)
    Logged

    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...
    Logged

    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?
    Logged

    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
    Logged

    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
    Logged

    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...
    Logged

    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?
    Logged

    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
    Logged

    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
    Logged

    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?
    Logged

    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 »
    Quote from: darcek 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 ???

    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.
    Logged
    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..
    Logged
    Pages: 1 2 [3] 4   Go Up
    « previous next »
     
    * Recent Posts
    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 ]
    Bebot and Rasberry by bitnykk
    [November 29, 2023, 11:04:14 pm ]
    * Who's Online
    • Dot Guests: 135
    • 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