mysql changing field definition for an existing db.

2015-03-03 Thread Alan Munday
From the README.sql-mysql: "Instead of declaring a time_iso field in table msgs as a string: time_iso char(16) NOT NULL, one may want to declare is as: time_iso TIMESTAMP NOT NULL DEFAULT 0, in which case $timestamp_fmt_mysql *MUST* be set to 1 in amavisd.conf to avoid MySQL inability t

Re: Spam assassin with amavisd-new

2015-03-03 Thread Alex Regan
Hi, "pkg_delete: package 'p5-Mail-SpamAssassin-3.3.2_8' is required by these other packages and may not be deinstalled: amavisd-new-2.8.0_2,1 maia-1.0.3.r1575_3 p5-FuzzyOcr-devel-3.6.0_5 “ Do is my best course of action to delete those ports and reinstall from scratch?? Yes, especially if yo

Spam assassin with amavisd-new

2015-03-03 Thread jason hirsh
I am running a FreeBSD server with Postfix Dovecot and amavisd-new . Going through A recent upgrade i have come to the observation that overtime I have messed up and install two Spamassasinsat least I believe that is what the following message us feeling me when I trie dot upgrade amavisd-