# Development Environment Problem

**URL:** <https://www.ruby-forum.com/t/development-environment-problem/117147>\
**Category:** Rails\
**Created:** [October 13, 2007, 10:41pm UTC](https://www.ruby-forum.com/t/development-environment-problem/117147 "2007-10-13T22:41:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MrLipid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@MrLipid](https://www.ruby-forum.com/u/MrLipid)\
**Post date:** [October 13, 2007, 10:41pm UTC](https://www.ruby-forum.com/t/development-environment-problem/117147/1 "2007-10-13T22:41:13Z")

</div>

Here’s the message I get when I try to start a development  
environment?:

Loading development environment.  
D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in ‘load’:ArgumentError:  
syntax error on line 18, col 2: ’ host: localhost’

> >

Recently had some MySQL problems and now I get a 500 error on  
[http://localhost:3000/](http://localhost:3000/)

No idea what blew up. Had been very stable until yesterday.

Any ideas would be appreciated.

---

<div class="post-metadata">

**Author:** ![MrLipid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@MrLipid](https://www.ruby-forum.com/u/MrLipid)\
**Post date:** [October 13, 2007, 10:48pm UTC](https://www.ruby-forum.com/t/development-environment-problem/117147/2 "2007-10-13T22:48:50Z")

</div>

On Sat, 13 Oct 2007 13:40:22 -0700, MrLipid wrote:

> Loading development environment.  
> D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in ‘load’:ArgumentError:  
> syntax error on line 18, col 2: ’ host: localhost’
> 
> > >

What’s on the line before it? If that doesn’t help, post the whole  
database.yml file (mask out any passwords of course).

–  
Jay L. |  
Boston, MA | My character doesn’t like it when they  
Faster: jay at jay dot fm | cry or shout or hit.  
[http://www.jay.fm](http://www.jay.fm) | - Kristoffer

---

<div class="post-metadata">

**Author:** ![MrLipid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@MrLipid](https://www.ruby-forum.com/u/MrLipid)\
**Post date:** [October 13, 2007, 10:53pm UTC](https://www.ruby-forum.com/t/development-environment-problem/117147/3 "2007-10-13T22:53:30Z")

</div>

On Oct 13, 3:48 pm, Jay L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Boston, MA | My character doesn’t like it when they  
> Faster: jay at jay dot fm | cry or shout or hit.[http://www.jay.fm](http://www.jay.fm) | - Kristoffer

# 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: VCBeta2\_development  
username: root  
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: VCBeta2\_test  
username: root  
password:  
host: localhost

production:  
adapter: mysql  
database: VCBeta2\_production  
username: root  
password:  
host: localhost

---

<div class="post-metadata">

**Author:** ![MrLipid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@MrLipid](https://www.ruby-forum.com/u/MrLipid)\
**Post date:** [October 14, 2007, 2:54am UTC](https://www.ruby-forum.com/t/development-environment-problem/117147/4 "2007-10-14T02:54:17Z")

</div>

You solved it! Genius!

It was a missing white space.

Things seem fine again.

Thanks!

---

<div class="post-metadata">

**Author:** ![MrLipid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@MrLipid](https://www.ruby-forum.com/u/MrLipid)\
**Post date:** [October 14, 2007, 1:30am UTC](https://www.ruby-forum.com/t/development-environment-problem/117147/5 "2007-10-14T01:30:43Z")

</div>

On Sat, 13 Oct 2007 13:52:59 -0700, MrLipid wrote:

> On Oct 13, 3:48 pm, Jay L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > On Sat, 13 Oct 2007 13:40:22 -0700, MrLipid wrote:
> > 
> > > Loading development environment.  
> > > D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in ‘load’:ArgumentError:  
> > > syntax error on line 18, col 2: ’ host: localhost’
> > 
> > What’s on the line before it? If that doesn’t help, post the whole  
> > database.yml file (mask out any passwords of course).

Is the “password:” line really blank, or did you just remove the  
password?  
It looks like that’s actually the line that’s giving it trouble.

Make sure there are no tabs where there should be spaces, and that  
there’s  
no whitespace at the end of the line; I don’t know if either is  
_supposed_  
to matter to YAML, but Ruby and tabs can do weird things on Windows.

Try switching the order of the password: and username: lines, and see if  
the error now lists username instead of host. And (assuming the  
passwords  
are the same or really blank) try swapping two of the password: lines,  
or  
retyping the line from scratch. Look at the file in a hex editor and  
see  
if there’s anything weird with line endings (CRLF vs LF).

–  
Jay L. |  
Boston, MA | My character doesn’t like it when they  
Faster: jay at jay dot fm | cry or shout or hit.  
[http://www.jay.fm](http://www.jay.fm) | - Kristoffer