[freeside-users] freeside-sqlradius-radacctd complainig about svc_acct record

[M. Stephen]

I have one question to go about, as i am not used to 
internal scripts of freeside.

If I look at Schema.pm, I find this section with radius 
entities commented out. Are these radius attributes not 
required for usage billing?


#add radius attributes to svc_acct
#
#my($svc_acct)=$dbdef->table('svc_acct');
#
#my($attribute);
#foreach $attribute (@attributes) {
#  $svc_acct->addcolumn ( new DBIx::DBSchema::Column (
#    'radius_'. $attribute,
#    'varchar',
#    'NULL',
#    $char_d,
#  ));
#}
#
# foreach $attribute (@check_attributes) {
#   $svc_acct->addcolumn( new DBIx::DBSchema::Column (
#     'rc_'. $attribute,
#     'varchar',
#     'NULL',
#     $char_d,
#  ));
# }

______
Stemap





On Mon, 3 Dec 2007 13:41:31 -0800
  Ivan Kohler <ivan at sisd.com> wrote:
> On Tue, Dec 04, 2007 at 12:29:33AM +0300, M. Stephen 
>wrote:
>> I think freeside-sqlradius-radacctd is complainig as "no 
>> svc_acct record found" because freeside sends the 
>>username 
>> to freeside database as xxx at yyy.zzz but the internal 
>> stored UseRName is xxx. So when 
>> freeside-sqlradius-radacctd check record detail from 
>> radacct in freeradius database and compare to username 
>>in 
>> svc_acct, it finds no record as the usernames are 
>> different.
>> 
>> Is there a way to store the names in svc_acct table in 
>>the 
>> form of xxx at yyy.zzz?
> 
> No.  Usernames ("xxx") are stored in the svc_acct table, 
>and domains 
> ("yyy.zzz") are stored in the svc_domain table.
> 
> If you aren't finding the accounting records because 
>your RADIUS server 
> stores them differently than the ones we've written the 
>support against, 
> modify the lookup to find records the way Freeside 
>stores them: Lookup 
> the domain in svc_domain, then lookup the svc_acct with 
>username and 
> domsvc set to the svcnum of the domain you found. 
> 
> Don't kludge username at domain into the svc_acct.username 
>field.
> 
>For bonus points, make your changes conditional on a 
>configuration 
> option (so as not to disturb the default operation) and 
>submit them as a 
> patch for inclusion in the next release (diff -u format 
>preferred).
> 
> HTH.
> 
> -- 
> _ivan
> 
> 
> 
>> This should be taken from the new 
>> customer form section of UserName,Domain and password
>> 
>> ________
>> Stephen
>> 
>> 
>> 
> 
> 
> 
> 
>> On Mon, 3 Dec 2007 12:14:55 -0800
>>   Ivan Kohler <ivan at sisd.com> wrote:
>> > On Mon, Dec 03, 2007 at 11:06:55PM +0300, M. Stephen 
>> >wrote:
>> >> I downloaded November 2. Actually I just downloaded 
>>the 
>> >> cvs using the cvs command as follows
>> >> 
>> >> $ cvs checkout -r FREESIDE_1_7_BRANCH freeside
>> >> 
>> >> With the above command, I got full freeside 
>> >>distribution.
>> >> 
>> >> The skipped records does not contain uppercase
>> > 
>> > Okay, your problem is not the same as the one we fixed 
>> >some time ago on 
>> >FREESIDE_1_7_BRANCH, then.
>> > 
>> > No idea what's causing your problem; 
>> >freeside-sqlradius-radacctd is 
>> > working for us for several customers and has been for 
>> >somet time.
>> > 
>> > Let us know what you turn up.
>> > 
>> > -- 
>> > _ivan
>> > 
>> > 
>> >> On Sun, 2 Dec 2007 16:40:58 -0800
>> >>   Ivan Kohler <ivan at sisd.com> wrote:
>> >> > On Sat, Dec 01, 2007 at 09:42:48PM +0300, M. 
>>Stephen 
>> >> >wrote:
>> >> >> 
>> >> >> I am trying to do usage billing from freeradius. I 
>> >>want 
>> >> >>an 
>> >> >> account to get suspended when usage limit is 
>>reached.
>> >> >> 
>> >> >> On monitoring the freeside-sqlradius-radacctd 
>>(from 
>> >>the 
>> >> >> logs) I see it is complaining about svc_acct 
>>record. 
>> >>The 
>> >> >> message from the log file is as follows;
>> >> >> 
>> >> >> [Sat Dec  1 20:58:21 2007] [3886] WARNING: no 
>> >>svc_acct 
>> >> >> record found for RADIUS detail RadAcctID 91681 
>> >>(UserName 
>> >> >> xxx at yyy.com, Realm ) - skipping.
>> >> >> 
>> >> >> Monitoring the account from the billing interface, 
>>i 
>> >>can 
>> >> >> see the usage has exceeded the limit but not 
>> >>suspended.
>> >> >> 
>> >> >> I am using CVS branch FREESIDE_1_7_BRANCH
>> >> > 
>> >> > When did you last update?
>> >> > 
>> >> > Do the skipped records contain uppercase 
>>characters?
>> >> > 
>> >> > -- 
>> >> > _ivan
>> >> > _______________________________________________
>> >> > freeside-users mailing list
>> >> > freeside-users at sisd.com
>> >> > 
>>http://420.am/cgi-bin/mailman/listinfo/freeside-users
>> >> 
>> >> _______________________________________________
>> >> freeside-users mailing list
>> >> freeside-users at sisd.com
>> >> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>> > 
>> > -- 
>> > _ivan
>> > _______________________________________________
>> > freeside-users mailing list
>> > freeside-users at sisd.com
>> > http://420.am/cgi-bin/mailman/listinfo/freeside-users
>> 
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at sisd.com
>> http://420.am/cgi-bin/mailman/listinfo/freeside-users
> 
> -- 
> _ivan
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users