radius server 2.1.6 not storing data in radacct

[ramesh p]

On Mon, Aug 10, 2009 at 4:23 PM, ramesh p <rock786143 at gmail.com> wrote:

>  >fromt he debug looks like its not doing any SQL thing at all -
> >ie you either havent configured the SQL stuff (uncomment
> >an 'include' statement in the cofngi to pull in sql.conf
> >or, because you arent using SQL for authentication/authorization
> >and only for logging you have to add 'sql' to the instantiate
> >section so the module gets fired up
> I have uncommented sql.conf under module configuration section of
> radiusd.conf
>
> $INCLUDE sql.conf
> ..
>
> And added stmt "sql" to instantiate section.
>
> and still am not able to see records in radacct table.
>
> Thanks,
> Rams.
>
>
>
>
>> ------------------------------
>>
>> Message: 4
>> Date: Mon, 10 Aug 2009 10:34:35 +0100
>> From: Alan Buxey <A.L.M.Buxey at lboro.ac.uk>
>> Subject: Re: radius server 2.1.6 not storing data in radacct
>>        table..help
>> To: FreeRadius users mailing list
>>        <freeradius-users at lists.freeradius.org>
>> Message-ID: <20090810093435.GA13680 at lboro.ac.uk>
>> Content-Type: text/plain; charset=us-ascii
>>
>> hi,
>>
>> fromt he debug looks like its not doing any SQL thing at all -
>> ie you either havent configured the SQL stuff (uncomment
>> an 'include' statement in the cofngi to pull in sql.conf
>> or, because you arent using SQL for authentication/authorization
>> and only for logging you have to add 'sql' to the instantiate
>> section so the module gets fired up
>>
>> alan
>>
>>
>> ------------------------------
>>
>> Message: 5
>> Date: Mon, 10 Aug 2009 15:40:12 +0500
>> From: "Nadir M. Aliyev" <nadir at ultel.net>
>> To: <freeradius-users at lists.freeradius.org>
>> Message-ID:
>>        <!~!
>> UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAANJZwrxjEZEaUwy61645wl8KAAAAQAAAA623CuuOKtESprsBks9KekQEAAAAA at ultel.net
>> >
>>
>> Content-Type: text/plain; charset="koi8-r"
>>
>> Dear All!
>>
>>
>>
>> Have small problem with radclient.
>>
>>
>>
>> I use radclient for disconnect users:
>>
>>
>> "Acct-Session-Id={ACTSESSION}\nUser-Name={MYUSERNAME}\nX-Ascend-Session-Svr-
>> Key={SESSIONKEY}\nNAS-IP-Address=10.0.5.1" | radclient -x 10.0.5.1:3799
>> disconnect 123";
>>
>>
>>
>> Users disconnects well.
>>
>> But  instead of successfull i receive this message:
>>
>>
>>
>> ad_recv: Disconnect-NAK packet from host 10.0.5.1:3799, id=236, length=47
>>
>>        Reply-Message = "No Matching Session"
>>
>>        Error-Cause = Session-Context-Not-Found
>>
>>
>>
>>
>>
>> Logs from cisco:
>>
>> Aug 10 14:29:34 10.0.5.1 360982: 421932: Aug 10 14:26:00.414 AZST: POD:
>> Received Acct-Session-Id of 0002A89C
>>
>> Aug 10 14:29:34 10.0.5.1 360983: 421933: Aug 10 14:26:00.414 AZST: POD:
>> Converted to internal Session-Id of 0002A89C
>>
>> Aug 10 14:29:34 10.0.5.1 360984: 421934: Aug 10 14:26:00.414 AZST: POD:
>> 10.0.5.2 user nadiritus 0.0.0.0 sessid 0x2A89C key 0x9F282A8D
>>
>> Aug 10 14:29:34 10.0.5.1 360985: 421935: Aug 10 14:26:00.414 AZST: POD:
>> Line     User     IDB          Session Id Key
>>
>> Aug 10 14:29:34 10.0.5.1 360986: 421936: Aug 10 14:26:00.414 AZST: POD:
>> KILL
>> Virtual- nadiritus 10.0.5.25 0x2A89C    0x9F282A8D
>>
>> Aug 10 14:29:34 10.0.5.1 360987: 421937: Aug 10 14:26:00.418 AZST: POD:
>> Added Reply Message: Session Not Removed
>>
>> Aug 10 14:29:34 10.0.5.1 360988: 421938: Aug 10 14:26:00.418 AZST: POD:
>> Added NACK Error Cause: Session Context Not Removable
>>
>> Aug 10 14:29:34 10.0.5.1 360989: 421939: Aug 10 14:26:00.418 AZST: POD:
>> Sending NAK from port 3799 to 10.0.5.2/54033
>>
>>
>>
>> Anybody can help me? Why I reveice that session not removed? (but session
>> removed)
>>
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> https://lists.freeradius.org/pipermail/freeradius-users/attachments/20090810/025a9e8e/attachment.html
>> >
>>
>> ------------------------------
>>
>> Message: 6
>> Date: Mon, 10 Aug 2009 10:51:07 +0100
>> From: Alan Buxey <A.L.M.Buxey at lboro.ac.uk>
>> Subject: Re: your mail
>> To: FreeRadius users mailing list
>>        <freeradius-users at lists.freeradius.org>
>> Message-ID: <20090810095107.GA13695 at lboro.ac.uk>
>> Content-Type: text/plain; charset=us-ascii
>>
>> Hi,
>>
>> > I use radclient for disconnect users:
>> >
>> >
>> "Acct-Session-Id={ACTSESSION}\nUser-Name={MYUSERNAME}\nX-Ascend-Session-Svr-
>> > Key={SESSIONKEY}\nNAS-IP-Address=10.0.5.1" | radclient -x 10.0.5.1:3799
>> > disconnect 123";
>>
>> you're telling the NAS about itself (NAS-IP-Address) - perhaps it doesnt
>> like
>> that bit and the message you are getting is just its way of saying
>> that something wasnt quite right. ie try
>>
>> "Acct-Session-Id={ACTSESSION}\nUser-Name={MYUSERNAME}\nX-Ascend-Session-Svr-Key={SESSIONKEY}"
>> | radclient -x 10.0.5.1:3799
>> disconnect 123";
>>
>> ?
>>
>>
>> alan
>>
>>
>> ------------------------------
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>>
>> End of Freeradius-Users Digest, Vol 52, Issue 48
>> ************************************************
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090810/4eb40866/attachment.html>