Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error: uninitialized constant Mysql::Protocol::UNIXSocket

61 views
Skip to first unread message

Shahab Qadeer

unread,
Feb 3, 2010, 5:47:49 PM2/3/10
to
/!\ FAILSAFE /!\ Wed Feb 03 23:02:50 +0500 2010
Status: 500 Internal Server Error
uninitialized constant Mysql::Protocol::UNIXSocket
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb:105:in
`const_missing'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.2/lib/mysql/protocol.rb:212:in
`initialize'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.2/lib/mysql/protocol.rb:209:in
`initialize'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.2/lib/mysql.rb:110:in
`new'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.2/lib/mysql.rb:110:in
`connect'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:585:in
`connect'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:199:in
`initialize'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:71:in
`new'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:71:in
`mysql_connection'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
`new_connection'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in
`checkout_new_connection'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in
`checkout'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
`loop'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
`checkout'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/monitor.rb:242:in `mon_synchronize'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in
`checkout'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in
`connection'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in
`retrieve_connection'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in
`retrieve_connection'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in
`connection'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/query_cache.rb:9:in
`cache'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/query_cache.rb:28:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/head.rb:9:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/params_parser.rb:15:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/session/cookie_store.rb:93:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/failsafe.rb:26:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/dispatcher.rb:114:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/reloader.rb:34:in
`run'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/dispatcher.rb:108:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/static.rb:31:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:48:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in
`each'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/log_tailer.rb:17:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/content_length.rb:13:in
`call'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb:50:in
`service'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/httpserver.rb:104:in
`service'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:173:in
`start_thread'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:162:in `start'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:162:in
`start_thread'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:95:in `start'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:92:in `each'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:92:in `start'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:23:in `start'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/1.8/webrick/server.rb:82:in `start'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb:14:in
`run'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/commands/server.rb:111
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/commands/server.rb:31:in
`require'
C:/Program Files/NetBeans
6.8/ruby2/jruby-1.4.0/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require'
script\server:3
--
Posted via http://www.ruby-forum.com/.

Shahab Qadeer

unread,
Feb 3, 2010, 5:59:39 PM2/3/10
to
Can someone faced this error before. I have just configured the
application until now.

It seems to me like that something is wrong with MySQL connection. But I
am not sure. Please help

Eric Christopherson

unread,
Feb 4, 2010, 1:37:49 AM2/4/10
to
On Wed, Feb 3, 2010 at 4:59 PM, Shahab Qadeer <shahab...@hotmail.com> wrote:
> Can someone faced this error before. I have just configured the
> application until now.
>
> It seems to me like that something is wrong with MySQL connection. But I
> am not sure. Please help
>

It appears you're running on Windows, which doesn't have Unix sockets.
Sorry, I don't know how to fix your problem.

Jonathan Nielsen

unread,
Feb 4, 2010, 9:57:25 AM2/4/10
to
> It appears you're running on Windows, which doesn't have Unix sockets.
> Sorry, I don't know how to fix your problem.
>
On Windows, tell MySQL to connect to '127.0.0.1' instead of
'localhost' to force the use of a TCP socket instead of unix sockets.

-Jonathan Nielsen

Rodrigo

unread,
Feb 27, 2010, 10:54:52 AM2/27/10
to
Hey, I've got the same issue, how do I set mysql to connect to localhost:3001 in my case ??
Thanks!

---
frmsrcurl: http://compgroups.net/comp.lang.ruby/Error-uninitialized-constant-Mysql-Protocol-UNIXSocket

Charles Oliver Nutter

unread,
Mar 5, 2010, 10:49:24 AM3/5/10
to
On Wed, Feb 3, 2010 at 4:47 PM, Shahab Qadeer <shahab...@hotmail.com> wrote:
> /!\ FAILSAFE /!\  Wed Feb 03 23:02:50 +0500 2010
>  Status: 500 Internal Server Error
>  uninitialized constant Mysql::Protocol::UNIXSocket
>    C:/Program Files/NetBeans
> 6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb:105:in
> `const_missing'
>    C:/Program Files/NetBeans
> 6.8/ruby2/jruby-1.4.0/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.2/lib/mysql/protocol.rb:212:in
> `initialize'

This looks like the ruby-mysql gem (which I assume is the pure-ruby
mysql driver) depends on UNIXSocket, which is obviously not available
on Windows.

Perhaps you're using the default Rails configuration that tries to use
unix sockets instead of a real socket? Try changing the config to
specify a host name instead of a UNIX socket file.

- Charlie

raronas

unread,
Mar 13, 2010, 12:23:17 PM3/13/10
to
On 5 mar, 12:49, Charles Oliver Nutter <head...@headius.com> wrote:

Hello,
How do I do this?
MySQL works for other languages in my PC, for PHP for example, how do
I confgiure this with ruby on rails? in which config file?
thanks!

Luis Lavena

unread,
Mar 13, 2010, 1:19:05 PM3/13/10
to
On Mar 13, 6:23 pm, raronas <arona...@gmail.com> wrote:
>
> Hello,
> How do I do this?
> MySQL works for other languages in my PC, for PHP for example, how do
> I confgiure this with ruby on rails? in which config file?
> thanks!

Please provide details about the ruby implementation and version
you're using.

Also, the operating system and the version of mysql you're trying to
connect with.

With that information, we can help you out figuring out which
component needs to be replaced and guide you on the right direction.

--
Luis Lavena

Charles Oliver Nutter

unread,
Mar 15, 2010, 2:55:50 PM3/15/10
to
On Sat, Mar 13, 2010 at 11:25 AM, raronas <aron...@gmail.com> wrote:
> Hello,
> How do I do this?
> MySQL works for other languages in my PC, for PHP for example, how do
> I confgiure this with ruby on rails? in which config file?
> thanks!

It would be in your database.yml file.

- Charlie

raronas

unread,
Mar 21, 2010, 7:43:54 PM3/21/10
to

Hello,
in database.yml I have this:

development:
adapter: mysql
encoding: utf8
database: dancemove_development
pool: 5
username: root
password: xxxxx
host: localhost

I'm using netbeans 6.8, I have Windows 7 Professional, Trying to use
MySQL 5.0,
have ruby 1.8.6 and rails 2.0.2.
Thanks!

raronas

unread,
Mar 28, 2010, 7:48:36 PM3/28/10
to

Hello fellas!
Does anybody know something about this error? It's really annoying I
can't set it up correctly on my PC.
Thanks!!!

Jonathan Nielsen

unread,
Mar 29, 2010, 1:25:51 AM3/29/10
to
>
> Hello fellas!
> Does anybody know something about this error? It's really annoying I
> can't set it up correctly on my PC.
> Thanks!!!
>
>

Just a possibility, try changing 'host' from localhost to 127.0.0.1 so
it uses a TCPSocket instead of a UNIXSocket.

-Jonathan Nielsen

raronas

unread,
Mar 29, 2010, 7:41:17 AM3/29/10
to
I'm already Using 127.0.0.1.
Thanks anyway!

---
frmsrcurl: http://compgroups.net/comp.lang.ruby/Error-uninitialized-constant-Mysql-Protocol-UNIXSocket

Luis Lavena

unread,
Mar 29, 2010, 8:03:07 AM3/29/10
to
On Mar 29, 1:41 pm, raronas <u...@compgroups.net/> wrote:
> I'm already Using 127.0.0.1.
> Thanks anyway!

Please report to the ruby-mysql author[1] that this is a bug since is
not considering RbConfig::CONFIG['host_os'] to avoid usage of
UNIXSocket under Windows

[1] http://github.com/tmtm/ruby-mysql

--
Luis Lavena

raronas

unread,
Mar 31, 2010, 10:14:49 PM3/31/10
to

Hey, thank you all!
I've put 127.0.0.1 on host in database.yml and worked like a charm!
Thank you all guys! Problem Solved!

0 new messages