Development Environment Problem

Rails
1

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/

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

Any ideas would be appreciated.

2

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 | - Kristoffer

3

On Oct 13, 3:48 pm, Jay L. [email protected] 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 | - 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

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

4

You solved it! Genius!

It was a missing white space.

Things seem fine again.

Thanks!

5

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

On Oct 13, 3:48 pm, Jay L. [email protected] 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 | - Kristoffer