![Shocked :shock:](images/smilies/icon_eek.gif)
I've uploaded to google docs, and you can download from the urls below...
Much thanks to Barry Hunter over at Sphinx Forum - he figured it out.
This resolves the issue reported here:
viewtopic.php?f=1&t=2053
and here:
viewtopic.php?t=1109&p=4961
I tested both with mariadb and postgresql with sphinx 2.0.8 (Fedora)
Since the config files below are delta, I would recommend you go ahead and change config.php.dist
to set sphinx index to delta as default.
define('SPHINX_INDEX', 'ttrss, delta');
// Index name in Sphinx configuration. You can specify multiple indexes
// as a comma-separated string.
I changed config.php.dist to include the delta index by default since the attached files are delta.
One for mariadb/mysql and the other for postgresql.
Steps would be as follows:
1. Install Sphinx, i.e. yum install sphinx
2. Select the config file for your database (mariadb/mysql or postgresql)
3. Make the necessary changes (instructions on what to change in the comments of each config)
4. Change to the Sphinx conf directory
5. Rename sphinx.conf to sphinx.conf.dist
6. Rename the ttrss specific config you just modified to sphinx.conf
7. Run /bin/indexer --all to initialize the database
8. Start the sphinx process, i.e. systemctl start searchd.service
9. Enable the service to ensure startup at system initialization, i.e. systemctl enable searchd.service
10. Setup cron to run indexer:
@daily /bin/indexer --rotate ttrss >/dev/null 2>&0 # Same as 0 0 * * *
*/20 * * * * /bin/indexer --rotate delta >/dev/null 2>&0 # Every 20 minutes
11. And, last but not least, remember to enable sphinx in the ttrss config.php:
define('SPHINX_ENABLED', true);
Here is the configuration for postgresql:
https://docs.google.com/file/d/0B96ctNl ... sp=sharing
Here is the configuration for mysql/mariadb:
https://docs.google.com/file/d/0B96ctNl ... sp=sharing