Re: I want to know if piler can do the following

2022-06-05 Thread Janos SUTO
Unfortunately, piler is not an imap server, so it cannot do what you asked. Janos On Jun 6, 2022, 02:06, at 02:06, Asmodean Thor wrote: >I have decided to offload my mail from google, and look for another >provider in the future. > >This is the solution I want: >Google send and receive —> POP3

Re: Reindex Question / Clarification

2020-09-21 Thread Janos SUTO
Hello Ryan, reindexing won't cause any waste in sphinx, so go ahead. Btw. you have several main indices, eg. main1, main2, etc. It's possible to use main1 for 2017 data, main2 for 2018 data, etc. In that case you may move main1 to a backup media to free up some space. The trick is to fix both

Re: Piler 1.35 on Ubuntu 18.04 - Web UI doesn't show mail headers / contents

2020-07-31 Thread Janos SUTO
Hello Patrick, fix the piler binary paths in config-site.php. Check out the current values in config.php. Janos SUTO On 31 Jul 2020, 14:07, at 14:07, "Wagner, Patrick" wrote: > > >Hello everyone, > > >just opened an older piler archive (version 1.35) and was surp

Re: Empty message header and body

2020-07-15 Thread Janos SUTO
; >Em qua., 15 de jul. de 2020 às 00:46, Janos SUTO escreveu: > >> Hello Marcelo, >> >> check if piler.key and the iv parameter in piler.conf (if there's >any) are >> the same. >> >> Janos >> On 14 Jul 2020, at 23:42, Marcelo Machado wrote: >

Re: Empty message header and body

2020-07-14 Thread Janos SUTO
Hello Marcelo, check if piler.key and the iv parameter in piler.conf (if there's any) are the same. Janos On 14 Jul 2020, 23:42, at 23:42, Marcelo Machado wrote: >Hello everyone. > >After I migrated MailPiler to a new hardware, the header and body of >old >messages no longer appear. The new

Re: Upgrade Piler 1.3.7 -> 1.3.8 / Upgrade Sphinx

2020-04-21 Thread Janos SUTO
Hello, well, you need that python module, please install it. And yes, I recommend sphinx 3.2.1 for a new installation. The 2.2.x series is not maintained by the sphinx team apparently. It's safe to upgrade from 3.1.1 to 3.2.1. Janos On 22 Apr 2020, 00:58, at 00:58, "BKH-Netz.de - Postfach"

Re: Wrong dates

2020-02-04 Thread Janos SUTO
Hello, click on view headers, and paste the date header line here. Janos On 4 Feb 2020, 12:15, at 12:15, Marcelo Machado wrote: >Hello everyone. > >Can you help me why the dates are different? > >Marcelo > > >[image: tempsnip.png]

Re: Upgrade or reinstall on newer OS version ?

2020-01-10 Thread Janos SUTO
Hello Yann, I have no experience upgrading through several LTS versions. A mysql -> mariadb switch should not hurt. Anyway, be sure to backup the database, or even better snapshot the whole vm. When the os upgrade is ready, be sure to recompile Piler. Be sure to stop all piler related

Re: Authentication against multiple IMAP servers

2019-10-31 Thread Janos SUTO
Hello, then there must be a syntax error on the introduced function. Check out the error logs of the webserver. If it doesn't help, then show me the function in a private email. Janos Original Message From: BKH - Post Sent: Thu Oct 31 11:25:37 GMT+01:00 2019 To:

Re: Upgrade from 1.3.5 -> 1.3.7

2019-10-25 Thread Janos SUTO
Hello, I'll clarify this in the upgrade docs, however you may overwrite all files (except the configs), because there hasn't been any incompatible change. As a precaution, always backup your config files and especially the encryption key. Janos Original Message From: BKH -

Re: Forward messages from another server

2019-10-14 Thread Janos SUTO
Hello Marcelo, assuming you want to archive internal emails as well that provably never reach the postfix relay, I'd rather setup journaling on exchange. Janos Original Message From: Marcelo Machado Sent: Mon Oct 14 15:32:45 GMT+02:00 2019 To: Piler User Subject: Forward

Re: Cronjobs - change indexing interval

2019-08-24 Thread Janos SUTO
Hello, try this: */10 * * * * Btw. check the mail log to see if it works as required. Whenever the indexer script starts it syslogs it. Janos Original Message From: BKH Sent: Fri Aug 23 21:35:04 GMT+02:00 2019 To: piler-user@list.acts.hu Subject: Cronjobs - change

Re: Indexation of Excel files newer than 2007

2019-05-08 Thread Janos SUTO
08 10:52:33 GMT+02:00 2019 To: Piler User Subject: AW: Indexation of Excel files newer than 2007 In at least my case, this does not seem to work. BR, Christian Von: Janos SUTO Gesendet: Montag, 6. Mai 2019 11:33 An: Piler User Betreff: Re: Indexation of Excel files newer than 2007 Newer

Re: Indexation of Excel files newer than 2007

2019-05-06 Thread Janos SUTO
Newer office files, eg. xlsx, etc should be handled internally by the parser, provided that you have libzip package installed as well as the header files, libzip-dev or similar. Janos Original Message From: Katterl Christian Sent: Mon May 06 10:19:07 GMT+02:00 2019 To:

Re: How to configure info@ adresses?

2019-05-03 Thread Janos SUTO
Hello, I think it can be done using the group feature. Its purpose is to give access to another mailbox as well. You may setup the group settings as admin in the GUI. Janos Original Message From: Biderius - Sent: Fri May 03 12:34:41 GMT+02:00 2019 To:

Re: Downloaded files corrupt

2019-04-30 Thread Janos SUTO
Hello, what language file do you use? Can reproduce the issue using English? Janos Original Message From: Katterl Christian Sent: Tue Apr 30 05:45:59 GMT+02:00 2019 To: "piler-user@list.acts.hu" Subject: Downloaded files corrupt Hello, when I try to download archived

Re: Rentention-rules and pilerpurge

2018-11-14 Thread Janos SUTO
Hello Ryan, you are right about the verification hash problem. However, since you are about to purge those messages, it's probably not that big issue. Btw. the GUI compares only the message hash values, and the rest of the metadata table entries (eg. the retained column) are not used

Re: var/piler/tmp files

2018-10-18 Thread Janos SUTO
Hello Kim, you should look at the mail log to find out what happened. There might be some parsing or encoding issues. Janos Original Message From: "Kim Mølgaard" Sent: Thu Oct 18 09:18:52 GMT+02:00 2018 To: piler-user@list.acts.hu Subject: var/piler/tmp files Hi ! Piler v.

Re: Upgrading from old piler to new

2018-10-05 Thread Janos SUTO
Hello, well, the official site has a section for the upgrade. It should work. It's worth to backup the MySQL database, your configs and the piler.key. Janos Original Message From: Michael Mansour Sent: Fri Oct 05 01:47:18 GMT+02:00 2018 To: Piler User Subject: Upgrading

Re: Moved piler VM and then rsync'ed piler store

2018-10-04 Thread Janos SUTO
Hello Michael, check the ownership on all the directories down to the .m file. Janos Original Message From: Michael Mansour Sent: Thu Oct 04 14:13:49 GMT+02:00 2018 To: piler-user@list.acts.hu Subject: Moved piler VM and then rsync'ed piler store Hi Piler users, I had to

Re: CentOS 7 support only for free version

2018-07-07 Thread Janos SUTO
Hello Steve, give me some time, and I will check if I can make it on centos 7. Janos Original Message From: Stephen Ingram Sent: Sun Jul 08 01:55:10 GMT+02:00 2018 To: piler-user@list.acts.hu Subject: CentOS 7 support only for free version Is there any way to get the

Re: Limit on searchs?

2018-06-20 Thread Janos SUTO
Hello Thiago, surely not correct. In fact it's pretty bad. For starters check if the Sphinx database is fine. Janos Original Message From: Thiago Lima Sent: Wed Jun 20 00:38:54 GMT+02:00 2018 To: Piler User Subject: Limit on searchs? After a crash and rebuild of the

RE: only sent mails are stored or also received?

2018-04-12 Thread Janos SUTO
What were your issues? Perhaps I can help with them. Anyway, using pilerimport is possible, though it's not efficient as you have an ever growing mailbox, and pilerimport needs more and more time to process. Janos Original Message From: Jackson Craig

Re: only sent mails are stored or also received?

2018-04-12 Thread Janos SUTO
Hello Lucian, piler archives every email you send to it. Just configure your mail server to copy both sent and received emails to piler, and you'll be fine. Janos Original Message From: Lucian Lazar Sent: Thu Apr 12 14:20:36 GMT+02:00 2018 To:

Re: BCC not shown

2018-02-12 Thread Janos SUTO
Hello Christian, check the Sphinx query in the mail log. I suspect that your bcc address is not in the query. The fix depends on what authentication you are using. Janos Original Message From: "Christian Röser - PELMA" Sent: Mon Feb 12 17:37:09

Re: Feature Request: Disable Restore to Mailbox

2017-11-29 Thread Janos SUTO
Hello, you can disable the feature: set the smarthost parameter to an empty string. Janos Original Message From: Katterl Christian Sent: Wed Nov 29 10:43:42 GMT+01:00 2017 To: Piler User Subject: Feature Request: Disable Restore

Re: AW: LDAP Users can see other's mails

2017-11-28 Thread Janos SUTO
d by, anyone other than the addressee. If you receive this message by mistake, please advise the sender. Firmenbuch: Landesgericht Wels, FN: 407726y, ATU 68646334 Von: Janos SUTO [mailto:s...@acts.hu] Gesendet: Dienstag, 28. November 2017 08:11 An: Piler User Betreff: Re: AW: LDAP Users can see other'

Re: AW: LDAP Users can see other's mails

2017-11-27 Thread Janos SUTO
u are on. Janos On 2017-11-23 12:09, Katterl Christian wrote: > It seems that i can see all messages of members of the same ad-groups. > > > In my case, piler would not need to take care of groups….. > > VON: Janos SUTO [mailto:s...@acts.hu] > GESENDET: Donnerstag, 23. N

Re: LDAP Users can see other's mails

2017-11-23 Thread Janos SUTO
Show me the sphinx query from the mail log related to the given user. Janos Original Message From: Katterl Christian Sent: Thu Nov 23 07:35:19 GMT+01:00 2017 To: "piler-user@list.acts.hu" Subject: LDAP Users can see other's mails

Re: View all emails from a domain

2017-07-05 Thread Janos SUTO
iler-user@list.acts.hu> Subject: Re: View all emails from a domain Hi Janos. I would like an audit user to view the messages only from one domain and another audit user only from another domain. It is possible? Marcelo Gomes 2017-07-05 1:22 GMT-03:00 Janos SUTO <s...@acts.hu>: > Hell

Re: View all emails from a domain

2017-07-04 Thread Janos SUTO
Hello, a regular user can't see all emails, however an auditor user can. Janos Original Message From: Marcelo Machado Sent: Tue Jul 04 21:54:58 GMT+02:00 2017 To: piler-user@list.acts.hu Subject: View all emails from a domain Hello everyone. I have a

Re: Metadata Cleanup?

2017-07-03 Thread Janos SUTO
Hello Uwe, besides deleting from metadata table, you may delete the corresponding entries from rcpt table as well. However, my personal point of view is that the metadata table serves as a history of emails worth to keep. Anyway it's your archive. And one more thing. Sphinx uses the deleted=1

1.3.0 is soon to be released

2017-05-16 Thread Janos SUTO
Dear piler users, I'm about to release 1.3.0. It has a few new features, it's mostly a maintenance release with bugfixes, minor improvements. tl;dr #1: 1.3.0 will be released on this week tl;dr #2: if you use piler on FreeBSD or other non-Linux platform, please drop me a line. There will be

Re: Starting in Piller

2017-03-04 Thread Janos SUTO
se TCP 127.0.0.1:3206 [1] __.https://eXtremeSHOK.com .__ On 02/23/2017 11:09 PM, Janos SUTO wrote: Hello Marcelo, On 2017-02-23 21:05, Marcelo Soares wrote: Dear, Do I have to change mysqlsocket=/var/run/mysqld/mysql

Re: Starting in Piller

2017-02-23 Thread Janos SUTO
Hello Marcelo, On 2017-02-23 21:05, Marcelo Soares wrote: Dear, Do I have to change mysqlsocket=/var/run/mysqld/mysqld.sock to mariadb? (Ubuntu 16.04 MariaDB10) unlikely. Mariadb uses just the same socket file. Anyway start mariadb, then check if that socket file exists. Janos

Re: Starting in Piller

2017-02-21 Thread Janos SUTO
Hello Marcelo, I recommend ubuntu xenial x64 with mariadb 10.1 (and not the stock shipped mysql 5.7 which has some utf8 and other problems with piler). Janos On 2017-02-21 18:58, Marcelo Soares wrote: Hello Everybody, My name is Marcelo Soares, from Brazil. I am starting on Piler, i have a

Re: Verification Failure

2017-02-20 Thread Janos SUTO
894120da436b09c25e3e21522 | bbfef40739b9e1447479ef066f1d0d98bda82eba8fcdff9328df266386072ab6 | +--+--+ 1 row in set (0.00 sec) Cheers Stephan Am 09.02.2017 um 20:01 schrieb

Re: Verification Failure

2017-02-09 Thread Janos SUTO
the sha256 values you can see in pilertest output (also run sha256 ) with the stored results. Janos On 2017-02-02 11:08, Stephan Schöffel wrote: Which values should I compare? Am 01.02.2017 um 10:27 schrieb Janos SUTO: Hello Stephan, no, it shouldn't. I need some troubleshooting to figure

Re: Exclude mails with a specific header value

2017-02-08 Thread Janos SUTO
Hello, this feature is not supported. Currently your best bet is to put an MTA, eg. postfix in front of piler, and let it do the filtering. Or you may do the equivalent of this on the sending side. Janos Original Message From: Yann Lehmann Sent: Wed

Re: Verification Failure

2017-02-01 Thread Janos SUTO
ccured. Can the parser bug occur without an update? Cheers Stephan Am 31.01.2017 um 19:26 schrieb Janos SUTO: > Hello, > > On 2017-01-30 12:10, Stephan Schöffel wrote: >> >> upon trying to export emails from the archive I get about 3% >> "verification FAILED&q

Re: Verification Failure

2017-01-31 Thread Janos SUTO
Hello, On 2017-01-30 12:10, Stephan Schöffel wrote: upon trying to export emails from the archive I get about 3% "verification FAILED" messages. Unfortunately, I cannot find any log file to check what's going on. Maybe you can give me a hint. the 'verification failed' message means that the

Re: Sphinx index files rotation (and corrupted?)

2016-10-26 Thread Janos SUTO
or even mainxxx.*? If we need to move these files, using symbolic links won't be a problem? Thank you very much for the help! On Tue, Oct 25, 2016 at 2:59 PM, Janos SUTO <s...@acts.hu> wrote: > Hello, > > On 2016-10-25 21:03, apfc...@gmail.com wrote: > >> >> I've be

Re: Mysql 5.7

2016-10-24 Thread Janos SUTO
Hello Michael, On 2016-10-23 22:48, Prof. Dr. Michael Schefczyk wrote: Thank you very much for taking piler even further. While I only run a small personal installation which would qualify for the free offer of Mailarchiva, I still very much prefer truly open source software! cool :-)

Re: End Users are not seeing their email

2016-10-11 Thread Janos SUTO
You didn't provide any description what you are using, your setup, piler version, anything. Janos On Tue, 11 Oct 2016, Karl Rossing wrote: We have our email servers forwarding to mailpiler. Using the auditor account, we were able to determine that the mail is arriving in mail piler

Re: AW: Access to mails with delimiter "+"

2016-08-21 Thread Janos SUTO
y screen. You may keep it in one line). Then recompile, and run pilertest against it, and check if the To address is displayed correctly. Let me know if it works for you. Janos André -Ursprüngliche Nachricht- Von: Janos SUTO [mailto:s...@acts.hu] Gesendet: Sonntag, 21. August 2016

Re: Archive size

2016-08-12 Thread Janos SUTO
Hello Konstantin, it's possible to main merge once a week, but if it's the disk space then I'm not sure how it would help you. Hopefully pilerpurge removes the attachments as well provided that they are not referenced anymore. Unless there's a bug somewhere. Anyway your best bet is to test

Re: Web UI Display encoded Mails

2016-07-25 Thread Janos SUTO
Hello Joe, there shouldn't be such a flag. Can you send me an example email that looks wrong? And perhaps a screenshot how it looks for you. Janos Original Message From: Joe Rady Sent: Mon Jul 25 11:33:15 GMT+02:00 2016 To: piler-user@list.acts.hu

Re: Delete some special mails[Avira checked]

2016-07-14 Thread Janos SUTO
Hello, set its retention value to the past (eg. yesterday), then run the pilerpurge. Janos On 2016-07-14 15:37, Jan Novak wrote: Hi, how can i delete some manually selected mails oft he archive? Jan

Re: LDAP works via email address only and breaks SSO + allows disabled users access

2016-07-14 Thread Janos SUTO
Hello, On 2016-07-14 10:25, S T wrote: Hello, RE: LDAP + Username Currently it seems the only way to login using an LDAP connected server is to use the/an email address for a user. Whilst this works it breaks the unified username/password combo that users in our organisation are used to using

Re: existing users Not found

2016-07-13 Thread Janos SUTO
Hello, On Wed, 13 Jul 2016, Carrie Knox wrote: Here is my attempt to manually execute the mysql query mysql> SELECT user.uid, isadmin, username, realname, domain, email     -> FROM user,email     -> WHERE user.uid='email.uid  group by user.uid'     -> ORDER BY username     -> ASC  LIMIT 0,20  

Re: existing users Not found

2016-07-12 Thread Janos SUTO
Hello Carrie, On 2016-07-12 23:10, Carrie Knox wrote: The issue that I am seeing is that when I login as admin@local and select administration -> users, no existing users are listed. I would expect to see the admin@local, auditor@local and listarchive@local accounts, but instead I am

Re: no mails can be found after imap import

2016-06-29 Thread Janos SUTO
Hello, this is the problem: SELECT id FROM main1,dailydelta1,delta1 WHERE       folder IN () AND ^^^ To fix it you have to login as administrator and assign some folders to the given user. He should relogin, and verify on the

Re: Problem: SSO Debian 8 Piler 1.1.1 not working (smbd 2:4.2.10+dfsg-0+deb8u3)

2016-06-29 Thread Janos SUTO
Enable debug log level in apache, then how me all the apache entries related to the SSO login. Janos Original Message From: Herman Harperink Sent: Wed Jun 29 08:26:34 GMT+02:00 2016 To: "piler-user@list.acts.hu" Subject:

Re: Piler new manual installation does not show archived mail in the search console

2016-06-22 Thread Janos SUTO
See the download section on the official site. You should really read the site. Janos On Jun 22, 2016, 14:25, at 14:25, Mahmoud Ramadan wrote: >Thanks Janos , yes the newer Sphinx version solved my issue , but i >noticed >that the URL of Piler source code on

Re: MTA / Mail resending[Avira checked]

2016-06-21 Thread Janos SUTO
On Tue, 21 Jun 2016, Jan Novak wrote: Dear piler user, i have installed the piler vm and it works great. 2 questions: 1.) how can a user resend a mail in archive back to him out oft he WebGui as normal user? click on the restore link in the preview pane (make sure you have set the

Re: Piler new manual installation does not show archived mail in the search console

2016-06-21 Thread Janos SUTO
. Janos On Jun 21, 2016, 09:55, at 09:55, Mahmoud Ramadan <mahmoud.ramadan@gmail.com> wrote: >My Sphinx version is >root@Piler-VM:~# search >Sphinx 2.0.4-release (r3135) > > and Piler version is >root@Piler-VM:~# piler -v >piler 1.1.1, build 904, Janos SUTO <s.

Re: Piler new manual installation does not show archived mail in the search console

2016-06-21 Thread Janos SUTO
tribute size (32) > >Thanks in advance. > > >Best Regards, > >Mahmoud Ramadan Ali > >Network and VOIP Specialist. > >Mobil: (+2) 01276877112 > >Blog <http://hotciscolabs.blogspot.com/>| Website ><http://telecomandsecurity.com/>| LinkedIn ><http

Re: Piler new manual installation does not show archived mail in the search console

2016-06-20 Thread Janos SUTO
c) >> >> mysql> use piler; >> Database changed >> mysql> select * main1,daildelta1,delta1; >> ERROR 1064 (42000): You have an error in your SQL syntax; check the >manual >> that corresponds to your MySQL server version for the right syntax to >use >> ne

Re: AW: Error when using " Download the selected PDF " feature in the end user web GUI.

2016-06-14 Thread Janos SUTO
On 2016-06-14 19:59, André Peters wrote: The directory is probably just not writeable by the user who runs piler. almost. The directory must be writable by the webserver, eg. www-data, apache, etc. Btw. note that the installer takes care of it. Janos VON: Mahmoud Ramadan

Re: Single mail stuck in queue, smtp times out

2016-06-03 Thread Janos SUTO
Hello Andre, what piler version do you have? Also try increase the verbosity level to see at which stage the connection is stuck. And finally it would be useful to see an ngrep output for only this specific email. Anyway you may zip this email and send it to me. Janos On Jun 3, 2016,

Re: Diskspace of archive

2016-06-02 Thread Janos SUTO
Piler compresses and deduplicates emails. 1.2GB is the raw size, 165 MB is the size on the disk. Janos On Jun 2, 2016, 16:46, at 16:46, Yann Lehmann wrote: > >Hi > >On the stats page of my test-installation of Piler, the 'Archive size' >is showed as '1.2 GB (165 MB)'. >

Re: Some questions about piler (user rights, ignored messages, etc)

2016-05-24 Thread Janos SUTO
Hello, On 2016-05-24 16:55, Yann Lehmann wrote: Hi, I am new to piler and after some trouble, I have a working system that I will test in the next days. I have some questions about the use of piler: 1) User rights I would like one user being able to see all messages. Do I have to grant this

Re: piler on arm-based device

2016-04-19 Thread Janos SUTO
Hello Yann, I've never tried to port piler to ARM. However, I'm curious whether it can be compiled at all. Unfortunately I don't have access to such a device. If you can't make it, and can afford to provide some access to the device, then I may try to do the job. No promises, though. Janos On

Re: Folders

2016-04-10 Thread Janos SUTO
Hello Raimer, On 2016-04-09 14:12, Raimar Sandner wrote: Hi all, I'm reaching out one more time, maybe someone can help me with this folders- problem described below. Cheers Raimar On Montag, 1. Februar 2016 13:51:51 CEST Raimar Sandner wrote: I'm having trouble making folders work in

Re: Pilerpurge and attachments

2016-04-05 Thread Janos SUTO
Hello Konstantin, the 0.1.25 release was an interim build between two major releases, and I don't plan to support fixes for that, sorry. I suggest to upgrade to either 1.1.1, and I believe that this issue would be gone. Janos On 2016-04-04 17:02, Konstantin wrote: Hello Janos I found

RE: 3 Message with wrong 2036 date

2016-03-02 Thread Janos SUTO
Hello Edwin, can you show me the headers for these emails? In Tim's case it turned out there were some bogus Date: headers, and we managed to fix it with a manual sphinx update. Janos On 2016-02-18 17:17, Nichols, Edwin (BeneFACT) wrote: Strangely, I have the same issue with 8 emails. The

Re: Too Many Duplicate Messages With " message-id: null "

2016-03-02 Thread Janos SUTO
On 2016-02-29 12:06, Mahmoud Ramadan wrote: Hi dears I'm getting too many duplicated messages on Piler and by checking my logs i found that the messages are received by Piler without message ID (null) so Piler discards them. Is there is any way to force Piler to accept duplicated messages and

Re: Some Piler Messages are displayed with " Message Failed Verification ".

2016-03-02 Thread Janos SUTO
On 2016-02-29 13:37, Mahmoud Ramadan wrote: Update: I noticed something weird ! When i changed the Piler contact settings in Exchange to enable " Use MAPI rich text format" then all please don't, as it forces exchange to transform the email, and this practice may contradict with some

SECURITY ALERT: the drown attack

2016-03-02 Thread Janos SUTO
Dear piler-users, you probably have heard about the drown attack against (see https://drownattack.com/ for more) tls/ssl. In a nutshell it targets services (http, smtp, imap, pop3, etc) allowing ssl v2 connections as well. Piler 1.1.1 uses TLSv1_client_method() and TLSv1_server_method()

Re: User that can read all mailboxes

2016-02-29 Thread Janos SUTO
x_matches=1000' >> in 0.00 s, 3 hits, 3 total found >> >> But as there are more mails from the past, which I tried using the >> search field with dates, etc before I'm unsure if that works well. >> >> >> >> 2016-02-20 22:00 GMT+01:00 Janos SUTO &l

Re: User that can read all mailboxes

2016-02-29 Thread Janos SUTO
s, etc before I'm unsure if that works well. 2016-02-20 22:00 GMT+01:00 Janos SUTO <s...@acts.hu>: I asked you to hit the search button, then show me the sphinx query, not "type *, then hit the search button, and show me the sphinx query". Note that there's indeed wildcard search

Re: User that can read all mailboxes

2016-02-20 Thread Janos SUTO
! 2016-02-17 15:25 GMT+01:00 Janos SUTO <s...@acts.hu>: hit the search button, then show me the matching sphinx query (look in the mail log). Janos On 2016-02-17 13:43, Matt . wrote: Sure I did but whatever I search I get back no results. Crons are running. Do you have a wildcard exa

Re: 3 Message with wrong 2036 date

2016-02-18 Thread Janos SUTO
show me the Date: headers from these 3 emails. Janos On 2016-02-18 15:45, Tim Stumbo wrote: I have 3 messages that always appear at the top of the search field due to them having an incorrect date. The year on the messages is 2036. I would like to either delete these 3 e-mails or fix the index

Re: Modify Indexer Cron Job

2016-02-17 Thread Janos SUTO
On Wed, 17 Feb 2016, Tim Stumbo wrote: We would like the indexer job to run every 5 minutes instead of 30. Is that an easy adjustment?  yes. Edit piler's crontab, and you are done. Janos

Re: User that can read all mailboxes

2016-02-17 Thread Janos SUTO
hit the search button, then show me the matching sphinx query (look in the mail log). Janos On 2016-02-17 13:43, Matt . wrote: Sure I did but whatever I search I get back no results. Crons are running. Do you have a wildcard example that should always work ? 2016-02-17 13:41 GMT+01:00

Re: Urgent: Piler " Message Failed Verification " Issue.

2016-02-15 Thread Janos SUTO
It seems that pilerget can return only the headers of the message and not the body. If you indeed copied the whole output to the message you sent, then it must be an error. However in that case pilerget syslogs the problem. Please check for that problem. Janos On 2016-02-13 18:27, Mahmoud

changes in the bitbucket issue tracker

2016-01-29 Thread Janos SUTO
Dear piler users, I've decided to fix the bitbucket issue tracker settings, and disallow creating issues as anonymous. I expected the bitbucket jira issue tracker as a tool allowing piler users to report bugs found in the software. And actually it has happened. However other things also

Re: error importing 'xxxx-imap-xxxxx.txt'

2016-01-24 Thread Janos SUTO
Hello Michael, I've just reviewed the code, and found the matching part for each open() and fopen() calls. Can you provide more clues, error messages, etc. on the matter? Janos On 2016-01-14 16:57, Michael Volz wrote: I kind of solved the problem. The problem was that the pilerimport process

Re: MS Exhange Impersonation Issue With Piler .

2016-01-16 Thread Janos SUTO
Hello Mahmoud, On Sat, 16 Jan 2016, Mahmoud Ramadan wrote: I've successfully configured Piler integration with MS Exchange 2007 using Jornaling and everything is working fine. But i have an issue with Exhange Impersonation,I've configured user "mahmoud.aly" to get full access on user's

Re: error importing 'xxxx-imap-xxxxx.txt'

2016-01-14 Thread Janos SUTO
I'd like you to view src/message.c, and locate process_message() function around the 265th line. It has the following line in the ~283rd row: fd = open(state->message_id_hash, O_CREAT|O_EXCL, S_IRUSR|S_IWUSR); please check if you can see a few lines below that it has the following as well:

Re: Basic Pilar Questions Before Setup With MS Exchange 2007.

2016-01-14 Thread Janos SUTO
Hello Mahmoud, On Thu, 14 Jan 2016, Mahmoud Ramadan wrote: I'm planning to use Pilar and integrate it with MS Exchange 2007 for archiving BUT i need clarification regarding some points that I'm confused about. 1.How MS Exchange will send E-Mails for archiving to Pilar , i mean what are the

Re: New Install issues

2015-12-01 Thread Janos SUTO
On Mon, 30 Nov 2015, Warren H. Prince wrote: Thanks for getting back to me, but I?m still stuck. I got rid of postfix on the Piler server and can see email for arch...@princelaw.com mounting up on the mail server. I have enabled IMAP_AUTH and SSL. From the command line, if I issue:

Re: New Install issues

2015-12-01 Thread Janos SUTO
On Mon, 30 Nov 2015, Warren H. Prince wrote: Thanks for getting back to me, I?ve made some progress, but still not quite home.  I was able to import some email with the command: pilerimport -i mail.princelaw.com -u arch...@piler.princelaw.com -p -P 993 And I can search that data, but I?ve

Re: Empty message body

2015-11-30 Thread Janos SUTO
Hello Konstantin, Can you please clarify what exactly delete pilerpurge ? Will piler use old sig value from piler.attachment if an attachment was removed for the new attachment with same name,type and size? it shouldn't, however if it does, then it's definitely a bug. The pilerpurge utility

Re: Custom Skin

2015-11-10 Thread Janos SUTO
Hello Stephen, On 2015-11-10 16:28, srisin...@meintl.com wrote: 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

Re: retention time considerations

2015-11-02 Thread Janos SUTO
byte long type. For dates < 2106 4 byte data type is fine. If you plan to use piler in the next century, then you should use bigint types for sent, arrived and retained columns. Janos On 11/1/15, 6:53 AM, "Janos SUTO" <s...@acts.hu> wrote: Dear piler users, piler

retention time considerations

2015-11-01 Thread Janos SUTO
Dear piler users, piler uses a 4 byte value to store the retention timestamp. The trouble is that it has 23 more years of support, ie. up to 2038. Usually it's not a problem, since most people keep emails for 3-10 years. However, what if you have to store emails for a longer time, eg. to

Re: Pilerimport - IMAP help

2015-10-28 Thread Janos SUTO
thanks for the replies. Perhaps it's worth to share what you did on the windows side, eg. what commands you ran, etc. before running pilerimport. Janos On 2015-10-28 16:14, Cristiano Manzoni wrote: pilerimport -i exchange.test.local -u test.local/userwithrights/usermailbox -p Password -P 993

RE: Exchange 2010 journal user messages appearing in archive

2015-10-19 Thread Janos SUTO
On 2015-10-19 21:18, Jason Morrill wrote: Thank you for the suggested solution. It seems to have fixed my problem: Edit /usr/local/etc/piler.conf Revised, hostid= with my server name Save changes Restart rc.piler Now records in the database don't have the extra recipient, jour...@here.com

Re: Exchange 2010 journal user messages appearing in archive

2015-10-19 Thread Janos SUTO
Hello Jason, On 2015-10-19 18:40, Jason Morrill wrote: I am journaling all messages to/from our Exchange 2010 server. I followed the instructions creating a mail contact, enabling journaling, and creating the Send Connector. And it's working great ... except ... all messages are being stored

Re: beginner/install question, trying to use with docker

2015-10-18 Thread Janos SUTO
On 2015-10-18 00:54, Justin Mecham wrote: A very accomplished developer friend of mine places all of his static things in one docker image and all the acid/volatile data in another. ok, then it's a vote for a single docker image Janos

Re: beginner/install question, trying to use with docker

2015-10-16 Thread Janos SUTO
Hello Stefan, On 2015-10-16 12:52, stefanz wrote: I wanted to try out piler, recently looked at docker (also a beginner) I thought this was a good idea. So my first question: Is there a docker image available? yes: https://bitbucket.org/jsuto/piler/downloads/docker-896.tar.gz Note that

high availability options

2015-10-05 Thread Janos SUTO
Dear piler-users, I've got a feature request for DAG-like high resiliency. I've designed piler to run on a single host only. However it's a valid business demand that let the archive be fault tolerant. Though piler has no builtin high availability feature, something close might be achieved.

RE: Search Issues

2015-10-01 Thread Janos SUTO
On 2015-09-30 22:47, srisin...@meintl.com wrote: 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

Re: Search Issues

2015-09-30 Thread Janos SUTO
Hello Stephen, On 2015-09-30 16:37, srisin...@meintl.com wrote: 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:

Re: Pilerimport - periodical import

2015-09-30 Thread Janos SUTO
Hello, On 2015-09-30 18:42, Federico wrote: if I use pilerimport from an external IMAP mailbox, does it retrieve *every time* all the messages or it will keep track of the index number of the already downloaded one? In other terms, the "de-duping" is done before importing or after importing?

Re: sph_index table not populated after imap import

2015-09-21 Thread Janos SUTO
Hello Cristiano, On 2015-09-21 10:00, Cristiano Manzoni wrote: we've a strange situation here, after import all user's email via imap, the sph_index table is not populated and so the search doesn't show results. is there any error message on stdout or in mail log? I've to stop cron jobs

Re: Upgrading/updating Piler

2015-09-08 Thread Janos SUTO
Hello Stephen, On 2015-09-08 20:06, srisin...@meintl.com wrote: So, I'm looking at updating Piler to the latest Master Branch. We have Exchange 2007 for our mail server, so I believe I can pause (or suspend) our SMTP queue for piler.meintl.com. Assuming I'm doing this during a low-email period

imap import issue

2015-08-31 Thread Janos SUTO
Dear piler users, an odd bug has been discovered in the imap import feature of piler, see https://bitbucket.org/jsuto/piler/issues/593/emails-are-removed-from-imap-server-when for more. Workaround: Do NOT use -r with -D Fix: Apply the following patch to src/imap.c diff --git a/src/imap.c

Re: Housekeeping after email purging.

2015-08-27 Thread Janos SUTO
On 2015-08-27 08:57, Ross Gailer wrote: If you are seeing ghosts, then chances are that the actual email has been removed. I believe that the lists shown in the GUI are built from the Sphinx search results. If the files have been removed and the index has not been updated, you will end up with

  1   2   3   >