Internet Services from KKoncepts

Recent our CentOS vservers have refused to upgrade the "filesystem" rpm. It gives the error:unpacking of archive failed on file /proc: cpio: chown

Fortunately the fix is easy once you know it. Edit the file "/etc/rpm/macros" inside the guest and add "/proc" to the "%_netsharedpath" line. (Separate entries by a colon.)

So if the line presently says:

%_netsharedpath  /dev:/etc/rc.d/init.d/halt
Change it to say:

%_netsharedpath    /dev:/etc/rc.d/init.d/halt:/proc

Recently I wrote my own start/stop script for our vservers. The "util-vserver" package gives you a little control over the order that the servers are stopped and started, but I wanted to specify the exact order that virtual machines started and stopped in the event of a heartbeat takeover.

Being a perl "fan boy" from way back, I have a lot of small perl scripts lying around that I use to look through logs for something specific. We use Cacti and Nagios for "real" monitoring, but I've got scripts to see which email accounts have failed authentication attempts, who's logged into certain services in the past X days, how many connections our email server has rejected based on blacklisting, etc., etc.

I use VirtualBox when I need to run Windows, and it works beautifully. But today I went to install some Windows software off a CD and discovered that I could no longer connect the CD drive on my laptop to VirtualBox.

I've wanted for some time to create my own custom installer for the Windows OpenVPN client. Up until now we've told clients to download the software and then given them the certificates and configuration files they needed along with instructions on how to install them. But some people still end up unable to use the VPN, which means more support calls for us.

Couriersite is a web program we've written which is designed to allow relatively easy administration of Courier email servers. It is also designed to allow others to administer different parts of the email system, thereby making less work for the overworked and under paid email administrator! To that end, it provides four programs:

All of our systems are 64-bit, but today I needed to compile a simple executable for a 32-bit system. Fortunately gcc makes that easy; just add the "-m32" switch to the command line. Unfortunately, it didn't work!

This morning I began my working day, as usual, by firing up my trusty Dell laptop. I then deviated from my normal routine and promptly sneezed all over the keyboard. I do not recommend this. While I can find no mention of this in the "how NOT to care for your Dell product" section of my "User's Guide", there certainly should be. It makes a HUGE mess which requires a fair bit of time to clean up.

Like most all SQL servers, mysql supports the "LIKE" operator, which allows you to do simple wildcard matches using the percent sign (%) as the wildcard.SHOW TABLES LIKE "%user%";shows you all your tables (in the working database) which have "user" in their name.

Unfortunately this operator doesn't work with the DROP syntax. You can't sayDROP TABLE LIKE "%users%";and drop all the tables with "user" in their name. You have to list them each individually.

I recent used gtk-recordmydesktop to record a short video to explain to one of our clients how to do something complicated in the Drupal CMS. ("A picture's worth a 1000 words...", and all that.)

Unfortunately when I viewed it, I saw that the video and audio were out of sync. About 4 seconds - just enough to be really annoying and make it impossible to follow along.