Open Source

PGCon 2009 Schedule released

Leave a Comment / Conferences, PGCon, PostgreSQL / By / /

The preliminary PGCon 2009 schedule has been released. PGCon is the premiere PostgreSQL conference. It is simply the best place to meet other PostgreSQL people and learn more. The talks are absolutely amazing, not to mention the great social atmosphere. If you’re looking to hire any PostgreSQL talent, PGCon is the place to be. You’ll find more PostgreSQL people (DBAs, coders, web developers, core contributers) than at any other conference. If you’re looking […]

PGCon 2009 Schedule released Read More »

Moving my PGP from Windows to KDE

Leave a Comment / Open Source / By /

I found my old PGP key today. I haven’t used it in quite some time. But there it was, on my Windows machine: secring.skr I use Thunderbird on FreeBSD, under KDE. I see I need to install mail/enigmail if I want to use PGP (well, the GnuPG implementation of PGP). This appears to be my slippery slope. First, I encountered this: [dan@laptop:/usr/ports/mail/enigmail] $ sudo make install clean Password: => enigmail-0.93.0.tar.gz doesn’t seem to

Moving my PGP from Windows to KDE Read More »

Migrating one Bacula Volume to another

Leave a Comment / Backups, Bacula, Open Source / By /

I run Bacula. I have coded for Bacula. Now I’m writing about Bacula again. Bacula is by far and away the best open source program for managing network-based backups. In this article, I will show you how I migrated a bunch of jobs from a disk Volume to a tape Volume. However, the approach I will use can be applied to any type of job migration. Why bother? I’m running of disk space

Migrating one Bacula Volume to another Read More »

Avoiding dynamic IP address woes with a VPN

8 Comments / DNS, Networks, Open Source, OpenVPN / By /

I’m sick of dealing with dynamic IP issues. My broadband connection at home has a dynamic IP address. I can always find out what my home IP address is. I’m using dns/noip to manage a hostname which points to home. I can always ssh home via the hostname. The problems arise when I try to restrict access to services provided at home or access to services on external servers. For example, the web

Avoiding dynamic IP address woes with a VPN Read More »

SVN commits now available

Leave a Comment / FreeBSD, FreshPorts, Open Source / By /

The SVN commits are now available for viewing. At present, only the FreeBSD src tree is working through SVN. Therefore, the easiest way for you to see those commits is through the FreshSource interface. That link takes you to the SVN version. You will notice that the src commits are duplicated. This was not done intentionally. However, it is fortunate in it allows for easy fact checking. This error is possible only because

SVN commits now available Read More »

Database load times

Leave a Comment / FreeBSD, Open Source, PostgreSQL / By /

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

1 Comment / Open Source, PostgreSQL / By /

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 »

stunnel “local socket: Protocol not supported”

3 Comments / FreeBSD / By /

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 »

cfengine – practical examples

Leave a Comment / Open Source / By /

In a sea of inadequete cfengine examples, one stands out: http://www.sysadmin.hep.ac.uk/wiki/Cfengine. I’m in the early stages of developing an administration strategy for a jail server I’m setting up. It will run regression tests for Bacula. I’ve already found ezjail, which will help me create the jails. What I needed was tool for administering the jails. I don’t want to ssh to 10 different systems just to update a script on each one. I

cfengine – practical examples Read More »

Scroll to Top