Data model for Postfix v2

[John Sidney-Woollett]

Just asking in case anyone has this info...

Does anyone have a complete and working data model that allows Postfix
v2 to lookup domain/user lookups (including virtual domains and users).

I've got mostly working data model cobbled together over a period of
time, but I can't get my config/db model to allow mail forwarding for
local users to a remote mail address (aliasing).

I know that this is just a config issue, but I think the combination of
my data model and lookup table configs (in main.cf) and sql statements
is screwed.

If anyone has a decent model that they'd be willing to share with their
main.cf table lookup entries (that use the db) and the extra .cf files
that detail the sql statements used, could they let me know?

Thanks

John Sidney-Woollett

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[John Sidney-Woollett]

Thanks for the link - I think I've have seen this before.

I'm really trying to find a definitive covers all bases data model that
will provide the functionality I need. My DB data model/postfix config
is now so butchered that I wanted a "good" data model to start afresh with.

I'll take a fresh look at this, it may provide the answers to my problems.

Thanks for your help.

John Sidney-Woollett

Paul Thomas wrote:

On 27/07/2004 08:35 John Sidney-Woollett wrote:

Just asking in case anyone has this info...

Does anyone have a complete and working data model that allows Postfix
v2 to lookup domain/user lookups (including virtual domains and users).

Googling came up with

http://www.high5.net/howto/

which explains how to set it up with MySQL. Maybe you could use that as
a starting point?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Paul Thomas]

On 27/07/2004 08:35 John Sidney-Woollett wrote:

Just asking in case anyone has this info...

Does anyone have a complete and working data model that allows Postfix
v2 to lookup domain/user lookups (including virtual domains and users).

Googling came up with

http://www.high5.net/howto/

which explains how to set it up with MySQL. Maybe you could use that as a
starting point?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Marius Andreiana]

On Tue, 2004-07-27 at 08:35 +0100, John Sidney-Woollett wrote:

Does anyone have a complete and working data model that allows Postfix
v2 to lookup domain/user lookups (including virtual domains and users).

You know about web-cyradm?
http://www.tldp.org/HOWTO/Postfix-Cy...-cyradm-HOWTO/
use the same setup, a pam_pgsql.so module (does it exist?) and the pgsql
database for web-cyradm.

--
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match