how to configure postfix,dovecot mail server to save log in MySQL
I want to have the log of sender-name,receiver-name and deliver time in my SQL
but I don't have any idea that I should configure postfix or dovecot for that
and how to configure them
can anyone help me?
mysql postfix-mta dovecot
asked Nov 11 at 7:49
mohammad naser
82
add a comment |
I want to have the log of sender-name,receiver-name and deliver time in my SQL
but I don't have any idea that I should configure postfix or dovecot for that
and how to configure them
can anyone help me?
mysql postfix-mta dovecot
asked Nov 11 at 7:49
mohammad naser
82
add a comment |
I want to have the log of sender-name,receiver-name and deliver time in my SQL
but I don't have any idea that I should configure postfix or dovecot for that
and how to configure them
can anyone help me?
mysql postfix-mta dovecot
asked Nov 11 at 7:49
mohammad naser
82
I want to have the log of sender-name,receiver-name and deliver time in my SQL
but I don't have any idea that I should configure postfix or dovecot for that
and how to configure them
can anyone help me?
mysql postfix-mta dovecot
mysql postfix-mta dovecot
asked Nov 11 at 7:49
mohammad naser
82
asked Nov 11 at 7:49
mohammad naser
82
asked Nov 11 at 7:49
mohammad naser
82
asked Nov 11 at 7:49
mohammad naser
82
asked Nov 11 at 7:49
mohammad naser
82
82
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The most straightforward and non-intrusive way is to pass all the messages to the syslog. That functionality is already built-in for both postfix and dovecot. Say for dovecot configuration should look like that:
. . . .
log_path = syslog
syslog_facility = mail
. . . .
syslog can direct all the messages received from the certain binary to the pipe.
mail.* |/tmp/maillog.pipe
Then some script should read that pipe, parse lines and invoke the CLI mysql client that store the data into the database.
#!/bin/sh
while read LINE
do
# all the parsing should be written here
mysql -e "USE maillog; INSERT INTO $table VALUES ($a, $b, $c);"
# any additional proceeding can be performed here
done < /tmp/maillog.pipe
####
All that isn't a working solution but just a hint. Exact configuration and script code depend on your actual needs.
answered Nov 11 at 20:50
Kondybas
631512
what exactly i want is to have this log(sender,receiver,deliver time) in mysql to use in asp.net and i think the first step is to configure one of this two(postfix dovecot) just trying to figure out a simple way to have this report in my asp mvc application
– mohammad naser
Nov 21 at 10:08
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246810%2fhow-to-configure-postfix-dovecot-mail-server-to-save-log-in-mysql%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The most straightforward and non-intrusive way is to pass all the messages to the syslog. That functionality is already built-in for both postfix and dovecot. Say for dovecot configuration should look like that:
. . . .
log_path = syslog
syslog_facility = mail
. . . .
syslog can direct all the messages received from the certain binary to the pipe.
mail.* |/tmp/maillog.pipe
Then some script should read that pipe, parse lines and invoke the CLI mysql client that store the data into the database.
#!/bin/sh
while read LINE
do
# all the parsing should be written here
mysql -e "USE maillog; INSERT INTO $table VALUES ($a, $b, $c);"
# any additional proceeding can be performed here
done < /tmp/maillog.pipe
####
All that isn't a working solution but just a hint. Exact configuration and script code depend on your actual needs.
answered Nov 11 at 20:50
Kondybas
631512
what exactly i want is to have this log(sender,receiver,deliver time) in mysql to use in asp.net and i think the first step is to configure one of this two(postfix dovecot) just trying to figure out a simple way to have this report in my asp mvc application
– mohammad naser
Nov 21 at 10:08
add a comment |
The most straightforward and non-intrusive way is to pass all the messages to the syslog. That functionality is already built-in for both postfix and dovecot. Say for dovecot configuration should look like that:
. . . .
log_path = syslog
syslog_facility = mail
. . . .
syslog can direct all the messages received from the certain binary to the pipe.
mail.* |/tmp/maillog.pipe
Then some script should read that pipe, parse lines and invoke the CLI mysql client that store the data into the database.
#!/bin/sh
while read LINE
do
# all the parsing should be written here
mysql -e "USE maillog; INSERT INTO $table VALUES ($a, $b, $c);"
# any additional proceeding can be performed here
done < /tmp/maillog.pipe
####
All that isn't a working solution but just a hint. Exact configuration and script code depend on your actual needs.
answered Nov 11 at 20:50
Kondybas
631512
what exactly i want is to have this log(sender,receiver,deliver time) in mysql to use in asp.net and i think the first step is to configure one of this two(postfix dovecot) just trying to figure out a simple way to have this report in my asp mvc application
– mohammad naser
Nov 21 at 10:08
add a comment |
The most straightforward and non-intrusive way is to pass all the messages to the syslog. That functionality is already built-in for both postfix and dovecot. Say for dovecot configuration should look like that:
. . . .
log_path = syslog
syslog_facility = mail
. . . .
syslog can direct all the messages received from the certain binary to the pipe.
mail.* |/tmp/maillog.pipe
Then some script should read that pipe, parse lines and invoke the CLI mysql client that store the data into the database.
#!/bin/sh
while read LINE
do
# all the parsing should be written here
mysql -e "USE maillog; INSERT INTO $table VALUES ($a, $b, $c);"
# any additional proceeding can be performed here
done < /tmp/maillog.pipe
####
All that isn't a working solution but just a hint. Exact configuration and script code depend on your actual needs.
answered Nov 11 at 20:50
Kondybas
631512
The most straightforward and non-intrusive way is to pass all the messages to the syslog. That functionality is already built-in for both postfix and dovecot. Say for dovecot configuration should look like that:
. . . .
log_path = syslog
syslog_facility = mail
. . . .
syslog can direct all the messages received from the certain binary to the pipe.
mail.* |/tmp/maillog.pipe
Then some script should read that pipe, parse lines and invoke the CLI mysql client that store the data into the database.
#!/bin/sh
while read LINE
do
# all the parsing should be written here
mysql -e "USE maillog; INSERT INTO $table VALUES ($a, $b, $c);"
# any additional proceeding can be performed here
done < /tmp/maillog.pipe
####
All that isn't a working solution but just a hint. Exact configuration and script code depend on your actual needs.
answered Nov 11 at 20:50
Kondybas
631512
answered Nov 11 at 20:50
Kondybas
631512
answered Nov 11 at 20:50
Kondybas
631512
answered Nov 11 at 20:50
Kondybas
631512
631512
what exactly i want is to have this log(sender,receiver,deliver time) in mysql to use in asp.net and i think the first step is to configure one of this two(postfix dovecot) just trying to figure out a simple way to have this report in my asp mvc application
– mohammad naser
Nov 21 at 10:08
add a comment |
what exactly i want is to have this log(sender,receiver,deliver time) in mysql to use in asp.net and i think the first step is to configure one of this two(postfix dovecot) just trying to figure out a simple way to have this report in my asp mvc application
– mohammad naser
Nov 21 at 10:08
what exactly i want is to have this log(sender,receiver,deliver time) in mysql to use in asp.net and i think the first step is to configure one of this two(postfix dovecot) just trying to figure out a simple way to have this report in my asp mvc application
– mohammad naser
Nov 21 at 10:08
what exactly i want is to have this log(sender,receiver,deliver time) in mysql to use in asp.net and i think the first step is to configure one of this two(postfix dovecot) just trying to figure out a simple way to have this report in my asp mvc application
– mohammad naser
Nov 21 at 10:08
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246810%2fhow-to-configure-postfix-dovecot-mail-server-to-save-log-in-mysql%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
