Hi,
I installed Flying Sphinx recently and am attempting to run heroku run rake fs:index after running heroku run bundle exec flying-sphinx configure. I am getting the following error:
Executing Action: configure
Action Finished: configure
Executing Action: index
Sphinx 2.1.8-id64-release (rel21-r4675)
Copyright (c) 2001-2014, Andrew Aksyonoff
Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/mnt/local/flying-sphinx/3edb4dcfb50055547/sphinx.conf'...
indexing index 'custom_field_value_core'...
ERROR: index 'custom_field_value_core': sql_connect: SSL connection error: ASN: bad other signature confirmation (DSN=mysql://b80a016d8466a9:***@us-cdbr-iron-east-02.cleardb.net:3306/heroku_16993e4627f8fcf).
total 0 docs, 0 bytes
total 0.022 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'custom_field_value_delta'...
ERROR: index 'custom_field_value_delta': sql_connect: SSL connection error: ASN: bad other signature confirmation (DSN=mysql://b80a016d8466a9:***@us-cdbr-iron-east-02.cleardb.net:3306/heroku_16993e4627f8fcf).
total 0 docs, 0 bytes
total 0.007 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'listing_core'...
ERROR: index 'listing_core': sql_connect: SSL connection error: ASN: bad other signature confirmation (DSN=mysql://b80a016d8466a9:***@us-cdbr-iron-east-02.cleardb.net:3306/heroku_16993e4627f8fcf).
total 0 docs, 0 bytes
total 0.007 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'listing_delta'...
ERROR: index 'listing_delta': sql_connect: SSL connection error: ASN: bad other signature confirmation (DSN=mysql://b80a016d8466a9:***@us-cdbr-iron-east-02.cleardb.net:3306/heroku_16993e4627f8fcf).
total 0 docs, 0 bytes
total 0.007 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'custom_field_value'...
skipping non-plain index 'listing'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
Action Finished: index
Do you know how I can fix this? Thank you for the help.
#1 Posted by Pat Allan Support staff on 09 Jun, 2015 04:08 AM
Hi there
It looks like your database requires SSL configuration - you'll need to pass through the relevant settings in the appropriate environment via
config/thinking_sphinx.yml: http://sphinxsearch.com/docs/current.html#conf-mysql-sslYou can use relative paths, but it does mean you'll need to commit these files to your app's git repo.
Once you've got it all in place, you'll need to run configure again to copy the updated configuration plus SSL files over to the Flying Sphinx, and then indexing should work.
Hope this helps - if there's any further questions, do let me know.
Kind regards,
Pat
#2 Posted by chase221 on 09 Jun, 2015 05:26 AM
That worked. Thanks for the awesome help!
Chase
#3 Posted by Pat Allan Support staff on 09 Jun, 2015 05:30 AM
No worries, great to know it's working now :)
Pat Allan closed this discussion on 09 Jun, 2015 05:30 AM.