Re: [vchkpw] vpopmail / postgres config issues

2004-07-02 Thread Charles M. Gerungan 
Hello Jay,

On Fri, 02 Jul 2004 11:45:06 -0700 UTC, Jay Tortorelli wrote:

>> OK, I'm trying to configure vpopmail 5.4.6 with postgres 7.4.1.  The
>> compilation process seems to work fine, but I can't get a connection to
>> the database when actually running the tools. 

JT> In vpgsql.h there are a couple of lines that need editing:

It should be a lot nicer if there was a vpopmail.pgsql (like there is a
vpopmail.mysql).

-- 
Regards, Charles.

Re: [vchkpw] vpopmail / postgres config issues

2004-07-02 Thread Jay Tortorelli 
On Thu, 2004-07-01 at 18:50, Darius Wei wrote:
> OK, I'm trying to configure vpopmail 5.4.6 with postgres 7.4.1.  The 
> compilation process seems to work fine, but I can't get a connection to 
> the database when actually running the tools. 

In vpgsql.h there are a couple of lines that need editing:

#define DB "NAME_OF_YOUR_DATABASE"
#define PG_CONNECT "host=YOUR_DB_HOST_NAME user=YOUR_DB_USERNAME
password=YOUR_PASSWORD dbname=" DB

Although I don't think host is in there as a default.  But if your
database server is on a different server you will need to add that.

Hope that helps.

Jay Tortorelli

Re: [vchkpw] vpopmail / postgres config issues

2004-07-01 Thread Tom Collins 
On Jul 1, 2004, at 6:50 PM, Darius Wei wrote:
Mike Bowe's quick guide to vpop/pg seems fine, although I can fine 
noplace in the ./configure help or documentation about how to 
authenticate to the database (the postgres user has a password that 
I'm never prompted for, nor do I see anything asking for a config 
file).  The vpopmail db exists in the database.
Try editing vpgsql.h to set the connection info for the database.
--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/

[vchkpw] vpopmail / postgres config issues

2004-07-01 Thread Darius Wei 
OK, I'm trying to configure vpopmail 5.4.6 with postgres 7.4.1.  The 
compilation process seems to work fine, but I can't get a connection to 
the database when actually running the tools. 

Mike Bowe's quick guide to vpop/pg seems fine, although I can fine 
noplace in the ./configure help or documentation about how to 
authenticate to the database (the postgres user has a password that I'm 
never prompted for, nor do I see anything asking for a config file).  
The vpopmail db exists in the database.

The error given when I type ./vadddomain test.com test is this:
vauth_open: can't connect: fe_sendauth: no password supplied
pg_begin: no connection to the server
vpgsql: error creating table 'dir_control': no connection to the server
vcreate_dir_control: insert failed: no connection to the server
I have compiled vpopmail using the following options:
./configure --enable-postgres=y 
--enable-tcpserver-file=/var/vpopmail/etc/tcp.smtp --enable-logging=v 
--enable-auth-module=pgsql --disable-ip-alias-domains 
--disable-roaming-users --disable-passwd --enable-clear-passwd 
--disable-domain-quotas --enable-valias

Any help would be much appreciated.  Thanks!!
darius