BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: dragonjr on May 11, 2013, 03:02:52 pm
-
================================================
_/_/_/ _/_/_/ _/
_/ _/ _/_/ _/ _/ _/_/ _/_/_/_/
_/_/_/ _/_/_/_/ _/_/_/ _/ _/ _/
_/ _/ _/ _/ _/ _/ _/ _/
_/_/_/ _/_/_/ _/_/_/ _/_/ _/_/
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
-
I would start by making sure that your MySQL is running before you try to start your bot.
Shelly
-
and how would i do that would i just start the cmd and log into mysql?
-
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.
-
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?
-
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
-
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.
-
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 (http://bebot.link/helpful-posts/mysql-n00b-help/msg18489/#msg18489)
This was snipped from http://bebot.link/helpful-posts/bebot-on-linux/ (http://bebot.link/helpful-posts/bebot-on-linux/). It's for Linux, but this part is the setup for MySQL.
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;
-
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
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>
-
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
-
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?
-
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.
<?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
-
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?
-
C:\Users\Chris>mysql -u dragon -p
Enter password: ********
What happens when you enter this?
-
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>
-
Sorry for the delay in posting... A this point you have me stumped as to where your problem is. Did you try starting your bot "runas administrator"?
-
no i haven't don't even know where to start on that one. but im glad i have everything else up to par and im doing everything else right. the problem hasn't happened now for about a month. but running the bot in the mode you have mention what does that do to the bot and does it effect the way it works in game?
-
It does not affect how it runs in came, but gives it a bit more authority in the Windows OS is all.
-
ok the issue just happened today and i noticed my internet took a bit to start up but i went into MySQL and tried to log into the server like you suggested and this is what i got.
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Chris>mysql -u root -p
Enter password: ********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
C:\Users\Chris>
C:\Users\Chris>mysql -u root -p
Enter password: ********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
C:\Users\Chris>mysql -u root -p
Enter password: *********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
C:\Users\Chris>
C:\Users\Chris>mysql -u root -p
Enter password: *********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
C:\Users\Chris>
as you can tell i tried many times to get it to sign in and i even tried the dragon one as well and got the same results.
do you think this is happening because of something else going on with my computer ?
-
That would be because your MySQL application is not starting up most likely. Check your services and see if it is running.
-
ok and how would i go about do that ? could you explain please
thank you
-
Unfortunately, I am not a windows person. I would suggest perhaps going to the MySQL site and seeing what they have there for help with that on Windows.
Check out the URLs in this post for help --> http://bebot.link/helpful-posts/mysql-n00b-help/msg18489/#msg18489 (http://bebot.link/helpful-posts/mysql-n00b-help/msg18489/#msg18489)
Sorry I am not more help there,
Shelly
-
ok
thank you for all your help and time . you've helped me a lot
-
ok it looks like the problem isnt going to go away it started to have the issue yet again so i think there is a issue with windows so correct me if im wrong if you could please
if i re-instal windows im going to have to re-instal the bot now would i have to do all the steps all over again down loading mysql and creating a data base and a server .
then take the back up that i have and re-instal that as well, or can i just re-instal mysql and put the back up in there after that ???
thanks again for your help and time so i dont screw things up.
-
You should be able to export your database from MySQL tools. Then after you reinstall ... import that to your MySQL. that way when you restart your bot, should come right up. I would also suggest that you keep a backup of your <bothome>\conf folder. It should keep you from having to resetup your bot from scratch.
If you reinstall windows, yes you will need to reinstall the Bot & MySQL. Then you can recover from the backups of the database and conf folder.
Shelly
-
ok thank you very much