BeBot - An Anarchy Online and Age Of Conan chat automaton
		Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: Gladiatorrr on April 02, 2007, 01:42:10 pm 
		
			
			- 
				Hello,
I want to use BeBot for my Guild, but some reason, it doesn't want to start. 
I have installed / configured MySQL  following the manual 
I have Editted Bot.conf / MySQL.conf the right way ( I think ) 
And now, when I try to open start.php ( Using CMD  -   C:\BeBot\php start.php )    
It sais:   Could not open input file: start.php     
Could anyone help me please?  I've searched for the answer on this forums but I cant seem to find it.. 
Thanks in advance :) 
			 
			
			- 
				Did you execute that command in the directory that contains start.php?
Otherwise php got no clue where to look :)
			 
			
			- 
				I did... I think :p 
			
 
			
			- 
				I think "the preferred way"tm to start the bot is to: 
- Start a command line interpeter with START->Run->"cmd"[ENTER]
 - Change directory to where the bot is (in your case: cd \BeBot)
 - Run startbot.bat (the .bat extention is optional)
 
  
Hope that helps.
			 
			
			- 
				What do you mean by:  
Change directory to where the bot is (in your case: cd \BeBot)
?
If I run startbot.bat I get an other error -_- 
MySQL error (# 0) on query: Database not found or insufficient priviledges!
Access denied for user 'Blackbt'@'localhost' to database 'anarchy'
Tho I am pretty sure that the Database is installed correct. 
			 
			
			- 
				Check username and password for that database + your sql server, if no luck try making new ones
			
 
			
			- 
				I already did.. I've reinstalled the complete progess like 3 times keep getting the same error :s 
And for the simplicity I've putted the same name / password onto everything so I cant mess things up... still not working :s 
			 
			
			- 
				Maybe a problem with permissions?
			
 
			
			- 
				Ok, two likely scenarioes comes to mind here.
A) You have not granted access to the user Blackbt to the table anarchy or forgot to reload the privileges after such a grant has been made. To do this log into your MySQL server as root and type the commands: 
GRANT ALL ON anarchy.* TO Blackbt@localhost IDENTIFIED BY 'passwordHere';
FLUSH PRIVILEGES;
or 
B) The username is case sensitive so you might have granted access to blackbt@localhost or BlackBt@localhost or some other similar name. (perhaps even BlackBot@localhost). To verify this beyond all odds you can log into your MySQL server as root and type the commands:
use mysql;
SELECT * FROM db WHERE User='Blackbt';
It should yeld a reply similar to:
+-----------+------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| Host      | Db         | User      | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv |
+-----------+------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| localhost | anarchy    | Blackbt   | Y           | Y           | Y           | Y           | Y           | Y         | N          | Y               | Y          | Y          | Y                     | Y                | Y                | Y              | Y                   | Y                  | Y            |
+-----------+------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
Now if this lines is filled with 'N's or does not return see point A.
I hope that helps.
Note: To log in to your MySQL server as root type the command at the command line: mysql.exe -u root -p
Then at the prompt provide the root password you have set. (You have set a root password, haven't you?)
			 
			
			- 
				heey 
sorry for the very very late response, but it worked =)  
Thanks guys! 
Thank you so much I love the bot:)