Hello:
I am trying to connect to a remote mysql server via ruby with require
mysql tag.
I am seeing the following error :
dbconnect.rb:4:in `require’: no such file to load – mysql (LoadError)
from dbconnect.rb:4
Any thoughts ?
thanks
did you install the mysql adapter gem?
Michael S. wrote:
did you install the mysql adapter gem?
That’s where the problem is coming. I tried doing that in both manner:
gem install mysql
and as shown here :
http://www.notsostupid.com/blog/2007/10/25/ruby-leopard-and-gems/
Both result in :
Building native extensions. This could take a while…
ERROR: While executing gem … (Gem::Installer::ExtensionBuildError)
ERROR: Failed to build gem native extension.
ruby extconf.rb install mysql
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lm… yes
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lz… yes
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
*** extconf.rb failed ***
Appreciate your response. Thanks in advance.
Aashish
Did you install MySQL? Binary or Source? Even if you are connecting to
a remote database, you are still going to have to have mysql header
files and libs installed.
Michael S. wrote:
Did you install MySQL? Binary or Source? Even if you are connecting to
a remote database, you are still going to have to have mysql header
files and libs installed.
NO I haven’t installed MYSQL ( Binary/libraries/header files). Do you
mean a full mysql install ? Or are there drivers available ??
On Oct 29, 2007 8:34 PM, X43 X43 [email protected] wrote:
Michael S. wrote:
Did you install MySQL? Binary or Source? Even if you are connecting to
a remote database, you are still going to have to have mysql header
files and libs installed.NO I haven’t installed MYSQL ( Binary/libraries/header files). Do you
mean a full mysql install ? Or are there drivers available ??
So, you need to install MySQL first. You can grab a binary installer
from mysql.com for your architecture.
Then, in order to install the Ruby bindings, follow the steps here:
Please tell us if this doesn’t work for you.
Laurent
Laurent S. wrote:
Please tell us if this doesn’t work for you.
Laurent
This works!!! Thanks Laurent.
Aashish