Leo on Tech

Powered by
WordPress

  • Continuing MediaWiki development

    No fresh download quite yet, but I just made a large commit to the MediaWiki source of the last week’s work. This is going in the trunk — aka MediaWiki 1.16alpha. There are a few bugs I hope to catch this weekend, at which point I’ll put up a fresh archive of working code. config/index.php:…

  • Changing the DB2 hostname

    SQL6031N Error in the db2nodes.cfg file at line number “1”. Reason code “10”. DB2 caches your machine’s hostname in several places. If your machine is changing its hostname, or if you are somehow moving an existing installation to a machine with a different hostname, you will need to adjust the hostname stored by DB2. Hostname…

  • Oracle kills Virtual Iron

    Only 5 weeks from acquisition to death. No more licenses for existing customers, either. Harsh.

  • DB2 data movement tool

    The DB2 data movement tool sounds like an excellent way to move stuff from, say, MySQL to DB2. I should see if I can use it to move a MediaWiki database. Speaking of MediaWiki, I swear I’ll have a patched zip of 1.15 ready any day now.:-)

  • setTimeout() require qualification

    The two javascript functions above are very useful. The first one executes something after a set delay, and the second executes something at regular intervals. The syntax is very similar. var time = 2000; // 2 seconds window.setTimeout(function() { alert(‘Yay!’); }, time); window.setInterval(function() { alert(‘Woo!’); }, time); Unfortunately, they weren’t working for me earlier. It…

  • DB2

    I now edit the Computers: Software: Databases: IBM DB2 category at dmoz.org open directory project. Directories used to be important in the mid-1990s, as they tended to provide better search results than dumb link crawlers like Altavista. Yahoo started off as a human-edited hierarchical directory of links and adopted the crawler approach later. However, since…

  • DB2 and usernames with spaces

    DB2 v9.5 uses the Windows username as the default schema. Unfortunately, it does not support spaces in schema names. Accordingly, usernames – e.g. “Jane Smith” — that have a space can make DB2 unhappy. I recently helped someone resolve an issue with this command: db2sampl -force -name SAMPLE Which brought up this error: Creating database…

  • Dynamic playlists in MusikCube

    On Windows, my music player of choice is musikCube. It’s fast, clean, elegant, and powerful. Oh, and it has an embedded SQL engine underlying its song library. It has conventional playlists, but it also has dynamic playlists based on queries of the underlying SQL database. For example, this query gives the Top 10 Most Played…

  • Update Symantec without an uninstall password

    I had to update an old XP Home test machine to run the latest Symantec Suite of Crap. Installation of new Symantec stuff requires a manual uninstall of old Symantec stuff. Here, I ran into a problem — it prompted for an “uninstall password”. The default password is “symantec”, but that wasn’t my issue. Apparently,…

  • Disabling PHP in a specific directory

    To disable the PHP processor in a given directory, put the following in an .htaccess file. If one doesn’t exist, create it. # Disable PHP AddHandler default-handler php RemoveType application/x-httpd-php php # Make .php files display as plain text AddType text/plain php This assumes an Apache server. PHP on IIS may involve different steps. Files…