From: David D'Andrea <ddandrea@...>
Date: 2003-06-24T17:39:57+09:00
Subject: Re: Newbie dbi install problem

Appreciate the pointer, pretty ug primitive mistake there.

However I still can't get this to work. I think the mysql DBD isn't 
getting installed properly.

[~/Desktop/mysql-ruby-2.4.4a]% ruby extconf.rb 
--with-mysql-include=/usr/local/mysql/include 
--with-mysql-lib=/usr/local/mysql/lib
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... yes
checking for mysql.h... yes
creating Makefile
% make
gcc -fno-common -g -O2 -fno-common -pipe -no-cpp-precomp  -I. 
-I/sw/lib/ruby/1.6/powerpc-darwin6.6 -I. -I/sw/include -DHAVE_MYSQL_H 
-I/sw/include  -I/usr/local/mysql/include -c -o mysql.o mysql.c
mysql.c: In function `Init_mysql':
mysql.c:1420: `ER_SUBSELECT_NO_' undeclared (first use in this function)
mysql.c:1420: (Each undeclared identifier is reported only once
mysql.c:1420: for each function it appears in.)
make: *** [mysql.o] Error 1
% ruby -I. ./test.rb localhost root lovelypass
./test.rb:11:in `require': No such file to load -- ./mysql (LoadError)
         from ./test.rb:11
'%make install' here fails too, and running simple.rb still returns the 
same error (undefined method, DBI::InterfaceError)

hrmm...?

I believe I have the include & lib parameters to extconf.rb correctly 
set...  Running extconf.rb with no args, or as suggested in DuBois' 
tutorial also fail (they don't find the mysql_query())
I'm not sure what to try at this point, I've taken a few stabs:
It doesn't make a difference if I reinstall the DBI after this DBD 
install.
I've also tried stopping mysqld before installing the DBD, and 
installing under bash, no difference.
I've even tried editing extconf.rb's Makefile to fill in an empty 
LIBPATH param...

any ideas?  I hope I'm not missing something obvious again...

David

On Monday, June 23, 2003, at 02:55  PM, Brian Candler wrote:
> You need to install the ruby-mysql package, *as well as* the ruby-dbi
> package. (ruby-dbi is just a wrapper around ruby-dbi, which is in turn 
> a
> Ruby wrapper around the native C API)