yml file structure

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

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.

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

Colin

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

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?

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