VNC to the rescue
Had a little problem – needed to download some rather large files which would have blown my data allowance, and the clock was ticking, so thought it a good idea to download them to my webhost. Slight problem, though, I needed a browser so I could access the files from links sent to my email (files from Google Takeout so WGET/CURL didn’t seem like an option – I tried WGET to no avail) Here’s how I achieved it: 1) Installed Openbox and X server components to my host (Ubuntu based)
|
1 |
sudo apt-get install xorg openbox |
Then I needed
|
1 2 |
sudo apt-get update sudo apt-get update --fix-missing |
2) Tried to start x…
Monday WordPress Woes
I picked the wrong day to give up sniffing glue! Been building a new WordPress site and I was trying to migrate it to a new domain when something went very wrong. I had a backup before you ask, but when I tried to restore it, things went tits up Here are the results of the MySQL CLI alchemy: (edited to just show errors)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
mysql> source /var/www/html/.../updraft/wp.db ERROR 1366 (HY000): Incorrect string value: '\xF0\x9F\x8E\x89</...' for column 'option_value' at row 125 ERROR 1067 (42000): Invalid default value for 'user_registered' ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_users' doesn't exist ERROR 1067 (42000): Invalid default value for 'comment_date' ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_comments' doesn't exist ERROR 1067 (42000): Invalid default value for 'link_updated' ERROR 1067 (42000): Invalid default value for 'post_date' ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_posts' doesn't exist mysql> |
It’s not as bad as it looks; there are two errors basically • Attempted insert of string with 4-byte value fails • Invalid default value. This turns out to be a date value of '0000-00-00 00:00:00'…
YAML – Watch those indents
The H2O webserver configuration file (h2o.conf) is YAML animal. As I learned the hard way, spaces used to indent in YAML are super important. Notes re YAML syntax: as it pertains to h2o.conf: https://h2o.examp1e.net/configure/syntax_and_structure.html#yaml_alias How to validate your YAML: http://www.yamllint.com/
Pizza Legend vs El Supremo
Not familiar with the game? It’s fun but once you learn the key strategy (attempt to roll as many sixes as you can) there’s not much room for creativity. It then just comes down to luck. You do, however, need a good playing name 🙂 Yahtzee has been cited as a precipitating factor in a case of domestic violence and as the motive for at least one murder. I pipped him at the post, it all came down to the last game where he dropped his topping only scoring 53 in the top half. A nice way to spend the…
Sunday stroll to the market
It’s always the little things. Went to the local supermarket this morning to pick up some supplies and scored a tonne of bargains. Discount stickers everywhere I tell you. In the basket Pork Chicken Bologne Pasta Sesame seeds Lettuce Tomato (x2) Kale (x4) Okra Carrot Broccoli Bean sprouts Ginger Limes and a can of coke All for the princely sum of THB 445 ~ USD 13.50 Max Valu indeed! Amazing Thailand
Reminiscing with Retropie
Showing my age now. Time to work on building up my 2nd Rasberry Pi. This time I’m going to install Retropie and see if I can get one of my old games up and running. • Step 1 – Download Retropie
|
1 |
-rw-r--r-- 1 root root 641640647 Nov 17 22:44 retropie-4.3-rpi2_rpi3.img.gz |
It’s 612MB so will take a while. Enjoy a nice cup of tea while you wait and read the installation guide. Don’t attempt to download a file this large via HTTP. Timed out for me, so I used FTP instead. Downloaded via my webhost using wget, copied into my FTP home directory then used FileZilla to download from…