I mean I have postfix server i want to merge all mail and users in mysql.
On Tue, Sep 11, 2012 at 11:04 AM, John R Pierce <pierce@hogranch.com> wrote:
> On 09/10/12 9:13 PM, jiten jha wrote:
> > my answer is not. I mean I have 400 user with his/her mails. So can I
> shift
> > or move all mails and users in MYSQL (database) .
>
>
> shift or move all mail and users from where to where ? do you mean
> between two servers, or ??
>
>
>
> --
> john r pierce N 37, W 122
> santa cruz ca mid-left coast
>
> _______________________________________________
> CentOS mailing list
> CentOS@centos.org
> http://lists.centos.org/mailman/listinfo/centos
>
On Tue, 11 Sep 2012 12:27:34 +0530
jiten jha wrote:
> I mean I have postfix server i want to merge all mail and users in mysql.
Define your purpose. That's not something that one would normally do.
--
MELVILLE THEATRE ~ Real D 3D Digital Cinema ~ www.melvilletheatre.com
www.creekfm.com - FIFTY THOUSAND WATTS of POW WOW POWER!
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
09-11-2012, 07:18 AM
John R Pierce
postfix mail server
On 09/10/12 11:57 PM, jiten jha wrote:
> I mean I have postfix server i want to merge all mail and users in mysql.
and we've gone ful circle, without you answering our questions or.
the word 'merge' usually means to combine many pieces into one, like to
combine a bunch of seperate files or folders into a single file.
previously you said 'shift or move', you need to tell us what you want
to move from where to where, precisely, before we have a clue what
you're talking about.
also, postfix is a mail transfer agent, it doesn't implement the user
reader side like IMAP or POP, it just transfers messages. another
package, such as dovecot or cyrus, is used as a client agent for reading
email via pop or imap protocols, and its in one of these packages that
the email folder format is normally defined.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
09-11-2012, 09:01 PM
Les Mikesell
postfix mail server
On Tue, Sep 11, 2012 at 2:18 AM, John R Pierce <pierce@hogranch.com> wrote:
>
>
> also, postfix is a mail transfer agent, it doesn't implement the user
> reader side like IMAP or POP, it just transfers messages. another
> package, such as dovecot or cyrus, is used as a client agent for reading
> email via pop or imap protocols, and its in one of these packages that
> the email folder format is normally defined.
On the postfix side of things you can probably configure the mail
addresses controlling future deliveries to do whatever you want.
There are many options and the details will depend on what you have
and what you want. Already-delivered mail messages are no longer
controlled by postfix. There are programs to move messages from one
imap account to another if you need to move between servers or server
types. Imapsync will do one account at a time, given the servers,
logins, and passwords. I think the cyrus tools have something to move
all accounts.
--
Les Mikesell
lesmikesell@gmail.com
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
09-13-2012, 09:33 PM
Matt
postfix mail server
> I have postfix mail server it is running fine . In my mail server all users
> are virtual. Can I merge all users with his/her mails in mysql or
> postgresql database.
Does this mean you want the account details and all messages all
stored in mysql rather then maildir or mbox format? Is that commonly
done? Would be a very large database.
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
09-14-2012, 04:05 AM
jiten jha
postfix mail server
I want to create database for stores mail and users there.
On Fri, Sep 14, 2012 at 3:03 AM, Matt <matt.mailinglists@gmail.com> wrote:
> > I have postfix mail server it is running fine . In my mail server all
> users
> > are virtual. Can I merge all users with his/her mails in mysql or
> > postgresql database.
>
> Does this mean you want the account details and all messages all
> stored in mysql rather then maildir or mbox format? Is that commonly
> done? Would be a very large database.
> _______________________________________________
> CentOS mailing list
> CentOS@centos.org
> http://lists.centos.org/mailman/listinfo/centos
>
On Thu, Sep 13, 2012 at 11:05 PM, jiten jha <jitenjha11@googlemail.com> wrote:
> I want to create database for stores mail and users there.
I think you would need 3rd party software to put the mail store in a
mysql or postgresql database. Is there some reason you want to do
that instead of using the standard dovecot or cyrus packages that
store messages in the filesystem? Cyrus scales well and doesn't
require email uses to be system users.
--
Les Mikesell
lesmikesell@gmail.com
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
09-17-2012, 06:45 PM
postfix mail server
>> On Thu, Sep 13, 2012 at 11:05 PM, <jitenjha11@googlemail.com> wrote:
J> I want to create database for stores mail and users there.
>> On Mon, 17 Sep 2012 11:02:11 -0500, <lesmikesell@gmail.com> replied:
L> I think you would need 3rd party software to put the mail store in a
L> mysql or postgresql database.
If you want a list of good reasons to NOT use a database for email,
have a look at
http://www.memoryhole.net/~kyle/databaseemail.html
--
Karl Vogel I don't speak for the USAF or my company
The little boat gently drifted across the pond exactly the way a bowling
ball wouldn't. --bizarre expressions found in English papers
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
09-17-2012, 06:51 PM
"Joseph L. Casale"
postfix mail server
> If you want a list of good reasons to NOT use a database for email,
> have a look at
> http://www.memoryhole.net/~kyle/databaseemail.html
The funny part is at scale, all the reasons he has against mail in a db
are the exclusive list of why I think its a good idea, not to mention it _is_
being done reliable for long enough to prove so.
I'd say ymmv, but I think I'd have to say _all_ our mileage varies from his
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
09-18-2012, 02:25 AM
postfix mail server
>> On Mon, 17 Sep 2012 20:57:25 +0200,
>> Reindl Harald <h.reindl@thelounge.net> said:
R> point 3 [Backup must be easy] is bullshit. have fun tar/rsync
R> maildir/mbox CONSISTENT while the server is up. nothing easier than
R> that with database-replication.
Backing up maildirs doesn't require any downtime because a maildir is
atomic in every way that matters. It uses filename and location to
indicate message status. If you want to back up *live* Maildir folders,
either one of these will do:
Unless your users are in the habit of editing messages, Maildir files
don't get modified; they're created, renamed and deleted. When users do
edit messages, the mail client normally creates a new one and deletes
the old one. As a result, rsync isn't the most efficient way to sync
maildirs -- when status changes occur, rsync sees that a new file exists
and an old one is gone. It doesn't know that the file was renamed.
The only real issue when backing up a Maildir using tar/rsync is speed.
Neither method is great when backing up a large number of small files, as
many people have observed in the past. Common workarounds:
* using dump/restore (requires a quiescent filesystem), or
* using tar/scp for the first Maildir backup and using rsync afterwards.
All you need for this case is an SMTP server that understands Maildirs.
Contrast this with an RDB, where you absolutely need consistent and quiet
files to do a successful backup. If you want DB replication, then you need:
* an SMTP server, plus
* an RDB on the mailserver, plus
* a replica of the DB on another server.
Which setup is easier to create and maintain?
--
Karl Vogel I don't speak for the USAF or my company
She made me a mix tape called "Sorry I Barfed On Your Comforter".
--Jimmy Fallon, #thatsmyroommate tweets, 14 Sep 2012
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
postfix mail server
