Re: [Freeswitch-users] How to make FS to use ODBC instead of SQLITE?
Thanks. I will use one DB. - Original Message - From: Michael Jerris To: freeswitch-users@lists.freeswitch.org Sent: Thursday, November 13, 2008 10:16 AM Subject: Re: [Freeswitch-users] How to make FS to use ODBC instead of SQLITE? I don't agree with that statement on the wiki. On Nov 13, 2008, at 8:12 AM, gary wrote: Thanks. In the instruction, it state that "A separate database should be used for each, including each type of SIP (external, internal and nat are typical examples). Therefore, the odbc.ini in /etc, should include an entry for each database used". Why is that? Can I use one database for all? Gary -- ___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org ___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
[Freeswitch-users] Errors on startup
When starting up FS, I got these errors: 2008-11-13 09:50:26 [NOTICE] switch_loadable_module.c:139 switch_loadable_module_process() Adding Endpoint 'sofia' 2008-11-13 09:50:26 [NOTICE] switch_loadable_module.c:257 switch_loadable_module_process() Adding API Function 'sofia' 2008-11-13 09:50:26 [NOTICE] switch_loadable_module.c:257 switch_loadable_module_process() Adding API Function 'sofia_contact' 2008-11-13 09:50:26 [NOTICE] switch_loadable_module.c:352 switch_loadable_module_process() Adding Chat interface 'sip' 2008-11-13 09:50:26 [NOTICE] switch_loadable_module.c:392 switch_loadable_module_process() Adding Management interface 'mod_sofia' OID[.1.3.6.1.4.1.27880.1] 2008-11-13 09:50:26 [ERR] switch_core_sqldb.c:95 switch_core_db_persistant_execute_trans() SQL ERR [database is locked] 2008-11-13 09:50:26 [ERR] switch_core_sqldb.c:95 switch_core_db_persistant_execute_trans() SQL ERR [database is locked] 2008-11-13 09:50:27 [ERR] switch_core_sqldb.c:95 switch_core_db_persistant_execute_trans() SQL ERR [database is locked] . 2008-11-13 09:51:31 [CONSOLE] switch_loadable_module.c:778 switch_loadable_module_load_file() Successfully Loaded [mod_expr] 2008-11-13 09:51:31 [NOTICE] switch_loadable_module.c:257 switch_loadable_module_process() Adding API Function 'expr' 2008-11-13 09:51:31 [ERR] switch_core_sqldb.c:131 switch_core_db_persistant_execute() SQL ERR [database is locked] 2008-11-13 09:51:32 [ERR] switch_core_sqldb.c:131 switch_core_db_persistant_execute() SQL ERR [database is locked] 2008-11-13 09:51:34 [CONSOLE] switch_loadable_module.c:778 switch_loadable_module_load_file() Successfully Loaded [mod_fifo] 2008-11-13 09:51:34 [NOTICE] switch_loadable_module.c:237 switch_loadable_module_process() Adding Application 'fifo' 2008-11-13 09:51:34 [NOTICE] switch_loadable_module.c:257 switch_loadable_module_process() Adding API Function 'fifo' 2008-11-13 09:51:34 [INFO] mod_voicemail.c:706 load_config() Added Profile default 2008-11-13 09:51:34 [CONSOLE] switch_loadable_module.c:778 switch_loadable_module_load_file() Successfully Loaded [mod_voicemail] 2008-11-13 09:51:34 [NOTICE] switch_loadable_module.c:237 switch_loadable_module_process() Adding Application 'voicemail' 2008-11-13 09:51:34 [NOTICE] switch_loadable_module.c:257 switch_loadable_module_process() Adding API Function 'voicemail' 2008-11-13 09:51:34 [NOTICE] switch_loadable_module.c:257 switch_loadable_module_process() Adding API Function 'voicemail_inject' 2008-11-13 09:51:34 [NOTICE] switch_loadable_module.c:257 switch_loadable_module_process() Adding API Function 'vm_boxcount' 2008-11-13 09:51:38 [ERR] switch_core_sqldb.c:95 switch_core_db_persistant_execute_trans() SQL ERR [database is locked] 2008-11-13 09:51:38 [ERR] switch_core_sqldb.c:95 switch_core_db_persistant_execute_trans() SQL ERR [database is locked] 2008-11-13 09:51:39 [ERR] switch_core_sqldb.c:95 switch_core_db_persistant_execute_trans() SQL ERR [database is locked] 2008-11-13 09:51:39 [ERR] switch_core_sqldb.c:95 switch_core_db_persistant_execute_trans() SQL ERR [database is locked] What causes these errors? How can I fix them? Gary ___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Re: [Freeswitch-users] How to make FS to use ODBC instead of SQLITE?
Thanks. In the instruction, it state that "A separate database should be used for each, including each type of SIP (external, internal and nat are typical examples). Therefore, the odbc.ini in /etc, should include an entry for each database used". Why is that? Can I use one database for all? Gary - Original Message - From: Michael Jerris To: freeswitch-users@lists.freeswitch.org Sent: Wednesday, November 12, 2008 4:39 PM Subject: Re: [Freeswitch-users] How to make FS to use ODBC instead of SQLITE? http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core You can configure odbc as normal on the box to setup the dsn's then follow the instructions at that link. FreeSWITCH will create the tables it needs for you. Mike On Nov 12, 2008, at 3:54 PM, gary wrote: I am tring to configure FS to use ODBC with mysql instead of sqlite to store all the SIP registration information. The UnixODBC and mysql all work fine. I also find the doc on the web regarding install SpiderMonkey ODBC. It seems that this one is for using javascript to access ODBC db. What is the procedure to enable ODBC support for FS core system? I guess I also need to create database schema for FS to use. Where can I find it? I compile FS with following steps: 1) uncomment the languages/mod_spidermonkey_odbc line within the build/modules.conf file. 2) ./configure --enable-core-odbc-support 3) make all install What else do I need to do to make FS using ODBC instead of sqlite? database name? table structure? user name? password? etc -- ___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org ___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
[Freeswitch-users] How to make FS to use ODBC instead of SQLITE?
I am tring to configure FS to use ODBC with mysql instead of sqlite to store all the SIP registration information. The UnixODBC and mysql all work fine. I also find the doc on the web regarding install SpiderMonkey ODBC. It seems that this one is for using javascript to access ODBC db. What is the procedure to enable ODBC support for FS core system? I guess I also need to create database schema for FS to use. Where can I find it? I compile FS with following steps: 1) uncomment the languages/mod_spidermonkey_odbc line within the build/modules.conf file. 2) ./configure --enable-core-odbc-support 3) make all install What else do I need to do to make FS using ODBC instead of sqlite? database name? table structure? user name? password? etc Gary ___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
[Freeswitch-users] Questions
1) Do I need to reload directory into FS after I added new users in XML file? How? reloadxml? 2) Can I use alias for user? I'd like to register the user with 10 digits DID and also assign 4 digits extension to the same user so people can call each other internally with 4 extensions. What is the best way to do this? I do not want to hard code all these 4 digits extensions into dialplan to map the their DID. 3) Can FS handle large number of sip registrations with multiple(over 100) tenants (context) ? Lets say 10,000 or even 50,000 users. Gary___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Re: [Freeswitch-users] Problem with first use.
Here is the debug info after press F8:
2008-10-10 13:33:00 [DEBUG] sofia.c:3134 sofia_handle_sip_i_invite() IP
10.1.1.129 Rejected by acl domains. Falling back to Digest auth.
2008-10-10 13:33:00 [DEBUG] sofia.c:3134 sofia_handle_sip_i_invite() IP
10.1.1.129 Rejected by acl domains. Falling back to Digest auth.
2008-10-10 13:33:00 [NOTICE] switch_channel.c:534 switch_channel_set_name() New
Channel sofia/internal/[EMAIL PROTECTED] [41067ebd-0e4a-46e2-942c-f2a953819333]
2008-10-10 13:33:00 [DEBUG] sofia.c:3624 sofia_handle_sip_i_invite() Setting
NAT mode based on via port
2008-10-10 13:33:00 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state() Channel
sofia/internal/[EMAIL PROTECTED] entering state [received]
2008-10-10 13:33:00 [DEBUG] sofia.c:2133 sofia_handle_sip_i_state() Remote SDP:
v=0
o=Cisco-SIPUA 11819 0 IN IP4 10.1.1.129
s=SIP Call
t=0 0
m=audio 23142 RTP/AVP 0 8 18 101
c=IN IP4 10.1.1.129
a=rtpmap:0 PCMU/8000
a=rtpmap:8 PCMA/8000
a=rtpmap:18 G729/8000
a=fmtp:18 annexb=no
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
2008-10-10 13:33:00 [DEBUG] sofia_glue.c:2280 sofia_glue_negotiate_sdp() Audio
Codec Compare [PCMU:0:8000]/[G722:9:8000]
2008-10-10 13:33:00 [DEBUG] sofia_glue.c:2280 sofia_glue_negotiate_sdp() Audio
Codec Compare [PCMU:0:8000]/[PCMU:0:8000]
2008-10-10 13:33:00 [DEBUG] sofia_glue.c:1530 sofia_glue_tech_set_codec() Set
Codec sofia/internal/[EMAIL PROTECTED] PCMU/8000 20 ms 160 samples
2008-10-10 13:33:00 [DEBUG] sofia_glue.c:2243 sofia_glue_negotiate_sdp() Set
2833 dtmf payload to 101
2008-10-10 13:33:00 [DEBUG] sofia.c:2270 sofia_handle_sip_i_state()
sofia/internal/[EMAIL PROTECTED] State Change CS_NEW -> CS_INIT
2008-10-10 13:33:00 [DEBUG] switch_core_session.c:722
switch_core_session_signal_state_change() Kill sofia/internal/[EMAIL PROTECTED]
[BREAK]
2008-10-10 13:33:00 [DEBUG] switch_core_state_machine.c:365
switch_core_session_run() sofia/internal/[EMAIL PROTECTED] Running State Change
CS_INIT
2008-10-10 13:33:00 [DEBUG] switch_core_state_machine.c:415
switch_core_session_run() (sofia/internal/[EMAIL PROTECTED]) State INIT
2008-10-10 13:33:00 [DEBUG] mod_sofia.c:80 sofia_on_init()
sofia/internal/[EMAIL PROTECTED] SOFIA INIT
2008-10-10 13:33:00 [DEBUG] mod_sofia.c:107 sofia_on_init()
sofia/internal/[EMAIL PROTECTED] State Change CS_INIT -> CS_ROUTING
2008-10-10 13:33:00 [DEBUG] switch_core_session.c:722
switch_core_session_signal_state_change() Kill sofia/internal/[EMAIL PROTECTED]
[BREAK]
2008-10-10 13:33:00 [DEBUG] switch_core_state_machine.c:415
switch_core_session_run() (sofia/internal/[EMAIL PROTECTED]) State INIT going
to sleep
2008-10-10 13:33:00 [DEBUG] switch_core_state_machine.c:365
switch_core_session_run() sofia/internal/[EMAIL PROTECTED] Running State Change
CS_ROUTING
2008-10-10 13:33:00 [DEBUG] switch_core_state_machine.c:420
switch_core_session_run() (sofia/internal/[EMAIL PROTECTED]) State ROUTING
2008-10-10 13:33:00 [DEBUG] mod_sofia.c:119 sofia_on_routing()
sofia/internal/[EMAIL PROTECTED] SOFIA ROUTING
2008-10-10 13:33:00 [DEBUG] switch_core_state_machine.c:64
switch_core_standard_on_routing() Standard ROUTING sofia/internal/[EMAIL
PROTECTED]
2008-10-10 13:33:00 [INFO] mod_dialplan_xml.c:222 dialplan_hunt() Processing
Line1->[EMAIL PROTECTED]
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions ${unroll_loops}(true) =~ /^true$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions ${sip_looped_call}() =~ /^true$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:109 parse_exten() Regex mismatch
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions ${strftime(%H%M)}(1333) =~ /^((09|1[0-7])[0-5][0-9]|1800)$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions destination_number(1001) =~ /^886$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:109 parse_exten() Regex mismatch
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions destination_number(1001) =~ /^\*\*(\d+)$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:109 parse_exten() Regex mismatch
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions destination_number(1001) =~ /^870$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:109 parse_exten() Regex mismatch
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions ${network_addr}(10.1.1.129) =~ /^$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:109 parse_exten() Regex mismatch
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions ${numbering_plan}() =~ /^$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions ${call_debug}(false) =~ /^true$/
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:109 parse_exten() Regex mismatch
2008-10-10 13:33:00 [DEBUG] mod_dialplan_xml.c:107 parse_exten() test
conditions ${sip_has_crypto}() =~
/^(AES_CM_128_HMAC_SHA1_32|AES_CM_128_HMAC_SHA1_80)$/
2008-10-1
[Freeswitch-users] Problem with first use.
Hello, I am new to freeswitch. Just installed freeswitch-1.0.1 with default configurations on CentOS 4.6 with OpenVZ. I registered two Cisco7960 phones using static IP with default users(1001.xml, 1007.xml). The registration are OK, but when I try to call from each other, it immedially send to voicemail. The following is the log info from console: (I replaced the real IP with 10.1.1.117 in the log) 2008-10-10 11:41:02 [NOTICE] switch_channel.c:534 switch_channel_set_name() New Channel sofia/internal/[EMAIL PROTECTED]:51029;transport=udp;fs_nat=yes [bfe75310-638d-48df-8f3d-262143c15b22] 2008-10-10 11:41:02 [NOTICE] sofia.c:2545 sofia_handle_sip_i_state() Hangup sofia/internal/[EMAIL PROTECTED]:51029;transport=udp;fs_nat=yes [CS_CONSUME_MEDIA] [NORMAL_TEMPORARY_FAILURE] 2008-10-10 11:41:02 [ERR] switch_ivr_originate.c:926 switch_ivr_originate() Cannot create outgoing channel of type [user] cause: [NORMAL_TEMPORARY_FAILURE] 2008-10-10 11:41:02 [INFO] mod_dptools.c:1789 audio_bridge_function() Originate Failed. Cause: NORMAL_TEMPORARY_FAILURE 2008-10-10 11:41:02 [NOTICE] switch_core_session.c:807 switch_core_session_thread() Session 6 (sofia/internal/[EMAIL PROTECTED]:51029;transport=udp;fs_nat=yes) Ended 2008-10-10 11:41:02 [NOTICE] switch_core_session.c:809 switch_core_session_thread() Close Channel sofia/internal/[EMAIL PROTECTED]:51029;transport=udp;fs_nat=yes [CS_HANGUP] Is it possible the NAT causing problem? I am using static IP on both server and phones and do not really need NAT. If it is, how can I disable NAT on the FS server. Can anybody tell me the cause? Gary___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
