Ta wiadomość e-mail jest wolna od wirusów i złośliwego oprogramowania, ponieważ ochrona avast! Antivirus jest aktywna.
Coś masz kolego nie tak. Parametr Interim-Update konfiguruje się na mikrotiku(koncentratorze). Wpisy dotyczące aktualizacji danych powinny wyglądać tak:
accounting_onoff_query = "UPDATE ${acct_table1} \
SET AcctStopTime='%S', \
AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), \
AcctTerminateCause='%{Acct-Terminate-Cause}', \
AcctStopDelay = '%{Acct-Delay-Time}' \
WHERE AcctSessionTime=0 \
AND AcctStopTime=0 \
AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
accounting_update_query = "UPDATE ${acct_table1} \
SET FramedIPAddress = '%{Framed-IP-Address}', \
AcctSessionTime = '%{Acct-Session-Time}', \
AcctInputOctets = '%{Acct-Input-Octets}', \
AcctOutputOctets = '%{Acct-Output-Octets}' \
WHERE AcctSessionId = '%{Acct-Session-Id}' \
AND UserName = '%{SQL-User-Name}' \
AND NASIPAddress= '%{NAS-IP-Address}'"
accounting_start_query = "INSERT into ${acct_table1} \
(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, \
NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, \
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, \
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, \
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) \
VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', \
'%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', \
'%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', \
'%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', \
'%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')"
accounting_stop_query = "UPDATE ${acct_table2} \
SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', \
AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', \
AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', \
ConnectInfo_stop = '%{Connect-Info}' \
WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' \
AND NASIPAddress = '%{NAS-IP-Address}';\
UPDATE nodes SET lastonline = unix_timestamp() WHERE name='%{User-Name}'"
..................
pozdrawiam
Mb
From: lms [mailto:lms-bounces@lists.lms.org.pl] On Behalf Of Łukasz Łuczak
Sent: Monday, April 20, 2015 9:18 AM
To: lista użytkowników LMS
Subject: Re: [lms] statystyki klienta - freeradius
Re
Samego parametru Interim-Update nie moge znaleść w konfigach od freeradiusa
acct-update mam w sql.conf od zawsze, ale nie wydać w bazie w radacct nigdy aktualnych sessji tylko zawsze zamknięte.
sql.conf mam zrobionego na podstawie radius-lms.conf
accounting_update_query = "UPDATE ${acct_table1} \
SET FramedIPAddress = '%{Framed-IP-Address}', \
AcctSessionTime = '%{Acct-Session-Time}', \
AcctInputOctets = '%{Acct-Input-Octets}', \
AcctOutputOctets = '%{Acct-Output-Octets}' \
WHERE AcctSessionId = '%{Acct-Session-Id}' \
AND UserName = '%{SQL-User-Name}' \
AND NASIPAddress= '%{NAS-IP-Address}'"
accounting_update_query_alt = "INSERT into ${acct_table1} (AcctSessionId, AcctU
niqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSess
ionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledSta
tionId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay)
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm
}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{A
cct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-
Authentic}', '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}
', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Addre
ss}', '0')"