July 2004

Homeland security threat level

When you can't win at the ballot box then move the ballot box. We learned earlier this year that the methods of extracting information from prisioners, borrowed from sadistic dictators, had been added to the adminstration's bag of tricks. Now comes the news that the Department of Homeland Security is looing at ways of postponing elections. Does it scare anyone that a president who was not elected by a majority of the people, who leads his country to destroy a weaker country on the basis of l

Driving Naked

I spent most of today driving wihtout a flasher for the turn signals. It would not have been so bad but when it fails the turn signal won't come on. It leads to an odd feeling as though one is driving totally exposed. It is worth remembering for VW Passat owners that the flasher is the hazard flasher. I had two parts stores not sell one telling me it was different than the turn flasher. The $30 part from Volkswagen includes the push-button control for the hazard flashers. The flasher unit itself mounts in the dash right behind the button.

Database Abstraction

Jeremy Zawodny has an article about the ills of database abstraction. At first when I read it I thought he was perhaps a bit loony. But the more I thought about it the more it makes sense. I'm thinking particularly of my current favorite database abstraction model for PHP - AdoDB. I've come to use it under what Jeremy calls the "Portability Fallacy".

Webmin glitch with apache

I just spent some time finding a bit of a glitch with WebMin and the Apache module. By default the PHP configuration portion of the httpd.conf file is configured to add index.php to the list of directory indices. If you try to override this setting in Webmin it never takes. You can add index.htm all day long but it simply won't add. A quick work around is to add index.htm to the various DirectoryIndex entries for the versions of PHP.

So late as to be embarassing

Gartner recently released a report saying that the "unauthorised and uncontrolled use of portable storage devices" could pose a security risk. You don't say?What ever should we do if we didn't have the folks over at Gartner to write reports and tell us, the pedestrian technologists we are, about a four-old-problem. What's next a report saying that guns in the wrong hands kill people? Gartner suggests being very careful about preventing the use of unauthorized devices.... Don't look now but that photo

Congratulations Professor Markell

An announcement from last week on the 9th circuit court website announces that UNLV's Prof. Bruce A. Markell has been appointed to the U.S. Bankruptcy Court for Nevada. The announcement covers many of his professional accomplishments. What is not adequately covered in the announcement is how instrumental Prof. Markell has been to establishing a wonderful law school.

Only by going alone in silence

Only by going alone in silence, without baggage, can one truly get into the heart of the wilderness. All other travel is mere dust and hotels and baggage and chatter. – John Muir

Selecting the most recent entry for a person in MySQL

Here's a snippet of code to get the most recent entry for a person from a list of records with dates. I use this in a situation where I have a list of GPAs for students. The list of GPAs is updated each day for a couple of weeks. The challenge is that some students graduate and are dropped from the list each day so I need to pick the most recent record for each person in the database.

SELECT name, gpa, standing, run_date
FROM `ranking` AS a
WHERE ( standing = '123' OR standing = '122' ) AND a.run_date = (
SELECT MAX( run_date )
FROM `ranking` AS b
WHERE b.name = a.name )
ORDER BY standing, gpa DESC

KDC on Mac OS X Server

I've had a heck of the time getting LDAP to run on Mac OS X Server 10.3. The underlying problem has been kdc not starting so there is no way to do authenticate. I here is what I did to get kdc working... well almost. It currently is running but won't authenticate the primary user.

1. mkdir /var/db/krb5kdc

2. kdb5_util create -r TIOGA.SIERRATARN.COM -s

3. kerberosautoconfig -r TIOGA.SIERRATARN.COM -m tioga.sierratarn.com -u

4. kdcsetup -f /LDAPv3/127.0.0.1/ -a admin -p XXXXXXX -w TIOGA.SIERRATARN.COM

5. kadmin.local (create local user)

6. krb5kdc ( Start it up)

Foiled

I went with a co-worker to see Spiderman last night. The pre-movie commercials had just concluded as the lights came on and the fire alarm sounded. I still might make it tonight.... Time will tell.

Pages