MsSQL lookup tables.

Aaron Roberts

unread,

Oct 20, 2003, 10:38:29 AM10/20/03

to

Hi all,
I found some discussions for using a MsSQL backend for Postfix in the =
list archives. Basically, we have an existing Mail server that runs =
from a MsSQL database (the server software is MailMax 5.5) and I would =
like to put Postfix in place as a relay to avoid having the MailMax =
server open to the internet. It would be ideal for my needs to have =
Postfix take it's virtual maps from the same database as MailMax runs.

If anybody has had any real life experience of running Postfix from =
MsSQL I would love to hear it - a scheduled job to build a hash file =
from the SQL database would be adequate for my needs, but I have no =
experience in Perl or other scripting language to build something like =
this from scratch.

Many thanks,
Aaron

Keith Matthews

unread,

Oct 20, 2003, 10:47:25 AM10/20/03

to

On Mon, 20 Oct 2003 15:36:28 +0100
"Aaron Roberts" <aa...@domicilium.com> wrote:

> Hi all,
> I found some discussions for using a MsSQL backend for Postfix

> in the list archives. Basically, we have an existing Mail
> server that runs from a MsSQL database (the server software is
> MailMax 5.5) and I would like to put Postfix in place as a relay
> to avoid having the MailMax server open to the internet. It
> would be ideal for my needs to have Postfix take it's virtual

> maps from the same database as MailMax runs.
>
> If anybody has had any real life experience of running Postfix from

> MsSQL I would love to hear it - a scheduled job to build a hash file

> from the SQL database would be adequate for my needs, but I have no

> experience in Perl or other scripting language to build something like

> this from scratch.
>

If you are talking about user verification against MySQL then quite a
number of us do it without intermediate files/databases. If you haven't
spotted them there are several howtos linked to from the postfix web
site. You may want to read them then ask more specific questions.

Whether MySQL is necessarily the best way is another matter which cannot
be answered with the information you've given.

Aaron Roberts

unread,

Oct 20, 2003, 10:50:25 AM10/20/03

to

Keith Matthews wrote:
>=20

> If you are talking about user verification against MySQL then quite a
> number of us do it without intermediate files/databases. If
> you haven't
> spotted them there are several howtos linked to from the postfix web
> site. You may want to read them then ask more specific questions.

>=20

> Whether MySQL is necessarily the best way is another matter
> which cannot
> be answered with the information you've given.

I'm looking for Microsoft SQL lookup tables for relay domains (not by =
choice).

Aaron

Keith Matthews

unread,

Oct 20, 2003, 10:55:58 AM10/20/03

to

On Mon, 20 Oct 2003 15:48:17 +0100
"Aaron Roberts" <aa...@domicilium.com> wrote:

> Keith Matthews wrote:
> >
> > If you are talking about user verification against MySQL then quite
> > a number of us do it without intermediate files/databases. If
> > you haven't
> > spotted them there are several howtos linked to from the postfix web
> > site. You may want to read them then ask more specific questions.
> >

> > Whether MySQL is necessarily the best way is another matter
> > which cannot
> > be answered with the information you've given.
>
> I'm looking for Microsoft SQL lookup tables for relay domains (not by

> choice).
>

Didn't get that impression from what you wrote, probably I misread it.
ISTR someone trying it a year or so back, not sure what the result was,
they may not even have posted a conclusion.

I'd be inclined to look at UnixODBC as a means of driving the changes to
the database accessed by postfix. You'll need to do some digging though.