Asp Forum - Ruby, Rails & MySQL - configuration problem

Kenosis

7/15/2005 4:39:00 PM

Greetings,

Perhaps this should be posted to a mysql related group, however I'm
guessing someone in the Ruby/Rails community may have seen this problem
so I'm posting here hoping for some help.

So, I have Ruby 1.8.x, Rails and MySQL installed and running on a
RedHat Linux PC. Ruby compiles and runs fine as does Rails. The
problem I'm having is w/MySQL configuration: in order to get the MySQL
binary distribution I installed on my PC to run its self-tests and
bench marks, I had to setup /etc/my.cfg as follows:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

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

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

[client]
socket=/tmp/mysql.sock
password=<omitted :>

When I try to connect to my test database (per the Rails tutorial at
http://www.onlamp.com/pub/a/onlamp/2005/01/20/...), MySQL fails
to find the client socket /tmp/mysql.sock.

I had this same problem with MySQL's mysql-tests: adding the [client]
section (as above) to my.cfg fixed this problem. Similarly, the MySQL
sql-bench would not run w/out the [mysqld] socket set to
/var/lib/mysql/mysql.sock Admittedly, I'm new to MySQL and Linux so
there must be something obvious I'm missing.

Lastly, as I progress through the aforementioned Rails tutorial, all
works fine up to the point of trying to read from MySQL so I presume my
configuration of database.yml is correct (the connection is not being
deined.)

Any help you can lend will, as always, be appreciated.

Ken Hilton
Kenosis LLC

1 Answer

Kenosis

7/15/2005 4:56:00 PM

Of course, 5 minutes after I posted this I figured it out :) Thanks
never-the-less :)

Ken

comp.lang.ruby

Ruby, Rails & MySQL - configuration problem

Kenosis

Kenosis

x Login to ForumsZone