Appfog mysql tunnel error - Encryption not available on this event-machine

Question

We've established a connection to appfog using caldecott and af tunnel command. We try to connect to a mysql service to load and execute a big .sql file to populate the db.

We tried it from 3 different machines Ubuntu on VirtualBox, Feora 18 on VirtualBox and native Ubuntu. We also tried it on another account, but we keep getting this error:

Launching 'mysql --protocol=TCP --host=localhost --port=10000 --user=uZVQhGhbYEzyb --password=pNu1l6xbXVhbj d39d6d0e6344b41a4aaeada16dfca2a46'

terminate called after throwing an instance of 'std::runtime_error'
 what():  Encryption not available on this event-machine
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Aborted (core dumped)

if it works with smaller payloads then the size of the payload is the issue. — mpm, Apr 02 '13 at 15:33

score 11 · Answer 1 · edited Oct 03 '15 at 22:13

11

Thanks to appfog customer support I managed to solve this problem. My distro lacked an ssl provider.

To solve this on fedora

yum install openssl openssl-devel
gem uninstall eventmachine
gem install eventmachine

However I still had a problem with executing big sql scripts. Does anyone know a neat solution to this issue?

edited Oct 03 '15 at 22:13

Nakilon

34,866
14
107
142

answered Apr 03 '13 at 16:20

JohnnyM

1,273
1
13
26

2

Thanks. In my case I had to install libssl-dev instead openssl-devel. (debian machine) – Pawel Jan 10 '14 at 20:20
By "problem", do you mean that the connection is unstable? Because that has always been my experience with AppFog tunneling. – Paul Draper Jan 31 '14 at 08:29
On Fedora, make sure to reinstall all of the gems after installing openssl and openssl-devel – Freedom_Ben Feb 03 '15 at 05:36

score 3 · Answer 2 · edited Apr 29 '15 at 17:53

3

For a Windows system, I got it to run by doing the following:

Install Win32 OpenSSL v1.0.1e Light from here
Install Visual C++ 2008 Redistributables from the same link if not already installed.
Re-install eventmachine in Ruby with the newly installed open-ssl.

gem install eventmachine -- --with-ssl-dir=C:\OpenSSL-Win32

(you might need C:\OpenSSL-Win32\bin)

After the installation is complete, you're ready to tunnel to any service! (In my case postgresql)

edited Apr 29 '15 at 17:53

Community

1
1

answered Aug 20 '13 at 13:06

Anup Chaudhari

335
1
10

OpenSSL distribution from the provided link didn't work for me. `gem install eventmachine` command didn't show any error messages while building so I wasn't sure if it was built with ssl support as expected. But I was able to install an alternative OpenSSL distribution from sourcefourge (http://gnuwin32.sourceforge.net/packages/openssl.htm), used it in the `with-ssl-dir` option and everything went just fine. – Cléssio Mendes May 02 '15 at 22:08

Appfog mysql tunnel error - Encryption not available on this event-machine

2 Answers2