You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to OpenWISP
I apologize for inconveniencing you, but I need your help in solving this problem
This log appears when trying to authenticate
radius_1 | [0b150222d3ca] - pid: 28 172.20.1.13 (-) {42 vars in 643 bytes} [Sat Dec 5 18:56:41 2020] POST /api/v1/authorize/ => generated 0 bytes in 285 msecs (HTTP/1.1 200) 4 headers in 111 bytes (1 switches on core 0)
postgres_1 | 2020-12-05 18:56:42.015 IST [274] ERROR: function greater(integer, integer) does not exist at character 30
postgres_1 | 2020-12-05 18:56:42.015 IST [274] HINT: No function matches the given name and argument types. You might need to add explicit type casts.
postgres_1 | 2020-12-05 18:56:42.015 IST [274] STATEMENT: SELECT SUM(AcctSessionTime - GREATER((1607106600 - AcctStartTime::ABSTIME::INT4), 0)) FROM radacct WHERE UserName='ms2' AND AcctStartTime::ABSTIME::INT4 + AcctSessionTime > '1607106600'
freeradius_1 | Sat Dec 5 18:56:42 2020 : Error: rlm_sql_postgresql: 42883: UNDEFINED FUNCTION
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailycounter: ERROR: rlm_sql_postgresql: ERROR: function greater(integer, integer) does not exist
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailycounter: ERROR: rlm_sql_postgresql: LINE 1: SELECT SUM(AcctSessionTime - GREATER((1607106600 - AcctStart...
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailycounter: ERROR: rlm_sql_postgresql: ^
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailycounter: ERROR: rlm_sql_postgresql: HINT: No function matches the given name and argument types. You might need to add explicit type casts.
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailycounter: ERROR: SQL query failed: server error
postgres_1 | 2020-12-05 18:56:42.038 IST [274] ERROR: function unix_timestamp(timestamp with time zone) does not exist at character 122
postgres_1 | 2020-12-05 18:56:42.038 IST [274] HINT: No function matches the given name and argument types. You might need to add explicit type casts.
postgres_1 | 2020-12-05 18:56:42.038 IST [274] STATEMENT: SELECT SUM(acctinputoctets + acctoutputoctets) FROM radacct WHERE UserName='ms2' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1607106600'
freeradius_1 | Sat Dec 5 18:56:42 2020 : Error: rlm_sql_postgresql: 42883: UNDEFINED FUNCTION
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailybandwidthcounter: ERROR: rlm_sql_postgresql: ERROR: function unix_timestamp(timestamp with time zone) does not exist
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailybandwidthcounter: ERROR: rlm_sql_postgresql: LINE 1: ... WHERE UserName='ms2' AND UNIX_TIMES...
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailybandwidthcounter: ERROR: rlm_sql_postgresql: ^
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailybandwidthcounter: ERROR: rlm_sql_postgresql: HINT: No function matches the given name and argument types. You might need to add explicit type casts.
freeradius_1 | Sat Dec 5 18:56:42 2020 : ERROR: (12) dailybandwidthcounter: ERROR: SQL query failed: server error