Dear Friends,
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.
On 09/09/12 9:57 PM, jiten jha 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.
what exactly do you mean by 'merge all users' ?
On Sun, 2012-09-09 at 22:23 -0700, John R Pierce wrote:
On 09/09/12 9:57 PM, jiten jha 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.
what exactly do you mean by 'merge all users' ?
I assume he means create one map that knows about all users - the answer is yes.
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) .
On Mon, Sep 10, 2012 at 6:44 PM, Adam Tauno Williams <awilliam@whitemice.org
wrote:
On Sun, 2012-09-09 at 22:23 -0700, John R Pierce wrote:
On 09/09/12 9:57 PM, jiten jha 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.
what exactly do you mean by 'merge all users' ?
I assume he means create one map that knows about all users - the answer is yes.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
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 ??
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.
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.
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.
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.
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.
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
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:)
-
Adam Tauno Williams -
Frank Cox -
jiten jha -
John R Pierce -
Joseph L. Casale -
Les Mikesell -
Matt -
vogelke+centos＠pobox.com