Just got dropbox installed on my Ubuntu workstation. Great way to share files with my Mac and other computers. Now I cant live without it. To install on Jaunty just edit /etc/apt/sources.list and add:

deb http://linux.getdropbox.com/ubuntu jaunty main
deb-src http://linux.getdropbox.com/ubuntu jaunty main

Then:

$ sudo apt-get update
$ sudo apt-get install nautilus-dropbox

That’s it!!!

–JC

BCC maps are handled in postfix by the following tags:

always_bcc = address
Deliver a copy of all mail to the specified address. In Postfix versions before 2.1, this feature is implemented by smtpd(8), qmqpd(8), or pickup(8).

sender_bcc_maps = type:table
Search the specified “type:table” lookup table with the envelope sender address for an automatic BCC address. This feature is available in Postfix 2.1 and later.

recipient_bcc_maps = type:table
Search the specified “type:table” lookup table with the envelope recipient address for an automatic BCC address. This feature is available in Postfix 2.1 and later.

So this is how I did it:

Added the following lines to /etc/postfix/main.cf:

sender_bcc_maps = hash:/etc/postfix/bcc_maps
recipient_bcc_maps = hash:/etc/postfix/bcc_maps

Edited the file /etc/postfix/bcc_maps :

monitorme@linuxzone.org admin@linuxzone.org

This way for all messages sent and received by monitorme@linuxzone.org, a copy will be sent to admin@linuxzone.org

Ran postmap /etc/postfix/bcc_maps

restarted postfix.

If you want mysql to have a different timezone than your server’s, here are the steps:

1) Run the following command to populate mysql’s timezone tables:

mysql_tzinfo_to_sql /usr/share/zoneinfo |mysql mysql

2) in the [mysqld] section of /etc/my.cnf, add the following line:

default-time-zone='US/Eastern'
(change US/Eastern with the desired timezone of course. It should match the format of /usr/share/zoneinfo)

3) Restart mysql

To check you mysql server’s time run the following query:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-03-30 16:21:20 |
+---------------------+
1 row in set (0.00 sec)


–JC

This morning I read a twit about a blog post from xapbr.com (http://www.xaprb.com/blog/2009/03/25/mysql-command-line-tip-compare-result-sets/).

Pretty nifty tip on how to get a MD5 Checksum on a result set from a query. This can be very helpful when you are optimizing queries that return a very large set of results and you need to make sure they match.

mysql> pager md5sum -
PAGER set to 'md5sum -'
mysql> select * from test;
a09bc56ac9aa0cbcc659c3d566c2c7e4 -
4096 rows in set (0.00 sec)

–JC

If you get this error when trying to access Log Manager, this happens because filemng which runs as psaadm user does not have permission to access the directory. You can get a similar error on the File Manager:

Error: Unable to change directory to /statistics: filemng failed: filemng: opendir failed: Permission denied

To fix this problem make sure psaadm is part of the psaserv group in /etc/group

–JC