[vPostMaster] SQL Error getting extra attribute / user extra settings (fwd from: scott@tummy.com)

[Scott Kleihege]

On Thu, Jul 03, 2008 at 08:49:33AM -0400, Craig Isdahl wrote:
>All -
>
>The commercial update rolled out on one of our mail server and we are now
>seeing the following error, any assistance is welcome!
>
>-----
>The following errors were found in your form. Please correct them and submit
>the form again.
>
>    * SQL Error getting extra attribute information: ERROR: relation
>"extraattributes" does not exist
>    * SQL Error getting user extra settings: ERROR: relation "extrasettings"
>does not exist
>-----

It sounds like you'll need to manually update the database.  Try running
the following commands to stop the mail services, and upgrade the database.

   service dovecot stop; service httpd stop; service postfix stop
   su postgres -c '/usr/lib/vpostmaster/bin/vpm-dbupgrade --force'
   service dovecot start; service httpd start; service postfix start

I believe it should have run the vpm-dbupgrade as part of the postinstall
process during the upgrade, I wonder why it failed or didn't run...

-- 
Regards,                    tummy.com, ltd
Scott Kleihege              Linux Consulting since 1995
                            http://www.tummy.com/