CANNOT get Ruby to work with SQL

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?

Rails apps use a database configuration file,
/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

-----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%20cannot%20find%20mysql%20socket&ie=UTF-8&oe=UTF-8

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


Phillip G.
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-----

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs