CANNOT get Ruby to work with SQL

[Corne Lombaard]

Please can someone help me?

I get the following error message when I start the rails server and I
click on About your application environment.

Errno::ENOENT in Rails/infoController#properties

No such file or directory - /tmp/mysql.sock

RAILS_ROOT: /home/corne/Studies/Ruby/Sites/demo

If I did a mysql> show variables like '%sock%' I get
the following:

/var/lib/mysql/mysql.sock

I do not know anything about Ruby, Linux, Sockets or the rest. Please
can someone tell me where to put this information or how do I setup my
database so that it works with Ruby?

 

[Phillip Gawlowski]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Corne Lombaard wrote:
| Please can someone help me?
|
| I get the following error message when I start the rails server and I
| click on About your application environment.
|
| Errno::ENOENT in Rails/infoController#properties
|
| No such file or directory - /tmp/mysql.sock
|
| RAILS_ROOT: /home/corne/Studies/Ruby/Sites/demo
|
| If I did a mysql> show variables like '%sock%' I get
| the following:
|
| /var/lib/mysql/mysql.sock
|
| I do not know anything about Ruby, Linux, Sockets or the rest. Please
| can someone tell me where to put this information or how do I setup my
| database so that it works with Ruby?

A quick Google[0] shows this link:
<http://abstractplain.net/blog/?p=973>, which mentions that you can
modify the database.yml file to include a path to your socket file.

Also, Rails questions (and this is a question about Rails, and not a
general 'Ruby and SQL' question) are better off asked to the Rails
community[1].

[0]
<http://www.google.com/search?client=safari&rls=en&q=rails cannot find mysql socket&ie=UTF-8&oe=UTF-8>

[1] http://rubyonrails.com/community

- --
Phillip Gawlowski
Twitter: twitter.com/cynicalryan
Blog: http://justarubyist.blogspot.com

You were ever good at sudden commendations.
~ -- William Shakespeare (1564-1616), King Henry VIII
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkgZtYwACgkQbtAgaoJTgL+PWgCfYic9zpJRfbD/OSsc30zz+40/
IikAn1cpTg/U+7qFNuGmC/4fH+JKaohq
=ljok
-----END PGP SIGNATURE-----

 

[Craig Demyanovich]

[Note: parts of this message were removed to make it a legal post.]

Rails apps use a database configuration file,
<path-to-your-rails-app>/config/database.yml. When using mysql, there's
often a line in the file for each database like

socket: /tmp/mysql.sock

You could replace that path with the one from your error message,
/var/lib/mysql/mysql.sock. Alternatively, you could just remove the "socket"
lines from the file. I'm on Mac OS X, and I installed mysql via macports. I
find that I don't need to specify the location of the socket, so I just
delete that line.

For future issues with Rails, you should consult the rails-talk mailing
list, http://groups.google.com/group/rubyonrails-talk .

Good luck,
Craig