Hi mailpiler list! After installing mailpiler 0.1.24 on CentOS6 with LDAP auth via Zimbra and adding some testmessages, I’m having now problems to find these testmessages via the webgui. Sphinx was installed via the sphinx-2.0.9-1.rhel6.x86_64.rpm file.
I’m trying to find messages containing my email address [email protected] A regular sphinx search via CLI returns matches in the delta1 index: # search "cprobst\@mediaventures\.de” index 'delta1': query 'cprobst\@mediaventures\.de ': returned 1 matches of 1 total in 0.000 sec displaying matches: 1. document=2, weight=7361, arrived=1407138389, sent=1407138389, size=2559, direction=0, folder=0, attachments=0 words: 1. 'cprobst': 1 documents, 2 hits 2. 'mediaventures': 115 documents, 459 hits 3. 'de': 115 documents, 463 hits All other indexes doesn’t return any matching records. The same search via the webgui logged to the maillog: Aug 4 10:46:20 vmdcmv-marchive01 piler-webui[27331]: sphinx query: 'SELECT id FROM dailydelta1,main1 WHERE MATCH('@from cprobstXmediaventuresXde') ORDER BY `sent` DESC LIMIT 0,1000 OPTION max_matches=100 This query via the sphinxQL: # mysql -P9306 --protocol=tcp --prompt='sphinxQL> ‘ sphinxQL> SELECT id FROM dailydelta1,main1 WHERE MATCH('@from cprobstXmediaventuresXde') ORDER BY `sent` DESC LIMIT 0,1000 OPTION max_matches=100; Empty set (0.00 sec) but: sphinxQL> SELECT id FROM delta1 WHERE MATCH('@from cprobstXmediaventuresXde') ORDER BY `sent` DESC LIMIT 0,1000 OPTION max_matches=100; +------+ | id | +------+ | 2 | +------+ 1 row in set (0.00 sec) So the objects are in delta1 but not in dailydelta1 or main1... Any help is really appreciated! Regards, Carsten
