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
- nginx_1 | [2e898f5449e9] - - [05/Dec/2020:18:56:42 +0530] "POST
/api/v1/postauth/ HTTP/1.1" status: 201 0 "-" "FreeRADIUS 3.0.19"
http_x_forwarded_for: - - remote_addr: 172.20.1.13 - realip_remote_addr:
172.20.1.13 - real_ip: 172.20.1.13
- radius_1 | [0b150222d3ca] - pid: 28 172.20.1.13 (-) {42 vars in
643 bytes} [Sat Dec 5 18:56:42 2020] POST /api/v1/postauth/ => generated 0
bytes in 47 msecs (HTTP/1.1 201) 4 headers in 116 bytes (1 switches on core
1)
- freeradius_1 | Sat Dec 5 18:56:42 2020 : Auth: (12) Login incorrect
(dailycounter: rlm_sql_postgresql: ERROR: function greater(integer,
integer) does not exist): [ms2/<no User-Password attribute>] (from client
radius_clients port 12 cli 08:00:27:A8:73:CB)
- nginx_1 | [2e898f5449e9] - - [05/Dec/2020:18:57:00 +0530] "GET
/controller/vpn/checksum/1fa6ad20-772e-4b06-af5c-76eada44297d/?key=bp4InTZ9zdcljeF2kjhAzCKRujdXeijB
HTTP/1.1" status: 200 32 "-" "Wget" http_x_forwarded_for: - - remote_addr:
172.20.1.6 - realip_remote_addr: 172.20.1.6 - real_ip: 172.20.1.6
- controller_1 | [b55d2bf3fe41] - pid: 14 172.20.1.6 (-) {32 vars in
552 bytes} [Sat Dec 5 18:57:00 2020] GET
/controller/vpn/checksum/1fa6ad20-772e-4b06-af5c-76eada44297d/?key=bp4InTZ9zdcljeF2kjhAzCKRujdXeijB
=> generated 32 bytes in 54 msecs (HTTP/1.1 200) 5 headers in 137 bytes (1
switches on core 1)
-
--
You received this message because you are subscribed to the Google Groups
"OpenWISP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web, visit
https://groups.google.com/d/msgid/openwisp/1a55824a-57d8-4df5-906a-22220bcc4a99n%40googlegroups.com.
