Re: Piler auditor login error

2021-06-30 Thread Marcelo Machado
Commenting this line and the line 814 worked for me.

Thanks

Em sáb., 26 de jun. de 2021 às 10:00,  escreveu:

>
>
> Hello,
>
> On 2021-06-25 21:34, Marcelo Machado wrote:
> >
> > I did a fresh installation of Mail Piler version 1.3.11 on Ubuntu
> > 16.04 and when I log in with auditor user, the error message "HTTP
> > ERROR 500" appears.
> >
> > The apache error log shows the error "PHP Parse error: syntax error,
> > unexpected '=' in /var/piler/www/model/search/search.php on line 734"
>
> Though I use nginx and not apache, I can't reproduce the issue.
> Anyway, try commenting out this line.
>
> Janos
>
>


Piler auditor login error

2021-06-25 Thread Marcelo Machado
Hello.

I did a fresh installation of Mail Piler version 1.3.11 on Ubuntu 16.04 and
when I log in with auditor user, the error message "HTTP ERROR 500" appears.

The apache error log shows the error "PHP Parse error: syntax error,
unexpected '=' in /var/piler/www/model/search/search.php on line 734"

Can someone help me?

P.S. With the admin user everything is normal.

Marcelo


Re: Deleting emails

2020-07-22 Thread Marcelo Machado
Thank you again Janos.

Em qua., 22 de jul. de 2020 às 17:33,  escreveu:

>
>
> Hello Marcelo,
>
> connect to the piler mysql database, and execute the following query:
>
> update metadata set retained=10 where id > x;
>
> Then let pilerpurge.py take care of the rest.
>
> x: is the numeric id of the last email you want to keep.
> Make sure to double check, because after purging the emails
> they are gone for good.
>
> Janos
>
> On 2020-07-22 00:49, Marcelo Machado wrote:
> > Hello everyone.
> >
> > How to delete emails from a specific date until the end of all stored
> > emails?
> >
> > Marcelo Gomes
>
>


Re: Enterprise edition

2020-07-22 Thread Marcelo Machado
Janos, I'm sorry if I was misunderstood.
I didn't know the piler.com website and I accidentally entered it thinking
I was accessing the piler.org website.
It was a mess on my part so I asked the question.
Sorry if I caused a problem.

Marcelo

Em qua., 22 de jul. de 2020 às 16:08,  escreveu:

>
>
> I'd like to clarify a few things. I'll use the following conventions
> in this email to distinguish between the open source and commercial
> editions of piler:
>
> - 'piler': the open source email archiving project
> - 'piler-ee': the commercial, enterprise version of piler
>
>
> I'm a huge fan of open source projects, and even though I'm working on a
> paid, commercial product of piler-ee, I'd like to emphasize that
>
> - I intend to keep piler open source, you have access to the source code
> - I won't remove any feature from piler to make piler-ee more attractive
> - I won't force you to switch to piler-ee*
> - You can use piler for whatever purposes absolutely free of charge
>
>
> Note that despite piler doesn't have the word 'enterprise' among its
> adjectives,
> it doesn't mean it's a crappy product you shouldn't use it for company
> purposes. It's quite the opposite. I believe that piler is a decent
> product
> for a secure email archive (especially if you regularly backup its key
> components,
> but that's a story for another day).
>
> However, I've been looking for ways to monetize the popularity of piler,
> so I've decided to fork it, and been working on piler-ee, including
> commercial
> services as well even for piler.
>
> *: check out https://mailpiler.com/ if you are curious what piler-ee
> offers for you.
>
>
> Janos
>
>
> On 2020-07-22 18:07, Martin Nadvornik wrote:
> > Hi Marcelo,
> >
> > can't speek for Janos, the developer of Piler, but I am not aware of
> > any changes. What did you read that leads you into thinking piler is
> > not open source anymore?
> > The source code is available like always at
> > https://bitbucket.org/jsuto/piler/src/master/ and the master branch
> > had the last commit 4 days ago...
> >
> > There has always been an enterprise edition (at least as long as I
> > know the project) but you are not required to pay anything to use
> > piler when using the open source version.
> >
> > Or maybe you got confused because the site currently seems a bit
> > broken and clicking on "GoBD notes" leads to the enterprise
> > documentation. The normal documentation ist still reachable under
> > http://www.mailpiler.org/wiki/current:index however.
> >
> > Janos: FYI the website seems broken. I guess "Please fill or disable
> > this placeholder" is not something that is supposed to be there :)
> >
> > Regards,
> > Martin
> >
> > Am 2020-07-22 17:51, schrieb Marcelo Machado:
> >> Hello everyone.
> >>
> >> Is Mail Piler only commercial now?
> >>
> >> Does the Open Source Edition still exist?
> >>
> >> Marcelo Gomes
>
>


Re: Enterprise edition

2020-07-22 Thread Marcelo Machado
Sorry,
Please disregard the previous message.

Marcelo

Em qua., 22 de jul. de 2020 às 12:51, Marcelo Machado 
escreveu:

> Hello everyone.
>
> Is Mail Piler only commercial now?
>
> Does the Open Source Edition still exist?
>
> Marcelo Gomes
>


Enterprise edition

2020-07-22 Thread Marcelo Machado
Hello everyone.

Is Mail Piler only commercial now?

Does the Open Source Edition still exist?

Marcelo Gomes


Deleting emails

2020-07-21 Thread Marcelo Machado
Hello everyone.

How to delete emails from a specific date until the end of all stored
emails?

Marcelo Gomes


Re: Empty message header and body

2020-07-16 Thread Marcelo Machado
Sorry. My fault.

Em qui., 16 de jul. de 2020 às 16:52,  escreveu:

>
>
> On 2020-07-16 21:35, Marcelo Machado wrote:
> > Just an observation.
> > The migration documentation on the website does not mention anything
> > about the piler.key file.
>
> "Make sure that piler.key on NEW is the same as on OLD, and if the 'iv'
> parameter is set on OLD in piler.conf, it must have the same value on
> NEW."
>
> See http://www.mailpiler.org/wiki/current:migration-to-new-host for
> more.
>
> Janos
>
>


Re: Empty message header and body

2020-07-16 Thread Marcelo Machado
Just an observation.
The migration documentation on the website does not mention anything about
the piler.key file.


Em qui., 16 de jul. de 2020 às 15:56,  escreveu:

>
>
> On 2020-07-16 20:31, Marcelo Machado wrote:
> > - is there an iv parameter in the old host's piler.conf file?
> > No.
> >
> > - are the piler.key files on old and new host identical?
> >
> > Not also.
>
> That's the problem. Legacy emails can be decrypted with old piler.key
> only.
> However, you started to encrypt new emails with a different key.
>
> I suggest you to stop piler, then export all new emails, and start over
> the migration process. Be sure to use piler.key from old host.
>
> Verify that you can access legacy emails on the new host, and then
> import the exported emails.
>
> Janos
>
>


Re: Empty message header and body

2020-07-16 Thread Marcelo Machado
OK. I will try.
Thank you.

Em qui., 16 de jul. de 2020 às 15:56,  escreveu:

>
>
> On 2020-07-16 20:31, Marcelo Machado wrote:
> > - is there an iv parameter in the old host's piler.conf file?
> > No.
> >
> > - are the piler.key files on old and new host identical?
> >
> > Not also.
>
> That's the problem. Legacy emails can be decrypted with old piler.key
> only.
> However, you started to encrypt new emails with a different key.
>
> I suggest you to stop piler, then export all new emails, and start over
> the migration process. Be sure to use piler.key from old host.
>
> Verify that you can access legacy emails on the new host, and then
> import the exported emails.
>
> Janos
>
>


Re: Empty message header and body

2020-07-16 Thread Marcelo Machado
- is there an iv parameter in the old host's piler.conf file?
No.

- are the piler.key files on old and new host identical?
Not also.

Em qui., 16 de jul. de 2020 às 02:55,  escreveu:

> Usually I don't require any sensitive information to troubleshoot,
> eg. your mysql password, or even the attached encryption key.
>
> Anyway, I can see that no 'iv' parameter in piler.conf on the
> new host. However,
>
> - is there an iv parameter in the old host's piler.conf file?
> - are the piler.key files on old and new host identical?
>
> Janos
>
> On 2020-07-16 00:42, Marcelo Machado wrote:
> > In attachment is my piler.key
> >
> > Below is my piler.conf (I changed the domain):
> >
> > archive_emails_not_having_message_id=0
> > archive_only_mydomains=0
> > backlog=20
> > check_for_client_timeout_interval=20
> >
> cipher_list=ECDH+AESGCM:DH+AESGCM:ECDH+AES256:DH+AES256:ECDH+AES128:DH+AES:ECDH+3DES:DH+3DES:RSA+AESGCM:RSA+AES:RSA+3DES:!aNULL:!MD5:!DSS
> > clamd_socket=/tmp/clamd
> > default_retention_days=90
> > enable_chunking=0
> > enable_cjk=0
> > enable_folders=0
> > encrypt_messages=1
> > extract_attachments=1
> > extra_to_field=X-Envelope-To:
> > helper_timeout=20
> > hostid=arch...@piler.mydomain.com.br
> > listen_addr=0.0.0.0
> > listen_port=2525
> > max_connections=64
> > max_requests_per_child=1
> > memcached_servers=127.0.0.1
> > memcached_to_db_interval=900
> > memcached_ttl=86400
> > min_message_size=100
> > min_word_len=1
> > mmap_dedup_test=0
> > mysqlcharset=utf8mb4
> > mysql_connect_timeout=2
> > mysqldb=piler
> > mysqlpwd=n3ts0l
> > mysqlsocket=/var/run/mysqld/mysqld.sock
> > mysqluser=piler
> > number_of_worker_processes=2
> > pemfile=/usr/local/etc/piler/piler.pem
> > pidfile=/opt/run/piler/piler.pid
> > piler_header_field=X-piler-id:
> > process_rcpt_to_addresses=0
> > server_id=0
> > smtp_timeout=60
> > spam_header_line=X-Spam-Flag: YES
> > syslog_recipients=0
> > tls_enable=1
> > tweak_sent_time_offset=0
> > update_counters_to_memcached=0
> > username=piler
> > verbosity=1
> > workdir=/opt/piler/tmp
> > queuedir=/opt/piler/store
> >
> > Em qua., 15 de jul. de 2020 às 08:33, Janos SUTO 
> > escreveu:
> >
> >> Sorry, piler.key is a file, not an entry in piler.conf.
> >>
> >> Janos
> >> On 15 Jul 2020, at 12:25, Marcelo Machado 
> >> wrote:
> >>
> >> Thanks for the answer.
> >>
> >> The parameter iv is cipher_list.There is no line with piler.key.
> >> I was unable to read the contents of piler.key.
> >>
> >> Marcelo
> >>
> >> Em qua., 15 de jul. de 2020 às 00:46, Janos SUTO < s...@acts.hu>
> >> 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 < mmgom...@gmail.com>
> >> wrote:
> >>
> >> Hello everyone.
> >>
> >> After I migrated MailPiler to a new hardware, the header and body of
> >> old messages no longer appear. The new ones are OK.
> >>
> >> I followed the migration documentation on the website.
> >>
> >> Marcelo Gomes
>


Re: Empty message header and body

2020-07-15 Thread Marcelo Machado
I copied the folders: mysql, sphinx and store, and didn't change the
parameter iv.
So far I haven't found that parameter either.

Em qua., 15 de jul. de 2020 às 20:38, ad...@extremeshok.com <
ad...@extremeshok.com> escreveu:

> Do you know if the IV or key value changed ?
>
> Ie. Did you copy the key file from the old server and use the old servers
> config or the old servers IV value ?
>
>
>
> > On 16 Jul 2020, at 00:43, Marcelo Machado  wrote:
> >
>


Re: Empty message header and body

2020-07-15 Thread Marcelo Machado
In attachment is my piler.key

Below is my piler.conf (I changed the domain):
archive_emails_not_having_message_id=0
archive_only_mydomains=0
backlog=20
check_for_client_timeout_interval=20
cipher_list=ECDH+AESGCM:DH+AESGCM:ECDH+AES256:DH+AES256:ECDH+AES128:DH+AES:ECDH+3DES:DH+3DES:RSA+AESGCM:RSA+AES:RSA+3DES:!aNULL:!MD5:!DSS
clamd_socket=/tmp/clamd
default_retention_days=90
enable_chunking=0
enable_cjk=0
enable_folders=0
encrypt_messages=1
extract_attachments=1
extra_to_field=X-Envelope-To:
helper_timeout=20
hostid=arch...@piler.mydomain.com.br
listen_addr=0.0.0.0
listen_port=2525
max_connections=64
max_requests_per_child=1
memcached_servers=127.0.0.1
memcached_to_db_interval=900
memcached_ttl=86400
min_message_size=100
min_word_len=1
mmap_dedup_test=0
mysqlcharset=utf8mb4
mysql_connect_timeout=2
mysqldb=piler
mysqlpwd=n3ts0l
mysqlsocket=/var/run/mysqld/mysqld.sock
mysqluser=piler
number_of_worker_processes=2
pemfile=/usr/local/etc/piler/piler.pem
pidfile=/opt/run/piler/piler.pid
piler_header_field=X-piler-id:
process_rcpt_to_addresses=0
server_id=0
smtp_timeout=60
spam_header_line=X-Spam-Flag: YES
syslog_recipients=0
tls_enable=1
tweak_sent_time_offset=0
update_counters_to_memcached=0
username=piler
verbosity=1
workdir=/opt/piler/tmp
queuedir=/opt/piler/store

Em qua., 15 de jul. de 2020 às 08:33, Janos SUTO  escreveu:

> Sorry, piler.key is a file, not an entry in piler.conf.
>
> Janos
> On 15 Jul 2020, at 12:25, Marcelo Machado  wrote:
>>
>> Thanks for the answer.
>>
>> The parameter iv is cipher_list.There is no line with piler.key.
>>  I was unable to read the contents of piler.key.
>>
>> Marcelo
>>
>> Em qua., 15 de jul. de 2020 às 00:46, Janos SUTO < s...@acts.hu> 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 < mmgom...@gmail.com> wrote:
>>>>
>>>> Hello everyone.
>>>>
>>>> After I migrated MailPiler to a new hardware, the header and body of
>>>> old messages no longer appear. The new ones are OK.
>>>>
>>>> I followed the migration documentation on the website.
>>>>
>>>> Marcelo Gomes
>>>>
>>>


piler.key
Description: Binary data


Re: Empty message header and body

2020-07-15 Thread Marcelo Machado
Thanks for the answer.

The parameter iv is cipher_list.There is no line with piler.key.
 I was unable to read the contents of piler.key.

Marcelo

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:
>>
>> Hello everyone.
>>
>> After I migrated MailPiler to a new hardware, the header and body of old
>> messages no longer appear. The new ones are OK.
>>
>> I followed the migration documentation on the website.
>>
>> Marcelo Gomes
>>
>


Empty message header and body

2020-07-14 Thread Marcelo Machado
Hello everyone.

After I migrated MailPiler to a new hardware, the header and body of old
messages no longer appear. The new ones are OK.

I followed the migration documentation on the website.

Marcelo Gomes


Re: Wrong dates

2020-02-04 Thread Marcelo Machado
Thank you Janos. Below is the header:

Received: from webmail.caparao.com.br (localhost.localdomain [127.0.0.1])
by webmail.caparao.com.br (Postfix) with ESMTPS id 16F5422185D;
Thu, 23 Jan 2020 17:12:34 -0300 (BRT)
Received: from webmail.caparao.com.br (localhost.localdomain [127.0.0.1])
by webmail.caparao.com.br (Postfix) with ESMTPS id ED5FC221864;
Thu, 23 Jan 2020 17:12:33 -0300 (BRT)
X-Envelope-To: despacha...@caparao.com.br
Received-SPF: Pass (sender SPF authorized) identity=mailfrom;
client-ip=201.76.49.219; helo=mail49219.hm1479.locaweb.com.br;
envelope-from=cont...@5ribh.com.br;
receiver=despacha...@caparao.com.br
Received: from mail49219.hm1479.locaweb.com.br
(mail49219.hm1479.locaweb.com.br [201.76.49.219])
by webmail.caparao.com.br (Postfix) with ESMTP id 5C975221867
for ; Thu, 23 Jan 2020 17:12:24 -0300 (BRT)
Received: from mcbain0002.correio.biz (189.126.112.13) by
mail4970.hm1479.locaweb.com.br id h57v0i16a4cr for
; Thu, 23 Jan 2020 17:11:45 -0300
(envelope-from )
Received: from proxy.email-ssl.com.br (bartf0023.email.locaweb.com.br
[10.31.120.55])
by mcbain0002.correio.biz (Postfix) with ESMTP id 669D080A047
for ; Thu, 23 Jan 2020 17:11:48 -0300 (-03)
x-locaweb-id: 
7IXqHEDRUUynpbi3_fb1Ab1kq2blRCjAMQOs7MZcNIEK0NhMSjup06QpzsBwlH0HYjxXfWh-BqmJMxqMQc5IR8a1Mklv9LuA1z7kFiIieMKAD3lEi6nv3LJqM5SawpPMRlQCkIqLZx7KshjHSCdaHohf0noNFDGw9vroulFclFs-p-l_bQsvxC3ReHTo3MbBiBYDBkeHTygSR-JlL-4efA==
NjM2ZjZlNzQ2MTc0NmY0MDM1NzI2OTYyNjgyZTYzNmY2ZDJlNjI3Mg==
X-LocaWeb-COR: locaweb_2009_x-mail
X-AuthUser: cont...@5ribh.com.br
Received: from Server (unknown [177.182.244.159])
(Authenticated sender: cont...@5ribh.com.br)
by proxy.email-ssl.com.br (Postfix) with ESMTPA id 507BD9A036A
for ; Thu, 23 Jan 2020 17:12:16 -0300 (-03)
Date: Thu, 23 Jan 2020 20:11:30 UT
From: cont...@5ribh.com.br
Subject: =?iso-8859-1?Q?CART=D3RIO_DO_QUINTO_OFICIO_DE_BELO_HORIZONTE_-_Pr?=
 =?iso-8859-1?Q?otocolo_283455_PRONTO?=
To: despacha...@caparao.com.br
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <20200123201216.507bd9a0...@proxy.email-ssl.com.br>
X-yoursite-MailScanner-Information: Please contact the ISP for more information
X-yoursite-MailScanner-ID: 5C975221867.A9E6C
X-yoursite-MailScanner: No virus found
X-yoursite-MailScanner-SpamCheck: not spam, SpamAssassin (not cached,
score=2.1, required 3.7, BAYES_50 0.80, JMQ_SPF_NEUTRAL 0.50,
KAM_ASCII_DIVIDERS 0.80, SPF_HELO_NONE 0.00, SPF_PASS -0.00)
X-yoursite-MailScanner-SpamScore: ss
X-yoursite-MailScanner-From: cont...@5ribh.com.br
X-Spam-Status: No


Em ter., 4 de fev. de 2020 às 08:40, Janos SUTO  escreveu:

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


Re: Forward messages from another server

2019-10-14 Thread Marcelo Machado
Thanks for your quick reply.
I think I expressed myself poorly.
All messages to and from Exchange go through Postfix. I need all these
messages to be forwarded to MailPiler.

Marcelo

Em seg, 14 de out de 2019 às 11:11, Janos SUTO  escreveu:

> 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
> ------
> *From:* Marcelo Machado
> *Sent:* Mon Oct 14 15:32:45 GMT+02:00 2019
> *To:* Piler User
> *Subject:* Forward messages from another server
>
> I have a postfix that works as relay from an Exchange server. How do I get
> postfix to forward these messages to Mailpiler?
>
> Marcelo Gomes
>


Forward messages from another server

2019-10-14 Thread Marcelo Machado
I have a postfix that works as relay from an Exchange server. How do I get
postfix to forward these messages to Mailpiler?

Marcelo Gomes


Message Failed Verification

2019-02-23 Thread Marcelo Machado
Hello everyone.

After migrate piler to a new hardware, my old messages are showing "Message
Failed Verification" and the header/body empty. New messages are normal.

Someone can help me?

Marcelo Gomes


Internal messages

2018-02-15 Thread Marcelo Machado


I need to archive only messages from my domain to my domain.

This is possible?

Marcelo



Re: Partition Projected to be Full in

2018-02-15 Thread Marcelo Machado


That´s it Daniel.

Thank you.

Marcelo

2018-02-15 9:20 GMT-02:00 Daniel Abegglen <daniel.abegg...@gmail.com>:
> Try $config['DATA_PARTITION'] = '/'; in config-site.php
> Hope I understud your question correct.
>
>
> 2018-02-15 12:14 GMT+01:00 Marcelo Machado <mmgom...@gmail.com>:
>>
>>
>>
>> Hello everyone.
>>
>> Where I change the folder in "Partition Projected to be Full" in Helth
>> Monitor screen.
>>
>> My Piler installation is not in /var.
>>
>> Marcelo
>>
>



Re: View all emails from a domain

2017-07-05 Thread Marcelo Machado


Janos, I set ENABLE_SAAS to 1 and worked fine.

Thank you so much

Marcelo

2017-07-05 10:44 GMT-03:00 Janos SUTO <s...@acts.hu>:
> Hello Marcelo,
>
> well, something like that is possible. Set ENABLE_SAAS to 1, and see if it
> suits your needs.
>
> Note that I was working on adding multitenant capabilities to piler, however
> at some point I decided to stop. I won't remove what's already done, but I
> don't intend to improve it.
>
> If you had many domains with many customers, then piler may lack a few
> features, like separating customers' data, supporting more nodes, etc.
>
> Janos
> ____
> From: Marcelo Machado
> Sent: Wed Jul 05 12:56:49 GMT+02:00 2017
> To: Piler User
> 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>:
>>
>>  Hello,
>>
>>  a regular user can't see all emails, however an auditor user can.
>>
>>  Janos
>> 
>>
>>  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 piler server receiving messages from two different domains.
>>
>>  Is possible one regular user or auditor user see messages from all
>>  users only of a one
>>  domain?
>>
>>  Marcelo Gomes
>
>
>



Re: View all emails from a domain

2017-07-05 Thread Marcelo Machado


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>:
> Hello,
>
> a regular user can't see all emails, however an auditor user can.
>
> Janos
> ________
> 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 piler server receiving messages from two different domains.
>
> Is possible one regular user or auditor user see messages from all
> users only of a one
> domain?
>
> Marcelo Gomes
>