> > Hello Mario, > > On 2015-02-03 10:09, [email protected] wrote: > > > > i've just setup a demo system based on latest debian stable with > > mailpiler 1.1.0. > > Now i wanted to import a bunch of mails from our old archive for > > further testing but i'm stuck here. > > Our current software for mailarchive is called "openbenno" and it > > imports mails via imap from an Exchange 2010 mailbox > > and stores the them as .gz files to the files system. So I took a few, > > gunzipped them and used "pilerimport -d" to > > import. All mails showed up in the GÙI but most of the messages didn't > > got the "From:" field filled. It is just > > empty. So I took pilertest and ran it with the files I imported > > earlier and got the same results. Only on a few > > the "From:" field was detected correct. > > After some time I recognized that all mails that were imported correct > > got imported to the old system via POP3 > > from Exchange 2003. All failing mails came via IMAP from our Exchange > > 2010 system we migrated to. > > > > I've attached two anonymised mails, one of eatch type. > > Anyone has an idea on how to get those IMAP mails imported correctly? > > what mysql version do you have? A user reported that he had the same(?) > or similar issues using stock mysql 5.6 (the oracle version). In his > case > a downgrade to mysql 5.5 was the solution, because 5.6 had a hard time > inserting utf-8 characters to the sph_index table. > Note that both of your attached files look correct. > > Janos > >
Hey Janos, just checked the version, here the output of "dpkg-query -W mysql-server" : mysql-server 5.5.41-0+wheezy1 As you can see 5.6 shouldn't be the problem ;-) When I use pilertest with that privious attached mails I get this output : For the POP3 message : --- locale: de_DE.UTF-8 build: 884 parsing... post parsing... message-id: <4b47ae6735f23b4fab2c4fb994d7a9b50a110...@exchangeserver.ourdomain.de> / 85f201fc14ac70cde573523f55d895c84fef6fac172aeac97f4d706a411260ba from: *User No1 [email protected] User No1 ourdomain de (ourdomain.de)* to: *user no2 [email protected] user no2 ourdomain de (ourdomain.de )* reference: ** subject: *AW: Subject* body: *Hello foo foo bar bar and so on Name - this is my very cool signature - Originalnachricht - Von User No2 Gesendet Wednesday November 30 2011 04 37 PM An User No 1 Betreff Subject Previous foo and bar and bar and foo * sent: 1322720598, delivered-date: 0 hdr len: 852 body digest: c1a354b622a6e4cfe841a0cb82b9b1249945580f805c29e5b220f8291f699d95 rules check: (null) retention period: 1643959371 attachments: direction: 0 spam: 0 NOT IN mydomains --- The IMAP message : --- locale: de_DE.UTF-8 build: 884 parsing... post parsing... message-id: null / 74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b from: * ()* to: *user no2 [email protected] user no2 ourdomain de no3 [email protected] user no3 ourdomain de no4 [email protected] user no4 ourdomain de (ourdomain.de )* reference: ** subject: *Mailsubject* body: *This is some text More text Foo bar and even more foo and bar greertzß UserNo1 * sent: 1322799709, delivered-date: 0 hdr len: 1128 body digest: 524a8e4724947e7d0bba4817746f01647d5a73d96604c0cd37b70fc1f263694b rules check: (null) retention period: 1643959579 attachments: direction: 0 spam: 0 NOT IN mydomains --- Does the pilertest also rely on mysql/mysqllibraries so that it can not detect the "from:" field? Or are there any formating errors in the source mail files that we both missed? Should I try the latest master branch version? Thanks, Mario
