Trying to install Bugzilla-4.0.10 with Perl 5.18.x you might have a problem with DBI Version

Something like this may show up:

Checking for                  DBI (v1.614)    found v1.63 

Even though you have DBI-1.630 installed..

So you'll have to force it to use a version that it's not going to strip the last zero off of.

perl install-module.pl --shell
TIMB/DBI-1.628.tar.gz
exit

And voila!

Checking for                  DBI (v1.614)    ok: found v1.628 

Zimbra: How to shut off automatic backups

Here's how to remove the autobackup schedule from zimbra.
In my case I had done a trial backup/restore onto an older laptop and the disk was fairly small, thus backups filled up the disks and kept sending me messages.

First su to the zimbra user

su - zimbra

The it's probably a good idea to see what the current schedule is and save it in case you want to restore it later.

zmschedulebackup -q
f 0 1 * * 6 -a all --mail-report
i 0 1 * * 0-5 --mail-report
d 1m 0 0 * * * --mail-report

Lastly use the -F (Flush) flag to delete the current schedule.

zmschedulebackup -F 

Congratulations! You now have 0 scheduled backups..I hope that's what you really wanted.

Gridengine: How to add globally consumable resource

To setup a globally consumable resource use the following commands:

qconf -mc and add a line like:

#name               shortcut   type        relop requestable consumable default  urgency
#----------------------------------------------------------------------------------------
arch                a          RESTRING    ==    YES         NO         NONE     0

qconf -me global

Add your resource to the complex values:
hostname              global
load_scaling          NONE
complex_values        my_complex_value=18
user_lists            NONE
xuser_lists           NONE
projects              NONE
xprojects             NONE
usage_scaling         NONE
report_variables      NONE

Then you can request by adding:
qsub -l my_complex_value=1

How to adjust the number of slots per host in gridengine

qconf -mq all.q  (if you're using the default queue)
Then you should see a line similar to:

slots                 1,[host1.abc.com=8],[host2.abc.com=12], \

                      [host3.abc.com=12]

Change the =## on a per host basis and then exit and save your editor.

Convert SQL TIME field to plain seconds

Here's something I do occasionally and always have to go search the interwebs for.
So let me write it somewhere I (and hopefully others) can find it easily.

select TIME_TO_SEC(FIELD_NAME) as MY_ALIAS_FIELD_NAME from TABLE...;

How to configure gridengine with a consumable resource to reserve memory for a submitted job

This is fairly simple to do:
1) Modify the resource mem_free to be a consumable resource for the cluster
2) Then from an admin host run:

qhost | awk 'NR>3 {
       print "qconf -mattr exechost complex_values mem_free=" $8,$1
}'  | sh

Click here for a more detailed discussion.

How to merge multiple user's iTunes libraries into one library (assuming their all the same iTunes User account)

Note these directions are for a Mac (but would only need slight modifications to work on a pc)
(These haven't been fully tested yet, please let me know if you find issues)

So you're a family of 6 and you each have a login on the same mac:

1. Dad
2. Mom
3. Son1
4. Son2
5. Daughter1

First you need to decide which user will "own" the master library. So if we select "Dad", then Dad should log into the mac.

1. Login to the user whose library you'll be working on 
2. Launch iTunes
3. Select iTunes -> Preferences (Or hit Splat-,)
4. Click on the Advanced tab  (Make a note of the "iTunes Media folder location")
5. Select "Keep iTunes Media folder organized"
6. Select "Copy files to iTunes Media folder when adding to library" 
7. Click "OK" and close the preferences folder
8. Select File->Library->Organize Library (This will copy all files into the directory specified in the advanced user preferences tab as the base directory, and organize them according to the wisdom of iTunes)
9. At this point all Dad's music files should be organized.
10. Repeat 1->7 for the rest of the users (Mom, Son1, Son2, Daughter1)
11. Make a note of the location of the iTunes library for each user when you're in the advanced tab.
12. Now log back into the Dad's account
13. Start iTunes
14. Click on File->Add to Library...
15. Select the directory for the user's library you're consolidating into this library.
16. Click OK
17. Repeat 12->16 for the rest of the users you're consolidating into this library

And.. You're done.

One thing this won't do is migrate playlists into the master account.