March 24th, 2009
I wrote a pretty simple Perl script which outputs a list of open user sessions in an Ingres installation (remote or local). This information can also be retrieved using Ingres utilities iinamu and iimonitor, but not in a very straigth-forward fashion. The script is also a decent example how to access an Ingres database using Perl scripting language and Database Interface (DBI).
The script uses DBD-Ingres driver to access the imadb database, which is part of the Ingres Management Architecture (IMA). The script retrieves the necessary data from the imadb and then prints it. A short, concise list of open sessions is printed first with a more verbose listing (”iimonitor show user sessions formatted” alike) following.
The version 1.0 of the script is available at http://pauli.borodulin.fi/misc/ingres/ima_sessions-v1.0.pl. The requirements for running the script are listed in the beginning of the script.
Tags: Ingres, work
Posted in Tech stuff | No Comments »
February 15th, 2009
Since Debian Lenny is about to be released this weekend, I decided to upgrade my VDR box from Debian Etch to the upcoming Lenny. Instead of just doing dist-upgrade, I decided to do a complete reinstall from scratch including upgrading some of the components used by my VDR setup.
Now my current setup is:
- FFmpeg revision 17245
- DirectFB 1.0.1
- Xinelib 1.1.16.2
- VDR 1.6.0-2, with the following plugins
- xineliboutput 1.0.4
- epgsearch 0.9.24
- femon 1.6.6
- remote 0.4.0
- skinsoppalusikka 1.6.3
- streamdev 0.3.4
- sc 0.9.1
I also upgraded to the latest v4l-dvb tree for which I ported the Mantis driver by Manu Abraham.
Posted in Tech stuff | No Comments »
October 2nd, 2008
I have been working to get WSO2 WSF/PHP 2.0.0 to work with the SecureCalculatorApp example web service provided with NetBeans 6.1. I want to be able to call a secure web service created with NetBeans 6.1’s user interface from an application written in PHP. SecureCalculatorApp example provides a really good starting point for a simple interoperability test.
Read the rest of this entry »
Posted in Uncategorized | 2 Comments »
October 1st, 2008
I have recently been working to get some web services to run on Glassfish, which uses Metro. The web services need to be called from different clients (some not even written in Java) and unfortunately not all clients work as documented. Sometimes it’s because of incorrect configuration, sometimes because of interoperability problems etc.
Comparing the requests sent by different clients makes it easier to debug the reasons for the problems. Since not all clients allow dumping the created requests upon sending, it would be nice if it was possible to ask Metro to do it. Fortunately, this is possible through configuration. For doing this, Arun Gupta describes the possible properties in his blog.
The easiest way is to add parameters
-Dcom.sun.xml.ws.assembler.client=true
-Dcom.sun.xml.ws.assembler.server=true
to your Glassfish domain’s domain.xml as jvm-options elements.
Posted in Tech stuff | No Comments »
September 21st, 2008
I have recently upgraded my VDR setup with more recent software and plugin versions! My current setup consists of
- FFmpeg revision 15245
- DirectFB 1.0.1
- Xinelib 1.1.15
- VDR 1.6.0-2, with the following plugins
- xineliboutput 1.0.1
- epgsearch 0.9.24
- remote 0.4.0
- skinsoppalusikka 1.6.1
- streamdev 0.3.4
- sc 0.9.0
I’m using Matrox G550 and its tv-output to display the video image on my old 28″ analog television.
The actual reason for the upgrade was to get a recent FFmpeg version to play videos using xineliboutput’s media player. Everything went well except that for some reason, there’s a problem with the OSD when playing videos using software scaling (hardware scaling made OSD look awful). I posted a question about the problem on the VDR mailing list to see, if anyone else has had this problem. It seems to be some kind of initialization problem during playback, but I have not yet been able to find out the cause for it.
For those who don’t know what VDR is: It can be used to make a computer to function as a video disk recorder (article in Wikipedia).
Posted in Tech stuff | No Comments »
July 1st, 2008
I recently needed to know how much disk space each table in a Ingres 2006 R2 database took. Any Ingres DBA knows that by default Ingres stores the data under location II_DATABASE, but the filenames used for the data files are not too informative. Fortunately it is possible to check the filename of a table using the following query in the corresponding database:
SELECT file_name, file_ext FROM iifile_info WHERE table_name = 'mytable';
The file_name column contains the name of the file for the table without extension and the column file_ext contains the extension. If the database uses multiple locations, it is also necessary to check the value of the column ‘location’, which will tell you the location of the file.
But this is not all. Ingres also stores all secondary indexes in separate files. It is also possible to see, using the table iifile_info, which index is stored in which file. This way it is even possible to hunt down indices that require more disk space than you expected.
Tags: Ingres
Posted in Tech stuff | No Comments »
May 17th, 2008
I have just reworked Kristian Slavov’s remote control patch for Manu Abraham’s latest Mantis driver tree. The original patch was posted in April 2007 on linux-dvb mailing list. The reworked version contains only the remote controller functionality and it applies cleanly to the latest version (cd1fc4c7f1d8) of the driver tree. The patch is available at http://pauli.borodulin.fi/misc/mantis-rc-cd1fc4c7f1d8.patch.
Here’s some tips to get it working:
- Get a snapshot of Manu’s tree from http://www.jusst.de/hg/mantis/
- Extract the tree and apply the patch:
tar jfx mantis-cd1fc4c7f1d8.tar.bz2
cd mantis-cd1fc4c7f1d8
patch -p1 < mantis-rc-cd1fc4c7f1d8.patch
- Compile and install
make
make install
The remote control will be visible through /dev/input. You can check the correct device by running dmesg. You should be able to spot a like similar to this: “input: Mantis VP-2033 IR Receiver as /class/input/input3″. To use the remote control with VDR you will need something like vdr-remote.
Edit 1 (2008-05-19): A revised version of the patch is available here. It is against the driver tree revision b14e79e460fc.
Edit 2 (2009-01-05): A revised version of the patch is available here. It is against the driver tree revision 303b1d29d735 (works for VP-2040 too!).
Posted in Tech stuff | No Comments »
May 4th, 2008
Yay! I got my bike fixed yesterday (had a flat front tyre etc.). I could not resist taking a short test drive in the evening and instead of just checking out that everything worked okay, I drove a 10 km route to the University and back home. I was able to maintain 20 km/h average speed which was fine after last winter with almost no physical exercise at all. Didn’t take it too seriously tho’, since I had jeans on and didn’t even have anything to drink. I guess I’ll have to try cycling my last summer’s regular route to Rajasalmen silta and back (about 40 km) soon.
I have decided to try tracking all my this summer’s cyclings using Nokia’s Sports Tracker so that I can check how much I cycled during the summer. I guess I will miss some workouts anyway, but some kind of total number of kilometers would be nice to see when summer ends.
Tags: cycling
Posted in Uncategorized | No Comments »
April 22nd, 2008
I have been preparing for an update of Sun ONE Application Server 7 at work for some time now. A week ago I finally found a decent way to run Sun Java System Application Server 9.1 u1 on Solaris 9 under unprivileged account so that SJSAS could be reached on ports 80 and 443. The solution was to put Apache HTTP server in front of SJSAS using mod_jk and AJP (just like Tomcat often is installed). In the solution Apache will listen for the ports and deliver the requests to SJSAS using AJP. Gladly, Sun has provided instructions for this.
Read the rest of this entry »
Tags: java, log4j, mod_jk, SJSAS, work
Posted in Tech stuff | No Comments »
April 21st, 2008
Yay! I was finally bored enough to put up a blog. The default theme looks pretty awful, but I guess it’s the content that really matters. I will see if I have time to put up my own theme later. Until that I’ll try to adopt a habit of writing my findings and thoughts publicly from time to time.
Posted in Uncategorized | 2 Comments »