error when installing mysql gem and when create user

[Per...@gmail.com]

guys anyone can point me to right direction. here is the log of what i
m doing.


C:\InstantRails\rails_space>dir
Volume in drive C has no label.
Volume Serial Number is 4456-505D

Directory of C:\InstantRails\rails_space

03/23/2008 05:10 PM <DIR> .
03/23/2008 05:10 PM <DIR> ..
03/23/2008 05:10 PM <DIR> app
03/23/2008 05:10 PM <DIR> config
03/23/2008 05:10 PM <DIR> db
03/23/2008 05:10 PM <DIR> doc
03/23/2008 05:10 PM <DIR> lib
03/23/2008 05:10 PM <DIR> log
03/23/2008 05:10 PM <DIR> public
03/23/2008 05:10 PM 307 Rakefile
03/23/2008 05:10 PM 8,819 README
03/23/2008 05:10 PM <DIR> script
03/23/2008 05:10 PM <DIR> test
03/23/2008 05:10 PM <DIR> tmp
03/23/2008 05:10 PM <DIR> vendor
2 File(s) 9,126 bytes
13 Dir(s) 19,994,959,872 bytes free

C:\InstantRails\rails_space>ruby script/generate controller site index
about hel
p
exists app/controllers/
exists app/helpers/
create app/views/site
exists test/functional/
create app/controllers/site_controller.rb
create test/functional/site_controller_test.rb
create app/helpers/site_helper.rb
create app/views/site/index.html.erb
create app/views/site/about.html.erb
create app/views/site/help.html.erb

C:\InstantRails\rails_space>rm public/index.html
'rm' is not recognized as an internal or external command,
operable program or batch file.

C:\InstantRails\rails_space>dir
Volume in drive C has no label.
Volume Serial Number is 4456-505D

Directory of C:\InstantRails\rails_space

03/23/2008 05:10 PM <DIR> .
03/23/2008 05:10 PM <DIR> ..
03/23/2008 05:10 PM <DIR> app
03/23/2008 05:10 PM <DIR> config
03/23/2008 05:13 PM <DIR> db
03/23/2008 05:10 PM <DIR> doc
03/23/2008 05:10 PM <DIR> lib
03/23/2008 05:10 PM <DIR> log
03/23/2008 05:10 PM <DIR> public
03/23/2008 05:10 PM 307 Rakefile
03/23/2008 05:10 PM 8,819 README
03/23/2008 05:10 PM <DIR> script
03/23/2008 05:10 PM <DIR> test
03/23/2008 05:10 PM <DIR> tmp
03/23/2008 05:10 PM <DIR> vendor
2 File(s) 9,126 bytes
13 Dir(s) 19,994,488,832 bytes free

C:\InstantRails\rails_space>cd public

C:\InstantRails\rails_space\public>dir
Volume in drive C has no label.
Volume Serial Number is 4456-505D

Directory of C:\InstantRails\rails_space\public

03/23/2008 05:10 PM <DIR> .
03/23/2008 05:10 PM <DIR> ..
03/23/2008 05:10 PM 1,251 .htaccess
03/23/2008 05:10 PM 947 404.html
03/23/2008 05:10 PM 930 422.html
03/23/2008 05:10 PM 947 500.html
03/23/2008 05:10 PM 489 dispatch.cgi
03/23/2008 05:10 PM 871 dispatch.fcgi
03/23/2008 05:10 PM 489 dispatch.rb
03/23/2008 05:10 PM 0 favicon.ico
03/23/2008 05:10 PM <DIR> images
03/23/2008 05:10 PM 7,557 index.html
03/23/2008 05:10 PM <DIR> javascripts
03/23/2008 05:10 PM 204 robots.txt
03/23/2008 05:10 PM <DIR> stylesheets
10 File(s) 13,685 bytes
5 Dir(s) 19,994,488,832 bytes free

C:\InstantRails\rails_space\public>mysqladmin create
rails_space_development --u
ser=root --password=

C:\InstantRails\rails_space\public>gem install mysql
Successfully installed mysql-2.7.3-x86-mswin32
1 gem installed
Installing ri documentation for mysql-2.7.3-x86-mswin32...
Installing RDoc documentation for mysql-2.7.3-x86-mswin32...
ERROR: While generating documentation for mysql-2.7.3-x86-mswin32
... MESSAGE: Unhandled special: Special: type=17, text="<!-- $Id:
README.html,
v 1.20 2006-12-20 05:31:52 tommy Exp $ -->"
... RDOC args: --op C:/InstantRails/ruby/lib/ruby/gems/1.8/doc/
mysql-2.7.3-x86-m
swin32/rdoc --exclude ext --main README --quiet ext README docs/
README.html
(continuing with the rest of the installation)

C:\InstantRails\rails_space\public>mysqladmin create rails_space_test
--user=roo
t --password=

C:\InstantRails\rails_space\public>mysqladmin create
rails_space_production --us
er=root --password=

C:\InstantRails\rails_space\public>ruby script/generate modeul User
ruby: No such file or directory -- script/generate (LoadError)

C:\InstantRails\rails_space\public>ruby script/generate modeul User
ruby: No such file or directory -- script/generate (LoadError)

C:\InstantRails\rails_space\public>cd..

C:\InstantRails\rails_space>ruby script/generate modeul User
C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/
active_record
/connection_adapters/abstract/connection_specification.rb:217:in
`establish_conn
ection': development database is not configured
(ActiveRecord::AdapterNotSpecifi
ed)
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/
activerecord-2.0.2/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
208:in `e
stablish_connection'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:234:in `initialize_database'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:94:in `process'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:49:in `send'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:49:in `run'
from C:/InstantRails/rails_space/config/environment.rb:13
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `gem_original_require'
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `require'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/command
s/generate.rb:1
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `gem_original_require'
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `require'
from script/generate:3

C:\InstantRails\rails_space>ruby script/generate model user
C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/
active_record
/connection_adapters/abstract/connection_specification.rb:217:in
`establish_conn
ection': development database is not configured
(ActiveRecord::AdapterNotSpecifi
ed)
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/
activerecord-2.0.2/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
208:in `e
stablish_connection'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:234:in `initialize_database'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:94:in `process'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:49:in `send'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:49:in `run'
from C:/InstantRails/rails_space/config/environment.rb:13
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `gem_original_require'
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `require'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/command
s/generate.rb:1
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `gem_original_require'
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `require'
from script/generate:3

C:\InstantRails\rails_space>rails -d mysql myapp
create
create app/controllers
create app/helpers
create app/models
create app/views/layouts
create config/environments
create config/initializers
create db
create doc
create lib
create lib/tasks
create log
create public/images
create public/javascripts
create public/stylesheets
create script/performance
create script/process
create test/fixtures
create test/functional
create test/integration
create test/mocks/development
create test/mocks/test
create test/unit
create vendor
create vendor/plugins
create tmp/sessions
create tmp/sockets
create tmp/cache
create tmp/pids
create Rakefile
create README
create app/controllers/application.rb
create app/helpers/application_helper.rb
create test/test_helper.rb
create config/database.yml
create config/routes.rb
create public/.htaccess
create config/initializers/inflections.rb
create config/initializers/mime_types.rb
create config/boot.rb
create config/environment.rb
create config/environments/production.rb
create config/environments/development.rb
create config/environments/test.rb
create script/about
create script/console
create script/destroy
create script/generate
create script/performance/benchmarker
create script/performance/profiler
create script/performance/request
create script/process/reaper
create script/process/spawner
create script/process/inspector
create script/runner
create script/server
create script/plugin
create public/dispatch.rb
create public/dispatch.cgi
create public/dispatch.fcgi
create public/404.html
create public/422.html
create public/500.html
create public/index.html
create public/favicon.ico
create public/robots.txt
create public/images/rails.png
create public/javascripts/prototype.js
create public/javascripts/effects.js
create public/javascripts/dragdrop.js
create public/javascripts/controls.js
create public/javascripts/application.js
create doc/README_FOR_APP
create log/server.log
create log/production.log
create log/development.log
create log/test.log

C:\InstantRails\rails_space>ruby script/generate model user
C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/
active_record
/connection_adapters/abstract/connection_specification.rb:217:in
`establish_conn
ection': development database is not configured
(ActiveRecord::AdapterNotSpecifi
ed)
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/
activerecord-2.0.2/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
208:in `e
stablish_connection'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:234:in `initialize_database'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:94:in `process'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:49:in `send'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/initial
izer.rb:49:in `run'
from C:/InstantRails/rails_space/config/environment.rb:13
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `gem_original_require'
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `require'
from C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/
lib/command
s/generate.rb:1
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `gem_original_require'
from C:/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/
custom_require
.rb:27:in `require'
from script/generate:3

C:\InstantRails\rails_space>gem install mysql
Successfully installed mysql-2.7.3-x86-mswin32
1 gem installed
Installing ri documentation for mysql-2.7.3-x86-mswin32...
Installing RDoc documentation for mysql-2.7.3-x86-mswin32...
ERROR: While generating documentation for mysql-2.7.3-x86-mswin32
... MESSAGE: Unhandled special: Special: type=17, text="<!-- $Id:
README.html,
v 1.20 2006-12-20 05:31:52 tommy Exp $ -->"
... RDOC args: --op C:/InstantRails/ruby/lib/ruby/gems/1.8/doc/
mysql-2.7.3-x86-m
swin32/rdoc --exclude ext --main README --quiet ext README docs/
README.html
(continuing with the rest of the installation)

C:\InstantRails\rails_space>

--------------------------------------------------------------------------------------------------------------------------------------------------------

* i already tell rails to read from rails -d mysql myapp
* create 3 database for production site test and deploy
* and here is my database.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:
# There is no gem for Windows. Install mysql.so from RubyForApache.
# http://rubyforge.org/projects/rubyforapache
#
# 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: rails_space_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: rails_space_test
username: root
password:
host: localhost
production:
adapter: mysql
database: rails_space_production
username: root
password:
host: localhost

[Kamal Fariz]

Can you check if your indentation in the database.yml file is right?
Better still, attach the copy of the database.yml to your email.

The mysql gem installation went fine from what I can see, only minor
warnings when it generates the documentation.

Regards,
Kamal

[Per...@gmail.com]

* i already tell rails to read from rails -d mysql myapp

* create 3 database for production dev , test and production

[Kamal Fariz]

Attached would be nicer. I lose the formatting information when
reading in my email client.

Regards,
Kamal

[Per...@gmail.com]

haha ok i will attach the file tonight because currently i at office.

rgds
faizan

On Mar 24, 9:16 am, Kamal Fariz <kamal.fa...@gmail.com> wrote:
> Attached would be nicer. I lose the formatting information when
> reading in my email client.
>

> On Mar 24, 2008, at 9:12 AM, Perw...@gmail.com wrote:
>
>
>
>
>
> > * i already tell rails to read from rails -d mysql myapp
> > * create 3 database for production dev , test and production
> > * and here is my database.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:
> > # There is no gem for Windows. Install mysql.so from RubyForApache.

> > #http://rubyforge.org/projects/rubyforapache

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

> > #http://dev.mysql.com/doc/refman/5.0/en/old-client.html

[Per...@gmail.com]

bro kamal kindly please check your email, i already send that file to
you :) thank you.