This blog was great and ultimately gave me enough info to get this done, however, it wasn’t for a rookie in MYSQL since the whole part about ‘deleting rows’ assumes you know how to delete a row. It looks like I also wrote a cpanel version of the same need a few years back. Also I elected to turn off…
How to move Decred from Decredition to Canadian Fiat Bank Account
I was quite happy to learn I had some decred. I recall when I first received it that it was very nice, ahead of its time, and well thought out crypto. The problem was I didn’t know how to trade in crypto, let alone trade in a less-than-top-3 cryptos. Without further adoo, here is what I did and I hope…
How to make a Virtual Machine (VM) Visible on the LAN with Virtualbox and Ubuntu
Why this post? Some new owners took over a company. The previous owner had delivered a crm system to the new owners which ‘ran on a server upstairs’. The buyers asked for all admin passwords to the server which the Sellers provided. However, these were just user passwords and not actual root passwords or system passwords to the actual box.…
How to move Thunderbird emails from one Ubuntu Machine to Another
I thought I had blogged this years ago but apparently I haven’t. It should be part of a backup procedure regardless, but sometimes you just might want to move all your email accounts from one Ubuntu machine to another like I want to today. Heres how you do it. Note: this tutorial assumes that you are putting the .thunderbird directory…
How to Setup FTP to Specific Ubuntu Server Directory
First, I want to give full credits to this blog because this is the brains behind this tutorial. However, because I’m not as smart as the author, I got stuck a few times so this blog is a ‘dumbed down’ version of the same tutorial but with my notes added for the ‘less smart’ 🙂 Please note that if you…
Changing or Fixing the Site URL for SuiteCRM
Recently I moved my SuiteCRM from a slow shared host over to a Digital Ocean droplet to speed things up. It worked very well, by the way. So fast, and probably I save 10 minutes per day just not waiting for server, haha. Anyways, everything went pretty well except one thing: the emails that were sent out from the Workflow…
How to Install Older PHP and Server Software with Digital Ocean
Why? Someone asked me to set up some old proprietary server software stuff that would no longer work in a modern server environment. I figured it might be possible if we match the mysql and php versions and give it a shot. Here is my documented journey in case anyone else needs to / wants to do something similar. Set…
How to Backup your Akaunting Installation
If you are like me, you were attracted to Akaunting accounting software because they are one of the first nice looking and open source accounting softwares around that operate in a similar way to the ‘friendly’ GUI systems like Quickbooks online. I was so upset about not having control of the data and / or price plans that I decided…
How to Convert Image to editable text with Tesseract OCR on Ubuntu
First, watch this video for the full meal deal. However, for a quick and dirty summary of how to quickly convert a pretty bad image / photo (or pretty good one) into a .txt file, here we go: 1. Install Tesseract sudo apt install tesseract-ocr 2. Convert the image (ie. .jpg, pdf, etc) into a .tiff file with Imagemagik to…
How to Overcome a Prestashop 500 Error on Front End
The Background I upgraded my ubuntu server last week and after I did so, the Prestashop front end went down – but not the back end! Everything seemed fine because no one was checking the front end so after someone changed something in the back and refreshed the front they thought they had killed the site (and so did I!).…