[Freeswitch-users] FreeSWITCH startup failure

Thu May 13 07:46:19 PDT 2010

who suggested those configure flags?
"-enable-optimization --disable-debug --enable-visibility" probably should
not be passed

regardless if you configure with odbc or not it will not use it unles you
configure it to.
It will always us sqlite.

You are using bleeding edge distro which is an at-your-own risk decision.

you probably need to rm -f /usr/local/freeswitch before you re-install from
scratch.

Basically you are wasting your 2 days by not following
the recommendations we lay out for people who are unsure how to properly
configure their system.  Learn to take the tao approach and "go with the
flow" and you could spend those 2 days in a hammock.

On Thu, May 13, 2010 at 1:04 AM, Muhammad Shahzad <
shaheryarkh at googlemail.com> wrote:

> First i tried odbc but it gave this error. Then i removed everything (FS
> binaries, configs, sources etc.), downloaded FS again and compiled it
> without odbc support but again same problem. I can see sqlite files being
> created by freeswitch in /usr/local/freeswitch/db folder but for some
> reason, FS still can't find any table in it. The problem is not with just
> interface table but all tables, include table related to sofia sip, voice
> mail etc. etc.
>
> I am using Ubuntu 10.04 32bit desktop edition, on Intel x86 with following
> freeswitch configuration,
>
> ./configure --enable-optimization --disable-debug --enable-visibility
> --enable-zrtp --enable-core-odbc-support --with-openssl
> --with-java=/usr/lib/jvm/java-6-sun --with-python --with-erlang
>
> FS compiles without any problem as all dependencies are already
> pre-installed. But after installation when i start it with following options
> as root user,
>
> ./freeswitch -hp -waste -core
>
> The console soon become full with switch_core_sqldb.c errors and system
> gets to slow down till it hangs.
>
> I have tried different combinations of configure flags (e.g. removing zrtp
> and odbc support etc.) but no success.
>
> I have examined the sqlite files created by FS but it seems each file
> contains only one table, while i suspect there should be more then one
> tables, for example for sofia sip i remember there is a table for sip
> registrations, sip presence, sip dialog etc. etc. but when i open
> /usr/local/freeswitch/db/sofia_reg_internal.db file in SQLite manager, there
> is only one empty table named sip_recovery.
>
> Same thing happens when using odbc, only one table sip_recovery gets
> created for sofia sip, the FS continues to complain that it can't find any
> table.
>
> Please help as i have wasted 2 days without any luck on this.
>
> Thank you.
>
>
>
> On Wed, May 12, 2010 at 6:49 PM, Rupa Schomaker <rupa at rupa.com> wrote:
>
>> THat commit just removes a .rej file, don't see how it can affect
>>
>> $ git diff
>> --stat 1d2c64d33bf033788c5521c212b861ba11c229af..5530de66ef6880621086c6276731504459eb6709
>>
>> (those are the two SHA1s I'm getting stats on,  first is tony's just
>> before my changes, second is mine)
>>
>>  src/include/switch_types.h.orig                    | 1714 ------
>>  .../mod_conference/mod_conference.c.orig           | 6343
>> --------------------
>>  .../mod_conference/mod_conference.c.rej            |   50 -
>>  src/mod/formats/mod_sndfile/mod_sndfile.c.orig     |  462 --
>>  .../languages/mod_python/mod_python_wrap.cpp.rej   |   38 -
>>  src/switch_core.c.orig                             | 2018 -------
>>   src/switch_time.c.orig                             | 1962 ------
>>  7 files changed, 0 insertions(+), 12587 deletions(-)
>>
>>
>> Don't see how removing patch droppings can possibly cause your problem.
>>
>> The real issue is that the interfaces table doesn't exist.  The last error
>> is because the table didn't exist for the records to be inserted into.  As
>> with all core tables, this SHOULD be auto-created.
>>
>> Are you running against odbc for core or sqlite?
>>
>> On Wed, May 12, 2010 at 6:48 AM, Muhammad Shahzad <
>> shaheryarkh at googlemail.com> wrote:
>>
>>> Hi,
>>>
>>> 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.
>>>
>>>
>>> 2010-05-12 16:35:42.691358 [ERR] switch_core_sqldb.c:404 SQL ERR [no such
>>> table: interfaces]
>>> insert into interfaces
>>> (type,name,description,syntax,ikey,filename,hostname)
>>> values('chat','event','','','mod_dptools','/usr/local/freeswitch/mod/mod_dptools.so','lenovo');
>>> insert into interfaces
>>> (type,name,description,syntax,ikey,filename,hostname)
>>> values('chat','api','','','mod_dptools','/usr/local/freeswitch/mod/mod_dptools.so','lenovo');
>>> 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');
>>>
>>> 2010-05-12 16:35:42.691419 [ERR] switch_core_sqldb.c:670 SQL ERR [no such
>>> table: interfaces]
>>> 2010-05-12 16:35:42.791490 [CRIT] switch_core_sqldb.c:889 SQL thread
>>> unable to commit transaction, records lost!
>>>
>>> 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.
>>>
>>> commit 5530de66ef6880621086c6276731504459eb6709
>>> Author: Rupa Schomaker <rupa at rupa.com>
>>> Date:   Wed May 12 03:32:18 2010 -0500
>>>
>>> I suspect the last line, i.e.
>>> 2010-05-12 16:35:42.791490 [CRIT] switch_core_sqldb.c:889 SQL thread
>>> unable to commit transaction, records lost!
>>>
>>> is the reason for these errors but i am not sure why its happening.
>>>
>>> Thank you.
>>>
>>>
>>> --
>>> Muhammad Shahzad
>>> -----------------------------------
>>> CISCO Rich Media Communication Specialist (CRMCS)
>>> CISCO Certified Network Associate (CCNA)
>>> Cell: +92 334 422 40 88
>>> MSN: shari_786pk at hotmail.com
>>> Email: shaheryarkh at googlemail.com
>>>
>>> _______________________________________________
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> http://www.freeswitch.org
>>>
>>>
>>
>>
>> --
>> -Rupa
>>
>> _______________________________________________
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
>
> --
> Muhammad Shahzad
> -----------------------------------
> CISCO Rich Media Communication Specialist (CRMCS)
> CISCO Certified Network Associate (CCNA)
> Cell: +92 334 422 40 88
> MSN: shari_786pk at hotmail.com
> Email: shaheryarkh at googlemail.com
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>

-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100513/3ad67de0/attachment.html 