RE: zip archive

2012-08-10 Thread Janos SUTO
Hello John, On Fri, 10 Aug 2012 13:48:11 +1000, John Kenyon wrote: OK, I'm glad. Tomorrow I'll release version 0.1.20 which will be the basically the same as the latest master branch version. Using version 0.1.20, this works as a Regular User but not as an Auditor hmmm, can you login

Re: piler 0.1.20 daily-report.php issues

2012-08-10 Thread Janos SUTO
Hello John, On Fri, 10 Aug 2012 12:53:00 +1000, John Kenyon wrote: Using piler 0.1.20 but have an issue when running the daily report script: /usr/bin/php /usr/local/libexec/piler/daily-report.php PHP Warning: fsockopen(): unable to connect to 127.0.0.1:25 (Connection refused) in

RE: zip archive

2012-08-10 Thread Janos SUTO
Hello John, On Fri, 10 Aug 2012 19:47:57 +1000, John Kenyon wrote: As Auditor: idlist: 1462,1461,1460,1459,1458,1457,1456,1455,1454,1453,1452,1451,1450,1449,1448,1447,1446,1445,1444,1443 Array ( [0] = 40005024ba1236a1d124df50322fe9d7 [1] = 40005024c0f13acda084c1748bfb7d58

RE: zip archive

2012-08-10 Thread Janos SUTO
On Fri, 10 Aug 2012 20:10:54 +1000, John Kenyon wrote: OK, this time I got 19 x items in the zip. However I went to the next page of the search results, and only got 14 x items in the zip... ok, but can you download the archive file as the auditor user, and does it contain all the

RE: zip archive

2012-08-10 Thread Janos SUTO
Hello John, On Fri, 10 Aug 2012 20:18:57 +1000, John Kenyon wrote: ok, but can you download the archive file as the auditor user, and does it contain all the selected files? The Regular user works fine. The problem is with the Auditor user account. ok, I see. However it's not clear that

Re: pilerimport

2012-08-17 Thread Janos SUTO
Hello Oleg, On Fri, 17 Aug 2012 15:52:53 +0200, Oleg Reich wrote: i have one problem with pilerimport. i'm trying to import some messages to the piler base, but unfortunally piler crashes with the Segmentation fault. it's happens during importing from imap or folder. after crash i found one

Re: Empty set is returned on search

2012-10-30 Thread Janos SUTO
Hello Gabriele, On 2012-10-30 16:44, Gabriele wrote: I have the same problem. I run piler under Debian Squeeze, using sphinx2 from the official .deb archive. I have sent 1 message to piler, ad it has been fed into the database. The next messages, are not :-( what do you mean? Please set

Re: MailPiler implementations

2012-12-09 Thread Janos SUTO
Hello Jarek, On 2012-12-09 21:24, Serafin wrote: I'm considering MailPiler as a tool for email archiving in my organization for about 1000 mailboxes and max traffic 50msg/minute. So far I was able to feed my test instance with much higher email traffic, so I assume that performace is

Re: LDAP/AD integration

2012-12-11 Thread Janos SUTO
Hello Jarek, yes, I've tried it with Active Directory. I'm not sure whether you reported an importing error on bitbucket, but please check that you have a column called 'samaccount' in the 'user' table. If not, then apply util/db-upgrade-0.1.21-vs-0.1.22.sql to the piler database.

Re: Restore message to mailbox

2012-12-18 Thread Janos SUTO
On 2012-12-18 18:19, Serafin wrote: to make it more user-friendly I would like to see this feature as popup window with all addresses listed and check-boxes next to them. Also you'd need Restore button on this popup, which would invoke real restore action ok, I modified it, please check

Re: Restore message to mailbox

2012-12-20 Thread Janos SUTO
Hello Jarek, On 2012-12-18 23:33, Serafin wrote: this is exactly what I though about - Thanks I've just updated the master branch. Please update the webui, then try and test the restore feature for auditors. It includes the From address as well if it's an internal domain. Janos

Re: Restore message to mailbox

2012-12-22 Thread Janos SUTO
Hello, On 2012-12-22 19:25, Serafin wrote: restore function works as expected - thanks fine the only comment - if message was send to the sender itself, then there are two the same addresses on the list try this diff: --- a/webui/model/search/search.php +++

Re: pilerimport imap gives no feedback at all

2013-01-08 Thread Janos SUTO
Hello, I think, you are in /root, and user piler has no permission to create temp files there. Please chdir to /tmp, and try again. Janos On 2013-01-08 08:58, mourik jan heupink wrote: Hi, I have just discovered mailpiler, and it seems to do exactly what we were looking for. Great!

Re: Documentation

2013-03-17 Thread Janos SUTO
Hello, On 2013-03-17 07:40, Frank Ellebrecht wrote: As I had some problems during the installation process, I thought it might be a good idea to share them here and suggest some changes to the documentation: Mandatory packages == The package »sysstat« is required. Without

Re: Translations

2013-03-17 Thread Janos SUTO
On 2013-03-17 20:59, Frank Ellebrecht wrote: Replied off the list, sorry. no problem. I've just updated the master branch to include the lang option. You may try it on the demo site as well, see http://www.mailpiler.org/en/demo.html Janos

Re: Max results

2013-03-18 Thread Janos SUTO
Hello Viet, On 2013-03-18 09:27, Hoang Tuan Viet wrote: I have set sphinx.conf: max_matches = 1 and restart searchd. I also set in config.php define('MAX_SEARCH_HITS', 1); define('MAX_AUDIT_HITS', 1); However, piler still returned 1000 results while searching in cli

Re: Max results

2013-03-18 Thread Janos SUTO
Hello Viet, Does user 'piler' have write permissions on /tmp/piler directory? Please find the improved pilerexport.c attached. It has a slightly changed sql query for exporting all emails. Please recompile, and let's see whether it works for you. Please note that if you have many emails then it

Re: Documentation

2013-03-18 Thread Janos SUTO
Hello Frank, On 2013-03-18 20:26, Frank Ellebrecht wrote: Just wanted to let you know that I finally succeeded installing the master branch, at least yesterday's build (770). I did have some trouble just post them. I'd like to make the piler install/upgrade as smooth as possible. here

Re: Documentation

2013-03-19 Thread Janos SUTO
On 2013-03-18 23:18, Frank Ellebrecht wrote: There's another thing I just noticed. When running daily-report.php I get »PHP Notice: Undefined variable: usagetrend in /var/piler/www/view/theme/default/templates/health/daily-report.tpl on line 101« there's a typo, and it's $useagetrend in

Re: Max results

2013-03-19 Thread Janos SUTO
Hello Viet, On 2013-03-19 04:11, Hoang Tuan Viet wrote: There was an error when I recompiled piler: pilerexport.c: In function ‘export_emails_matching_to_query’: pilerexport.c:167:22: warning: passing argument 2 of ‘retrieve_email_from_archive’ from incompatible pointer type [enabled by

Re: Text attachment problem

2013-03-24 Thread Janos SUTO
On 2013-03-24 22:54, Frank Ellebrecht wrote: then try to download the same attachment Nope, if I open/download the attachment mail.log, it's 0 bytes. ehh, in the 65th line it should read as: if(!preg_match(/\s/, $s)) { so it's not preg_replace but preg_match. Please try again. So,

Re: Text attachment problem

2013-03-26 Thread Janos SUTO
Hello Frank, On 2013-03-25 22:38, Frank Ellebrecht wrote: I've done that and now the message looks way better. Here is the good interesting part, copied from the web UI: [...] Content-Type: application/pdf;

Re: Installation query inbound email

2013-03-26 Thread Janos SUTO
On 2013-03-26 14:02, Adam Fyfe wrote: If I stop postfix, I cannot telnet on port 25, even from the localserver : telnet 127.0.0.1 25 Trying 127.0.0.1... telnet: connect to address 127.0.0.1 [2]: Connection refused don't use 127.0.0.1 since it's unreachable from outside. Use the IP-address

Re: Text attachment problem

2013-03-29 Thread Janos SUTO
Hello Frank, thanks for the bug report, please check out model/search/message.php from the latest commit. Now it should be ok. Janos On 2013-03-28 23:32, Frank Ellebrecht wrote: Hello Janos, Am Donnerstag, den 28.03.2013, 16:46 +0100 schrieb Janos SUTO: I've just commited a few changes

changes on the demo site and other news

2013-03-29 Thread Janos SUTO
Dear piler users, I've changed the demo site. It uses twitter's bootstrap framework to make the gui simpler. I'd like you to try it, and tell me your (honest :-)) opinion - whether it's any better than it was. If you want to try it for your site, then it's already in the latest commit in the

Re: Feature request #1 (additional logging capabilities)

2013-03-30 Thread Janos SUTO
Hello Frank, On 2013-03-30 22:31, Frank Ellebrecht wrote: May I make two suggestion/feature requests? Here is the first one, I'll leave the second one for an upcoming message. Almost every action in the web UI is logged to the audit log. Would it be possible and make sense to add another

Re: Feature request #1 (additional logging capabilities)

2013-04-01 Thread Janos SUTO
Hello Frank, On 2013-04-01 22:29, Frank Ellebrecht wrote: hmm, that's a surprise to me. In that case you shouldn't use the pilerpurge utility because it's based on a calculated timestamp when you receive the message. Yes, that's a tough one. You only know after the period if a message can

Re: Restore email with imap

2013-04-02 Thread Janos SUTO
Hello, On 2013-04-02 15:43, Csárdi-Braunstein János wrote: It's possible to restore email directly to imap server (if user login with his imap user and password), with IMAP, not SMTP? just to clarify: you want the piler gui to restore an email from the archive to the mail server via imap

Re: Restore email with imap

2013-04-02 Thread Janos SUTO
On 2013-04-02 16:18, Csárdi-Braunstein János wrote: Yes, this is what i mean. If user logged in with IMAP auth, piler have every information to this procedure. Simply put message to INBOX, or discover what directory existing in server, and ask user what directory is the destination. ok, it

Re: Restore email with imap

2013-04-02 Thread Janos SUTO
On 2013-04-02 16:18, Csárdi-Braunstein János wrote: Yes, this is what i mean. If user logged in with IMAP auth, piler have every information to this procedure. Simply put message to INBOX, or discover what directory existing in server, and ask user what directory is the destination. ok,

Re: Migrating Piler to a new host and upgrading

2013-04-09 Thread Janos SUTO
Hello Simon, On 2013-04-09 19:53, Simon Booth wrote: I have had Piler successfully installed for about 6 or 7 months and although it started out as a test I've built up quite an archive that I don't really want to lose. I'm now at a stage where I want to move I'm glad that you like piler

Re: Search returns only emails that user received

2013-04-12 Thread Janos SUTO
Hello Viet, On 2013-04-12 07:20, Hoang Tuan Viet wrote: I have created a regular account v...@mydomain.com. When I searched with no resource with that account: Apr 12 12:04:22 ldap-2 piler-webui[23799]: sphinx query: 'SELECT id FROM main1 WHERE MATCH('@to vietXmydomainXcom') ORDER BY

Re: LDAP user cannot search his email

2013-04-12 Thread Janos SUTO
Hello Viet, On 2013-04-12 12:48, Hoang Tuan Viet wrote: I have integrated Piler with OpenLDAP successfully. But when LDAP user v...@mydomain.com searched with no resource: Apr 12 17:38:03 ldap-2 piler-webui[13766]: sphinx query: 'SELECT id FROM main1 WHERE MATCH('@to ') ORDER BY `sent`

Re: LDAP user cannot search his email

2013-04-15 Thread Janos SUTO
On 2013-04-15 05:07, Hoang Tuan Viet wrote: great. When a user logs in can he see his email address(es) on the settings page? What happens if he just hits the search buttons? Can he see any emails? Yes, he can see his email on the settings page. When he just hit the search buttons, no

Re: Digital Signage

2013-04-16 Thread Janos SUTO
Hello Karsten, On 2013-04-16 14:23, Karsten Bandlow wrote: is this feature implemented? And how can I verify the message and the cert are untouched? a basic verification is implemented to check message integrity. If you set the following in config-site.php, then you should see some green

RE: Piler scalability

2013-05-06 Thread Janos SUTO
Hello Steve, On 2013-05-06 16:46, Steve Miller wrote: Janos, I would like to put my personal experience into this question as well. I have been running piler over 6 days now, with a daily average of 10k emails. Average message size is 0.2MB, metadata is 2k, and index size is 6k. Average size

Re: Question about Search

2013-05-08 Thread Janos SUTO
Hello Roberto, On 2013-05-08 12:41, Roberto Bartali wrote: Hi everyone I'm new to mailpiler and just trying to understand if is it suitable for my organization needs. I'm using compiled version of mailpiler and sphinx. This is the problem: if i search a message using the search button it

Re: Empty set returned on search after reboot

2013-05-20 Thread Janos SUTO
Hello Roberto, according to your listing, something has just resetted the sphinx database. However your emails are still in the archive, just the indices are lost. Run reindex -a to recreate them, and after the piler cron jobs run then you'll have search results again. Note that you should

Re: New install - no search results / User Login issue.

2013-05-23 Thread Janos SUTO
Hello Adam, On 2013-05-23 21:36, Adam Camp wrote: Hi, hoping someone can help... Just carried out a new installation on CentOS 5.9 x64. (VMWare VM). ok, I assume, it's 0.1.23 I've run into a couple of issues. Firstly, I've been directing mail at the installation, and it shows that it has

RE: New install - no search results / User Login issue.

2013-05-23 Thread Janos SUTO
On 2013-05-23 23:04, Adam Camp wrote: The package is installed. To clarify, I mean the accounting page (not statistics, statistics displays correctly, sorry!) shows no e-mails, although all other areas say otherwise. I see. Please check piler's cron jobs whether it includes something like

Re: Piler is listening port 25 but i cant connect

2013-07-24 Thread Janos SUTO
Hello, please show me the output of netstat -an|grep 25 then the exact telnet command, and its result. Janos On 2013-07-23 23:02, Tobias Friede wrote: Hi, today I have installed piler on a Ubutntu 12.04 LTS System (64-bit). The Webinterface works but I can't connect to the SMTP Server of

Re: piler install options

2013-07-29 Thread Janos SUTO
Hello, On 2013-07-29 16:47, NetCetera Lists wrote: I am wondering if it is possible to install piler on a low volume existing mail server - either directly (I doubt it...) or using a VM installed on the existing mail server. even though piler is expected to have its own host (either

Re: Backup/Restore

2013-07-29 Thread Janos SUTO
Hello Michael, On 2013-07-29 17:06, Michael Wessel wrote: I installed Piler last night to check it out and test it and have it all up and running now. So far I like it a lot (though I had to jump through a few hoops to get it all working). share with us, and I'll review the install

Re: Backup/Restore

2013-07-30 Thread Janos SUTO
On 2013-07-30 10:30, Michael Wessel wrote: Unfortunately I'm no good with SELinux... But I should probably sit down and learn it and figure this out. I'll update this if I actually manage to do this in the near future. no problem After that I had 2 other gotchas. One was that I had to

Re: Backup/Restore

2013-07-30 Thread Janos SUTO
On 2013-07-30 12:44, Michael Wessel wrote: no LD_LIBRARY_PATH variable is set. cat /etc/ld.so.conf include ld.so.conf.d/*.conf and nothing in the ld.so.conf.d points to that directory. According to the ldconfig man page /lib and /usr/lib are checked be default, but not /usr/local/lib well,

RE: Move from MailArchiva to Piler

2013-07-30 Thread Janos SUTO
On 2013-07-30 14:09, Steve Miller wrote: So I'm happy with Piler and would like to move an existing archive from MailArchiva over to Piler. I have some 200K messages in the existing archive that I would like to import into Piler. Has anyone done this before? If so, how? I only have the free

Re: Question: Exclude certain email addresses from Archive

2013-08-07 Thread Janos SUTO
Hello, On 2013-08-07 01:07, NetCetera Lists wrote: Is there a mechanism, planned or existing, to not archive email from certain email addresses. I thought I saw this capability somewhere but if I did I can't find it now ... yes, it's possible to make it, the archiving rules are to

Re: Error upgrading from 0.1.23 to master branch - mysql

2013-08-07 Thread Janos SUTO
On 2013-08-07 14:31, NetCetera Lists wrote: I decided to give the master branch a try. The configure and make went as expected but I ran into an error on the sql script. BTW, upgrade page mysql -u piler -p piler util/db-upgrade-0.23-vs-0.24.sql should be mysql -u piler -p piler

Re: Relay Server Outbound Archiving

2013-08-13 Thread Janos SUTO
Hello Beryl, On 2013-08-13 18:49, Beryl Snyder wrote: Sorry if this is a common question. I didn't find anything searching the achieves.  I am looking for a way to log all out bound messages from a relay server.  The rub is that this server only sends automated emails from a webapp. So there

Re: domain settings

2013-08-23 Thread Janos SUTO
Hello Stephen, its purpose is to map several domain names together. Eg. if you host several customers, then it helps piler to know which domain belongs to the given customer. If you host for a single company, then use the primary domain as the mapped domain name. Janos On 2013-08-23 22:05,

Re: LDAP and local users

2013-08-23 Thread Janos SUTO
On 2013-08-23 22:43, Stephen Ingram wrote: If I'm using LDAP authentication, it works great, however, I can no longer login as a local user (admin@local). Is this supposed to be the case such that you have to create admins somehow in your directory or is this an error? well, you should be

Re: LDAP and local users

2013-08-23 Thread Janos SUTO
wrote: On Fri, Aug 23, 2013 at 3:09 PM, Janos SUTO s...@acts.hu wrote: On 2013-08-23 23:55, Stephen Ingram wrote: No SSO enabled (I assume it's disabled by default), just trying to yes use LDAP right now. It works for the users and they are regular users when they login, however

Re: xlhtml on CentOS 6

2013-08-24 Thread Janos SUTO
Thanks, Christian. based on the info found on the link, I've updated the source tree to include the required fix. Tested on Debian 7 x64 platform, and now it compiles. Download link: http://cdn.bitbucket.org/jsuto/piler/downloads/xlhtml-0.5.1-sj-mod.tar.gz Janos On 2013-08-24 15:01,

Re: Question about Query in WebUi

2013-08-24 Thread Janos SUTO
Hello Christian, On 2013-08-24 21:15, Christian Vielhauer wrote: ah okay, that looks definitely for a reason. I think it's good to know that the min_prefix_len should be 6 signs. you may decrease this number, but you should know that the lower is the value, the more tokens the indexer

Re: Question about Query in WebUi

2013-08-24 Thread Janos SUTO
Hello Christian, On 2013-08-24 21:40, Christian Vielhauer wrote: i don't mean the doc, i mean the webui can inform a user about this behavior. or a little user doc inside webui would be nice or write it as note under advanced search menu would be the easiest i have added that information

Re: Wrong Date of Mails

2013-08-24 Thread Janos SUTO
Hello Chris, On 2013-08-24 22:55, Christian Vielhauer wrote: i have exported all mails out of openbenno where they are stored as *.gz. so i have to export them with zcat filename filename.eml but now all mail eml-files are from same date piler imports mails successfully, but now they

Re: Wrong Date of Mails

2013-08-25 Thread Janos SUTO
Hello Christian, On 2013-08-25 21:50, Christian Vielhauer wrote: okay, i have tried with an mail from 22.8.2013. in webui table, it shows date 2013.08.24 in webui mailview, it shows Date: Thu, 22 Aug 2013 11:31:57 +0200 pilertest 4000eml gives the following information: . sent:

Re: Wrong Date of Mails

2013-08-25 Thread Janos SUTO
Hello, On 2013-08-25 23:06, Christian Vielhauer wrote: i understand right? When Mail processed by piler-smtp, then DATE = NOW When Mail processed by pilerimport, then DATE = Date-Tag of Mail-Header yes that would explain the date problem ... it seems to concern mails i import

Re: pilerimport imap-ssl login work but failed

2013-08-27 Thread Janos SUTO
Hello, please overwrite src/imap.c with the attached one, then recompile it and try running the following commands: cd src cp /path/to/imap.c imap.c make clean all export LD_LIBRARY_PATH=. ./pilerimport -D -i 10.27.1.22 -u mailarc...@mydomain.com -p Chang3dPwd -P 993 (-D stands for dry run

Please help translating DE and PT lang files. Was: WebUi translation correction

2013-08-27 Thread Janos SUTO
Hello, thanks for the fix. Actually there's text_date_to and text_date_from for such a situation, just forgot to use it until now. However as the gui has been improving some new text_ placeholders were introduced. Could you please help me translating them? Unfortunately I was dumb enough

Re: import and indexing

2013-08-27 Thread Janos SUTO
On 2013-08-27 19:46, Stephen Ingram wrote: I just imported several GB worth of email into piler using imap connection. All of the emails seemed to have come in properly and stored in /var/piler/store/00, however, I don't see any mail in the search interface whether I leave it blank or input a

Re: import and indexing

2013-08-27 Thread Janos SUTO
On 2013-08-27 20:47, Stephen Ingram wrote: On Tue, Aug 27, 2013 at 11:32 AM, Janos SUTO s...@acts.hu wrote: I'm using the latest stable 0.1.23 from the Website. I have a feeling it's because I installed from binaries and tar.gz. Stuff is probably not the right place. I think I'm going to roll

Re: import and indexing

2013-08-27 Thread Janos SUTO
On 2013-08-27 21:24, Stephen Ingram wrote: Oops. I forgot about the encryption. Although it was lots of email, it was just a test. I'm going to start over with the latest master branch as you suggest. Compile the important stuff from scratch and then re-import. This time we'll try PST along

captcha support for the piler gui

2013-08-30 Thread Janos SUTO
Dear piler users, the final 0.1.24 is almost ready, expect it this weekend. I've introduced two new features: - I've added Spanish translation (thanks for Emilio who did the actual work) - captcha support for the login screen. It may be useful to mitigate brute force login attempts by

Re: guide for centos 6.x

2013-08-30 Thread Janos SUTO
Thank you guys for both of you. I've just appended this url to the installation manual. Janos On 2013-08-28 21:18, admin-at-extremeshok-dot-com wrote: Nice guide.. Used yours and fixed it up a little (sed for replacements, cat for creating configs). From experience... ONLY use MariaDB

0.1.24 is out

2013-09-02 Thread Janos SUTO
Dear piler-users, I proudly present that the final 0.1.24 is out (because I couldn't wait any longer). What's new in 0.1.24? I switched from virtualbox back to vmware, and an OVA file is available at bitbucket: https://bitbucket.org/jsuto/piler/downloads/piler-0.1.24.ova (~600 MB) I

Re: How to search

2013-09-02 Thread Janos SUTO
Hello, debian and ubuntu have a daily cron job to run indexer --all every day. Unfortunately this ruins the index files piler relies on. To fix it do the following: 1. stop searchd 2. edit /etc/default/sphinxsearch, and set START=no 3. Use the piler shipped init.d/rc.searchd script to start

Re: CPU usage at 100%, mail retention question

2013-09-17 Thread Janos SUTO
Hello Stephen, On 2013-09-17 19:54, Stephen Ingram wrote: After having installed 0.1.24 I notice that the CPU usage is always at 100%. /var/piler/stat/cpu.stat reports 96.63 which according to mpstat is the %idle. That should mean a very low usage, correct? But the bar in the UI is red and

Re: CPU usage at 100%, mail retention question

2013-09-17 Thread Janos SUTO
On 2013-09-17 21:29, Stephen Ingram wrote: /var/piler does have 700, but /var/piler/stat already has 755. So shouldn't it work as is? no, because current /var/piler permissions prevent the webserver to read /var/piler/stat, so I recommend to fix it: chmod 755 /var/piler The documentation

0.1.24 segfault issues on certain platforms (eg. centos)

2013-10-08 Thread Janos SUTO
Dear piler users, it appears that 0.1.24 has some issues on platforms, eg. on centos. I'd like to share my latest findings to help you resolving this showstopper problem. I used the latest master branch which has only some minor bugfixes over the final 0.1.24 (they are basically the same from

the weird segfault issue when starting piler finally fixed

2013-11-01 Thread Janos SUTO
Dear piler users, I was pretty unfortunate when putting the finishing touches to 0.1.24. I created some sql wrapper functions for the piler binaries, however it turned out that I had not been careful enough to handle NULL values properly. Like I said I was unfortunate because the mysql

Re: archive folder structure

2013-11-07 Thread Janos SUTO
Hello Sebastian, unfortunately when the piler daemon gets a message via smtp, it has no idea about any folder info. But even if it had, it would be difficult to follow any changes in the message transition between folders, eg. if a user drags a message from folder1 to folder2. But how would

Re: Sent time in emails returned by search

2013-11-21 Thread Janos SUTO
On 2013-11-21 23:58, Keith Moore wrote: When viewing the email, the date header in the web interface shows: Date: Thu, 21 Nov 2013 21:46:17 + I would like it to match local (Denver) time, which would be UTC-7. The message header shows: Received: from xxx.local ([172.17.96.22]) by

Re: Sent time in emails returned by search

2013-11-21 Thread Janos SUTO
On 2013-11-22 00:04, Keith Moore wrote: I believe so...  and I am running the OVA. # date Thu Nov 21 16:02:04 MST 2013 #cat /etc/timezone America/Denver Is there some place else I need to change it? I think that's it: /etc/timezone and TIMEZONE in config-site.php. Give me some time, and

Re: Sent time in emails returned by search

2013-11-26 Thread Janos SUTO
On 2013-11-26 17:04, Keith Moore wrote: You got an email from someone (probably me?) who's timezone is 7 hours ahead yours, that's why the Received line show 14:46, but the Date header (which is set by the sender) shows 21:46. There was a debate whether to use what is in the Date header or

Re: Sent time in emails returned by search

2013-11-27 Thread Janos SUTO
at 12:52 PM, Janos SUTO s...@acts.hu wrote: On 2013-11-26 17:04, Keith Moore wrote: You got an email from someone (probably me?) who's timezone is 7 hours ahead yours, that's why the Received line show 14:46, but the Date header (which is set by the sender) shows 21:46. There was a debate

Re: Store messages on NFS?

2013-12-03 Thread Janos SUTO
Hello Jeff, On 2013-12-03 04:39, Jeff Larsen wrote: I have successfully set up mailpiler in a virtual machine, but the best storage available that will be large enough is on an NFS server. I have set up the NFS destination with autofs and linked it to /var/piler/store. But what will piler do

Re: Automate Search

2013-12-03 Thread Janos SUTO
Hello, On 2013-12-03 14:04, edenilson de paula wrote: I need the function: Automated searching per time period; results delivered by email or view in other frame. Is there any possibility to implement? there is. Please describe it in a more detail, for starters I'd like to know the

Re: AW: Delete mails after import from journaling mailbox

2013-12-03 Thread Janos SUTO
Hello Jan, On 2013-12-03 16:00, Jan Patrick Lübbert wrote: I'm testing the master e133a41570cf now. After I imported lots of mails I see the following issues: - The date show in the WebUI is the import date not the date from the message hmm, it's strange. I also imported two spams back

Re: Store messages on NFS?

2013-12-03 Thread Janos SUTO
On 2013-12-03 17:21, Jeff Larsen wrote: I agree that lacking highly available NFS is unfortunate, however the nature of a mail archive is well suited to network storage. So failure should be handled gracefully. well, I'm not against NFS (or iscsi for the matter) at all. I did a simple

Re: Store messages on NFS?

2013-12-04 Thread Janos SUTO
On 2013-12-04 15:56, Jeff Larsen wrote: My NFS share is on a 1 TB NAS with about 600GB free. We have a dedicated mysql server in a different virtual machine with it's own storage. I have assumed that the mysql database for piler is mostly metadata and will not be as large as the file store.

Re: Integration with zimbra

2014-01-02 Thread Janos SUTO
Hello, integration with zimbra is pretty trivial, you need two things: #1: have zimbra to forward all emails to piler As Ser@fin described, it's a single entry in main.cf: always_bcc = arch...@archive.wdc.net You don't need any transport mapping nor an MX record for archive.wdc.net #2:

Re: sql table folder ?

2014-01-17 Thread Janos SUTO
Hello Timothee, On 2014-01-17 11:00, Timothee CLERC wrote: I have installed Piler on Debian 7, it works fine and WebUI is I'm glad really nice. But i have some problems with email importation : sometimes mail does not have TO field, and we have lot of email alias... well, if an email

Re: How scaleable is mailpiler?

2014-01-30 Thread Janos SUTO
Hello, On 2014-01-30 16:16, ad...@extremeshok.com wrote: Your over thinking the whole thing with trying to scale a single instance. Create multiple virtual machines on something like open stack, etc. 1 vm per a client /company, scale the storage and resources as needed. Client leaves, kill

Re: How scaleable is mailpiler?

2014-01-30 Thread Janos SUTO
On 2014-01-30 16:57, Travis Dolan wrote: The single VM per client option is a good idea. However when dealing with 100s or 1000s of clients management of those VMs becomes fun. We roll our MailPiler install out via AWS, and we manage the configuration via Puppet. We can roll out as many

Re: How scaleable is mailpiler?

2014-02-03 Thread Janos SUTO
Hello Darryl, ok, thanks for the answers. I'll start working on it. Firstly, I'm going to tweak the piler daemon and other binaries to support different clients and databases. After some testing (I hope you can join the test) I'm going to enhance the gui to support this changed setup. I'm not

Re: How scaleable is mailpiler?

2014-02-05 Thread Janos SUTO
On 2014-02-05 12:59, Darryl Sutherland wrote: Wow Janos! You have been busy! Thanks for all the extra info, I'll check out your PoC and give you some feedback after further testing! ok, if you got stuck, then I'd provide some help remotely. Looking forward to your opinion on the matter.

Re: How to restore email back to inbox for Exchange 2010?

2014-02-05 Thread Janos SUTO
On 2014-02-05 16:30, Jonathan Brown wrote: I am considering using this as an archive for Exchange 2010 organization. How can I select an email I searched and restore to the users inbox? you have two options: #1 imap restore: the message is restored to INBOX folder #2 smtp restore: you

Re: some future plans for piler, and a 10 question long survey

2014-02-20 Thread Janos SUTO
release you mentioned a few posts ago and take the discussion further from there? Regards - Original Message - From: Janos SUTO s...@acts.hu To: piler-user@list.acts.hu Cc: Sam Gelbart s...@synaq.com, David Jacobson (dav...@synaq.com) dav...@synaq.com Sent: Monday, 17 February, 2014 10

Re: strange pilerimport issue..?

2014-02-20 Thread Janos SUTO
On 2014-02-20 15:06, mourik jan heupink wrote: Latest master works a lot better, but still no actual import..: processing folder: Templates... found 18 messages cannot open: 8226-imap-1.txt processing folder: Sent Items/2004... found 0 messages processing folder: Sent Items/2005... found 2045

Re: piler scalability

2014-02-24 Thread Janos SUTO
Hello, thanks for your comments. However a few questions popped in my mind. On 2014-02-24 15:35, admin-at-extremeshok-dot-com wrote: Maybe do a more isolated management node (gui) with multiple independent worker nodes (piler+searchd), which are centrally controlled from the management

Re: piler scalability

2014-02-24 Thread Janos SUTO
Hello Darryl, On 2014-02-24 14:27, Darryl Sutherland wrote: In the model you propose, how is data provisioned/deprovisioned in a multitenant environment? Are you keeping the per client db and per client storage model changes you started implementing a few weeks ago? yes, I'd keep the

Re: piler scalability

2014-02-26 Thread Janos SUTO
Hello Darryl, thanks for your comments. On 2014-02-25 08:18, Darryl Sutherland wrote: Also several more observations. I agree with the previous post regarding large MySql replications - a busy db such as a large Mailpiler implementation is likely to get behind and out of sync due to

Re: date / encryption question

2014-02-27 Thread Janos SUTO
Hello Mourik, On 2014-02-27 16:17, mourik jan heupink wrote: In the search results top pane: The date there is the date the mail was archived in the mailpiler system. In the search results bottom frame: The date there is the date taken from the headers of the mail. However: when performing

Re: Getting duplicates with postfix always_bcc

2014-04-29 Thread Janos SUTO
On 2014-04-29 17:16, Jeff Larsen wrote: That appears to have taken care of it. I'm glad to hear that. Janos

Re: piler and public folders

2014-06-03 Thread Janos SUTO
Hello Adam, On 2014-06-03 12:54, Adam Camp wrote: The client has several employees, all accessing their own individual mailboxes. When they receive e-mails from certain suppliers/clients, they are moved from their personal mailbox to a shared folder. Now, for our own office use, all our

Re: Cron job mail

2014-06-10 Thread Janos SUTO
On 2014-06-09 16:39, Jeff Larsen wrote: Since piler listens on port 25, we can't run a standard MTA to get system messages via email. I seem to recall that removing postfix was one of the steps in getting piler installed. What is the recommended method for enabling cron emails on a piler

Re: right search command

2014-06-12 Thread Janos SUTO
Hello, the parser transforms URLs to special tokens, eg. __URL__wwwXdropboxXcom. You can check it by running pilertest message.eml to see what the parser makes. However this is not a human friendly token, so the gui make this transformation or rewriting when you enter

Re: Pilerimport -d import order

2014-07-03 Thread Janos SUTO
On 2014-07-02 23:05, Shenandoah Gallitz wrote: I'm importing some large email folders that have been converted from PST using ReadPST. Usually the import works correctly, but I have one folder of .EMLs where Pilerimport -d is stopping on a particular email and not going any further. I'm not

Re: Pilerimport -d import order

2014-07-03 Thread Janos SUTO
Hello Ben, On 2014-07-03 22:56, Shenandoah Gallitz wrote: Janos, I narrowed down the email through a lot of trial and error. Would it help at all if I sent you a copy of the message to make sure what helper or code is having trouble handling it? sure, go ahead, and send it to me. Janos

  1   2   3   >