Re: [vchkpw] vpopmail and postgresql

2007-09-12 Thread Sandeep Agarwal 
On 9/12/07, Charles Boening [EMAIL PROTECTED] wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 I'm not sure about the newer versions of vpopmail (still running
 5.4.10), but you may need to edit the vpgsql.h file.

 After you changed the postgresql configs, did you restart the postgresql
 service or HUP the postmaster?

 lsof -i | grep postgres

 ps ax | grep postmaster


 Charlie



  -Original Message-
  From: Marco Spiga [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, September 11, 2007 9:41 AM
  To: vchkpw@inter7.com
  Subject: Re: [vchkpw] vpopmail and postgresql
 
  On Mon, Sep 10, 2007 at 12:18:34PM -0700, Charles Boening wrote:
   Date: Mon, 10 Sep 2007 12:18:34 -0700
   From: Charles Boening [EMAIL PROTECTED]
   Subject: RE: [vchkpw] vpopmail and postgresql
   To: vchkpw@inter7.com
  
   -BEGIN PGP SIGNED MESSAGE-
   Hash: SHA1
  
  
   In your pg_hba.conf
  
   hostvpopmail   vpopuser   127.0.0.1/32trust
  
  
   Also, in your postgresql.conf, make sure you enable TCP connections.
   listen_addresses = '*'  # set appropriately
   port = 5432
  
  Hi Charles!
 
  My netstat output is:
  Active Internet connections (servers and established)
  Proto Recv-Q Send-Q Local Address   Foreign Address
  State   PID/Program name
  tcp0  0 127.0.0.1:5432  0.0.0.0:*
  LISTEN  3508/postmaster
  udp0  0 127.0.0.1:32768 127.0.0.1:32768
  ESTABLISHED 3508/postmaster
 
  If I try to run 'tcpdump -i lo 5432' and I give the command
 vadddomain,
  I don't see any traffic on loopback interface.
 
  Where I can setup vpopmail parameters to work with remote address
  of postgresql (for example 127.0.0.1 or 172.16.89.4) and one private
  password of vpopmail database?
 
  I tried to create /var/vpopmail/etc/vpopmail.pgsql with this line:
  localhost|0|vpopuser|password|vpopmail
  but the status don't change (I think this file is useless).
 
 
  
  
-Original Message-
From: Marco Spiga [mailto:[EMAIL PROTECTED]
Sent: Monday, September 10, 2007 11:28 AM
To: vchkpw@inter7.com
Subject: [vchkpw] vpopmail and postgresql
   
Hello
   
Please help me!!!
   
How can I do to work vpopmail with postgresql over socket tcp and
password authentications?
   
If I try the command:
   
/var/vpopmail/bin/vadddomain mydomain.com domainpassword
   
I have this output message:
   
   
 ---
vauth_open: can't connect: FATAL:  Ident authentication failed for
   user
vpopuser
   
Error - Success. Initial open.
   
 ---
   
It work only if I insert in pg_hba.conf this line:
   
# TYPE  DATABASEUSERCIDR-ADDRESS  METHOD
   
# local is for Unix domain socket connections only
   
local   all postgres  ident
 sameuser
local   vpopmailvpopuser  trust
   
I have inserted in /var/vpopmail/etc/vpopmail.pgsql this line:
   
localhost|0|vpopuser|mypassword|vpopmail
   
I am Sorry for my bad English.
Please help me!!!
   
Marco

i am also using a old version of vpopmail 5.4.13, to connect to
postgres on a remote machine i made the following changes in vpgsql.h
file, the changes are

/* Edit to match your set up */
#define DB vpopmail
#define DBHOST hostname
#define DBUSER username
#define DBPASSWD password
#define PG_CONNECT host= DBHOST  user= DBUSER  password=
DBPASSWD  dbname= DB

Re: [vchkpw] vpopmail and postgresql

2007-09-12 Thread Marco Spiga 
On Wed, Sep 12, 2007 at 02:30:07PM +0530, Sandeep Agarwal wrote:
 Date: Wed, 12 Sep 2007 14:30:07 +0530
 From: Sandeep Agarwal [EMAIL PROTECTED]
 Subject: Re: [vchkpw] vpopmail and postgresql
 To: vchkpw@inter7.com
 
 On 9/12/07, Charles Boening [EMAIL PROTECTED] wrote:
  -BEGIN PGP SIGNED MESSAGE-
  Hash: SHA1
 
  I'm not sure about the newer versions of vpopmail (still running
  5.4.10), but you may need to edit the vpgsql.h file.
 
  After you changed the postgresql configs, did you restart the postgresql
  service or HUP the postmaster?
 
  lsof -i | grep postgres
 
  ps ax | grep postmaster
 
 
  Charlie
 
 
 
   -Original Message-
   From: Marco Spiga [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, September 11, 2007 9:41 AM
   To: vchkpw@inter7.com
   Subject: Re: [vchkpw] vpopmail and postgresql
  
   On Mon, Sep 10, 2007 at 12:18:34PM -0700, Charles Boening wrote:
Date: Mon, 10 Sep 2007 12:18:34 -0700
From: Charles Boening [EMAIL PROTECTED]
Subject: RE: [vchkpw] vpopmail and postgresql
To: vchkpw@inter7.com
   
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
   
   
In your pg_hba.conf
   
hostvpopmail   vpopuser   127.0.0.1/32trust
   
   
Also, in your postgresql.conf, make sure you enable TCP connections.
listen_addresses = '*'  # set appropriately
port = 5432
   
   Hi Charles!
  
   My netstat output is:
   Active Internet connections (servers and established)
   Proto Recv-Q Send-Q Local Address   Foreign Address
   State   PID/Program name
   tcp0  0 127.0.0.1:5432  0.0.0.0:*
   LISTEN  3508/postmaster
   udp0  0 127.0.0.1:32768 127.0.0.1:32768
   ESTABLISHED 3508/postmaster
  
   If I try to run 'tcpdump -i lo 5432' and I give the command
  vadddomain,
   I don't see any traffic on loopback interface.
  
   Where I can setup vpopmail parameters to work with remote address
   of postgresql (for example 127.0.0.1 or 172.16.89.4) and one private
   password of vpopmail database?
  
   I tried to create /var/vpopmail/etc/vpopmail.pgsql with this line:
   localhost|0|vpopuser|password|vpopmail
   but the status don't change (I think this file is useless).
  
  
   
   
 -Original Message-
 From: Marco Spiga [mailto:[EMAIL PROTECTED]
 Sent: Monday, September 10, 2007 11:28 AM
 To: vchkpw@inter7.com
 Subject: [vchkpw] vpopmail and postgresql

 Hello

 Please help me!!!

 How can I do to work vpopmail with postgresql over socket tcp and
 password authentications?

 If I try the command:

 /var/vpopmail/bin/vadddomain mydomain.com domainpassword

 I have this output message:


  ---
 vauth_open: can't connect: FATAL:  Ident authentication failed for
user
 vpopuser

 Error - Success. Initial open.

  ---

 It work only if I insert in pg_hba.conf this line:

 # TYPE  DATABASEUSERCIDR-ADDRESS  METHOD

 # local is for Unix domain socket connections only

 local   all postgres  ident
  sameuser
 local   vpopmailvpopuser  trust

 I have inserted in /var/vpopmail/etc/vpopmail.pgsql this line:

 localhost|0|vpopuser|mypassword|vpopmail

 I am Sorry for my bad English.
 Please help me!!!

 Marco
 
 i am also using a old version of vpopmail 5.4.13, to connect to
 postgres on a remote machine i made the following changes in vpgsql.h
 file, the changes are
 
 /* Edit to match your set up */
 #define DB vpopmail
 #define DBHOST hostname
 #define DBUSER username
 #define DBPASSWD password
 #define PG_CONNECT host= DBHOST  user= DBUSER  password=
 DBPASSWD  dbname= DB

Thanks Charles, Thanks Sandeep.

With your AID, I have resolved problem!!

Marco

Re: [vchkpw] vpopmail and postgresql

2007-09-11 Thread Marco Spiga 
On Mon, Sep 10, 2007 at 12:18:34PM -0700, Charles Boening wrote:
 Date: Mon, 10 Sep 2007 12:18:34 -0700
 From: Charles Boening [EMAIL PROTECTED]
 Subject: RE: [vchkpw] vpopmail and postgresql
 To: vchkpw@inter7.com
 
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 
 In your pg_hba.conf
 
 hostvpopmail   vpopuser   127.0.0.1/32trust
 
 
 Also, in your postgresql.conf, make sure you enable TCP connections.
 listen_addresses = '*'  # set appropriately
 port = 5432
 
Hi Charles!

My netstat output is:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address   Foreign Address
State   PID/Program name
tcp0  0 127.0.0.1:5432  0.0.0.0:*
LISTEN  3508/postmaster
udp0  0 127.0.0.1:32768 127.0.0.1:32768
ESTABLISHED 3508/postmaster

If I try to run 'tcpdump -i lo 5432' and I give the command vadddomain,
I don't see any traffic on loopback interface.

Where I can setup vpopmail parameters to work with remote address
of postgresql (for example 127.0.0.1 or 172.16.89.4) and one private
password of vpopmail database?

I tried to create /var/vpopmail/etc/vpopmail.pgsql with this line:
localhost|0|vpopuser|password|vpopmail
but the status don't change (I think this file is useless).


 
 
  -Original Message-
  From: Marco Spiga [mailto:[EMAIL PROTECTED]
  Sent: Monday, September 10, 2007 11:28 AM
  To: vchkpw@inter7.com
  Subject: [vchkpw] vpopmail and postgresql
  
  Hello
  
  Please help me!!!
  
  How can I do to work vpopmail with postgresql over socket tcp and
  password authentications?
  
  If I try the command:
  
  /var/vpopmail/bin/vadddomain mydomain.com domainpassword
  
  I have this output message:
  
  ---
  vauth_open: can't connect: FATAL:  Ident authentication failed for
 user
  vpopuser
  
  Error - Success. Initial open.
  ---
  
  It work only if I insert in pg_hba.conf this line:
  
  # TYPE  DATABASEUSERCIDR-ADDRESS  METHOD
  
  # local is for Unix domain socket connections only
  
  local   all postgres  ident sameuser
  local   vpopmailvpopuser  trust
  
  I have inserted in /var/vpopmail/etc/vpopmail.pgsql this line:
  
  localhost|0|vpopuser|mypassword|vpopmail
  
  I am Sorry for my bad English.
  Please help me!!!
  
  Marco
  --
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.7 (MingW32)
 
 iD8DBQFG5ZiKcGGHuFdGSWARAgAGAKCKKE03bcTFqF9xPp/niZjaW7LHMACfYW3d
 tHWbldIoIpJef+ZIqTMVjjs=
 =lcPe
 -END PGP SIGNATURE-

RE: [vchkpw] vpopmail and postgresql

2007-09-11 Thread Charles Boening 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I'm not sure about the newer versions of vpopmail (still running
5.4.10), but you may need to edit the vpgsql.h file.

After you changed the postgresql configs, did you restart the postgresql
service or HUP the postmaster?

lsof -i | grep postgres

ps ax | grep postmaster


Charlie



 -Original Message-
 From: Marco Spiga [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 11, 2007 9:41 AM
 To: vchkpw@inter7.com
 Subject: Re: [vchkpw] vpopmail and postgresql
 
 On Mon, Sep 10, 2007 at 12:18:34PM -0700, Charles Boening wrote:
  Date: Mon, 10 Sep 2007 12:18:34 -0700
  From: Charles Boening [EMAIL PROTECTED]
  Subject: RE: [vchkpw] vpopmail and postgresql
  To: vchkpw@inter7.com
 
  -BEGIN PGP SIGNED MESSAGE-
  Hash: SHA1
 
 
  In your pg_hba.conf
 
  hostvpopmail   vpopuser   127.0.0.1/32trust
 
 
  Also, in your postgresql.conf, make sure you enable TCP connections.
  listen_addresses = '*'  # set appropriately
  port = 5432
 
 Hi Charles!
 
 My netstat output is:
 Active Internet connections (servers and established)
 Proto Recv-Q Send-Q Local Address   Foreign Address
 State   PID/Program name
 tcp0  0 127.0.0.1:5432  0.0.0.0:*
 LISTEN  3508/postmaster
 udp0  0 127.0.0.1:32768 127.0.0.1:32768
 ESTABLISHED 3508/postmaster
 
 If I try to run 'tcpdump -i lo 5432' and I give the command
vadddomain,
 I don't see any traffic on loopback interface.
 
 Where I can setup vpopmail parameters to work with remote address
 of postgresql (for example 127.0.0.1 or 172.16.89.4) and one private
 password of vpopmail database?
 
 I tried to create /var/vpopmail/etc/vpopmail.pgsql with this line:
 localhost|0|vpopuser|password|vpopmail
 but the status don't change (I think this file is useless).
 
 
 
 
   -Original Message-
   From: Marco Spiga [mailto:[EMAIL PROTECTED]
   Sent: Monday, September 10, 2007 11:28 AM
   To: vchkpw@inter7.com
   Subject: [vchkpw] vpopmail and postgresql
  
   Hello
  
   Please help me!!!
  
   How can I do to work vpopmail with postgresql over socket tcp and
   password authentications?
  
   If I try the command:
  
   /var/vpopmail/bin/vadddomain mydomain.com domainpassword
  
   I have this output message:
  
  
---
   vauth_open: can't connect: FATAL:  Ident authentication failed for
  user
   vpopuser
  
   Error - Success. Initial open.
  
---
  
   It work only if I insert in pg_hba.conf this line:
  
   # TYPE  DATABASEUSERCIDR-ADDRESS  METHOD
  
   # local is for Unix domain socket connections only
  
   local   all postgres  ident
sameuser
   local   vpopmailvpopuser  trust
  
   I have inserted in /var/vpopmail/etc/vpopmail.pgsql this line:
  
   localhost|0|vpopuser|mypassword|vpopmail
  
   I am Sorry for my bad English.
   Please help me!!!
  
   Marco
   --
  -BEGIN PGP SIGNATURE-
  Version: GnuPG v1.4.7 (MingW32)
 
  iD8DBQFG5ZiKcGGHuFdGSWARAgAGAKCKKE03bcTFqF9xPp/niZjaW7LHMACfYW3d
  tHWbldIoIpJef+ZIqTMVjjs=
  =lcPe
  -END PGP SIGNATURE-
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFG5uOdcGGHuFdGSWARAilBAJ0Xv1TYU8K9PaNTGmZfr6sR14nTtwCffwx7
/sgIPWaH5WlCGsZOO+HOVCQ=
=lgdv
-END PGP SIGNATURE-

RE: [vchkpw] vpopmail and postgresql

2007-09-10 Thread Charles Boening 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


In your pg_hba.conf

hostvpopmail   vpopuser   127.0.0.1/32trust


Also, in your postgresql.conf, make sure you enable TCP connections.
listen_addresses = '*'  # set appropriately
port = 5432



 -Original Message-
 From: Marco Spiga [mailto:[EMAIL PROTECTED]
 Sent: Monday, September 10, 2007 11:28 AM
 To: vchkpw@inter7.com
 Subject: [vchkpw] vpopmail and postgresql
 
 Hello
 
 Please help me!!!
 
 How can I do to work vpopmail with postgresql over socket tcp and
 password authentications?
 
 If I try the command:
 
 /var/vpopmail/bin/vadddomain mydomain.com domainpassword
 
 I have this output message:
 
 ---
 vauth_open: can't connect: FATAL:  Ident authentication failed for
user
 vpopuser
 
 Error - Success. Initial open.
 ---
 
 It work only if I insert in pg_hba.conf this line:
 
 # TYPE  DATABASEUSERCIDR-ADDRESS  METHOD
 
 # local is for Unix domain socket connections only
 
 local   all postgres  ident sameuser
 local   vpopmailvpopuser  trust
 
 I have inserted in /var/vpopmail/etc/vpopmail.pgsql this line:
 
 localhost|0|vpopuser|mypassword|vpopmail
 
 I am Sorry for my bad English.
 Please help me!!!
 
 Marco
 --
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFG5ZiKcGGHuFdGSWARAgAGAKCKKE03bcTFqF9xPp/niZjaW7LHMACfYW3d
tHWbldIoIpJef+ZIqTMVjjs=
=lcPe
-END PGP SIGNATURE-

Re: [vchkpw] vpopmail and postgresql error on valias

2004-02-06 Thread Jason Parker 
On Feb 4, 2004, at 2:25 AM, Vpopmail Mailinglist wrote:

hi guys..
im getting a error when i try to create an alias on vpopmail 5.4.0.. im
getting :
lx0007:/usr/src/vpopmail-5.4.0# /var/qmail/vpopmail/bin/valias -i
[EMAIL PROTECTED] [EMAIL PROTECTED]
vpgsql:sql error[n]:ERROR:  parser: parse error at or near ( at
character 112
vpgsql: sql error[j]: ERROR:  Relation valias does not exist

vpgsql:sql error[n]:ERROR:  parser: parse error at or near ( at
character 112
vpgsql: sql error[k]: ERROR:  Relation valias does not exist

any idea ?


I got that too.

The errors say the relation valias does not exist

... using vconvert ...

  [EMAIL PROTECTED]:etc # setuidgid vpopmail vconvert -c -m
  vpgsql:sql error[n]:ERROR:  syntax error at or near ( at character  
112

  vpgsql: sql error: ERROR:  relation valias does not exist

... And when delivering mail (qmail-send) ...

  2004-02-06 15:58:04.366286500 starting delivery 1: msg 311219 to  
local [EMAIL PROTECTED]
  2004-02-06 15:58:04.366296500 status: local 1/10 remote 0/20
  2004-02-06 15:58:04.366299500 starting delivery 2: msg 311219 to  
remote [EMAIL PROTECTED]
  2004-02-06 15:58:04.366303500 status: local 1/10 remote 1/20
  2004-02-06 15:58:04.488389500 delivery 1: success:  
vpgsql:sql_error[n]:ERROR: 
__syntax_error_at_or_near_(_at_character_112//vpgsql:_sql_error[j]: 
_ERROR:__relation_valias_does_not_exist//did_0+0+1/
  2004-02-06 15:58:04.489176500 status: local 0/10 remote 1/20
  2004-02-06 15:58:05.671511500 delivery 2: success:  
63.121.160.34_accepted_message./Remote_host_said: 
_250_ok_1076104694_qp_42069/

-jason

Re: [vchkpw] Vpopmail 5.3.28 + PostgreSQL missing initial sql statement

2003-10-12 Thread Michael Bowe 




- Original Message - 

  From: 
  Juan Alonso 
  
  To: [EMAIL PROTECTED] 
  Sent: Friday, October 10, 2003 7:10 
  PM
  Subject: [vchkpw] Vpopmail 5.3.28 + 
  PostgreSQL missing initial sql statement
  
  Back with another bug:After installing Vpopmail 5.3.28 with 
  postgresql auth module I have to manually "create sequence vpopmail_id_seq;" 
  into the db before being able to insert a domain.If I don't do that an 
  SQL error is generated when trying to add a domain.

I spent some time looking into this 
problem

As reported, if you compile with 
--enable-postgres=y --enable-many-domains=y, then the vpopmail install will not 
work. You get the error as reported.

I cant see any reason why the vpopmail TABLE_LAYOUT 
in vpgsql.h needs to have the lines maked in bold:

  #ifdef MANY_DOMAINS#ifdef CLEAR_PASS#define TABLE_LAYOUT 
  "pw_name varchar(32) NOT NULL, \pw_domain varchar(64) NOT NULL, 
  \pw_passwd varchar(40), \pw_uid int4, pw_gid int4, \pw_gecos 
  varchar(48), \pw_dir varchar(160), \pw_shell varchar(20), 
  \pw_clear_passwd varchar(16), \id integer DEFAULT 
  nextval('\"vpopmail_id_seq\"'::text) NOT NULL, \UNIQUE(\"id\"), 
  \PRIMARY KEY(\"pw_domain\", \"pw_name\")"

I tried removing this line and it cleared the error 
you report. vpopmail still appeared to work normally. I searched the source and 
found no reference to this id column.

Does anyone know why that column is included? 



Michael.