Convert IONOS MySQL 5.5 Database to MySQL 5.7

Using the instructions provided by IONOS to upgrade your MySQL database from 5.5 to 5.7 did not work for me. Unfortunately, once I got to the step to import the old database into the new, I got a 1044 – Access Denied error. IONOS recommends deleting all statements that begin with CREATE or USE in the exported database prior to attempting to import. This is not helpful as then your tables will not be recreated in the new database. The fix is to search for all occurrences of your database name (db402946823 in my case) in the exported database file and replace with the new database name. After that, the import went off without a hitch.

If you are using the database for WordPress, don’t forget to update the settings in wp-config.php to match the new database so that it doesn’t continue using the old. IONOS makes this simple with the Webspace tool.

Basic Linux Screen Usage

Have you ever faced the situation where you perform a long-running task on a remote machine and suddenly your connection drops, the SSH session is terminated and your work is lost. Well, it has happened to all of us at some point, hasn’t it? Luckily, there is a utility called screen that allows us to resume the sessions.

Screen or GNU Screen is a terminal multiplexer. In other words, it means that you can start a screen session and then open any number of windows (virtual terminals) inside that session. Processes running in Screen will continue to run when their window is not visible even if you get disconnected.

Below are the most basic steps for getting started with screen:

1. At the command prompt, type screen.
2. Run the desired program.
3. Use the key sequence Ctrl-a + d to detach from the screen session.
4. Reattach to the screen session by typing screen -r.

FreeNAS 11.1-U6 CIFS Problems

If like me you upgraded FreeNAS to 11.1-U6, then you’ve likely run into issues due to SMB1 being disabled. See below link for the particulars:

FreeNAS 11.1-U6 Release Notes

Changes in SMB for 11.1U5 to 11.1U6?

Mounting cifs: “Operation not supported”

Linux Mint 19 Grub Error During Install Fix

Getting an error that Grub2 cannot install to the target at the end of the install?
No problem, pretty simple fix:

  • Download Super Grub2 Disk and reboot the new Linux Mint 19 install using it
  • Run “sudo update-grub” in terminal and reboot

That’s it!

LEDE Project on WRT3200ACM

After pulling my hair out trying to get an OpenVPN server working on stock Linksys firmware I finally made the plunge and installed the latest LEDE firmware on this router and couldn’t be happier. I also considered DD-WRT but that project seems to have stagnated (no update for WRT3200ACM firmware for over a year). Stay tuned for how to do it and what to expect.

Stop the Windows 10 Upgrade with Never10

Tired of being nagged by Microsoft to upgrade to Windows 10? Stop the insanity with the nice little utility Never 10 from the good folks at Gibson Research Corporation. According to the site:

Never10 does NOT prevent the installation of Windows updates, including
the infamous Get Windows 10 (GWX) update KB3035583.  Never10 simply
employs Microsoft’s documented and sanctioned configuration settings to
instruct it NOT to change the installed version of Windows.

So if you’re wanting perhaps the easiest way to stop the insanity head on over to GRC and grab this 83k beauty and forget about it.

Enable Auto Login in CrunchBang++

Now that a suitable replacement for CrunchBang has come along, you can use my previous guide here for optimizing the lightweight CrunchBang++ Linux operating system as a guest virtual machine. One difference you will find is how to enable auto-login now that the core Debian base has changed in Jessie. The easy method of using a GUI is no longer available, but fret not as the changes required are minor. Simply perform the following steps to enable the auto-login functionality.

Open a terminal window and run the following command to edit the proper config file:

$ sudo geany /etc/slim.conf

On line 37 delete the part of the login command after exec and up to the ampersand so the line now looks like this:

login_cmd          exec /bin/bash -login /etc/X11/Xsession %session

Uncomment line 70 and change simone to your username:

default_user       nodakbarnes

Uncomment line 78 and change to yes to enable auto-login:

auto_login          yes

That’s it! Now save the file and reboot and enjoy not having to login in every time to your VM.

Approaches to Computing

There are three approaches to computing:

Commercial-ubiquitous approach: This is Microsoft’s approach. Try to support (or to get manufacturers to support) as much hardware as possible.  Be the default solution. Things generally look good (I can’t fault Microsoft over their years for most of their UI decisions), stability may not always be terribly good though, and that’s the sacrifice, ubiquity over stability, but the gain is to run on just about all hardware in existence. Android is also mostly falling into this category too now.

Commercial-restricted approach: Sell your hardware and your software, and only allow a select-few others to sell hardware or software that is compatible with your products. The upside is that the platforms are highly stable, but the downsides are that users will sometimes find they simply can’t do something because it’s disallowed. It also requires the company to be ever-vigilant about pushing more features and capabilities, as stagnation will mean death. Apple currently leads this community, but SGI, Sun, NeXT, Commodore, and a whole bunch of computer companies throughout the years have tried it and ultimately closed up shop.

Open-Source approach: Both leading edge (ie, research projects by major universities) and completely behind (many user applications simply don’t exist or are only partially functional).

I use Windows, OSX, and Linux daily as desktop environments. Linux is stable and fast, but often not compatible with developments out of Redmond and with a lot of work to make some features function. OSX is very smooth, very stable, and awkwardly locked-down to where some things simply aren’t options. Windows is compatible with just about everything and requires weekly reboots to keep it running.

They all suck. All of them.

Original post courtesy of TWX on Slashdot

Recovering from a Botched CrunchBang Upgrade

I recently botched an upgrade of the kernel in my CrunchBang VM and it broke the X window system leaving me staring at a black screen after boot. Thankfully it wasn’t terribly difficult to fix. See below for the steps to take to re-apply the upgrades and make the system bootable once again.

When initially booting, CrunchBang shows a Grub menu with the kernel to boot and another option with the same kernel in recovery mode. Choose this second kernel option to log in as root and then run these commands in single-user mode.

First we need to get the network interface up:

# ip link set eth0 up

Next we need to get an IP address using DHCP:

# dhclient eth0

Let’s see how the interface looks now:

# ifconfig eth0

And now we can run the update process again:

# apt-get update
# apt-get dist-upgrade

Reboot and it should all just work now:

# shutdown -r now

This is not a cure-all for all booting problems, but for a botched kernel upgrade this did the trick for me!

Optimizing CrunchBang Linux for VirtualBox

CrunchBang is an excellent version of Linux to run in VirtualBox due to the fact that it’s a nimble Openbox Linux distribution. That being said, the OS still requires tweaking after install in a VM to get the most performance and satisfaction out of it. I’ve put together a guide to walk one through the installation and optimization settings. So take this opportunity to grab the requisite softwares:

And then click here to see how it’s done.