Re: 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

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 |
+------------------------------+---------------------------------------------+

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Tue, 27 Jul 2004, Paul Thomas 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?

No way...

There is a problem with PostgreSQL authentication there which I could not
solve since 15 days. There must be something different, but what? :)

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBBiEOtl86P3SPfQ4RAnsyAJ9PFC4IkCysz1Ovd9RMOPKppbmGgACg7W/0
1mt9e4W/u8MYGPmHipTcc/4=
=DJK5
-----END PGP SIGNATURE-----

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?
>

I don't have any problem getting postfix to talk to postgres - I just
have a problem getting postfix to do what i want! :)

John Sidney-Woollett

Devrim GUNDUZ wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Hi,
>
> On Tue, 27 Jul 2004, Paul Thomas 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?
>
>
> No way...
>
> There is a problem with PostgreSQL authentication there which I could not
> solve since 15 days. There must be something different, but what? :)
>
> Regards,
> - --
> Devrim GUNDUZ
> devrim~gunduz.org devrim.gunduz~linux.org.tr
> http://www.tdmsoft.com
> http://www.gunduz.org
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
> iD8DBQFBBiEOtl86P3SPfQ4RAnsyAJ9PFC4IkCysz1Ovd9RMOPKppbmGgACg7W/0
> 1mt9e4W/u8MYGPmHipTcc/4=
> =DJK5
> -----END PGP SIGNATURE-----
>

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-Cyrus-Web-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