On 24.05.2018 11:59, Alexandr wrote:

I found function strftime, i think it writes time , but i found error contain strftime

(12) sql: ERROR: rlm_sql_mysql: ERROR 1305 (FUNCTION radius_serv.strftime does not exist): 42000 (12) sql: SQL query returned: server error

How do fix it?

 some sql queries ( insert / update)

INSERT:

rlm_sql (sql): Reserved connection (0) (11) sql: EXPAND %{User-Name} (11) sql:    --> systemn (11) sql: SQL-User-Name set to 'systemn' (11) sql: EXPAND INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', %{%{integer:Event-Timestamp}:-date('now')}, %{%{integer:Event-Timestamp}:-date('now')}, NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')

(11) sql:    --> INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('8D3C0B6681A85E4F', '4884926a9a6b3dadbdd270f22e5fd4c4', 'systemn', '', '192.168.10.26', '2', 'Wireless-802.11', 1527148106, 1527148106, NULL, '0', 'RADIUS', 'CONNECT 54Mbps 802.11g', '', '0', '0', '60-E3-27-72-BF-5A:DEvChata_new', '38-2D-D1-32-61-1E', '', 'Framed-User', '', '')

(11) sql: Executing query: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('8D3C0B6681A85E4F', '4884926a9a6b3dadbdd270f22e5fd4c4', 'systemn', '', '192.168.10.26', '2', 'Wireless-802.11', 1527148106, 1527148106, NULL, '0', 'RADIUS', 'CONNECT 54Mbps 802.11g', '', '0', '0', '60-E3-27-72-BF-5A:DEvChata_new', '38-2D-D1-32-61-1E', '', 'Framed-User', '', '')     (11) sql: SQL query returned: success     (11) sql: 1 record(s) updated

UPDATE:  rlm_sql (sql): Reserved connection (1)     (13) sql: EXPAND %{User-Name}     (13) sql:    --> systemn     (13) sql: SQL-User-Name set to 'systemn'     (13) sql: EXPAND UPDATE radacct SET acctstoptime    = %{%{integer:Event-Timestamp}:-date('now')}, acctsessiontime   = %{%{Acct-Session-Time}:-NULL}, acctinputoctets    = %{%{Acct-Input-Gigawords}:-0} << 32 | %{%{Acct-Input-Octets}:-0}, acctoutputoctets = %{%{Acct-Output-Gigawords}:-0} << 32 | %{%{Acct-Output-Octets}:-0}, acctterminatecause = '%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'

    (13) sql:    --> UPDATE radacct SET acctstoptime    = 1527150519, acctsessiontime   = 36, acctinputoctets   = 0 << 32 | 282380, acctoutputoctets = 0 << 32 | 1486385, acctterminatecause = 'User-Request', connectinfo_stop = 'CONNECT 54Mbps 802.11g' WHERE AcctUniqueId = '4ac1349d1e910f79fba700d0d1a1abba'

    (13) sql: Executing query: UPDATE radacct SET acctstoptime  = 1527150519, acctsessiontime   = 36, acctinputoctets   = 0 << 32 | 282380, acctoutputoctets = 0 << 32 | 1486385, acctterminatecause = 'User-Request', connectinfo_stop = 'CONNECT 54Mbps 802.11g' WHERE AcctUniqueId = '4ac1349d1e910f79fba700d0d1a1abba'

    rlm_sql_mysql: Rows matched: 1  Changed: 1  Warnings: 1     (13) sql: SQL query returned: success     (13) sql: 1 record(s) updated

On 23.05.2018 13:51, Alan DeKok wrote:

...

On May 23, 2018, at 4:00 AM, Alexandr<systemn17088@gmail.com> wrote:

...

freeradius -v3.0.18

Instead db mysql in table radacct shows incorrect time column acctstartime and acctstoptime in v.3 , if I will use v.2 or v.4 it will be ok. It's a bug ? Those times are created by the access point. FreeRADIUS just writes them to the database.

Run the server in debugging mode to see what's going on.

Alan DeKok.

- List info/subscribe/unsubscribe? Seehttp://www.freeradius.org/list/users.html