Hello,
try setting the following in config-site.php:
$config['SPHINX_MAIN_INDEX'] = 'main1,dailydelta1,delta1';
It appears that you have delta1, but it's not present in the sphinx
query.
Let me know if it works for you. Btw. if you are evaluating piler, I
recommend
you to grab the master branch since it contains lots of fixes, and
improvements.
And it's pretty close to the final 1.1.0.
Janos
On 2014-08-04 11:26, Carsten Probst wrote:
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
