<HTML>
<HEAD>
<TITLE>Freeradius' schema.sql breaks CDRTool</TITLE>
</HEAD>
<BODY>
<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>
</BODY>
</HTML>