Re: Admin password
It worked. Thanks Em ter., 13 de jun. de 2023 às 14:44, Janos SUTO escreveu: > > > > Then either restore it from backup, or simply recreate the table, > and add the admin and auditor users. See util/db-mysql.sql for its > schema. > > Janos > > On 2023-06-13 19:32, Marcelo Machado wrote: > > Thanks for the answer. > > when I use the command that is in the FAQ this error appears: ERROR > > 1146 (42S02): Table 'piler.user' doesn't exist > > > > Em ter., 13 de jun. de 2023 às 14:17, Janos SUTO escreveu: > >> > >> > >> > >> Hello, > >> > >> yes, please read the FAQ. > >> > >> Janos > >> > >> On 2023-06-13 19:02, Marcelo Machado wrote: > >> > Hello everyone. > >> > > >> > Is it possible to reset the admin@local user password to the original > >> > one? > >> > > >> > Thanks in advance > >> > > >> > Marcelo Gomes > >> >
Re: Admin password
Thanks for the answer. when I use the command that is in the FAQ this error appears: ERROR 1146 (42S02): Table 'piler.user' doesn't exist Em ter., 13 de jun. de 2023 às 14:17, Janos SUTO escreveu: > > > > Hello, > > yes, please read the FAQ. > > Janos > > On 2023-06-13 19:02, Marcelo Machado wrote: > > Hello everyone. > > > > Is it possible to reset the admin@local user password to the original > > one? > > > > Thanks in advance > > > > Marcelo Gomes >
Admin password
Hello everyone. Is it possible to reset the admin@local user password to the original one? Thanks in advance Marcelo Gomes
Messages wrong date
Hello everyone. How do I fix the date of messages that appear with the date of 2036. Thanks in advance. Marcelo Gomes
Re: Piler auditor login error
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 > >
Re: Deleting emails
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
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
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
Hello everyone. Is Mail Piler only commercial now? Does the Open Source Edition still exist? Marcelo Gomes
Deleting emails
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
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
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
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
- 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
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
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
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
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
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
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
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
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
I need to archive only messages from my domain to my domain. This is possible? Marcelo
Re: Partition Projected to be Full in
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
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
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 >
