Jordan If you’ve started using MySQL 8, you’ll notice your usually commands for creating a user no longer function. That’s because it’s changed in MySQL 8, you need to now create a user, then grant privileges. Let’s create a user The critical part here is the “mysql_native_password” if you don’t have this portion, you’ll get errors … Read more
This is pretty straightforward, you’ll see this error when updating or installing a plugin. [enlighter linenumbers=”true”]The package could not be installed. PCLZIP_ERR_BAD_FORMAT[/enlighter] Basically the file WordPress is trying to download is either corrupt or you don’t have the PHP curl module installed. So simply install it, for Ubuntu this is: [enlighter linenumbers=”true”]apt-get install php-curl[/enlighter] or … Read more
From time to time, you’ll need to look at data within MySQL dump files, specifically I do it mostly with WordPress. There isn’t an easy way to search the dump unless you use grep. Here are some useful grep commands. Pull out a table. [enlighter linenumbers=”true”] grep ‘INSERT INTO `wp_bspr_users`’ dump.sql > /tmp/users.sql [/enlighter] Format … Read more
So I bought a 3 pack of the WeMo Smart Plugs in the hopes of yelling “Alex turn Bedroom Light Off” before bedtime. Instead of buying a Clapper, of which I’ve never seen in real life. Which was probably a better idea seeing as the WeMo Smart Plugs are notorious for disconnecting from Wifi or … Read more
If you have the Booster for WooCommerce plugin enabled and have used their order items table, specifically “[wcj_order_items_table]” You might see item meta that should be hidden. I’ve created a GitHub Gist that you can place into wp-content/plugins
Current Setup I had a request from a client to purchase dual monitors for their Macbook Pro Late 2013 (or Macbook11,1). I also wanted to sort out my own setup Macbook Pro 2016 (Macbook13,2). Currently I’m using the following, an Apple USB-C Digital AV Multiport Adapter and a generic ArkTek branded adapter. Both come with … Read more
If you login to the OVH control panel and notice that the monitoring is showing Red instead of Green, this is due to their monitoring servers not being able to connect to your VPS. You simply need to add their IP’s for monitoring that they provide in the control panel to your Windows 2012 VPS … Read more
If you’ve tried to change the hostname on your OVH public cloud instance running CentOS 7, you may have had issues with it persisting after reboot. Took me way to long to find this solution, but someone had already spent way too much time figuring it out. This GitHub Gist explains it all https://gist.github.com/zmjwong/77ee37deb1749c2582eb Basically you … Read more
An update to CrashPlan was rolled out at version 4.8 but no download files were available on their site for Windows. So if you’ve been trying to manage your Linux headless install and its failing, this might be why. Here’s the release notes. https://support.code42.com/Release_Notes/Code42_Platform/Code42_Public_Cloud_Version_5.4 I don’t know how to kick off updates to CrashPlan on … Read more
We had a 32bit Ubuntu server that was getting pegged due to the lack of memory it was able to use when observium was kicking off it’s cron. So I decided to move Observium to a 64bit Ubuntu server. Unfortunately when trying to run the poller, the following error appeared. ERROR: This RRD was created on … Read more