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

[M. Stephen]

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? 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