Hi,<br><br>Finally, I got xml_odbc running, but it does not really work well for me. I am getting:<br>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.<br>
2009-08-28 03:33:47.459383 [ERR] mod_xml_odbc.c:408 Something went horribly wrong while generating an XML template!<br><br>My config is:<br><configuration name="xml_odbc.conf" description="XML ODBC Configuration"><br>
<br> <settings><br> <param name="binding" value="directory"/><br> <param name="odbc-dsn" value="class5_odbc:root:JdqB-S"/><br> <param name="debug" value="true"/><br>
<param name="keep-files-around" value="true"/><br> </settings><br><br> <templates><br><br> <template name="default"><br> <document type="freeswitch/xml"><br>
<section name="directory"><br> <xml-odbc-do name="query" on-empty-result-break-to="not-found" value="SELECT enabled, sip_password FROM agent WHERE sip_user = ${user}"/><br>
<domain name="${domain}"><br> <user id="${user}"><br> <params><br> <xml-odbc-do name="query" value="SELECT sip_password FROM agent WHERE sip_user = ${user}"><br>
<param name="password", value="${sip_password}"/><br> </xml-odbc-do><br> </params><br> </user><br> </domain><br>
<br><br> </section><br> </document><br> </template><br><br> </templates><br><br></configuration><br><br><br>Since these two queries get data from the same table, I tried to merge them, but could not get it to work.<br>
<br>Anyone has any idea?<br><br>Thanks,<br>JB <br>