[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss] Looking for resources
From: |
Chris Lightfoot |
Subject: |
Re: [tpop3d-discuss] Looking for resources |
Date: |
Mon, 26 Jan 2004 11:52:43 +0000 |
User-agent: |
Mutt/1.4i |
On Mon, Jan 26, 2004 at 06:12:29PM +0700, Chris Travers wrote:
>
> I am in the process of building a large open source (GPL'd) CRM suite called
> HERMES. THe project web page is at http://hermesweb.sourceforge.net. I am
> looking at tpop3d to eventually provide a pop3 interface for the messaging
> and email subsystem. The messages will be stored in the PostgreSQL
> database. Consequently, I am looking for a way to:
> 1: Authenticate against the PostgreSQL database
> 2: Retrieve messages from a table (or more likely view) in the database
>
> I understand that this will require writing an auth module, as well as a
> mailbox driver. I am thinking of starting with the auth_mysql driver and
> modifying it to work with libpq instead of libmysql.
>
> However, I noticed another thing: Notably that there are defined
> configuration parameters for AUTH_PGSQL aready defined in cfgdirectives.c.
> Rather than reinventing the wheel yet, I figured I would ask: Has anyone
> created such an authentication module? If so, what is the status of it?
Yes-- this is in recent releases, enabled with
--enable-auth-pgsql. The code was contributed by Stephen
White. (Looks like I forgot to put it in the CHANGES file.
Oops.)
> Secondly, I wanted to ask: what sort of features would the community like
> to see in this work? If I am able to make these things work together, I
> would be more than happy not only to bundle tpop3d with my application but
> also contribute these drivers back so that others could use them as well.
> What would people like to see?
A database mailbox format is an excellent idea. I
considered implementing such a thing, but never got round
to it....
As a general comment, it would be great if you could make
the mailbox driver as independent of database schema as
possible. In particular, if you could adopt the same
substitution-variables approach for SQL queries that the
auth_... drivers use.
What does your database schema for mailboxes look like?
--
``If I were an international spy, should I choose an aisle or a window seat?''
(burning questions of the hour: seen on the internet)