Author Archives: Randy

Etherchannel 802.1q trunk between Cisco and Foundry

Foundry and Cisco both implement port grouping (load sharing) but are very different.  The following code snippets describe the configuration needed between the two very different platforms to create a working Etherchannel trunk. On the Cisco, ports 23 and 24 form the group for port-channel1: port-channel load-balance src-dst-ip interface Port-channel1 switchport trunk encapsulation dot1q switchport […]

Alternate Row Shading in Excel

One way to make your data legible is to apply cell shading to every other row in a range. Excel’s Conditional Formatting feature (available in Excel or later) makes this a simple task. Select the range that you want to format Choose Format, Conditional Formatting In the Conditional Formatting dialog box, select Formula Is from […]

Categories: Windows. Comments Off on Alternate Row Shading in Excel

Cpanel – Globally disabling the Email Catch-All feature

Spammers love nothing more than launching dictionary attacks on unsuspecting domains using the ‘catch-all’ feature.  This causes multiple problems — the main issues are excessive server load, disk usage, and spam volume.  The worse issue is that once spammers catch on to the fact your domain has a catch-all, they will launch spam campaigns with […]

Categories: Linux. Comments Off on Cpanel – Globally disabling the Email Catch-All feature

Cpanel / SuPHP Part 2 – Fix Ownership Issues

In addition to the correct chmod of files and folders (see part 1), you must ensure that all public_html files and folders have the correct (user and group) ownership.  The following Perl code will eliminate nobody/root ownership.  Place the Perl script into your /home directory and execute it. #!/usr/bin/perl -w my @dirs = grep -d,<*>; […]

MySQL: How To Repair & Optimize All Tables in All Databases

The following command can be used to repair and optimize all tables in a MySQL database.  This can be useful on a busy server with many tables after a hard reboot or otherwise unclean shutdown. mysqlcheck -u root -p –auto-repair –optimize –all-databases