# \[NEW TO RoR\] - Error on Rake DB:Create

**URL:** <https://www.ruby-forum.com/t/new-to-ror-error-on-rake-db-create/182465>\
**Category:** Rails\
**Created:** [January 28, 2010, 3:10pm UTC](https://www.ruby-forum.com/t/new-to-ror-error-on-rake-db-create/182465 "2010-01-28T15:10:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nelson\_AndrSSSS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/e274bd/32.png) [@Nelson\_AndrSSSS](https://www.ruby-forum.com/u/Nelson_AndrSSSS)\
**Post date:** [January 28, 2010, 3:10pm UTC](https://www.ruby-forum.com/t/new-to-ror-error-on-rake-db-create/182465/1 "2010-01-28T15:10:56Z")

</div>

Hello there,

this is my first post and I’m new to Ruby on Rails.

I’m getting the following error when I do “rake db:create” :

(in /home/nelson/rubyapps/blog)  
rake aborted!  
syntax error on line 24, col 1: ` socket : /var/run/mysqld/  
mysqld.sock’

Now the background:

I installed Ubuntu Karmic Koala 9.10 in a Sun VirtualBox virtual  
machine running in a Windows XP host

Following Ubuntu installation I followed this guide :  
[http://www.hackido.com/2009/11/install-ruby-on-rails-on-ubuntu-karmic.html](http://www.hackido.com/2009/11/install-ruby-on-rails-on-ubuntu-karmic.html)

until STEP 6 , included, to have RoR installed on the Ubuntu box

In step 1 I set my locale to pt-PT (I’m from Portugal) using

sudo locale-gen pt\_PT.UTF-8  
and  
sudo /usr/sbin/update-locale LANG=pt\_PT.UTF-8

Next I followed this guide:

> **[Getting Started with Rails — Ruby on Rails Guides](https://guides.rubyonrails.org/getting_started.html)**
>
> Getting Started with RailsThis guide covers getting up and running with Ruby on Rails.After reading this guide, you will know: How to install Rails, create a new Rails application, and connect your application to a database. The general layout of a...

to have RoR installed to a mysql database

When I get to step 3.4 Creating the Database I get the error displayed  
above.

Note : I have a password defined in the database.yml file for the  
DEVELOPMENT area, that reads as :

development:  
adapter : mysql  
enconding : utf8  
reconnect : false  
database : blog\_development  
pool : 5  
username : root  
password : \<mypassword, same when installed mysql\>  
socket : /var/run/mysqld/mysqld.sock

The only thing I changed in this file was the password.

Any clue on why I get this error?

Thanks in advance,  
Nelson

---

<div class="post-metadata">

**Author:** ![Nelson\_AndrSSSS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/e274bd/32.png) [@Nelson\_AndrSSSS](https://www.ruby-forum.com/u/Nelson_AndrSSSS)\
**Post date:** [January 28, 2010, 3:27pm UTC](https://www.ruby-forum.com/t/new-to-ror-error-on-rake-db-create/182465/2 "2010-01-28T15:27:20Z")

</div>

once remove the line socket : /var/run/mysqld/mysqld.sock  
i am not sure but it may works…

On Thu, Jan 28, 2010 at 7:20 PM, Nelson AndrÃ©  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)wrote:

> to have RoR installed to a mysql database  
> reconnect : false  
> Thanks in advance,  
> “Ruby on Rails: Talk” group.  
> To post to this group, send email to removed\_email\_address@domain.invalid.  
> To unsubscribe from this group, send email to  
> removed\_email\_address@domain.invalid[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> .  
> For more options, visit this group at  
> [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en).

–  
Regards:  
Rajeev sharma  
+919813270707

---

<div class="post-metadata">

**Author:** ![Nelson\_AndrSSSS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/e274bd/32.png) [@Nelson\_AndrSSSS](https://www.ruby-forum.com/u/Nelson_AndrSSSS)\
**Post date:** [January 30, 2010, 10:20pm UTC](https://www.ruby-forum.com/t/new-to-ror-error-on-rake-db-create/182465/3 "2010-01-30T22:20:08Z")

</div>

On Jan 28, 8:50 am, Nelson André [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 

I can recreate this in irb:

require ‘YAML’;  
YAML.load(‘foo: bar’) #=\> { ‘foo’ =\> ‘bar’ }

YAML.load(" foo: bar\n\tbaz: woot")

# =\> ArgumentError: syntax error on line 1, col 0: ` baz: woot’

It’s caused by mixing tabs and spaces in a YAML file, which is  
forbidden.

–Matt J.
