Jade's weblog Archive

Analyzing queries in Postgres [www.databasejournal.com]

Good article on logging and analyzing queries in Postgres, thanks to Jeff.

12:15 PM, 30 Jun 2004 by Jade Rubick Permalink | Comments (0)

Example of after-mount callback [xarg.net]

The link doesn't actually go to the after-mount callback, but it shows how it's added into the .info file.

11:54 AM, 28 Jun 2004 by Jade Rubick Permalink | Comments (0)

Setting up PHP on Aolserver [panoptic.com]

.

01:51 PM, 23 Jun 2004 by Jade Rubick Permalink | Comments (0)

Perl script to rename Postgres user in dump file

perl -pi -e "s/^\\connect olduser$/\\connect newuser/" filename

Thanks, Dave, Dossy, and Til.

To load in the database dump:

psql -f filename dbusername

12:44 PM, 22 Jun 2004 by Jade Rubick Permalink | Comments (0)

Making an SMTP conversation [www.cs.cf.ac.uk]

Helpful reference.

02:43 PM, 20 Jun 2004 by Jade Rubick Permalink | Comments (0)

Updated easy virtual hosting document

I updated my easy virtual hosting document. I finally fixed the most major problem I was having with it.

12:39 PM, 20 Jun 2004 by Jade Rubick Permalink | Comments (0)

Setting up a mailserver on Qwest

My ISP (Qwest) recently implemented a brain-dead measure to prevent spam. They require you to check your email before you can send out email.

Of course, this doesn't prevent spam at all -- it only makes it harder if you have a low-volume mail server. Here's what I did to get around this:

$ crontab -e

Add this line:

*/10 * * * * /usr/bin/telnet pop.ptld.qwest.net 110 < /home/mename/bin/script.txt >& /dev/null

Every ten minutes, it connects to port 110, and runs the contents of bin/script.txt

$ cat bin/script.txt
user username@qwest.net
pass mypassword
list
quit

10:36 AM, 20 Jun 2004 by Jade Rubick Permalink | Comments (0)

Setting up spamassassin site-wide [www.stearns.org]

Interesting..

What I actually ended up doing, however, is setting Spamassassin up with Exim

10:02 PM, 19 Jun 2004 by Jade Rubick Permalink | Comments (0)

Set up courier-imap on Debian [talk.trekweb.com]

I used this link to set up courier-imap. I also looked at http://www.crazysquirrel.com/debian/mail.php

08:49 PM, 19 Jun 2004 by Jade Rubick Permalink | Comments (0)

Electoral map currently predicts Kerry win [www.electoral-vote.com]

This changes every day, I believe. Thanks to Joel.

12:21 PM, 19 Jun 2004 by Jade Rubick Permalink | Comments (0)

I appear in an article in the University of Oregon's Cascade magazine [www.safe4all.org]

I appeared in another article featuring my work with Stop Abuse For Everyone. It was a very positive article, I think.

01:00 AM, 06 Jun 2004 by Jade Rubick Permalink | Comments (0)

XML