SSL connection error:

chase221's Avatar

chase221

09 Jun, 2015 04:02 AM

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. Support Staff 1 Posted by Pat Allan on 09 Jun, 2015 04:08 AM

    Pat Allan's Avatar

    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-ssl

    You 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. 2 Posted by chase221 on 09 Jun, 2015 05:26 AM

    chase221's Avatar

    That worked. Thanks for the awesome help!

    Chase

  3. Support Staff 3 Posted by Pat Allan on 09 Jun, 2015 05:30 AM

    Pat Allan's Avatar

    No worries, great to know it's working now :)

  4. Pat Allan closed this discussion on 09 Jun, 2015 05:30 AM.

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

Keyboard shortcuts

Generic

? 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