Can't connect to MySQL server on 'localhost' (10061)
2,770 views
Skip to first unread message
Sandeep Singla
Mar 13, 2012, 7:16:19 AM3/13/12
to rubyin...@googlegroups.com
Hi,
I have installed ruby 1.9.2-p290 on window vista basic. and ruby dev kit "DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe"
Following is the Gem list on my machine:
actionmailer (3.2.2)
actionpack (3.2.2)
activemodel (3.2.2)
activerecord (3.2.2)
activeresource (3.2.2)
activesupport (3.2.2)
arel (3.0.2)
builder (3.0.0)
bundler (1.1.0)
coffee-rails (3.2.2)
coffee-script (2.2.0)
coffee-script-source (1.2.0)
dep_walker (1.0.2)
erubis (2.7.0)
execjs (1.3.0)
hike (1.2.1)
i18n (0.6.0)
journey (1.0.3)
jquery-rails (2.0.1)
json (1.6.5)
mail (2.4.3)
mime-types (1.17.2)
minitest (1.6.0)
multi_json (1.1.0)
mysql2 (0.3.11 x86-mingw32)
polyglot (0.3.3)
rack (1.4.1)
rack-cache (1.2)
rack-ssl (1.3.2)
rack-test (0.6.1)
rails (3.2.2)
railties (3.2.2)
rake (0.9.2.2, 0.8.7)
rdoc (3.12, 2.5.8)
rubygems-update (1.8.18)
sass (3.1.15)
sass-rails (3.2.4)
sprockets (2.1.2)
thor (0.14.6)
tilt (1.3.3)
treetop (1.4.10)
tzinfo (0.3.32)
uglifier (1.2.3)
=====================
Now, I am able to create any new project using rails new <proj_name> -d=mysql
but when I am starting server using command "rails start", I am getting the error:
[Can't connect to MySQL server on 'localhost' (10061)]
=====================
Full Trace:
mysql2-0.3.11-x86 (mingw32) lib/mysql2/client.rb:44:in `connect'
mysql2-0.3.11-x86 (mingw32) lib/mysql2/client.rb:44:in `initialize'
activerecord (3.2.2) lib/active_record/connection_adapters/mysql2_adapter.rb:16:in `new'
activerecord (3.2.2) lib/active_record/connection_adapters/mysql2_adapter.rb:16:in `mysql2_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:277:in `new_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:287:in `checkout_new_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:235:in `block (2 levels) in checkout'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:230:in `loop'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:230:in `block in checkout' C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:229:in `checkout'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:95:in `connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:374:in `retrieve_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_specification.rb:168:in `retrieve_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_specification.rb:142:in `connection'
activerecord (3.2.2) lib/active_record/query_cache.rb:67:in `rescue in call'
activerecord (3.2.2) lib/active_record/query_cache.rb:61:in `call'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:443:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
activesupport (3.2.2) lib/active_support/callbacks.rb:405:in `_run__1051109948__call__947130322__callbacks'
activesupport (3.2.2) lib/active_support/callbacks.rb:405:in `__run_callback'
activesupport (3.2.2) lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
activesupport (3.2.2) lib/active_support/callbacks.rb:81:in `run_callbacks'
actionpack (3.2.2) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/reloader.rb:65:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
railties (3.2.2) lib/rails/rack/logger.rb:26:in `call_app'
railties (3.2.2) lib/rails/rack/logger.rb:16:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/request_id.rb:22:in `call'
rack (1.4.1) lib/rack/methodoverride.rb:21:in `call'
rack (1.4.1) lib/rack/runtime.rb:17:in `call'
activesupport (3.2.2) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
rack (1.4.1) lib/rack/lock.rb:15:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/static.rb:61:in `call'
railties (3.2.2) lib/rails/engine.rb:479:in `call'
railties (3.2.2) lib/rails/application.rb:220:in `call'
rack (1.4.1) lib/rack/content_length.rb:14:in `call'
railties (3.2.2) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.4.1) lib/rack/handler/webrick.rb:59:in `service'
C:/Ruby192/lib/ruby/1.9.1/webrick/httpserver.rb:111:in `service'
C:/Ruby192/lib/ruby/1.9.1/webrick/httpserver.rb:70:in `run'
C:/Ruby192/lib/ruby/1.9.1/webrick/server.rb:183:in `block in start_thread'
I have installed ruby 1.9.2-p290 on window vista basic. and ruby dev kit "DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe"
Following is the Gem list on my machine:
actionmailer (3.2.2)
actionpack (3.2.2)
activemodel (3.2.2)
activerecord (3.2.2)
activeresource (3.2.2)
activesupport (3.2.2)
arel (3.0.2)
builder (3.0.0)
bundler (1.1.0)
coffee-rails (3.2.2)
coffee-script (2.2.0)
coffee-script-source (1.2.0)
dep_walker (1.0.2)
erubis (2.7.0)
execjs (1.3.0)
hike (1.2.1)
i18n (0.6.0)
journey (1.0.3)
jquery-rails (2.0.1)
json (1.6.5)
mail (2.4.3)
mime-types (1.17.2)
minitest (1.6.0)
multi_json (1.1.0)
mysql2 (0.3.11 x86-mingw32)
polyglot (0.3.3)
rack (1.4.1)
rack-cache (1.2)
rack-ssl (1.3.2)
rack-test (0.6.1)
rails (3.2.2)
railties (3.2.2)
rake (0.9.2.2, 0.8.7)
rdoc (3.12, 2.5.8)
rubygems-update (1.8.18)
sass (3.1.15)
sass-rails (3.2.4)
sprockets (2.1.2)
thor (0.14.6)
tilt (1.3.3)
treetop (1.4.10)
tzinfo (0.3.32)
uglifier (1.2.3)
=====================
Now, I am able to create any new project using rails new <proj_name> -d=mysql
but when I am starting server using command "rails start", I am getting the error:
[Can't connect to MySQL server on 'localhost' (10061)]
=====================
Full Trace:
mysql2-0.3.11-x86 (mingw32) lib/mysql2/client.rb:44:in `connect'
mysql2-0.3.11-x86 (mingw32) lib/mysql2/client.rb:44:in `initialize'
activerecord (3.2.2) lib/active_record/connection_adapters/mysql2_adapter.rb:16:in `new'
activerecord (3.2.2) lib/active_record/connection_adapters/mysql2_adapter.rb:16:in `mysql2_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:277:in `new_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:287:in `checkout_new_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:235:in `block (2 levels) in checkout'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:230:in `loop'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:230:in `block in checkout' C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:229:in `checkout'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:95:in `connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:374:in `retrieve_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_specification.rb:168:in `retrieve_connection'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_specification.rb:142:in `connection'
activerecord (3.2.2) lib/active_record/query_cache.rb:67:in `rescue in call'
activerecord (3.2.2) lib/active_record/query_cache.rb:61:in `call'
activerecord (3.2.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:443:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
activesupport (3.2.2) lib/active_support/callbacks.rb:405:in `_run__1051109948__call__947130322__callbacks'
activesupport (3.2.2) lib/active_support/callbacks.rb:405:in `__run_callback'
activesupport (3.2.2) lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
activesupport (3.2.2) lib/active_support/callbacks.rb:81:in `run_callbacks'
actionpack (3.2.2) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/reloader.rb:65:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
railties (3.2.2) lib/rails/rack/logger.rb:26:in `call_app'
railties (3.2.2) lib/rails/rack/logger.rb:16:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/request_id.rb:22:in `call'
rack (1.4.1) lib/rack/methodoverride.rb:21:in `call'
rack (1.4.1) lib/rack/runtime.rb:17:in `call'
activesupport (3.2.2) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
rack (1.4.1) lib/rack/lock.rb:15:in `call'
actionpack (3.2.2) lib/action_dispatch/middleware/static.rb:61:in `call'
railties (3.2.2) lib/rails/engine.rb:479:in `call'
railties (3.2.2) lib/rails/application.rb:220:in `call'
rack (1.4.1) lib/rack/content_length.rb:14:in `call'
railties (3.2.2) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.4.1) lib/rack/handler/webrick.rb:59:in `service'
C:/Ruby192/lib/ruby/1.9.1/webrick/httpserver.rb:111:in `service'
C:/Ruby192/lib/ruby/1.9.1/webrick/httpserver.rb:70:in `run'
C:/Ruby192/lib/ruby/1.9.1/webrick/server.rb:183:in `block in start_thread'
Boško Ivanišević
Mar 13, 2012, 8:08:12 AM3/13/12
to rubyin...@googlegroups.com
--
You received this message because you are subscribed to the Google Groups "RubyInstaller" group.
To post to this group, send email to rubyin...@googlegroups.com.
To unsubscribe from this group, send email to rubyinstalle...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyinstaller?hl=en.
What are your settings in database.yml? Do you have MySQL installed on same computer and is it up and running? According to this error it looks like your MySQL server isn't started or is not listening on MySQL default port (3306).
--
Regards,
Boško Ivanišević
Sandeep Singla
Mar 13, 2012, 10:32:31 AM3/13/12
to rubyin...@googlegroups.com
Hi
I have mysql installed on the same computer and is running. Even mysql is connecting fine with my php and rails 2 applications. Only I am getting issue[Can't connect to MySQL server on 'localhost' (10061)] with rails3. Following are my database.yml settings
# MySQL. Versions 4.1 and 5.0 are recommended.
#
# Install the MYSQL driver
# gem install mysql2
#
# Ensure the MySQL gem is defined in your Gemfile
# gem 'mysql2'
#
# And be sure to use new-style password hashing:
# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
adapter: mysql2
encoding: utf8
reconnect: false
database: test_app_development
pool: 5
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: mysql2
encoding: utf8
reconnect: false
database: test_app_test
pool: 5
username: root
password:
host: localhost
production:
adapter: mysql2
encoding: utf8
reconnect: false
database: test_app_production
pool: 5
username: root
password:
host: localhost
I have mysql installed on the same computer and is running. Even mysql is connecting fine with my php and rails 2 applications. Only I am getting issue[Can't connect to MySQL server on 'localhost' (10061)] with rails3. Following are my database.yml settings
# MySQL. Versions 4.1 and 5.0 are recommended.
#
# Install the MYSQL driver
# gem install mysql2
#
# Ensure the MySQL gem is defined in your Gemfile
# gem 'mysql2'
#
# And be sure to use new-style password hashing:
# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
adapter: mysql2
encoding: utf8
reconnect: false
database: test_app_development
pool: 5
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: mysql2
encoding: utf8
reconnect: false
database: test_app_test
pool: 5
username: root
password:
host: localhost
production:
adapter: mysql2
encoding: utf8
reconnect: false
database: test_app_production
pool: 5
username: root
password:
host: localhost
2012/3/13 Boško Ivanišević <bosko.iv...@gmail.com>
Boško Ivanišević
Mar 13, 2012, 10:49:28 AM3/13/12
to rubyin...@googlegroups.com
Please do not top-post. Can you send output of
netstat -na
You can put it in a gist for easier reading. Do you really have empty password for root account on your MySQL installation?
Sandeep Singla
Mar 13, 2012, 11:18:55 AM3/13/12
to rubyin...@googlegroups.com
Hi
gist for easier reading?
yes I have empty password for root account on MySQL
C:\>netstat -na
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:22 0.0.0.0:0 LISTENING
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3000 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
TCP 0.0.0.0:5357 0.0.0.0:0 LISTENING
TCP 0.0.0.0:29344 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49152 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49153 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49154 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49155 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49156 0.0.0.0:0 LISTENING
TCP 127.0.0.1:554 0.0.0.0:0 LISTENING
TCP 127.0.0.1:3306 127.0.0.1:49412 ESTABLISHED
TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8000 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8001 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8009 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8975 0.0.0.0:0 LISTENING
TCP 127.0.0.1:49157 127.0.0.1:49158 ESTABLISHED
TCP 127.0.0.1:49158 127.0.0.1:49157 ESTABLISHED
TCP 127.0.0.1:49171 127.0.0.1:49172 ESTABLISHED
TCP 127.0.0.1:49172 127.0.0.1:49171 ESTABLISHED
TCP 127.0.0.1:49412 127.0.0.1:3306 ESTABLISHED
TCP 192.168.1.40:139 0.0.0.0:0 LISTENING
TCP 192.168.1.40:29344 74.133.198.76:41258 ESTABLISHED
TCP 192.168.1.40:49173 213.199.179.146:40045 ESTABLISHED
TCP 192.168.1.40:49175 213.146.189.206:12350 ESTABLISHED
TCP 192.168.1.40:49586 74.125.236.9:80 CLOSE_WAIT
TCP 192.168.1.40:49721 74.125.236.22:443 ESTABLISHED
TCP 192.168.1.40:49725 74.125.236.22:443 ESTABLISHED
TCP 192.168.1.40:49726 74.125.236.16:443 TIME_WAIT
TCP 192.168.1.40:49728 113.21.74.40:29681 ESTABLISHED
TCP 192.168.1.40:49729 14.98.248.203:8188 ESTABLISHED
TCP 192.168.1.40:49732 74.125.236.15:80 TIME_WAIT
TCP 192.168.1.40:49733 74.125.236.31:80 TIME_WAIT
TCP 192.168.1.40:49734 74.125.236.31:80 TIME_WAIT
TCP 192.168.1.40:49754 123.238.137.238:20791 ESTABLISHED
TCP 192.168.1.40:49755 202.134.153.97:34010 ESTABLISHED
TCP [::]:135 [::]:0 LISTENING
TCP [::]:445 [::]:0 LISTENING
TCP [::]:5357 [::]:0 LISTENING
TCP [::]:49152 [::]:0 LISTENING
TCP [::]:49153 [::]:0 LISTENING
TCP [::]:49154 [::]:0 LISTENING
TCP [::]:49155 [::]:0 LISTENING
TCP [::]:49156 [::]:0 LISTENING
UDP 0.0.0.0:123 *:*
UDP 0.0.0.0:443 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:5355 *:*
UDP 0.0.0.0:29344 *:*
UDP 0.0.0.0:49152 *:*
UDP 0.0.0.0:49155 *:*
UDP 0.0.0.0:56789 *:*
UDP 127.0.0.1:1900 *:*
UDP 127.0.0.1:8008 *:*
UDP 127.0.0.1:49154 *:*
UDP 127.0.0.1:49163 *:*
UDP 127.0.0.1:49164 *:*
UDP 127.0.0.1:49165 *:*
UDP 127.0.0.1:49942 *:*
UDP 127.0.0.1:57271 *:*
UDP 127.0.0.1:62794 *:*
UDP 192.168.1.40:137 *:*
UDP 192.168.1.40:138 *:*
UDP 192.168.1.40:1900 *:*
UDP 192.168.1.40:5353 *:*
UDP 192.168.1.40:57270 *:*
UDP [::]:123 *:*
UDP [::]:500 *:*
UDP [::]:5355 *:*
UDP [::]:49153 *:*
UDP [::1]:1900 *:*
UDP [::1]:57268 *:*
UDP [fe80::2c:32a2:35f3:81a1%14]:1900 *:*
UDP [fe80::2c:32a2:35f3:81a1%14]:57265 *:*
UDP [fe80::1081:22c0:3f57:fed7%10]:1900 *:*
UDP [fe80::1081:22c0:3f57:fed7%10]:57269 *:*
UDP [fe80::d915:92bd:f479:f779%11]:1900 *:*
UDP [fe80::d915:92bd:f479:f779%11]:57267 *:*
UDP [fe80::f5f5:55:4e21:a38d%12]:1900 *:*
UDP [fe80::f5f5:55:4e21:a38d%12]:57266 *:*
gist for easier reading?
yes I have empty password for root account on MySQL
C:\>netstat -na
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:22 0.0.0.0:0 LISTENING
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3000 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
TCP 0.0.0.0:5357 0.0.0.0:0 LISTENING
TCP 0.0.0.0:29344 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49152 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49153 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49154 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49155 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49156 0.0.0.0:0 LISTENING
TCP 127.0.0.1:554 0.0.0.0:0 LISTENING
TCP 127.0.0.1:3306 127.0.0.1:49412 ESTABLISHED
TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8000 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8001 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8009 0.0.0.0:0 LISTENING
TCP 127.0.0.1:8975 0.0.0.0:0 LISTENING
TCP 127.0.0.1:49157 127.0.0.1:49158 ESTABLISHED
TCP 127.0.0.1:49158 127.0.0.1:49157 ESTABLISHED
TCP 127.0.0.1:49171 127.0.0.1:49172 ESTABLISHED
TCP 127.0.0.1:49172 127.0.0.1:49171 ESTABLISHED
TCP 127.0.0.1:49412 127.0.0.1:3306 ESTABLISHED
TCP 192.168.1.40:139 0.0.0.0:0 LISTENING
TCP 192.168.1.40:29344 74.133.198.76:41258 ESTABLISHED
TCP 192.168.1.40:49173 213.199.179.146:40045 ESTABLISHED
TCP 192.168.1.40:49175 213.146.189.206:12350 ESTABLISHED
TCP 192.168.1.40:49586 74.125.236.9:80 CLOSE_WAIT
TCP 192.168.1.40:49721 74.125.236.22:443 ESTABLISHED
TCP 192.168.1.40:49725 74.125.236.22:443 ESTABLISHED
TCP 192.168.1.40:49726 74.125.236.16:443 TIME_WAIT
TCP 192.168.1.40:49728 113.21.74.40:29681 ESTABLISHED
TCP 192.168.1.40:49729 14.98.248.203:8188 ESTABLISHED
TCP 192.168.1.40:49732 74.125.236.15:80 TIME_WAIT
TCP 192.168.1.40:49733 74.125.236.31:80 TIME_WAIT
TCP 192.168.1.40:49734 74.125.236.31:80 TIME_WAIT
TCP 192.168.1.40:49754 123.238.137.238:20791 ESTABLISHED
TCP 192.168.1.40:49755 202.134.153.97:34010 ESTABLISHED
TCP [::]:135 [::]:0 LISTENING
TCP [::]:445 [::]:0 LISTENING
TCP [::]:5357 [::]:0 LISTENING
TCP [::]:49152 [::]:0 LISTENING
TCP [::]:49153 [::]:0 LISTENING
TCP [::]:49154 [::]:0 LISTENING
TCP [::]:49155 [::]:0 LISTENING
TCP [::]:49156 [::]:0 LISTENING
UDP 0.0.0.0:123 *:*
UDP 0.0.0.0:443 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:5355 *:*
UDP 0.0.0.0:29344 *:*
UDP 0.0.0.0:49152 *:*
UDP 0.0.0.0:49155 *:*
UDP 0.0.0.0:56789 *:*
UDP 127.0.0.1:1900 *:*
UDP 127.0.0.1:8008 *:*
UDP 127.0.0.1:49154 *:*
UDP 127.0.0.1:49163 *:*
UDP 127.0.0.1:49164 *:*
UDP 127.0.0.1:49165 *:*
UDP 127.0.0.1:49942 *:*
UDP 127.0.0.1:57271 *:*
UDP 127.0.0.1:62794 *:*
UDP 192.168.1.40:137 *:*
UDP 192.168.1.40:138 *:*
UDP 192.168.1.40:1900 *:*
UDP 192.168.1.40:5353 *:*
UDP 192.168.1.40:57270 *:*
UDP [::]:123 *:*
UDP [::]:500 *:*
UDP [::]:5355 *:*
UDP [::]:49153 *:*
UDP [::1]:1900 *:*
UDP [::1]:57268 *:*
UDP [fe80::2c:32a2:35f3:81a1%14]:1900 *:*
UDP [fe80::2c:32a2:35f3:81a1%14]:57265 *:*
UDP [fe80::1081:22c0:3f57:fed7%10]:1900 *:*
UDP [fe80::1081:22c0:3f57:fed7%10]:57269 *:*
UDP [fe80::d915:92bd:f479:f779%11]:1900 *:*
UDP [fe80::d915:92bd:f479:f779%11]:57267 *:*
UDP [fe80::f5f5:55:4e21:a38d%12]:1900 *:*
UDP [fe80::f5f5:55:4e21:a38d%12]:57266 *:*
Boško Ivanišević
Mar 13, 2012, 3:34:24 PM3/13/12
to rubyin...@googlegroups.com
On Tue, Mar 13, 2012 at 4:18 PM, Sandeep Singla <sing...@gmail.com> wrote:
Hi
gist for easier reading?
Sandeep Singla
Mar 14, 2012, 6:20:57 AM3/14/12
to rubyin...@googlegroups.com
While connecting with rails 2 I was using gem mysql. I have tried to find the version of libmysql.dll but I am not able to get it.
I got this when running dep walker
C:\xampp\htdocs\ruby_projects\test_app>dep_walker -c mysql2 -t
Checking mysql2-0.3.11-x86-mingw32
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.8/m
ysql2.so
libmysql.dll -> Found at C:\Ruby192\bin
kernel32.dll -> Found at C:\Windows\system32
msvcrt.dll -> Found at C:\Windows\system32
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.9/m
ysql2.so
msvcrt-ruby191.dll -> Found at C:\Ruby192\bin
libmysql.dll -> Found at C:\Ruby192\bin
kernel32.dll -> Found at C:\Windows\system32
msvcrt.dll -> Found at C:\Windows\system32
========================================
All dependencies found
I tried connecting with sqlite3
I have followed the instructions for installing sqlite3 from this site
Install SQLite3 on Windows
http://mislav.uniqpath.com/rails/install-sqlite3/
I have downloaded and copied
sqlite3.def
sqlite3.dll
sqlite3.exe
these in C:\Windows\System32
then I run gem install sqlite3
but when I am doing rake db:create
I am getting error
C:\xampp\htdocs\ruby_projects\test_app>rake db:create
Please install the sqlite3 adapter: `gem install activerecord-sqlite3-adapter` (
sqlite3 is not part of the bundle. Add it to Gemfile.)
C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/rubygems_integrati
on.rb:147:in `block in replace_gem'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/sqlite3_adapter.rb:3:in `<top (required)>'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:251:in `require'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:251:in `block in require'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:236:in `load_dependency'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:251:in `require'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:48:in `resolve_hash_connection
'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:27:in `spec'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:127:in `establish_connection'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:58:in `create_database'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:40:in `block (3 levels) in <top (required)>'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:40:in `each'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:40:in `block (2 levels) in <top (required)>'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `block
in execute'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execut
e'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:158:in `block
in invoke_with_call_chain'
C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke
_with_call_chain'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke
'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:116:in
`invoke_task'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `
block (2 levels) in top_level'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `
each'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `
block in top_level'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `
top_level'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `
block in run'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `
run'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/bin/rake:33:in `<top (required)
>'
C:/Ruby192/bin/rake:19:in `load'
C:/Ruby192/bin/rake:19:in `<main>'
Couldn't create database for {"adapter"=>"sqlite3", "database"=>"testapp", "user
name"=>"root", "password"=>nil, "pool"=>5, "timeout"=>5000}
rake aborted!
Please install the sqlite3 adapter: `gem install activerecord-sqlite3-adapter` (
sqlite3 is not part of the bundle. Add it to Gemfile.)
Tasks: TOP => db:create
(See full trace by running task with --trace)
then I have done the following
C:\xampp\htdocs\ruby_projects\test_app>gem install activerecord-sqlite3-adapter
I am getting
ERROR: Could not find a valid gem 'activerecord-sqlite3-adapter' (>= 0) in any
repository
I got this when running dep walker
C:\xampp\htdocs\ruby_projects\test_app>dep_walker -c mysql2 -t
Checking mysql2-0.3.11-x86-mingw32
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.8/m
ysql2.so
libmysql.dll -> Found at C:\Ruby192\bin
kernel32.dll -> Found at C:\Windows\system32
msvcrt.dll -> Found at C:\Windows\system32
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.9/m
ysql2.so
msvcrt-ruby191.dll -> Found at C:\Ruby192\bin
libmysql.dll -> Found at C:\Ruby192\bin
kernel32.dll -> Found at C:\Windows\system32
msvcrt.dll -> Found at C:\Windows\system32
========================================
All dependencies found
I tried connecting with sqlite3
I have followed the instructions for installing sqlite3 from this site
Install SQLite3 on Windows
http://mislav.uniqpath.com/rails/install-sqlite3/
I have downloaded and copied
sqlite3.def
sqlite3.dll
sqlite3.exe
these in C:\Windows\System32
then I run gem install sqlite3
but when I am doing rake db:create
I am getting error
C:\xampp\htdocs\ruby_projects\test_app>rake db:create
Please install the sqlite3 adapter: `gem install activerecord-sqlite3-adapter` (
sqlite3 is not part of the bundle. Add it to Gemfile.)
C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/rubygems_integrati
on.rb:147:in `block in replace_gem'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/sqlite3_adapter.rb:3:in `<top (required)>'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:251:in `require'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:251:in `block in require'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:236:in `load_dependency'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.2.2/lib/active_support/depen
dencies.rb:251:in `require'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:48:in `resolve_hash_connection
'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:27:in `spec'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:127:in `establish_connection'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:58:in `create_database'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:40:in `block (3 levels) in <top (required)>'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:40:in `each'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.2.2/lib/active_record/railtie
s/databases.rake:40:in `block (2 levels) in <top (required)>'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `block
in execute'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execut
e'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:158:in `block
in invoke_with_call_chain'
C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
_with_call_chain'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke
'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:116:in
`invoke_task'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `
block (2 levels) in top_level'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `
each'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `
block in top_level'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `
top_level'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `
block in run'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `
run'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/bin/rake:33:in `<top (required)
>'
C:/Ruby192/bin/rake:19:in `load'
C:/Ruby192/bin/rake:19:in `<main>'
Couldn't create database for {"adapter"=>"sqlite3", "database"=>"testapp", "user
name"=>"root", "password"=>nil, "pool"=>5, "timeout"=>5000}
rake aborted!
Please install the sqlite3 adapter: `gem install activerecord-sqlite3-adapter` (
sqlite3 is not part of the bundle. Add it to Gemfile.)
Tasks: TOP => db:create
(See full trace by running task with --trace)
then I have done the following
C:\xampp\htdocs\ruby_projects\test_app>gem install activerecord-sqlite3-adapter
I am getting
ERROR: Could not find a valid gem 'activerecord-sqlite3-adapter' (>= 0) in any
repository
Boško Ivanišević
Mar 14, 2012, 7:37:08 AM3/14/12
to rubyin...@googlegroups.com
On Wed, Mar 14, 2012 at 11:20 AM, Sandeep Singla <sing...@gmail.com> wrote:
While connecting with rails 2 I was using gem mysql. I have tried to find the version of libmysql.dll but I am not able to get it.
I got this when running dep walker
C:\xampp\htdocs\ruby_projects\test_app>dep_walker -c mysql2 -t
Checking mysql2-0.3.11-x86-mingw32
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.8/m
ysql2.so
libmysql.dll -> Found at C:\Ruby192\bin
kernel32.dll -> Found at C:\Windows\system32
msvcrt.dll -> Found at C:\Windows\system32
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.9/m
ysql2.so
msvcrt-ruby191.dll -> Found at C:\Ruby192\bin
libmysql.dll -> Found at C:\Ruby192\bin
kernel32.dll -> Found at C:\Windows\system32
msvcrt.dll -> Found at C:\Windows\system32
========================================
All dependencies found
dep_walker has found libmysql.dll in the C:\Ruby192\bin folder as you can see from the output. Check which version is it.
Do you have sqlite3 gem in your Gemfile within Rails 3 app folder and have you executed:
bundle install
bundle install
Sandeep Singla
Mar 14, 2012, 1:12:33 PM3/14/12
to rubyin...@googlegroups.com
When I Am checking the properties of libmysql.dll I did'nt find version there.
I have successfully run sqlite
When I am configuring project on my machine
I got following error
C:\xampp\htdocs\ruby_projects\HomeRuns>rails s
C:/Ruby192/lib/ruby/gems/1.9.1/gems/cucumber-rails-1.0.2/lib/cucumber/rails.rb:4
:in `dirname': can't convert nil into String (TypeError)
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/cucumber-rails-1.0.2/lib/cucumb
er/rails.rb:4:in `<top (required)>'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:74:in `require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:74:in `rescue in block in require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:62:in `block in require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:55:in `each'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:55:in `require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler.rb:11
8:in `require'
from C:/xampp/htdocs/ruby_projects/HomeRuns/config/application.rb:13:in
`<top (required)>'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:53:in `require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:53:in `block in <top (required)>'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:50:in `tap'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:50:in `<top (required)>'
from script/rails:6:in `require'
from script/rails:6:in `<main>'
I have installed cucumber rails gem also
C:\xampp\htdocs\ruby_projects\HomeRuns>gem install cucumber-rails -v=1.0.2
Successfully installed cucumber-rails-1.0.2
1 gem installed
Installing ri documentation for cucumber-rails-1.0.2...
Installing RDoc documentation for cucumber-rails-1.0.2...
But still getting same error.
I have successfully run sqlite
When I am configuring project on my machine
I got following error
C:\xampp\htdocs\ruby_projects\HomeRuns>rails s
C:/Ruby192/lib/ruby/gems/1.9.1/gems/cucumber-rails-1.0.2/lib/cucumber/rails.rb:4
:in `dirname': can't convert nil into String (TypeError)
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/cucumber-rails-1.0.2/lib/cucumb
er/rails.rb:4:in `<top (required)>'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:74:in `require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:74:in `rescue in block in require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:62:in `block in require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:55:in `each'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler/runti
me.rb:55:in `require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/bundler-1.1.0/lib/bundler.rb:11
8:in `require'
from C:/xampp/htdocs/ruby_projects/HomeRuns/config/application.rb:13:in
`<top (required)>'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:53:in `require'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:53:in `block in <top (required)>'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:50:in `tap'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.2.2/lib/rails/comman
ds.rb:50:in `<top (required)>'
from script/rails:6:in `require'
from script/rails:6:in `<main>'
I have installed cucumber rails gem also
C:\xampp\htdocs\ruby_projects\HomeRuns>gem install cucumber-rails -v=1.0.2
Successfully installed cucumber-rails-1.0.2
1 gem installed
Installing ri documentation for cucumber-rails-1.0.2...
Installing RDoc documentation for cucumber-rails-1.0.2...
But still getting same error.
Boško Ivanišević
Mar 14, 2012, 1:42:56 PM3/14/12
to rubyin...@googlegroups.com
Reply all
Reply to author
Forward
0 new messages