By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

QMail

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
* 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, (503) 667-4564

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

P: n/a
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

Nov 23 '05 #3

P: n/a
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

Nov 23 '05 #4

P: n/a
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.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

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

Nov 23 '05 #5

P: n/a
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-----

Nov 23 '05 #6

P: n/a
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

Nov 23 '05 #7

P: n/a
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.
Nov 23 '05 #8

P: n/a
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.
Nov 23 '05 #9

P: n/a
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

Nov 23 '05 #10

P: n/a
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

Nov 23 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.