Hi,<br><br>For last two days i am trying to setup a freeswitch box for an voip application testing against it. FreeSWITCH compiles successfully but when i try to start it i get a lot critical errors from switch_core_sqldb.c, e.g.<br>
<br><br><span style="color: rgb(255, 0, 0);">2010-05-12 16:35:42.691358 [ERR] switch_core_sqldb.c:404 SQL ERR [no such table: interfaces]</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">insert into interfaces (type,name,description,syntax,ikey,filename,hostname) values('chat','event','','','mod_dptools','/usr/local/freeswitch/mod/mod_dptools.so','lenovo');</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);">insert into interfaces (type,name,description,syntax,ikey,filename,hostname) values('chat','api','','','mod_dptools','/usr/local/freeswitch/mod/mod_dptools.so','lenovo');</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);">insert into interfaces (type,name,description,syntax,ikey,filename,hostname) values('api','expr','Eval an expression','<expr>','mod_expr','/usr/local/freeswitch/mod/mod_expr.so','lenovo');</span><br style="color: rgb(255, 0, 0);">
<br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">2010-05-12 16:35:42.691419 [ERR] switch_core_sqldb.c:670 SQL ERR [no such table: interfaces]</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">2010-05-12 16:35:42.791490 [CRIT] switch_core_sqldb.c:889 SQL thread unable to commit transaction, records lost!</span><br style="color: rgb(255, 0, 0);">
<br>and it continues till my machine eventually hangs. Its happening with latest git revision, i don't know how to get revision number in git (i am not much familiar with it) but "git log" command give this as first line.<br>
<br>commit 5530de66ef6880621086c6276731504459eb6709<br>Author: Rupa Schomaker <<a href="mailto:rupa@rupa.com">rupa@rupa.com</a>><br>Date: Wed May 12 03:32:18 2010 -0500<br><br clear="all">I suspect the last line, i.e.<br>
<span style="color: rgb(255, 0, 0);">2010-05-12 16:35:42.791490 [CRIT]
switch_core_sqldb.c:889 SQL thread unable to commit transaction, records
lost!</span><br><br>is the reason for these errors but i am not sure why its happening.<br><br>Thank you.<br><br><br>-- <br>Muhammad Shahzad<br>-----------------------------------<br>CISCO Rich Media Communication Specialist (CRMCS)<br>
CISCO Certified Network Associate (CCNA)<br>Cell: +92 334 422 40 88<br>MSN: <a href="mailto:shari_786pk@hotmail.com">shari_786pk@hotmail.com</a><br>Email: <a href="mailto:shaheryarkh@googlemail.com">shaheryarkh@googlemail.com</a><br>