470,810 Members | 1,152 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

Data model for Postfix v2

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

Nov 23 '05 #1
3 1032
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)

Nov 23 '05 #2

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

Nov 23 '05 #3
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

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mark Adams | last post: by
5 posts views Thread by Henry Jordon | last post: by
6 posts views Thread by Sergey | last post: by
8 posts views Thread by subramanian100in | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.