Acer Aspire Revo 3700 with Linux

Looks like Acer is releasing a Linux model of its new Revo, product code “PT.SEMEC.003“; listed as a 160 GB HDD, 2 GB Linux version. Insight UK have them for £230. See this list of sites for prices; all around £200 – £300.  Gigabit ethernet sees nice, as does 802.11n if you need to fall back to wireless. Amazon ar elisting it for £349, so a little steep there. Here’s the press release from Acer, dated September 9.

HP Dreamscreen update: 23 Sept 2010 (1.6.2.0)

Yesterday, the 10th of October 2010 (10-10-10), my HP DreamScreen dutifylly informed me of a firmware update! Wow, I wasn’t expecting any more updates out of HP, given the age of the product. Down came 1.6.2.0, with a release/build date of “9/23/10“, and on boot telling me that to use the Facebook app there were new security options in Facebook to permit this. It claims to be fron the “HP Development Company”. Is that separate from HP? Googling around shows “Hp Development Company LLC is located at 4401 N Mesa St El Paso, TX 79902″. Hm.

Snapfish deleting photos

I started using Snapfish to store photos as the only main way to get an online album displying in my HP DreamScreen. HP decided against supporting Flickr, Picasa, or other established sites, opting to use Snapfish because – HP owns them. Fair enough, so I signed up and uploaded some content to show on my Hp DreamScreen device(s). Now, Snapfish have told me:

Please place an order by October 12, 2010 or you risk losing your photos. Lastly, remember you can also preserve your photos with a photo CD.

Thanks HP; you’ll delete my content since I havent purchased prints from you. How else can I display an album online to the display I purchased from you? Can I get an app for Flickr, Picasa, or perhaps access to boot and run my own code on here yet? The platform appears to be stagnant now for some time….

Subversion upgrades

Another nugget that took me a few minutes to go through, so a summary here: when upgrading subversion environments, you need to consider:

  • The version of the client tools (eg, svn from the command line, Tortoise, Subclipse, etc)
  • The version of the binaries in the web server (libapache-svn)
  • The version of the repository on disk

The repository on the server on disk generally does not auto-upgrade. Indeed, I just found that my personal SVN repo was still using format version 1! Version 1.4 uses format 2, and version 1.5 uses format 3. Thanks to this link its easy to see the format of a repo – cat $PATH/db/format.

Check the release notes to see the features that don’t work when the repo is not upgraded, and what version clients do and don’t work.

How to convert IPv4 to IPv6 in MySQL

If you original IPv4 address is in an unsigned long called “IPv4“, then…

select concat("0:0:0:0:0:0:", LPAD(CONV(substring_index(inet_ntoa(IPv4), '.', 1), 10, 16), 2, "0"), LPAD(CONV(SUBSTRING_INDEX(SUBSTRING_INDEX( inet_ntoa(IPv4) , '.', 2 ),'.',-1), 10, 16), 2, "0"), ":", LPAD(CONV(SUBSTRING_INDEX(SUBSTRING_INDEX( inet_ntoa(IPv4) , '.', 3 ),'.',-1), 10, 16), 2, "0"), LPAD(CONV(SUBSTRING_INDEX(SUBSTRING_INDEX( inet_ntoa(IPv4) , '.', 4 ),'.',-1), 10, 16), 2, "0")) as IPv6 from Log3NF.Access limit 1000;