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: Installing BeBot (Windows).  (Read 10550 times)

0 Members and 1 Guest are viewing this topic.

Offline Glarawyn

  • BeBot Hero
  • ******
  • Posts: 521
  • Karma: +0/-0
Installing BeBot (Windows).
« on: November 16, 2006, 09:41:03 pm »
To run BeBot you need three things. MySQL, PHP, and the BeBot files. MySQL is an open source database server. PHP is PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. Similar in function to ASP, Perl, VBS, etc. BeBot is what you're trying to run. :)

Phase 1: MySQL.
If you can't get MySQL setup and working, you won't be able to get a functioning bot. Start with my    
MySQL n00b guide
to get MySQL setup and ready for BeBot.

Phase 2: BeBot & PHP:
Kahlem has provided a PHP Bundle to run with BeBot. The PHP support files have been separated from the BeBot files to ease updating.

You can install the bot in any directory you wish, however I'm going to use C:\BeBot for simplicity.

Extract the bot files to C:\BeBot. Then extact the php bundle to the same directory. The contents of c:\BeBot should now look something like:

  • conf/
  • core/
  • extras/
  • help/
  • IRC/
  • log/
  • modules/
  • php_extension/
  • txt/
  • AOChat.php
  • Bot.php
  • Changelog
  • gmp.dll
  • INSTALL_GUILDBOT.txt
  • INSTALL_RAIDBOT.txt
  • libmysql.dll
  • Licence.txt
  • License.txt
  • main.php
  • MySQL.php
  • php5rs.dll
  • php.exe
  • php.ini
  • start.bat
  • start.php
  • update.php

Using your favorite text editor, edit the files conf/Bot.conf and conf/MySQL.conf to match your AO Account Info, Guild Info, and MySQL configuration.

Start the bot by running the start.bat file. If you did things right, the bot will start up and connect to the AO chat servers.

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Re: Installing BeBot (Windows).
« Reply #1 on: November 16, 2006, 10:10:11 pm »
BeBot Founder and Fixer Kingpin

Offline Nova

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #2 on: November 23, 2006, 06:47:39 am »
Ok. I did the mysql as well as I could (Took me a bit) and now I'm stuck on (Drumroll) BeBot!
I configured the .conf files by changing name from .conf to .txt and editing then saving and renaming back to .conf. Doing good so far.
Now I got to run the "Start.bat" file and guess what?

"'php' is not recognized as an internal or external command,
operable program or batch file.

C:\BeBot>pause
Press any key to continue . . ."

It STAYS this way. When I press any key it closes. Making no visible effect.
A few questions;
1) Is it correct that you should run bot on a diferent accaunt? I have a Froob accaunt RK1 for this purpose.
2) Is phase 5 Necesary for BeBot to run? Because I seem to be unable to do it;

"Microsoft Windows XP [Version 5.1.2600]
<C> Copyright blahblahblah

C:\Documents and Settings\Owner>mysql -u orothrim -p bebot < c:\bebot\items.sql;

The system cannot find the file specified.

C:\documents and settings\owner>"

All help aprecciated.
Now I'm going to bed. My bum hurts my eyes are watery and I have a mothelode Headache for sitting here for 4 hours trying to figutre the damn thing out. Blasted scripts!
« Last Edit: November 23, 2006, 07:22:13 pm by Nova »

Offline Vhab

  • Contributor
  • *******
  • Posts: 180
  • Karma: +0/-0
    • VhaBot Forum
Re: Installing BeBot (Windows).
« Reply #3 on: November 23, 2006, 07:23:22 am »
please edit out those account details asap and change your password asap!

more on topic: it seems you didn't have the php-bundle downloaded or copied to the directory of your bot.
and the mysql error indicates you didn't download mysql.

also, you don't need to (but you can) run the bot on a different account, just a different character.

Offline neongen

  • BeBot User
  • **
  • Posts: 64
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #4 on: November 23, 2006, 04:29:10 pm »
Quote
'php' is not recognized as an internal or external command,
operable program or batch file.

there you need to go into start.php and edit $php_bin = "php"; to $php_bin = "php.exe";

Quote
C:\Documents and Settings\Owner>mysql -u orothrim -p bebot < c:\bebot\items.sql;

The system cannot find the file specified.

make sure the file is there... the new bebot's don't have it anymore but it's still in the install guide for some reason i don't know  ;)

Offline Nova

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #5 on: November 23, 2006, 07:07:57 pm »
Quote
more on topic: it seems you didn't have the php-bundle downloaded or copied to the directory of your bot.
and the mysql error indicates you didn't download mysql.

also, you don't need to (but you can) run the bot on a different account, just a different character.

Didn't download? But It took the Create Database and so on commands perfectly.
If I hadn't downloaded it would have said "Cannot find file\script MySQL" or somesuch wouldn't it?
I unzipped the .php bundle to C:\BeBot where I have the Bot files themselves.

Quote
there you need to go into start.php and edit $php_bin = "php"; to $php_bin = "php.exe";

1) It is set to php.exe

Quote
make sure the file is there... the new bebot's don't have it anymore but it's still in the install guide for some reason i don't know  ;)

2) I can live without the item register. Is it a requirement for the bot to run right?
« Last Edit: November 23, 2006, 07:29:59 pm by Nova »

Offline Vhab

  • Contributor
  • *******
  • Posts: 180
  • Karma: +0/-0
    • VhaBot Forum
Re: Installing BeBot (Windows).
« Reply #6 on: November 23, 2006, 08:04:34 pm »
they changed items module a while back, it no longer uses that itemsdatabase.
so it'll run fine without. just ignore it said that in the guide.

Offline Nova

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #7 on: November 23, 2006, 08:18:18 pm »
ok I got it.
Now it does start out as a BeBot but on the $Server line when I put in my Nova@localhost it says;

Warning: mysql_connect<>: Unknown MySQL server host 'Nova@localhost' <11001> in C:\BeBot\MySQL.php on line 63
MySQL error <# 0> on query; Cannot connect to the database server!
Unknown MySQL server host 'Nova@localhost' <11001>

C:\BeBot>pause
Press any key to continue...

Now what?

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #8 on: November 23, 2006, 09:44:48 pm »
Nova seems to be your mysql user.
localhost is your mysql server.

Offline Nova

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #9 on: November 24, 2006, 01:06:46 am »
Ok corrected that now it says;

Acces denied for user 'Nova'@'localhost' <Using password: YES)
In C:\BeBot\MySQL.php on line 63

OMG does it never end?

Offline edgehead

  • BeBot Rookie
  • *
  • Posts: 5
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #10 on: November 24, 2006, 03:30:13 am »
I had the same problem, chances are you forgot to add ; after every command on mysql window (LIKE I DID).

Ex: Phase 4: Create a Database and Database User for BeBot
1. Type CREATE DATABASE databasename; (replace databasename with the name of the database you wish to create)

What I type (EXACTLY) was this: CREATE DATABASE bebot

What I should have typed was: CREATE DATABASE bebot;

Try and see if that makes a difference

Offline Nova

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #11 on: November 24, 2006, 04:20:19 am »
No its not that. Aparently my password has to be a 41 digit Hexadecimal number and I have no clue what the heck that is.

Offline neongen

  • BeBot User
  • **
  • Posts: 64
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #12 on: November 24, 2006, 04:59:21 am »
did you do
Type GRANT ALL on databasename.* TO username@localhost; (Again, change databasename and username, keep @localhost)
???

about the paasword i don't know i use password on 7 number
« Last Edit: November 24, 2006, 05:02:27 am by neongen »

Offline Glarawyn

  • BeBot Hero
  • ******
  • Posts: 521
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #13 on: November 24, 2006, 05:27:57 am »
In your MySQL.conf, remove @localhost from your user name. You seem to have missed this in my instructions.

For the items.sql, there is big red text that states IMPORTANT: This only applies for BeBot version older than 0.2.4.

As you've skipped some key parts in the instructions already, I would suggest a careful rereading of the instructions for anything you may have missed. That might shed some light on your troubles.

Since your stuck on php not found, did you download and install the php bundle? Do the contents of your bebot directory matches the contents posted? If not, figure out where you went wrong, you may need to move the php bundle files or something.

Offline Nova

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Installing BeBot (Windows).
« Reply #14 on: November 24, 2006, 02:12:36 pm »
I am mostly doing this before or after work so I'm somewhat fuzzy.
Patience please. This is my first bot and the first time I've messed with PHP.
I had forgotten what version of BeBot I had installed. Don't know why i didn't look it up.
This is what I did;

Quote
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Owner>mysql -u root -p
Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.27-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE Bot;
Query OK, 1 row affected (0.03 sec)

mysql> CREATE USER Nova@localhost;
Query OK, 0 rows affected (0.03 sec)

mysql> SET PASSWORD FOR Nova@localhost = '*******';
ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
mysql> SET PASSWORD FOR Nova@localhost = '******************************';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL on Bot.* TO Nova@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

Current settings;

 
Quote
$dbase = "Bot";
    $user = "Nova";
    $pass = "*************************************";
    $server = "localhost";

The password is what is not working properly I think because when I try to log it on:

Quote
(BeBot Logo deleted because of size)
Warning: mysql_connect(): Access denied for user 'Nova'@'localhost' (using password: YES) in C:\BeBot\MySQL.php on line 63
MySQL error (# 0) on query: Cannot connect to the database server!
Access denied for user 'Nova'@'localhost' (using password: YES)

C:\BeBot>pause
Press any key to continue . . .

I have all the files listed.
« Last Edit: November 24, 2006, 02:42:35 pm by Nova »

 

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