LART’s Blog

I know what the 3 of you who have my blog’s rss are thinking 2 posts in 1 day wtf?  well I finally come up with something to talk about.  This is related to my first post but it’s different enough that I’m making it a second post.

A number of people have requested that we use Postgresql instead of mysql.  At first I thought it was going to be a walk in the park after all the are both SQL… well I had never setup a dbms other then mysql and well postgresql has a LOT of options and is really diffrent from mysql.  The confusing file is pg_hba.conf mostly because there’s 9 different ways to  authenticate to the db server and you can set that differently for different hosts.  Then there’s the little differences.  If you want to quit you type \q if you want to list the tables you type \d if you want to see the structure of a table you type \d table_name.  Now I get to try and get php to work nicely with postgresql

I’ve been working for a little bit now on a new project that we started calling the IP archive project.  The idea is we keep a track of what ip’s are up to bad things and put dates next to this.  There’s a few diffrent ways we plan on getting data all in all I think it’s going to be a HUGE project.  However one idea that was brought up was keeping track of domains.  say that a spammer has a domain that they use for 5 days and then git rid of and have 10 more domains that they do the same thing with but all point to the same ip.  With this we will be able to search for stuff like.  One thing you could do with that is go hay this domain resoloves to an ip that spammers have used in the past let’s not trust it as much.