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

[Wagner, Patrick]

Hello Martin,

indeed, you are correct - the address that doesn't work is exactly 42 
characters long. So looks like it's the same issue and you're not the 
only one affected.


Interesting that this issue never surfaced before?

- Patrick

On 31.07.2020 18:18, Martin Nadvornik wrote:


Hello Patrick,

of course check what Janos said first, but if it's just one single
e-mail account where mails are not shown in the webgui, it would be
interesting if the account has access in piler to an address that is
longer than 41 characters. I stumbled upon this for our piler instance
recently
(https://bitbucket.org/jsuto/piler/issues/1082/no-sphinx-results-with-long-email).
Let me know if you have the same issue.

Thanks,
Martin

Am 31.07.2020 um 17:34 schrieb s...@acts.hu:


On 2020-07-31 17:16, Wagner, Patrick wrote:

So that issue is fixed now, but has unearthed another - I can find and
open all mails just fine as auditor@local, and logging in with my
personal account works as well (I'm shown only my emails, as it should
be), but another email address / account I've tested doesn't show any
emails even though the usage report and my login as auditor definitely
contains emails for this email address? I've even used copy and paste
out of the usage report UI to change email address and username for
the piler account in question (basically a NOOP, as there was no typo
before either)

check the sphinx query logged when this other user hits the search
button.
Verify that his email addresses are present in the query. If that's good,
then download or export a single email he should see, and run pilertest
on the email to see what piler thinks about it. Check that the From/To/Cc
fields have his email address.

Janos

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

[Wagner, Patrick]

Hello Janos,


thanks for your prompt response, correct as always! The paths were still 
referring to /usr/local instead of /usr.


So that issue is fixed now, but has unearthed another - I can find and 
open all mails just fine as auditor@local, and logging in with my 
personal account works as well (I'm shown only my emails, as it should 
be), but another email address / account I've tested doesn't show any 
emails even though the usage report and my login as auditor definitely 
contains emails for this email address? I've even used copy and paste 
out of the usage report UI to change email address and username for the 
piler account in question (basically a NOOP, as there was no typo before 
either)


In the past I would only see "no search results" if the sphinx cronjobs 
didn't run properly, and in that case the auditor or other users 
wouldn't see any mails either, so this time it's another issue?


Thanks,

Patrick

On 31.07.2020 15:09, Janos SUTO wrote:

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, at 14:07, "Wagner, Patrick" > wrote:



Hello everyone,


just opened an older piler archive (version 1.35) and was surprised to
see all the emails listed in the web GUI upper pane / list, including
icons for attachments and correct messages sizes, but I cannot display
the actual email headers or contents.

The lower pane / detail pane per email is pretty much empty:


Subject:
From:
To:
Date:



Attachment names are shown, however every attachment I try to open is 1
bytes on download, so obviously unusable.

Thankfully it seems to be a web GUI interface only, as a test with
pilerexport yielded the email contents, including attachments.

What's wrong? Is the Piler version too old for modern browsers? What do
I need to fix?

Thanks,

Patrick


# piler -V
piler 1.3.5, build 997, Janos SUTO 

Build Date: Sun Apr 21 16:50:30 UTC 2019
ldd version: ldd (Ubuntu GLIBC 2.27-3ubuntu1) 2.27
gcc version: gcc version 7.3.0 (Ubuntu 7.3.0-27ubuntu1~18.04)
OS: Linux 188ae4f9894f 4.15.0-47-generic #50-Ubuntu SMP Wed Mar 13
10:44:52 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
Configure command: ./configure --prefix=/usr --sysconfdir=/etc
--localstatedir=/var --with-database=mariadb
MySQL client library version: 10.2.9
Extractors: /usr/bin/pdftotext /usr/bin/catdoc /usr/bin/catppt
/usr/bin/xls2csv /usr/bin/unrtf /usr/bin/tnef

Ubuntu 18.04.4 LTS

PHP 7.2.24-0ubuntu0.18.04.6 (as supplied with the distro)

MariaDB 10.1.44 (as supplied with the distro)


*
*

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

[Martin Nadvornik]

Hello Patrick,

of course check what Janos said first, but if it's just one single
e-mail account where mails are not shown in the webgui, it would be
interesting if the account has access in piler to an address that is
longer than 41 characters. I stumbled upon this for our piler instance
recently
(https://bitbucket.org/jsuto/piler/issues/1082/no-sphinx-results-with-long-email).
Let me know if you have the same issue.

Thanks,
Martin

Am 31.07.2020 um 17:34 schrieb s...@acts.hu:
>
>
> On 2020-07-31 17:16, Wagner, Patrick wrote:
>>
>> So that issue is fixed now, but has unearthed another - I can find and
>> open all mails just fine as auditor@local, and logging in with my
>> personal account works as well (I'm shown only my emails, as it should
>> be), but another email address / account I've tested doesn't show any
>> emails even though the usage report and my login as auditor definitely
>> contains emails for this email address? I've even used copy and paste
>> out of the usage report UI to change email address and username for
>> the piler account in question (basically a NOOP, as there was no typo
>> before either)
>
> check the sphinx query logged when this other user hits the search
> button.
> Verify that his email addresses are present in the query. If that's good,
> then download or export a single email he should see, and run pilertest
> on the email to see what piler thinks about it. Check that the From/To/Cc
> fields have his email address.
>
> Janos
>

-- 
Martin Nadvornik
IT Mitarbeiter

Diakonie Flüchtlingsdienst gem. GmbH
Steinergasse 3/12
1170 Wien, Austria
Tel: +43 (0) 1/ 402 67 54 - 1337
Fax: +43 (0) 1/ 402 67 54 - 16
Mobil: 0664/88350692
http://www.diakonie.at/fluechtlingsdienst

Verantwortung kann man nicht abschieben!

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

[Wagner, Patrick]

Hello everyone,


just opened an older piler archive (version 1.35) and was surprised to 
see all the emails listed in the web GUI upper pane / list, including 
icons for attachments and correct messages sizes, but I cannot display 
the actual email headers or contents.


The lower pane / detail pane per email is pretty much empty:


Subject:
From:
To:
Date:



Attachment names are shown, however every attachment I try to open is 1 
bytes on download, so obviously unusable.


Thankfully it seems to be a web GUI interface only, as a test with 
pilerexport yielded the email contents, including attachments.


What's wrong? Is the Piler version too old for modern browsers? What do 
I need to fix?


Thanks,

Patrick


# piler -V
piler 1.3.5, build 997, Janos SUTO 

Build Date: Sun Apr 21 16:50:30 UTC 2019
ldd version: ldd (Ubuntu GLIBC 2.27-3ubuntu1) 2.27
gcc version: gcc version 7.3.0 (Ubuntu 7.3.0-27ubuntu1~18.04)
OS: Linux 188ae4f9894f 4.15.0-47-generic #50-Ubuntu SMP Wed Mar 13 
10:44:52 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
Configure command: ./configure --prefix=/usr --sysconfdir=/etc 
--localstatedir=/var --with-database=mariadb

MySQL client library version: 10.2.9
Extractors: /usr/bin/pdftotext /usr/bin/catdoc /usr/bin/catppt 
/usr/bin/xls2csv /usr/bin/unrtf /usr/bin/tnef


Ubuntu 18.04.4 LTS

PHP 7.2.24-0ubuntu0.18.04.6 (as supplied with the distro)

MariaDB 10.1.44 (as supplied with the distro)


*
*

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

[sj]

On 2020-07-31 17:16, Wagner, Patrick wrote:


So that issue is fixed now, but has unearthed another - I can find and
open all mails just fine as auditor@local, and logging in with my
personal account works as well (I'm shown only my emails, as it should
be), but another email address / account I've tested doesn't show any
emails even though the usage report and my login as auditor definitely
contains emails for this email address? I've even used copy and paste
out of the usage report UI to change email address and username for
the piler account in question (basically a NOOP, as there was no typo
before either)


check the sphinx query logged when this other user hits the search 
button.
Verify that his email addresses are present in the query. If that's 
good,

then download or export a single email he should see, and run pilertest
on the email to see what piler thinks about it. Check that the 
From/To/Cc

fields have his email address.

Janos

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

[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 surprised to
>see all the emails listed in the web GUI upper pane / list, including
>icons for attachments and correct messages sizes, but I cannot display
>the actual email headers or contents.
>
>The lower pane / detail pane per email is pretty much empty:
>
>
>Subject:
>From:
>To:
>Date:
>
>
>
>Attachment names are shown, however every attachment I try to open is 1
>
>bytes on download, so obviously unusable.
>
>Thankfully it seems to be a web GUI interface only, as a test with
>pilerexport yielded the email contents, including attachments.
>
>What's wrong? Is the Piler version too old for modern browsers? What do
>
>I need to fix?
>
>Thanks,
>
>Patrick
>
>
># piler -V
>piler 1.3.5, build 997, Janos SUTO 
>
>Build Date: Sun Apr 21 16:50:30 UTC 2019
>ldd version: ldd (Ubuntu GLIBC 2.27-3ubuntu1) 2.27
>gcc version: gcc version 7.3.0 (Ubuntu 7.3.0-27ubuntu1~18.04)
>OS: Linux 188ae4f9894f 4.15.0-47-generic #50-Ubuntu SMP Wed Mar 13
>10:44:52 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
>Configure command: ./configure --prefix=/usr --sysconfdir=/etc
>--localstatedir=/var --with-database=mariadb
>MySQL client library version: 10.2.9
>Extractors: /usr/bin/pdftotext /usr/bin/catdoc /usr/bin/catppt
>/usr/bin/xls2csv /usr/bin/unrtf /usr/bin/tnef
>
>Ubuntu 18.04.4 LTS
>
>PHP 7.2.24-0ubuntu0.18.04.6 (as supplied with the distro)
>
>MariaDB 10.1.44 (as supplied with the distro)
>
>
>*
>*