From: paul@... (paul vudmaska)
Date: 2004-05-23T16:53:45+09:00
Subject: Re: mysql-ruby

Paul Vudmaska <paul@vudmaska.com> wrote in message news:<40AF9541.7080403@vudmaska.com>...
> Appologies for top posting and inconveniencing everyone.
> redhat linux 9.2
> ruby 1.8
> mysql-ruby 2.4.5
> dbi 0.23
> mysql 4.0.2
> 
> In a nutshell, dbi is dieing(killing the response) calling either 
> select_one, or select_all (but do works), no header, no response at all.

This is definately a  bad install of mysql-ruby. I've tried it with
params all ways from sunday, as per this page ,
http://www.tmtm.org/en/mysql/ruby/README.  . I've written the owner. I
asked a guy who had experienced this before.
http://groups.google.com/groups?q=null+pointer+mysql-ruby&hl=en&lr=&ie=UTF-8&selm=1064375532.9480.6.camel%40localhost.localdomain&rnum=2

Yet I cant get the test.rb to fly.

The defaults dont reflect my installation so i've given the paths to
mysql, which is /usr/local/mysql. So i've changed the paths. And even
used the last option to configure from the configure command with the
same result.


[root@iis mysql-ruby-2.4.5]# ruby -I. ./test.rb localhost root pwd
connect.............ok
create_db...........ok
create_table........ok
insert..............ok
select.............../t/40select.rb:4:in `fetch_hash': NULL pointer
given (Arg
entError)
       from ./t/40select.rb:4
       from ./test.rb:23:in `load'
       from ./test.rb:23
       from ./test.rb:19:in `each'
       from ./test.rb:19

[root@iis mysql-ruby-2.4.5]# ruby extconf.rb --with-mysql-config
checking for mysql.h... yes
creating Makefile
[root@iis mysql-ruby-2.4.5]# make
gcc -fPIC -g -O2  -I. -I/usr/local/lib/ruby/1.8/i686-linux
-I/usr/local/lib/ruby/1.8/i686-linux -I. -DHAVE_MYSQL_H 
-I/usr/local/mysql/include -mcpu=pentiumpro -c mysql.c
gcc -shared  -L"/usr/local/lib" -o mysql.so mysql.o 
-L/usr/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl -lm -lc
-lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv 
-ldl -lcrypt -lm   -lc
[root@iis mysql-ruby-2.4.5]# ruby -I. ./test.rb localhost root pwd
connect.............ok
create_db...........ok
create_table........ok
insert..............ok
select.............../t/40select.rb:4:in `fetch_hash': NULL pointer
given (ArgumentError)
       from ./t/40select.rb:4
       from ./test.rb:23:in `load'
       from ./test.rb:23
       from ./test.rb:19:in `each'
       from ./test.rb:19
[root@iis mysql-ruby-2.4.5]# ruby extconf.rb
--with-mysql-config=/usr/local/mysql/config
extconf.rb:1: command not found: /usr/local/mysql/config --cflags
[root@iis mysql-ruby-2.4.5]# ruby extconf.rb
--with-mysql-include=/usr/local/mysql/include
--with-mysql-lib=/usr/local/mysql/lib
--with-mysql-dir=/usr/local/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... yes
checking for mysql.h... yes
creating Makefile
[root@iis mysql-ruby-2.4.5]# make
gcc -fPIC -g -O2  -I. -I/usr/local/lib/ruby/1.8/i686-linux
-I/usr/local/lib/ruby/1.8/i686-linux -I. -DHAVE_MYSQL_H
-I/usr/local/mysql/include -I/usr/local/mysql/include  -c mysql.c
gcc -shared  -L"/usr/local/lib" -L"/usr/local/mysql/lib" -o mysql.so
mysql.o  -lmysqlclient -lz -lm  -ldl -lcrypt -lm   -lc
[root@iis mysql-ruby-2.4.5]# ruby -I. ./test.rb localhost root pwd    
   connect.............ok
create_db...........ok
create_table........ok
insert..............ok
select.............../t/40select.rb:4:in `fetch_hash': NULL pointer
given (ArgumentError)
       from ./t/40select.rb:4
       from ./test.rb:23:in `load'
       from ./test.rb:23
       from ./test.rb:19:in `each'
       from ./test.rb:19
[root@iis mysql-ruby-2.4.5]#

I've tried above and more. I dont know where these libraries are or
even what it asking for.

any insight besides 'dont top post' would be great.