API not processing configuration file

Fernando Piancastelli's Avatar

Fernando Piancastelli

19 Oct, 2015 10:24 PM

Since my app doesn't use Ruby or Rails, I'm trying to upload my configuration file to API directly.
PUT configuration request to /api/my/app goes fine, status OK.
I'm trying getting index to run, but its info says:
        "status": "FINISHED",
        "log": "FATAL: config file '/mnt/local/flying-sphinx/4eaa11dd8a18c230c/sphinx.conf' does not exist or is not readable"
Dashboard doesn't help, since clicking Show Logs doesn't show anything.
My Heroku app is "ullu-php" and configuration API request is:

{"configuration":"source base
 type = mysql
 sql_host = us-cdbr-iron-east-03.cleardb.net
 sql_user = **
 sql_pass = **
 sql_db = **
 sql_query_pre = SET CHARACTER_SET_RESULTS=utf8
 sql_query_pre = SET NAMES utf8
 sql_query_pre = SET SESSION query_cache_type=0
 sql_query = select * from sphinx_index WHERE id >= $start AND id <= $end
 sql_query_range = SELECT MIN(id),MAX(id) FROM ullu_itens
 sql_range_step = 10000
 sql_attr_uint = id_proprietario
 sql_attr_uint = tipo
 sql_attr_timestamp = updated_at
 sql_attr_timestamp = created_at
 sql_field_string = link
 sql_ranged_throttle = 0
 sql_query_killlist = SELECT id FROM ullu_itens WHERE UNIX_TIMESTAMP(updated_at) >= @last_reindex UNION SELECT id FROM ullu_itens WHERE deleted_at IS NOT NULL AND UNIX_TIMESTAMP(deleted_at) >= @last_reindex
index idx
 source = base
 docinfo = extern
 dict = keywords
 mlock = 0
 min_stemming_len = 4
 min_word_len = 1
 html_strip = 0

  1. 1 Posted by Fernando Pianca... on 21 Oct, 2015 09:31 PM

    Fernando Piancastelli's Avatar

    I'm closing this since due to poor support and debugging we already switched to ElasticSearch.

  2. Support Staff 2 Posted by Pat Allan on 23 Oct, 2015 09:01 PM

    Pat Allan's Avatar

    Hi Fernando

    Firstly: I'm very sorry that I've not responded more quickly. Your decision to use a different service is completely fair and understandable. I hope that ElasticSearch works out well for you.

    I would debug this issue further, but since you removed Flying Sphinx from your app, I no longer have any of your data, and thus cannot see how the request wasn't structured quite correctly. I certainly would not expect you to keep the add-on just for my debugging, this is more a note for anyone else who comes across any issues implementing their own API interactions - and I'll strive to be much faster at responding.

    Kind regards,


  3. Pat Allan closed this discussion on 23 Oct, 2015 09:01 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac