Get the IP address of your VirtualBox guest VM

Make sure you have VirtualBox's Guest Additions installed on the VM and then simply run the following command from your host:

VBoxManage guestproperty get 'CentOS 6' '/VirtualBox/GuestInfo/Net/0/V4/IP'

Subversion log by user name

Ever wanted to know how to get a subversion log by user name? Here's how to do it...

Burning a CD from the command line

Find your CD drive

cdrecord --devices

Burn your CD

cdrecord -v --dev='/dev/sg1' ~/Downloads/ubuntu-12.04-beta1-alternate-amd64.iso

How to split a large file into several smaller files

Many thumb drives are formatted with FAT32, making the maximum file size just shy 4GB. If you need to copy a large file like this to a thumb drive, follow the instructions below.

Get wireless working on a Dell Inspiron 8500 in Ubuntu

First, you should check to be sure that you have the same wireless card (BCM4306 rev 02) that I do using the lspci command:

maryjo@lubuntu-mjh:~$ lspci -vvnn | fgrep 14e4
02:00.0 Ethernet controller [0200]: Broadcom Corporation BCM4401 100Base-T [14e4:4401] (rev 01)
02:03.0 Network controller [0280]: Broadcom Corporation BCM4306 802.11b/g Wireless LAN Controller [14e4:4320] (rev 02)

If everything matches, you should be able to follow the steps below to get wireless working on your laptop.

Find the top 5 largest MySQL tables on your server

SELECT
  CONCAT(table_schema, '.', table_name) AS tableName,
  CONCAT(ROUND(table_rows / 1000, 2), ' Thousand') AS numberOfRows,
  CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ' MB') AS dataSize,
  CONCAT(ROUND(index_length / ( 1024 * 1024 ), 2), ' MB') AS indexSize,
  CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 ), 2), ' MB') AS totalSize,
  ROUND(index_length / data_length, 2) AS indexFraction
FROM information_schema.TABLES
ORDER  BY data_length + index_length DESC
LIMIT  5;

Adding an admin user to WordPress from the Command Line

Ever wanted to know how to add a WordPress administrator from the command line? Here's how to do it...

Finding version numbers for multiple websites

As a Systems Administrator, I often need to find out which version multiple websites are on. With Linux, this often can be achieved with a surprisingly quick one-liner:

Colorado School of Mines Fight Song

Colorado School of Mines LogoEarlier this week, a couple of co-workers and I somehow got onto the topic of school songs.

I still had a copy of a small portion of the song from the 'mines.pl' t-shirt that was popular with computer science majors; however, I wanted to find the rest of the song. It took a little digging, but I was eventually able to find a cached copy of the song from the old CSM Alumni site. I thought I would post a copy online to make it easier for anyone else who may be looking for a copy.

Bash Hack - Testing to see if a variable is an integer

Bash unfortunately does not include a built-in function to test if a variable is an integer. There is however a simple pattern matching hack that you can use to test this on your own:

Check for Unsigned Integer

[[ $number =~ ^[0-9]+$ ]] && echo -e "match found : integer\n"

Check for Signed Integer

[[ $number =~ ^[+-]?[0-9]+$ ]] && echo -e "match found : (signed) integer\n"

Pages

Subscribe to TechNickal Solutions, LLC. RSS