headers
Darvin Denmian | 4 May 2009 22:13
Picon

Dbmail Hybrid


Hello,

i need to know if is possible to construct something like:

DBmail stores Message and the attachments of messages are stored outside
Mysql DB.

Thanks. !!!

-----
Free your mind.
--

-- 
View this message in context: http://www.nabble.com/Dbmail-Hybrid-tp23322602p23322602.html
Sent from the dbmail users mailing list archive at Nabble.com.
Permalink | Reply | 23 comments |
headers
Aaron Stone | 4 May 2009 22:27
Gravatar

Re: Dbmail Hybrid

You could do this with a script or small LMTP server that sits between the
MTA and DBMail, and removes certain MIME attachments and replaces them with
e.g. a url to a web server where the attachment is now stores. I know of at
least one commercial product that does this, and there might be some open
source code to do the same. DBMail does not itself natively support doing
such a thing.

Aaron

On Mon, 4 May 2009 13:13:58 -0700 (PDT), Darvin Denmian
<darvin.denmian <at> gmail.com> wrote:
> Hello,
> 
> i need to know if is possible to construct something like:
> 
> DBmail stores Message and the attachments of messages are stored outside
> Mysql DB.
> 
> Thanks. !!!
> 
> -----
> Free your mind.
Permalink | Reply | 1 comment |
headers
Josh Marshall | 5 May 2009 01:07
Favicon

Re: Dbmail Hybrid

I believe we've all gone over this before, but remember if you do
something like this, you lose or complicate redundancy.

For example, our dbmail installation, which has over 4500 mailboxes and
100,000 emails/week has three mail servers and two database servers. The
database servers are MySQL in a master-master replication setup, with
one set as the active using ucarp (it's not smart to load balance
database servers with dbmail). The three mail servers are load balanced
with LVS on the firewalls. We have a backup database server that
replicates off a particular master, which is stopped daily to take a
snapshot, then restarted again. This takes backup load off the primary
database server.

If you store the messages outside the database and wanted redundancy
then you would have to share them on a file server using something like
NFS. This would add complexity, and I believe it would not increase
speed or availability.

A few other questions to ask yourself before doing such a thing include:

* Will it change the amount of disk space required? (Not really)
* What is your backup strategy? You may have to shut down the server to
get a true snapshot.
* What is your recovery strategy? Can you do a point-in-time recovery?
(NO, files are created and deleted)

Everything I see is that to pull the message contents out of the
database and store in the filesystem:

* Adds complexity to the creation and deletion of emails
(Continue reading)

Permalink | Reply | 0 comments |
headers
Michael Monnerie | 5 May 2009 07:36
Picon

Re: Dbmail Hybrid

On Montag 04 Mai 2009 Darvin Denmian wrote:
> DBmail stores Message and the attachments of messages are stored
> outside Mysql DB.

Use cyrus as your mailserver, then everything is a file. A mixture of 
SQL+file combines the disadvantages of both, not the advantages.

mfg zmi
--

-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4
Permalink | Reply | 20 comments |
headers
Jorge Bastos | 5 May 2009 11:15
Picon

QUOTA Question

Hi there,

 

A simple questions:

The QUOTA is calculated for every folders and every messages on them, or just INBOX?

 

Jorge,

 

 

_______________________________________________
DBmail mailing list
DBmail <at> dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Permalink | Reply | 0 comments |
headers
Paul J Stevens | 5 May 2009 13:07
Picon
Favicon
Gravatar

Re: QUOTA Question


quota is calculated for all folders that belong to a user.

Jorge Bastos wrote:
> Hi there,
> 
>  
> 
> A simple questions:
> 
> The QUOTA is calculated for every folders and every messages on them, or
> just INBOX?
> 
>  
> 
> Jorge,
> 
>  
> 
>  
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> DBmail mailing list
> DBmail <at> dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

--

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
Permalink | Reply | 0 comments |
headers
Darvin Denmian | 5 May 2009 21:45
Picon

Re: Dbmail Hybrid

Thanks for all replies

On Tue, May 5, 2009 at 2:36 AM, Michael Monnerie
<michael.monnerie <at> is.it-management.at> wrote:
> On Montag 04 Mai 2009 Darvin Denmian wrote:
>> DBmail stores Message and the attachments of messages are stored
>> outside Mysql DB.
>
> Use cyrus as your mailserver, then everything is a file. A mixture of
> SQL+file combines the disadvantages of both, not the advantages.
>
> mfg zmi
> --
> // Michael Monnerie, Ing.BSc    -----      http://it-management..at
> // Tel: 0660 / 415 65 31                      .network.your.ideas.
> // PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
> // Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
> // Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4
>
> _______________________________________________
> DBmail mailing list
> DBmail <at> dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
Permalink | Reply | 19 comments |
headers
Jorge Bastos | 5 May 2009 22:06
Picon

Offtopic, Question about FTTH

People & Paul/Aaron,

Sorry about this off topic, allow me to ask a few things just for my knowledge:

 

·         Who has FTTH?

·         How is the FTTH implementation going on your country?

·         In case someone already has, speeds? Download & Upload? Prices? In Euro if possible.

·         Differences for the FTTH speeds between the destiny, for home and for company’s?

 

Sorry for this, I’m very curious on this info, since I’m watching a big revolution in my country (Portugal) right now, on the implementation of FTTH.

 

Thanks,

Jorge,

_______________________________________________
DBmail mailing list
DBmail <at> dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Permalink | Reply | 0 comments |
headers
Michael Monnerie | 5 May 2009 23:07
Picon

Re: Offtopic, Question about FTTH

On Dienstag 05 Mai 2009 Jorge Bastos wrote:
> Who has FTTH?

In Austria: About 0%. Lots of cable TV+Internet, giving speeds 20Mb/2Mb 
up/down like for me :-)

mfg zmi
--

-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4
Permalink | Reply | 0 comments |
headers
Marc Dirix | 6 May 2009 15:19
Picon
Favicon
Gravatar

mysterious from-address

Hi

I'm on 2.2.11.

Often some customers receive emails with incorrect (or strangely 
encoded) From headers. This From header then gets mangled
at some point between reception and delivery. 

The newly formed From header has been mangled, and
 <at> host.domain of the mailserver has been added.
See here a resulting header:

=?iso-8859-1?Q?Jos=E9_M._Joao?= <at> gamma.electronics-design.nl

If now the customers replies to this, obviously the email is
not delivered to the original sender.

Is it possible dbmail at some point adds the header?
Er should I be looking through spamassassin or postfix?

Regards,

Marc
Permalink | Reply | 9 comments |

Gmane