Something stupid no doubt, but I verified the settings, which work
fine via this api: http://www.tmtm.org/en/ruby/mysql/
here's the code:
require 'rubygems'
require 'sequel'
#DB = Sequel.connect
(:adapter=>'mysql', :host=>'localhost', :database=>'finqueries', :user=>'root',
:password=>'')
# tried this, same thing
DB = Sequel.connect('mysql://root:@localhost:3306/finqueries')
dataset = DB["SELECT pricedate FROM pricedata"]
puts dataset.count # => this is line 7, source of errors; see below
produces this:
/usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/adapters/mysql.rb:
107:in `connect': NameError uninitialized constant
Mysql::CLIENT_MULTI_RESULTS (Sequel::DatabaseConnectionError)
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
database.rb:92:in `initialize'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
connection_pool.rb:169:in `call'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
connection_pool.rb:169:in `make_new'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
connection_pool.rb:156:in `available'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
connection_pool.rb:147:in `acquire'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
connection_pool.rb:146:in `synchronize'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
connection_pool.rb:146:in `acquire'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
connection_pool.rb:102:in `hold'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
database.rb:472:in `synchronize'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
adapters/mysql.rb:137:in `execute'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
dataset.rb:314:in `execute'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
adapters/mysql.rb:358:in `execute'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
adapters/mysql.rb:314:in `fetch_rows'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
dataset.rb:185:in `each'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
dataset/convenience.rb:196:in `single_record'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
dataset/convenience.rb:203:in `single_value'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
dataset/sql.rb:94:in `count'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
dataset/sql.rb:94:in `count'
from /home/jenko/NetBeansProjects/FinQueryAlpha/lib/
test_sequel1.rb:7
Thanks in advance
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
