Linux
« Previous EntriesMySQL average times
Friday, September 28th, 2007I was trying to calculate average time in MySQL. I had a “time” field. After fooling around I came up with:
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(actual_arrival))/COUNT(actual_arrival))
FROM arrival_times;
It actually is pretty fast too.
Happy SysAdmin Day!
Friday, July 27th, 2007Today is Sys Admin Day
Where’s my presents!??????
Postfix and Spamassassin
Saturday, August 19th, 2006I’ve been using Postfix / Spamassassin / Amavisd-new / Procmail for a while now. The wierd thing is mail that goes to an alias from /etc/aliases doesnt get X-Spam-Status headers written to it.
I’ve been using a procmail recipe to fix this problem. Anyone have an idea of how to fix this within postfix?
Weird Ident requests
Wednesday, March 23rd, 2005ns.strangecode.com requested ident from my qmailr user 235 times between 10:22 and 10:31am today.. dunno why. Weird.
Linux World Days 1-3
Wednesday, August 4th, 2004Jeez, I keep forgetting to write about LinuxWorld.. First of all, sitting on a bed and using the laptop gets very uncomfortable after about 20 minutes in one position.
The weather has been great here.. high 50’s at night and high 60’s in the daytime.. The conference has been great, got so much free stuff, im [...]
Linux World Arrival
Sunday, August 1st, 2004Made it to San Francisco this afternoon for Linux World. The weather is real nice, about 68 degrees right now.. The hotel is decent, but the wireless seems to be flaky, it’s acting like a linksys router or something.. every minute or so it drops me. I’ve got the same issues in linux and windows [...]
SpamAssassin Addons
Wednesday, April 21st, 2004Been running SpamAssassin on the mail server for quite some time.
The following .cf files have reduced the amount of spam by a noticable bit.
http://www.stearns.org/sa-blacklist/sa-blacklist.current
http://mywebpages.comcast.net/mkettler/sa/antidrug.cf
http://www.merchantsoverseas.com/wwwroot/gorilla/bigevil.cf
Throw them in your /etc/mail/spamassassin/ directory and restart spamd. Oh yeah, make sure and : “mv sa-blacklist.current 50blacklist.cf“.
Make sure you keep them up to date, that way you will be blocking all [...]
Wiki’ing
Thursday, April 15th, 2004Been documenting the entire network/server layout here at the office. I decided to do it in WikiTikiTavi[1], so that it would be easy to update. I chose this wiki implementation because it wrote to a mysql database. Plus it’s been running about 6 months anyway. If I was to redo it now, I might use [...]
MozDex Open Source Search
Wednesday, April 14th, 2004Byron made the news for MozDex today. Pretty neat what they are doing, a fully open source search engine. It’s the first search engine based on open source software. Check out the article: MozDex - Open Source Search Engine Launches the Search Engine Journal
You can use MozDex (which is in beta) here.
New Server!
Tuesday, April 13th, 2004Well, thanks to :
Scott, Torrent, Thomas, AdJohnny, and Andy (yes in that order). This site is being hosted on a much better server.
P4 1.6ghz
1gig ddr
160gig hd