Jul 312011

Hey All
I’ve just purchased the Humble Indie Bundle 3.
Grab your DRM-free copies Here !
Hopefully, time permitting, I shall be posting up some quick reviews of the games or at least some screenshots of me playing them.

Jul 262011

Hi All,

I just bought my daughter a digital camera for her to take photos with since she loves taking them.
It’s one of these, which we bought at Toys ‘R’ Us for $25, which was a pretty good deal.

Look like this :
Kidz Camera

Once we got home, she exhausted the tiny internal memory fairly quickly, so I had to download the photos off the camera.

Only problem, the bundled software only supports Windows. I don’t have a Windows machine anymore though, so off to the internet I trundle to find out how to get the photos off the camera.

After lots of trawling, I come across a snippet from a post a while back mentioning gphoto2.
So off I go to install gphoto2, and what do you know, I can now download all the photos off the camera in ppm format.

To do it, I plugged the camera in via USB, after I plugged it in, the camera was detected by my eeePC.
The lsusb command spat out

Bus 003 Device 003: ID 0979:0227 Jeilin Technology Corp., Ltd

that as the camera, which was a bit cryptic but that’s ok, as long as it was picking it up.

After I plugged it in, I used gphoto2 to check out the camera to see what was on it.

I ran –

gphoto2 -L

to see what was on it, and it spat out –

There are 39 files in folder '/'.
#1 jl_001.ppm image/x-portable-pixmap
#2 jl_002.ppm image/x-portable-pixmap
#3 jl_003.ppm image/x-portable-pixmap
#4 jl_004.ppm image/x-portable-pixmap

So gphoto2 can definitely read the camera. Next step – to download all the photos.

I ran –

gphoto2 -P

to download all the photos to the current directory.
After running it, I got this –

Downloading 'jl_001.ppm' from folder '/'...
Saving file as jl_001.ppm
Downloading 'jl_002.ppm' from folder '/'...
Saving file as jl_002.ppm
Downloading 'jl_003.ppm' from folder '/'...
Saving file as jl_003.ppm

And all the photos were saved to the current directory.
So that’s how I downloaded all the photos off the Sakar Kidz Cam.

Hope this helps someone in need !.

Jul 192011

Hi All, just a quick update today.

I was trying to get NFS working today but kept running into errors.
Whenever I tried to start imapd, I would keep getting this error –

rpc.idmapd[12599]: main: fcntl(/var/lib/nfs/rpc_pipefs/nfs): Invalid argument

Turns out, I didn’t have dnotify support enabled in the kernel.
Enabling this now, and will be testing very soon.

Just a quick tip for anyone coming across this issue !

Cheers all.

Jul 022011

Hi All,

I have just worked up a short script to search a SQL server using Javascript.
Using ActiveX and the ADoDB.Connection object this enables me to build a little HTA frontend to do what I need.

Firstly, we create the ADODB object.

var objConnection = new ActiveXObject("adodb.connection");

Then, set the options we want for the connection.
I’m connecting to a SQL server, that is hosted on “server1”, and the database i want is “db1”, and I’m connecting with username and passwords.

var strConn = "driver={sql server};server=server1;database=db1;uid=username;password=password";

Then we open the connection with the options specified.


Once the connection has been opened, we use the ADODB.Recordset object to execute a query and retrieve results from SQL.

var rs = new ActiveXObject("ADODB.Recordset");
var strQuery = "SELECT * FROM users WHERE username = 'user1'";

Once the query has been executed, the results will be stored in the recordset.
You will now be able to view the results using the standard recordset functions.

while(!rs.eof) {
//Do your thing here