[vPostMaster] Postgress Passwords

[Scott Kleihege]

On Fri, Feb 29, 2008 at 03:41:53PM -0700, Brian Wood wrote:
> After restoring the config and database files from the running server to a 
> new machine, vpostmaster is unable to connect to the database as user 
> vpostmasterwww.
>
> The wwwdb.conf files on both systems show the same password (is this the 
> actual password or is it encrypted?).
>
> Does vpostmaster use the same password for vpostmasterwww on every 
> installation? Or did I over-write one system's password with the other's 
> and thus cause problems.
>
> I don't know much about postgres, obviously.
>
> Any suggestions as to the easiest way to correct this? Short of 
> re-installing on the new machine?
>
> Much thanks for any suggestions.

If this is a debian or ubuntu system, you may need
to edit your postgres configuration file, something like
/etc/postgresql/8.1/main/postgresql.conf, depending on what version
of postgresql you have installed, and uncommenting or setting

ssl = false

then restarting postgresql

   /etc/init.d/postgresql-8.1 restart

Turning off ssl is a security risk if you have remote systems
accessing postgresql on the vPostMaster system since passwords and
data may be passed in plaintext over the network.  If postgresql is
only accessed locally, it is less of a security risk, but I still
suggest utilizing the firewall to block incoming connections.

If that still doesn't work, running
/usr/lib/vpostmaster/bin/setup-debian will reset all of the passwords
based on what is in the configuration files, it will restart several
services when it runs, including postgres, apache, and all of the mail
programs.

If this is not a debian system, try
/usr/lib/vpostmaster/bin/setup-fc3

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