<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Revisiting this problem a few months later. Now running Freeside
4.2 and this issue persists.</p>
<p>With two Exports configured for sqlradius: changes to passwords,
assigned IP Address, and username only get written to the first
sqlradius Export listed.</p>
<p>If I run /usr/bin/freeside-sqlradius-reset ian to reset all sql
radius servers (there are only 2 although they are Exports #1 and
#3) they both get deleted, but radcheck and radreply do not get
written to the second export, although nas and radgroupreply do.<br>
</p>
<p>I've found that Freeside will only do a 'full' export to
whichever server is configured as Export #1. <br>
</p>
<p>So when running :<br>
</p>
<p>guest@freesidedev:/var/log$ sudo su - freeside<br>
$ /usr/bin/freeside-sqlradius-reset ian 3<br>
Subroutine JSON::XS::Boolean::(0+ redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
Subroutine JSON::XS::Boolean::(-- redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
Subroutine JSON::XS::Boolean::(++ redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
FS::part_event::Condition::payby is disabled; skipping</p>
<p>Export deletes all records and then stops after writing nas and
radgroupreply to Export #3</p>
<p>I then swapped the IP Addresses of Export #1 and #3 and run this<br>
</p>
<p>$ /usr/bin/freeside-sqlradius-reset ian 1<br>
Subroutine JSON::XS::Boolean::(0+ redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
Subroutine JSON::XS::Boolean::(++ redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
Subroutine JSON::XS::Boolean::(-- redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
FS::part_event::Condition::payby is disabled; skipping<br>
$</p>
<p>And export writes all data to Export #1 (formerly Export #3
above) <br>
</p>
<p>So I then run <br>
</p>
<p>$ /usr/bin/freeside-sqlradius-reset ian<br>
Subroutine JSON::XS::Boolean::(0+ redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
Subroutine JSON::XS::Boolean::(-- redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
Subroutine JSON::XS::Boolean::(++ redefined at
/usr/share/perl/5.20/overload.pm line 50.<br>
FS::part_event::Condition::payby is disabled; skipping</p>
<p>And Export deletes both Radius databases and writes ALL records
to Export #1 and then stops writing to Export #3 after nas and
radgroupreply (which is the previous Export #1) so I know it's not
my Radius/mysql servers. <br>
</p>
<p>Swapped the IP Addresses back and run $
/usr/bin/freeside-sqlradius-reset ian again and both databases
are deleted but again only the Export#1 is fully rewritten.<br>
</p>
<p>It looks like there's a bug here somewhere but....<br>
</p>
<p>Thanks,</p>
<p>Ian<br>
</p>
<br>
<div class="moz-cite-prefix">On 21/11/2016 3:30 PM, Ian Fraser
wrote:<br>
</div>
<blockquote
cite="mid:1993b8fd-7bbe-ef91-5534-f7256e7608ff@gozoom.ca"
type="cite">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<p><br>
</p>
<p>I'm changing my Radius configuration and so I've added another
Radius export to Freeside. <br>
</p>
<p>When I run /usr/bin/freeside-sqlradius-reset<i> <user></i>
Freeside only populates the nas and radgroupreply field in the
New Radius server, it will not populate the radcheck field on
the new server. <br>
</p>
<p>So I cloned all the data from the existing database to the New
server and Freeside deleted the radcheck table and did not
repopulate it. <br>
</p>
<p>I must be missing a step but it's been so long since I setup
Freeside I don't recall.</p>
<p><br>
</p>
<p>Thanks,<br>
</p>
<pre class="moz-signature" cols="72">--
Ian Fraser
goZoom.ca Inc.
195 Libby's Rd. McNab-Braeside
K7S0E1
877(613) 622 0093 ext 21
</pre>
</blockquote>
<br>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br />
<table style="border-top: 1px solid #D3D4DE;">
<tr>
<td style="width: 55px; padding-top: 13px;"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" width="46" height="29" style="width: 46px; height: 29px;" /></a></td>
<td style="width: 470px; padding-top: 12px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: #4453ea;">www.avg.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body>
</html>