<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hello Anyone,<br><br>Now, I'm attempting to load CDR Data on the database in Real Time.<br>by following the instruction on this link <br><font style="" color="#4f81bd">http://wiki.freeswitch.org/wiki/CDR</font><br><br>
However, when trying to send create_table.rb to the database,<br>I'm still struggling with connecting to mySQL database<br><br>Note: <br>
my Operation System is WindowXP 2002.<br>
the ruby version that I used is 1.9.1 p129.<br><br>Below is the error message show in the Command Prompt:<br>------------------------------------------------------------------------- <br><font style="" color="#7f7f7f"></font><font style="" color="#7f7f7f"></font><font style="" color="#7f7f7f"></font><font style="" color="#808080">C:\cdr>ruby create_table.rb</font><font style="" color="#808080"><br></font><font style="" color="#808080">C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters/mysql.rb:157</font><font style="" color="#808080"><br></font><font style="" color="#808080">:in `query': Mysql::Error: Commands out of sync; you can't run this command now</font><font style="" color="#808080"><br></font><font style="" color="#808080">(Sequel::DatabaseDisconnectError)</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters</font><font style="" color="#808080"><br></font><font style="" color="#808080">/mysql.rb:157:in `_execute'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters</font><font style="" color="#808080"><br></font><font style="" color="#808080">/mysql.rb:140:in `block in execute'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/connecti</font><font style="" color="#808080"><br></font><font style="" color="#808080">on_pool.rb:112:in `hold'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database</font><font style="" color="#808080"><br></font><font style="" color="#808080">.rb:482:in `synchronize'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/adapters</font><font style="" color="#808080"><br></font><font style="" color="#808080">/mysql.rb:140:in `execute'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database</font><font style="" color="#808080"><br></font><font style="" color="#808080">.rb:313:in `execute_dui'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database</font><font style="" color="#808080"><br></font><font style="" color="#808080">.rb:306:in `execute_ddl'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database</font><font style="" color="#808080"><br></font><font style="" color="#808080">/schema_methods.rb:188:in `create_table_from_generator'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from C:/Ruby19/lib/ruby/gems/1.9.1/gems/sequel-3.5.0/lib/sequel/database</font><font style="" color="#808080"><br></font><font style="" color="#808080">/schema_methods.rb:73:in `create_table'</font><font style="" color="#808080"><br></font><font style="" color="#808080"> from create_table.rb:6:in `<main>'</font><font style="" color="#808080"><br></font><font style="" color="#808080"><main>:306: [BUG] Segmentation fault</font><font style="" color="#808080"><br></font><font style="" color="#808080">ruby 1.9.1p129 (2009-05-12 revision 23412) [i386-mswin32]</font><font style="" color="#808080"><br></font><font style="" color="#808080"><br></font><font style="" color="#808080">-- control frame ----------</font><font style="" color="#808080"><br></font><font style="" color="#808080">c:0001 p:0000 s:0002 b:0002 l:0010c4 d:0010c4 TOP <main>:306</font><font style="" color="#808080"><br></font><font style="" color="#808080">---------------------------</font><font style="" color="#808080"><br></font><font style="" color="#808080">-- Ruby level backtrace information-----------------------------------------</font><font style="" color="#808080"><br></font><font style="" color="#808080"><br></font><font style="" color="#808080">[NOTE]</font><font style="" color="#808080"><br></font><font style="" color="#808080">You may encounter a bug of Ruby interpreter. Bug reports are welcome.</font><font style="" color="#808080"><br></font><font style="" color="#808080">For details: http://www.ruby-lang.org/bugreport.html</font><font style="" color="#808080"><br></font><font style="" color="#808080"><br></font><font style="" color="#808080"><br></font><font style="" color="#808080">This application has requested the Runtime to terminate it in an unusual way.</font><font style="" color="#808080"><br></font><font style="" color="#808080">Please contact the application's support team for more information.</font><font style="" color="#808080"><br></font><font style="" color="#808080"><br></font><font style="" color="#808080">C:\cdr></font><br>------------------------------------------------------------------------- <br><br>Has anyone ever had this problem? Pleaes advise.<br><br>PB.<br><br><br><br><br><br><br> <br /><hr />Windows 7: Simplify your PC. <a href='http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen1:102009' target='_new'>Learn more.</a></body>
</html>