Open Source

Keeping Fruity running

Leave a Comment / Open Source / By /

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 »

jail: fetch: transfer timed out / protocol not supported

Leave a Comment / FreeBSD, Jails, Networks / By /

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 host. There is was. I’ll show only a small part of the ifconfig output: $ ifconfig inet

jail: fetch: transfer timed out / protocol not supported Read More »

jail: execv: /bin/sh: No such file or directory

2 Comments / BSDCan, FreeBSD, Open Source, The FreeBSD Diary / By /

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 cause some confusion, here they are: root ntpd 63822 25 udp4 10.35.0.100:123 *:* Warning: Some services already seem

jail: execv: /bin/sh: No such file or directory Read More »

Upgrading to Bacula database version 14

Leave a Comment / Bacula / By /

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 the upgrade script. Examine the following command output for your database: bacula=# \dt restoreobject List of relations Schema

Upgrading to Bacula database version 14 Read More »

Pentabarf authentication issues

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

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 is very useful, both in a negative and a positive fashion. The error upon login was: You are

Pentabarf authentication issues Read More »

Pentabarf travel

Leave a Comment / Pentabarf, PostgreSQL / By /

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’

Pentabarf travel Read More »

Pentabarf fix

1 Comment / Pentabarf, PostgreSQL / By /

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 IN SELECT conference_phase_conflict.conflict FROM conflict.conference_phase_conflict INNER JOIN conference ON ( conference.conference_id = conference_id AND conference.conference_phase = conference_phase_conflict.conference_phase )

Pentabarf fix Read More »

Such devious spam

Leave a Comment / Open Source / By /

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 contained in this email, you’ll see other such posts. I’m certain it’s spam. By, the way, I’ve amended

Such devious spam Read More »

ZFS details – just in case

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

I use a ZFS array for backups. The data is first copied to this array, and later copied to tape. This post contains some information which might be useful should I need to replace one of the drives in the array. We have 10 HDD in this system. Two are used in a gmirror for the base OS: ada8 ada9 Seven are active in an array: ada0 ada2 ada3 ada4 ada5 ada6 ada07

ZFS details – just in case Read More »

Scroll to Top