If your Milestone does not auto-mount to /media/milestone (and it probably doesn’t), adjust the first step to account for your path. Additionally, these instructions assume you are using a Linux workstation to install CyanogenMod. If you are using an alternative operating system, you’ll either need to adapt these instructions, or boot a LiveCD. Set Up Your…
Subscribe via RSS
If knowledge has instrinsic value, sharing it enriches us all.
Category Archives: Guides
Importing CSV Files to SQL Databases
CSV is a data exchange format that most software can export to, since it is a simple list of values separated by commas (hence the name). Spreadsheet programs like OpenOffice Calc, Microsoft Excel, Google Docs Spreadsheet and others commonly have an ‘Export to CSV’ option, often found under the File menu. There are scripts that…
Replacing Text in Multiple Files with sed and Regular Expressions
Sometimes you need to replace text in more than one file. Often a quick ‘find and replace’ with your favourite text editor (CTRL+\ in nano, for instance) can do this, and when multiple files is a small number, this is a practical method. When dealing with text replacement for large sets of files, a quick…
Storing date without time in SQL Server 2005
The Problem Apparently Microsoft SQL Server 2005 doesn’t offer a data type that stores date only, which is all sorts of inconvenient. I am certain this was not merely an oversight, and that it was actually the result of carefully planning and design. I wish I knew what the reasoning was, though. From MSDN: datetime…
Resolving 32-Bit Dependencies on 64-Bit Ubuntu (or Debian) with getlibs
One of the more irritating aspects of running a 64-bit distribution is that there are still many applications that are not compiled as native 64-bit binaries. This leads to dependence on 32-bit libraries, and managing these 32-bit dependencies is often unpleasant. There is no shortage of users who have introduced more problems than they have…
Setting Up Parental Controls with DansGuardian and Squid
Ignoring the dangers implicit with censorship, this guide should offer a simple way to filter what some may consider “objectionable” content from the cesspool that is the internet. The configuration outlined here may also have the added benefit of caching web requests, which can lead to noticeable performance gains for many home users, most often…
Using mod_rewrite to Fix Canonical Problems
Canonical problems occur when there is confusion over which version of a given document is ‘official’. If a URI identifies a specific document, two different URIs are often treated as two different documents. If the contents of each do not differ, it could be assumed that one is a copy of the other. In fact,…
Dual WAN Configuration with Linux
This article presents a straightforward approach to Dual WAN configuration with Linux (using multiple independent internet connections on one system). While the examples provided are for multiple ethernet connections, they could easily apply to a mixed ethernet/wireless system with some minor changes. Requirements PC or router running GNU/Linux (tested on Debian/Ubuntu/Gentoo) Multiple WAN Connections, either…
Building .deb Packages from Source in Ubuntu (or Debian)
Sometimes, we need to build a package from source. For performance reasons (architecture-specific optimizations), memory reasons (removing features we don’t need), or just for kicks. In Ubuntu (or any other Debian derivative, for that matter), this can often pose a problem, as such hand-built packages are no longer managed by our Package Manager. Removal is…
Forcing SSL Connections with .htaccess and mod_rewrite
Warning! Forcing SSL use like this can cause more problems than it is worth. Anything that is not SSL-aware will be unable to view your site. This can break compatibility with web services (see the example of FeedBurner below, including a workaround), search spiders (many may regard SSL-enabled content as private, and not index it),…
