Read to POP3 without delete messages
Hi I modified PostMasterPOP3.pl in order to read email from POP3 server without deleting or reload them. It's simply a new table called messages_uidl with these fields uidl: varchar(100) timestamp: date with one more condition in code before checking mail size It checks the message uidl in the pop3 mailbox with uidl stored in the table and retrieves only new messages. When a new message is retrieved it adds the new uidl in the table. Are someone interested in this modify? How can I share my new feature?
Hi, On Sa, Feb 10, 2007 at 08:52:24 +0100, Chef Tony wrote:
I modified PostMasterPOP3.pl in order to read email from POP3 server without deleting or reload them.
Cool :).
It's simply a new table called messages_uidl with these fields
uidl: varchar(100) timestamp: date
with one more condition in code before checking mail size
It checks the message uidl in the pop3 mailbox with uidl stored in the table and retrieves only new messages. When a new message is retrieved it adds the new uidl in the table.
Can every POP3 server deal with this per default?
Are someone interested in this modify? How can I share my new feature?
Yes, we'd be interested in this patch. Can you open a new task on http://bugs.otrs.org and include the patch in the report? You can categorize it as "Enhancement". Kind regards and thanks for your help, Christian -- ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818-0 :: Fax: +49 (0) 9421 56818-18 http://www.otrs.com/ :: Communication with success!
Christian Schoepplein ha scritto:
It checks the message uidl in the pop3 mailbox with uidl stored in the table and retrieves only new messages. When a new message is retrieved it adds the new uidl in the table.
Can every POP3 server deal with this per default?
I think so because "uidl" is a standard command for POP3 servers and it's native in Perl.
Yes, we'd be interested in this patch. Can you open a new task on http://bugs.otrs.org and include the patch in the report? You can categorize it as "Enhancement".
Ok...I'll try to do that
On Mon, 12 Feb 2007 08:30:07 +0100 Christian Schoepplein wrote:
On Sa, Feb 10, 2007 at 08:52:24 +0100, Chef Tony wrote:
When a new message is retrieved it adds the new uidl in the table.
Can every POP3 server deal with this per default?
UIDL is marked as an "optional command" in RFC1939[1] so the answer to your question is "certainly not". However, most current POP3 implementations do support it. [1] http://www.ietf.org/rfc/rfc1939.txt -- Denis Jedig syneticon networks GbR
Denis Jedig ha scritto:
UIDL is marked as an "optional command" in RFC1939[1] so the answer to your question is "certainly not". However, most current POP3 implementations do support it.
I tried this command with Microsoft Exchange and qmail and a lot of internet provider's pop servers and all response to uidl command. UIDLs are very different from one service to others. I'm trying the modified version of PostMasterPOP3 in my company with Exchange server and it seems to work correctly, but it's important to use in mysql a case sensitive collation.
On Wed, Feb 14, 2007 at 11:19:39AM +0100, Chef Tony wrote:
Denis Jedig ha scritto:
UIDL is marked as an "optional command" in RFC1939[1] so the answer to your question is "certainly not". However, most current POP3 implementations do support it.
I tried this command with Microsoft Exchange and qmail and a lot of internet provider's pop servers and all response to uidl command. UIDLs are very different from one service to others. I'm trying the modified version of PostMasterPOP3 in my company with Exchange server and it seems to work correctly, but it's important to use in mysql a case sensitive collation.
Hmm. If it is not a general standard which is supported by all pop3 servers, we can not integrate it in the standard OTRS releases :(. -- Christian -- ((otrs)) :: OTRS GmbH :: Norsk-Data-Strasse 1 :: 61352 Bad Homburg Fon: +49 (0) 6172 681988 10 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftsführer: André Mindermann, Martin Edenhofer Handelsregister: HRB 9452 Bad Homburg Steuernummer: 003/240/97521
On Wed, 14 Feb 2007 11:22:34 +0100 Christian Schoepplein wrote:
Denis Jedig ha scritto:
UIDL is marked as an "optional command" in RFC1939[1]
Hmm. If it is not a general standard which is supported by all pop3 servers, we can not integrate it in the standard OTRS releases :(.
It is basically a standard, as it is defined with the POP3 protocol. It is surely optional, but many other things in OTRS are, S/MIME for example. However, I would recommend to add two additional boolean parameters in regard to the UIDL functionality: "use UIDL" and "delete messages after fetching". Some broken UIDL implementations do change the UIDL occasionally, resulting in multiple deliveries of the same message, which is rather undesirable with OTRS. I believe that as of current, people wanting UIDL functionality with POP3 are using fetchmail/procmail/Piping-to-Postmaster constellations. -- Denis Jedig syneticon networks GbR http://syneticon.net/service/
Denis Jedig ha scritto:
However, I would recommend to add two additional boolean parameters in regard to the UIDL functionality: "use UIDL" and "delete messages after fetching". Sure, I think this feature must be an option, users must be free to choose their favourite behaviour for otrs. I think it may not be so difficult the implementation of parameters, but I think I have to study deeper the code to do that
Christian Schoepplein ha scritto: I modified a little the table creation script because the lenght of the field "uild" was 50 chars, but rfc specifies that UIDLs must be from 1 to 70 chars "The unique-id of a message is an arbitrary server-determined string, consisting of one to 70 characters in the range 0x21 to 0x7E, which uniquely identifies a message within a maildrop and which persists across sessions." I have already modified the script on bugzilla
participants (3)
-
Chef Tony -
Christian Schoepplein -
Denis Jedig