[Rails]

[Craig White]

On Sun, 2006-02-26 at 09:33 +0100, bbqbaker wrote:
> i just recently purchase agile web dev book about ruby on rails and 
> going through the whole project.  well i am now stuck on creating the 
> scaffold. I have been messing with settings for awhile now. here is the 
> error:
> 
> koloa at ubuntu:/var/www/depot$ ruby script/generate scaffold Product Admin
> exists app/controllers/
> exists app/helpers/
> exists app/views/admin
> exists test/functional/
> dependency model
> exists app/models/
> exists test/unit/
> exists test/fixtures/
> identical app/models/product.rb
> identical test/unit/product_test.rb
> identical test/fixtures/products.yml
> No such file or directory - /tmp/mysql.sock
> 
> ////////////////////////////////////////////////////////
> 
> now i have been searching the forums and google but getting even more 
> confused. what is the difference between mysql.sock and mysqld.sock? is 
> this file created when mysql starts?
> 
> does mysql port number have to be the same that my RoR site is 
> configured to? example my RoR site is localhost:3000, do I have to go 
> into the mysql conf file and change the default 3203(or something) to 
> 3000? thank you for the help!!!!!!!!!!!!!
----
how to connect to mysql is totally dependent upon your setup.

if on mysql windows...remove the socket and put 

port: 3306

and make sure that the port is not blocked by firewall (I presume TCP
but unblock both TCP & UDP just in case)

if mysql on Linux and it is localhost...chances are likely that the
socket is /var/lib/mysql/mysql.sock

if mysql is started on localhost...see if you can connect to it from
command line.

mysql DATABASE_NAME -h localhost -u USER_NAME -p 

and you can determine socket location (if available) by doing

ps aux|grep mysql

Craig