Author Topic: Got problem, what do i wrong ? (Read 13488 times)

craized · « **Reply #15 on:** January 26, 2005, 10:12:03 am »

You have to have your own MySQL database, it isn't anything specific for RK2. If you have mysql installed on the same box you're running the bot off of, then the server would be localhost. You have to set up a user and password for mysql as well, which you will then put into MySQL.conf. Once you have it set up, log into mysql using

Code: [Select]

mysql -u <username> -p
(prompts for password)

then type:

Code: [Select]

CREATE DATABASE <dbname>;
use bebot or your bots name as the dbname for organization.
then, type

Code: [Select]

use <dbname>;
source <path/to/items.sql>;

Then wait for the items database to upload into yoru newly created database! Finally, log out of mysql using

Code: [Select]


exit

You're all set to use your bot now.
You can get mysql from http://dev.mysql.com/downloads/mysql/4.1.html

Also, congradulations on the resolution of your old problem, but I still find it hard to believe that worked.

Paganizer · « **Reply #16 on:** January 26, 2005, 05:13:42 pm »

ok i will check this out later.. need to find out where to put evreything first

but if i tryed it i will let u know if it worked or not]]
thanks

Paganizer · « **Reply #17 on:** January 26, 2005, 05:19:24 pm »

got a mysql now.... but what do i do now must i put the codes u gave in mysql.conf ?
couse i see :

<?
$dbase = "";
$user = "";
$pass = "";
$server = "";
?>

$server = ""; <-- my own ip or something ?

Sputnik · « **Reply #18 on:** January 26, 2005, 07:38:49 pm »

<?
$dbase = "";
$user = "";
$pass = "";
$server = "";
?>

Lets assume you got you mysql server working and you have a schema named bebot and the user is thebot and password is 12345 and you have given thebot user GRANT ALL priviledges to the bebot schema. This is wht the info would look like.

dbase= "bebot";
user= "thebot";
pass= "12345";
server= "localhost";

craized · « **Reply #19 on:** January 26, 2005, 09:48:22 pm »

To create a MySQL user, type

Code: [Select]


GRANT ALL PRIVILEGES ON <dbname>.* TO <username>
IDENTIFIED BY <password>;

Normally I would expect you to find this information on your own, but the MySQL documentation is fairly hard to comprehend.

Paganizer · « **Reply #20 on:** January 26, 2005, 10:37:21 pm »

Warning: Mysql_connect(): Access denied for user 'Paganizer'@'...my ip here...' (using password: YES) in C:\documents and settings\ikee16\MySQL.php on line 36...........................

help ? :cry: :cry:

craized · « **Reply #21 on:** January 26, 2005, 11:02:12 pm »

Is the MySQL db on the same box, or on a different one?
If its on the same box, then you don't need to put @<your ip>.
Also, Usernames and passwords are case sensitive.

Paganizer · « **Reply #22 on:** January 29, 2005, 09:50:15 pm »

hm i already dont understand it

But other guy in guild got it runned now, he had same problem as i had first but its fixed by him
so thanks for the help

:D:D its ok now

Empyreanwolf · « **Reply #23 on:** May 17, 2005, 02:19:47 pm »

I am havin the same problem as him above . and i follow all the steps and the problem still occurs, i got the error....

[Keine Verbindung zur Datenbank!] Access denied for user 'bebot' (using password: YES)

i try alot of method but some of the mare too confusin :cry:

Kate · « **Reply #24 on:** May 17, 2005, 02:28:08 pm »

Are you Sure you did the mysql command like (see below), as the root user?

GRANT ALL PRIVILEGES ON bebot.* TO 'user'@'localhost' IDENTIFIED BY 'password';

Empyreanwolf · « **Reply #25 on:** May 17, 2005, 03:27:03 pm »

Ok thanks got it runnin ! now i need to configure it......

Now it is sayin

To [Unholywolf]: !help
[Unholywolf]: I only listen to members of this bot.

i am makin a raid bot and i have put

$super_admin["Empyreanwolf"] = true;

wat step did i miss ?

Ltes · « **Reply #26 on:** May 18, 2005, 12:44:14 am »

Quote from: "Empyreanwolf"

To [Unholywolf]: !help
[Unholywolf]: I only listen to members of this bot.

i am makin a raid bot and i have put

$super_admin["Empyreanwolf"] = true;

thats easy enough...all you're going to need to do is
/tell Unholywolf !member Empyreanwolf
then you can !join, !help, w/e

Jordan · « **Reply #27 on:** May 25, 2005, 02:10:05 am »

I saw all post and this helped me to solve many problems... but now i get this ...

Warning: mysql_connect(): Can't connect to MySQL server on '217.114.210.66' (100
60) in D:\bebot_v0211\bebot\MySQL.php on line 36
[Keine Verbindung zur Datenbank!] (Can't connect to MySQL server on '217.114.210.66' (10060))

Cans sombody help me?

Pudz · « **Reply #28 on:** June 02, 2005, 05:03:27 pm »

guys do u mind swearing here?guess not.anywayz i need to kno how to install this so called 'guildbot' instalation files show i need php and i got it from this site.i got the files>php(wit a screen sybol),php(wit a notepad sybol),php_bz2.dll,php sockets.dll and php4ts.dll< wha do i do from here plz?

komives · « **Reply #29 on:** June 07, 2005, 04:45:38 pm »

Paga you are hopeless