The introduction of PDNSOps2
March 6, 2012
I’ve not made any mention of PDNSOps since the original blog post back in October 2011. This isn’t for lack of trying, it’s just that the holidays were a busy time and didn’t allow for a lot of programming time. We have made some progress dealing with a bunch of bugs, and we’ve also figured out our future plans for the project.
October 21, 2011
By Dsv (Own work) Public domain, via Wikimedia CommonsFor the last few years, my DNS server of choice (when I run my own) is PowerDNS. It is very simple to use, and the ability to run multiple “backends” makes it wonderfully configurable. My choice setup is PowerDNS running the MySQL backend. Of course the question is “How do I manage the MySQL backend?” and that is where PDNSOps comes in.
Serendipity to WordPress – Importer version 1.5
November 29, 2010
I should have posted this sooner, but I forgot. My Serendipity to WordPress post importer (v1.4) has been upgraded! Simone Tellini took it (in the spirit of which this software was originally released, way back when) and updated the importer to support nested categories (and of course re-released it). To make sure the software continues to be available, I’ve taken (with permission) Simone’s updated version and checked it into my Google Code SVN repo (SVN direct).
Serendipity to WordPress – Changing table prefix
June 17, 2010
While this isn’t strictly part of the migration process from S9y to WordPress, I decided to take some advice I read on the net and change the prefix for WordPress tables. Most use this feature for when they have to share a database, but the suggestions I read said to do it to help prevent from SQL injection hacks. Basically the majority of these injections presume a default of ‘wp_’ prefix.
Serendipity to WordPress – Post import
June 11, 2010
The first thing you need to do in migrating from Serendipity to WordPress, is to move the post content. Luckily for all of us, at some point in time an importer was written (and shared). It has floated around the internet for a while and been updated a number of times. The version I used was verison 1.3, last updated by a German fellow. While his updates were good, I needed a little more out of it. Two pieces that were lacking were the handling of drafts vs published posts (John and I have a number of drafts, as has been previously mentioned) and the most important, matching up post id numbers. Without that one piece, you can’t move between the two platforms and maintain any links.
In MySQL: x^y != x raised to the y
November 18, 2008
As the title states, the caret (^) is not used as an exponent in MySQL. I’m not certain what exactly it does (and couldn’t find any documentation after a quick search), and would love to find out what its purpose is. I ran into this problem today when I noticed that MySQL’s math results (using ^) didn’t match my own. After triple checking my own math, I added lots of parens and still got nowhere, so I checked the Operator Precedence and sure enough it listed the caret (^) as falling between “*, /, DIV, %, MOD” and “- (unary minus), ~ (unary bit inversion)".