Rick Widmer wrote:
> I am working on making all the back ends work the same way, but not
> being a PostgreSQL user, and not seeing all that many people using it,
> it isn't a high priority for me.  I'll get around to it in or soon after
> version 6 hits the street.  That may be a year or more out.

WOW, thats a long time to wait :) It's unfortunate that not people use
it, because it is a very good database from what I've seen, and I'm no
guru :)

Have you considered the possibilty of unixODBC/iODBC, or an ODBC manager
of sorts? I would have thought that it would be easier to point it to an
OdBC manager and let it take care of the specific driver details, or is
there something else I am missing :)

> If you want the functions, and you can code c, you should copy the
> needed code from vmysql.c to pgsql.c and vmysql.h to vpgsql.h then
> adjust the queries as needed to work with PostgreSQL.  It should not be
> all that hard to do.  If you submit a patch I'll add it to the next
> release.  If you wanted to sponsor me to do the work, paid work comes
> before open source projects.  (The reason I haven't been seen here for
> so long... :)

I'm no C expert, but I will try to look around to see if I can do
anything that may help my cause :) Thanks for the tips on where to look
though. I did manage to get a little further with the sql logging
option, it appears that the "sqlBufUpdate" issue was a typo, because it
is defined in vpgsql.c but is defined as "SqlBufUpdate". I just changed
the 2 places in vauth.c to be an uppercase S and it compiled further,
now I'm getting the following error:

/usr/sfw/bin/gcc  -I/usr/sfw/include -Wall   -o vchkpw  vchkpw.o md5.o
hmac_md5.o libvpopmail.a -L/usr/lib -lpq  -lcrypt
Undefined                       first referenced
 symbol                             in file
PGresultStatus                      libvpopmail.a(libvpopmail_a-vauth.o)
ld: fatal: Symbol referencing errors. No output written to vchkpw
collect2: ld returned 1 exit status
gmake[2]: *** [vchkpw] Error 1
gmake[2]: Leaving directory `/export/home/user/build/qmail/vpopmail-5.4.25'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/export/home/user/build/qmail/vpopmail-5.4.25'
gmake: *** [all] Error 2

Is this a library issue?

>> On a side note, are there any other PostgreSQL users out there that can
>> recommend any additional parameters I should use with vpopmail?
> There are a few.  I think I've heard from about three other people who
> are using the PostgreSQL back end.  Hopefully someone else will reply...
>> Also, what do the following configure options do, I've tried to find
>> documentation on them but am obviously looking in the wrong places:
>> [1] --enable-ip-alias-domains,
> Allows vpopmail to use the incoming (server) IP address to determine
> which domain a user is associated with rather than requiring the user to
> supply it when they attempt to connect.  (Using [EMAIL PROTECTED] instead
> of just user for the  smtp/pop/imap user name in their mail reader.)
> This requires a unique IP address for each incoming domain that can be
> identified by an IP alias.
>> [2] --enable-qmail-ext
> When enabled vpopmail (vdelivermail) will recognize files like
> ..qmail-something in user directories.  This lets the user manage
> multiple email addresses like [EMAIL PROTECTED]

Thanks for the explantions :)

> Rick


Reply via email to