Jack,<br><br><div class="gmail_quote">On Mon, Sep 3, 2012 at 11:21 AM, Jack Martin <span dir="ltr"><<a href="mailto:jack.d.martin@magicwisp.com" target="_blank">jack.d.martin@magicwisp.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I am under the assumption that I am making a small mistake in setting it up. Would you be willing to share how you made it work?<br clear="all"></blockquote></div><br><br>Our export is setup like this:<br><br><br>
<style type="text/css">
<!--
@page { margin: 0.79in }
TD P { margin-bottom: 0in }
P { margin-bottom: 0.08in }
CODE.cjk { font-family: "WenQuanYi Zen Hei Sharp", monospace }
CODE.ctl { font-family: "Lohit Devanagari", monospace }
A:link { so-language: zxx }
-->
</style>
<p style="margin-bottom:0.2in"><font size="6">Edit Export </font>
</p>
<form name="dummy">
<table cellpadding="2" cellspacing="0" width="264" bgcolor="#cccccc">
<colgroup><col width="84">
<col width="172">
</colgroup><tbody><tr>
<td style="border:none;padding:0in" width="84">
<p align="RIGHT">Export name</p>
</td>
<td style="border:none;padding:0in" width="172">
<p><input name="exportname" value="FreeRadius" style="width:1.71in;height:0.28in" type="TEXT">
</p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="84">
<p align="RIGHT">Export host</p>
</td>
<td style="border:none;padding:0in" width="172">
<p><input name="machine" value="mysql.domain.net" style="width:1.71in;height:0.28in" type="TEXT">
</p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="84">
<p align="RIGHT">Export</p>
</td>
<td style="border:none;padding:0in" width="172"><br></td>
</tr>
</tbody></table>
</form>
<div id="dsqlradius" dir="LTR">
<form name="sqlradius" action="http://process/part_export.cgi" method="POST">
<table cellpadding="2" cellspacing="0" width="797" bgcolor="#cccccc">
<colgroup><col width="126">
<col width="663">
</colgroup><tbody><tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Description</p>
</td>
<td style="border:none;padding:0in" width="663" bgcolor="#ffffff">
<p style="margin-bottom:0.2in">Real-time export of <b>radcheck</b>,
<b>radreply</b> and <b>usergroup</b>/<b>radusergroup</b> tables
to any SQL database for <a href="http://www.freeradius.org/">FreeRADIUS</a>
or <a href="http://radius.innercite.com/">ICRADIUS</a>. This
export does not export RADIUS realms (see also
sqlradius_withdomain). An existing RADIUS database will be
updated in realtime, but you can use <a href="http://www.freeside.biz/mediawiki/index.php/Freeside:1.9:Documentation:Developer/bin/freeside-sqlradius-reset">freeside-sqlradius-reset</a>
to delete the entire RADIUS database and repopulate the tables
from the Freeside database. See the <a href="http://search.cpan.org/dist/DBI/DBI.pm#connect">DBI
documentation</a> and the <a href="http://search.cpan.org/search?mode=module&query=DBD%3A%3A">documentation
for your DBD</a> for the exact syntax of a DBI data source.
</p>
<ul><li><p>Using FreeRADIUS 0.9.0 with the PostgreSQL backend, the
db_postgresql.sql schema and postgresql.conf queries contain
incompatible changes. This is fixed in 0.9.1. Only new installs
with 0.9.0 and PostgreSQL are affected - upgrades and other
database backends and versions are unaffected.
</p>
</li><li><p style="margin-bottom:0.2in">Using ICRADIUS, add a dummy
"op" column to your database:
</p>
<blockquote><code class="western">ALTER TABLE radcheck ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT '=='<br>ALTER TABLE radreply ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT '=='<br>ALTER TABLE radgroupcheck ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT '=='<br>
ALTER TABLE radgroupreply ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT '=='
</code>
</blockquote>
</li><li><p>Using Radiator, see the <a href="http://www.open.com.au/radiator/faq.html#38">Radiator
FAQ</a> for configuration information.
</p>
</li></ul>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">DBI data source
</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="datasrc" value="DBI:mysql:host=mysql.domain.net;dbname=radius" style="width:5.38in;height:0.28in" type="TEXT"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Database username</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="username" value="freeside" style="width:5.38in;height:0.28in" type="TEXT"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Database password</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="password" value="password" style="width:5.38in;height:0.28in" type="TEXT"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Group table</p>
</td>
<td style="border:none;padding:0in" width="663"><br></td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Ignore accounting records from this database</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="ignore_accounting" value="1" style="width:0.14in;height:0.14in" type="CHECKBOX"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Only process one realm of accounting records</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="process_single_realm" value="1" style="width:0.14in;height:0.14in" type="CHECKBOX"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">The realm of of accounting records to be
processed</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="realm" style="width:5.38in;height:0.28in" type="TEXT"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Ignore sessions which span billing periods</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="ignore_long_sessions" value="1" style="width:0.14in;height:0.14in" type="CHECKBOX"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Hide IP address information on session reports</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="hide_ip" value="1" style="width:0.14in;height:0.14in" type="CHECKBOX"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Hide download/upload information on session
reports</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="hide_data" value="1" style="width:0.14in;height:0.14in" type="CHECKBOX"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Show the Called-Station-ID on session reports</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="show_called_station" value="1" style="width:0.14in;height:0.14in" type="CHECKBOX"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Radius groups to assign to svc_acct which has
exceeded its bandwidth or time limit (if not overridden by
overlimit_groups global or per-agent config)</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><input name="overlimit_groups" style="width:5.38in;height:0.28in" type="TEXT"></p>
</td>
</tr>
<tr>
<td style="border:none;padding:0in" width="126">
<p align="RIGHT">Radius group mapping to reason (via template
user) (svcnum|username|username@domain reasonnum|reason)</p>
</td>
<td style="border:none;padding:0in" width="663">
<p><textarea name="groups_susp_reason" style="width:6.87in;height:1.29in"></textarea></p>
</td>
</tr>
</tbody></table>
</form>
</div>
<p style="margin-bottom:0in"><br>
</p>
Very simple - very basic. Works with our Freeradius database in MySQL.<br><br><br><br>Chris<br><br>-- <br>Chris Stone<br>AxisInternet, Inc.<br><a href="http://www.axint.net" target="_blank">www.axint.net</a><br>