[vPostMaster] Vpostmaster

[Sam Povilus]

Sean Reifschneider wrote:
> On Sun, Sep 16, 2007 at 06:44:13PM -0400, Sam Povilus wrote:
>   
>> Where is the password that vpostmster uses to log in to that database, 
>> psql does prompt, i just don't know the vpostmaster postgres password 
>> because i used the install script. obviously it has to connect to the 
>> database before it can test imap passwords
>>     
>
> There are a couple of ".conf" files in "/usr/lib/vpostmaster/etc" that have
> logins.  The Postfix and Dovecot logins are in "/etc/postfix/vpm-domains"
> and "/etc/dovecot-pgsql.conf".
>
> Sean
>   
i get into the database with user postgres and did this;
postgres=# ALTER USER vpostmaster WITH PASSWORD 'FAKE';
ALTER ROLE
postgres=# SELECT passwd FROM pg_shadow WHERE usename='vpostmster';
 passwd
--------
(0 rows)

postgres=#

why is it doing that?, i have changed the password in 
/etc/dovecot-pgsql.conf to FAKE and it still does not work, what is 
going wrong with my postgres server? i also tried uncommenting this line 
in pg_hba.conf:


host    all         all         127.0.0.1/32          ident sameuser

but it juat said "uathentication failed" when trying "cd vpostmaster: 
psql -d vpostmaster -h localhost"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.tummy.com/pipermail/vpostmaster/attachments/20070918/2ca357a3/attachment.html