Rails 1.1 and webrick/mysql problems


#1

i just upgraded to rails 1.1 yesterday and since then i could´nt make it
work with mysql, for example i have my database “todo” and one table
“todos”, i create the app and generate the model but when i try to
generate the scaffold with “ruby script/generate scaffold Todo Todo” i
get this error " error Before updating scaffolding from new DB schema,
try creating a table for your model (Todo)", i have the values in the
database.yml correct, and also when i try to boot webrick i get this:

=> Booting WEBrick…
C:/ruby/lib/ruby/1.8/yaml.rb:133:in load': syntax error on line 27, col 2: socket: /path/to/your/mysql.sock’ (ArgumentError)
from C:/ruby/lib/ruby/1.8/yaml.rb:133:in load' from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/initializer.rb:459:indatabase_configuration’
from
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/initializer.rb:181:in
initialize_database' from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/initializer.rb:84:inprocess’
from
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/initializer.rb:42:in
run' from ./script/../config/../config/environment.rb:10 from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
from
C:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.0/lib/active_support/dependencies.rb:136:in
require' from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/commands/servers/webrick.rb:52 from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
from
C:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.0/lib/active_support/dependencies.rb:136:in
require' from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/commands/server.rb:30 from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
from
C:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.0/lib/active_support/dependencies.rb:136:in
`require’
from ./script/server:3
from -e:3

and never starts, by the way, im on windows, hope someone can help with
this cause im going crazy with all this :frowning:


#2

On Wed, 2006-04-05 at 23:27 +0200, Ana B. wrote:

2: socket: /path/to/your/mysql.sock' (ArgumentError) from from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
from ./script/server:3
from -e:3

and never starts, by the way, im on windows, hope someone can help with
this cause im going crazy with all this :frowning:


did you do ‘rake rails:update’ after you updated? Have you always used
sockets to connect to mysql?

Craig


#3

Craig W. wrote:

On Wed, 2006-04-05 at 23:27 +0200, Ana B. wrote:

2: socket: /path/to/your/mysql.sock' (ArgumentError) from from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
from ./script/server:3
from -e:3

and never starts, by the way, im on windows, hope someone can help with
this cause im going crazy with all this :frowning:


did you do ‘rake rails:update’ after you updated? Have you always used
sockets to connect to mysql?

Craig

Yes i already done “rake rails:update” and still get the same errors my
database.ymal fiel have an info like this:

development:
adapter: mysql
database: todo_development
username: rasta
password: rasta
host: localhost

I had rails 1.0 yesterday and all was fine, just upgraded to 1.1 and all
screwed up, im using ruby1.8.4/rails1.1/mysql4.x/windows, i tried
reinstalling all and restarting but nothing, hope you can help me, im
already have one day hours dedicated to find a solution to this problem
but i cant find it, in google, irc, wiki.rubyonrails.com, and some
places more.

Convention over configuration… im starting to have doubts about that
:frowning:


#4

Check your database.yml file. Make sure you go through a delete all the
whitespaces (tab characters) and replace it with two spaces only.

I had this problem because I was testing with a blank password on one of
my databases. Having a space for a blank password was giving the parser
problems.