Problem when trying to authenticate

21 views
Skip to first unread message

MA S

unread,
Dec 5, 2020, 8:32:44 AM12/5/20
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
    • 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)
    Reply all
    Reply to author
    Forward
    0 new messages