Tech for me...and you too...I guess
Chrooted SFTP, Inotify & Chattr – A Fortified Prison for Backups
In my last post, I touched on ways you could automate remote database backups using SSH and passphrase-less keys. I didn’t really go in-depth as I felt this topic deserved its own article and wouldn’t you know it, here it is!
Now, as you can tell by the title, we’re going to be focusing on using SFTP as our transfer protocol of choice instead of SSH or SCPas I’ve found its a lot easier to sec ...
Automating MariaDB Backups…As Securely as Possible
Right off the bat, I’ll tell you that there is no completely secure way to automate your MariaDB backups. I researched this for awhile and haven’t found one yet. That isn’t to say there aren’t ways to mitigate your risk, but as some point you’re going to need to store your password somewhere. If you are unwilling to invite any risk to your databases, your best options are to automate entire ba ...
Please Encrypt Your Databases (MariaDB)
Security is often one of the last things IT professionals think about when starting a project. Most of the time tight deadlines and an overworked staff lead to a less than perfect implementation. Security, along with other important things…looking at you Documentation…get pushed to the back burner and sometimes forgotten about altogether. One safeguard that is seldom implemented is database ...
Automatic Webmail Notifications in Linux
I use webmail for all of my email accounts as I find it much more convenient than setting up a local mail client like Thunderbird. For what seems like forever, I had been using a Firefox Add-On called X-notifierto alert me when I receive new mail. It was a cool little utility that allowed Firefox to regularly notify me of new mail from my various email accounts. User submitted scripts provide ...
Migrating From MySQL 5.7 to MariaDB 10.2 on Ubuntu 16.04
For those unfamiliar with MariaDB, it’s a fork of MySQL that is dedicated to remaining free to use. It was created the day Oracle bought out Sun Microsystems in 2010 who had previously acquired MySQL in 2008. MariaDB was built by the very developers who worked on MySQL and for most users the transition to MariaDB should be fairly painless. All of the clients and tools that work with MySQL wor ...
: 
: