[Freeswitch-users] need help with mod_xml_odbc

Juan Backson juanbackson at gmail.com
Thu Aug 27 06:53:42 PDT 2009

Hi Leon,

Thanks for your help.

I have changed it according to your comment but I am still getting the
looping error.

Would you please take a look see what else I did wrong?

Also, sip_user is an integer field, so I can't really use ''.  Is there
anyway to get around that?

<configuration name="xml_odbc.conf" description="XML ODBC Configuration">

        <param name="binding" value="directory"/>
    <param name="odbc-dsn" value="class5_odbc:root:abcd"/>
    <param name="debug" value="true"/>
    <param name="keep-files-around" value="true"/>


    <template name="default">
      <document type="freeswitch/xml">
        <section name="directory">
     <xml-odbc-do name="query" on-empty-result-break-to="not-found"
value="SELECT enabled, sip_password FROM agent WHERE sip_user =  ${user} and
        <domain name="${domain}">
          <user id="${user}">
              <xml-odbc-do name="query" value="SELECT sip_password FROM
agent WHERE sip_user = ${user}">
                <param name="password" value="${sip_password}"/>



        <document type="freeswitch/xml">
            <section name="result">
                <result status="not found"/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090827/de5d7b63/attachment-0002.html 

More information about the FreeSWITCH-users mailing list