# (no subject)

**URL:** <https://www.ruby-forum.com/t/no-subject/87147>\
**Category:** Rails\
**Created:** [February 28, 2007, 3:22pm UTC](https://www.ruby-forum.com/t/no-subject/87147 "2007-02-28T15:22:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jarod\_R](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/3bc359/32.png) [@Jarod\_R](https://www.ruby-forum.com/u/Jarod_R)\
**Post date:** [February 28, 2007, 3:22pm UTC](https://www.ruby-forum.com/t/no-subject/87147/1 "2007-02-28T15:22:06Z")

</div>

I have run into a bit of an odd problem. I have searched the web with no  
definitive answer. When running rake migrate I get

syntax error on line 18, col 2: ` host: localhost’.

Heres the yml:

# MySQL (default setup). Versions 4.1 and 5.0 are recommended.

# 

# Install the MySQL driver:

# gem install mysql

# On MacOS X:

# gem install mysql – --include=/usr/local/lib

# On Windows:

# gem install mysql

# Choose the win32 build.

# Install MySQL and put its /bin directory on your path.

# 

# And be sure to use new-style password hashing:

# [http://dev.mysql.com/doc/refman/5.0/en/old-client.html](http://dev.mysql.com/doc/refman/5.0/en/old-client.html)

development:

adapter: mysql

database: the\_mighty\_database

username: the\_mighty\_username

password: the\_mighty\_password

host: localhost

# Warning: The database defined as ‘test’ will be erased and

# re-generated from your development database when you run ‘rake’.

# Do not set this db to the same as development or production.

test:

adapter: mysql

database: depot\_test

username: root

password:

host: localhost

production:

adapter: mysql

database: depot\_production

username: root

password:

host: localhost

I have checked the file over to no avail. Everything seems correctly  
structured for YAML. any takers?

Jarod

---

<div class="post-metadata">

**Author:** ![Jarod\_R](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/3bc359/32.png) [@Jarod\_R](https://www.ruby-forum.com/u/Jarod_R)\
**Post date:** [February 28, 2007, 3:31pm UTC](https://www.ruby-forum.com/t/no-subject/87147/2 "2007-02-28T15:31:19Z")

</div>

On 2/28/07, Jarod R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 

_snip_

> I have checked the file over to no avail. Everything seems correctly  
> structured for YAML� any takers?

Make sure you only use spaces. YAML blows up on tabs.

HTH,  
Isak

---

<div class="post-metadata">

**Author:** ![Jarod\_R](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/3bc359/32.png) [@Jarod\_R](https://www.ruby-forum.com/u/Jarod_R)\
**Post date:** [February 28, 2007, 3:40pm UTC](https://www.ruby-forum.com/t/no-subject/87147/3 "2007-02-28T15:40:37Z")

</div>

It’s very likely that the real problem is on line 17 (which I assume  
you edited for content when posting)  
-Rob

Rob B. [http://agileconsultingllc.com](http://agileconsultingllc.com)  
removed\_email\_address@domain.invalid