<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	>

<channel>
	<title>pete harris</title>
	<atom:link href="http://peteharris.me.uk/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://peteharris.me.uk</link>
	<description>Just another WordPress weblog</description>
	<pubDate>Wed, 25 Aug 2010 12:27:57 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.5.1</generator>
	<language>en</language>
			<item>
		<title>Leeds Festival 2010 Clashfinder</title>
		<link>http://peteharris.me.uk/?p=36</link>
		<comments>http://peteharris.me.uk/?p=36#comments</comments>
		<pubDate>Wed, 25 Aug 2010 12:27:25 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=36</guid>
		<description><![CDATA[These are more useful than the programme you can buy on site, and they&#8217;re free!
http://www.clashfindergeneral.co.uk/s/leeds10/
]]></description>
			<content:encoded><![CDATA[<p>These are more useful than the programme you can buy on site, and they&#8217;re free!</p>
<p><a href="http://www.clashfindergeneral.co.uk/s/leeds10/">http://www.clashfindergeneral.co.uk/s/leeds10/</a></p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=36</wfw:commentRss>
		</item>
		<item>
		<title>Garlic Story</title>
		<link>http://peteharris.me.uk/?p=28</link>
		<comments>http://peteharris.me.uk/?p=28#comments</comments>
		<pubDate>Tue, 17 Aug 2010 11:52:56 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[drawing]]></category>

		<category><![CDATA[garlic]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=28</guid>
		<description><![CDATA[I realised I&#8217;d not re-posted the garlic story since I migrated to wordpress, so here it is.





]]></description>
			<content:encoded><![CDATA[<p>I realised I&#8217;d not re-posted the garlic story since I migrated to wordpress, so here it is.</p>
<p><a href="http://peteharris.me.uk/wp-uploads/2010/07/1.jpg"><img class="alignnone size-medium wp-image-29" title="Garlic Story 1" src="http://peteharris.me.uk/wp-uploads/2010/07/1-300x86.jpg" alt="" width="300" height="86" /></a></p>
<p><a href="http://peteharris.me.uk/wp-uploads/2010/07/2.jpg"><img class="alignnone size-medium wp-image-31" title="Garlic Story 2" src="http://peteharris.me.uk/wp-uploads/2010/07/2-300x82.jpg" alt="" width="300" height="82" /></a></p>
<p><a href="http://peteharris.me.uk/wp-uploads/2010/08/3.jpg"><img class="alignnone size-medium wp-image-33" title="Garlic Story 3" src="http://peteharris.me.uk/wp-uploads/2010/08/3-300x78.jpg" alt="" width="300" height="78" /></a></p>
<p><a href="http://peteharris.me.uk/wp-uploads/2010/08/4.jpg"><img class="alignnone size-medium wp-image-34" title="Garlic Story 4" src="http://peteharris.me.uk/wp-uploads/2010/08/4-300x69.jpg" alt="" width="300" height="69" /></a></p>
<p><a href="http://peteharris.me.uk/wp-uploads/2010/08/5.jpg"><img class="alignnone size-medium wp-image-35" title="Garlic Story 5" src="http://peteharris.me.uk/wp-uploads/2010/08/5-300x69.jpg" alt="" width="300" height="69" /></a></p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=28</wfw:commentRss>
		</item>
		<item>
		<title>amazonmp3 downloader in ubuntu 10.04 lucid lynx</title>
		<link>http://peteharris.me.uk/?p=32</link>
		<comments>http://peteharris.me.uk/?p=32#comments</comments>
		<pubDate>Thu, 12 Aug 2010 20:21:42 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[computer]]></category>

		<category><![CDATA[amazon]]></category>

		<category><![CDATA[mp3]]></category>

		<category><![CDATA[ubuntu]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=32</guid>
		<description><![CDATA[Amazon helpfully provide non-windows applications for downloading mp3s you&#8217;ve bought (what&#8217;s wrong with normal HTTP, I don&#8217;t know) but the ubuntu one is for a previous release so the exactly specified dependencies aren&#8217;t there in more up to date systems.
This can be got round by just installing the particular packages from the 9.10 release.  [...]]]></description>
			<content:encoded><![CDATA[<p>Amazon helpfully provide non-windows applications for downloading mp3s you&#8217;ve bought (what&#8217;s wrong with normal HTTP, I don&#8217;t know) but the ubuntu one is for a previous release so the exactly specified dependencies aren&#8217;t there in more up to date systems.<br />
This can be got round by just installing the particular packages from the 9.10 release.  This can be done by going to &#8220;software sources&#8221; under the system menu, going to the &#8220;Other sources&#8221; tab and adding this line:<br />
<code>deb http://gb.archive.ubuntu.com/ubuntu/ karmic main restricted universe</code><br />
(or alternatively, manually add this line to /etc/apt/sources.list)</p>
<p>You should then be able to update the package list and install the amazon package using <code>dpkg -i amazonmp3.deb</code> or using the gdebi GUI program.</p>
<p>Just downloaded the new Chemical Brothers album for £3 - good old Amazon (even if they do evade VAT by being based in Luxemburg)</p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=32</wfw:commentRss>
		</item>
		<item>
		<title>xbox 360 music streaming from ubuntu linux</title>
		<link>http://peteharris.me.uk/?p=27</link>
		<comments>http://peteharris.me.uk/?p=27#comments</comments>
		<pubDate>Fri, 11 Jun 2010 13:36:23 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[computer]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=27</guid>
		<description><![CDATA[Tried to find servers that&#8217;d do this, like ustream which sort of works
then found this java project
http://sourceforge.net/projects/x360mediaserve/
No problem, just run the server, tell it where your music is.  It&#8217;ll index it all then provide album/artist searches via your xbox music interface.
job&#8217;s a good &#8216;un!
]]></description>
			<content:encoded><![CDATA[<p>Tried to find servers that&#8217;d do this, like ustream which sort of works<br />
then found this java project<br />
http://sourceforge.net/projects/x360mediaserve/</p>
<p>No problem, just run the server, tell it where your music is.  It&#8217;ll index it all then provide album/artist searches via your xbox music interface.</p>
<p>job&#8217;s a good &#8216;un!</p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=27</wfw:commentRss>
		</item>
		<item>
		<title>xbox live routing in linux</title>
		<link>http://peteharris.me.uk/?p=26</link>
		<comments>http://peteharris.me.uk/?p=26#comments</comments>
		<pubDate>Wed, 26 May 2010 11:55:01 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[computer]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=26</guid>
		<description><![CDATA[Just bought an xbox and wanted to set it up in my room so as not to block the TV in the lounge.
My existing wifi dongle doesn&#8217;t work with the box, and official ones cost about 40 quid so thought I&#8217;d try a bit of linux iptables to get the xbox live connection working
(internet)   ---phone [...]]]></description>
			<content:encoded><![CDATA[<p>Just bought an xbox and wanted to set it up in my room so as not to block the TV in the lounge.</p>
<p>My existing wifi dongle doesn&#8217;t work with the box, and official ones cost about 40 quid so thought I&#8217;d try a bit of linux iptables to get the xbox live connection working</p>
<pre>(internet)   ---phone line--&gt;  bthomehub  --wifi--&gt;   laptop   ---wired---&gt;   xbox</pre>
<p>This told me how to get the ports forwarded on my laptop:</p>
<p>http://www.portalstorm.net/guides/xboxlive.php</p>
<pre>
iptables -A FORWARD -i wlan0 -o eth0 -s 192.168.2.0/24 -m conntrack --ctstate NEW -j ACCEPT
iptables -A FORWARD -m conntrack --ctstate ESTABLISHED,RELATED -j ACCEPT
iptables -A POSTROUTING -t nat -j MASQUERADE

iptables -t nat -A PREROUTING -p udp --dport 88 -i wlan0 -j DNAT --to 192.168.2.x
iptables -t nat -A PREROUTING -p tcp --dport 3074 -i wlan0 -j DNAT --to 192.168.2.x
iptables -t nat -A PREROUTING -p udp --dport 3074 -i wlan0 -j DNAT --to 192.168.2.x
iptables -t nat -A POSTROUTING -p udp -s 192.168.2.x --sport 88 -j MASQUERADE --to-ports 88
iptables -t nat -A POSTROUTING -p tcp -s 192.168.2.x --sport 3074 -j MASQUERADE --to-ports 3074
iptables -t nat -A POSTROUTING -p udp -s 192.168.2.x --sport 3074 -j MASQUERADE --to-ports 3074</pre>
<p>then I need to set my bt home hub up for forwarding the ports from the internet onto my laptop</p>
<p>I don&#8217;t have the password for my router (my housemate has the account) so I&#8217;ve had to use uPnP to get it working.</p>
<p>installed <code>http://packages.debian.org/gupnp-tools</code></p>
<p>then I can &#8220;invoke&#8221; uPnP methods on the router to tell it to open new ports for me.</p>
<p>ports 88 and 3074 UDP, and port 3074 TCP</p>
<p>Need to be able to script the upnp step, or find out the password for the router, to make this a more complete solution.</p>
<p>Alternatively, if I could just bridge the wired and wireless connections using linux then my xbox would pick up a DHCP address from the router and do uPnP directly.</p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=26</wfw:commentRss>
		</item>
		<item>
		<title>Arcee</title>
		<link>http://peteharris.me.uk/?p=25</link>
		<comments>http://peteharris.me.uk/?p=25#comments</comments>
		<pubDate>Mon, 29 Mar 2010 21:38:29 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[drawing]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=25</guid>
		<description><![CDATA[
Picture of Arcee from Transformers, copied from this image
]]></description>
			<content:encoded><![CDATA[<p><a href='http://peteharris.me.uk/wp-uploads/2010/03/2010-03-29-arcie.jpg'><img src="http://peteharris.me.uk/wp-uploads/2010/03/2010-03-29-arcie-168x300.jpg" alt="Arcee from transformers" title="2010-03-29-arcee" width="168" height="300" class="alignnone size-medium wp-image-24" /></a><br />
Picture of Arcee from Transformers, copied from <a href="http://callmepo.deviantart.com/art/Final-page-ROBOTS-72149945">this image</a></p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=25</wfw:commentRss>
		</item>
		<item>
		<title>restore a single table from mysqldump</title>
		<link>http://peteharris.me.uk/?p=23</link>
		<comments>http://peteharris.me.uk/?p=23#comments</comments>
		<pubDate>Thu, 25 Mar 2010 15:53:52 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[computer]]></category>

		<category><![CDATA[mysql]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=23</guid>
		<description><![CDATA[using mysqldump is a quick an easy way to backup databases, but restoring a single table (possibly to retrieve a single row) is a pain in the arse.
This article has a useful perl script which does just that
The bit that does the actual work is quite simple:
&#60;snip&#62;
125     ## go through the [...]]]></description>
			<content:encoded><![CDATA[<p>using mysqldump is a quick an easy way to backup databases, but restoring a single table (possibly to retrieve a single row) is a pain in the arse.</p>
<p><a href="http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html">This article</a> has a useful perl script which does just that</p>
<p>The bit that does the actual work is quite simple:</p>
<p>&lt;snip&gt;</p>
<pre>125     ## go through the file one line at a time
126     while (my $line = &lt;STDIN&gt;) {</pre>
<p>&lt;snip&gt;</p>
<pre>140             ## set a flag when we encounter the table we want
141             if ($line =~ /^-- Table structure for table `$conf{'tableName'}`/) {
142                 $flag = 1;
143                 printmsg("Turning flag on", 1);
144             }
145             ## turn flag off as soon as we encounter next table definition
146             elsif ($line =~ /^-- Table structure for table/) {
147                 $flag = 0;
148                 printmsg("Turning flag off", 1);
149             }
150
151             ## if flag is set, then print to STDOUT, otherwise just move on
152             if ($flag) {
153                 print $line;
154             }</pre>
<p>&lt;snip&gt;</p>
<pre>156     }</pre>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=23</wfw:commentRss>
		</item>
		<item>
		<title>Sausage Beak</title>
		<link>http://peteharris.me.uk/?p=22</link>
		<comments>http://peteharris.me.uk/?p=22#comments</comments>
		<pubDate>Tue, 16 Mar 2010 22:51:07 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=22</guid>
		<description><![CDATA[Made a hearty bake by following Simon&#8217;s &#8220;beak&#8221; recipe.
Thanks Simon, Thimon.

]]></description>
			<content:encoded><![CDATA[<p>Made a hearty bake by following Simon&#8217;s &#8220;beak&#8221; recipe.<br />
Thanks Simon, Thimon.<br />
<a href='http://peteharris.me.uk/wp-uploads/2010/03/2010-03-16-beak1.jpg'><img src="http://peteharris.me.uk/wp-uploads/2010/03/2010-03-16-beak1-225x300.jpg" alt="" title="Sausage Beak" width="225" height="300" class="alignnone size-medium wp-image-21" /></a></p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=22</wfw:commentRss>
		</item>
		<item>
		<title>Wacko</title>
		<link>http://peteharris.me.uk/?p=17</link>
		<comments>http://peteharris.me.uk/?p=17#comments</comments>
		<pubDate>Sat, 06 Mar 2010 11:49:39 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[drawing]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=17</guid>
		<description><![CDATA[
]]></description>
			<content:encoded><![CDATA[<p><a href='http://peteharris.me.uk/wp-uploads/2010/03/2009-06-28-wacko.jpg'><img src="http://peteharris.me.uk/wp-uploads/2010/03/2009-06-28-wacko-300x225.jpg" alt="" title="2009-06-28-wacko" width="300" height="225" class="alignnone size-medium wp-image-18" /></a></p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=17</wfw:commentRss>
		</item>
		<item>
		<title>rsync backup to external drive</title>
		<link>http://peteharris.me.uk/?p=16</link>
		<comments>http://peteharris.me.uk/?p=16#comments</comments>
		<pubDate>Tue, 02 Mar 2010 23:09:17 +0000</pubDate>
		<dc:creator>pharris</dc:creator>
		
		<category><![CDATA[computer]]></category>

		<guid isPermaLink="false">http://peteharris.me.uk/?p=16</guid>
		<description><![CDATA[I keep my &#8220;documents&#8221; and &#8220;photos&#8221; folders synced to an external hard disk
rsync --modify-window=2 -avz Documents/ /media/LACIE/Documents/
The &#8211;modify-window is because the fat32 filesystem on my USB disk has lower precision when it comes to time so rsync thinks all the files have been modified.  This flag sets a window of 2 seconds.
]]></description>
			<content:encoded><![CDATA[<p>I keep my &#8220;documents&#8221; and &#8220;photos&#8221; folders synced to an external hard disk</p>
<p><code>rsync --modify-window=2 -avz Documents/ /media/LACIE/Documents/</code></p>
<p>The &#8211;modify-window is because the fat32 filesystem on my USB disk has lower precision when it comes to time so rsync thinks all the files have been modified.  This flag sets a window of 2 seconds.</p>
]]></content:encoded>
			<wfw:commentRss>http://peteharris.me.uk/?feed=rss2&amp;p=16</wfw:commentRss>
		</item>
	</channel>
</rss>
