I've found a way to test the accounting portion and just wanted to post it here.
echo "User-name= xxxx, NAS-Port-Id = 1, Acct-Session-Id = 10000, Acct-Status-Type = 1, Password = xxxxxx" | radclient hostname acct sharedsecret Acct-Status-Type = 1 starts the accounting. Nas-Port-Id is an arbitrary number, as is Acct-Session-Id. echo "User-name= xxxx, NAS-Port-Id = 1, Acct-Session-Id = 10000, Acct-Status-Type = 2, Password = xxxxxx" | radclient hostname acct sharedsecret Acct-Status-Type = 1 stops the accounting. And yes...It works! We have freeradius-0.9.3 working on RHEL 3.0 using RH's freeradius RPM and sending accounting info to Oracle. Authentication happens via pam. We had to build the rlm_sql_oracle driver from the freeradius-0.9.3.src.rpm because redhat didn't include it or the mysql, postgresql, or unixodbc drivers in their rpm. This involved modifiy the spec file and of course, installing the oracle client. Brian Dourty -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dourty, Brian R. (IATS) Sent: Wednesday, December 17, 2003 2:49 PM To: [EMAIL PROTECTED] Subject: RE: Sending accounting info to Oracle Oliver, Thanks for your reply. That makes sense now. Since I'm using the radtest utility to do my testing and not our actual NAS I won't see any accounting info. Duh... I used the radclient utility to send an acct request and I see in interacting with the accounting module now. Guess its time to point our NAS at it for some real testing. Sorry to waste your time. Thanks again, Brian D. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oliver Graf Sent: Wednesday, December 17, 2003 2:27 PM To: [EMAIL PROTECTED] Subject: Re: Sending accounting info to Oracle On Wed, Dec 17, 2003 at 01:45:55PM -0600, Dourty, Brian R. (IATS) wrote: > Shouldn't I see a call to the accounting module that tries to dump > accounting info to oracle? Why? You only show us Access-Requests in your debug output. Where are the Accounting-Requests radiusd should log? Did you configure your NAS to send them? Oliver. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
