NEWS:

Archive for the 'General' Category

Pentabarf travel

Saturday, January 21st, 2012

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 = […]

memtestosx

Sunday, January 8th, 2012

I just bought and downloaded memtestosx.

Last login: Sun Jan 8 16:14:10 on ttys001
[dan@dent:~] $ /Volumes/memtest_422/memtest/memtest ; exit;

Memtest version 4.22 (64-bit)
Copyright (C) 2004 Charles Cazabon
Copyright (C) 2004-2008 Tony Scaminaci (Macintosh port)
Licensed under the GNU General Public License version 2 only

NOTE: No command-line arguments have been specified
Using defaults: Test all available memory, one test […]

Pentabarf fix

Friday, December 30th, 2011

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 […]

Such devious spam

Thursday, October 6th, 2011

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, […]

When is a cleaning tape needed?

Monday, June 20th, 2011

As part of my magical Bacula website, I wanted to know when my tape drive required a cleaning tape. It appears that smartctl will reveal this information:

[dan@kraken:/usr/home/dan] $ sudo /usr/local/sbin/in/smartctl -d scsi -x /dev/nsa0
Password:
smartctl 5.39.1 2010-01-28 r3054 [FreeBSD 8.2-STABLE amd64] (local build)
Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net

Device: DEC […]

Bacula - Removing labels, then labeling tapes

Friday, May 27th, 2011

I have been using Bacula since 2004. I started off on DDS tapes, then moved to DLT. Now I’m backing up to a ZFS array and the copying to tape.
About a year ago, I obtained about 200 DLT tapes from a friend. They were no longer used at his place of work. […]

Bacula run-after scripts

Sunday, May 15th, 2011

Bacula is a backup and restore solution which I’ve been using and contributing to since 2004. Recently, I started backing up to disk and then copying to tape later. This approach, combined with a scratch pool, has proven to be very low maintenance, from a sysadmin point of view. I think all […]

INQUIRY command Failed

Wednesday, April 6th, 2011

I hate it when this happens:

[root@kraken /usr/home/dan]# /usr/local/sbin/mtx-changer /dev/pass10 list
mtx: Request Sense: Long Report=yes
mtx: Request Sense: Valid Residual=no
mtx: Request Sense: Error Code=0 (Unknown?!)
mtx: Request Sense: Sense Key=No Sense
mtx: Request Sense: FileMark=no
mtx: Request Sense: EOM=no
mtx: Request Sense: ILI=no
mtx: Request Sense: Additional Sense Code = 00
mtx: Request Sense: Additional Sense Qualifier = 00
mtx: Request Sense: BPV=no
mtx: Request […]

SSD

Wednesday, March 9th, 2011

This looks interesting for an SSD. A co-worker was saying: SandForce is the way to go.

Pentabarf hyperlinks

Sunday, March 6th, 2011

Links within events in Pentabarf are done like this:
[text](http://example.org/)