[Freeswitch-users] need help with mod_xml_odbc

Juan Backson juanbackson at gmail.com
Thu Aug 27 04:40:37 PDT 2009


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
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">

        <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"/>


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




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?

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

More information about the FreeSWITCH-users mailing list