[freeside] 1.4.0pre14

[Kristian Hoffmann]

On Fri, 14 Jun 2002, ivan wrote:

> On Fri, Jun 14, 2002 at 11:10:44PM -0700, Kristian Hoffmann wrote:
> > sqlmail is an export for svc_acct, svc_domain, and svc_forward.  The
> > reason that it only shows up in svc_domain has to do with Mark's comments
> > on exporttype2svcdb.  I thought we checked those changes in, but
> > apparently we didn't.  I'll ask Mark.
>
> I also thought you checked those changes in.
>
> > Other than that, the export is designed to work with a stock courier-imap
> > installation.  Exim can also be made to work with it.  I can share
> > configuration examples if you'd like.
>
> I realize that there isn't the best documentation on all of the existing
> exports, but if you could put any information on how to use the export
> into the `'notes' section of FS::part_export.pm, it would help.

I'll come up with something.

> If you're only using this export with courier-imap, and it needs extra
> hoops to use with other mail servers, it seems like it should be renamed
> to `courier' or `sqlcourier" or something.  It can inherit from a base
> class if there is code that might be useful for exports.

The database layout that the export, and courier, uses is pretty generic.
For the most part, it is just a renamed version of svc_acct, svc_domain,
and svc_forward.  Courier and Exim both required configuration changes but
nothing else.  Being that sqlmail exports all the available fields to the
remote database, this could be used for any mail server that supports sql
queries.  That's why I left the name sqlmail instead of something more
specific.

-Kristian