Not able to see messages in piler gui. < no subject> in view pane

[Former user]

hi I am using piler-1.1.1 version and sphinx-2.2.11.1 version on centos 7 in oracle virtual box.

I logged in as auditor in piler and I can see the subject,addess etc but when I select any message I am not able to see it. i have done pilerimport -i <imap server> -u username -p password - P 993 and it imported messages from inbox like this List of IMAP folders: => 'INBOX' processing folder: INBOX... found 8 messages duplicate: 21253-imap-1.txt (duplicate id: 1) duplicate: 21253-imap-2.txt (duplicate id: 2) duplicate: 21253-imap-3.txt (duplicate id: 3) duplicate: 21253-imap-4.txt (duplicate id: 4) duplicate: 21253-imap-5.txt (duplicate id: 5) duplicate: 21253-imap-6.txt (duplicate id: 6) duplicate: 21253-imap-7.txt (duplicate id: 7) processed: 8 [100%] plz help me I am stuck here for 3 days.

[Former user]

output from my database select id, sent, arrived, deleted from metadata where piler_id='4000000058789a3e3a426bcc008bad0bcc12'; +----+------------+------------+---------+ | id | sent | arrived | deleted | +----+------------+------------+---------+ | 6 | 1484298513 | 1484298804 | 0 | +----+------------+------------+---------+ output of pilerget: [root@localhost /]# pilerget 4000000058789a3e3a426bcc008bad0bcc12 Return-Path: [e-mail] Received: from mail.subite.eu ([unix socket]) by mail.subite.eu (Cyrus v2.4.16) with LMTPA; Fri, 13 Jan 2017 10:08:35 +0100 X-Sieve: CMU Sieve 2.4 X-Virus-Scanned: amavisd-new at subite.eu Received: from [10.30.23.215] (c01-gw1.ogone.com [77.67.63.226]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mail.subite.eu (Postfix) with ESMTPSA id 581621904CCB for [e-mail]; Fri, 13 Jan 2017 10:08:34 +0100 (CET) From: abc [e-mail] Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Mac OS X Mail 10.2 (3259)) Subject: View Message Test Message-Id: [e-mail] Date: Fri, 13 Jan 2017 10:08:33 +0100 To: [e-mail] X-Mailer: Apple Mail (2.3259)

Hello test message !

[Former user]

I download the message from piler gui and it is empty and i have this in /var/piler/store /var/piler/store/00/587/cc/12/4000000058789a3e3a426bcc008bad0bcc12.m

[Janos SUTO]

Try to disable selinux, and check it again.

[Former user]

if i will run pilertest from /var/piler [root@localhost piler]# pilertest 4000000058789a3e3a426bcc008bad0bcc12.m 4000000058789a3e3a426bcc008bad0bcc12.m is not found

[Janos SUTO]

Do what I asked, please.

[Former user]

MySQL [(none)]> select * from main1,delta1,dailydelta1; +------+------------+-------+-------------+ | id | sent | size | attachments | +------+------------+-------+-------------+ | 1 | 1484138520 | 906 | 0 | | 2 | 1484143840 | 31241 | 4 | | 3 | 1484143840 | 29371 | 4 | | 4 | 1484144453 | 884 | 0 | | 5 | 1484215129 | 919 | 0 | | 6 | 1484298513 | 908 | 0 | | 7 | 1484311879 | 2839 | 0 | | 8 | 1484325236 | 2811 | 0 | +------+------------+-------+-------------+

[Janos SUTO]

Are you in write-only mode?

[Former user]

I did /etc/selinux/config selinux is disabled restart piler, searchd,httpd

[Former user]

I checked /var/log/maillog localhost piler-webui[4565]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@(subject,body) test') ORDER BY sent DESC LIMIT 0,1000 OPTION max_matches=1000' in 0.00 s, 4 hits, 4 total found

So I run su - piler mysql -h 127.0.0.1 -P9306

<mysql>SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@(subject,body) test') ORDER BY sent DESC; +------+ | id | +------+ | 8 | | 6 | | 5 | | 1 | +------+

[Former user]

I have this error in /var/log/maillog Jan 14 18:47:14 localhost pilerget[4585]: /var/piler/store/00/587/71/da/400000005879017e2056c15400c9601671da.m: cannot open()

[Janos SUTO]

Show me the output of

select id, deleted from metadata where piler_id='400000005879017e2056c15400c9601671da';

[Janos SUTO]

Also can you see any email in the preview pane?

[Former user]

MariaDB [piler]> select id, deleted from metadata where piler_id='400000005879017e2056c15400c9601671da'; +----+---------+ | id | deleted | +----+---------+ | 8 | 0 |

[Former user]

I can see date,subject,to ,from,size etc. but when I clicked the subject it says <no subject> and close to view header Message Verification Failed.

[Former user]

when I run import command I have this output

List of IMAP folders: => 'INBOX' processing folder: INBOX... found 9 messages duplicate: 5547-imap-1.txt (duplicate id: 1) duplicate: 5547-imap-2.txt (duplicate id: 2) duplicate: 5547-imap-3.txt (duplicate id: 3) duplicate: 5547-imap-4.txt (duplicate id: 4) duplicate: 5547-imap-5.txt (duplicate id: 5) duplicate: 5547-imap-6.txt (duplicate id: 6) duplicate: 5547-imap-7.txt (duplicate id: 7) duplicate: 5547-imap-8.txt (duplicate id: 8) processed: 9 [100%]

[Janos SUTO]

Is pilerget setuid to piler user? Are the permissions are correct on /var/piler/store and under? Piler user must be able to read them. Also can you find 400000005879017e2056c15400c9601671da.m? Show me "ls -la /var/piler/store/00/587/71/da/400000005879017e2056c15400c9601671da.m" output.

[Former user]

how can I check pilerget setuid to piler user?

[Former user]

ls -lhrt /var/piler/store/00 total 0 drwxr-xr-x. 11 piler piler 96 Jan 14 19:25 587

[Former user]

output of ls -la /var/piler/store/00/587/71/da/400000005879017e2056c15400c9601671da.m

-rwxr-xr-x. 1 piler piler 1552 Jan 13 17:33 /var/piler/store/00/587/71/da/400000005879017e2056c15400c9601671da.m

[Former user]

cd /usr/local/bin ls -lhrt

-rwsr-sr-x. 1 piler piler 55K Jan 8 13:28 pilerget -rwsr-sr-x. 1 piler piler 19K Jan 8 13:28 pileraget -rwsr-sr-x. 1 piler piler 96K Jan 8 13:28 pilerimport -rwsr-sr-x. 1 piler piler 74K Jan 8 13:28 pilerexport -rwsr-sr-x. 1 piler piler 68K Jan 8 13:28 pilerpurge -rwsr-sr-x. 1 piler piler 68K Jan 8 13:28 reindex -rwsr-sr-x. 1 piler piler 61K Jan 8 13:28 pilertest

[Janos SUTO]

I'm out of options without checking your host. If that's ok, then find me on skype (janos.suto) to discuss the details.

[Former user]

ok

[Former user]

I have sent u contact request

[Janos SUTO]

I've sent you a hello on skype

[Former user]

but u r offline now

[Janos SUTO]

I'm not. I can see you offline.

[Former user]

I am online

[Janos SUTO]

selinux was enforcing despite you have reported it off. Setting it to permissive fixed the "bug". There was no bug at all.

[Former user]

Thanks Problem solved.