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

Am 12.10.2010 10:34, schrieb Premanshu M.:

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.

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


Maksim G.
webit! Gesellschaft fr neue Medien mbH
Schnorrstrae 76 | 01069 Dresden
Telefon +49 351 46766-0 | Telefax +49 351 46766-66
[email protected] | www.webit.de

Amtsgericht Dresden | HRB 15422
USt-ID DE 193477690
Geschftsfhrer Sven Haubold

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?

Am 12.10.2010 11:35, schrieb Premanshu M.:

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

On 12 October 2010 09:34, Premanshu M. [email protected] wrote:

My yml file reads like:

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

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

Colin