VoIP Mailing List Archives

[pippyduck1127 at hotma...]

Hello Anyone,

Now, I'm attempting to load CDR Data on the database in Real Time.
by following the instruction on this link
http://wiki.freeswitch.org/wiki/CDR

However, when trying to send create_table.rb to the database,
I'm still struggling with connecting to mySQL database

Note:
my Operation System is WindowXP 2002.
the ruby version that I used is 1.9.1 p129.

Below is the error message show in the Command Prompt:
-------------------------------------------------------------------------
C:\cdr>ruby create_table.rb
C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters/mysql.rb:157
:in `query': Mysql::Error: Commands out of sync; you can't run this command now
(Sequel::DatabaseDisconnectError)
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters
/mysql.rb:157:in `_execute'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters
/mysql.rb:140:in `block in execute'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/connecti
on_pool.rb:112:in `hold'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database
.rb:482:in `synchronize'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters
/mysql.rb:140:in `execute'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database
.rb:313:in `execute_dui'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database
.rb:306:in `execute_ddl'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database
/schema_methods.rb:188:in `create_table_from_generator'
from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database
/schema_methods.rb:73:in `create_table'
from create_table.rb:6:in `<main>'
<main>:306: [BUG] Segmentation fault
ruby 1.9.1p129 (2009-05-12 revision 23412) [i386-mswin32]

-- control frame ----------
c:0001 p:0000 s:0002 b:0002 l:0010c4 d:0010c4 TOP <main>:306
---------------------------
-- Ruby level backtrace information-----------------------------------------

[NOTE]
You may encounter a bug of Ruby interpreter. Bug reports are welcome.
For details: http://www.ruby-lang.org/bugreport.html


This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

C:\cdr>
-------------------------------------------------------------------------

Has anyone ever had this problem? Pleaes advise.

PB.






Windows 7: Simplify your PC. Learn more.