# Problem with database.yml **URL:** \ **Category:** Rails\ **Created:** [October 3, 2007, 10:26am UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189 "2007-10-03T10:26:31Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jacob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f1d935/32.png) [@jacob](https://www.ruby-forum.com/u/jacob)\ **Post date:** [October 3, 2007, 10:26am UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189/1 "2007-10-03T10:26:31Z")
Hi all! I am completely new to RoR and I have runned into a problem. I have followed an online course for RoR on [Lynda.com](http://Lynda.com) and everything has worked out well until I should change to database.yml file. Instead of the tutors text “host: localhost” I get “socket: /tmp/ mysql.sock” in development enviroment I thought I would give it a try to continue anyway but when I later try to do “rake db:migrate” after activating my webserver, I get this error: rake aborted! syntax error on line 18, col 2: ` host: localhost’ (See full trace by running task with --trace) Any help would be gladely appreciated 🙂 Thanks in advance, Jacob ---
**Author:** ![jacob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f1d935/32.png) [@jacob](https://www.ruby-forum.com/u/jacob)\ **Post date:** [October 3, 2007, 10:36am UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189/2 "2007-10-03T10:36:10Z")
Jacob wrote: > Hi all! I am completely new to RoR and I have runned into a problem. I > have followed an online course for RoR on [Lynda.com](http://Lynda.com) and everything has > worked out well until I should change to database.yml file. > > Instead of the tutors text “host: localhost” I get “socket: /tmp/ > mysql.sock” in development enviroment my database.yml looks like this: host: localhost db… user… passwd… adapter… socket: host is a must, socket is an option. the socket describes the path to your database connection. in ubuntu its /var/run/mysqld/mysqld.sock benni ---
**Author:** ![jacob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f1d935/32.png) [@jacob](https://www.ruby-forum.com/u/jacob)\ **Post date:** [October 3, 2007, 10:54am UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189/3 "2007-10-03T10:54:00Z")
Thanks for your reply. I might add that I use mac os x… How should I do to make it work? On 3 Okt, 10:36, Benjamin M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![jacob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f1d935/32.png) [@jacob](https://www.ruby-forum.com/u/jacob)\ **Post date:** [October 3, 2007, 11:41am UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189/4 "2007-10-03T11:41:28Z")
Jacob wrote: > Thanks for your reply. I might add that I use mac os x… > > How should I do to make it work? mac os x is standard in rails-development, isn’t it? try to comment out the socket-line: # socket: … ---
**Author:** ![jacob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f1d935/32.png) [@jacob](https://www.ruby-forum.com/u/jacob)\ **Post date:** [October 3, 2007, 12:14pm UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189/5 "2007-10-03T12:14:43Z")
Thanks for your response Benjamin. I am sorry but I am too much of a beginner to see what you mean by commenting out of the socket-line… I guess that you have to bring it down to a 3 year olds level 🙂 On 3 Okt, 11:41, Benjamin M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![jacob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f1d935/32.png) [@jacob](https://www.ruby-forum.com/u/jacob)\ **Post date:** [October 3, 2007, 1:40pm UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189/6 "2007-10-03T13:40:43Z")
I identified the problem. instead of spaces there were tabs before the lines. Kind of strange since that file is generated by the system… rake db:migrate still doesn´t work, now it tells me that “#28000Access denied for user ‘root’@‘localhost’ (using password: NO)” but at least it´s one step in the right direction 🙂 ---
**Author:** ![jacob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f1d935/32.png) [@jacob](https://www.ruby-forum.com/u/jacob)\ **Post date:** [October 3, 2007, 12:25pm UTC](https://www.ruby-forum.com/t/problem-with-database-yml/116189/7 "2007-10-03T12:25:50Z")
On 3 Oct 2007, at 11:13, Jacob wrote: > Thanks for your response Benjamin. > > I am sorry but I am too much of a beginner to see what you mean by > commenting out of the socket-line… I guess that you have to bring it > down to a 3 year olds level 🙂 > Comment out: place a # symbol at the start of the line. > It’s also worth checking that you’ve indented with spaces not tabs - > yaml doesn’t like tabs Fred