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.
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?
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)
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:
[caption id="" align=“alignnone” width=“400” caption=“The new(ish) mybook world edition”][/caption]
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.
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.
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.
*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.