Trac is pretty easy to set up on Debian, here’s a mini guide of what I did to get it working nice and quick. You’ll probably want to configure users etc afterwards, but this should be enough to get going.

Install:

apt-get install trac libapache2-mod-wsgi


Initiate the trac environment:

trac-admin /var/www/srdev/trac/ initenv


Set permissions:

chown -R www-data /var/www/srdev/trac/


Install the wsgi script and web resources. The first argument before ‘deploy’ should match the install environment (the path above.) The second argument following ‘deploy’ can probably go anywhere, but I just shoved it in the trac dir.


trac-admin /var/www/srdev/trac/ deploy /var/www/srdev/trac/www/


Next, we need to tell apache how to call the wsgi script, we do this using an alias. You can use / if you just want it to be in the same dir as your virtualhost, but in my case I wanted trac to be in a sub directory of the site (www.mysite.com/trac.) Add this to your virtual host (/etc/apache2/sites-enabled/whatever.)

The directory directive specifies some permissions for the script.

WSGIScriptAlias /trac /var/www/srdev/trac/www/cgi-bin/trac.wsgi

WSGIApplicationGroup %{GLOBAL}
Order deny,allow
Allow from all



Finally, enable the wsgi module, and then restart apache. Now it *should* work

a2enmod wsgi
/etc/init.d/apache2 restart


I’ve recently moved john-hunt.com again, from Australia to Texas in the states. The reason for this is my web host here in Australia was crap and the server kept going down (among other things.) They weren’t that terrible (hence I won’t mention them), but not worth the hassle.

Anyway, hopefully this year john-hunt.com will undergo a bit of a transformation.

Recently discovered this while creating some web graphics in inkscape:

http://studio.imagemagick.org/pipermail/magick-users/2007-August/020001.html

convert -density 100 -background None [filename].svg -compress none -depth 16 [filename].png

Really quite handy seeing as my version of inkscape loses the alpha channel when exporting.

Today’s beer, Schöfferhofer Hefeweizen is another German beer (there seems to be a few of these around at the moment.)

I drank this wheatbeer from a 500ml bottle. Apparently the fermentation is finished in the bottle.

Surprising at first, before the carbonation ruins it. I also suspect this beer is best drank a few degrees warmer than fridge temp.

Schöfferhofer Hefeweizen certainly isn’t that easy to categorise, the flavour feels like it’s hidden in there somewhere but won’t come out. Dissapointing really as it could have been pretty good.

Apparently this beer won a gold medal! Obviously I have no idea what I’m talking about.

Not a great review, but then not a beer that really stood out to me. 5/10 – Not foul by any means, but meh.

I thought it was about time I started reviewing some beer, at least as a reference for myself when I’m next out shopping for beer. In time I’ll start to do this properly, but for now it’s just a quick summary.

Today’s beer is Fürstenberg a 5.3% lager from Germany.

Approx. $18 for 6 330ml bottles from my local store. This is a german beer, and tastes very much like the beer we had at the world cup in Germany in 2006, so it brings back font memories for me. The first thing I’d note about Fürstenberg is that it goes down extremley well, it doesn’t seem too carbonated and there’s no bitterness to it at all, faily refreshing although not very sharp. This beer is lacking in flavour a bit, but then again it’s the kind of beer that isn’t meant to have a lot of flavour, it’s a real drinking beer – so I’m now off to drink the other 5!

I’ll hopefully revisit this review once I gain more experience and write some proper reviews. But for now, as a personal reference I’ll give this beer a solid 7/10 – it’s a good beer, but lacks anything special. Certainly better than most of the beer I seem to drink.

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /blah/somepage.php on line 123

The reason for this warning is because PHP4 can’t communicate with a MySQL5 server unless it’s using old passwords (set by using the OLD_PASSWORD() function below.)

There are two simple ways to fix this. The first would be to upgrade your version of php. Unless you *really* need php4 (or below?!) upgrade! I’m not sure php4 is supported any more and should be considered a security risk. If you can’t upgrade, just do this in your database:

update mysql.user set password=OLD_PASSWORD('thepassword') where user = 'theusername';
and:
flush privileges;

This should do the trick. Be warned, if you issue any GRANT statements after this you will have to update mysql.user again.

Discovered some fun things in MySQL today..

Set the variable @id to 0:
SET @id = 0;

Update the column id to be id + 1 – this will re-index your id column in one fell swoop. Very nice:
UPDATE tblname SET id = (@id := @id + 1);

Set the first value for an auto_increment column:
ALTER TABLE tblname AUTO_INCREMENT = 196;
(this won’t work if there are rows with a higher value already in the table)

All in all, a few nice bits and pieces for cleaning up your tables.

Amazingly, I’ve managed to get Ableton Live to work properly under Wine.. installation was a breeze, but getting it to decode MP3s properly was a head scratcher.

When I dragged an mp3 over into Ableton live, it would clip all over the place, even in the waveform which tipped me off that this wasn’t a hardware or emulation issue of some kind. Anyway, after faffing around with ffdshow and stuff, I finally found the answer:

http://appdb.winehq.org/objectManager.php?sClass=version&iId=16226 the summary says:

Install Apple iTunes and change msacm.winemp3=winemp3.acm to msacm.winemp3=QuickTime.qts to fix mp3 issue.

Now, I tried to install iTunes 8, but that was a lost cause, so I got iTunes 7 here:

http://www.pcauthority.com.au/Download/59665,apple-itunes-7.aspx

Installed that, then edited ~/.wine/drive_c/windows/system.ini and changed the above line. However this still didn’t work. What I needed to do was copy QuickTime.qts from it’s directory to system32:
cp ~/.wine/drive_c/Program\ Files/QuickTime/QTSystem/QuickTime.qts ~/.wine/drive_c/windows/system32/

Then it worked.. keep in mind that previously imported samples that are glitchy will still be glitchy as they need to be re-analysed, probably best to just delete and re-import them.

Oh, and make sure you’re using the latest version of Wine.

The new(ish) mybook world edition

A few weeks ago, I decided I needed some kind of NAS for my home as I’m often replacing my linux distro, installing Win7 or whatever and I wanted somewhere more permanent for my files.

I looked at the possibility of getting another PC to set up as a NAS, but this looked like it was going to be too costly, and I really needed something that could be plugged into my router which is stuck in the kitchen so I went for the WD Mybook World Edition as I knew it was running Linux and was hackable.

So far I’ve been fairly happy with it, it was *Very* easy to enable SSH and get to work fiddling with it. There’s a checkbox option on its web interface to allow SSH access. From there it’s fairly easy to install optware (similar to apt on Debian/Ubuntu) which allows you to easily install pretty much anything.

Performance is apparently a lot better than the old blue-ring version, however I must say the USB & ntfs performance is laughable – after a lot of tweaking I managed to only get 1.2MB(megabytes!)/sec out of it via USB where as I get about 5MB/sec over my wireless network! Oh well.

The only other issue I’ve had with it is the software it runs.. WD have done something very bizzare indeed and used what seems to be some kind of generic PHP software for embedded devices to run the thing. At first I thought this was just for the web front end, but no, there are all kinds of system() and shell() (or whatever it is) calls in a whole bunch of weird php files that do everything from mounting hard disks to starting other services etc.. very weird! I think significant performance gains could have been made if WD had opted for a more ‘normal’ system rather than having the overhead of a web server and php for everything.

Having said that, using optware allows you to do things as you would on a normal system without interfering with the main system which is a nice feature of optware.

Overall, I’d recommend this device – it’s not the best, but for the price I think it’s pretty reasonable.

Picked up a WDTV last night for $200. As you may have guessed from some of my other posts, I’m into my A/V stuff, so this thing seemed like a bargain. Many reviews will rave about how great it is, and I must say it’s not too bad, but I have found there are bugs (even in the latest 1.0.1.2 firmware):

Playback of any AC3 file seems to result in a barely noticable (but very annoying) 100ms or so audio lag. This doesn’t drift which is good, but it makes watching anything with an AC3 soundtrack very annoying. I’ve tried various things to try and fix this and make sure it’s not me or my files, but the unit. Strangely, this only seems to occur when playing back NTSC files, and not PAL (25fps) files.

Other than that, it’s pretty good. I’ll hang on to it until I can test it on someone else’s setup. Otherwise it might have to go back to the shop!

*update*

After more testing with different files, it seems to be off-sync with a bunch of files, not just ones with an AC3 soundtrack. I also tested the device at a friends place before finally taking it back. If Western Digital manages to sort this bug out, I may consider buying it again…probably not though, manufacturers need to start testing stuff rather than just putting things out there and then releasing good firmware a year later.

I also just found out the WDTV violates the GPL, so I don’t want it anyway!

*update2*

Version 1.02 firmware is now released for the WDTV, and I’ve recently bought an AV reciever which has built in a/v delay stuff (and optical/hdmi inputs etc..) so perhaps it is time to re-purchase WDTV after all. Converting MKV/h264 to AVI/xvid for my xbox w/ac3 isn’t so great.

*update3*

I did re-buy the WDTV, and I’ve been very happy with it, but only if using firmware version 1.02.03 (I think it’s that one) which has all the sync issues sorted. Recommended!

I don’t believe in emailing chain-emails about, so I thought I’d put this here:

London Times – Obituary

An Obituary printed in the London Times……..

Today we mourn the passing of a beloved old friend,  Common Sense, who
Has been with us for many years. No one knows for sure how old he was,
Since his birth records were long ago lost in bureaucratic red tape. He
Will be remembered as having cultivated such valuable lessons as:
Knowing when to come in out of the rain;  Why the early bird gets the
Worm;  Life isn’t always fair; and maybe it was my fault.

Common Sense lived by simple, sound financial policies (don’t  spend
More than you can earn) and reliable strategies (adults, not children,
Are in charge).

His health began to deteriorate rapidly when well-intentioned but
Overbearing regulations were set in place. Reports of a 6-year-old boy
Charged with sexual harassment for kissing a classmate; teens suspended
From school for using mouthwash after lunch; and a teacher fired for
Reprimanding an unruly student, only worsened his condition.

Common Sense lost ground when parents attacked teachers for doing the
Job that they themselves had failed to do in disciplining their unruly
Children.

It declined even further when schools were required to get parental
Consent to administer sun lotion or an Aspirin to a student; but could
Not inform parents when a student became pregnant and wanted to have an
Abortion.

Common Sense lost the will to live as the churches became businesses;
And criminals received better treatment than their victims.

Common Sense took a beating when you couldn’t defend yourself from a
Burglar in your own home and the burglar could sue you for assault.

Common Sense finally gave up the will to live, after a woman failed to
Realize that a steaming cup of coffee she had purchased in MacDonald’s was hot. She spilled a little in
Her lap, and was promptly awarded a huge settlement against the company.

Common Sense was preceded in death, by his parents, Truth and Trust, by
His wife, Discretion, by his daughter, Responsibility, and by his son, Reason.

He is survived by his 4 stepbrothers;
I Know My Rights
I Want It Now
Someone Else Is To Blame
I’m A Victim

Not many attended his funeral because so few realized he was gone.

A new and significant release from Sun, Virtualbox 2.1 is now out just in time for Christmas.

I’ve been checking out a couple of new features that have been added. First, the most significant (to me) is native built in host networking support. This makes it super easy to connect a VM up to a host network adapter so that you can access the VM from the outside on the network – far easier and more simple than setting up tun/tap interfaces. It even works with wireless network devices on the host which is awesome.

The other neat new feature is 3d hardware support, this is a big deal if you’re a gamer and you use linux as it enables you to play your 3d games on VM rather than re-booting into windows or using WINE or whatever.

All in all, Virtualbox is now probably my favourite application ever, it just keeps getting better and better. If you’ve never used it before, it’s definitely worth giving it a try.

Download version 2.1

*Updated!

The xbox360 doesn’t like divx/xvid files that have ac3 sound tracks, so we can use mencoder to convert these files so they use 128kbit stereo mp3 soundtracks instead. This isn’t too hard to do, just use a command similar to:

mencoder input.avi -ovc copy -oac mp3lame -lameopts cbr:br=128 -channels 2 -o output.avi

Easy when you know how.

I recently purchased the Edimax EW-7728IN IEEE802.11n Draft 2.0 wireless card. Although I’ve not tested the performance yet, I have managed to get it to successfully connect to my Billion 7300N 802.11n wireless router at a rate of between 270 and 300Mb/sec.

Before I began I read on the Ubuntu forums that many people had problems trying to get the thing to work. I found it was fairly straight forward which is probably a result of the new(ish) drivers on the edimax website for Linux.

You can download the latest source from http://www.ralinktech.com/ralink/Home/Support/Linux.html – I didn’t see any restrictions or licenses on there for the source, so I’ve decided to compile and upload the modules as I need them. You can check back here to pick up the latest if you’re not confident compiling it yourself.

Please don’t try running the modules on kernels that they are not for. This will not work! You will need to compile it against headers for your currently running kernel if you don’t find it listed here.

Then you’ll want to extract the kernel module:

bunzip2 rt2860sta.ko.bz2

Now test that it works before you continue:

sudo insmod rt2860sta.ko

Now run iwconfig to see if the module loaded OK. If so, you should have the ra0 device listed.

If all is well, copy the module to the kernel module directory:

sudo cp rt2860sta.ko /lib/modules/2.6.24-19-generic/ubuntu/net/rt2860/rt2860sta.ko

Now we’d like to tell it to auto-load upon system startup. We can do this by adding the line: rt82860sta to the /etc/modules file. Easy!

Update!!

I’ve recently found a link to a dynamically building kernel module .deb file, which is great because it means you can just install this .deb on your system and it should work. With a bit of luck the Ubuntu team will include the driver in Intrepid, but I wouldn’t hold your breath:

http://www.array.org/ubuntu/dists/intrepid/eeepc/binary-i386/rt2860-dkms_1.7.1.1_all.deb

Hi, I’ve posted this to my site in order to find people looking for a central coast linux user group (Central Coast, NSW, Australia that is.) Basically, I’ve sort-of found one at http://cclug.com, but it seems to be a bit dead with hardly any info. If you are interested in a central coast LUG, please leave a comment with your email address and I’ll get in touch. Perhaps you can help me find the mysterious CCLUG, or help me establish a new one? Who knows! Either way, it’d be nice to have a LUG that’s not all the way down in Sydney.

Explaining microblogging is slightly difficult, but I’ll give it a go:

You sign up for a microblogging service like twitter. You ‘follow’ your friends that are already on there, and perhaps some people that aren’t your friends but people who say interesting things. Once you’ve started following your friends, you might download a program for your computer to alert you when they post (or in the case of twitter ‘tweet’), and to allow you to post your own ‘tweets’ without having to visit the twitter website at all. This is great because it allows you to know what your friends are up to, or tell the world what you’re up to, or that you’ve just discovered an amazing new pizza at dominos.

When you post an update on a service like twitter, it’s totally public. You are broadcasting, and people who are following you will be automatically alterted to what you say. It gets really cool when you consider all of it can be done from your mobile/laptop/pc etc..

What’s wrong with twitter?

Now that’s cool, and I’ve used twitter and it’s good. However, there’s one (or two, perhaps three?) major flaws with twitter. The first being that it’s a closed service. Imagine if email was a closed service, eg people on hotmail could only send and recieve email from other people on hotmail and people on gmail could only send and recieve mail to @gmail addresses. This is effectively the problem with twitter, jaiku and all the 100’s of other closed microblogging services – it’s cool, but it’s silly. Oh yeah, the other things wrong with twitter are it breaks often is all closed up.

Laconi.ca

Enter laconi.ca. Laconi.ca is an open source microblogging server program. This means that anyone can start their own microblogging website. Please don’t stop reading here! This is where it gets good. You can easily link your microblogging website to any other laconi.ca microblogging website – adding to a big mesh of microblogging servers.. just like email servers. laconi.ca uses an open standard for communication also meaning that you’re not limited to using laconi.ca as your server.

Why is it better for me though?

laconi.ca does lots of cool things that twitter doesn’t! Firstly, you can use an instant messeging client with it, and post to your feed just by sending the laconi.ca contact a message. Secondly, you can ‘track’ certain words. Say you’re interested in cake, you can type into your IM client: track cake and every time someone posts something with the word ‘cake’ in it (not just your friends!) you’ll get their post. There’s other neat things I haven’t tried yet such as posting attachments and things, but it’s got some killer features that no other microblogging services have.. the best being it’s open.

Find me on identi.ca

You probably don’t want to have to set up your own laconi.ca server, so why not just use the ‘main’ one! Check out identi.ca and subscribe to me: johnhunt

Just a quick upadte, john-hunt.com is now hosted in Australia rather than the UK. This is good because it means I don’t have to wait ages for pages to load on my own sites etc..

I’m going to set up a more personal blog, probably at blog.john-hunt.com with posts about life in Aus, photos etc…what I should have sorted out ages ago really.

If you find your system isn’t booting sometimes and you get this funny error message, edit your kernel boot line in /boot/grub/menu.lst:


kernel /boot/vmlinuz-2.6.24-19-generic root=UUID=75a92494-bdae-4715-92d9-f06d1887008e ro all_generic_ide


e.g – Add the all_generic_ide parameter. All should be fine once again. I believe this is a strange Ubuntu kernel bug, although I’m not sure.

While it’s not possible to play mkv files directly on the xbox360, you only need to do a few things to remux the video and audio streams into the mp4 format. This means that no re-encoding is done with the video, therefore there is no loss in video quality.

At the time of writing, the xbox360 doesn’t support anything other than 2 channel AAC audio for mp4 streams, so you’ll have to put up with that. It does work well though.

1. Gather video information
mkvinfo movie.mkv
Look for things like the following:

|+ Segment tracks
| + A track
| + Track number: 1
| + Track UID: 1
| + Track type: video
- snip -
| + Default duration: 41.708ms (23.976 fps for a video track)

This shows us track 1 is the video stream. Remember that, it’ll come in handy later. Also, make a note of the fps, if you get the FPS wrong later you’ll have a/v sync issues. Generally track 1 is always the video stream and track 2 is always the main audio stream:


| + A track
| + Track number: 2
| + Track UID: 445320639
| + Track type: audio
- snip -
| + Name: Main audio DTS 1536
| + Audio track
| + Sampling frequency: 48000.000000
| + Channels: 6


Make a note of whether you’re dealing with a DTS stream (as in my example) or an AC3 stream. There is a newer format ACC3 or something..I don’t know much about that.

2. Extract the video and audio streams from the mkv
Remember, mkv and mp4 are just like avi (in some ways.) They are all container formats, not the actual video itself. Now we extract the audio and video streams we want. If you like you could choose different audio and video streams you discovered using mkvinfo.

Extract the video:

mkvextract tracks movie.mkv 1:video.h264


Next we have to do something quite strange in order to make our h.264 file compatible with the xbox360. Run hexedit video.h264 and change the sequence: “67 64 00 33″ to “67 64 00 29″.

Now we have our video file ready for muxing, we need to deal with the audio stream:

mplayer movie.mkv -novideo -ao pcm:fast:file=audiodump.wav -channels 2

This gets the audio from the mkv file and saves it as audiodump.wav ready for re encoding using nero’s AACenc program (http://www.nero.com/eng/down-ndaudio.php):

3. Encode the audio dump to AAC format
Now we encode the wav file to AAC:

neroAacEnc -lc -ignorelength -q 0.50 -if audiodump.wav -of audio.m4a

Both the audio and video streams are now ready to be muxed (put together) by MP4Box:

4. Mux the files

Remember to use the correct FPS value we obtained using mkvinfo from earlier!

MP4Box -new output.mp4 -add video.h264 -add audio.m4a -fps 23.976

output.mp4 is now ready to watch!!

Footnotes:
1. I didn’t have any luck getting windows media player 11 to stream the mp4’s to my xbox, I got the all to common ‘format not supported’ thing on the xbox even though they played just fine on WMP11.

2. You’ll want to split your original MKV into just under 4GB chunks if you’re putting the files on anything other than DVD5/DVD9. Do this:
mkvmerge -o output_part.mkv --split 3900M movie.mkv

*note - we leave it just under 4000M for two reasons, firstly fat32 can’t store eactly 4GB, secondly I’m not sure if it’s GiB or GB…!

3. Special thanks to Mike from Linux Love. For some tips that actually worked!

4. I’m not sure if there’s an artificial limit on the file size of mp4s that can be played back, but I will know by this afternoon!

Update:
It appears as though the xbox360 doesn’t like any media files > 4GB, a bit of a shame really. Hopefully the next dashboard update will fix these issues. Until then, looks like we’ll have to put up with split files.