Articles in the system_administration category

1. vCloud Director Install - ORA-00972 Error During Oracle Setup

   Posted on June 14, 2012 in System Administration

   If you are unfamiliar with Oracle and setting up your vCloud Director Oracle database, don't make the same mistake I made:

   SQL> CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf" SIZE 1000M AUTOEXTEND ON ;
   CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf …

2. Sendmail: Remove Queued Messages

   Posted on January 04, 2012 in system_administration

   for id in \`find . -mtime +10 -name qf\\\* \| sed 's/\^....//'\`; do
       mv qf\${id} /var/tmp/scott-20120104/ ;
       mv df\${id} /var/tmp/scott-20120104/ ;
   done
   

3. DRBD Tuning Notes

   Posted on November 29, 2011 in System Administration

   I ran across these notes I took while tuning DRBD on a pair of NFS servers.

   [root@smtp10 ~]# bonnie++ -s0 -r 1000 -u 666 -d /mailstore/benchmark/
   Using uid:666, gid:666.
   Create files in sequential order...done.
   Stat files in sequential order...done.
   Delete files in sequential order...done …

4. Lion + Cisco VPN DNS Workaround

   Posted on November 07, 2011 in System Administration

   When I upgraded to OS X 10.7 (Lion), I started using the built-in IPSec VPN client rather than Cisco's VPNClient. I experienced problems immediately. At first it appeared that the connection was being made, but no traffic was passing. When I tried pinging by IP address, I found that …

5. Mac OS X terminal and GNU screen scrollback

   Posted on October 11, 2011 in system_administration

   If you're a frequent user of GNU screen on your Mac, you are probably tired of using ctrl-a [ to enter scrollback mode. Adding the following lines to the .screenrc configuration file in your home directory in order to scroll with your mouse:

   defscrollback 5000
   termcapinfo xterm* ti@:te@
   

6. Killing Old popper Processes in Solaris 8

   Posted on September 19, 2011 in System Administration

   I've dealt with a few servers that have long lived popper (POP3) processes. These processes should be closed once the connection is closed, but they occasionally hang around. Once they get in this state, they will never close on their own. After a while, hundreds of these processes will just …

7. Sendmail Mail-to-Program Failures: Check smrsh

   Posted on September 05, 2011 in System Administration

   One of the beauties of using a Linux-based Mail Transport Agent (MTA) like Sendmail is the ability to pipe mail into programs. You can use this in conjunction with a filtering application like procmail, with a custom application that collects data about the email, or anything else you can imagine …

8. Cisco IronPort Default Username and Password

   Posted on August 26, 2011 in System Administration

   Why is it always a pain to find this stuff in the documentation?

   Username: admin
   Password: ironport
   

9. SNMP Traps into MySQL is Sublime

   Posted on August 22, 2011 in System Administration

   I use snmptrapd to catch SNMP traps and then put them into a MySQL database using a pretty generic trap handler. This gives me the opportunity to generate such useful information as:

   > SELECT HOUR(time) AS "hour", COUNT(*) AS "bounces" FROM snmptraps
       WHERE hostname = 'XXX' AND time > '2011-07-25'
           AND trap_oid …

10. How to Enable RPMforge-Extras

    Posted on July 25, 2011 in System Administration

    Historically, the RPMforge repository has aimed to create add-on RPMs for RHEL, CentOS, and Scientific Linux. Although their goal was not to replace base packages, avoiding that has not always been possible. In mid-November 2010, RPMforge created the rpmforge-extras and moved all packages that replaced base packages into the repository …