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

[Ivan Kohler]

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