Perl 6 - the future is here, just unevenly distributed

IRC log for #ilbot, 2015-08-19

| Channels | #ilbot index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
01:47 ilbot3 joined #ilbot
01:47 Topic for #ilbot is now ilbot -- http://moritz.faui2k3.org/en/ilbot -- logs at http://irclog.perlgeek.de/ilbot/today -- read UPGRADE.md and upgrade!
04:44 moritz GeekShadow: which OS are you on?
05:16 cfloare joined #ilbot
10:07 cfloare Hello everyone. I tried to install ilbot on Ubuntu 14.04LTS (Trusty) but
10:09 cfloare the installer stops with the same error as 'vidvisionify' mentioned at 12:27 on http://irclog.perlgeek.de/ilbot/2015-04-09
10:11 cfloare seems to be a mysql version problem with the right syntax near "DELIMITER //" in sql/schema.mysql
10:26 moritz cfloare: what version of mysql are you using?
10:29 cfloare 5.5.44-0ubuntu0.14.04.1
10:32 moritz cfloare: in the ilbot source directory, there's a file sql/schema.mysql
10:32 moritz cfloare: can you please try to copy&paste everything from line 39 ("DELIMITER //") onwards into a mysql prompt, and see if you get the same error?
10:34 cfloare It seems it worked finally if I loaded the db manually using the command: mysql -u ilbot -p ilbot < sql/schema.mysql
10:35 cfloare I mean didn't get any error.
10:35 moritz then it worked, yes
10:35 cfloare and the ./install went up to the end.
10:36 cfloare I installed it in /var/www/html/ilbot
10:37 moritz I have the same mysql version; I guess I should try to reproduce the error
10:46 cfloare Only Apache Lucy search engine library was not present in the distribution and I had to install it using: sudo cpan install Lucy
10:46 cfloare but I think this is not important
10:49 cfloare also, I then had to create a MySQL user 'ilbot' and an empty database with the same name. I personally done it using PHPMyAdmin.
10:50 moritz username and database are configurable
10:52 cfloare The first time the installer stopped with the error: Now testing your database connection...
10:52 cfloare DBI connect('database=ilbot;host=localhost;port=3306','ilbot',...) failed: Access denied for user 'ilbot'@'localhost' (using password: YES) at ./install line 97.
10:54 cfloare but after creating the user 'ilbot' I arrived to the one mentioned previously
10:55 cfloare I have now a problem with FastCGIServer. After reloading the apache2 server, I got the error:
10:55 cfloare The apache2 configtest failed. Not doing anything.
10:55 cfloare Output of config test was:
10:55 cfloare AH00526: Syntax error on line 3 of /etc/apache2/sites-enabled/localhost.conf:
10:56 cfloare Invalid command 'FastCgiServer', perhaps misspelled or defined by a module not included in the server configuration
10:56 moritz cfloare: that probably means you need to install and enable the module the provides the FastCgiServer directive
10:58 moritz mod_fastcgi
11:00 cfloare Yes, you are right. I hope I'll mange. I'm just trying to read the manual: http://www.fastcgi.com/mod_fastcgi/INSTALL
11:01 moritz apt-get install libapache2-mod-fastcgi
11:01 moritz a2enmod fastcgi
11:04 cfloare Oh, thank you. Initially, I thought I have to recompile it.
11:12 cfloare It worked. I hope I'll manage now the last steps.
11:43 cfloare I think I've done everything. But when I try to connect to it from the browser I get the mesage 'No such channel'. Surely, I didn't properly understood something.
11:45 moritz cfloare: what URL did you call, exactly? Did you start the bot already? Did it log something?
11:49 cfloare the freenode one 31.13.222.109
11:49 cfloare but but you are right it stopped at: "."
11:49 cfloare Launching logger...
11:50 cfloare This means is not connected yet. I suppose it is a firewall problem.
12:12 cfloare As I can see this is an IP from Sofia, Bulgaria. Probably one of the many of the irc.freenode.net.
12:14 moritz cfloare: oh, you must give the bot a new name in bot.conf
12:14 moritz it won't connect if the nick name is already taken, and the error message is shitty (or non-existent, even)
12:18 cfloare I changed the name but I suppose it's a firewall problem.
12:19 cfloare I cannot connect from even from the client. I get only 'Connection timed out'
12:27 cfloare I think I am not far have it working. I have to solve this connection problem. Thank you very much for all help.
12:33 moritz you're welcome.
13:18 cgfloare joined #ilbot
13:18 cgfloare left #ilbot
13:26 cgfloare joined #ilbot
13:42 calingfloare joined #ilbot
13:44 calingfloare joined #ilbot
13:47 cfloare Hello again. I can now connect to the channel from irrsi but when I start
13:48 cfloare perl /var/www/html/ilbot/bin/ilbot2.pl /var/www/html/ilbot/config/bot.conf
13:52 cfloare It get stuck at: Launching logger... Trying to connect to '#ilbot'
14:07 nakilon joined #ilbot
14:13 cfloare In fact it was simply working. That's great ! :)
14:32 pdurbin cfloare: you got it working? nice
16:01 cfloare Yes. I am happy. It's a nice IRC logger.
16:04 cfloare I still have a question. Is there an example cron script or how often 'create-search-index' and the update of database caches has to be done ?
16:08 nakilon joined #ilbot
17:13 moritz cfloare: I run both daily
17:41 pdurbin it is nice
18:09 nakilon joined #ilbot
19:05 cfloare I don
19:07 cfloare I don't understand for the moment how they work. This means ilbot database and consequently the website is updated only one time a day ?
19:10 moritz cfloare: no
19:11 moritz cfloare: the logger continuously writes into the database, and the web frontend displays that
19:11 moritz cfloare: the search index is what is used on the search page, for example http://irclog.perlgeek.de/perl6/search
19:12 moritz so if you run the create-search-index script once a day, the search will miss up to the last 24 hours -- which is usually OK, because people use it search for old stuff
19:13 moritz cfloare: the cache is barely an optimization; if you look at http://irclog.perlgeek.de/perl6/ for example, you'll notice that the various days have different background colors: the darker, the more activity
19:14 moritz cfloare: and to get the activity numbers, the database has to count many lines; to make that faster, a cache exists for dates in the past
19:14 moritz if the cache isn't filled, building the index page will become slower
19:14 moritz (but that's only noticable after your bot has logged a few tens or hundred thousand lines)
19:23 moritz installer fixed now.
19:23 ilbot-news joined #ilbot
19:23 ilbot-news [ilbot] moritz pushed 1 new commit to master: https://github.com/moritz/ilbot/commit/5604958098c482202cd41b21f370aca3b93bb0a8
19:23 ilbot-news ilbot/master 5604958 Moritz Lenz: Fix schema creation in the installer...
19:23 ilbot-news left #ilbot
19:24 moritz meh, I take the time to write a proper commit message, and that dumb bot only shows the first line :(
19:35 nakilon joined #ilbot

| Channels | #ilbot index | Today | | Search | Google Search | Plain-Text | summary