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