Saw this on Neil's a while back and thought it would be cool to do.  One of those old-fashioned "blog memes" that people used to do twenty years ago.  I stopped commenting on Neil's blog forever ago because when I tried to catch up with him when I was in York in 2010 he completely ignored me.  His blog went dead for years but my feed reader still had it and notified me a few years back of new posts.

Why did you start blogging in the first place?

Vic said I should.  I was doing unpaid work at CIA/Host1 at the time (well, helping out with windows hosting support and answering support mail in exchange for free internet and web hosting).  I'd heard of blogs by then (January 2003) but had never read or subscribed to any.  Vic probably wanted to spread the word of his ISP a bit, so I did it.  But it very quickly became a place I could brain dump and I only wish I'd started the thing sooner so I could have recorded my life better.  Not that the early years were much good at recording events.  Too many times when I've been sorting my photos I've wondered what I was doing the day I took them, only to find no useful record.  These days are much more betterer.

What platform are you using to manage your blog and why did you choose it?

Movable Type.  Been using it since day 1.  I started using it because it came as part of the cpanel setup Host1 had so it was easy to start with.  There was one big upgrade a few years in that changed the whole directory/post/file structure layout, and the one that started inserting images as assets, but otherwise it really hasn't changed much.  I'm still using the last free open source version before it started costing $500 USD .. PER YEAR..!!  WTF!??  I really do need to modernise, not the least of which is because it uses http not https and I still haven't figured out how to *fully* sslify it (eg, canonical links)

Have you blogged on other platforms before?

I did put a few entries up on blogger.com for some more private stuff, but it never really went anywhere.  Same with the "This Day in History" posts I was trying to do here.

How do you write your posts? For example, in a local editing tool, or in a panel/dashboard that's part of your blog?

I just use the Movable Type web interface.  And only ever from my computer, or laptop when travelling.  Phone is too hard.

When do you feel most inspired to write?

Back in the day I would blog nearly every day and sometimes more often.  Usually in the evenings.  For several years now I've only blogged on the weekends after I've downloaded and processed my photos for the week.  I definitely post a lot more photos than I did twenty years ago.  Really my blog now is a place for me to post photos.  With a little bit of filler about what I've been doing.  It's also a bit less cryptic.  Reading my old entries now I have no idea what I was talking about half the time.

Do you publish immediately after writing, or do you let it simmer a bit as a draft?

I always publish immediately.  Usually on Sunday evenings.

What are you generally interested in writing about?

Nothing.  My blog's byline is "Boring Life Of a Geek" - BLOG for short.  My life is boring.  My photos are mostly of flowers and food.  I do like my travel blogs though.  There's even at least one holiday blog (USA 2000) that I wrote up from literally a paper notebook of notes I took during the trip.  And my USA 1983 blog was written entirely from my memories of the trip thirty years after the event!  When I was 9 years old!

Who are you writing for?

Myself. There's maybe like half a dozen readers that I know about, and maybe a few more I don't.  My mother and brother care most.  The sweetie might read things if they happen to show up in his feed reader.  Mostly I do it for the record of my own life.  And it's been quite useful for that.

What's your favourite post on your blog?

Don't have one. 

Any future plans for your blog? Maybe a redesign, a move to another platform, or adding a new feature?

This thing really needs to move to something more modern.  One that bakes in https naturally.  But the idea of moving it is just too daunting.  Maybe if I retire and have more time to think about such things.

Who else do you want to tag?

Ha.  Who even does that anymore??  The only two active bloggers I know that might even still read my blog from time to time are Dave2 and kapgar.

Monday.  21st.  Did I mention I'm doing low carb again for another few weeks? Except the day got off to a rocky start because I'd forgotten about an apple that needed eating. There goes my carb limit for the day.. whoops. The sweetie prepped a cauliflower bake and brussels sprouts for dinner and I chucked a chunk of beef in to go with it. I got my blogging done quite early. Funny how writing up notes properly during the week makes blogging a lot quicker on a Sunday.. or Monday in this case. DS9 2.24.

Tuesday.  Awake from Dentist Time for hours and only broken sleep after that. Sigh. NEIL at work, as well as trying to figure out the API of our IP management system to help someone with something. Leftovers for dinner, DS9 2.25. After dinner started going through Dad's photos (from when he switched from slides to prints and onwards) to get photos of Mum. Annoyingly Dad had a really bad habit of over-enhancing his photos. At least with the prints I can go back and rescan them, but for digital photos once they're enhanced at all they're destroyed because he didn't keep the originals. Which is odd in itself because he used to make backups upon backups upon backups, just not of the original unaltered files. #grunt.

Wednesday.  Slept mostly ok. Really wanted to get through some decom prep but the interruptions Would. Not. Stop. All. Day. So damned hard to concentrate with Teams and Outlook popping up every five seconds. Seriously considering turning all notifications off. The sweetie cooked creamy mushroom chicken for dinner which was very nice.

DS9 2.26. Then more photo picking. From 2010 and some of 2011 Dad saved the raw camera photos off separately to the enhanced photos. That was nice of him. Maybe there were other copies of the rest of his digital camera photos elsewhere that either he or I lost. More likely him. I spent an entire week one Christmas trying to sort it all out, and would definitely have kept any raw photos if I'd found them. Knowing him he probably made several backups, thought he had a backup, didn't in fact have a backup, and deleted the original. Or maybe he just never thought he'd need his originals. Silly Dad.

Thursday.  Slept okish until about 5:00. Mostly decom work at work. Bar 59 for drinks which was quite pleasant, although a lot more expensive than work drinks! Made pizzas then DS9 3.1.

Friday.  Anzac Day.  Lest we forget.  Awake from 1:45 for hours sigh.

House stuff mostly in the morning. Happy that Stumpy is basking more and is more enthusiastic about food.  Did some camera testing in the afternoon. Only to realise later I had it on the wrong mode. Sigh.

I need to find a spot to plant out these chrysanthemums.  I accidentally uprooted one of the ones out the front the other month and chucked it in a pot out the back.  They're now happily flowering while the ones out the front are barely hanging on to life.  These things like a lot of sun but our garden is completely hopeless so not sure where I can put them.  

Kievs for dinner.  With half a cauliflower and most of a capsicum.

DS9 3.2. Then watched Blackberry which made us both a little nostalgic. Also, it's Anzac Day but I've only worn a jumper like twice all year. Usually by now there would have been days where we'd be wanting to put the heater on in advance of the Anzac Day allowed starting date. Instead I had a window open in my room to cool it down so I could sleep.  hrmmm.

Saturday.  Slept mostly okish.

Cooked cheese kranskis and miso scrambled eggs for breakfast.  Although Stu just had eggs because he needed to only eat soft food to not break his temporary tooth crown again.

Started a jigsaw. Went for a several hour drive with the sweetie, checking out previous houses, family houses, the church we got married in etc. Was a lovely way to spend a few hours with the sweetie (and we drove like 70km!). 

Made a small share platter for lunch (although I did get hungry later)

Finished the jigsaw. Got Chong Co delivered for dinner (after the MenuLog driver finally turned up) and watched DS9 3.3, then The Princess Bride :)

Sunday.  Awake from ~3:30 and never got back to sleep. Sigh.  They promised many millimetres of rain.  We got about three drops.

Went and saw Constellations at the NFSA with Tony which was a bit of fun. House stuff mostly for the rest of the day, and some food shopping.

When you realise you have 15 different cheeses in the fridge.. whoops...

Filled with rage in the afternoon at Optus who FORCE you to use international roaming because there's no way to disable it. Their only workaround is leave the phone on flight mode and use wifi. WTF??? I think I did read somewhere that if you have a second sim you can disable the Optus one. Which would work unless I needed to receive an SMS for two factor for anything. But there's a heap of horror stories out there from people getting charged the $5/day even when the sim wasn't even in the phone!!!

Hi.

Sunday.  26th.  Leftovers for dinner, then went over to give Lily her 21st birthday presents.

Monday.  Bit late getting to sleep, then woke up at like 5.

Spent much of the day on my blog doing some catchup blog entries including a couple from 21 years ago.  Started to look at why Google isn't indexing my site very well anymore.  One error it complained about is canonical links being http.  The problem is I can't really do anything about that cause I have no idea how to fix MTEntryPermalink - <link rel="canonical" href="<$mt:EntryPermalink encode_html="1"$>"> cause I'm dumb.  It'll be buried deep deep deep in the Movable Type code somewhere.  Sad times.  Leftovers for dinner, Death in Paradise 13.6, Wednesday 1.3.  Then went and tried for some more comet photos on the new camera.

Tuesday.  Went to bed/sleep a little late, but woke up early still.  Decided to go to work (had been debating taking the day off).  Tidied up a bunch of doco from all the deleting I did on Friday.  Luv-a-Duck for dinner that we picked up when we went shopping today (Stu also cooked up a bunch of keto food).

Death in Paradise 13.7 then Mum photo picking.

Wednesday.  Took ages to get to sleep, even though it was nice and COLD after stoopidity of the day's heat.  Slept in past 6 though. 

Bit of crap in the morning then mostly planning out mail server upgrade (need to build new vms).  Home late, dinner of sausages and salad.  Death in Paradise 13.8 (end of season 13) with another preposterous setup for a murder.  Backed up computer, washed hair then bed.

Thursday.  Mail upgrade planning.  Built a vm.  Updated some doco.  Had our last drinks at Bar 59 for a while.  Made pizzas then Wednesday 1.4.

Friday.  Early night and slept ok (another nice cool change).  Crap meetings, bit of mail server work, amongst distractions.  Kievs for dinner.

Wednesday 1.5 then logged onto work for an hour and a half to do a big certificate renewal.

Saturday.  1st February.  Earlyish night but awake from 2-4.  Sigh.  Stu was awake for ages too.  Slept in til 7.  Bit of house stuff, food shopping and suddenly it's 10am and haven't really done anything.  Pretty much just cleaned the house all day.

Had EffanC over for dinner, which was lovely, it's been wayyyyy too long since we've had them over.  Did a nice rump cap, blue cheese potato bake and brussels sprouts.

Finished the last bottle of bubbles from my 50th!

Sunday.  Got about five hours sleep which wasn't too bad all things considered, but I was tired all day.  Had a nice quiet day, mostly doing Dotz and also cooking up a huge batch of mince/bacon/mushroom/garlic/onion to decorate in different ways over the next week or so.  

The other week (month!) I mentioned how I'd love to get a weather pixie working on my blog again.  Last night I had a harebrained idea to have a go at it.  At least text for now.

I first tried it with PowerShell to see if I could at least grab the file.  Easy enough (I've had a bit of practise at work over the past month) but will only run on my computer, not my web host.  So it was onto hacking Perl.  Had to do lots of Googling to get code that would work.  By bed time I could grab the contents of the JSON file from BOM, but couldn't quite parse the last hash (the JSON file there is a hash (observations), with an array (data), with a hash (each chunk)).

It may have contributed a little to me not getting to sleep for ages.  

This morning over breakfast I got it working, and was able to get it to save the data into fields and spit them out into useful infos, including a CSV file for histerical data.

I didn't spent tooo much time on it during the day - I'm wayyyy too busy to waste time on coding!

But I was able to get my script to output results into a html file that I could load in an iframe on my blog.

It's rough as guts - there's no styles at all, it's just raw html, in a table no less.  But the bones are there for it, so will tweak it as I find the time.  There's a cron job that runs every half hour to update the html file, as well as the CSV file.

Very exciting!! ;)

Monday.  9th.  Nice and cool overnight.  You'd think I'd be able to sleep.  You'd be wrong.  Took ages to get to sleep.  Busy morning before work doing all the dusting/vacuuming/weeding/cleaning the kitchen, and then time to go to work.  Cert renewal crap and meetings all day.  Kievs for dinner (was too hot and humid over the weekend to think about turning the oven on).  Did some catchup blogging, then bed.

Also waved at the peeps up on the space station.

Tuesday.  Nice and cool overnight.  You'd think I'd be able to sleep.  You'd be wrong.  Took ages to get to sleep.  Busy morning before work doing all the dusting/vacuuming/weeding/cleaning the kitchen, and then time to go to work.

Yeah a rinse and repeat.

Planned out some more decom work for later in the week.  Started looking at Daniel's quality report script.  Brain might have exploded.  Final Journey of Australian Science at the Shine Dome, which was back to hard science again which was pretty cool.  This one was related to the work of Sir John Carew Eccles.  They even had some of his family members there.

They had Prof Stephen Redman and Professor Lucy Palmer talking about their work with neurons and electricity in the brain.

Dinner at Terra afterwards.  We split a 220g beef brisket smoked steak and had charred broccolini and brisket fat chips as sides.  

Beef brisket (smoker) 220g | salsa verde $39

Charred broccolini | burnt miso butter, chili oil, garlic chips $18

Brisket fat chips $12

I enjoyed the sides.  The brisket itself I found a little.. dry..   I'm used to slower cooker brisket which is basically confit brisket.  This was done in a smoker so wasn't quite the same.  It wasn't bad, just wasn't what I'm used to.  It really needed the sauces.

Nice view of the tower on the way back to the car.

Wednesday.  Um.  I think I slept better.

Thursday.  12/12/24 - cool date!  I think I slept ok. 

Oh, I planted some mini capsicums the other week.  Some have sprouted.  At least one has been eaten already.

Got to do some decom work in the afternoon.  Ok drinks, but ate wayyy too much in the way of chips and sausage.  Still made pizzas but Stu ate most of mine.  Watched some more Jamie and Julia.

Friday.  took ages to get to sleep, then woke up at like 4:30.  Sigh.  Party day!!!!  The sweetie very kindly gave me a lift to work (he was working from home).  Picked up All The Sausages ($300 worth!!) and then just getting everything ready.  Went shopping with XL and Jo.  Then partied all afternoon! 

It was super hot though.  A special thanks to Louise and Tony for cooking the chicken and veggie stuff cause noone else wanted to go out in the heat! 

Typical though.. you give the camera to someone else and they cut off the tshirts and get all sky.  Uncropped.

Ho Ho Hold my .. bird.. ?  It's tradition for me to catch birds at these things.  I was never expecting to catch a honeyeater though!!

Finished up maybe like 19:30.  Stu took two loads of crap home.  Bestest sweetie ever!!  Con and Ward kicked on somewhere.  Tony biked it home.  And we gave Doc a lift home.  By the time we'd unpacked enough and organised, it was after nine by the time I got to bed.  Doh.

Saturday.  Slept relatively well.  Spent most of the morning organising the leftovers and party crap.  

For lunch I thought I'd see if any of the leftovers would give me food poisoning...

Mostly Lego filing in the afternoon.  Late in the afternoon I wondered how hard it would be to get a weather pixie on my blog...

Sunday.  Took ages to get to sleep (like 23:00).  Then woke up at 4:30.  Sigh.  Scripting, house stuff (two loads of washing up even! and ran the dishwasher for the second time in two days), Lego filing.  Put on my cd jukebox and listened to random crap all day.  Billy Joel sang about The King and I, and a few songs later Shall We Dance came up..!!  Funny stuff.

Monday.  28th.  Cranky cause I was meant to do a time use survey over the weekend.  Except they mailed me on Thursday.  We went to Queensland on Friday.  I never saw the emails til Monday.  When the survey had closed.  With only a "noreply" email address to reply to.  "noreply" email addresses should totally be outlawed. 

The congo tetra that hadn't been eating had died.  I was also trying to fix the outflow to the 620T tank, and found the stone that I'd previously used to pin down the filter wool from flowing away had gotten stuck there.  Just trying to deal with all the crap and suddenly it's 8:40.  Sigh.  Catching up and dealing with crap all day.  Blogged last week.  Cooked some frozen chicken pieces I had in the freezer with some veggies for dinner (cabbage bake and brussels sprouts).  Watched Mazey Day on Black Mirror.  Another "low tech" one.  Another one where they can't keep the damned camera still.

Tuesday.  Slept mostly ok.  Pissed off at one of my lovely poppy plants being knocked over.  I blame retarded cats.

So I brought the flowers inside.  As you do.

Bits and pieces day, mostly watching security talks. 

Leftovers and random stuff for dinner.  Demon 79 on Black Mirror.  Another "low tech" one.

Wednesday.  Slept mostly ok (once I finally got to sleep).  Of note is that I finally finished uploading all my Queensland 2014 photos!!  For those of you reading along at home (hi Mum!) you can go back and see food and hotel photos.  Noone else will ever care, I'm sure.  Took an early mark and went with Neil and Tony to Herbert's to finally try the very last TRBC beer - a blood orange sour.

The sweetie decided we had to have pizzas on a Wednesday since I'd be out Thursday night.. 

Thursday.  Slept mostly ok.  Stu thought it was Friday cause I'd been out drinking the night before and we'd had pizza for dinner.. 

The lake is very low at the moment...

Crap all day.  Drinks, trivia night.  Heaps of trash, like a whole round on exec baby/kid photos, and some super specific stuff that if you worked in the right area you *might* know, or crap like when does a full moon next fall on Halloween (and when did it last).  ie, not a whole heap of actual real trivia.  The exec table won.  Yeup.

Friday.  Slept mostly ok although woke up very early.  Crap all day again. 

The poppies that I brought inside.  I didn't think the unopened buds would open but they did!  But with a delicate peach colour rather than the bright orange they'd normally be.

The neighbour's bamboo is making a break for freedom.. hmmmmmmm!!

This can't be good!!

The sweetie ordered Dumpling Inn for dinner nom nom nom.  The National Anthem on Black Mirror (for some reason Netflix started me at season 6, so back to season 1).  Early night.

Saturday.  Slept mostly ok.  A day of All The Things.  Starting with the broken lemon tree..

Yeah .. 112 of them .. !!  I put 20 of them on the letterbox with a sign that said "free".  Only four left by the end of the day.

Changed the nameservers for kazza.id.au over to CloudLoop.  Did some hosting tidying up and clearing stuff out of Vodien.  

Same plant, two colours...

Leftover Dumpling Inn for dinner.  Watched an episode of Donna Hay's Christmas special from 2022.  Found her house in Avalon in a few minutes.  Although I guess it could always be some family/friend's house.  Edit: or probably just hired - there was a thing in the credits about "Katy Young, Contemporary Homes" or something.  Also.  I wish she'd stop saying "perfect".  !!  Fifteen Million Merits on Black Mirror.

Sunday.  Slept ok.  Another day of All The Things.  And still didn't get nearly enough done. 

Put another 10 lemons out on the letter box.  All gone by the end of the day.  Still have like 70 on the family room table...

Finally posted my dramas with Vodien over August/September.

Also this little bastard nearly dropped on my head.  I heard it go *thonk* right next to me as it fell down from the roof!

Hot today.  Like 31.  Gross.

Dear Vodien, 

Here's a bowl of petunias:

Tuesday 27.8.24.

I went to update my blog because I realised I'd forgotten to add a photo from last week's entry. Loaded the blog interface but got this:

Got an error: Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Loaded terminal through cPanel. Which luckily worked (no CageFS errors this time). Ran my test perl script which connects to SQL and got this:

Content-Type: text/html; charset=ISO-8859-1
DBI connect('db:localhost','<user>',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at common.pl line 18.
Cannot connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

In phpMyAdmin in cPanel I got:

mysqli_sql_exception: Access denied for user '<user>'@'localhost' (using password: YES)

Fricken great. Just what I need. Feeling like I should be buying a bowl of petunias for Vodien.

Wednesday 28.8.24.

I remembered that I'd had the phpMyAdmin error before, and the fix was to just reset the cPanel password. So I did that. Great, phpMyAdmin loads.

Except.

My MySQL database had been reverted to a point in time from last October!!

!!!!

AGAIN!!

Yeah so the exact same problem as in June where they reverted it back to the same spot in October. In June, after a week or two of yelling at them, they restored it.

So of course I yelled at them.

I didn't send them a photo of a bowl of petunias. I should have.

Now before you ask, yes I do have recent backups of my database, having learnt my lesson from last time, but that's not the damned point. In fact I'd taken a backup the Sunday before, so I was only missing one entry from my blog. But as it turned out, having my own backup was not going to help. But we'll get to that later.

Thursday 29.8.24

Vodien ticket escalated (supposedly) to the sysadmins.

Friday 30.8.24.

Still no response from Vodien about the database restore.

Saturday 31.8.24.

Still no response from Vodien about the database restore.

Sunday 1.9.24.

Still no response from Vodien - three days now. Started a new ticket. Which they promptly closed.

I changed the permissions on mt-comments.cgi so noone could post any comments. They would either fail because the entries don't exist, or break the site with a republish. And I didn't want more mess to clean up.

Monday 2.9.24.

Vodien provided a restore of the database in an .sql file and said here you go. But it was the database at the "bad" restore point from October last year - so it didn't have any recent data in it.

Tuesday 3.9.24.

One week in.

No progress getting Vodien to restore the correct database for me.

Wednesday 4.9.24.

Vodien basically keep telling me I have to restore my database myself. Which I was considering doing, assuming I actually had the right data. I did end up getting a copy that was taken a few days before they broke it, but I decided to keep pushing for the whole thing.

Then I went to my blog interface to check it and got

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at webmaster@<domain> to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

And logging into the terminal in cPanel I got

cagefs_enter: Error entering cagefs jail: Unable to mount /var/cagefs/35/<user>/home2 -> /usr/share/cagefs-skeleton/home: Too many levels of symbolic links.

So either they were trying to fix it or just making it worse.

Thursday 5.9.24.

Slept like crap. Stressing about my website. At least the cagefs file system on my website was working again in the morning. But the database is still bad.

Friday-Sunday.

Long weekend in Port Macquarie.

Sunday 8.9.24.

Checked my mail when we were near home. I shouldn't have, because the lack of useful response was just making me more and more depressed.

Monday 9.9.24.

While not getting to sleep last night I wondered if maybe there were two database servers on the server. It always used to be MySQL, but the restore they did recently (and I think I might have noticed this previously) was from Maria DB. Same only different. My latest theory is there's actually the old MySQL database server still on the host, and for whatever reason the pointers for Perl and phpMyAdmin have been pointed back at it (again). I mentioned this to them, but their only response was "what's the URL of your blog entry manager?". Yeah right like I'm going to let you into that. So I gave them a command line command that they could use to query my address book database, which has also been impacted by this whole drama. That was in the morning. No response by evening.

Tuesday 10.9.24.

Two weeks in.

No response from Vodien. Eventually they responded with something that didn't make sense, so yelled at them again to put this through to a senior sysadmin.

As an aside: if you Google "Vodien is trash" (I literally did this) you'll get links to review pages that have page after page of people ranting about how utterly trash Vodien is. One star reviews all the way.

Wednesday 11.9.24.

Awake from after 3. Vodien sent me a database restore. But restored from 19 August which was before my last backup anyway.

Tried to reload my blog index, but I got:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at webmaster@kazza.ciapics.cia.com.au to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

Turns out they've blatted all my cgi scripts permissions to 644 instead of 755 or 744. Every single one of them.

WTF?? I mean seriously, WTF???

So now what. Do I take their database, restore it, and hope they don't flip over to the other database at some random point (which I couldn't even find out from them if that's what had happened). Or do I just give up and take my clean backup to a new hosting company. Ok I'd pretty much made up my mind I was going to move. They've broken my site multiple times in the past few years, and it always takes days or weeks of yelling to get it resolved. I'm sick of it.

Thursday 12.9.24.

Apparently they've restored a database again.

Friday 13.9.24.

Tried opening my blog interface and got this:

Got an error: Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Yet my Address Book scripts still work. Ok, gave it some time and it came back. But database was still from October 2023.

Saturday 14.9.24.

Resolved myself to spending my entire weekend sorting out this mess.

Step one: find a new hosting company.

Back in 2020 I tried VentraIP. It looked to have everything I wanted and was a good price. I talked to them online before I joined and said I had a Perl/MySQL setup and they said that was fine. But when I went to get it going I found they didn't have the DBD::MySQL perl module and my blog wouldn't work. So that was a complete waste of time. So I wasn't going to try them again.

Had a look on https://www.productreview.com.au/ and someone recommended CloudLoop and they had excellent reviews. So had a look. $10/month for a basic plan which would cover what I needed. They didn't have an online chat, so I emailed them asking about Perl/MySQL. This was fairly early on a Saturday morning. They responded in MINUTES! I was impressed. So I joined up. Pro-rata til the end of the month it was only around $5, so even if it didn't work out I wouldn't lose much.

After the account was activated a short time later, I logged into cPanel only to find they don't have Terminal enabled. Fricken great. So set myself up an SSH private key to try and use ssh. But Internode blocks ssh doesn't it. Fricken fricken. So tried to log into Internode, but their MFA is trash and I had to log off/on a few times before I could finally get in. Also, Stu's phone number is out of date, but we can't update it because:

Your contact details cannot be changed at this time
Unfortunately, your contact details cannot be viewed or changed online at this time. Please contact us to update your details. We apologise for any inconvenience.

Thanks Internode, sorry iinet, sorry TPG.

Anyways, eventually got in and turned off the firewall, now to wait and see if it will work.

In the meantime I emailed support about Terminal in cPanel. Again they responded in minutes. They said it was not available for security reasons, but they enabled ssh access and I had to whitelist my IP address in the firewall. Which I couldn't actually find.
But.
Terminal now showed up in cPanel! Great! That's really all I need anyway. Let's do this thing!
(I think they may have mixed up ssh/cpanel terminal - so ssh is disabled which is fair enough, but the terminal in cpanel had been enabled which is all I needed anyway).

So first step is to make sure Perl will work with MySQL. I imported my address book database (it's only tiny) and tried out one of my scripts.

Can't locate CGI.pm in @INC (you may need to install the CGI module) (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at quickie.cgi line 3.
BEGIN failed--compilation aborted at quickie.cgi line 3.

Turns out CGI.pm hasn't been around since Perl 5.22. Vodien has 5.16. CloudLoop has 5.26.

So I get CGI.pm from CPAN. Add a line to my script to use lib and the path of the file. Works!

Next up my blog script (mt-check to start with). It wanted Util.pm so copied that up as well.

But then it wanted FCGI.pm. Got that too, but this time I got this error:

Can't locate loadable object for module FCGI in @INC

Which I think means it needs to be properly installed/compiled for binaries, which I can't do. hmmmmm

Ok so then ran mt-check on the web. It actually ran! It complained about a bunch of modules, but then it complains on the old site as well. It loaded enough that I might be able to work with it.

So next I need to get my database imported. I still didn't have the most current database export from Vodien (their exports are a different format to mine), so I used my own backup. But I was running into all sorts of problems. phpMyAdmin wouldn't import the file, giving sql errors when importing the "blob" data. And the file is 50MB so trying to edit it and cut it down to just do individual tables was proving problematic. Now I didn't have these problems when I tried VentraIP a few years back, so I'm guessing there must be some versioning problems or something?? But I was getting super frustrated with it. I did have a go at using Vodien's sql file and that one did import, albeit with old data.

Sunday 15.9.24.

So with some actual blog data in the database I next had to get an eighteen year old release of Movable Type working on a modern server. Yes yes I know I should update to something else. But newer versions of Movable Type are $499USD. PER YEAR. And I've seen the dramas people have moving to WordPress. Stu has threatened to spend his retirement moving it to a more modern platform heh. But in the meantime, I just want my blog to work.

So first up I try running mt.cgi on the command line to see what sort of errors I'd get.

[user@server MT-5.2.2]$ perl mt.cgi
Possible precedence issue with control flow operator at lib/MT/App.pm line 1821.
Content-Type: text/plain; charset=utf-8
Got an error: Unescaped left brace in regex is illegal here in regex; marked by <-- HERE in m/{{ <-- HERE support}}/?/

Yeah so now you need to escape {} characters in regex strings. Think I fixed that.

So then did a test post and that actually worked!! (using a hosts file entry on my computer so I could test it out on CloudLoop before changing DNS anywhere)

Well that was good enough for me to commit to moving the site across.

Tarballed my directory up on Vodien. ~2.5GB. !! Downloaded it to my computer, extracted it, saved into a number of smaller zip files, uploaded them one at a time, extracted them. Uploading large files must be a bit upsetting for Internode, and I kept getting dumped out of FTP because our IP address kept changing. Have I ever mentioned how trash Internode has become since they got bought out by iinet then TPG? Also I have a 5GB size limit on CloudLoop. Anyways, got there in the end.

Now all that's left is to get a proper copy of my database from Vodien. They did have a restore file taken on the morning of 26 August - the morning after my last blog post. But the files were owned by root and I had no read access. After a few chats/emails back and forth I realised there were actually two copies of the files, one in the root and one in my website. So got them. And they were perfect! Well, they had my latest data in them anyway.

Right, so tried to use phpMyAdmin to import it, but got errors again (didn't record what). But then I found this command

mysql -u database_username -p database_name < file.sql
from this site https://support.hostinger.com/en/articles/4536306-how-to-import-a-database-over-ssh
And that worked perfectly.

But it was at this point I realised that the export sql file was full of funky characters. Somewhere along the line "special characters" from foreign languages lost encoding and were broken. Tried doing search/replaces in vi, but it didn't want to play. So put that aside for now.

Tested posting some blog entries and they worked, so hopefully the database is working well enough.

But I was getting SSL certificate errors - saying it was self signed. I changed the DNS A record in Vodien and waited for it to change over, but I was still getting errors on https://www.sslshopper.com/ssl-checker.html#hostname=kazza.id.au

Emailed CloudLoop support again. Once again I got a response in minutes. And then sslhopper was picking the certificate up properly. Not sure if they did anything or not, but I was blown away by the responsiveness and usefulness of CloudLoop support. It's like a breath of fresh air after dealing with the faceless Vodien.

Monday 16.9.24.

Before all these dramas started I'd already been meaning to fix up my blogs properly. I'd fixed the style sheet on my main blog to be hardcoded to https, but I hadn't published it to everywhere, comments were still broken on https, and I wanted to get all my holidays blogs using a consistent design. I also wanted to replace the defunct Google Analytics scripts with the new ones. So after dinner I spent ages working on my holiday blog templates - fixing everything so it all works in https, fixing style sheet locations etc. I picked the Americas 2023 blog (the last one I did) and made sure everything worked properly, then made a Theme from it.

Tuesday 17.9.24.

Working through all my holiday blogs using the updated theme/design. The special characters in my Turkey blog were proving problematic :( Some of the characters I can do a search/replace in the blog interface and it'll go through and change them all. While this works for some characters (eg umlauts) it wouldn't work for some of the characters in the Turkish language :( I also found and fixed a time zone setting in my blog that has been annoying me for twenty years haha.

Wednesday/Thursday/Friday

Work on fixing holiday blogs.

Saturday 21.9.24.

Finished fixing up my holiday blogs (including the Australian Holidays blog which has a slightly different config to it, although have since found a couple of problems I still need to fix).

So then it was onto my behemoth of a main blog. There's over five thousand entries in it. The last time I tried to publish after design update it took over a day. Look I even took a screen shot! 

So I was dreading the pain it was going to cause. I'd taken notes during the fixing of my holiday blogs design, so it was pretty quick to repeat the changes in the main blog. But before I committed, I wanted to test the design with a test post to make sure it picked up everything ok.

Took a while and then BAM..

500
Internal Server Error
An internal server error has occurred.

The good news is the entry did actually post. Although not properly, and it was intermittent. Like it'd mostly update the entry page, but then not the archives page etc. So thinking there might be resource limits. I didn't see any real spikes/errors in the cPanel Resource Usage thingie though.

I tried clearing out the entire activity log. This cleared nearly 9MB out of the database. But it didn't help. I tried a few other Movable Type config options as well with no luck.

So I emailed CloudLoop support again. Once again I got a super quick response. And a stack trace. And they looked while trying to reproduce the problem themselves. This was all well and truly above and beyond the level of support I would have expected. I was astounded. But a definite possibility was the Assets. Since Movable Type 4, whenever you upload an image it would save it to the database as an asset. This annoyed me when it first started because of all the extra clutter, but I did like it simply because it'd read the image and put height/width info into the html. But after sixteen years, I had 14000 assets. !! So I deleted them all!! (well, firstly I tested what would happen if you did. I found it would delete the asset and the image itself, but it left the html alone. So all I needed to do was restore the images once I'd deleted the assets, and all would be well).

Then I did a test post.

It published.

In SECONDS.

!!!!

After a bit more testing of posting and commenting I was ready to release the hounds. I republished the entire site. I did it in chunks, but it was all done in under ten minutes. And search results are returned super quickly too now. My blog hasn't been this fast in YEARS!!!

The only real remaining issue now is the foreign characters. I download the mt-entry table (16MB) and did some search/replaces and was able to fix a lot of it. But there's some characters that I just can't publish because it won't talk to the database. There might be a way to fix it. Something about telling perl to talk to MySQL with the right version of utf-8. But I'm too dumb for that sort of thing. Replaced a good chunk of the bad characters. Almost accidentally blatted the .bak table because I forgot to change the table name in the insert into lines (yay for it not importing duplicate entries). Had to redo the whole thing again because I didn't escape ' and " characters. Then republished again. Nine minutes, fifty seconds. I should probably republish all my holiday blogs too.

Sunday 22.9.24.

Spent most of the afternoon blogging entries from the past month.

Monday 23.9.24.

Wrote up this post so far.

I still haven't changed my mail or DNS configs over yet. Or the websites for my subdomains. I'll do that first before I post this.

I haven't decided what I'll do with johnson.id.au or trainman.id.au. I'd actually prefer to keep trainman where it is, because then I'd be able to email David again (currently using my account as an SMTP server, which intercepts mail for trainman.id.au and delivers it to me instead of David).

I also need to figure out how to backup my database properly. I'll have to do some testing of exporting/importing the data on the same version. Otherwise I'm going to need to figure out a better way to backup the blob data in the database. If I hadn't been able to get the Maria DB dump from Vodien I would have been a bit stuck as I wasn't able to properly import my own database backup, which is quite upsetting.

Tuesday 24.9.24.

Started going through and documenting everything in my Vodien cPanel setup. Found a place for mail forwarding, so tried setting trainman.id.au to an external MX record to see what would happen if I sent mail there from my account. It hasn't bounced back to me, so maybe it did deliver to David. This is good to know if I end up moving trainman.id.au to CloudLoop. Also found another backup section which lets you download MySQL databases. This has the same format as what Vodien sent to me. Interestingly the Vodien export is full of trash characters, while the CloudLoop export is fine. This is good news. Dropped my TTLs on mail to 300. Setup my mail accounts on CloudLoop. Tried them out in Eudora. TLS errors to start with, but easily fixed by setting TLS to Required, Alternate Port in Eudora. So changed the DNS for mail.kazza.id.au to point at CloudLoop. So inbound mail all working. Had a look at migrating ciapics over. But it's half a gig. And I only have five on CloudLoop. Considering leaving it there, but I really want to take all of kazza.id.au off Vodien. Next up - SMTP. Got it to auth and send ok, but now to battle with the SPF record. Adding the IP address of my host didn't help. Or adding relay.mailchannels.net. hmm. On a lighter note, cPanel and DNS are actually integrated on CloudLoop which is nice.

Wednesday 25.9.24.

Tested mail again and my SPF record has propagated around so that's nice - can send to gmail now. Although this is all likely to be moot once I switch the nameservers across and use CloudLoops DNS which already has all this stuff. While clearing stuff out of Vodien I discovered that at some point they'd actually fixed the ownership of the db restores. Lolz.

Friday 27.9.24.

Setup johnson.id.au as a domain on CloudLoop.  Copied over the content (there's like, one page).  Then changed the nameservers from Vodien to CloudLoop.  Tested email once DNS propagated.

Saturday 2.11.24.

Been on CloudLoop for like six or seven weeks now. No issues. Today I changed the nameservers for kazza.id.au to point at CloudLoop. Pointed a few A names of my photo subdomains back at Vodien. They have a lot more storage so keeping my photos sites there.

Sunday 3.11.24.

Cleaned out most of kazza.id.au off Vodien, including my blog database. Left an entry in my addressbook database and make sure the scripts were working to access it. So I'll be able to tell when Vodien break it again.

In conclusion.

I knew as soon as Vodien broke my database AGAIN for the second time in three months that I was going to have to finally move my blog. This was reinforced over the next few weeks by being impossible to get anyone who actually cared or had the capability to look at the issue and fix it. No matter how much pleading and yelling I did I just couldn't get anywhere. It made me seriously depressed for weeks. I was also upset that the backups of the database I'd been dutifully taking weren't necessarily going to work properly.

On the flip side, the support and responsiveness of CloudLoop (Karthick) was utterly outstanding. They definitely deserve their five star reviews.

In the end my blog is a lot happier. The holiday sites are consistent in design and everything works properly in HTTPS. The culling of the assets out of the database means my entries publish in seconds. Every new year I'll clear out the previous year's assets to keep it trimmed down.

Let's hope I don't have to write another one of these posts any time soon...

Ten years (and one month) ago today my mother and I went to Queensland for an Outback Spirit tour of Queensland.  

While it was a very well organised tour, it was STOOPIDLY expensive - like a thousand dollars a day for the two of us.  This totally left a bad taste in my mouth for a lot of the trip.

I was going to post this link last month on the ten year anniversary, but Vodien broke my database (again) and it literally took weeks to sort out.  So it's a month late.

It's also funny how much of the trip I'd forgotten.  I was going through and choosing photos and labelling them and there were chunks I didn't remember at all, even when seeing the photos.  Stoopid dementia brain.

Anyway.. here it is!

With food/hotel photos still to come.  And by hotels, I mean like campsites.  Because a thousand dollars a day with Outback Spirit will get you picnic lunches and campsite accommodation.  Hurray.

Back in the early days of blogging there all sorts of widgets you could post on your blog.

My favourite was the Weather Pixie.  I didn't think her clothing choices were all that practical, as she was wearing pretty skimpy outfits when it was quite cold.

Here were some examples that were on my blog.

Because I'm a weirdly obsessive person, for a while I was compiling a spreadsheet showing which outfit she was in for a given combination of temperature and humidity.  I found it recently while filing crap in my in tray.  It was mostly in Sydney but in Canberra for a while as well.

(humidity y axis and temperature x axis)

I miss the Weather Pixie.  Maybe I should learn how to code pngs and read weather apis and make my own...  yeah.. in my copious free time..

Sunday.  15th.  Actually blogging on time for a change.  Overdone roast beef for dinner.

Monday.  16th.  Slept okish I think. More migrations at work. Working on blog after dinner.

Tuesday.  Slept okish. Rinse and repeat really. Mash had Patrick Swayze! Updating holiday blogs with new styles and fixing everything.

Wednesday.  I dunno.  Much the same really.  Work and fixing my blog.

First purple poppy!!!

Thursday.  Rinse and repeat really.   Decent drinks (thought it was going to be just us but another group came up as well).  Watched the first episode of Amazing Race Season ..? 6..? I dunno but it's another "Celebrity Edition" race, with mostly peeps I've never heard of.

Friday.  Woke up at 4am never got back to sleep hurrah. Another busy day.  Fake kievs for dinner (still Inghams, but not the proper sort, Coles didn't have them).  Into season 10 of Mash.  Pretty sure I watched a movie but can't remember what.  Maybe it'll come back to me.

Saturday. Logged onto work to start a big batch of migrations, that will likely take all weekend. Finished fixing up my Australian Holiday blogs. Then it was onto my main blog.  I asked the sweetie if he'd cook dinner.  So we had Dumpling Inn delivered.  Then watched South Solitary.  Been there!  Well, to Cape Otway Lighthouse where they filmed the interiors anyway.

Sunday. Bit of a restless nights' sleep but mostly ok. Did some tidying up on my blog, but have some other things I want to tidy up too. Read through all of John Heald's Smoke on the Water series on the Carnival Splendor fire. Really just procrastinating doing the hard work of blogging the past month.  Notepad in Windoze 11 is trash. I'll be editing a large file, go to another window, come back to notepad, and it dumps me right at the bottom of the file, not where i had the cursor.  Stoopid.  Then most of the afternoon after food shopping doing catchup blogging.  Including having to redo last week's because I accidentally hit control-v instead of control-c while it was publishing.  Watched Wonka (2023).  It had hints of music from the 70s movie.  With Rowan Atkinson (one scene) and Hugh Grant (haven't seen him yet).  Slugworth, Fickelgruber and Prodnose.  Sounds like something out of Fantastic Mr Fox.  Anyone would think it was by the same author or something heh.  OMFG Hugh Grant as the Oompa Loompa.  And he sings a variant of the song!! hahahaha.  That'll do for now.