Rails + Ubuntu + MySQL = Error

Question

I have XAMPP installed on Ubuntu 12.04 and it all works. I've also been using Rails for a while with PostgreSQL and it also worked fine.

Today, I tried creating a new app using mysql with mysql2 gem, and got an error while running rake db:create.

I first checked the other Rails/MySQL questions on SO, and will say:

MySQL is running
Using mysql2 gem
DB config looks correct (to me)
database.yml using socket: /opt/lampp/var/mysql/mysql.sock

Error:

/opt/lampp/lib/libmysqlclient.so.18: symbol SSL_accept, version OPENSSL_1.0.1 not defined in file libssl.so.1.0.0 with link time reference - /home/wwc/.rvm/gems/ruby-2.0.0-p353/extensions/x86_64-linux/2.0.0/mysql2-0.3.14/mysql2/mysql2.so
/home/wwc/.rvm/gems/ruby-2.0.0-p353/gems/mysql2-0.3.14/lib/mysql2.rb:8:in `require'
/home/wwc/.rvm/gems/ruby-2.0.0-p353/gems/mysql2-0.3.14/lib/mysql2.rb:8:in `<top (required)>'
/home/wwc/.rvm/gems/ruby-2.0.0-p353@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `require'
/home/wwc/.rvm/gems/ruby-2.0.0-p353@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `block (2 levels) in require'
/home/wwc/.rvm/gems/ruby-2.0.0-p353@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `each'
/home/wwc/.rvm/gems/ruby-2.0.0-p353@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `block in require'
/home/wwc/.rvm/gems/ruby-2.0.0-p353@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `each'
/home/wwc/.rvm/gems/ruby-2.0.0-p353@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `require'
/home/wwc/.rvm/gems/ruby-2.0.0-p353@global/gems/bundler-1.3.5/lib/bundler.rb:132:in `require'
/media/fat64/work/_active/josephzidell_rails/config/application.rb:7:in `<top (required)>'
/media/fat64/work/_active/josephzidell_rails/Rakefile:4:in `require'
/media/fat64/work/_active/josephzidell_rails/Rakefile:4:in `<top (required)>'
/home/wwc/.rvm/gems/ruby-2.0.0-p353/bin/ruby_executable_hooks:15:in `eval'
/home/wwc/.rvm/gems/ruby-2.0.0-p353/bin/ruby_executable_hooks:15:in `<main>'

do you have the ssl libs installed? – Marc B Jan 19 '14 at 04:44 — Marc B, Jan 19 '14 at 04:44
Not sure. If not, what's the command? – Joe Z Jan 19 '14 at 07:39 — Joe Z, Jan 19 '14 at 07:39

score 0 · Answer 1 · answered Feb 18 '14 at 11:15

0

You can try installing SSL libs using:

apt-get install libssl-dev

You can check the path that it has been installed in using:

apt-file list libssl-dev

you may need to install apt-file first by running:

sudo apt-get install apt-file
apt-file update

answered Feb 18 '14 at 11:15

MattW

1

MattW, thanks for your help. `libssl-dev` was already installed. – Joe Z Feb 18 '14 at 16:29

score 0 · Answer 2 · edited May 23 '17 at 12:05

The Ruby 2.0.0 got problem with OpenSSL 1.0.1f

Check How can I ensure that Ruby uses an OpenSSL not vulnerable to Heartbleed? and you will realize that your Ruby's OpenSSL lib is not up-to-date

Follow these command (credit: https://coderwall.com/p/tptocq) rvm pkg install openssl rvm install 2.0.0 \ --with-openssl-dir=$HOME/.rvm/usr \ --verify-downloads 1

The new installed Ruby 2.0.0 on your machine will got the final OpenSSL version (1.0.1g), which also patched for the Heart Bleed.

Rails + Ubuntu + MySQL = Error

2 Answers2