<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss 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" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" version="2.0">

<channel>
	<title>benperove.com</title>
	
	<link>http://benperove.com</link>
	<description>chronicles of geekdom</description>
	<lastBuildDate>Wed, 10 Mar 2010 02:41:55 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/benperove" /><feedburner:info xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" uri="benperove" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>Cybertool.mobi</title>
		<link>http://benperove.com/misc/cybertool-mobi/</link>
		<comments>http://benperove.com/misc/cybertool-mobi/#comments</comments>
		<pubDate>Thu, 17 Sep 2009 04:38:33 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[Misc]]></category>
		<category><![CDATA[apache]]></category>
		<category><![CDATA[Cybertool.mobi]]></category>
		<category><![CDATA[Networks]]></category>
		<category><![CDATA[projects]]></category>
		<category><![CDATA[security]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=443</guid>
		<description><![CDATA[Has it been 8  months since my last post?  Yeesh.  I need to get more simplistic when it comes to this whole blogging thing. When I&#8217;m not working, reading, studying for exams, training for races, or plotting to save the world, apparently I&#8217;m writing PHP?  I know&#8211;scary thought for a server/network guy.  Just the same&#8230; [...]]]></description>
			<content:encoded><![CDATA[<p><img class="alignleft" style="padding: 0 7px 3px 0; float: left;" title="tortoise crossing" src="http://benperove.com/files/tortoise_xing.jpg" alt="" width="139" height="146" />Has it been 8  months since my last post?  Yeesh.  I need to get more simplistic when it comes to this whole blogging thing.</p>
<p>When I&#8217;m not working, reading, studying for exams, training for races, or plotting to save the world, apparently I&#8217;m writing PHP?  I know&#8211;scary thought for a server/network guy.  Just the same&#8230; Happy Gilmore was a hockey player, not a golfer.</p>
<p>I&#8217;ve updated the site to include a <a href="http://benperove.com/projects/">projects</a> page, where  my latest &amp; greatest will be available for anyone who wants to check it out.</p>
<p>Speaking of which, I&#8217;ve recently built a mobile application called <a href="http://cybertool.mobi">Cybertool</a>.  It&#8217;s a collection of utilities that might help to   diagnose and resolve network issues.  For a while, I&#8217;ve used a handful of different sites to fix DNS, mail, or firewall stuff.  Cybertool is an aggregate of those sites for your mobile device.  As an added bonus, there are tools like Cisco password decryption, a default passwords list, and a subnet calculator.  It&#8217;s still a work in progress, so there&#8217;s a small list of bugs to iron out yet, but I&#8217;ve worked really hard to make sure it&#8217;s invulnerable to XSS/SQL injection, and have hardened Apache (obviously from my <a href="http://benperove.com/howto/bullet-proof-apache-nikto-security-scanner/" target="_blank">previous post</a>, as well as part II about mod_security which is coming soon).  All activity is logged and monitored, so don&#8217;t try anything funny!  It will get you banned faster than Paris Hilton at a spelling bee&#8230; faster than Kanye West at a charity event&#8230;  you get the point.</p>
<p>Be sure to leave comments over at the Cybertool <a href="http://benperove.com/projects/cybertool">projects</a> page.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=KsaZto7aF-k:VPPGub39V70:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=KsaZto7aF-k:VPPGub39V70:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=KsaZto7aF-k:VPPGub39V70:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=KsaZto7aF-k:VPPGub39V70:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=KsaZto7aF-k:VPPGub39V70:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=KsaZto7aF-k:VPPGub39V70:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=KsaZto7aF-k:VPPGub39V70:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=KsaZto7aF-k:VPPGub39V70:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=KsaZto7aF-k:VPPGub39V70:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/misc/cybertool-mobi/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Bullet-proof Apache: Nikto Security Scanner</title>
		<link>http://benperove.com/howto/bullet-proof-apache-nikto-security-scanner/</link>
		<comments>http://benperove.com/howto/bullet-proof-apache-nikto-security-scanner/#comments</comments>
		<pubDate>Mon, 26 Jan 2009 00:52:05 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[apache]]></category>
		<category><![CDATA[Linux]]></category>
		<category><![CDATA[security]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=327</guid>
		<description><![CDATA[If you&#8217;ve ever been responsible for maintaining an Apache web server, you know how important security is. Nikto provides an easy way to scan for known (and unknown) vulnerabilities within your Apache server.  Actually, it does a fairly comprehensive scan on over 200 web servers, not just Apache.  To run a security scan, download the [...]]]></description>
			<content:encoded><![CDATA[<p><img style="float:left; padding:0px 10px 0px 0px;" title="Apache" src="http://www.apache.org/images/feather.gif" alt="apache" width="91" height="27" /></p>
<p>If you&#8217;ve ever been responsible for maintaining an Apache web server, you know how important security is.</p>
<p><a href="http://www.cirt.net/nikto2">Nikto</a> provides an easy way to scan for known (and unknown) vulnerabilities within your Apache server.  Actually, it does a fairly comprehensive scan on over 200 web servers, not just Apache.  To run a security scan, download the tool, then extract the archive to the desired location.  To initiate a scan from the Nikto directory, type:</p>
<div class="codesnip-container" >./nikto.pl -host [ip address]</div>
<p>Note: when specifying an IP address, make sure you use the external IP of your webserver, not the internal IP.</p>
<p>Here is what my results look like:</p>
<div class="codesnip-container" >- Nikto v2.03/2.04<br />
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br />
+ Target IP:          10.0.0.1<br />
+ Target Hostname:    <em>blurred for security</em><br />
+ Target Port:        80<br />
+ Start Time:         2009-01-26 16:44:36<br />
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br />
+ Server: Apache<br />
+ OSVDB-3092: GET /manual/ : Web server manual found.<br />
+ OSVDB-3268: GET /manual/images/ : Directory indexing is enabled: /manual/images<br />
+ OSVDB-3233: GET /icons/README : Apache default file found.<br />
+ 3577 items checked: 3 item(s) reported on remote host<br />
+ End Time:        2009-01-26 16:45:25 (49 seconds)<br />
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br />
+ 1 host(s) tested</p>
<p>Test Options: -host 10.0.0.1<br />
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;</p></div>
<p>I would then look up the results and fix each issue until there have been no issues detected.  See the OSVDB-ID?  These IDs are found in the <a href="http://osvdb.org">Open Source Vulnerability Database</a>.  Each ID will contain a description, classification, and solution.</p>
<p>To aid in your research, I have created an <a href="http://mycroft.mozdev.org/search-engines.html?name=osvdb">OSVDB Firefox search plugin</a>.  Install the plugin and then search for <em>3092</em>, <em>3268</em>, <em>3233</em>, etc.</p>
<p>Hopefully this makes securing your web server quick &amp; painless.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=Qet6d2k825c:ek-XqF68RLg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=Qet6d2k825c:ek-XqF68RLg:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=Qet6d2k825c:ek-XqF68RLg:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=Qet6d2k825c:ek-XqF68RLg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=Qet6d2k825c:ek-XqF68RLg:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=Qet6d2k825c:ek-XqF68RLg:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=Qet6d2k825c:ek-XqF68RLg:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=Qet6d2k825c:ek-XqF68RLg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=Qet6d2k825c:ek-XqF68RLg:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/bullet-proof-apache-nikto-security-scanner/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Find Linux CPU Temperature</title>
		<link>http://benperove.com/howto/find-linux-cpu-temperature/</link>
		<comments>http://benperove.com/howto/find-linux-cpu-temperature/#comments</comments>
		<pubDate>Sun, 25 Jan 2009 21:14:07 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[acpi]]></category>
		<category><![CDATA[Linux]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=217</guid>
		<description><![CDATA[The easiest way to get a CPU temperature readout from Linux is by looking at an ACPI function called temperature: cat /proc/acpi/thermal_zone/THRM/temperature You could also try sensors-detect and then sensors, but I had some trouble detecting the correct modules on 8 year old hardware.]]></description>
			<content:encoded><![CDATA[<p><img style="float:left; padding: 0 7px 3px 0px;" title="linux cpu temperature" src="http://www.skilarosiere1850.com/images/icon_temperature.png" alt="" width="40" height="50" />The easiest way to get a CPU temperature readout from Linux is by looking at an ACPI function called temperature:</p>
<div class="codesnip-container" >cat /proc/acpi/thermal_zone/THRM/temperature</div>
<p>You could also try <em>sensors-detect</em> and then <em>sensors</em>, but I had some trouble detecting the correct modules on 8 year old hardware.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=nuJPtVwfL7Q:b30NwAcbnoU:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=nuJPtVwfL7Q:b30NwAcbnoU:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=nuJPtVwfL7Q:b30NwAcbnoU:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=nuJPtVwfL7Q:b30NwAcbnoU:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=nuJPtVwfL7Q:b30NwAcbnoU:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=nuJPtVwfL7Q:b30NwAcbnoU:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=nuJPtVwfL7Q:b30NwAcbnoU:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=nuJPtVwfL7Q:b30NwAcbnoU:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=nuJPtVwfL7Q:b30NwAcbnoU:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/find-linux-cpu-temperature/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>uTrack Mobile Application</title>
		<link>http://benperove.com/utrack/utrack-mobile-application/</link>
		<comments>http://benperove.com/utrack/utrack-mobile-application/#comments</comments>
		<pubDate>Mon, 05 Jan 2009 07:52:11 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[utrack]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=361</guid>
		<description><![CDATA[Trendy name aside, the uTrack mobile application is entirely responsible for my recent disappearance. Find out more about uTrack.]]></description>
			<content:encoded><![CDATA[<p><a href="http://utrack.mobi"><img style="float:left; padding-right:5px;" src="http://utrack.mobi/utrack.png" alt="" width="179" height="34" /></a>Trendy name aside, the <a title="uTrack mobile application" href="http://utrack.mobi" target="_self">uTrack mobile application</a> is entirely responsible for my recent disappearance. Find out more about <a title="uTrack" href="http://benperove.com/utrack/" target="_self">uTrack</a>.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=1Tp9e4Cbzvs:jiFCYAZDlXc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=1Tp9e4Cbzvs:jiFCYAZDlXc:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=1Tp9e4Cbzvs:jiFCYAZDlXc:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=1Tp9e4Cbzvs:jiFCYAZDlXc:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=1Tp9e4Cbzvs:jiFCYAZDlXc:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=1Tp9e4Cbzvs:jiFCYAZDlXc:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=1Tp9e4Cbzvs:jiFCYAZDlXc:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=1Tp9e4Cbzvs:jiFCYAZDlXc:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=1Tp9e4Cbzvs:jiFCYAZDlXc:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/utrack/utrack-mobile-application/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Dual-Boot a Sansa e260 with Sandisk OG and Rockbox</title>
		<link>http://benperove.com/howto/dual-boot-a-sansa-e260-with-sandisk-og-and-rockbox/</link>
		<comments>http://benperove.com/howto/dual-boot-a-sansa-e260-with-sandisk-og-and-rockbox/#comments</comments>
		<pubDate>Sun, 04 Jan 2009 08:09:50 +0000</pubDate>
		<dc:creator>iceolate</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[dual boot]]></category>
		<category><![CDATA[mp3 player]]></category>
		<category><![CDATA[rockbox]]></category>
		<category><![CDATA[sandisk]]></category>
		<category><![CDATA[sansa]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=375</guid>
		<description><![CDATA[Hi, thanks for reading. I&#8217;m a friend of Ben&#8217;s and he&#8217;s letting me put down this post. I run a small electronic music blog at astropope.com. If you have seen the post about how to boost wordpress audio with Amazon S3, then you know we are the guinea pigs to test a new breed of [...]]]></description>
			<content:encoded><![CDATA[<p>Hi, thanks for reading. I&#8217;m a friend of Ben&#8217;s and he&#8217;s letting me put down this post. I run a small electronic music blog at <a href="http://www.astropope.com">astropope.com</a>. If you have seen the post about <a href="http://benperove.com/howto/boost-wordpress-audio-w-amazon-s3/" target="_blank">how to boost wordpress audio with Amazon S3</a>, then you know we are the guinea pigs to test a new breed of online music blogging.</p>
<p>Pompous? Maybe. Fun? Yes. If you like music as much as we do, you probably want to be wearing it around your neck 24/7. In my case, you want it to listen to on your public transportation commute to work. Right? Or you&#8217;re having a hard time transporting 100+ gigs of music to your FreeBSD workstation. I know the feeling.</p>
<p>In this article, I am going to show how to set up your Sansa e260 as a &#8220;dual boot&#8221; with Sandisk&#8217;s original firmware and the Rockbox software.</p>
<p>I am not an expert on the technical differences between MSC or MTP, but in order to install the Rockbox software, you MUST have your Sansa in MSC mode. In Sansa&#8217;s original operating software, you will need to navigate to the &#8220;Settings&#8221; part of the wheel menu. Within there, you will find an option to switch between MCP and MTP. Many Google searches will give you quite intoxicating information of the minute details of both protocols.</p>
<p>The first thing it would be nice for you to do is update the firmware (since mine was refurbished, I had to update the firmware). Download the <a href="http://www.sandisk.com/Retail/Default.aspx?CatID=1376">firmware updater</a> and install it. I cannot always guarantee the accuracy of that link, but if it ever goes down, go to sandisk.com and look around.</p>
<p>Once you have updated what I called the &#8220;OG&#8221; Sansa software, you are ready to start installing Rockbox. You can begin by going to the <a href="http://www.rockbox.org/download/" target="_blank">install page</a> and selecting the appropriate device.</p>
<p>At the time of this version, we are working with version 3.1 of Rockbox and SanDisk Sansa e200. I tried Option 1, the Automatic Install, but this did not work for me as it constantly claimed it could not detect my Sansa device, so I opted for the manual install.</p>
<p>Download the <a href="http://download.rockbox.org/release/3.1/rockbox-sansae200-3.1.zip" target="_blank">archive for the Rockbox installation</a> and extract the contents to the root of your Sansa&#8217;s file system. For example, H:\.rockbox</p>
<p>Once that has been completed, you can access both the Rockbox software and Sandisk original firmware by installing <a>sansapatcher.exe</a>.</p>
<p>You should now have a pretty sweet &#8220;dual booting&#8221; mp3 player. Upon reboot, it will default to Rockbox, but you can get to the &#8220;OG&#8221; by pressing left on the main control. </p>
<p>You have any problems, please let us know!</p>
<p>http://www.sandisk.com<br />

http://www.rockbox.org</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=gDyLmW1899k:i7ECxGsirB4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=gDyLmW1899k:i7ECxGsirB4:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=gDyLmW1899k:i7ECxGsirB4:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=gDyLmW1899k:i7ECxGsirB4:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=gDyLmW1899k:i7ECxGsirB4:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=gDyLmW1899k:i7ECxGsirB4:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=gDyLmW1899k:i7ECxGsirB4:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=gDyLmW1899k:i7ECxGsirB4:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=gDyLmW1899k:i7ECxGsirB4:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/dual-boot-a-sansa-e260-with-sandisk-og-and-rockbox/feed/</wfw:commentRss>
		<slash:comments>5</slash:comments>
		</item>
		<item>
		<title>Boost WordPress Audio w/ Amazon S3</title>
		<link>http://benperove.com/howto/boost-wordpress-audio-w-amazon-s3/</link>
		<comments>http://benperove.com/howto/boost-wordpress-audio-w-amazon-s3/#comments</comments>
		<pubDate>Mon, 22 Sep 2008 07:46:01 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[amazon s3]]></category>
		<category><![CDATA[wordpress]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=143</guid>
		<description><![CDATA[The Simple Storage Service (S3) from Amazon is an easy way to serve information. Its high availability and low cost make it a no-brainer when it comes to hosting. Recently, a friend moved his website (the Astropope) from my server to that of a hosting company (for which he presently works). Along with his account [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://aws.amazon.com"><img style="float:left; padding-right:5px;" title="AWS" src="http://www.benperove.com/files/aws.jpg" alt="" width="213" height="83" /></a>The Simple Storage Service (S3) from Amazon is an easy way to serve information. Its high availability and <a href="http://aws.amazon.com/s3/#pricing" target="_blank">low cost</a> make it a no-brainer when it comes to hosting.</p>
<p>Recently, a friend moved his website (<a href="http://astropope.com" target="_blank">the Astropope</a>) from my server to that of a hosting company (for which he presently works). Along with his account comes 3 GB of storage, except he currently uses about 5 GB. To help with the transition, we decided to move the majority of content over to S3.</p>
<p>In order to do this, we got an account, uploaded everything, made a DNS record, and then ever-so-slightly modified a WordPress plugin.</p>
<p>The steps we took are detailed for your convenience:</p>
<p>1. Sign up for an <a href="http://aws.amazon.com/s3/" target="_blank">S3 account</a>.</p>
<p>2. Download, install &amp; configure the <a href="https://addons.mozilla.org/en-US/firefox/addon/3247" target="_blank">S3Fox plugin</a> for <a href="http://www.getfirefox.com/">Firefox</a>.</p>
<p>3. Amazon uses a<em> bucket</em> as a means for organizing information. You may refer to a bucket as a unique, top-level directory. Many directories may exist within a bucket, but the most absolute of those contained within is a &#8216;bucket&#8217;. Create a bucket named <em>s3.[yourdomain].com</em>. In that bucket, make an <em>audio</em> directory. So now we have something along the lines of <em>s3.[yourdomain].com/audio</em>.</p>
<p>4. Using S3Fox, upload your mp3 files to the newly created <em>audio</em> directory within the bucket.</p>
<p>5. Right-click the <em>audio</em> directory and specify an ACL with read access for public requests. <span style="color: red;">Note: Without specifying an ACL w/ public read access, it won&#8217;t work.</span></p>
<p>6. Within <a href="http://wordpress.org" target="_blank">WordPress</a>, install the <a href="http://wordpress.org/extend/plugins/audio-player/" target="_blank">Audio Player plugin</a>.</p>
<p>7. Once installed, modify the plugin as such:</p>
<p><strong>edit audio-player.php</strong></p>
<p>Under // Options Default add:<br />
add_option(&#8216;s3_url&#8217;, &#8221;, &#8220;Amazon S3 URL&#8221;, true);</p>
<p>Under // Global variables change $ap_audioURL to:<br />
$ap_audioURL = get_settings(&#8216;s3_url&#8217;) . get_option(&#8220;audio_player_web_path&#8221;);</p>
<p>Under // Update plugin options add:<br />
update_option(&#8216;s3_url&#8217;, $_POST['s3_url']);</p>
<p><strong>edit options-panel.php</strong></p>
<div class="codesnip-container" >&lt;tr&gt;<br />
&lt;th width=&#8221;33%&#8221; valign=&#8221;top&#8221;&gt;&lt;label for=&#8221;ap_audiowebpath&#8221;&gt;Audio files directory:&lt;/label&gt;&lt;/th&gt;<br />
&lt;td&gt;<br />
&lt;input type=&#8221;text&#8221; id=&#8221;ap_audiowebpath&#8221; name=&#8221;ap_audiowebpath&#8221; size=&#8221;40&#8243; value=&#8221;&lt;?php echo( get_option(&#8220;audio_player_web_path&#8221;) ); ?&gt;&#8221; /&gt;&lt;br /&gt;<br />
Recommended: &lt;code&gt;/audio&lt;/code&gt;<br />
&lt;/td&gt;<br />
&lt;/tr&gt;<br />
&lt;!&#8211; snipit starts here &#8211;&gt;<br />
&lt;tr&gt;<br />
&lt;th width=&#8221;33%&#8221; valign=&#8221;top&#8221;&gt;&lt;label for=&#8221;s3_url&#8221;&gt;Amazon S3 URL:&lt;/label&gt;&lt;/th&gt;<br />
&lt;td&gt;<br />
&lt;input type=&#8221;text&#8221; id=&#8221;s3_url&#8221; name=&#8221;s3_url&#8221; size=&#8221;40&#8243; value=&#8221;&lt;?php echo( get_option(&#8220;s3_url&#8221;) ); ?&gt;&#8221; /&gt;&lt;br /&gt;<br />
&lt;?php $string = get_option(&#8220;siteurl&#8221;);<br />
$url2 = substr($string, 7);<br />
echo &#8220;(e.g. http://s3.&#8221; . $url2 . &#8220;)&#8221;; ?&gt;<br />
&lt;/td&gt;<br />
&lt;/tr&gt;<br />
&lt;!&#8211; snipit ends here &#8211;&gt;</div>
<p>Alternately, you can upload/replace with these pre-modified files:<br />
wp-content/plugins/<a href="http://benperove.com/files/audio-player.ph_" target="_blank">audio-player.php</a><br />
wp-content/plugins/audio-player/<a href="http://benperove.com/files/options-panel.ph_">options-panel.php<br />
</a>(be sure to rename from .ph_ to .php)<a href="http://benperove.com/files/options-panel.ph_"></a></p>
<p>Login to WordPress, then go to Settings -&gt; Audio player and add http://s3.[yourdomain].com to the new field below the audio files directory.</p>
<p>8. Add a cname (alias) at your domain registrar:<br />
S3 -&gt; bucketname.s3.amazonaws.com<br />
(e.g. s3.[yourdomain].com.s3.amazonaws.com)<br />
where S3 points to bucketname.s3.amazonaws.com. (TTL of 1 hr is acceptable.)</p>
<p>9. Post a song according to the directions for the plugin.</p>
<p>Did it work for you? Did you run into any trouble? (I&#8217;d be happy to help you set this up if you&#8217;d like assistance.)</p>
<p><em>&#8211; Edit:  9.16.09 &#8211;</em></p>
<p><em>Version 2.0 beta 6 of the Audio Player plugin includes an option for a custom URL.  When upgrading to this most recent version, there is no need to modify any source code.  Nice!<br />
</em></p>
<p><img class="alignleft" title="Audio Player 2.0b6 setting" src="http://benperove.com/files/audio_player2_setting.png" alt="" width="477" height="111" /></p>
<p><em>Also, the most recent version of the  WordPress S3 plugin version .4 adds a setting for virtual hosting:</em><em><br />
</em></p>
<p><img class="alignleft" title="S3 Plugin .4 Virtual Host Setting" src="http://benperove.com/files/s3_setting.png" alt="" width="669" height="53" /></p>
<p><em>Make sure you check the &#8216;Bucket is setup for virutal hosting&#8217; box.  If you see DNS warnings at the top of the plugin screen, refresh the page and it should go away (if you had this setup previously).</em></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=8Nolq09_yaQ:ctHpBV1_l7s:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8Nolq09_yaQ:ctHpBV1_l7s:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=8Nolq09_yaQ:ctHpBV1_l7s:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8Nolq09_yaQ:ctHpBV1_l7s:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=8Nolq09_yaQ:ctHpBV1_l7s:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8Nolq09_yaQ:ctHpBV1_l7s:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8Nolq09_yaQ:ctHpBV1_l7s:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8Nolq09_yaQ:ctHpBV1_l7s:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=8Nolq09_yaQ:ctHpBV1_l7s:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/boost-wordpress-audio-w-amazon-s3/feed/</wfw:commentRss>
		<slash:comments>12</slash:comments>
		</item>
		<item>
		<title>Setup Openfire Chat Server and Configure Asterisk-IM Plugin</title>
		<link>http://benperove.com/howto/setup-openfire-chat-server-and-configure-asterisk-im-plugin/</link>
		<comments>http://benperove.com/howto/setup-openfire-chat-server-and-configure-asterisk-im-plugin/#comments</comments>
		<pubDate>Sun, 27 Jul 2008 00:29:23 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[asterisk]]></category>
		<category><![CDATA[openfire]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=124</guid>
		<description><![CDATA[In this session, I will show you how to setup the Openfire real-time collaboration server from Ignite Realtime. This free, open source application is a great way for organizations to leverage chat capabilities. Also, we&#8217;re going to configure the Asterisk-IM plugin to interface with our Asterisk PBX. This plugin can be configured to display Caller [...]]]></description>
			<content:encoded><![CDATA[<p>In this session, I will show you how to setup the <a title="Openfire" href="http://www.igniterealtime.org/projects/openfire/index.jsp" target="_blank">Openfire</a> real-time collaboration server from <a title="Ignite Realtime" href="http://www.igniterealtime.org/" target="_blank">Ignite Realtime</a>. This free, open source application is a great way for organizations to leverage chat capabilities.</p>
<p>Also, we&#8217;re going to configure the Asterisk-IM plugin to interface with our <a title="Asterisk" href="http://www.asterisk.org" target="_blank">Asterisk</a> PBX. This plugin can be configured to display Caller ID information, and view the phone status of other users.</p>
<p>We&#8217;ll be using <a title="Spark" href="http://http://www.igniterealtime.org/projects/spark/index.jsp" target="_blank">Spark</a> as the chat client, also from <a title="Ignite Realtime" href="http://www.igniterealtime.org/" target="_blank">Ignite Realtime</a>.</p>
<p><a href="http://benperove.com/screencast/openfire/openfire.htm"><img src="http://benperove.com/files/screencast.png" alt="" /></a></p>
<p>Installing Openfire on Fedora is simple:</p>
<div class="codesnip-container" >rpm -ivh openfire-3-5-2-1.i386.rpm</div>
<p>When the transaction has completed and Openfire has started, access http://hostname:9090 to finish the remaining portion of the setup process.</p>
<p>In this demo, I used a domain name for the system that would be considered inadequate in most cases. It is always best to use the FQDN (fully qualified domain name) of your system. Also, don&#8217;t forget to allow client traffic through your firewall (TCP 5222-5223), with each client as well. Did you run into configuration issues or problems? How did this install go for you?</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=QoaX2qNWQ6M:QOCOmprnEP0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=QoaX2qNWQ6M:QOCOmprnEP0:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=QoaX2qNWQ6M:QOCOmprnEP0:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=QoaX2qNWQ6M:QOCOmprnEP0:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=QoaX2qNWQ6M:QOCOmprnEP0:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=QoaX2qNWQ6M:QOCOmprnEP0:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=QoaX2qNWQ6M:QOCOmprnEP0:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=QoaX2qNWQ6M:QOCOmprnEP0:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=QoaX2qNWQ6M:QOCOmprnEP0:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/setup-openfire-chat-server-and-configure-asterisk-im-plugin/feed/</wfw:commentRss>
		<slash:comments>9</slash:comments>
		</item>
		<item>
		<title>Create an Encrypted Flash/Removable Volume With TrueCrypt 6</title>
		<link>http://benperove.com/howto/create-an-encrypted-flashremovable-volume-with-truecrypt-6/</link>
		<comments>http://benperove.com/howto/create-an-encrypted-flashremovable-volume-with-truecrypt-6/#comments</comments>
		<pubDate>Fri, 18 Jul 2008 07:29:01 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[truecrypt]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=23</guid>
		<description><![CDATA[I constantly push to implement a solid backup plan for clients. Some opt to get their data off-site, which is always a smart thing to do. You can&#8217;t ever have too much backup. Only thing is&#8211;there&#8217;s no easy way to get a 30 gig Exchange database off-site regularly over a WAN connection&#8230; unless you use [...]]]></description>
			<content:encoded><![CDATA[<p>I constantly push to implement a solid backup plan for clients. Some opt to get their data off-site, which is always a smart thing to do. You can&#8217;t ever have too much backup. Only thing is&#8211;there&#8217;s no easy way to get a 30 gig Exchange database off-site regularly over a WAN connection&#8230; unless you use an external disk. For this, I carry my trusty Seagate, but what if it fails? What if it were lost or stolen? Huge amounts of private information could be exposed.  NOT good. We need security.</p>
<p>I copy these super sensitive files to an encrypted volume on my external disk. I created this volume with <a href="http://truecrypt.org" target="_blank">TrueCrypt</a>, a free encryption utility that runs on Windows, Linux, and Mac OS X.</p>
<p>There are a few ways to go about encrypting a removable volume. (Before we begin, make sure you&#8217;ve downloaded and setup TrueCrypt.)</p>
<p><strong>Part 1: Create an encrypted container on a flash drive</strong></p>
<p><a href="http://benperove.com/screencast/tc1/tc1.htm"><img src="http://benperove.com/files/screencast.png" alt="" /></a></p>
<p>This works pretty good on flash drives, though a few caveats exist. First of all, Windows XP &amp; Vista don&#8217;t support multiple partitions on removable drives. Because of this, we must create a container file that resides on one partition.</p>
<p>Note: Some flash drive manufacturers (such as Lexar) have created utilites that allow you to <a href="http://www.pendriveapps.com/2008/05/01/bootit-lexar-usb-flip-the-removable-media-bit-tool/" target="_blank">set the removable media bit</a>, effectively fooling windows into thinking the flash drive is a real hard drive. Unless you know of a way to do this on your flash drive, a container file is the way to go.</p>
<p><strong>Part 2: Create an encrypted volume on an external disk</strong></p>
<p><a href="http://benperove.com/screencast/tc2/tc2.htm"><img src="http://benperove.com/files/screencast.png" alt="" /></a></p>
<p>Notice how we&#8217;ve previously created one large encrypted partition, and one smaller unencrypted partition. This can be done within the Disk Management subset of Computer Management (when right-clicking My Computer &gt; Manage). The traveler files will live on this smaller partition.</p>
<p>Any type of TrueCrypt volume will secure your data with very strong encryption (using a password of <em>at least</em> 20 characters). Attempting to break this would bring the best cryptographers and supercomputers to certain resignation. This is real government-grade security (and certainly good enough for 007).</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=8hGY3mTfjbw:Cs2xzL5naEY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8hGY3mTfjbw:Cs2xzL5naEY:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=8hGY3mTfjbw:Cs2xzL5naEY:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8hGY3mTfjbw:Cs2xzL5naEY:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=8hGY3mTfjbw:Cs2xzL5naEY:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8hGY3mTfjbw:Cs2xzL5naEY:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8hGY3mTfjbw:Cs2xzL5naEY:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=8hGY3mTfjbw:Cs2xzL5naEY:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=8hGY3mTfjbw:Cs2xzL5naEY:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/create-an-encrypted-flashremovable-volume-with-truecrypt-6/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>Make Firefox 3 Swap Memory When Minimized</title>
		<link>http://benperove.com/howto/make-firefox-3-swap-memory-when-minimized/</link>
		<comments>http://benperove.com/howto/make-firefox-3-swap-memory-when-minimized/#comments</comments>
		<pubDate>Fri, 04 Jul 2008 06:56:33 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[firefox]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=79</guid>
		<description><![CDATA[Ever have nine Firefox windows open, with 5+ tabs in each?Â  This could easily chew up 250 megs of memory or more, even if you suddenly reduce to one window with no tabs. On a system with less than 1 gig of memory, these are valuable system resources we&#8217;re talking about here. There is a [...]]]></description>
			<content:encoded><![CDATA[<p>Ever have nine Firefox windows open, with 5+ tabs in each?Â  This could easily chew up 250 megs of memory or more, even if you suddenly reduce to one window with no tabs. On a system with less than 1 gig of memory, these are valuable system resources we&#8217;re talking about here.</p>
<p>There is a setting that will make Firefox swap its memory when minimized, which, if you&#8217;re low on memory to begin with, could mean a tremendous performance boost.</p>
<p>In Firefox&#8217;s location bar, type: <strong>about:config </strong>and agree to clear the warning message.</p>
<p>Right-click anywhere and create a <strong>new boolean value</strong> called:</p>
<div class="codesnip-container" >config.trim_on_minimize</div>
<p>Then select true for the value. Click Ok and restart Firefox.</p>
<p>When firing up the browser again, we should see immediate improvements in memory consumption when the browser is minimized, as the memory it ties up will be swapped to the disk instead.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=MLO6yaoOLgY:XofeSAeNs9U:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=MLO6yaoOLgY:XofeSAeNs9U:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=MLO6yaoOLgY:XofeSAeNs9U:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=MLO6yaoOLgY:XofeSAeNs9U:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=MLO6yaoOLgY:XofeSAeNs9U:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=MLO6yaoOLgY:XofeSAeNs9U:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=MLO6yaoOLgY:XofeSAeNs9U:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=MLO6yaoOLgY:XofeSAeNs9U:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=MLO6yaoOLgY:XofeSAeNs9U:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/make-firefox-3-swap-memory-when-minimized/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>Delete MySQL Rows Older Than Date</title>
		<link>http://benperove.com/howto/delete-mysql-rows-older-than-date/</link>
		<comments>http://benperove.com/howto/delete-mysql-rows-older-than-date/#comments</comments>
		<pubDate>Wed, 25 Jun 2008 22:04:45 +0000</pubDate>
		<dc:creator>Ben</dc:creator>
				<category><![CDATA[How-To]]></category>
		<category><![CDATA[mysql]]></category>

		<guid isPermaLink="false">http://benperove.com/?p=74</guid>
		<description><![CDATA[I ran into a problem recently where I needed to delete all rows in a MySQL table that were older than three months. This I was able to accomplish with the following statement: DELETE FROM [table] WHERE [column] &#60; DATE_SUB(NOW(), INTERVAL 3 MONTH); Substitute table and column, and a proper date option. The date_sub function [...]]]></description>
			<content:encoded><![CDATA[<p>I ran into a problem recently where I needed to delete all rows in a MySQL table that were older than three months. This I was able to accomplish with the following statement:</p>
<div class="codesnip-container" >DELETE FROM [table] WHERE [column] &lt; DATE_SUB(NOW(), INTERVAL 3 MONTH);</div>
<p>Substitute table and column, and a proper date option. The <a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-sub" target="_blank">date_sub</a> function subtracts a time period from the date specified. In this statement, NOW() grabs the current date from which INTERVAL 3 MONTHS is subtracted (along with the &lt; operand).</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/benperove?a=WRujdnLLOdk:hZJomjUSLKk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/benperove?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=WRujdnLLOdk:hZJomjUSLKk:RBPZm5KitOA"><img src="http://feeds.feedburner.com/~ff/benperove?i=WRujdnLLOdk:hZJomjUSLKk:RBPZm5KitOA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=WRujdnLLOdk:hZJomjUSLKk:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/benperove?i=WRujdnLLOdk:hZJomjUSLKk:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=WRujdnLLOdk:hZJomjUSLKk:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/benperove?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=WRujdnLLOdk:hZJomjUSLKk:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/benperove?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/benperove?a=WRujdnLLOdk:hZJomjUSLKk:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/benperove?i=WRujdnLLOdk:hZJomjUSLKk:gIN9vFwOqvQ" border="0"></img></a>
</div>]]></content:encoded>
			<wfw:commentRss>http://benperove.com/howto/delete-mysql-rows-older-than-date/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
	</channel>
</rss>
