[Freeswitch-users] need help with mod_xml_odbc

[Juan Backson]

Hi,

Finally, I got xml_odbc running, but it does not really work well for me.  I
am getting:
2009-08-28 03:33:47.459383 [ERR] mod_xml_odbc.c:325 Stopped rendering
template, called xml_odbc_render_template more than [32] times, probably
looping.
2009-08-28 03:33:47.459383 [ERR] mod_xml_odbc.c:408 Something went horribly
wrong while generating an XML template!

My config is:
<configuration name="xml_odbc.conf" description="XML ODBC Configuration">

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

  <templates>

    <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}"/>
        <domain name="${domain}">
          <user id="${user}">
            <params>
              <xml-odbc-do name="query" value="SELECT sip_password FROM
agent WHERE sip_user = ${user}">
                <param name="password", value="${sip_password}"/>
              </xml-odbc-do>
            </params>
              </user>
        </domain>


        </section>
      </document>
    </template>

  </templates>

</configuration>


Since these two queries get data from the same table, I tried to merge them,
but could not get it to work.

Anyone has any idea?

Thanks,
JB
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090827/009e6d6d/attachment-0002.html