BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => AO 0.6 support => Topic started by: Faelwen on April 25, 2009, 01:54:48 pm
-
Access denied for user 'ODBC'@'localhost' (using password: NO)
MySQL error (# 0) on query: Database not found or insufficient priviledges!
Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
C:\Users\Steven\Desktop\bebot-hyborian\Sources\MySQL.php on line 245
MySQL error (# 0) on query: CREATE TABLE IF NOT EXISTS gratz_messages (id int(10
) unsigned NOT NULL AUTO_INCREMENT, level int(10) unsigned NOT NULL DEFAULT '0',
message varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id)) DEFAULT CHARSET=utf
8;
Access denied for user 'ODBC'@'localhost' (using password: NO)
MySQL error (# 0) on query: Database not found or insufficient priviledges!
Access denied for user 'ODBC'@'localhost' (using password: NO)
[edit]
Removed unneeded repetitions of errors - Khalem
[/edit]
Tfwbot [LOGIN] [STATUS] Connecting
Tfwbot [LOGIN] [STATUS] Authenticating
Tfwbot [LOGIN] [RESULT] Error
Tfwbot [LOGIN] [STATUS] Logging in
AOChat: not expecting login.
Could someone just explain me a little further on what i should do? or what i can do?
I use Windows Vista - 32 bit.
-
Access denied for user 'ODBC'@'localhost' (using password: NO)
MySQL error (# 0) on query: Database not found or insufficient priviledges!
Check your database setup and/or BeBot setup.
-
You know i'm a newbie, how do a plot in/check my databse in cmd/mysql? and bebot?
-
modify your /conf/Mysql.conf file to fit ur mysql user/pass and database.
-
Database server (usually localhost)
*/
$server = "";
Just a quick question... i have always ploted in like this in the $server="";
Database server (usually localhost)
*/
$server = "localhost";
Maybe thats the problem? in that case what should i use as server then?
-
if you run mysql on same server as the bot, it should be "localhost".
Anyway what box you run ur bots? linux, windows?
-
I wrote it m8 ;) Windows
-
Not sure then man, if you set up evrything right in mysql config file, then evrything should be ok, as long as you installed mysql on ur box and of course created the username you specified in config file :D
There is 1 more thing you should check, if you gived the specified username the right privileages.
-
Not sure then man, if you set up evrything right in mysql config file, then evrything should be ok, as long as you installed mysql on ur box and of course created the username you specified in config file :D
There is 1 more thing you should check, if you gived the specified username the right privileages.
How do i give my username the right privileges?
-
See http://bebot.link/helpful-posts/mysql-n00b-help/
-
See http://bebot.link/helpful-posts/mysql-n00b-help/
I have done this, and it's the same errors....
What more can i do? And why doesnt the arguments in the cmd text just co-operate?
EDIT;
Now i get these errors... and it just starts over and over like before.
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
C:\Users\Steven\Desktop\bebot-hyborian\Sources\MySQL.php on line 218
MySQL error (# 0) on query: SELECT * FROM koslist WHERE type = 'guildkos' ORDER
BY player ASC
Access denied for user 'ODBC'@'localhost' (using password: NO)
Tfwbot [MOD-CUSTOM] [LOAD] kos.php
MySQL error (# 0) on query: Database not found or insufficient priviledges!
Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
C:\Users\Steven\Desktop\bebot-hyborian\Sources\MySQL.php on line 245
MySQL error (# 0) on query: INSERT IGNORE INTO access_control (command, subcomma
nd, channel, minlevel) VALUES ('love', '*', 'tell', 'GUEST')
Access denied for user 'ODBC'@'localhost' (using password: NO)
MySQL error (# 0) on query: Database not found or insufficient priviledges!
Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
C:\Users\Steven\Desktop\bebot-hyborian\Sources\MySQL.php on line 245
MySQL error (# 0) on query: INSERT IGNORE INTO access_control (command, subcomma
nd, channel, minlevel) VALUES ('love', '*', 'pgmsg', 'GUEST')
Access denied for user 'ODBC'@'localhost' (using password: NO)
MySQL error (# 0) on query: Database not found or insufficient priviledges!
Access denied for user 'ODBC'@'localhost' (using password: NO)
[edit]
Moderated down the lenght of the post
[/edit]
Tfwbot [SECURITY] [ERROR] No groups exisit, not even the groups created by
default. Something is very wrong.
-
according to the error you are connecting with username ODBC but you dont have a password set
which is in the MySQL.conf or Botname.MySQL.conf
-
according to the error you are connecting with username ODBC but you dont have a password set
which is in the MySQL.conf or Botname.MySQL.conf
Well i do have a password set like this...
/*
Database password
*/
$pass = "*****";
-
Well i still need the help guys!
-
I would go through the sql setup routine again fael, make sure to do the GRANT ALL otherwise tables could be locked out.
-
Thanks man, but about the GRANT ALL.. do i have to change the databasename to my databasename such as Amundsen or whatever?
Never done this, maybe thats the problem.
-
yes it should be:
GRANT ALL on databasename.* TO username@localhost;
Where databasename = your database and username= your username
leave the ".*" attached and also the "@localhost"
do not forget to end each line with the semi-colon otherwise the command will fail.
-
1. Type CREATE DATABASE <<databasename>>; (replace <<databasename>> with the name of the database you wish to create)
2. Press Enter/Return.
3. CREATE USER <<username>>@localhost; (Change <<username>> to the username you want, keep @localhost)
4. Press Enter/Return.
5. SET PASSWORD FOR <<username>>@localhost = PASSWORD('<<newpassword>>'); (Change <<username>> and <<newpassword>> to your selected username and password, again keep @localhost)
6. Press Enter/Return.
7. Type GRANT ALL on <<databasename>>.* TO <<username>>@localhost; (Again, change <<username>>, keep @localhost)
8. Press Enter/Return.
9. Type quit then Enter/Return to exit the MySQL Monitor.
anything that has <<>> needs to be changed to whatever you have set up. Remeber to keep the rest of the punctuation marks, especially the semi-colons at the end of each line. Mysql reads the semi-colon as end-of-command markers.
basically, if I was filling this out:
username = clashbot
password = dbpass
database = bebot
it would look like this:
CREATE DATABASE bebot;
CREATE USER clashbot@localhost;
SET PASSWORD FOR clashbot@localhost = PASSWORD('dbpass');
GRANT ALL on bebot.* TO clashbot@localhost;
QUIT
Then you would modify the mysql.conf file with the same information
$dbase = "bebot";
$user = "clashbot";
$pass = "dbpass";
$server = "localhost";
if this is done, then you should get connected
-
Warning: require(whois-update.conf): failed to open stream: No such file or dire
ctory in C:\Users\Steven\Desktop\bebot-hyborian\core\whois-update.php on line 37
Fatal error: require(): Failed opening required 'whois-update.conf' (include_pat
h='.;C:\php5\pear') in C:\Users\Steven\Desktop\bebot-hyborian\core\whois-update.
php on line 37
Now i got this error... could someone just post me a SS (Screenshot) Link just so i get this clear as i had to "install" the new whois-update.
-
sry was deep lag on my comp, but still needs my answer ofc :P
-
Uhm the whois-update.php delivered with BeBot is for Anarchy Online only, it cannot work with Age of Conan as there are no XML files for the characters supplied by FC.
Besides that, whois-update.php is no BeBot module but a stand-alone tool. It must not be put into any of the bebot modules directories (this includes main, core, modules, core/aoc, modules/aoc as well as all core and module directories defined in the config file)!
-
ah dam, lol :P
Well i copy/pasted the Whois.php you posted in the "home" section. but i got this error..
Fatal error: Cannot access private property Bot::$buddy_status in C:\Users\Steve
n\Desktop\bebot-hyborian\core\whois.php on line 124
btw i check on it a little more and found this.
Tfwbot [ERROR] [access_control] Undefined function create(all, maintenan
ce, OWNER)!
-
Are you using bebot 0.6?
-
Yes i'm using bebot 0.6