2013-12-09T02:47:32 *** thestinger has quit IRC (Quit: sleep) 2013-12-09T03:28:18 *** coeus has quit IRC (Ping timeout: 246 seconds) 2013-12-09T03:31:54 *** smiley1983 has joined #aichallenge 2013-12-09T03:40:50 *** iglo has joined #aichallenge 2013-12-09T03:59:10 *** sigh has joined #aichallenge 2013-12-09T04:56:05 *** iglo has quit IRC (Quit: .) 2013-12-09T05:24:06 *** iglo has joined #aichallenge 2013-12-09T05:50:12 *** iglo has quit IRC (Quit: .) 2013-12-09T07:14:39 *** hemaolle has joined #aichallenge 2013-12-09T07:15:40 Hi, does someone know what has happened to the Planet Wars site (http://planetwars.aichallenge.org/)? 2013-12-09T07:30:45 *** hemaolle has quit IRC (Ping timeout: 250 seconds) 2013-12-09T07:58:20 *** Accoun has quit IRC () 2013-12-09T08:14:29 *** Accoun has joined #aichallenge 2013-12-09T08:23:22 *** aerique_ has joined #aichallenge 2013-12-09T08:23:28 *** aerique has quit IRC (Ping timeout: 246 seconds) 2013-12-09T08:28:30 *** sigh has quit IRC (Remote host closed the connection) 2013-12-09T09:18:57 Looks like the aichallenge.org site has lost its MySQL server (no forums, no rankings, no planetwars site) 2013-12-09T10:02:52 *** smiley1983 has quit IRC (Ping timeout: 264 seconds) 2013-12-09T10:06:51 *** Areks has quit IRC (Ping timeout: 260 seconds) 2013-12-09T10:21:06 *** foRei has joined #aichallenge 2013-12-09T10:46:48 *** berak has joined #aichallenge 2013-12-09T10:48:55 *** berak has left #aichallenge 2013-12-09T14:10:40 *** dici has joined #aichallenge 2013-12-09T14:57:16 *** Scooper has joined #aichallenge 2013-12-09T15:26:21 *** amstan has joined #aichallenge 2013-12-09T15:26:21 *** ChanServ sets mode: +o amstan 2013-12-09T16:10:35 *** sigh has joined #aichallenge 2013-12-09T16:14:34 *** thestinger has joined #aichallenge 2013-12-09T16:49:29 *** sigh has quit IRC (Remote host closed the connection) 2013-12-09T17:00:04 *** sigh has joined #aichallenge 2013-12-09T17:07:36 *** sigh has quit IRC (Remote host closed the connection) 2013-12-09T17:44:26 *** coeus has joined #aichallenge 2013-12-09T18:00:18 The DB is down because amstan is in the process of transfering the site to a new server 2013-12-09T18:00:33 oh man... we actually have people questioning about that 2013-12-09T18:00:38 i should hurry up 2013-12-09T18:00:56 :) apparently at least two people still visit 2013-12-09T18:00:59 janzert: i finished that transfer, i just need to get it configured 2013-12-09T18:01:01 we did. neither of whom are here right now. 2013-12-09T18:01:47 np, I don't think there's a huge rush. 2013-12-09T18:02:08 let me know if there's something I might be able to help figure out 2013-12-09T18:02:49 of course it's probably just as long since I looked at the configuration as you have :/ 2013-12-09T18:48:22 *** contestbot has joined #aichallenge 2013-12-09T18:48:22 *** ChanServ sets mode: +o contestbot 2013-12-09T18:58:06 great... now i have to use mariadb 2013-12-09T19:00:59 *** chris__0076 has joined #aichallenge 2013-12-09T19:03:50 *** chris___0076 has quit IRC (Ping timeout: 240 seconds) 2013-12-09T19:38:45 *** chris___0076 has joined #aichallenge 2013-12-09T19:39:58 *** dici has quit IRC (Read error: Connection reset by peer) 2013-12-09T19:41:45 *** chris__0076 has quit IRC (Ping timeout: 272 seconds) 2013-12-09T19:50:37 *** smiley1983 has joined #aichallenge 2013-12-09T20:20:29 that was a pain 2013-12-09T20:20:37 freaking #mysql50# 2013-12-09T20:37:01 *** Scooper has quit IRC (Quit: Leaving) 2013-12-09T20:57:33 janzert: does anything have to be writable? besides the occasional folders in forums/ 2013-12-09T21:07:59 *** yoden has quit IRC (Read error: No route to host) 2013-12-09T21:08:53 *** yoden has joined #aichallenge 2013-12-09T21:09:04 and here's the fun mysql errors 2013-12-09T21:09:11 Incorrect key file for table './aichallenge_forums/forums_login_attempts.MYI'; try to repair it [126] 2013-12-09T21:18:03 mysqlcheck seems to do its job 2013-12-09T21:18:16 idk why there's probablems, probably the translation with mariadb 2013-12-09T21:18:29 or they existed on the other server too(i checked md5sums after transfer) 2013-12-09T21:18:53 *** deltreey has joined #aichallenge 2013-12-09T21:19:10 how is everyone in here...the room certainly seems empty these days 2013-12-09T21:19:22 deltreey: o/ 2013-12-09T21:19:33 just moving forums+archives to a new server 2013-12-09T21:19:39 *** smiley1983 has quit IRC (Ping timeout: 272 seconds) 2013-12-09T21:19:42 need a hand with anything? 2013-12-09T21:19:52 i'm mostly ok 2013-12-09T21:20:04 I have to admit, the custom sites have always been neat, but I wish it were easier to go back and look at the old games 2013-12-09T21:20:07 just annoyed at mysql 2013-12-09T21:20:19 deltreey: which old games? 2013-12-09T21:20:23 mysql....yes, gotta stop using that myself 2013-12-09T21:20:33 tron, galaxy wars, etc 2013-12-09T21:20:36 right.. 2013-12-09T21:20:53 those were taken offline due to to the dbs using lots of cpu 2013-12-09T21:20:55 the AI contest site always seems to do this, focus really heavily on the latest game 2013-12-09T21:20:57 apparently adding indexes will help 2013-12-09T21:21:08 i might do that during this transfer 2013-12-09T21:21:19 and by might i mean probably 2013-12-09T21:21:27 so why the transfer? prepping for a new game? 2013-12-09T21:21:28 deltreey: does forums.aichallenge.org work for you yet? 2013-12-09T21:21:41 no 2013-12-09T21:21:58 deltreey: well.. i have a server that's unused and janzert wants to free up his ec2 instance 2013-12-09T21:22:18 yeah.. unfortunatelly aichallenge.org has a 8 hour dns timeout 2013-12-09T21:22:20 ah, np, if you need anything I'm happy to help. Always loved the contest 2013-12-09T21:22:29 deltreey: did you try to access it recently? 2013-12-09T21:22:32 just now 2013-12-09T21:22:50 did so again as you asked 2013-12-09T21:22:52 deltreey: can you give me your dns's ip? 2013-12-09T21:22:54 still nada 2013-12-09T21:23:16 is there a quick way to get that? whatismyip.com? 2013-12-09T21:24:11 deltreey: it would be in your router 2013-12-09T21:24:13 alright.. nvm 2013-12-09T21:24:19 checking it 2013-12-09T21:24:41 deltreey: did you try to access aichallenge.org recently? last 8 hours? 2013-12-09T21:25:00 8.8.8.8(google dns) seems to have the new ip just fine 2013-12-09T21:25:00 yeah, just started checking it about an hour agi 2013-12-09T21:25:02 *ago 2013-12-09T21:25:10 deltreey: yeah.. so flush your dns, then the forums will work 2013-12-09T21:26:59 yup, good stuff 2013-12-09T21:27:07 working? 2013-12-09T21:27:35 yup 2013-12-09T21:27:50 dns flush worked 2013-12-09T21:31:54 woo! http://ants.aichallenge.org/ 2013-12-09T21:32:10 deltreey: can you do me a favour? and try all possible links for it, stuff that deals with databases and files 2013-12-09T21:38:50 and starter page: http://aichallenge.org/ 2013-12-09T21:38:58 if anyone wants to make it prettier contact me 2013-12-09T21:42:34 I appreciate you doing that 2013-12-09T21:42:54 I have a guy who could use some programming practice...mind if I get him to put soething together? 2013-12-09T21:43:19 deltreey: umm.. sure.. 2013-12-09T21:43:23 for the page I mean 2013-12-09T21:45:18 wait.. 2013-12-09T21:45:22 how on earth is ants working? 2013-12-09T21:45:30 nvm 2013-12-09T21:45:31 not sure myself 2013-12-09T21:45:32 it isn't 2013-12-09T21:45:48 deltreey: i asked you to check the links :( http://ants.aichallenge.org/rankings.php 2013-12-09T21:46:07 I clearly didn't listen 2013-12-09T21:46:13 yep.. 2013-12-09T21:47:58 I didn't get to checking the links in the 30 seconds after you asked and you were upset? 2013-12-09T21:48:10 I was talking to my guy, telling him about the project 2013-12-09T21:56:08 great... encoding errors: http://ants.aichallenge.org/organization_profile.php?org=224 2013-12-09T21:56:14 just what i needed at this point 2013-12-09T21:56:23 ick 2013-12-09T21:56:36 hopefully janzert knows how to fix it 2013-12-09T21:56:38 I'm wondering if you'd let me upgrade you to SQL Server 2012? 2013-12-09T21:56:44 deltreey: what? 2013-12-09T21:56:52 why? 2013-12-09T21:57:11 http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf8-in-my-cnf 2013-12-09T21:57:39 <@amstan> just annoyed at mysql 2013-12-09T21:58:04 there's 60GB of data in this db, it's not changing database engines any time soon 2013-12-09T21:58:18 ooo, some of the links are funky, I clicked on the game # on the home page http://aichallenge.org/visualizer.php?game=328430 2013-12-09T21:58:30 60gb....holy fuck 2013-12-09T21:58:59 that's a LOT of porn 2013-12-09T21:59:01 shit... visualizer is hardcoded to that url 2013-12-09T22:00:34 php isn't a tough language, I'm sure I could track that error quickly 2013-12-09T22:00:50 wrote a few php sites back in the day 2013-12-09T22:00:57 it's not in php, it's the way that visualizer was done 2013-12-09T22:01:01 there's a file it parses 2013-12-09T22:01:04 i'm pretty sure it's in there 2013-12-09T22:01:12 like...text file? 2013-12-09T22:02:02 that visualizer is an impressive piece of code, I imagine you were working with what you got 2013-12-09T22:02:11 darn it 2013-12-09T22:02:45 url's are hardcoded: http://ants.aichallenge.org/game/0/10/10000.replaygz 2013-12-09T22:02:51 in every playback file 2013-12-09T22:03:50 that's ridiculous!! why would we ever do that 2013-12-09T22:04:06 i might have to make a script that renames all of them 2013-12-09T22:04:06 need a file rewriter? 2013-12-09T22:04:26 ::continues to fail to find ways to help:: 2013-12-09T22:04:39 yeah, there's only 346656 files to change 2013-12-09T22:04:44 fml 2013-12-09T22:05:23 frontier's not in here so i can bug him 2013-12-09T22:05:30 contestbot: seen frontier 2013-12-09T22:05:30 amstan: frontier was last seen in #aichallenge 1 year, 43 weeks, 6 days, 14 hours, 50 minutes, and 5 seconds ago: kthx bye 2013-12-09T22:05:33 want me to write something? 2013-12-09T22:05:40 I can do it 2013-12-09T22:05:41 long time ago 2013-12-09T22:05:42 lol 2013-12-09T22:06:03 deltreey: well.. do you know what to do? 2013-12-09T22:06:10 I got this, relax, is it linux or windows? 2013-12-09T22:06:17 **powershell or bash 2013-12-09T22:06:29 it's 346656, in lots of nested folders, bash 2013-12-09T22:06:41 they're json files, but you can probably do this as text 2013-12-09T22:06:41 k, on it, I'll slap something together 2013-12-09T22:06:45 give me a few minutes 2013-12-09T22:06:50 replace all http://aichallenge.org to http://ants.aichallenge.org 2013-12-09T22:07:01 right. 2013-12-09T22:07:07 they're also gz compressed: http://ants.aichallenge.org/game/0/10/10000.replaygz 2013-12-09T22:08:48 I was just gonna do a recursive regex, but I'll fire up a VM for testing 2013-12-09T22:10:25 woo! http://planetwars.aichallenge.org/rankings.php 2013-12-09T22:11:24 huzzah 2013-12-09T22:11:34 that was my favorite AI contest by far 2013-12-09T22:14:01 http://tron.aichallenge.org/ 2013-12-09T22:14:26 janzert wasn't kidding when he said tron kills mysql 2013-12-09T22:16:24 how bad is it? 2013-12-09T22:18:30 deltreey: time it for yourself: http://tron.aichallenge.org/rankings.php 2013-12-09T22:19:31 17 seconds, how large is that DB? 2013-12-09T22:20:09 the logo link on tron points to: http://tron.aichallenge.org/contest which is broken 2013-12-09T22:20:36 deltreey: good catch 2013-12-09T22:21:17 deltreey: fixed 2013-12-09T22:23:28 works for me 2013-12-09T22:23:52 except this doesn't: http://tron.aichallenge.org/profile.php?user_id=1661 2013-12-09T22:23:55 it relies on zend 2013-12-09T22:24:03 so i have to makepkg that 2013-12-09T22:24:45 my guy is building up the homepage btw, so that's no problem 2013-12-09T22:32:27 wtf? http://pastebin.com/jk2JRS1k 2013-12-09T22:33:15 wow, deeply tied to zend 2013-12-09T22:33:38 don't do zend myself, sorry, no help there 2013-12-09T22:33:56 deltreey: yep, go figure 2013-12-09T22:34:11 also.. there's no indexes on the rankings tabl 2013-12-09T22:34:14 no wonder it's slow 2013-12-09T22:34:23 but then aichallenge_tron.contest_rankings optimize Error Table 'contest_rankings' is read only 2013-12-09T22:34:29 that's because of myisampack 2013-12-09T22:34:48 indexes are easy stuff 2013-12-09T22:35:02 they'll just take a while to add to that much data 2013-12-09T22:35:14 ? 2013-12-09T22:39:17 thankfully tron is nothing compared to the rest of them 2013-12-09T22:39:27 hopefully i'm doing this right: ALTER TABLE `aichallenge_tron`.`contest_rankings` ADD INDEX `leaderboard_id` ( `leaderboard_id` ) 2013-12-09T22:40:13 deltreey: dude: http://tron.aichallenge.org/rankings.php 2013-12-09T22:40:17 checkout that speed now 2013-12-09T22:40:40 whoa 2013-12-09T22:40:45 very fast 2013-12-09T22:40:47 nicely done 2013-12-09T22:40:52 alright 2013-12-09T22:40:54 back to zend 2013-12-09T22:41:45 added that index pretty fast too 2013-12-09T22:42:23 so why can't i include that zend cache 2013-12-09T22:47:08 *** Accoun has quit IRC (Read error: Connection reset by peer) 2013-12-09T22:47:50 woo! http://tron.aichallenge.org/profile.php?user_id=2191 2013-12-09T22:48:09 speaking of that account guy ^ http://tron.aichallenge.org/profile.php?user_id=1376 2013-12-09T22:53:05 *** Accoun has joined #aichallenge 2013-12-09T22:53:23 Accoun: the tron website is back online: http://tron.aichallenge.org/profile.php?user_id=1376 2013-12-09T22:53:32 Accoun: you can get the all the girls now 2013-12-09T22:57:44 well.. my job is done! aichallenge archive sites are now safe on my server 2013-12-09T22:58:33 nice 2013-12-09T22:59:16 except that stupid visualizer hardcoding 2013-12-09T22:59:18 but meh 2013-12-09T23:02:34 almost done here 2013-12-09T23:02:49 haven't done grep in a while, so this is fun for me 2013-12-09T23:03:06 right.. you are working on that 2013-12-09T23:05:00 oh ... and the encoding problems 2013-12-09T23:10:08 egrep -lRZ --include-"*.replay*" 'http:\\/\\/aichallenge\.org' . | xargs -0 sed -i -e 's@http:\\/\\/aichallenge\.org@http:\\/\\/ants.aichallenge.org@g' 2013-12-09T23:10:31 that command will change any files that end in .replay* in the directory you run it in recursively 2013-12-09T23:11:28 enjoy 2013-12-09T23:11:51 deltreey: it's not in the same directory though 2013-12-09T23:12:03 deltreey: 300 000 files can't fit in one folder 2013-12-09T23:12:09 we have a whole hierarchy setup 2013-12-09T23:12:14 so your script should be recursive 2013-12-09T23:12:46 it works recursively 2013-12-09T23:12:54 why can't i use "find | xargs -0 sed -i -e 's@http:\\/\\/aichallenge\.org@http:\\/\\/ants.aichallenge.org@g'" 2013-12-09T23:12:59 run it in the lowest level directory where you want files changed 2013-12-09T23:13:11 that'd work, but I didn't know if you had other files in there 2013-12-09T23:13:22 so I was ensuring that only things with .replay were included 2013-12-09T23:13:23 deltreey: alright, now what about the gz part? 2013-12-09T23:13:31 it does .replay* 2013-12-09T23:13:36 so gz files are included 2013-12-09T23:13:41 yes, except xargs can't open gz files 2013-12-09T23:13:44 they're compressed 2013-12-09T23:13:47 doh 2013-12-09T23:13:51 well I'm an idiot then 2013-12-09T23:14:02 like you're close, but that has to be fixed first 2013-12-09T23:14:10 Ik, on it 2013-12-09T23:20:37 *** deltreey has quit IRC (Ping timeout: 250 seconds) 2013-12-09T23:31:29 *** thestinger has quit IRC (Quit: WeeChat 0.4.2) 2013-12-09T23:46:23 *** deltreey has joined #aichallenge 2013-12-09T23:46:38 don't know what happened there. anyway, any of the directories have spaces in the names? 2013-12-09T23:48:36 deltreey: i don't think so 2013-12-09T23:49:32 *** Areks has joined #aichallenge 2013-12-09T23:53:07 *** deltreey has quit IRC (Ping timeout: 250 seconds)