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 ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Steven Klassen]

* Eric <er***@conceptid.ca> [2004-10-27 14:14:25 -0400]:

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

This looks informative:

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

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, [phone]

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

[Russell Smith]

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/
---------------------------(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

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

[Tino Wildenhain]

Hi,

Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:

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/

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]

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.

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

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

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
[phone] - [e-mail] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

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

[Robby Russell]

On Wed, 2004-10-27 at 14:14 -0400, 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...
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:
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.

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

You will

hth,

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

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

iD8DBQBBg8oO0QaQZBaqXgwRAioUAJ4v0opG2zWyBcPw0pU5zp FRWAUakwCgntY/
+ldTPAT5+4fwNyFEGS42uVc=
=4vuc
-----END PGP SIGNATURE-----

[Tino Wildenhain]

Hi,

Am Sa, den 30.10.2004 schrieb Joshua D. Drake um 18:25:

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.

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.

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 ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Chris Browne]

ti**@wildenhain.de (Tino Wildenhain) writes:

Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:

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/

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.

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.com" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/linuxxian.html
A VAX is virtually a computer, but not quite.

[Chris Browne]

ti**@wildenhain.de (Tino Wildenhain) writes:

Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:

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/

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.

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.com" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/linuxxian.html
A VAX is virtually a computer, but not quite.

[Tino Wildenhain]

Am Di, den 02.11.2004 schrieb Chris Browne um 0:05:

ti**@wildenhain.de (Tino Wildenhain) writes:

Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:

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/
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.

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.

_I_ know ;)
What _would_ seem sensible would be to use PG for the data store for
an IMAP server.
that is, what dbmail tries to do.
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...

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]

Am Di, den 02.11.2004 schrieb Chris Browne um 0:05:

ti**@wildenhain.de (Tino Wildenhain) writes:

Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:

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/
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.

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.

_I_ know ;)
What _would_ seem sensible would be to use PG for the data store for
an IMAP server.
that is, what dbmail tries to do.
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...

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

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