On Sat, Sep 5, 2009 at 5:36 PM, Juan Backson <juanbackson@gmail.com> wrote:
Hi,
I am getting no dial-string available error when using xml_odbc module to bridge a call. How can I resolve this problem?
Hello, I never tried the mod_xml_odbc. But as the message says, you are not providing a dial-string. I believe your template is incomplete. Read about the dial-string here: http://wiki.freeswitch.org/wiki/XML_User_Directory_Guide#Dial_String
EXECUTE sofia/internal/180001@192.168.1.130 bridge(user/180001) 2009-09-05 16:31:29.853456 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [key_value]=[192.168.1.134] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [key_name]=[name] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [tag_name]=[domain] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [section]=[directory] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Event-Name]=[REQUEST_PARAMS] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Core-UUID]=[f649cdfd-3715-4d18-94d9-417aa7e26873] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [FreeSWITCH-Hostname]=[server] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [FreeSWITCH-IPv4]=[192.168.1.134] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [FreeSWITCH-IPv6]=[::1] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Event-Date-Local]=[2009-09-05 16:31:29] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Event-Date-GMT]=[Sat, 05 Sep 2009 08:31:29 GMT] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Event-Date-Timestamp]=[1252139489853456] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Event-Calling-File]=[mod_dptools.c] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Event-Calling-Function]=[user_outgoing_channel] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [Event-Calling-Line-Number]=[2365] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [as_channel]=[true] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [key]=[id] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [user]=[180001] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:401 DEBUG in xml_odbc_search, header [domain]=[192.168.1.134] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:319 DEBUG GOING TO RENDER TEMPLATE [default] 2009-09-05 16:31:29.854400 [INFO] mod_xml_odbc.c:214 DEBUG Performing Query: SELECT enabled, sip_password, account_id FROM agent WHERE sip_user = 180001 2009-09-05 16:31:29.855416 [INFO] mod_xml_odbc.c:214 DEBUG Performing Query: SELECT sip_password FROM agent WHERE sip_user = 180001 2009-09-05 16:31:29.855416 [INFO] mod_xml_odbc.c:417 Debug dump of generated XML: <document type="freeswitch/xml"> <section name="directory"> <domain name="192.168.1.134"> <user id="180001"> <params> <param name="password" value="111111"></param> </params> <variables> <variable name="account_id" value="18"></variable> </variables> </user> </domain> </section> </document> 2009-09-05 16:31:29.856442 [CONSOLE] mod_xml_odbc.c:457 Generated XML is in [/tmp/16d2f01a-4332-43ff-9535-5615a192b40e.tmp.xml] 2009-09-05 16:31:29.856442 [ERR] mod_dptools.c:2430 No dial-string available, please check your user directory. 2009-09-05 16:31:29.856442 [ERR] switch_ivr_originate.c:1527 Cannot create outgoing channel of type [user] cause: [MANDATORY_IE_MISSING]
_______________________________________________ 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