Server move and oddities

Windows Server SystemYou may have noticed some very odd things going on around the site over the past week or so. This is because I have moved this website from a Linux box, which has been very good to me over the past 4 years, to the dedicated Windows server that I got up and running a few weeks ago for Pineapple Boudoir.

This posed a few problems, the least of these being that WordPress runs on MySQL and we’re currently using SQL Server 2005. The two can (and do) run in perfect harmony, but obviously security is paramount and also we needed to make sure that there were enough resources available to run two database servers, so a few hours was spent making sure that the MySQL server was configured to be as tightly locked up as possible and running optimally.

Then there were permissioning problems. I run quite a few different plugins for WordPress, a few of them integral to the site, like the Google Reader feed that you can see on the right hand side. These use API’s to pull from their respective providers, the data then gets written (somewhere) so that it can be included in the sidebar. The problem was that each of these different plugins was writing the data to somewhere different and the way that I have set up the accounts on the server is so that the ability to write data to a folder is given on a case-by-case basis, to ensure that random scripts and plugins cannot write to any folder that they wish whenever they wish, thus maintaining a high level of accountability.

But, I’m glad to announce that hintofsarcasm is now functioning to its full potential and having tried all ways that I can to break it I have managed to iron out all the bugs that I have come across.

Let me know if you find anything though.


Leave a Comment.