Posts Tagged “MySQL”

There had been a few small issues with the new server that I had to sort out this morning, but that’s done now. This morning at 02:45 was not the right time to do it, I’d been up for a long time and somehow managed to go a fair way down a bottle of Belvedere.

I added the time to the date on the top left of the posts, I’d never noticed before but if I post twice on the same day it was previously just showing both posts with the same date.

The permalinks are working again, a little mod_rewrite action in the httpd.conf and that’s all sorted.

There are a few other small backend problems, the php MySQL module is older than the MySQL version I’m using, this has come about due to a lack of installer for MySQL and me having to drop in the packages myself. I may recompile php, but again I was not up to this last night, first though I’ll weigh up whether I can really be bothered sinc it doesn’t seem to be causing me any issues, and if it ‘aint broke, then don’t fix it.

Cheers

The website issues are finally resolved. The reasons for the problems are detailed below.

Well as some of you may or may not know I recently moved house. Since I was hosting the site myself for financial reasons it meant there would be a certain period of downtime while the phone line and Internet connection was sorted out. I was aware of this and could live with it.

What I could not have foreseen was that at the same time I would have an Install issue with my little MacMini server and would be forced to reinstall the only copy of OS X I have, 10.5 onto it for web serving purposes. On it’s own this was not a problem, obviously I have backups of the site and the database so just restore them and away I go. Simple. Except up until very recently MySQL AB did not produce a compiled version of MySQL for 10.5 on PPC, only on x86. I did attempt a few times to compile the database from source but with no luck. I was seemingly stuck. As a stop gap I used the drop in solution MAMP which worked for the most part other than a few little quirks, like sometimes the web server would stop running for no reason and MAMp would not be able to start it again as it still thought it was running. This created a problem where I had no control over whether the server was up or down, with no serious monitoring effort the server may fall over and I would be non the wiser.

That is what had been happening for the last few weeks, but now MySQL AB have pulled their collective fingers out and delivered a build of MySQL for 10.5 PPC, a quick install and it’s up and running.

Fingers crossed it will be ok now, time will tell though.

Cheers

Bad Behavior has blocked 105 access attempts in the last 7 days.