BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: blofeld on August 04, 2006, 01:41:45 am
-
Ok,
Got the bot working by following the instructions in various posts.
All commands work except when starting it says:
CREATE command denied to user 'blofeld'@'localhost' for table ...
and goes down the list. Basically won't make any tables therefore it wont update members. recognizes who is online in the bot command window but lists them as non members and lists 0 when doing the !online command
like i said, commands such as !oe and !whois and such work fine but tells get a response of "i only listen to members of this bot"
Thanks, like the bots functionality so far.
-
This is an MySQL permission issue rather than a bot issue.
You need to make sure that your MySQL user blofeld is allowed to CREATE, ALTER and DELETE tables amongst other things. Either that or you need to manually create the tables for the bot using the root user or another user with the apropriate permissions.
-
ok figured something like that but how do i fix :)
noob in all things programming
i did the command in mysql bebot to:
GRANT ALL on databasename.* TO username@localhost;
dont know what else to do
Thanks
-
btw did substitute the right names for the generic ones in example above
-
okay think i got this licked now
grant for some reason wont work when i do bebot.* but if i just am within the bebot sql database and use * by itself that worked ok
thanks for the feedback and thanks for the cool bot and the great faqs
just making a little org for some young sons, nieces and nephews thats G rated this will make things so much easier and more fun
thanks again
-
Well Enter the Mysql promt again,
enter ur db(with use bebot; )
then type the following line:
GRANT ALL PRIVILEGES ON bebot.* TO 'bebot'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
replace password, with w/e pass you want, be sure you put it on Mysql.conf same too