<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Yes, use that file <span class="Apple-style-span" style="font-family: Tahoma; font-size: 13px; ">CDRTool/setup/radius/OpenSIPs/radacct.mysql</span></div><div><br></div><div>Adrian</div><div><br></div><div><br><div><div>On Dec 18, 2008, at 8:58 PM, Jeff Pyle wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div> <font face="Tahoma, Verdana, Helvetica, Arial"><span style="font-size:10pt">Hello,<br> <br> CDRTool’s INSTALL.txt says to use /usr/share/doc/freeradius/examples/db_mysql.sql.gz to create the Radius backend framework for DB storage. The closest file available in freeradius-server-2.1.3 is /usr/local/etc/raddb/sql/mysql/schema.sql. Unfortunately it creates all the field names in lowercase. While this doesn’t affect Radius, it does prevent CDRTool from querying much of the data. Perhaps using CDRTool/setup/radius/OpenSIPs/radacct.mysql might be a better option? It looks like radacct.mysql contains all the updates from radacct-patch.sh as well.<br> <br> - Jeff<br> </span></font> </div> _______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br></blockquote></div><br></div></body></html>