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 […]
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,
Keeping Fruity running Read More »
After recent efforts to get old jails running on a new server, I tried to upgrade some ports today. I failed. portupgrade was erroring out and reporting: protocol not supported A simple fetch http://www.google.com/ was giving me fetch: transfer timed out I tried portaudit -Fa. Nothing. fetch: transfer timed out I checked ifconfig on the
jail: fetch: transfer timed out / protocol not supported Read More »
Recently, I was moving some jails from one server to another. First, I created the jail using the -x switch, which indicates the jail already exists, don’t create it, just add entries for it: # ezjail-admin create -f bacula -x mysql41.example.org 10.35.0.100 Warning: Some services already seem to be listening on IP 10.35.0.100 This may
jail: execv: /bin/sh: No such file or directory Read More »
After running the script which upgrades your Bacula database to version 14, there are a couple of fix-ups you may wish to run: alter table restoreobject owner to bacula; grant all on restoreobject_restoreobjectid_seq to bacula; grant all on restoreobject to bacula; You may or may not have to do this, depending on how you ran
Upgrading to Bacula database version 14 Read More »
I encountered this situation recently. I had consolidated two logins. One was for 2012, the other for 2011. It’s better to reuse your login from previous years instead of creating a new one each year. Why? It lets the program committee see what you’ve submitted in previous years. They can see your previous acceptances/rejections. That
Pentabarf authentication issues Read More »
The list of talks and speakers for PGCon 2012 has been released. For 2012, we once again have a strong collection of talks that will appeal to a wide range of attendees.
PGCon 2012 schedule released Read More »
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 = ‘BSDCan2012’
After a very long effort, this is the solution: CREATE OR REPLACE FUNCTION conflict.conflict_statistics(conference_id integer, OUT conflict_level text, OUT conflicts integer) RETURNS SETOF record LANGUAGE plpgsql AS $function$ #variable_conflict use_variable DECLARE conflict TEXT; conflict_rows INTEGER; BEGIN FOR conflict_level IN SELECT conflict_level.conflict_level FROM conflict.conflict_level WHERE conflict_level.conflict_level ‘silent’ ORDER BY rank LOOP conflicts = 0; FOR conflict
Today I received this rather devious spam. Invoke education, children, libraries, and hope that someone will link to their site. I’m not sure *why* they want this particular site promoted. There’s not much useful information there. No attempt to sell anything. I’m confused. Perhaps this was legit. But then, if you search for certain phrases