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: having a issue starting bot  (Read 10259 times)

0 Members and 1 Guest are viewing this topic.

Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
having a issue starting bot
« on: May 11, 2013, 03:02:52 pm »
Code: [Select]
================================================

    _/_/_/              _/_/_/                _/

   _/    _/    _/_/    _/    _/    _/_/    _/_/_/_/

  _/_/_/    _/_/_/_/  _/_/_/    _/    _/    _/

 _/    _/  _/        _/    _/  _/    _/    _/

_/_/_/      _/_/_/  _/_/_/      _/_/        _/_/

         An Anarchy Online Chat Automaton

                     And

          An Age of Conan Chat Automaton

         v.0.6.8 - PHP 5.3.3

                 OS: Windows_NT

        Your operating system is detected as 32bit

===================================================

Curl extension loaded

Warning: mysql_connect(): [2002] A connection attempt failed because the connect
ed party did not  (trying to connect via tcp://127.0.0.1:3306) in C:\bebot\Sourc
es\MySQL.php on line 129

Warning: mysql_connect(): A connection attempt failed because the connected part
y did not properly respond after a period of time, or established connection fai
led because connected host has failed to respond.
 in C:\bebot\Sources\MySQL.php on line 129
MySQL ERROR(# 1) on query: Cannot connect to the database server at 127.0.0.1 as
 user dragon!
A connection attempt failed because the connected party did not properly respond
 after a period of time, or established connection failed because connected host
 has failed to respond.
i see this once in a while and i leave the computer off for a day or just leave the bot off for a day or so and it fixes it self sometimes but what is causeing this to happen so that i can fix it ?it was working fine last night.
any help would be great
thanks

Offline Shelly

  • BeBot Apprentice
  • ***
  • Posts: 192
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #1 on: May 12, 2013, 03:45:46 am »
I would start by making sure that your MySQL is running before you try to start your bot.

Shelly

Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #2 on: May 12, 2013, 12:53:15 pm »
and how would i  do that  would i just start the cmd and log into mysql?

Offline WeZoN

  • Global Moderator
  • *****
  • Posts: 92
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #3 on: May 14, 2013, 12:56:31 pm »
The bot needs a mysql server to save all it's details.

If you have installed one you will need to start it.
If you haven't set one up then go ahead and do so.


Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #4 on: May 15, 2013, 02:01:46 am »
i thought i created on when i created the bot on the computer. is that what you do when you down load the bot and set up mysql?

Offline Shelly

  • BeBot Apprentice
  • ***
  • Posts: 192
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #5 on: May 26, 2013, 11:58:05 pm »
i thought i created on when i created the bot on the computer. is that what you do when you down load the bot and set up mysql?

Downloading the bot does not come with MySQL. For that you need to get and install MySQL separately.

Shelly

Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #6 on: May 27, 2013, 10:01:14 pm »
but i thought that what i did.
i thought i had to get MySQL before i could even get the bot running?
Phase 1: MySQL Installer
1. Click Next.
2. Select Typical, Click Next.
3. Click Install.
4. Select Skip Sign-Up, Click Next.
5. Check Configure MySQL Server Now, Click Finish.
« Last Edit: May 27, 2013, 10:18:48 pm by dragonjr »

Offline Shelly

  • BeBot Apprentice
  • ***
  • Posts: 192
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #7 on: May 29, 2013, 02:54:54 am »
Dragonjr,

You may want to look over this post also as both seem to be similar... --> http://bebot.link/helpful-posts/mysql-n00b-help/msg18489/#msg18489

This was snipped from http://bebot.link/helpful-posts/bebot-on-linux/. It's for Linux, but this part is the setup for MySQL.
Code: [Select]
5) Configure the mysql database
   Log into mysql
      $ mysql -u root

   Create the database.  I called mine bebot (don't forget the semi-colon at the end of the line)
      mysql> CREATE DATABASE bebot;

   Make the new database the one you're issuing commands to
      mysql> USE bebot;

   Upload the items db file into the database. 
   I put my bebot directory in my home directory, so I used:
      mysql> SOURCE /home/MyUserName/bebot/items.sql;

   You'll get a ton of lines updated messages, and then everything is loaded

   Create a user in mysql that the bot can logon with
   This command gives the user "bebot" access to all tables on database bebot
   If they log in from the local host with the password 'bebotpassword'
   Again, don't forget the semi-colon on the second line but not the first
      mysql> GRANT ALL PRIVILEGES ON bebot.* TO 'bebot'@'localhost'
          -> IDENTIFIED BY 'bebotpassword' WITH GRANT OPTION;

Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #8 on: May 29, 2013, 03:48:32 am »
First i want to say thank you for all the time you  are taking to get me threw this mess that i think i have.
i might be wrong but is this the server you are refering to
Code: [Select]
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Chris>mtsql -u root -p
'mtsql' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Chris>mysql -u root -p
Enter password: ********
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)

C:\Users\Chris>mysql -u root -p
Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.50-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
« Last Edit: May 29, 2013, 03:56:19 am by dragonjr »

Offline Shelly

  • BeBot Apprentice
  • ***
  • Posts: 192
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #9 on: June 01, 2013, 04:20:29 am »
That be right... so you need to make sure that userid and password are entered in your <bothome>\conf\botname.MySQL.conf

*Incorrect parts removed from post
Shelly
« Last Edit: June 01, 2013, 02:31:40 pm by Shelly »

Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #10 on: June 01, 2013, 11:35:16 am »
so the info you are showing me do i type something on the cmd - MySQL
or is this in the C:\bebot and look for this info in the file there?

Offline Shelly

  • BeBot Apprentice
  • ***
  • Posts: 192
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #11 on: June 01, 2013, 02:29:13 pm »
so the info you are showing me do i type something on the cmd - MySQL
or is this in the C:\bebot and look for this info in the file there?
This will be in your C:\bebot\conf folder
And I apologize the snippit was for a different bot. Here is where your stuff should go.

This is from C:\bebot\conf\MySQL.conf.TEMPLATE (I added a bit for what I could glean from your posts.
Code: [Select]
<?php
        
/*
        Database name
        */
        
$dbase "bebot";

        
/*
        Database username
        */
        
$user "root";

        
/*
        Database password
        */
        
$pass "whatever you set the password to";

        
/*
        Database server (usually localhost)
        */
        
$server "localhost";

        
/*
        Database table prefix
        The bot will use <botname> as prefix on default, you only need to change this entry if you
        want a different prefix or none at all, in which case you have to set it to an empty
        string ("").
        If you want a different or no prefix you will have to uncomment the line below by removing
        the // in front of it and set it to the wished value.
        you may also use <botname> as part of the string and it will be replaces with the botname in lowercase
        */
        // $table_prefix = "";

        /*
        If you have $table_prefix Defined your tables will be prefixed as above with a _ added on
        if you dont want the _ added uncomment below
        */
        //$nounderscore = TRUE;

        /*
        Master prefix table.
        This is the mastertable containing information about all tablenames and whether those use
        or don't use a prefix. Only uncomment the line below by removing the // in front of it if
        you want to use a different mastertable then botname_tablenames, which is used on default.
        you may also use <botname> as part of the string and it will be replaces with the botname in lowercase
        */
        // $master_tablename = "botname_tablenames";
?>

Normally this would be a file called <botname>.MySQL.conf in your c:\bebot\conf\ folder.

Shelly

Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #12 on: June 01, 2013, 05:15:19 pm »
ok i have that but i ahve one thing that doesnt match
 Database username
        */
        $user = "root";
mine says
 Database username
        */
        $user = "dragon";
is that going to be a problem?

Offline Shelly

  • BeBot Apprentice
  • ***
  • Posts: 192
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #13 on: June 02, 2013, 01:17:12 am »
C:\Users\Chris>mysql -u dragon -p
Enter password: ********
What happens when you enter this?

Offline dragonjr

  • BeBot Apprentice
  • ***
  • Posts: 131
  • Karma: +0/-0
Re: having a issue starting bot
« Reply #14 on: June 02, 2013, 01:02:13 pm »
Code: [Select]
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Chris>mysql -u dragon -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.50-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 

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