From: Rich <rich@...>
Date: 2004-05-23T23:51:18+09:00
Subject: Re: mysql-ruby

Use ruyb-mysql and don't use dbi.

I've been down what sounds like the same frustrating road, and it didn't
stop until I used ruby-mysql.

(Note: ruby-mysql is different from mysql-ruby)

-Rich


----- Original Message ----- 
From: "paul vudmaska" <paul@vudmaska.com>
Newsgroups: comp.lang.ruby
To: "ruby-talk ML" <ruby-talk@ruby-lang.org>
Sent: Sunday, May 23, 2004 1:53 AM
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.
>