Custom Skin

[srisinger]

Okay, I feel dumb in asking, but I have done everything possible to try to add 
new themes to Piler. The only thing I could find to work is to replace the 
metro-bootstrap.css file with a new one, but that replaces everybody's default 
theme.

The instructions at http://www.mailpiler.org/wiki/current:administering-piler 
are no longer right. How about a little something for the llama?

--
Regards,

Stephen R. Risinger *  Systems Administrator  *  
srisin...@meintl.com
Meetings & Events International  |  www.meintl.com
1314 Burch Drive | Evansville, IN 47725
1348 W Concord Pl | Chicago, IL 60642

RE: Pilerimport - IMAP help

[srisinger]

Jason,

Is IMAP running? I disabled TLS while I went through the import process. Janos 
says you should be able to leave it on, but it’s what worked for me (on 
Exchange 2007).

--
Regards,

Stephen R. Risinger •  Systems Administrator  •  
srisin...@meintl.com
Meetings & Events International  |  www.meintl.com
1314 Burch Drive | Evansville, IN 47725
1348 W Concord Pl | Chicago, IL 60642

From: Jason Caspersen [mailto:jason.casper...@3tsystems.com]
Sent: Wednesday, October 28, 2015 10:03 AM
To: piler-user@list.acts.hu
Subject: Pilerimport - IMAP help


Hi everyone, I'm having some trouble trying to import the legacy email from my 
Exchange 2010 server.



Long story short, I used the instructions from 
http://www.mailpiler.org/wiki/current:importing-emails



I need to impersonate each user, because I don't have access to the AD password.



I have "full access" setup correctly and can view the mailbox email using OWA  
http://mail.domain.com/owa/n...@domain.com, however when I try use Pilerimport 
using the following format:



pilerimport -i mail.domain.com -u domain.com/superuser/username -p superpassword



I get an error:



login failed, server reponse: A1 NO LOGIN failed.



On the flip side, if I know the users password it works correctly



pilerimport -i mail.domain.com -u domain.com/user -p password



Has anyone successfully imported their Legacy email using IMAP without having 
to reset the users AD account?





Thanks,

Jason Caspersen

RE: Search Issues

[srisinger]

Thanks for the followup, guys!

James, I implemented what you talked about from Issue 601. I think that will 
definitely help!

Janos, we can do multiple searches if MailPiler can't handle a complex search 
like we were attempting. (I don't know if other archivers can do it, either, so 
don't think I'm slamming MailPiler!) We were able to find the data we needed; 
it just seemed more difficult than it should have been.

RE: eml file names... That is a good point. If you try to save multiple emails 
from Outlook, for example, it prompts saying that it already has a file saved 
with that name (after the first). So, even Microsoft doesn't automatically 
handle it. Would it be possible to export the emails by subject, appending a 
number based of sent time (1,2,3, etc., oldest being 1, incrementing the number 
with newer emails)?

RE: Time & Date search...  Is this something that can't be done? Or would this 
better be served as a feature request on BitBucket?

-- 
Regards,

Stephen R. Risinger .  Systems Administrator  .  srisin...@meintl.com
Meetings & Events International  |  www.meintl.com

-Original Message-
From: Janos SUTO [mailto:s...@acts.hu] 
Sent: Wednesday, September 30, 2015 2:28 PM

Hello Stephen,

well, check the maillog if the parsed query looks OK. Anyway it might be easier 
to do two search queries:

from: ema...@domain.com OR ema...@domain.com OR ema...@domain.com,
date1: 2015-09-18

then another:

to: ema...@domain.com OR ema...@domain.com OR ema...@domain.com, date1: 
2015-09-18

If you insist on running a single query, then start with the date:

date1: 2015-09-18, (from: ema...@domain.com OR ema...@domain.com OR
ema...@domain.com)
OR (to: ema...@domain.com OR ema...@domain.com OR ema...@domain.com)

Also check the maillog if the sphinx query is built properly.

> change the *.eml filename to better reflect the email, perhaps using 
> the subject, for example?

might be possible, however how to deal with a message thread having 5 messages 
with the same subject, eg. Re: what was this?


> I also can't figure out how to search for times. Adding time to a date
> (-MM-DD hh:mm:ss) changes the search to incorrect results or gives
> no results whatsoever. What gives? (aka, I feel like I'm doing this
> wrong. Am I, or is this a bug in the search?)

well, the date parser handles year, month and day only. Don't specify 
anything else.

Btw. James is right with the highlighting, it was fixed recently in the 
master branch.

Janos

Search Issues

[srisinger]

We received a request to pull emails to-or-from three emails from a certain 
date forward.

We tried several different search methods, and I used the Sphinx advanced 
search criteria to come up with something like the following:
(from: ema...@domain.com| ema...@domain.com | 
ema...@domain.com)
When we ran this search, we seemed to get the proper amount of emails, but no 
text appeared in the email results. If we released an email, the email released 
correctly (text and images were present).

We were finally able to get the complete search results we needed, by using the 
following search:
from: ema...@domain.com|ema...@domain.com|ema...@domain.com | to: 
ema...@domain.com|ema...@domain.com|ema...@domain.com, date1: 2015-09-18

Is there a specific order that search terms need to be? Why did the initial 
search not include the email text? Also, is it possible to change the *.eml 
filename to better reflect the email, perhaps using the subject, for example?

I also can't figure out how to search for times. Adding time to a date 
(-MM-DD hh:mm:ss) changes the search to incorrect results or gives no 
results whatsoever. What gives? (aka, I feel like I'm doing this wrong. Am I, 
or is this a bug in the search?)

Piler -V results: 1.2.0-master build 919

--
Regards,

Stephen R. Risinger *  Systems Administrator  *  
srisin...@meintl.com
Meetings & Events International  |  www.meintl.com

RE: Missing emails from one user

[srisinger]

I restarted my Piler server, which solved my problem.

Is there a way to prevent an archive policy from regexing a user's email 
address? I.E., is it possible to have i...@domain.com but still archive 
jnor...@domain.com? 

-- 
Regards,

Stephen R. Risinger .  Systems Administrator

-Original Message-
To: Piler User piler-user@list.acts.hu
Subject: RE: Missing emails from one user

On 2015-07-28 22:35, srisin...@meintl.com wrote:
I had, at one point, had an archiving policy with from=i...@domain.com. This 
particular user's email is jnor...@domain.com. Because the end of the name made 
a regex match to is@, Piler tagged this email to discard.

Missing emails from one user

[srisinger]

I have one user (relatively new to the organization, but not the last) with 
outbound emails missing from Piler. Her inbound emails are there, and she can 
log in. We've checked our Exchange logs (2007), and everything appears to 
deliver. The emails never get indexed, and, in fact, never even make it into 
the sph_index table.

How can I further troubleshoot this problem?

--
Regards,

Stephen R. Risinger *  Systems Administrator

RE: pilerimport Syntax for importing from Exchange with impersonation because readpst skips many messages

[srisinger]

I did a good job of documenting most everything else I did, but I can't find my 
reference for turning off the IMAP TLS. I figured it was either a limitation of 
Piler or x2007 and just went with it. I didn't try to prove that one otherwise.

-- 
Regards,

Stephen R. Risinger .  Systems Administrator

-Original Message-
From: Janos SUTO [mailto:s...@acts.hu] 
Sent: Wednesday, July 22, 2015 2:53 PM
To: Piler User piler-user@list.acts.hu
Subject: RE: pilerimport Syntax for importing from Exchange with impersonation 
because readpst skips many messages


On 2015-07-21 23:43, srisin...@meintl.com wrote:
 Joern,
 
 Here's how I did ours. Granted, it's an Exchange 2007 box, so YMMV.
 
 add-mailboxpermission username -AccessRights FullAccess -user 
 superuser pilerimport -i mail.domain.com -u 
 domain.com/superuser/username -p superpassword -x 'Junk E-mail','RSS 
 Feeds','Sync Issues','Inbox/Helpdesk','INBOX/Helpdesk','RSS 
 Feeds/Microsoft at Home','RSS Feeds/Microsoft at Work,'
 remove-mailboxpermission username -AccessRights FullAccess -user 
 superuser
 
 Remember to replace 'username' with your email user (no @domain 
 necessary), 'superuser' with your import user, and 'superpassword'
 with your import user's password, and 'domain.com' with your domain. I 
 left the '-x' flag in for example exclusions. Be sure the IMAP service 
 is running and that TLS is turned off while you do this.

thank you, Steve. I've added this info to the import manual page.
Btw. why should tls be disabled? pilerimport is able to handle encrypted 
connections.

Janos

RE: pilerimport Syntax for importing from Exchange with impersonation because readpst skips many messages

[srisinger]

Joern,

Here's how I did ours. Granted, it's an Exchange 2007 box, so YMMV.

add-mailboxpermission username -AccessRights FullAccess -user superuser
pilerimport -i mail.domain.com -u domain.com/superuser/username -p 
superpassword -x 'Junk E-mail','RSS Feeds','Sync 
Issues','Inbox/Helpdesk','INBOX/Helpdesk','RSS Feeds/Microsoft at Home','RSS 
Feeds/Microsoft at Work,'
remove-mailboxpermission username -AccessRights FullAccess -user superuser

Remember to replace 'username' with your email user (no @domain necessary), 
'superuser' with your import user, and 'superpassword' with your import user's 
password, and 'domain.com' with your domain. I left the '-x' flag in for 
example exclusions. Be sure the IMAP service is running and that TLS is turned 
off while you do this.

I hope this helps!!

-- 
Regards,

Stephen R. Risinger .  Systems Administrator

-Original Message-
From: Joern Quillmann, kuehlhaus AG [mailto:j.quillm...@kuehlhaus.com] 
Sent: Tuesday, July 21, 2015 4:25 PM
To: piler-user@list.acts.hu
Subject: AW: pilerimport Syntax for importing from Exchange with impersonation 
because readpst skips many messages

I'm getting bald and losing my last hairs over this...

Domain\ImpersonationEnabledUser\AliasOfSomeUser does not work. 
Neither any combination with ImpersonationEnabledUser@Domain.local\alias

I tried escaping the Backspace with double Backspace.
I can login with domain\\ImpersonatioEnabledUser oder 
domain\ImpersonationEnabledUser and get the contents of the 
ImpersonationEnabledUser's mailbox but as soon as I try to add the alias of the 
user whose mailbox I want to import it always fails with login failed, server 
reponse: A1 NO LOGIN failed

Any ideas? 

RE: piler and public folders

[srisinger]

 Hello Stephen,

 if you referred to Adam's email (~a year ago), see the following url
 (http://www.mail-archive.com/piler-user@list.acts.hu/msg00589.html),
 then it's actually ready.

That's the email chain I was reading, actually.

 One thing has changed, though: it's '-a' (not -R). If you have something 
 different
 in mind, then let me know, and I'll try to solve it.

That's what I was looking for. Is there documentation that lists how to use the 
'-a' switch? If it's possible to directly import my public folders, rather than 
exporting to pst, then doing readpst to convert and import them, that is 
preferable!

-- 
Regards,

Stephen Risinger
Systems Administrator

RE: Time Column in GUI

[srisinger]

I concur with Janos's guidance. I had to look up php date/time formatting, 
which can be found here: http://php.net/manual/en/function.date.php. That 
should give you the information you need to modify the Date column format to 
your liking.

-- 
Regards,

Stephen Risinger
Systems Administrator

-Original Message-
From: Janos SUTO [mailto:s...@acts.hu] 
Sent: Tuesday, April 21, 2015 2:52 PM
To: Piler User
Subject: Re: Time Column in GUI


On 2015-04-21 21:39, Philip Deubner wrote:
 On 2015-04-20 23:54, srisin...@meintl.com wrote:
 Is it possible to add a Time column or modify the Date column to
 include time to the GUI?
 
 yes, it's possible. Put $config['DATE_TEMPLATE'] = 'Y.m.d';
 to config-site.php and fix it.
 
 Janos
 
 I tried to include it into the config-site.php. After restarting the
 webserver, no time column showed up - what am I doing wrong?

tweaking this value doesn't create new column for you. It affects only
the formatting, ie. $config['DATE_TEMPLATE'] = 'd/m/Y H:i:s';
would extend the already existing column, and give you the hour, min, 
sec
besides the date.

Check out the demo site for what to expect.

Janos