| 00:29.47 | jetscreamer | ah it's select command denied to user blootbot |
| 00:32.05 | g4lt | sounds like you need to do some mysql-fu |
| 00:32.20 | g4lt | you dID run the setup script? |
| 01:31.44 | dondelelcaro | jetscreamer: yeah, you need to use GRANT to give the blootbot user select privileges... |
| 01:46.04 | jetscreamer | yeah i ran it and the fix-priv.pl iirc.. bot has and has had the req. priv's... not that i know anything about mysql or much cli sql server usage, but i've done it a couple times. i do showgrants for 'blootbot'@'localhost', i get grant usage on *.* to 'blootbot'@'localhost' identifiedby blahblah... then the... |
| 01:46.30 | jetscreamer | grant select insert update create delete blahblahblah |
| 01:46.53 | jetscreamer | on 'mysql' |
| 01:47.35 | jetscreamer | .'blootbot.... (fqdn to db on localhost or lwhatever in sql-ese) |
| 01:47.58 | jetscreamer | and blootbot has all priv on blootbot db |
| 01:48.26 | jetscreamer | the 'blootbot'@'host' is different |
| 01:48.42 | jetscreamer | just usage and all priv's |
| 01:49.08 | jetscreamer | so afaict it's got the needed privs. |
| 01:49.28 | jetscreamer | i did not have a chance to learn how and where to apply your patch yet |
| 01:52.33 | jetscreamer | heh how would you do a script to simultaenously give all the bots a botsnack... just need the identifier to change on botsnack.. |
| 01:52.55 | jetscreamer | just a thought, don't care about that atm |
| 01:55.41 | jetscreamer | hmmm i guess the mysql keeps a log |
| 02:01.48 | jetscreamer | hey dondelelcaro how long does something like your patch making it's way into the package in sid generally/usually/optimally take? |
| 02:05.56 | jetscreamer | oh and i couldn't get the bot online till i had it set up ant talking to the db, either |
| 02:06.16 | jetscreamer | well not talking, but whatever form of limited communication it's having with it |
| 02:06.32 | jetscreamer | ack brb windows |
| 02:14.39 | *** join/#debian-bots jetscreamer (~jetscream@adsl-64-219-216-41.dsl.hstntx.swbell.net) |
| 02:17.14 | dondelelcaro | jetscreamer: depends on the maintainer |
| 02:17.32 | dondelelcaro | jetscreamer: yeah, you've got to get it talking to the database. |
| 02:18.02 | jetscreamer | how do i apply your patch? |
| 02:18.11 | dondelelcaro | jetscreamer: basically, all you really need to do is go mysql -p -u root; then GRANT INSERT,SELECT,UPDATE,DELETE on blootbot.* TO 'blootbot@localhost' IDENTIFIED BY 'password'; |
| 02:18.28 | dondelelcaro | jetscreamer: you don't need to apply the patch... you just need to do the right mysql grant statement... |
| 02:18.28 | jetscreamer | it has those |
| 02:18.34 | dondelelcaro | ok, then it should work. |
| 02:18.40 | jetscreamer | and has had. |
| 02:19.15 | jetscreamer | ahhhh.. i think it's on mysql, not blootbot |