> > > > > 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 > >
Hey all, I can answer the last question myself : downloaded and installed master branch version a few minutes ago. Afterwards I was able to import all my testmails with no problems as far as I can tell right now. (imported 23 testmails) Now I'll have to do some scripting to import a larger set (in the end the total archive) from openbenno. Thx Janos for this nice pieces of software.
