Simon wrote:
Is there a native webmail package for dbmail version 2.x? I can only
find one for version 1.x
The reason i ask is that we have been asked by a client to build a very
customised webmail (with PHP) system for use with dbmail 2.x and would
like to take a look at the sql commands for various things...
There's a pretty concise description of the database layout on the dbmail wiki
pages. Combine that with a trace_level=5 or a query log for mysql, and you
should be able to build a list of sql commands pretty easily. The testimap.py
code in test-scripts/ tries to cover most of the IMAP commands, and tracing its
resulting database interaction will provide you with a pretty good coverage.
You can also start reading the C code; db.c contains 90% of the sql code, with
the remainder in dbmsgbug.c and dbsearch.c
A word of caution though: the database layout will be expanded during the 2.1
development cycle. The most significant change will be addition of separate
caching tables for email headers. Changes will be backward compatible, so your
code will most likely run just fine on the future 2.1+ releases, but you'll have
to update your code if you want to make use of the performance enhancements
offered by those changes.
I would suggest you consider writing your own imap client code instead of
talking to the backend directly: your code will be forward compatible, use a
well documented standard protocol, and be able to use all backends offered by
dbmail.
But if you insist on rewriting the whole db-interface layer in php, I'm sure we
can help you solve any problems you encounter.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
