# Problem in Database Connection

**URL:** <https://www.ruby-forum.com/t/problem-in-database-connection/82100>\
**Category:** Rails\
**Created:** [January 17, 2007, 12:35pm UTC](https://www.ruby-forum.com/t/problem-in-database-connection/82100 "2007-01-17T12:35:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dhirajmundada](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/96bed5/32.png) [@dhirajmundada](https://www.ruby-forum.com/u/dhirajmundada)\
**Post date:** [January 17, 2007, 12:35pm UTC](https://www.ruby-forum.com/t/problem-in-database-connection/82100/1 "2007-01-17T12:35:05Z")

</div>

Hi guys,

I have installed rails on my LINUX machine and was following a tutorial  
on following link

> **[Radar - O’Reilly](https://www.oreilly.com/radar/?page=3)**
>
> Now, next, and beyond: Tracking need-to-know trends at the intersection of business and technology

But I was unable to proceed after creating respective tables in MySQL  
database.  
When I executed command,

ruby script\generate controller Recipe

it worked fine. The next step was to add a line  
scaffold :recipe  
to the file recipe\_controller.rb . I did that. But when I wrote

```
      http://localhost:3000/recipe/new

```

inside my browser window, it gave me an error,

Errno::ENOENT in RecipeController#new

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

RAILS\_ROOT: script/…/config/…

What do I do now???

Thanks & Regards,

Dhiraj Mundada

---

<div class="post-metadata">

**Author:** ![dhirajmundada](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/96bed5/32.png) [@dhirajmundada](https://www.ruby-forum.com/u/dhirajmundada)\
**Post date:** [January 17, 2007, 1:56pm UTC](https://www.ruby-forum.com/t/problem-in-database-connection/82100/2 "2007-01-17T13:56:22Z")

</div>

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

Your mysql.sock file may be in a different directory (or even called  
differently). Consult your MySQL configuration or use `find / -name mysql.sock` to find its whereabouts and adjust your config/database.yml  
accordingly.

Regards,

Roderick

–  
Nedforce Informatica Specialisten B.V.

> **[De domeinnaam Nedforce.nl is te koop.](http://www.nedforce.nl)**
>
> Deze mooie domeinnaam kan al over een paar minuten van jou zijn. Betalen gaat eenvoudig en vertrouwd via iDEAL. Direct na de betaling ontvang je de verhuiscode per e-mail en kun je aan de slag.

+31 (0)53 4500225

---

<div class="post-metadata">

**Author:** ![dhirajmundada](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/96bed5/32.png) [@dhirajmundada](https://www.ruby-forum.com/u/dhirajmundada)\
**Post date:** [January 17, 2007, 2:41pm UTC](https://www.ruby-forum.com/t/problem-in-database-connection/82100/3 "2007-01-17T14:41:02Z")

</div>

Hi Rodrisk,  
I found the path to mysql.sock…  
It is /var/lib/mysql/mysql.sock

But I dont know what changes to make to config/database.yml file…

Will you please tell me???

Thanks & Regards…

---

<div class="post-metadata">

**Author:** ![dhirajmundada](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/96bed5/32.png) [@dhirajmundada](https://www.ruby-forum.com/u/dhirajmundada)\
**Post date:** [January 17, 2007, 2:59pm UTC](https://www.ruby-forum.com/t/problem-in-database-connection/82100/4 "2007-01-17T14:59:36Z")

</div>

> I found the path to mysql.sock…  
> It is /var/lib/mysql/mysql.sock
> 
> But I dont know what changes to make to config/database.yml file…

If you can’t find out by yourself, you should consider buying a book  
about Rails. You will have many more questions and there’s no free  
helpdesk.

But here you go:

socket: /var/lib/mysql/mysql.sock

- Roderick

–  
Nedforce Informatica Specialisten B.V.

> **[De domeinnaam Nedforce.nl is te koop.](http://www.nedforce.nl)**
>
> Deze mooie domeinnaam kan al over een paar minuten van jou zijn. Betalen gaat eenvoudig en vertrouwd via iDEAL. Direct na de betaling ontvang je de verhuiscode per e-mail en kun je aan de slag.

+31 (0)53 4500225