Skip to content

Instantly share code, notes, and snippets.

@IanVaughan

IanVaughan/history

Created May 19, 2012 12:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save IanVaughan/2730636 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save IanVaughan/2730636 to your computer and use it in GitHub Desktop.
Download ZIP
problems with mysql and sequel gem working in ruby
Raw
history
$ sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql 1 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql-2.8.1
$ sudo gem uninstall mysql ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql-2.8.1
$ sudo gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config ✹ ✭master ‹1.9.3-p125›
Fetching: mysql-2.8.1.gem (100%)
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby extconf.rb --with-mysql-config=/usr/local/mysql/bin/mysql_config
*** extconf.rb failed ***
extconf.rb:35:in ``': No such file or directory - /usr/local/mysql/bin/mysql_config --cflags (Errno::ENOENT)
from extconf.rb:35:in `<main>'
$ sudo gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config 1 ↵ ✹ ✭master ‹1.9.3-p125›
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
extconf.rb:35:in ``': No such file or directory - /usr/local/mysql/bin/mysql_config --cflags (Errno::ENOENT)
from extconf.rb:35:in `<main>'
$ gem install -y mysql -- --with-mysql-config=/usr/bin/mysql_config 1 ↵ ✹ ✭master ‹1.9.3-p125›
ERROR: While executing gem ... (Errno::EACCES)
Permission denied - /Users/ivaughan/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/gems/mysql-2.8.1/COPYING
$ ls /usr/bin/mysql_config 1 ↵ ✹ ✭master ‹1.9.3-p125›
ls: /usr/bin/mysql_config: No such file or directory
$ gem install mysqlplus 1 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully installed mysqlplus-0.1.2
$ gem uninstall mysqlplus 130 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysqlplus-0.1.2
$ sudo env ARCHFLAGS="-arch x86_64" gem install mysqlplus ✹ ✭master ‹1.9.3-p125›
Successfully installed mysqlplus-0.1.2
$ gem list mysql 130 ↵ ✹ ✭master ‹1.9.3-p125›
mysqlplus (0.1.2)
$ sudo gem uninstall mysqlplus 1 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysqlplus-0.1.2
$ gem list mysql ✹ ✭master ‹1.9.3-p125›
$ gem list mysql2 ✹ ✭master ‹1.9.3-p125›
$ sudo env ARCHFLAGS="-arch i386" gem install mysql -- \ ✹ ✭master ‹1.9.3-p125›
> --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib \
> --with-mysql-include=/usr/local/mysql/include
Successfully installed mysql-2.8.1
$ sudo gem uninstall mysql sql 130 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql-2.8.1
INFO: gem "sql" is not installed
$ brew uninstall mysql-connector-c 1 ↵ ✹ ✭master ‹1.9.3-p125›
Uninstalling /usr/local/Cellar/mysql-connector-c/6.0.2...
$ gem install mysql ✹ ✭master ‹1.9.3-p125›
Fetching: mysql-2.8.1.gem (100%)
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby extconf.rb
checking for mysql_query() in -lmysqlclient... no
checking for mysql_query() in -lmysqlclient... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lmygcc... no
checking for mysql_query() in -lmysqlclient... no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.
Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby
--with-mysql-config
--without-mysql-config
--with-mysql-dir
--without-mysql-dir
--with-mysql-include
--without-mysql-include=${mysql-dir}/include
--with-mysql-lib
--without-mysql-lib=${mysql-dir}/lib
--with-mysqlclientlib
--without-mysqlclientlib
--with-mlib
--without-mlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-zlib
--without-zlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-socketlib
--without-socketlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-nsllib
--without-nsllib
--with-mysqlclientlib
--without-mysqlclientlib
--with-mygcclib
--without-mygcclib
--with-mysqlclientlib
--without-mysqlclientlib
$ export DYLD_LIBRARY_PATH="$DYLD_LIBRARY_PATH:/usr/local/mysql/lib/" 1 ↵ ✹ ✭master ‹1.9.3-p125›
$ gem install mysql ✹ ✭master ‹1.9.3-p125›
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby extconf.rb
checking for mysql_query() in -lmysqlclient... no
checking for mysql_query() in -lmysqlclient... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lmygcc... no
checking for mysql_query() in -lmysqlclient... no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.
Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby
--with-mysql-config
--without-mysql-config
--with-mysql-dir
--without-mysql-dir
--with-mysql-include
--without-mysql-include=${mysql-dir}/include
--with-mysql-lib
--without-mysql-lib=${mysql-dir}/lib
--with-mysqlclientlib
--without-mysqlclientlib
--with-mlib
--without-mlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-zlib
--without-zlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-socketlib
--without-socketlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-nsllib
--without-nsllib
--with-mysqlclientlib
--without-mysqlclientlib
--with-mygcclib
--without-mygcclib
--with-mysqlclientlib
--without-mysqlclientlib
$ brew install mysql-connector-c 1 ↵ ✹ ✭master ‹1.9.3-p125›
==> Downloading https://downloads.sf.net/project/machomebrew/Bottles/cmake-2.8.8.lion.bottle.1.tar.gz
######################################################################## 100.0%
==> Pouring cmake-2.8.8.lion.bottle.1.tar.gz
/usr/local/Cellar/cmake/2.8.8: 652 files, 30M
==> Installing mysql-connector-c
==> Downloading http://mysql.llarian.net/Downloads/Connector-C/mysql-connector-c-6.0.2.tar.gz
Already downloaded: /Users/ivaughan/Library/Caches/Homebrew/mysql-connector-c-6.0.2.tar.gz
==> cmake -DCMAKE_INSTALL_PREFIX='/usr/local/Cellar/mysql-connector-c/6.0.2' -DCMAKE_BUILD_TYPE=None -Wno-dev .
/usr/local/Cellar/mysql-connector-c/6.0.2: 74 files, 7.2M, built in 74 seconds
$ gem install mysql ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql-2.8.1
$ brew install mysql-connector-c ✹ ✭master ‹1.9.3-p125›
Error: mysql-connector-c-6.0.2 already installed
$ gem uninstall mysql 130 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql-2.8.1
$ gem uninstall ruby-mysql ✹ ✭master ‹1.9.3-p125›
INFO: gem "ruby-mysql" is not installed
$ gem install ruby-mysql ✹ ✭master ‹1.9.3-p125›
Successfully installed ruby-mysql-2.9.7
$ ruby test.rb ✹ ✭master ‹1.9.3-p125›
option not implemented: 5
unsupported flag: CLIENT_COMPRESS
Please EXIT!!!
$ gem uninstall ruby-mysql ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled ruby-mysql-2.9.7
$ mysql --version ✹ ✭master ‹1.9.3-p125›
mysql Ver 14.14 Distrib 5.5.19, for osx10.7 (i386) using readline 5.1
$ ruby test.rb ✹ ✭master ‹1.9.3-p125›
/Users/ivaughan/.rbenv/versions/1.9.3-p125/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require': LoadError: cannot load such file -- mysql (Sequel::AdapterNotFound)
$ gem install mysql 1 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql-2.8.1
$ brew uninstall mysql 130 ↵ ✹ ✭master ‹1.9.3-p125›
Uninstalling /usr/local/Cellar/mysql/5.5.19...
$ brew uninstall mysql-connector-c ✹ ✭master ‹1.9.3-p125›
Uninstalling /usr/local/Cellar/mysql-connector-c/6.0.2...
$ CC=/usr/bin/gcc-4.2 gem install mysql ✹ ✭master ‹1.9.3-p125›
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby extconf.rb
checking for mysql_query() in -lmysqlclient... no
checking for mysql_query() in -lmysqlclient... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lmygcc... no
checking for mysql_query() in -lmysqlclient... no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.
Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby
--with-mysql-config
--without-mysql-config
--with-mysql-dir
--without-mysql-dir
--with-mysql-include
--without-mysql-include=${mysql-dir}/include
--with-mysql-lib
--without-mysql-lib=${mysql-dir}/lib
--with-mysqlclientlib
--without-mysqlclientlib
--with-mlib
--without-mlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-zlib
--without-zlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-socketlib
--without-socketlib
--with-mysqlclientlib
--without-mysqlclientlib
--with-nsllib
--without-nsllib
--with-mysqlclientlib
--without-mysqlclientlib
--with-mygcclib
--without-mygcclib
--with-mysqlclientlib
--without-mysqlclientlib
$ CC=/usr/bin/gcc-4.2 gem install mysql 1 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql-2.8.1
$ mysql --version ✹ ✭master ‹1.9.3-p125›
mysql Ver 14.14 Distrib 5.5.20, for osx10.7 (i386) using readline 5.1
$ cd ~/Downloads mysql-connector-c-6.0.2-osx10.5-x86-64bit ‹1.9.3-p125›
$ cp lib/libmysql.16.0.0.dylib /usr/local/lib
$ brew install mysql
==> Downloading http://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.20.tar.gz
...
==> cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/Cellar/mysql/5.5.20 -DMYSQL_DATADIR=/usr/local/var/mysql -DINSTALL_MANDIR=/usr/local/Cellar/mysql/5.5.20/share/man -DINSTALL_DOCDIR=/
$ rbenv versions 130 ↵ ✹ ✭master ‹1.9.3-p125›
1.9.2-p290
1.9.3-p0
* 1.9.3-p125 (set by RBENV_VERSION environment variable)
ree-1.8.7-2011.03
ree-1.8.7-2012.01
$ rbenv shell 1.9.2-p290 ✹ ✭master ‹1.9.3-p125›
$ gem list sequel ✹ ✭master ‹1.9.2-p290›
$ gem install sequel ✹ ✭master ‹1.9.2-p290›
Successfully installed sequel-3.35.0
$ gem list mysql ✹ ✭master ‹1.9.2-p290›
mysql2 (0.3.11)
$ ruby test.rb ✹ ✭master ‹1.9.2-p290›
Please EXIT!!!
$ rbenv shell 1.9.3-p0 ✹ ✭master ‹1.9.2-p290›
$ ruby test.rb ✹ ✭master ‹1.9.3-p0›
Please EXIT!!!
$ gem list mysql ✹ ✭master ‹1.9.3-p0›
mysql (2.8.1)
mysql2 (0.3.11, 0.3.10, 0.3.7)
$ ruby test.rb ✹ ✭master ‹1.9.3-p0›
Please EXIT!!!
$ gem list sequel ✹ ✭master ‹1.9.3-p0›
sequel (3.34.1, 3.29.0)
$ rbenv shell 1.9.3-p125 ✹ ✭master ‹1.9.3-p0›
$ gem list sequel ✹ ✭master ‹1.9.3-p125›
sequel (3.34.1)
$ gem list mysql ✹ ✭master ‹1.9.3-p125›
mysql (2.8.1)
mysql2 (0.3.11)
$ gem uninstall sequel 130 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled sequel-3.34.1
$ gem install sequel ✹ ✭master ‹1.9.3-p125›
Successfully installed sequel-3.35.0
$ gem uninstall mysql2 130 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql2-0.3.11
$ gem install mysql2 ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql2-0.3.11
$ gem uninstall mysql2 ✹ ✭master ‹1.9.3-p0›
Select gem to uninstall:
1. mysql2-0.3.7
2. mysql2-0.3.10
3. mysql2-0.3.11
4. All versions
> 4
Successfully uninstalled mysql2-0.3.7
Successfully uninstalled mysql2-0.3.10
Successfully uninstalled mysql2-0.3.11
$ gem install mysql2 ✹ ✭master ‹1.9.3-p0›
Successfully installed mysql2-0.3.11
$ gem uninstall mysql2 ✹ ✭master ‹1.9.2-p290›
Successfully uninstalled mysql2-0.3.11
$ gem install mysql2 ✹ ✭master ‹1.9.2-p290›
Successfully installed mysql2-0.3.11
$ gem install mysql2 ✹ ✭master ‹1.9.2-p290›
Successfully installed mysql2-0.3.11
$ mysql -v 130 ↵ ✹ ✭master ‹1.9.2-p290›
Server version: 5.5.19 Source distribution
$ rbenv shell 1.9.3-p125 130 ↵ ✹ ✭master ‹1.9.2-p290›
$ gem uninstall mysql ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql-2.8.1
$ gem uninstall mysql2 ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql2-0.3.11
$ gcc -v ✹ ✭master ‹1.9.3-p125›
Using built-in specs.
Target: i686-apple-darwin11
Configured with: /private/var/tmp/llvmgcc42/llvmgcc42-2335.15~25/src/configure --disable-checking --enable-werror --prefix=/Developer/usr/llvm-gcc-4.2 --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-prefix=llvm- --program-transform-name=/^[cg][^.-]*$/s/$/-4.2/ --with-slibdir=/usr/lib --build=i686-apple-darwin11 --enable-llvm=/private/var/tmp/llvmgcc42/llvmgcc42-2335.15~25/dst-llvmCore/Developer/usr/local --program-prefix=i686-apple-darwin11- --host=x86_64-apple-darwin11 --target=i686-apple-darwin11 --with-gxx-include-dir=/usr/include/c++/4.2.1
Thread model: posix
gcc version 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)
$ gem install mysql --debug ✹ ✭master ‹1.9.3-p125›
$ ruby test.rb ✹ ✭master ‹1.9.3-p125›
/Users/ivaughan/.rbenv/versions/1.9.3-p125/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require': LoadError: cannot load such file -- mysql2 (Sequel::AdapterNotFound)
INFO: gem "mysql2" is not installed
$ gem uninstall mysql ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql-2.8.1
$ ruby test.rb ✹ ✭master ‹1.9.3-p125›
/Users/ivaughan/.rbenv/versions/1.9.3-p125/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require': LoadError: cannot load such file -- mysql (Sequel::AdapterNotFound)
$ cat /usr/bin/mysql_config 1 ↵ ✹ ✭master ‹1.9.3-p125›
cat: /usr/bin/mysql_config: No such file or directory
$ brew update mysql 1 ↵ ✹ ✭master ‹1.9.3-p125›
==> Updated Formula
$ gem install mysql ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql-2.8.1
Server version: 5.5.19 Source distribution
$ gem uninstall mysql 1 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql-2.8.1
$ gem install mysql -- —–with-mysql-config=/usr/local/mysql/bin/mysql_config 1 ↵ ✹ ✭master ‹1.9.3-p125›
ERROR: While executing gem ... (Errno::EACCES)
Permission denied - /Users/ivaughan/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/gems/mysql-2.8.1/COPYING
$ sudo gem install mysql -- —–with-mysql-config=/usr/local/mysql/bin/mysql_config 1 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql-2.8.1
$ sudo gem uninstall mysql 255 ↵ ✹ ✭master ‹1.9.3-p125›
Successfully uninstalled mysql-2.8.1
$ sudo gem uninstall mysql ✹ ✭master ‹1.9.3-p125›
INFO: gem "mysql" is not installed
$ env ARCHFLAGS="-arch x86_64" gem install mysql ✹ ✭master ‹1.9.3-p125›
Successfully installed mysql-2.8.1
$ sudo gem update --system 130 ↵ ✹ ✭master ‹1.9.3-p125›
RubyGems 1.8.24 installed
$ sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
Building native extensions. This could take a while...
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby extconf.rb --with-mysql-config=/usr/local/mysql/bin/mysql_config
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.
Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby
--with-mysql-config
extconf.rb:35:in ``': No such file or directory - /usr/local/mysql/bin/mysql_config --cflags (Errno::ENOENT)
from extconf.rb:35:in `<main>'
$ sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby extconf.rb --with-mysql-config=/usr/local/mysql/bin/mysql_config
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.
Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=/Users/ivaughan/.rbenv/versions/1.9.3-p125/bin/ruby
--with-mysql-config
extconf.rb:35:in ``': No such file or directory - /usr/local/mysql/bin/mysql_config --cflags (Errno::ENOENT)
from extconf.rb:35:in `<main>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment