2008

Database load times

With all the databases I run, I need a daily sanity check. I download a copy of each database and do a test load on my system at home. Today I timed that process: $ time ~/bin/backup-supernews.sh … real 77m57.323s user 12m52.610s sys 0m56.136s There are 11 such databases. The dump files range in size from 5K (globals.sql) to 2.8G (freshports.sql). The script that does this is pretty simple, but has evolved over […]

Database load times Read More »

openx upgrade issues

I’ve been running ads on my websites since early 1999, so nearly 10 years. It was roughly May 2002 that I started using phpPgAds. This was the PostgreSQL version of phpAdsNew. This project became OpenAds and is now known as OpenX. Recently I decided to upgrade to the latest version of OpenX. There was a upgrade path from Openads-PgSQL-2.0.11-pr1, the latest releast of OpenAds to use PostgreSQL, to OpenX 2.6. The first problem

openx upgrade issues Read More »

Short term plan

I have several items I would like to complete in the short term. Writing them down may help me commit to doing them. To Do Upgrade the NYI server to the latest version of PostgreSQL Prepare the BSDCan and PGCon websites for 2009 (partly done) Get MacPorts running on my MacBook Get spamd running on the new server Add a check to Nagios to check that system email arrives each day (e.g. ‘security

Short term plan Read More »

stunnel “local socket: Protocol not supported”

Tonight I encountered this problem when starting stunnel: 2008.10.17 02:46:02 LOG7[43534:134656000]: Private key loaded 2008.10.17 02:46:02 LOG7[43534:134656000]: SSL context initialized for service 6000 2008.10.17 02:46:02 LOG5[43534:134656000]: stunnel 4.25 on i386-portbld-freebsd6.3 with OpenSSL 0.9.7e-p1 25 Oct 2004 2008.10.17 02:46:02 LOG5[43534:134656000]: Threading:PTHREAD SSL:ENGINE Sockets:POLL,IPv6 Auth:LIBWRAP 2008.10.17 02:46:02 LOG6[43534:134656000]: file ulimit = 11095 (can be changed with ‘ulimit -n’) 2008.10.17 02:46:02 LOG6[43534:134656000]: poll() used – no FD_SETSIZE limit for file descriptors 2008.10.17 02:46:02 LOG5[43534:134656000]: 5417 clients

stunnel “local socket: Protocol not supported” Read More »

New Bacula features

There are several new interesting features in the upcoming Bacula release. Including, but not limited to: “Accurate” backups regardless of mtime, mv, rm, etc Copy Jobs Virutal Backup / Synthetic Backup / Consolidation Duplicate Job Control TLS Authentication Ignore Dir Honor No Dump Flag Plugins libdbi framework These features are being added to the development 2.5.x versions to be released as Bacula version 3.0.0. This release is expected to occur near the end

New Bacula features Read More »

Biff + stitches

I biffed last night. Hard. It was in Wissahickon. Fortunately, the injuries will heal and no scars will be visible, unless I want them to. It was entirely my fault. I sat where I should have stood and got tossed over the bars. I was going too fast too. :) I have four, maybe five stitches in my right elbow, one stitch in my right knee, a severely bruised left thigh, and lots

Biff + stitches Read More »

Scroll to Top