On Dec 11, 8:16 pm, dave <[email protected]> wrote: > I am unsure of what i'm doing wrong but it seems that it's 1 step > forward and a few back at present for me. > after issues trying to sort out the rescue ensure part of my DB access > script i've fallen foul of the gem gods again. > > my connection code is this... > > puts 'in remote side' > @db = Sequel.mysql2(:host => 'remote.co.nz', :database => > 'server', :user => "my_name", :password => "2010") > # remote > end > Thread.new{loop{sleep 60; DB.get(1)}} #to keep the connection > open > > rescue Sequel::DatabaseError > @log.debug("An error occurred\nError code: #{Sequel}\nError > message: #{Sequel.to_s}") > ensure > @log.debug("DB closed!") > @db.disconnect if @db > > currently i am getting these errors... > > in DB connection initialize > in remote side > C:/Ruby187/lib/ruby/gems/1.8/gems/sequel-3.18.0/lib/sequel/adapters/ > mysql2.rb:58 > :in `query': Interrupt: (Sequel::DatabaseConnectionError) > from C:/Ruby187/lib/ruby/gems/1.8/gems/sequel-3.18.0/lib/ > sequel/adapters > /mysql2.rb:58:in `connect' > > this ot me *IS* the problem!
This says the initial exception was Interrupt (did you press Ctrl-C while connecting?). > **** lots of lines referring to problems in the apdapter - these > not shown.**** It's almost always a bad idea not to provide full backtraces. > I tried originially this line and got the same errors > > @db = Sequel.connect(:adapter => 'mysql', :host => > 'remote.co.nz', :database => 'server', :user => "my_name", :password > => "2010") > > I've also tried a simple get the version number after the connect and > it has worked but as soon as i try to get a Query result this error > occures You may want to use test_connection after the Sequel.connect call just to make sure things are working. > I am wondering if the mysql (2.8.1 x86-mingw32) gem is incompatible > with sequel. > tried using mysql2 (0.2.6 x86-mingw32) also but this too gives me the > same errors. Both are compatible with Sequel and tested on a regular basis (before every push to github). > Now just added a .connect and got this error so I'm making progress > but don't understand what I am doing wrong! > > connection statement was > @db = Sequel.mysql.connect(:host => 'remote.co.nz', :database => > 'server', :user => "my_name", :password => "2010") This is not progress, this is just wrong. You are attempting to set up the connection with default parameters (which is why it attempts to use localhost), and then calling the connect method, which should not really be called by user code. My recommendation is first get a working connection using either mysql or mysql2 directly. Once you have a working connection with mysql or mysql2, you should be able to figure out how to get it working with Sequel, and if not, please post here with your working connection information for mysql or mysql2 and I'll attempt to help. Jeremy -- 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.
