Search button shows no result

[Julien DELVECCHIO]

Hi,

I've recently installed Piler on debian 7.4 and I can login using the WebUI with the users stored in my Zimbra LDAP.

I've set the always_bcc = mypilerIPaddress in /opt/zimbra/postfix/conf/main.cf file, by doing this it should forward every email sent / received to piler I guess ?

When I try to send mails and check if they are in my WebUI, the search button says "Empty search results". I've read that it could take up to 30mins for archived mail to be seen on the webUI and i've waited that amount of time, still cannot see it.

Any ideas?

Thanks in advance

Here's the /var/log/mail.log : Apr 18 12:15:33 piler piler-webui[3261]: sphinx query: 'SELECT id FROM dailydelta1,main1 WHERE MATCH('(@from frodonXtestzimbraXfr | @to frodonXtestzimbraXfr)') ORDER BY sent DESC LIMIT 0,1000 OPTION max_matches=1000' in 0.00 s, 0 hits

[Janos SUTO]

The always_bcc parameter expects an email address, so always_bcc = 1.2.3.4 is definitely not good. Instead set the following:

always_bcc = [e-mail]

Then reloading zimbra's postfix send a test mail, and verify in the zimbra postfix logs that the test email was actually mirrored to piler.

[Julien DELVECCHIO]

Thanks, i've changed it to the mail of my domain.

This is the log that appears when I send an test email : (gandalf is the name of my zimbra machine host, don't mind that haha) Not sure if it mirrors it correctly since I can see a status = deffered. I'll wait a bit to see if it comes to my piler webUI.

Apr 18 12:34:14 gandalf postfix/smtpd[31287]: connect from gandalf.testzimbra.fr
[192.168.1.75]
Apr 18 12:34:14 gandalf postfix/smtpd[31287]: 08F05C21DF: client=gandalf.testzim
bra.fr[192.168.1.75]
Apr 18 12:34:14 gandalf postfix/cleanup[31288]: 08F05C21DF: message-id=<10146384
[e-mail]>
Apr 18 12:34:14 gandalf postfix/qmgr[27879]: 08F05C21DF: from=<frodon@testzimbra
.fr>, size=639, nrcpt=2 (queue active)
Apr 18 12:34:14 gandalf postfix/smtpd[31287]: disconnect from gandalf.testzimbra
.fr[192.168.1.75]
Apr 18 12:34:14 gandalf amavis[27651]: (27651-01) ESMTP::10024 /opt/zimbra/data/
amavisd/tmp/amavis-20140418T123414-27651: <[e-mail]> -> <archive@pil
er.testpiler.fr>,<[e-mail]> SIZE=639 Received: from gandalf.testzimb
ra.fr ([127.0.0.1]) by localhost (gandalf.testzimbra.fr [127.0.0.1]) (amavisd-ne
w, port 10024) with ESMTP; Fri, 18 Apr 2014 12:34:14 +0200 (CEST)
Apr 18 12:34:14 gandalf amavis[27651]: (27651-01) Checking: qjVhHzzpZTcb MYNETS 
[192.168.1.75] <[e-mail]> -> <[e-mail]>,<frodon@te
stzimbra.fr>
Apr 18 12:34:14 gandalf postfix/smtpd[29540]: connect from localhost[127.0.0.1]
Apr 18 12:34:14 gandalf postfix/smtpd[29540]: 42A80C2222: client=localhost[127.0
.0.1]
Apr 18 12:34:14 gandalf postfix/cleanup[31288]: 42A80C2222: message-id=<10146384
[e-mail]>
Apr 18 12:34:14 gandalf postfix/qmgr[27879]: 42A80C2222: from=<frodon@testzimbra
.fr>, size=1071, nrcpt=1 (queue active)
Apr 18 12:34:14 gandalf amavis[27651]: (27651-01) FWD via SMTP: <frodon@testzimb
ra.fr> -> <[e-mail]>,BODY=7BIT 250 2.0.0 from MTA([127.0.0.1]:
10025): 250 2.0.0 Ok: queued as 42A80C2222
Apr 18 12:34:14 gandalf postfix/smtpd[29540]: 44D2CC2224: client=localhost[127.0
.0.1]
Apr 18 12:34:14 gandalf postfix/cleanup[31288]: 44D2CC2224: message-id=<10146384
[e-mail]>
Apr 18 12:34:14 gandalf postfix/qmgr[27879]: 44D2CC2224: from=<frodon@testzimbra
.fr>, size=1262, nrcpt=1 (queue active)
Apr 18 12:34:14 gandalf amavis[27651]: (27651-01) FWD via SMTP: <frodon@testzimb
ra.fr> -> <[e-mail]>,BODY=7BIT 250 2.0.0 from MTA([127.0.0.1]:10025)
: 250 2.0.0 Ok: queued as 44D2CC2224
Apr 18 12:34:14 gandalf amavis[27651]: (27651-01) Passed CLEAN, MYNETS LOCAL [19
2.168.1.75] [192.168.1.75] <[e-mail]> -> <[e-mail]
>,<[e-mail]>, Message-ID: <1014638492.3.1397817253945.JavaMail.root@
testzimbra.fr>, mail_id: qjVhHzzpZTcb, Hits: -2.91, size: 639, queued_as: 42A80C
2222/44D2CC2224, 230 ms
Apr 18 12:34:14 gandalf postfix/smtp[31289]: 08F05C21DF: to=<[e-mail]
iler.fr>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.28, delays=0.02/0.03/0.01/0.
23, dsn=2.0.0, status=sent (250 2.0.0 from MTA([127.0.0.1]:10025): 250 2.0.0 Ok:
 queued as 42A80C2222)
Apr 18 12:34:14 gandalf postfix/smtp[31289]: 08F05C21DF: to=<frodon@testzimbra.f
r>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.28, delays=0.02/0.03/0.01/0.23, ds
n=2.0.0, status=sent (250 2.0.0 from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queue
d as 42A80C2222)
Apr 18 12:34:14 gandalf postfix/qmgr[27879]: 08F05C21DF: removed
Apr 18 12:34:14 gandalf postfix/smtp[31292]: 42A80C2222: to=<[e-mail]
iler.fr>, relay=none, delay=0.02, delays=0/0.01/0.01/0, dsn=4.4.3, status=deferred (Host or domain name not found. Name service error for name=piler.testpiler.f
r type=MX: Host not found, try again)
Apr 18 12:34:14 gandalf amavis[27651]: (27651-01) extra modules loaded: /opt/zim
bra/zimbramon/lib/x86_64-linux-thread-multi/auto/Net/SSLeay/autosplit.ix, /opt/z
imbra/zimbramon/lib/x86_64-linux-thread-multi/auto/Net/SSLeay/randomize.al, IO/S
ocket/SSL.pm, Net/LDAP/Extension.pm, Net/SSLeay.pm
Apr 18 12:34:14 gandalf postfix/lmtp[31293]: 44D2CC2224: to=<frodon@testzimbra.f
r>, relay=gandalf.testzimbra.fr[192.168.1.75]:7025, delay=0.11, delays=0.01/0.01
/0/0.08, dsn=2.1.5, status=sent (250 2.1.5 Delivery OK)
Apr 18 12:34:14 gandalf postfix/qmgr[27879]: 44D2CC2224: removed
Apr 18 12:35:34 gandalf postfix/qmgr[27879]: CB7C8C2207: from=<frodon@testzimbra
.fr>, size=1077, nrcpt=1 (queue active)
Apr 18 12:35:34 gandalf postfix/smtp[31292]: CB7C8C2207: to=<[e-mail]
iler.fr>, relay=none, delay=416, delays=416/0.01/0/0, dsn=4.4.3, status=deferred
 (Host or domain name not found. Name service error for name=piler.testpiler.fr 
type=MX: Host not found, try again)
Apr 18 12:36:05 gandalf zmmailboxdmgr[31711]: status requested
Apr 18 12:36:05 gandalf zmmailboxdmgr[31711]: status OK
Apr 18 12:36:17 gandalf postfix/smtpd[30293]: timeout after END-OF-MESSAGE from 
localhost[127.0.0.1]
Apr 18 12:36:17 gandalf postfix/smtpd[30293]: disconnect from localhost[127.0.0.
1]

Looks like my Zimbra DNS setup isn't correct, it cannot resolv the IP address of the name [e-mail], am I right ?

[Janos SUTO]

You are right, you need a valid, resolvable DNS name for the email archive.

[Julien DELVECCHIO]

I changed the name of my piler domain for it to match the same domain as my zimbra server and it seems to work, however, I still can't see mails in my WebUI interface when I hit the search button.

Sendmail log :

Apr 18 14:56:16 gandalf postfix/smtp[11896]: ED863C2227: to=<archive@pil
er.testzimbra.fr>, relay=piler.testzimbra.fr[192.168.1.69]:25, delay=0.0
9, delays=0.06/0.01/0/0.02, dsn=2.0.0, status=sent (250 Ok 4000000053512
0e912672c8c004a003f84af <[e-mail]>)

Everything seems OK, the message has been sent.

Something i'm missing maybe?

I've changed the domain name of piler in the file config-sites.php, that's all, is there somewhere else I need to change this?

[Julien DELVECCHIO]

Problem solved, the emails are archived and I can see them, just had to wait a bit for the WebUI to get updated, thanks a lot for your help!

[Janos SUTO]

OK, I'm glad that you have made it :-)