Rubygems - Mysql

[Craig White]

On Sun, 2006-11-26 at 18:02 -0700, Craig White wrote:
> On Sun, 2006-11-26 at 18:51 -0600, Michael Satterwhite wrote:
> > I'm trying to do a "gem install mysql", but I can't get the gem to
> > build. Right at the beginning, I'm getting the error
> > 
> > ------------------
> > find_library: checking for mysql_query() in -lmysqlclient...
> > -------------------
> > - no
> > 
> > "gcc -o conftest -I. -I/usr/lib/ruby/1.8/i686-linux -I.
> > -I/usr/local/include  -g
> >  -O2 conftest.c  -L'/usr/local/lib' -Wl,-R'/usr/local/lib' -L'/usr/lib'
> > -Wl,-R'/
> > usr/lib'  -rdynamic -Wl,-export-dynamic     -lruby-static -lmysqlclient
> > -ldl -l
> > crypt -lm   -lc"
> > conftest.c: In function ‘t’:
> > conftest.c:3: error: ‘mysql_query’ undeclared (first use in this
> > function)
> > --------------------
> > 
> > I'm sure this is something that I need to install in Fedora, but I'm not
> > sure which package would have this. Can anyone offer any advice?
> ----
>  # locate mysqlclient
> /usr/lib/mysql/libmysqlclient.so.15
> /usr/lib/mysql/libmysqlclient.so.15.0.0
> /usr/lib/mysql/libmysqlclient_r.so.15
> /usr/lib/mysql/libmysqlclient_r.so.15.0.0
> 
> # rpm -q --whatprovides /usr/lib/mysql/libmysqlclient.so.15
> mysql-5.0.22-1.FC5.1
> 
> make sure you install 'gems' as root
----
and by the way...was that a 'fatal error' ? Did it fail to install?
Compile time errors are not uncommon - some of them are not a problem
(depends upon the package being compiled) and some of them are
absolutely fatal.

Also - important to note when using ruby on rails...

# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=0

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

NOTE line... old_passwords=0

I think by default, this is set to '1' which means true which I think is
a problem with ruby on rails (i.e., unless set to '0' and mysql is
restarted 'service mysqld restart', you will have trouble connecting
rubyonrails to mysql)

Craig