Slaptijack Title

Archive for the ‘System Administration’ Category

OS X CLI: Install VirtualBox

I decided the other night to begin doing some testing using my headless Mac Mini. I use VirtualBox for all my testing on my Mac OS X systems. Since the Mini is headless, I decided now was as a good a time as any to start using VirtualBox via the command line. Obviously, installing VirtualBox via the command line is not the same as running VirtualBox via the command line, but installing any package from the command line must be practiced to be remembered.

Categories: System Administration

Restart Brother ControlCenter

On your Mac, the Brother ControlCenter software that let's you scan an image from your Brother MFC to your computer is started at boot by launchd. Therefore, it can be restarted from the command line. For example, here is a list of processes controlled by launchd: $ launchctl list | grep brother 286 - [0x0-0x17017].com.brother.ControlCenter [...]

Categories: System Administration

Stuck at "copying to tmp table"

I have a fairly lightly loaded MySQL server with a few tables that are updated every five minutes. Other than these updates, there are very few queries run against the database. The data is queried just a few times per month. Ever so often, one of the more complicated queries will result in the process getting hung in the "copying to tmp table" state. To be honest, the queries that get hung aren't even that complicated. Usually there's one or two joins, a GROUP BY, and an ORDER BY.

Categories: System Administration

Apache Can't Use Remote MySQL Server When SELinux is Enabled

I don't know why SELinux problems seem so frustrating. The problem almost certainly is related to the fact that there is frequently no error message. This is exactly the problem I ran into while turning up a new Apache web server on Red Hat Enterprise Linux 6 (RHEL6) with SELinux enabled.

Categories: System Administration

Random Oracle FRA Usage Notes

While researching a problem with our Oracle Fast Recovery Area (FRA), I took note of the more useful commands I used. This is from Oracle 11g R2 with the Real Application Clusters (RAC) and Automatic Storage Management (ASM) options. SQL*Plus Show how much of the FRA is in use by different file types: SQL> SELECT [...]

Categories: System Administration