tech

The sun sets on Shashin

The sun sets on Shashin

It appears the popular Shashin WordPress plugin is no more. Although its developer Mike Toppa stopped supporting the plugin a number of years ago, it has now been pulled from the WP plugin repository and usage documentation seems to have disappeared. No surprise really, as Google has been slowly but surely killing the integration with Picasa after launching Google Photos (Google acquired Picasa in 2004). I’ve blogged about Picasa pain before. http://www.craigamos.rocks/picasa-pain-persisits/ http://www.craigamos.rocks/google-photos/ Additionally, the Picasa desktop application no longer works. Where does that leave the existing user base? The plugin still works for existing Google albums, at least. You…

Tuning fpm-php: Not for the faint of heart

Tuning fpm-php: Not for the faint of heart

Another tech Sunday – they never get old 🙂 This is a somewhat long and boring post. More of a tech journal entry. But who knows, maybe someone else will find it interesting. First let’s backtrack a little – what is CGI you ask? source: https://www.irt.org/articles/js184/ An acronym for Common Gateway Interface, CGI was the first implementation of a server-side ‘gateway’ where http could interact with external applications such as databases. Although CGI is language agnostic, typically PERL scripts were used. CGI is rarely used today due to inherent security vulnerabilities. Then there’s fastcgi And then there’s php-fpm (FastCGI process…

Sunday’s are for schemacrawling

Sunday’s are for schemacrawling

I love looking at database schema diagrams – and last Sunday I came across Schemacrawler. Getting it up and running all went pretty smoothly. I downloaded the zip file from here You also need to install GrahpViz. References: http://www.schemacrawler.com/diagramming.html Output your database schema To output a pdf of the schema:

To output a png of the schema:

A rainy saturday spent with SQLite

A rainy saturday spent with SQLite

I’d been meaning to get my mits on SQLite for some time and finally found a good project to do so. Installing SQLite I’m on ubuntu so the following got things sorted for me:

I then noticed I was getting the following 

I needed to install the following as per this post and restart my web server

Check SQLite is installed

Finally, some working php code While I won’t share my production code with you, here’s what I can share References: https://www.tutorialspoint.com/sqlite/sqlite_php.htm https://www.digitalocean.com/community/tutorials/how-and-when-to-use-sqlite As per the tutorial above, I created the WINES table and populated it:…

VNC to the rescue

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)

Then I needed

2) Tried to start x…

Monday WordPress Woes

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)

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'

Reminiscing with Retropie

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

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…

Pimping out the Pi

Pimping out the Pi

Thought I should keep track of the apps I’m installing on my Rasberry Pi. • Dolphin (file manager) • vim (editor) • PHP 7.0 • nginx (web server ; removed apache2) • pinta (graphics) • VLC media player • ufw (uncomplicated firewall) • x11-apps (xclock, xcalc, etc) Update nodejs curl -sL https://deb.nodesource.com/setup_7.x | sudo -E bash – sudo apt-get install -y nodejs Networking Plugged in the ethernet cable and it just worked! Nice one. However we no longer have eth0? It’s now exnb827eb071dfd and it isn’t configured via /etc/network/interfaces Explanation found here: Predictable Network Interface Names are not new, but…

Joining the Rasberry Pi revolution

Joining the Rasberry Pi revolution

I picked up a few Rasberry Pis from Amazon.com and I’m glad I waited a while so I could get the Pi 3, which seems to be a step up from its predecessor in terms of performance. Amazon.com now delivers to Thailand and includes taxes in the shipping so there’s no more to pay. This is a huge step forward as previously dubious import charges were levied by the courier. Thankfully a thing of the past I can now browse Amazon with confidence. As a bonus, it only took 3-4 days to arrive at my doorstep. Yeah! My total was…

Emmet & Notepad++ on Ubuntu

Emmet & Notepad++ on Ubuntu

Had a wander around the web in the wee hours of this morning and came across Emmet which I thought looked interesting so I downloaded npp to get it going. I’ve been hand-coding my HTML for 18 months now which has been a great learning experience. It’s getting a little tiresome now and I need some help 🙂 Opened and installed with Wine and guess what? It just worked! Amazing. Next I had to get the plugin manager going which is no longer bundled with npp. Grab it here Note the C:/Program Files folder is under the (hidden) .wine folder…

1 of 5
12345