QMail

[Eric]

Is there something to interface postgreSQL with QMail to store mails in
pgsql instead of using mbox or maildir?

Or maybe it's not a good idea to do that?

I think there is some adavantages...



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

[Steven Klassen]

Re: QMail

* Eric <ericg@concepti d.ca> [2004-10-27 14:14:25 -0400]:
[color=blue]
> Is there something to interface postgreSQL with QMail to store mails
> in pgsql instead of using mbox or maildir?[/color]

This looks informative:

http://qmail-sql.digibel.be/

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

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

[Russell Smith]

Re: QMail

On Thu, 28 Oct 2004 04:14 am, Eric wrote:[color=blue]
> Is there something to interface postgreSQL with QMail to store mails in
> pgsql instead of using mbox or maildir?
>
> Or maybe it's not a good idea to do that?
>
> I think there is some adavantages...[/color]

also look at http://www.dbmail.org/[color=blue]
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postg resql.org so that your
> message can get through to the mailing list cleanly
>
>[/color]

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tino Wildenhain]

Re: QMail

Hi,

Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:[color=blue]
> On Thu, 28 Oct 2004 04:14 am, Eric wrote:[color=green]
> > Is there something to interface postgreSQL with QMail to store mails in
> > pgsql instead of using mbox or maildir?
> >
> > Or maybe it's not a good idea to do that?
> >
> > I think there is some adavantages...[/color]
>
> also look at http://www.dbmail.org/[/color]

Do you know anything else? dbmail seems too much mysql
centric while at least providing access to postgresql
which is a pro. The storage of mails in big chunks
seems less then ideal and you need clever views to
get local part and host seperately.

Regards
Tino


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Joshua D. Drake]

Re: QMail

[color=blue]
>Do you know anything else? dbmail seems too much mysql
>centric while at least providing access to postgresql
>which is a pro. The storage of mails in big chunks
>seems less then ideal and you need clever views to
>get local part and host seperately.
>
>[/color]
Hello,

We were able to put something together fairly easily in Perl
which has excellent (if you like perl) facilities for dealing
with multi-part mime etc...

Sorry it was for a customer so we can't provide source. However
I know it only took us about 3 days and it has been in place for
2 years without issue.

Sincerely,

Joshua D. Drake

[color=blue]
>Regards
>Tino
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>[/color]


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Robby Russell]

Re: QMail

On Wed, 2004-10-27 at 14:14 -0400, Eric wrote:[color=blue]
> Is there something to interface postgreSQL with QMail to store mails in
> pgsql instead of using mbox or maildir?
>
> Or maybe it's not a good idea to do that?
>
> I think there is some adavantages...[/color]

We use QMail for our vhosting and it works quite well. We have plans to
move the storage into PostgreSQL at some point.

This is on the QMail.org site:
[color=blue]
> Mail2DB -- Store incoming mail in a PostgreSQL database. Mail2DB is
> suitable for putting in a .qmail/.forward file and will archive e-mail
> to a SQL database. Currently, there is only the storage component.
> [/color]

ftp://ftp.tummy.com/pub/tummy/Mail2DB/

You will

hth,

-Robby


--
/*************** *************** *********
* Robby Russell | Owner.Developer .Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | robby@planetarg on.com
* 503.351.4730 | blog.planetargo n.com
* PHP/PostgreSQL Hosting & Development
* --- Now supporting PHP5 ---
*************** *************** **********/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQBBg8oO0Qa QZBaqXgwRAioUAJ 4v0opG2zWyBcPw0 pU5zpFRWAUakwCg ntY/
+ldTPAT5+4fwNyF EGS42uVc=
=4vuc
-----END PGP SIGNATURE-----

[Tino Wildenhain]

Re: QMail

Hi,

Am Sa, den 30.10.2004 schrieb Joshua D. Drake um 18:25:[color=blue][color=green]
> >Do you know anything else? dbmail seems too much mysql
> >centric while at least providing access to postgresql
> >which is a pro. The storage of mails in big chunks
> >seems less then ideal and you need clever views to
> >get local part and host seperately.
> >
> >[/color]
> Hello,
>
> We were able to put something together fairly easily in Perl
> which has excellent (if you like perl) facilities for dealing
> with multi-part mime etc...
>
> Sorry it was for a customer so we can't provide source. However
> I know it only took us about 3 days and it has been in place for
> 2 years without issue.[/color]

Thx, even with python the email/mime/multipart handling is no
issue. The problem comes with IMAP _server_ support. Client
libs are available too. Does your solution provide IMAP
access with ordinary mail clients?

Regards
Tino


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

[Chris Browne]

Re: QMail

tino@wildenhain .de (Tino Wildenhain) writes:[color=blue]
> Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:[color=green]
>> On Thu, 28 Oct 2004 04:14 am, Eric wrote:[color=darkred]
>> > Is there something to interface postgreSQL with QMail to store mails in
>> > pgsql instead of using mbox or maildir?
>> >
>> > Or maybe it's not a good idea to do that?
>> >
>> > I think there is some adavantages...[/color]
>>
>> also look at http://www.dbmail.org/[/color]
>
> Do you know anything else? dbmail seems too much mysql
> centric while at least providing access to postgresql
> which is a pro. The storage of mails in big chunks
> seems less then ideal and you need clever views to
> get local part and host seperately.[/color]

I seriously question the merits of interfacing qmail with PostgreSQL;
qmail is "merely" an MTA, and is basically where mail would get
_queued_ until it is delivered to someone's 'mailbox.'

qmail isn't a 'mailbox manager,' so using PG as the data store for
qmail just doesn't seem sensible.

What _would_ seem sensible would be to use PG for the data store for
an IMAP server.

The most relevant one would seem to be Decimail:

<http://decimail.org/>

Decimail...

* Is an IMAP / SMTP email server.
* Uses a PostgreSQL database to store the messages.
* Defines mailboxes using SQL queries.

The way it handles mailboxes is very interesting...
--
let name="cbbrowne" and tld="cbbrowne.c om" in String.concat "@" [name;tld];;

http://www.ntlug.org/~cbbrowne/linuxxian.html

A VAX is virtually a computer, but not quite.

[Chris Browne]

Re: QMail

tino@wildenhain .de (Tino Wildenhain) writes:[color=blue]
> Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:[color=green]
>> On Thu, 28 Oct 2004 04:14 am, Eric wrote:[color=darkred]
>> > Is there something to interface postgreSQL with QMail to store mails in
>> > pgsql instead of using mbox or maildir?
>> >
>> > Or maybe it's not a good idea to do that?
>> >
>> > I think there is some adavantages...[/color]
>>
>> also look at http://www.dbmail.org/[/color]
>
> Do you know anything else? dbmail seems too much mysql
> centric while at least providing access to postgresql
> which is a pro. The storage of mails in big chunks
> seems less then ideal and you need clever views to
> get local part and host seperately.[/color]

I seriously question the merits of interfacing qmail with PostgreSQL;
qmail is "merely" an MTA, and is basically where mail would get
_queued_ until it is delivered to someone's 'mailbox.'

qmail isn't a 'mailbox manager,' so using PG as the data store for
qmail just doesn't seem sensible.

What _would_ seem sensible would be to use PG for the data store for
an IMAP server.

The most relevant one would seem to be Decimail:

<http://decimail.org/>

Decimail...

* Is an IMAP / SMTP email server.
* Uses a PostgreSQL database to store the messages.
* Defines mailboxes using SQL queries.

The way it handles mailboxes is very interesting...
--
let name="cbbrowne" and tld="cbbrowne.c om" in String.concat "@" [name;tld];;

http://www.ntlug.org/~cbbrowne/linuxxian.html

A VAX is virtually a computer, but not quite.

[Tino Wildenhain]

Re: QMail

Am Di, den 02.11.2004 schrieb Chris Browne um 0:05:[color=blue]
> tino@wildenhain .de (Tino Wildenhain) writes:[color=green]
> > Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:[color=darkred]
> >> On Thu, 28 Oct 2004 04:14 am, Eric wrote:
> >> > Is there something to interface postgreSQL with QMail to store mails in
> >> > pgsql instead of using mbox or maildir?
> >> >
> >> > Or maybe it's not a good idea to do that?
> >> >
> >> > I think there is some adavantages...
> >>
> >> also look at http://www.dbmail.org/[/color]
> >
> > Do you know anything else? dbmail seems too much mysql
> > centric while at least providing access to postgresql
> > which is a pro. The storage of mails in big chunks
> > seems less then ideal and you need clever views to
> > get local part and host seperately.[/color]
>
> I seriously question the merits of interfacing qmail with PostgreSQL;
> qmail is "merely" an MTA, and is basically where mail would get
> _queued_ until it is delivered to someone's 'mailbox.'
>
> qmail isn't a 'mailbox manager,' so using PG as the data store for
> qmail just doesn't seem sensible.[/color]

_I_ know ;)
[color=blue]
> What _would_ seem sensible would be to use PG for the data store for
> an IMAP server.[/color]

that is, what dbmail tries to do.
[color=blue]
> The most relevant one would seem to be Decimail:
>
> <http://decimail.org/>
>
> Decimail...
>
> * Is an IMAP / SMTP email server.
> * Uses a PostgreSQL database to store the messages.
> * Defines mailboxes using SQL queries.
>
> The way it handles mailboxes is very interesting...[/color]

Indeed, looks conceptional perfect. Lets try it.
Thanks for the hint!

Regards
Tino


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tino Wildenhain]

Re: QMail

Am Di, den 02.11.2004 schrieb Chris Browne um 0:05:[color=blue]
> tino@wildenhain .de (Tino Wildenhain) writes:[color=green]
> > Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:[color=darkred]
> >> On Thu, 28 Oct 2004 04:14 am, Eric wrote:
> >> > Is there something to interface postgreSQL with QMail to store mails in
> >> > pgsql instead of using mbox or maildir?
> >> >
> >> > Or maybe it's not a good idea to do that?
> >> >
> >> > I think there is some adavantages...
> >>
> >> also look at http://www.dbmail.org/[/color]
> >
> > Do you know anything else? dbmail seems too much mysql
> > centric while at least providing access to postgresql
> > which is a pro. The storage of mails in big chunks
> > seems less then ideal and you need clever views to
> > get local part and host seperately.[/color]
>
> I seriously question the merits of interfacing qmail with PostgreSQL;
> qmail is "merely" an MTA, and is basically where mail would get
> _queued_ until it is delivered to someone's 'mailbox.'
>
> qmail isn't a 'mailbox manager,' so using PG as the data store for
> qmail just doesn't seem sensible.[/color]

_I_ know ;)
[color=blue]
> What _would_ seem sensible would be to use PG for the data store for
> an IMAP server.[/color]

that is, what dbmail tries to do.
[color=blue]
> The most relevant one would seem to be Decimail:
>
> <http://decimail.org/>
>
> Decimail...
>
> * Is an IMAP / SMTP email server.
> * Uses a PostgreSQL database to store the messages.
> * Defines mailboxes using SQL queries.
>
> The way it handles mailboxes is very interesting...[/color]

Indeed, looks conceptional perfect. Lets try it.
Thanks for the hint!

Regards
Tino


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend