| 01:15.54 | *** join/#debian-bots Vladkao (~vladkao@ip-82-139.interbild.net) |
| 01:16.27 | Vladkao | where do i get a bot like apt for my channel ? |
| 01:22.58 | Vladkao | dondelelcaro: you here? :) |
| 01:23.07 | dondelelcaro | yes. what's your question? |
| 01:23.17 | Vladkao | where do i get a bot like apt for my channel ? |
| 01:23.33 | dondelelcaro | it's a blootbot. the databases are available, as is the codebase. |
| 01:24.11 | Vladkao | is it _easy_ to install ? :) |
| 01:24.51 | dondelelcaro | Vladkao: it's not hard, but if you don't know what you're doing, you probably should be running a bloot... they currently require a bit of care and feeding. |
| 01:24.56 | dondelelcaro | s/should/shouldn't/ |
| 01:25.20 | Vladkao | what does it require ? something non-standard ? |
| 01:25.39 | dondelelcaro | no, it's just big on features, low on installability. |
| 01:26.02 | Vladkao | i'm not afraid |
| 01:26.40 | dondelelcaro | !blootbot |
| 01:26.41 | dpkg | somebody said blootbot was a severely modified infobot (right now, the code doesn't even look like infobot any more), by xk. Homepage at http://blootbot.sourceforge.net. Archive is at http://www.nyip.net/~apt/blootbot. See blootbot debs now in debian, or if you didn't already know this you probably don't want to run a blootbot unless you're very good with perl |
| 01:26.44 | dondelelcaro | !your factoids |
| 01:26.44 | dpkg | i guess your factoids is at http://rzlab.ucr.edu/~dpkg/ |
| 01:26.44 | Vladkao | i just need a link on something working :) |
| 01:27.10 | Vladkao | unless you're very good with perl |
| 01:27.19 | Vladkao | that's what actually scares me |
| 01:27.31 | Vladkao | anyway, i'll check it |
| 01:29.51 | Vladkao | apt@OPN#debian has been running this version for months and it's been relatively stable. |
| 02:17.11 | Vladkao | dondelelcaro: still here? |
| 02:31.02 | dondelelcaro | sortof... wassup? |
| 02:35.37 | Vladkao | dondelelcaro: well, i'm stuck on mysql (as most people i guess) |
| 02:36.25 | Vladkao | my mysql user has no password. but when i disable the password in the config, it complains about access denied for user '@host' |
| 02:36.58 | Vladkao | so i must either change (that is, set) the password, or make the config work :( |
| 02:37.05 | Vladkao | and ... i'm stuck |
| 02:48.53 | dondelelcaro | you should have a password... if you don't, it's just a blank password. |
| 02:49.01 | dondelelcaro | you'll also have to set the mysql user appropriately |
| 02:50.51 | Vladkao | well, i have no password, i just tap enter on pass: |
| 02:51.50 | Vladkao | but when i comment out the sqlpass in the config, when the bot starts it gives that accsess denied for user: '@host' |
| 02:52.00 | Vladkao | that is, no user. but i have set the user :( |
| 02:52.08 | Vladkao | i'm changing the pass now ... |
| 02:54.08 | dondelelcaro | you should have an DBName, an SQLHost, SQLUser and SQLPass... |
| 02:54.59 | Vladkao | well, i guess i'll change the pass :) |
| 02:55.25 | dondelelcaro | the problem you're seeing is most likely because you haven't set the SQLUser |
| 02:56.19 | Vladkao | nope. i've set it |
| 02:56.23 | Vladkao | and the host |
| 02:56.37 | Vladkao | ok, wait a bit until i'm finished with mysql :) |
| 02:56.47 | Vladkao | it seems a nasty thing to change tha pass |
| 03:05.43 | Vladkao | well, it seems, i can't change the mysql password :( |
| 03:09.34 | dondelelcaro | Vladkao: msyqladmin -u username -p password |
| 03:11.34 | Vladkao | heh, it's not that easy :) |
| 03:12.08 | Vladkao | mysql> SET PASSWORD FOR |
| 03:12.13 | Vladkao | -> 'some_user'@'some_host' = PASSWORD('mypass'); |
| 03:12.27 | Vladkao | and i've done it, but still no effect :( |
| 03:12.31 | dondelelcaro | it actually is that easy. |
| 03:12.33 | Vladkao | where am i wrong ? |
| 03:12.35 | dondelelcaro | what you're doing is totally wrong. |
| 03:12.49 | Vladkao | that's written in http://www.mysql.com/doc/en/Password_hashing.html |
| 03:14.48 | dondelelcaro | hrm... that documentation is needlessly complex. |
| 03:15.12 | dondelelcaro | you can just use the msyqladmin command to do that all for you |
| 03:15.33 | dondelelcaro | if you really want to go that way, you might as well munge the user table in the mysql database yourself. |
| 03:16.11 | Vladkao | well i guess it is the hardest part :) |
| 03:16.37 | Vladkao | ok, but if i disable the database support, thus dropping factoids, will the bot run ? |
| 03:16.48 | dondelelcaro | sort of... |
| 03:16.49 | Vladkao | (i want to check if i have everything installed) |
| 03:17.06 | dondelelcaro | but I've never run it that way, so no guarantees. |
| 03:17.20 | Vladkao | ok, no probs |
| 03:17.32 | dondelelcaro | I'd just fix your mysql problem though. |
| 03:17.42 | dondelelcaro | The mysqladmin command that I gave you *WILL* take care of the problem. |
| 03:17.56 | Vladkao | i'll manage it somehow. i'm not that new to problems in linux :) |
| 03:18.23 | Vladkao | well it gives me :connect to server at '195.138.139.82' |
| 03:18.32 | Vladkao | oops, cannot ... |
| 03:21.27 | dondelelcaro | that means that either your mysql server isn't running, or you've not given the proper address for it in your my.cnf file... |
| 03:21.45 | Vladkao | dondelelcaro: will check right now |
| 03:22.42 | dondelelcaro | 'course, if mysql -u username -pPASS works, mysql -u username -pPASS password [NEWPASS] will... |