[tpop3d-discuss] Looking for resources

Chris Lightfoot chris at ex-parrot.com
Mon, 26 Jan 2004 11:52:43 +0000


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)