sa.muel 2008-09-02T16:55:10-05:00 DotClear daily 1 2008-09-02T16:55:10-05:00 RAID Level performance norms 2008-09-02T16:55:10-05:00 2008-09-02T16:55:10-05:00 http://sa.muel.org/go/index.php/2008/09/02/54-raid-level-performance-norms Samuel T. Cossette General source: Greenplum Database Administrator Guide... <img src="/f/raid-level-performance-norms.png"><br> source: Greenplum Database Administrator Guide Google misleading developers to spam site! 2008-06-26T19:23:17-05:00 2008-06-26T19:23:17-05:00 http://sa.muel.org/go/index.php/2008/06/26/53-google-misleading-developers-to-spam-site Samuel T. Cossette General I was recently reading about Google Authentication API, while trying one of the example (see AuthSubRequest sample requests), I've been redirected to that web site: How disgusting! Spammed by Google, I was totally shocked. Get out of the 'plex and do some reading:... I was recently reading about <a href="http://code.google.com/apis/accounts/docs/AuthForWebApps.html">Google Authentication API</a>, while trying one of the example (see AuthSubRequest sample requests), I've been redirected to that web site:<br> <br> <img style="border:1px;border-color:#000000" src="/f/google-misleading-devloppers-to-spam.jpg"><br> How disgusting! Spammed by Google, I was totally shocked.<br> <br> Get out of the 'plex and do some reading: <a href="ftp://ftp.rfc-editor.org/in-notes/rfc2606.txt">ftp://ftp.rfc-editor.org/in-notes/rfc2606.txt</a>. Is Imageshack and Powerset linked? 2008-04-21T22:28:12-05:00 2008-04-21T22:28:12-05:00 http://sa.muel.org/go/index.php/2008/04/21/52-is-imageshack-and-powerset-linked Samuel T. Cossette General They are for sure peered together through EZRI Inc. (Levin brothers own ISP). According to a traceroute, Imageshack seem to be the internet service provider of Powerset: bonita:~ samuel$ traceroute powerset.com [...] 7 tge1-3.fr4.sjc.llnw.net (69.28.171.66) 119.812 ms 114.540 ms... They are for sure <a href="http://www.lerfjhax.com/as/36323">peered</a> <a href="http://www.lerfjhax.com/as/21968">together</a> through EZRI Inc. (Levin brothers own ISP). According to a traceroute, Imageshack seem to be the internet service provider of Powerset: <pre> bonita:~ samuel$ traceroute powerset.com [...] 7 tge1-3.fr4.sjc.llnw.net (69.28.171.66) 119.812 ms 114.540 ms 116.356 ms 8 imageshack.ge3-1.fr4.sjc.llnw.net (208.111.152.106) 135.034 ms 135.472 ms 135.122 ms 9 gi5-1.bas1.aa.powerset.com (208.76.46.165) 142.041 ms 139.165 ms 141.869 ms 10 w2.aa.powerset.com (208.76.46.17) 135.569 ms 134.921 ms 135.400 ms </pre> Search queries and user behavior on query result from Imageshack is extremely valuable data for Powerset. Gmail 2.0 first experience. 2007-11-07T01:04:10-06:00 2007-11-07T01:04:10-06:00 http://sa.muel.org/go/index.php/2007/11/07/51-gmail-20-first-experience Samuel T. Cossette General I noticed this morning that the web version of GTalk was back in my personalized Gmail interface. Weird, I have disabled that functionality long time ago. Then few minutes later, I got new error/unreachable Gmail server. I was freaking out until I saw the link on the top right corner giving me the... I noticed this morning that the web version of GTalk was back in my personalized Gmail interface. Weird, I have disabled that functionality long time ago. Then few minutes later, I got new error/unreachable Gmail server. I was freaking out until I saw the link on the top right corner giving me the opportunity to switch back to the old interface! For your pleasure only, here are some exclusive screen shots:<br><br> <img src="http://sa.muel.org/f/gmail2.0/02.png"><br>Few mortal have the possibility to switch to the new interface (my email censored using twirl effect).<br><br> <img src="http://sa.muel.org/f/gmail2.0/03.png"><br>New error messages.<br><br> <img src="http://sa.muel.org/f/gmail2.0/04.png"><br>New error messages.<br><br> <img src="http://sa.muel.org/f/gmail2.0/05.png"><br>State of the art loading message.<br><br> <img src="http://sa.muel.org/f/gmail2.0/01.png"><br>Unfortunatly you can't get rid of the chat box.<br><br> <img src="http://sa.muel.org/f/gmail2.0/06.png"><br>New url are definitively cool!<br><br> <img src="http://sa.muel.org/f/gmail2.0/09.png"><br>Hmmm confusing, they are actually online!<br><br> <img src="http://sa.muel.org/f/gmail2.0/08.png"><br>Oops, too many javascripts?<br><br> Ahhh SquirrelMail was the good old days. User-agent faxx0r python class. 2007-06-06T06:45:28-05:00 2007-06-06T06:45:28-05:00 http://sa.muel.org/go/index.php/2007/06/06/50-user-agent-faxx0r-python-class Samuel T. Cossette General Made from about 500 000 hits from an undisclosed servers. Sample usage: import urllib from ua import ua class myOwnUrlOpen(urllib.FancyURLopener): def __init__(self, *args): self.version = ua.gett() urllib.FancyURLopener.__init__(self) o = myOwnUrlOpen() f =... Made from about <a href="/go/files/useragent.rank.text">500 000 hits</a> from an undisclosed servers. Sample usage: <pre> import urllib from ua import ua class myOwnUrlOpen(urllib.FancyURLopener): def __init__(self, *args): self.version = ua.gett() urllib.FancyURLopener.__init__(self) o = myOwnUrlOpen() f = o.open("http://www.coolwebsite.com/") doc = f.read() </pre> The <a href="/go/files/ua.py">sources</a>: <pre> import random class ua: def __init__(self): self.ua = ['Mozilla/5.0 (Macintosh; U; Intel Mac OS X; de-de) AppleWebKit/419 (KHTML, like Gecko) Safari/419.3', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X; ja-jp) AppleWebKit/419 (KHTML, like Gecko)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; .NET CLR 1.1.4322)', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.4) Gecko/20060601 Firefox/2.0.0.4 (Ubuntu-edgy)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; FDM)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1) Gecko/20061010 Firefox/2.0', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; hu; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'kh_lt/LT4.0.2737', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-us) AppleWebKit/419 (KHTML, like Gecko) Safari/419.3', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; (R1 1.5); .NET CLR 1.1.4322)', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; fr; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-BR; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X; it-it) AppleWebKit/419 (KHTML, like Gecko) Safari/419.3', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727)', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; de; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322)', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-US) AppleWebKit/420+ (KHTML, like Gecko, Safari/420) OmniWeb/v607.17', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; MathPlayer 2.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; FunWebProducts; .NET CLR 1.1.4322)', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/419 (KHTML, like Gecko)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.0.12) Gecko/20070508 Firefox/1.5.0.12', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; .NET CLR 1.1.4322)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.1)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.12) Gecko/20070508 Firefox/1.5.0.12', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; InfoPath.1)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.2)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)', 'Opera/9.21 (Windows NT 5.1; U; en)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 2.0.50727; .NET CLR 1.1.4322; Media Center PC 4.0; InfoPath.1)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1)', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.0.12) Gecko/20070508 Firefox/1.5.0.12', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1)', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0)', 'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; es) AppleWebKit/419 (KHTML, like Gecko)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)', 'Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.4) Gecko/20061201 Firefox/2.0.0.4 (Ubuntu-feisty)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0)', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.3) Gecko/20061201 Firefox/2.0.0.3 (Ubuntu-feisty)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2; .NET CLR 1.1.4322)', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.0.12) Gecko/20070508 Firefox/1.5.0.12', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) AppleWebKit/419 (KHTML, like Gecko)', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/419 (KHTML, like Gecko) Safari/419.3', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) AppleWebKit/419 (KHTML, like Gecko) Safari/419.3', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.12) Gecko/20070508 Firefox/1.5.0.12', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', ' 9003 ', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)'] def gett(self): return self.ua[random.randrange(len(self.ua))] </pre> SUN non-breaking news: Java RVNC is now ActiveX RVNC 2007-06-04T09:20:56-05:00 2007-06-04T09:20:56-05:00 http://sa.muel.org/go/index.php/2007/06/04/49-sun-non-breaking-news-java-rvnc-is-now-activex-rvnc Samuel T. Cossette General Last summer I had chance to play with a SUN X4200 via the Try&Buy program. I was already familiar with command line interface BIOS from SUN, but that Java LOM (light out management) was just amazing. First time in my life (post-twenties) that I did not sweat while plugging a monitor to physically... <p>Last summer I had chance to <a href="http://sa.muel.org/go/images/IMG_5102.jpg">play with a SUN X4200</a> via the <a href="http://www.sun.com/tryandbuy/">Try&Buy</a> program. I was <a href="http://sa.muel.org/weirdos/misc/chambre.jpg">already familiar</a> with command line interface BIOS from SUN, but that Java LOM (light out management) was just amazing. First time in my life (post-twenties) that I did not sweat while plugging a monitor to physically manage a computer: thanks to VGA in the browser.</p> <p>We recently bought a SUN X2100. Low power consumption, cheap, commodity component and last but not least a SUN LOM, I like. </p> <p>So we're in! The box, us and 2184 other cabinets. It took us 3 minutes to unwrap the packages, 2 minutes to add the harddrives, 2 to wire it. We're ready to mount debian-40r0-i386-netinst.iso over the network. First <a href="http://sa.muel.org/go/images/connection_failed.png">oups</a> from Mac OS X / Firefox , second <a href="http://forum.java.sun.com/thread.jspa?threadID=5118638">oups</a> from Firefox/Parallels/Windows xp, then third <a href="http://sa.muel.org/go/images/oups3.png">oups</a> from Parallels/Windows xp/Internet Explorer. Strike. Erk, Java RVNC is now ActiveX RVNC. </p> <p>Nice <a href="http://www.linuxjournal.com/article/9624">interview</a> <a href="http://blogs.sun.com/webmink/">Phipps</a> but, what's going on at SUN?</p> Zero padded seq 2007-05-24T15:33:14-05:00 2007-05-24T15:33:14-05:00 http://sa.muel.org/go/index.php/2007/05/24/48-zero-padded-iseq-i Samuel T. Cossette General root@vee01:/var/log/apache2 # for i in `seq -f "%02g" 1 31`; do echo -n "$i "; grep -c "$i/Apr" /tmp/rsn.log; done 01 0 02 0 03 3 04 3711 05 3067 06 2677 07 2471 08 2559 09 2859 10 2951 11 3197 12 3165 13 2873 14 2372 15 2568 16 3243 17 3250 18 3132 19 2956... <pre> root@vee01:/var/log/apache2 # for i in `seq -f "%02g" 1 31`; do echo -n "$i "; grep -c "$i/Apr" /tmp/rsn.log; done 01 0 02 0 03 3 04 3711 05 3067 06 2677 07 2471 08 2559 09 2859 10 2951 11 3197 12 3165 13 2873 14 2372 15 2568 16 3243 17 3250 18 3132 19 2956 20 2316 21 2387 22 2533 23 3169 24 3103 25 1333 26 0 27 0 28 0 29 0 30 0 31 0 </pre> See: <a href="http://www.gnu.org/software/coreutils/manual/html_node/seq-invocation.html">http://www.gnu.org/software/coreutils/manual/html_node/seq-invocation.html</a> Cheap timezone webservice. 2007-05-16T01:06:00-05:00 2007-05-16T01:06:00-05:00 http://sa.muel.org/go/index.php/2007/05/16/47-cheap-timezone-webservice Samuel T. Cossette General Populate database using timezone shapefiles (http://openmap.bbn.com/data/shape/timezone/) 469 createdb timezone 470 createlang plpgsql timezone 471 psql timezone -f /usr/src/postgis-1.2.1/lwpostgis.sql 472 psql timezone -f /usr/src/postgis-1.2.1/spatial_ref_sys.sql 473... Populate database using timezone shapefiles (http://openmap.bbn.com/data/shape/timezone/) <pre> 469 createdb timezone 470 createlang plpgsql timezone 471 psql timezone -f /usr/src/postgis-1.2.1/lwpostgis.sql 472 psql timezone -f /usr/src/postgis-1.2.1/spatial_ref_sys.sql 473 ogr2ogr -f PostgreSQL PG:"dbname=timezone host=localhost" WrldTZA.shp -nln timezone -a_srs epsg:4326 -nlt GEOMETRY </pre> Fix the small glitch in 'offset' column <pre> postgres@mapserver:/root$ psql timezone Welcome to psql 8.1.8, the PostgreSQL interactive terminal. timezone=# update timezone set "offset" = substring("offset", '[\-,0-9]+'); </pre> Here is my timezone webservice using web.py (http://www.webpy.org) <pre> import _pg import web d = _pg.connect("timezone", "localhost", user='postgres') class tz: def GET(self, lon, lat): r = d.query("select noffset from timezone where wkb_geometry && GeomFromText('POINT(%s %s)', 4326) limit 1;" % (lon, lat)) print int(r.getresult()[0][0]) if __name__ == "__main__": urls = ( '/(.*)/(.*)', 'tz' ) web.run(urls, globals()) </pre> Wouhahahaha. Installing bgl-python [on Debian] 2007-05-08T03:17:15-05:00 2007-05-08T03:17:15-05:00 http://sa.muel.org/go/index.php/2007/05/08/46-installing-bgl-python-on-debian- Samuel T. Cossette General 615 wget http://superb-west.dl.sourceforge.net/sourceforge/boost/boost_1_34_0_beta.tar.bz2 620 tar xjvf boost_1_34_0_beta.tar.bz2 621 cd boost_1_34_0 625 bjam --toolset=gcc install Install bjam (aka Boost.Jam) 639 export BOOST_ROOT=/root/libs/sam/boost_1_34_0 641 cd... <pre> 615 wget http://superb-west.dl.sourceforge.net/sourceforge/boost/boost_1_34_0_beta.tar.bz2 620 tar xjvf boost_1_34_0_beta.tar.bz2 621 cd boost_1_34_0 625 bjam --toolset=gcc install</pre> <p>Install bjam (aka Boost.Jam)</p> <pre> 639 export BOOST_ROOT=/root/libs/sam/boost_1_34_0 641 cd $BOOST_ROOT/tools/jam/src 642 ./build.sh</pre> <p>Install Boost.Python</p> <pre> 646 cd /root/libs/sam/boost_1_34_0/libs/python/ 648 cd test/ 654 bjam --toolset=gcc test</pre> <p>Install bgl-python (you need development version for Jamfile v2 (needed by bjam / boost 1.34))</p> <pre> 805 svn co https://svn.osl.iu.edu/svn/projects_viz/bgl-python 806 cd bgl-python 816 echo "using python : 2.3 ;" &gt;&gt; /root/libs/sam/boost_1_34_0/tools/build/v2/user-config.jam 842 bjam --pythonlibdir=/usr/lib/python2.4/site-packages/ --exec-prefix=/usr/ install 843 python -c "import boost.graph as bgl"</pre> <p>Yeah!</p> <pre></pre> <p>Things that help:</p> <pre> 609 vi README 815 bjam --debug-configuration 816 vi /root/libs/sam/boost_1_34_0/tools/build/v2/user-config.jam (bjam config file) boost is at http://www.boost.org, bgl-python is at http://www.osl.iu.edu/~dgregor/bgl-python/</pre> <p>Notes:</p> <pre> 1. Boost team (excluding bgl-python) doesn't known how to summarize or write technical howto. 2. #boost people on irc.freenode.net are scary but helpful. 3. 2.2ghz is not enough for everybody.</pre> vserver / iptables hack. 2007-05-07T04:08:17-05:00 2007-05-07T04:08:17-05:00 http://sa.muel.org/go/index.php/2007/05/07/45-vserver-iptables-hack Samuel T. Cossette General Problem (need to access a local host when chbinded to a public ip address.): ##:/opt/back# chbind --ip 64.##.137.## ping -c 1 10.2.1.11 ipv4root is now 64.##.137.## PING 10.2.1.11 (10.2.1.11) 56(84) bytes of data. 10.2.1.11 ping statistics --- 1 packets transmitted, 0 received, 100% packet loss,... <p>Problem (need to access a local host when chbinded to a public ip address.):</p> <pre>##:/opt/back# chbind --ip 64.##.137.## ping -c 1 10.2.1.11 ipv4root is now 64.##.137.## PING 10.2.1.11 (10.2.1.11) 56(84) bytes of data. 10.2.1.11 ping statistics --- 1 packets transmitted, 0 received, 100% packet loss, time 0ms</pre> <p>Solution (aka hack):</p> <pre>##:/opt/back# for i in `cat /home/samuel/ipz`; do &gt; iptables -t nat -A POSTROUTING -s $i -d 10.2.1.11 -j SNAT --to-source 10.4.1.254; &gt; done ##:/opt/back# chbind --ip 64.##.137.## ping -c 1 10.2.1.11 ipv4root is now 64.##.137.## PING 10.2.1.11 (10.2.1.11) 56(84) bytes of data. 64 bytes from 10.2.1.11: icmp_seq=1 ttl=64 time=51.0 ms 10.2.1.11 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 51.069/51.069/51.069/0.000 ms ##:/opt/back#</pre>