[vPostMaster] SQL Error getting extra attribute / user extrasettings

[Craig Isdahl]

> -----Original Message-----
> From: Scott Kleihege [mailto:scott at tummy.com]
> Sent: Friday, July 04, 2008 1:47 AM
> To: Craig Isdahl
> Cc: vpostmaster at lists.tummy.com
> Subject: Re: [vPostMaster] SQL Error getting extra attribute / user
> extrasettings
> 
> 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/



This worked great!  Thanks!