Here is the start of a query for pulling out travel requirements for conference attendees. SELECT P.last_name, P.first_name, CPT.arrival_from, CPT.arrival_to, CPT.need_accommodation FROM conference_person_travel CPT, conference_person CP, conference C, person P WHERE CPT.need_accommodation AND CPT.conference_person_id = CP.conference_person_id AND P.person_id = CP.person_id AND CP.conference_id = C.conference_id AND C.acronym = ‘BSDCan2015’
This is the first in a series of articles on my migration to WordPress. I have another diary (The FreeBSD Diary). I’ve been running it since 1998. More than once I’ve been asked why doesn’t it use some blogging package. Well, I didn’t know of anything back then, and cobbled together my own solution. The website is just static HTML, with some PHP functions to provide common headers, sidebars, footers, etc. There is
Importing data into WordPress Read More »
Last night, I found that I had a number of unused ZFS snapshots. I decided to destroy some of them. The first destroy locked up the system. Nagios reported everything was dead. I remotely power cycled the system. After it came back, I noticed that a scrub was in progress. This had not been initiated because of the power cycle. The scrub was a weekly automatic operation which started some hours before my
Destroying some unneeded ZFS snapshots Read More »
I have been using Bacula since early 2004. That’s nearly 9 years of great backups. Back in early 2010, I set up a multi-terabyte system in my basement with commodity hardware. Today, after about 18 months of backups, it’s starting to fill up. Now is the time to start restricting the creation of new Volumes in order to force the recycling of older expired (but still on disk) Volumes. NOTE: actually, I did
Bacula volumes – running low on disk space Read More »
OK, let’s compare the two snapshots, one taken today, the other taken on Monday. [dan@ngaio:/usr] $ sudo du -c -d 1 . Password: 4 ./.snap 62760 ./bin 37520 ./include 93068 ./lib 184 ./libdata 35384 ./libexec 75109696 ./local 37708 ./sbin 102480 ./share 1103840 ./src 250268 ./compat 376 ./games 4 ./obj 71082728 ./home 3584112 ./ports 4 ./tmp 18287800 ./websites 4 ./bacula-restores 1335104 ./FreshPorts 21599028 ./samba_mounts 58065982 ./jails 250788058 . 250788058 total [dan@ngaio:/usr] $ [dan@ngaio:/usr] $
It seems the /usr partition on my dev box is filling up. But I’m not sure what is eating up the space. So let’s take a snapshot of the space and compare it later. [dan@ngaio:/usr] $ sudo du -c -d 1 . Password: 4 ./.snap 62760 ./bin 37520 ./include 93068 ./lib 184 ./libdata 35384 ./libexec 75109696 ./local 37708 ./sbin 102480 ./share 1103840 ./src 250268 ./compat 376 ./games 4 ./obj 71082728 ./home 3584112 ./ports
What’s using up /usr? Read More »
I still run Fruity, a web-based configuration tool for Nagios. Yes, I still run Nagios. I ran into a problem today where Fruity would not export and relaunch Nagios. I noticed these entries in my logs: Mon Aug 20 15:06:43 2012] [error] [client 96.245.113.112] PHP Warning: unlink(/tmp/512f590153b47413deef6b5d995dafc2/././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././../ in /usr/local/www/fruity/export.php on line 34, referer: https://fruity.example.org/fruity/export.php Ummm, why is it doing that. Well, I hacked the code and came up with a fix: //Remove all
Keeping Fruity running Read More »
Here are a few SPF tools which I recently used. http://www.openspf.org/Tools – an email based tester http://tools.bevhost.com/spf/ – web based tester http://www.mailradar.com/spf/ – wizard to create SPF records http://www.mtgsy.net/dns/spfwizard.php – a wizard for setting up SPF I needed to alter some of my SPF records because they were out of date, and therefore, no longer accurate.
mod_watch is a now unsupported package, originally created by Anthony C. Howe. I first learned of this software, from this Cacti post, when looking to graph statistics from my various Apache virtual hosts. I want to incorporate this data into my existing cacti installations. For those suggesting I use something other than cacti: thanks, but switching tools is not in the scope of this problem. mod_watch is available on github where it was
Getting mod_watch running with Apache 2.2 Read More »
Recently, I saw this log entry: Jul 19 08:00:05 nyi Mailman mail-wrapper: Group mismatch error. Mailman expected the mail wrapper script to be executed as group “mailman other mail daemon”, but the system’s mail server executed the mail script as group “mailman”. Try tweaking the mail server to run the script as group “mailman other mail daemon”, or re-run configure, providing the command line option `–with-mail-gid=mailman’. Searching around, it seems this is a
mailman – Group mismatch error Read More »