webui won't load emails or attachments

[Former user]

Hi Janos,

After spending a day with installing Piler, (linux newbie+2x vps reinstall) it's almost work like a dream. But now, i can't open any archived email for some reason.

The only thing i can see, is the <no subject> text in the viewer.

piler 0.1.25-master-branch, build 856, Janos SUTO <[e-mail]>

Build Date: Sat Dec 21 11:55:02 CST 2013
ldd version: ldd (GNU libc) 2.12
gcc version: gcc version 4.4.7 20120313 (Red Hat 4.4.7-4) (GCC) 
Configure command: ./configure --localstatedir=/var --with-database=mysql --enable-starttls

Could you please help me to solve this issue?

Thanks, Daniel Meszaros

[Janos SUTO]

Hello Daniel, I think there must be something wrong with pilerget. Get a piler id from the maillog (it's 400000.....3783784984 or something).

Then execute the following command (be sure to use a real piler id):

pilerget 400000.....3783784984

and show me what you got.

[Dániel Mészáros]

Hmm.. interesting.. no output

[root@host ~]# pilerget 4000000052b66adb27a062e4003948bb80bf
[root@host ~]# 

[Janos SUTO]

OK, now make sure that pilerget is setuid to piler:piler, and piler.conf is owned by root, and group piler, and has 640 permissions. Also check the maillog file for any sign of error. Finally, try locating the encrypted message file in /var/piler/store/00/52b/80/bf/.

[Dániel Mészáros]

#!

-rwxr-xr-x. 1 root root 78003 Dec 21 11:55 /usr/local/sbin/piler
-rwxr-xr-x. 1 root root 14507 Dec 21 11:55 /usr/local/sbin/pilerconf
-rwxr-xr-x. 1 root root 75054 Dec 21 11:55 /usr/local/sbin/pilergetd

#!

-rwsr-sr-x. 1 piler piler 16578 Dec 21 11:55 /usr/local/bin/pileraget
-rwsr-sr-x. 1 piler piler 77249 Dec 21 11:55 /usr/local/bin/pilerexport
-rwsr-sr-x. 1 piler piler 56877 Dec 21 11:55 /usr/local/bin/pilerget
-rwsr-sr-x. 1 piler piler 92389 Dec 21 11:55 /usr/local/bin/pilerimport
-rwsr-sr-x. 1 piler piler 77359 Dec 21 11:55 /usr/local/bin/pilerpurge
-rwsr-sr-x. 1 piler piler 66265 Dec 21 11:55 /usr/local/bin/pilertest

#!
-rw-r-----. 1 root piler 4533 Dec 21 16:57 /usr/local/etc/piler.conf

So that looks good, so far. But, i haven't found the message in the folder mentioned above. There's even no folder with .../bf/ but probably it's my fault, as i've picked that pilerid from the several encrypted messages laying in the /tmp dir.

what is the path of the mentioned maillog?

[Janos SUTO]

I assume you have centos / redhat, so it's /var/log/maillog. On debian and derivatives it's /var/log/mail.log

Also please check that you have some messages under /var/piler/store/00/52b/

[Dániel Mészáros]

Hello!

Sorry for the delay.. I was sure that i have looked into the /var/log.... but obviously i haven't. So, yes, there are some weird messages in the log, and yes, there are a lot of messages in the store. Store and messages rights: 700, owner: piler/piler. Any idea? Daniel

#!
Dec 22 22:07:11 host pilerget[13940]: unknown key: "encrypt_messages "
Dec 22 22:07:11 host pilerget[13940]: /var/piler/store/00/15/38/49/4000000052b67017162d8b2c00324c153849.m: cannot open()

#!

[root@host 00]# du -sh *
985M    52b

[Dániel Mészáros]

ok, i've removed the bad line from the config but that is not the only problem. In the /var/piler/sphinx dir, the main1.sph and some other files were owned by root. I've changed them to piler. But as you see the pilerget gets the wrong path for the messages. the correct path should be /var/piler/store/00/52b/............ But the thing is, that the corrected path also unavailable... while i've experienced this issue for the first time, i did a complete clean on the database as i could find it in the faq.

Dan

[Janos SUTO]

it's indeed strange. I recommend to continue on skype (janos.suto), probably we can resolve this issue faster.

[Dániel Mészáros]

Hi. I hope you had a lovely christmas. I've left it as it was for the christmas time, but now i'm on it again. It's still faulty. I'm thinking on reinstalling the vm now, but it would be more helpful to find out what was the problem, wouldn't it? I've added you to my skype,btw.

Thanks, Dan

[Dániel Mészáros]

For the record. I did some mysql search, found an id, and retrieved the message successfully with pilerget on a terminal. webui still doesn't work. i mean, i couldn't even find a trace of the message i got with the command line. (last ID in the V_MESSAGES table).

ps: searchd is running.

[Janos SUTO]

hmm, that's a bit better. Searchd is running, good. Has the indexer run at all? Please check /var/piler/sphinx/main1.* files if they grow over time.

[Dániel Mészáros]

I'm not sure it will grow. It's just a test db at the mo. No new mails, 1-2 searches a day. But at least it's not empty.

#!

-rw-r--r--. 1 piler piler      582 Dec 28 13:35 dailydelta1.sph
-rw-r--r--. 1 piler piler      582 Dec 28 13:35 delta1.sph
-rw-r--r--. 1 piler piler   448576 Dec 28 02:30 main1.spa
-rw-r--r--. 1 piler piler 33583465 Dec 28 02:30 main1.spd
-rw-r--r--. 1 piler piler      582 Dec 28 02:30 main1.sph
-rw-r--r--. 1 piler piler  8932542 Dec 28 02:30 main1.spi
-rw-r--r--. 1 piler piler 38373718 Dec 28 02:30 main1.spp
-rwxr-----. 1 piler piler      582 Dec 21 22:03 main2.sph
-rwxr-----. 1 piler piler      582 Dec 21 22:03 main3.sph
-rwxr-----. 1 piler piler      582 Dec 21 22:03 main4.sph
-rw-r--r--. 1 piler piler      289 Dec 28 13:30 note1.sph
-rw-r--r--. 1 piler piler      288 Dec 28 13:30 tag1.sph

[Janos SUTO]

Looks ok. Can we chat now?

[Janos SUTO]

Managed to solve it by disabling selinux.