yml file structure

rubyonrails-talk
1

Hi All,

rake db:create is not working. It is giving an error like

** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment rake aborted! syntax error on line 17, col -1: `'

My yml file reads like:

development: adapter:mysql encoding:utf8 reconnect:false database:news_development pool:5 username:root password: host:localhost

There is space at the beginning and end of every line. Password is blank. I have created a db news_development in mysql.

Rails: 2.3.5 Ruby: 1.8.7 OS: WinXp

2

Hi All,

rake db:create is not working. It is giving an error like

** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment rake aborted! syntax error on line 17, col -1: `'

My yml file reads like:

development: adapter:mysql encoding:utf8 reconnect:false database:news_development pool:5 username:root password: host:localhost

Hi,

like Rajeev said in the other mails. You need spaces between the key and the value. Try the following:

development:   adapter: mysql   encoding: utf8   reconnect: false   database: news_development   pool: 5   username: root   password:   host: localhost

Max.

3

You need a space after the : on each line as someone else tried to tell you in your previous thread.

Colin

4

No luck :frowning: I have attached my yml. There is space at the beginning of each line (from encoding onwards). There is space between : and the corresponding value. There is one space at the end after password:

From the early morning this rake has raked my brains out...Pls help..And many many thanks for the suggestions..

Premanshu

5

Hi,

you can't attach files on this mailing list. You need two whitespaces at the beginning of the line. See the part i posted in the last mail. Hope that helps.

Max.

P.S. Why don't you just take the generated database.yml and replace the values you need without touching the rest of it?

6

Tons of thanks to you Max and the other Railers: Rajeev and Colin.

Its working with two spaces in front of every line. And I added the password **** as well. And a final enter after entering the password.

I'm so happy.. again my thanks....

Premanshu