Unexpected closed sessions in database

Arran Cudbard-Bell a.cudbard-bell at sussex.ac.uk
Sat Feb 14 11:08:37 CET 2009


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marinko Tarlac wrote:
> Hi friends.
>
> I have small problem with freeradius and accounting (with
> database). Something is closing opened sessions and I can't see
> what is the reason. It seems that accounting_onoff_query was
> triggered by "something" and acctterminatecause field is empty so I
> don't see anything.
>
> accounting_onoff_query = "\ UPDATE ${acct_table1} \ SET \
> acctstoptime       =  '%S', \ acctsessiontime    =
> unix_timestamp('%S') - \ unix_timestamp(acctstarttime), \
> acctterminatecause =  '%{Acct-Terminate-Cause}', \ acctstopdelay
> =  '%{%{Acct-Delay-Time}:-0}', \ vrijeme            =  '%S' \ WHERE
> acctstoptime   =  0 \ #          WHERE acctstoptime IS NULL \ AND
> nasipaddress      =  '%{NAS-IP-Address}' \ AND acctstarttime     <=
> '%S'"
>
> Session is still alive in NAS but just like I said, account.
> doesn't work. I'm using old sql schema so WHERE acctstoptime IS
> NULL \ is commented and replaced with WHERE acctstoptime   =  0 \
>
> in sql.conf i set no for deletestalesessions because I don't need
> this function.
>
> # Remove stale session if checkrad does not see a double login
> deletestalesessions = no
>
> FreeRadius is 2.1.3
>
> Any ideas how to trace and solve this problem ?
Could be buggy NAS ? Check detail logs for Accounting-Requests with an
Acct-Status-Type of Accounting-On or Accounting-Off.

Also check that Accounting-Requests are being sent with the
NAS-IP-Address attribute set correctly.

Regards,
Arran

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkmWmCUACgkQcaklux5oVKLPeACfdn+6q6qE1XdWUPQBHDk8lRC8
KJYAoJGbgWHWdd2eUnUnDmDUn/JrLoT8
=ruu/
-----END PGP SIGNATURE-----




More information about the Freeradius-Users mailing list