http://www.spikelab.org/blog You never know what people are after en Copyright 2005 - 2006 Filippo Spike Morelli 60 Thu, 27 Mar 2008 14:03 GMT fsm@spikelab.org PyBlosxom http://pyblosxom.sourceforge.net/ 1.3.2 2/13/2006 mysqlDefaultSQLMODEIsEvil http://www.spikelab.org/blog/mysqlDefaultSQLMODEIsEvil.html Recently I took a peak at a default mysql installation and found one interesting, to not say scary, thing. SQL_MODE comes set to empty string and if you dig into the documentation you find that... you find nothing! Yes you heard me, whatever a blank SQL_MODE means is not known yet is what most of the people run with because this little fact is advertised nowhere, especially not in the post installation guidelines. more » ]]> Thu, 27 Mar 2008 14:03 GMT logfilesNeedTimestamp http://www.spikelab.org/blog/logfilesNeedTimestamp.html If there are a couple things that a few years of system administration should have taught you, the importance of backups and logs is one. more » ]]> Sat, 15 Mar 2008 21:03 GMT manageIpsDatabase http://www.spikelab.org/blog/manageIpsDatabase.html To be compatible across different backends the best option is to store ips and netmasks as longint and manage the transformations in code, otherwise, if compatibility is not a concern or writing that code is a problem, both mysql and postresql offer their own built-in functions to aid with the job. more » ]]> Mon, 18 Feb 2008 10:02 GMT namecheap http://www.spikelab.org/blog/namecheap.html A while ago I set on the search for a cheap domain and ssl certs reseller and settled for namecheap.com. Here I'm documenting my, overall positive, experience with them. more » ]]> Sat, 16 Feb 2008 22:11 GMT domainsSSLCertsHome http://www.spikelab.org/blog/domainsSSLCertsHome.html I never cared too much about my web presence and spikelab.org is the only domain I ever owned, so back then doing extensive researches to save a couple bucks didn't make much sense. Someone recommended Gandi to me and there I bought it. As for ssl certificates, CACert is what we all should use and push for, but right now we're far from a large adoption, and considering the associated fees (read bribes) required to be accepted in largely used browsers like IE it won't probably ever happen. more » ]]> Tue, 13 Nov 2007 14:11 GMT moveWebsitesNoDowntime http://www.spikelab.org/blog/moveWebsitesNoDowntime.html A friend of mine had to move some websites configured as vhosts on a certain ip to another hoster/ip and wanted this to happen without users noticing. The common approach is to lower the TTL a few days before switching to the new ip and maintain the old server up for an overlapping period. This is necessary because of broken dns cachers that won't honor the TTL and serve the cached ip. more » ]]> Thu, 01 Nov 2007 23:11 GMT newSpikelabStyle http://www.spikelab.org/blog/newSpikelabStyle.html Last night I had some kind of brainfart and ended up creating a new style for my website. It's kinda funny 'cause it took me ages to decide about my former one and instead this came out in about 1 hour. To me this looks much better, cleaner and more readable now that I moved away from the black background. The logo has been cut from a wallpaper I had in my collections, unfortunately I cant trace the author, all I could find is a reference on deviantart saying the wallpaper is from pixelgirlpresents.com, but that's it. Hope you like it.

]]> Sat, 27 Oct 2007 13:10 GMT tracForCustomers http://www.spikelab.org/blog/tracForCustomers.html I have some friends running a music digital promotion company and I recently got them on Trac. They simply loved it, and kept on saying for weeks they couldn't believe they worked without such tool. Face it, especially if your business is software development, living without a SCM/project management system is a suicide. more » ]]> Tue, 25 Sep 2007 22:09 GMT trackDownPhpScript http://www.spikelab.org/blog/trackDownPhpScript.html I've been asked again how to track down a php script abused by spammers on a standard LAMP platform running apache and mod_php. So here it goes. more » ]]> Tue, 28 Aug 2007 22:08 GMT aQuickUpdate http://www.spikelab.org/blog/aQuickUpdate.html I always tried to post at least a couple times a month, it's fun, I like it, and it's been helpful to jot down whatever I was working on for future reference. But in the last month things got really hectic at work, being in e-learning, summer is when big stuff happens as we have pretty much no users using our network. more » ]]> Tue, 21 Aug 2007 23:08 GMT