[Freeswitch-users] Problem when load CDR Data on the database in Real Time

[Pajongjit Buntaokit]

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.
http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen1:102009
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091022/dd7ad906/attachment-0002.html