version 2.8 problem

[troxlinux]

Hi , thnk I will make the changes

2013/3/26 Richard Thomas <gmane at richardthomas.es>:

> Hi,
>
> I've just hit the same problem upgrading to amavisd-new 2.8.0 on
> CentOS 5.9 (== RedHat Enterprise Linux 5.9). There is a database
> update required for the upgrade to 2.7.0 (which I guess was missed
> by RedHat/CentOS), full details are in the README file for mysql
> under /usr/share/doc/amavisd-new-2.8.0. You need to add the following
> 4 columns:
>
>   ALTER TABLE msgrcpt ADD rseqnum     integer  DEFAULT 0   NOT NULL;
>   ALTER TABLE msgrcpt ADD content     char(1)  DEFAULT ' ' NOT NULL;
>   ALTER TABLE msgrcpt ADD is_local    char(1)  DEFAULT ' ' NOT NULL;
>   ALTER TABLE msgs    ADD originating char(1)  DEFAULT ' ' NOT NULL;
>
> If you don't periodically clean out those tables the update will take
> ages, further down in the same README file you will find suggestions
> for DELETE scripts that will remove old messages from the database.
>
> I'm still in the process of purging old messages before I run the above
> ALTER TABLE statements, so I'll report back when it's done to confirm.
>
> HTH,
>
> Richard
>
>
>
>



-- 
rickygm

http://gnuforever.homelinux.com