collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18365
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Almost new to bebot needs help  (Read 7659 times)

0 Members and 3 Guests are viewing this topic.

Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Almost new to bebot needs help
« 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.
« Last Edit: April 25, 2009, 06:36:09 pm by Khalem »

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #1 on: April 25, 2009, 02:16:00 pm »
Quote
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.
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #2 on: April 25, 2009, 02:29:25 pm »
You know i'm a newbie, how do a plot in/check my databse in cmd/mysql? and bebot?

Offline Pharexys

  • BeBot Apprentice
  • ***
  • Posts: 117
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #3 on: April 25, 2009, 02:37:26 pm »
modify your /conf/Mysql.conf file to fit ur mysql user/pass and database.

Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #4 on: April 25, 2009, 02:40:21 pm »
   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?

Offline Pharexys

  • BeBot Apprentice
  • ***
  • Posts: 117
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #5 on: April 25, 2009, 02:42:47 pm »
if you run mysql on same server as the bot, it should be "localhost".
Anyway what box you run ur bots? linux, windows?

Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #6 on: April 25, 2009, 02:43:46 pm »
I wrote it m8 ;) Windows

Offline Pharexys

  • BeBot Apprentice
  • ***
  • Posts: 117
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #7 on: April 25, 2009, 03:01:45 pm »
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.

Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #8 on: April 25, 2009, 03:10:58 pm »
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?

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
BeBot Founder and Fixer Kingpin

Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #10 on: April 25, 2009, 06:59:16 pm »
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.
« Last Edit: April 26, 2009, 07:12:37 pm by Khalem »

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Almost new to bebot needs help
« Reply #11 on: April 25, 2009, 10:21:25 pm »
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

Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #12 on: April 25, 2009, 11:14:42 pm »
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 = "*****";



Offline Faelwen

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Almost new to bebot needs help
« Reply #13 on: April 26, 2009, 11:21:25 pm »
Well i still need the help guys!

Offline clashbot

  • BeBot Expert
  • ****
  • Posts: 295
  • Karma: +0/-0
    • Ascension's Home
Re: Almost new to bebot needs help
« Reply #14 on: April 27, 2009, 03:12:32 am »
I would go through the sql setup routine again fael, make sure to do the GRANT ALL otherwise tables could be locked out.

 

* Recent Posts
0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 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: 149
  • 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