I launch the enviroment in my machine,all of the three containers run successfully.But when I used openvpn-client and the client.ovpn
to auth the service,I got auth-failed.I collected the logs as follow:
ovpn_1 | 192.168.124.16:32965 TLS: Initial packet from [AF_INET]192.168.124.16:32965, sid=7e8e40ea 1c49bffe
ovpn_1 | 192.168.124.16:32965 peer info: IV_VER=2.4.6
ovpn_1 | 192.168.124.16:32965 peer info: IV_PLAT=linux
ovpn_1 | 192.168.124.16:32965 peer info: IV_PROTO=2
ovpn_1 | 192.168.124.16:32965 peer info: IV_NCP=2
ovpn_1 | 192.168.124.16:32965 peer info: IV_LZ4=1
ovpn_1 | 192.168.124.16:32965 peer info: IV_LZ4v2=1
ovpn_1 | 192.168.124.16:32965 peer info: IV_LZO=1
ovpn_1 | 192.168.124.16:32965 peer info: IV_COMP_STUB=1
ovpn_1 | 192.168.124.16:32965 peer info: IV_COMP_STUBv2=1
ovpn_1 | 192.168.124.16:32965 peer info: IV_TCPNL=1
ovpn_1 | Tue Mar 5 17:06:04 2019 RADIUS-PLUGIN: FOREGROUND THREAD: New user.
ovpn_1 | Tue Mar 5 17:06:04 2019 RADIUS-PLUGIN: Fail to set value ATTRIB_NAS_Ip_Address.
ovpn_1 | Tue Mar 5 17:06:04 2019 RADIUS-PLUGIN: No attributes Acct Interim Interval or bad length.
ovpn_1 | Tue Mar 5 17:06:04 2019 RADIUS-PLUGIN: Client config file was not written, overwriteccfiles is false
ovpn_1 | .Tue Mar 5 17:06:04 2019 RADIUS-PLUGIN: FOREGROUND THREAD: Add user to map.
ovpn_1 | 192.168.124.16:32965 PLUGIN_CALL: POST /usr/lib/openvpn/radiusplugin.so/PLUGIN_AUTH_USER_PASS_VERIFY status=0
ovpn_1 | 192.168.124.16:32965 TLS: Username/Password authentication succeeded for username 'testing' [CN SET]
ovpn_1 | 192.168.124.16:32965 Control Channel: TLSv1.2, cipher TLSv1/SSLv3 ECDHE-RSA-AES128-SHA256
ovpn_1 | 192.168.124.16:32965 [testing] Peer Connection Initiated with [AF_INET]192.168.124.16:32965
ovpn_1 | testing/192.168.124.16:32965 MULTI_sva: pool returned IPv4=10.43.94.6, IPv6=(Not enabled)
ovpn_1 | Tue Mar 5 17:06:04 2019 RADIUS-PLUGIN: BACKGROUND-ACCT: Fail to set value ATTRIB_NAS_Ip_Address.
ovpn_1 | No value in the Attribute!
ovpn_1 | Tue Mar 5 17:06:04 2019 RADIUS-PLUGIN: BACKGROUND-ACCT: Fail to add attribute ATTRIB_NAS_Ip_Address.
freeradius_1 | (12) Received Accounting-Request Id 44 from 10.0.0.130:47546 to 10.0.0.132:1813 length 124
freeradius_1 | (12) User-Name = "testing"
freeradius_1 | (12) NAS-Port = 1
freeradius_1 | (12) Service-Type = Outbound-User
freeradius_1 | (12) Framed-Protocol = PPP
freeradius_1 | (12) Framed-IP-Address = 10.43.94.6
freeradius_1 | (12) Calling-Station-Id = "192.168.124.16"
freeradius_1 | (12) NAS-Identifier = "OpenVpn"
freeradius_1 | (12) Acct-Status-Type = Start
freeradius_1 | (12) Acct-Session-Id = "0154C4970869412AADDCB31682B0BCAE"
freeradius_1 | (12) NAS-Port-Type = Virtual
freeradius_1 | (12) # Executing section preacct from file /etc/raddb/sites-enabled/default
freeradius_1 | (12) preacct {
freeradius_1 | (12) policy mask_accounting_data {
freeradius_1 | (12) if ( yes == "no" ) {
freeradius_1 | (12) if ( yes == "no" ) -> FALSE
freeradius_1 | (12) } # policy mask_accounting_data = noop
freeradius_1 | (12) [preprocess] = ok
freeradius_1 | (12) policy acct_unique {
freeradius_1 | (12) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) {
freeradius_1 | (12) EXPAND %{string:Class}
freeradius_1 | (12) -->
freeradius_1 | (12) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE
freeradius_1 | (12) else {
freeradius_1 | (12) update request {
freeradius_1 | (12) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}
freeradius_1 | (12) --> 20053898ef643316d6ad912998984bfd
freeradius_1 | (12) &Acct-Unique-Session-Id := 20053898ef643316d6ad912998984bfd
freeradius_1 | (12) } # update request = noop
freeradius_1 | (12) } # else = noop
freeradius_1 | (12) } # policy acct_unique = noop
freeradius_1 | (12) suffix: Checking for suffix after "@"
freeradius_1 | (12) suffix: No '@' in User-Name = "testing", looking up realm NULL
freeradius_1 | (12) suffix: No such realm "NULL"
freeradius_1 | (12) [suffix] = noop
freeradius_1 | (12) [files] = noop
freeradius_1 | (12) } # preacct = ok
freeradius_1 | (12) # Executing section accounting from file /etc/raddb/sites-enabled/default
freeradius_1 | (12) accounting {
freeradius_1 | (12) sql: EXPAND %{tolower:type.%{Acct-Status-Type}.query}
freeradius_1 | (12) sql: --> type.start.query
freeradius_1 | (12) sql: Using query template 'query'
freeradius_1 | rlm_sql (sql): Reserved connection (16)
freeradius_1 | (12) sql: EXPAND %{User-Name}
freeradius_1 | (12) sql: --> testing
freeradius_1 | (12) sql: SQL-User-Name set to 'testing'
freeradius_1 | (12) sql: EXPAND %{User-Name}
freeradius_1 | (12) sql: --> testing
freeradius_1 | (12) sql: SQL-User-Name set to 'testing'
freeradius_1 | rlm_sql (sql): Reserved connection (15)
freeradius_1 | (12) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = "testing" ORDER BY priority LIMIT 1
freeradius_1 | rlm_sql (sql): Released connection (15)
freeradius_1 | Need 1 more connections to reach min connections (3)
freeradius_1 | rlm_sql (sql): Opening additional connection (17), 1 of 30 pending slots used
freeradius_1 | rlm_sql_mysql: Starting connect to MySQL server
freeradius_1 | rlm_sql_mysql: Connected to database 'radius' on mysql via TCP/IP, server version 5.7.22, protocol version 10
freeradius_1 | (12) sql: EXPAND INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, 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}', '%{sql:SELECT groupname FROM radusergroup WHERE username = "%{SQL-User-Name}" ORDER BY priority LIMIT 1}', '%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', FROM_UNIXTIME(%{integer:Event-Timestamp}), FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')
freeradius_1 | (12) sql: --> INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('0154C4970869412AADDCB31682B0BCAE', '20053898ef643316d6ad912998984bfd', 'testing', 'test', '', '10.0.0.130', '1', 'Virtual', FROM_UNIXTIME(1551805567), FROM_UNIXTIME(1551805567), NULL, '0', '', '', '', '0', '0', '', '192.168.124.16', '', 'Outbound-User', 'PPP', '10.43.94.6')
freeradius_1 | (12) sql: Executing query: INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('0154C4970869412AADDCB31682B0BCAE', '20053898ef643316d6ad912998984bfd', 'testing', 'test', '', '10.0.0.130', '1', 'Virtual', FROM_UNIXTIME(1551805567), FROM_UNIXTIME(1551805567), NULL, '0', '', '', '', '0', '0', '', '192.168.124.16', '', 'Outbound-User', 'PPP', '10.43.94.6')
freeradius_1 | (12) sql: ERROR: rlm_sql_mysql: ERROR 1054 (Unknown column 'groupname' in 'field list'): 42S22
freeradius_1 | (12) sql: SQL query returned: server error
freeradius_1 | rlm_sql (sql): Released connection (16)
freeradius_1 | (12) [sql] = fail
freeradius_1 | (12) } # accounting = fail
freeradius_1 | (12) Not sending reply to client.
freeradius_1 | (12) Finished request
freeradius_1 | (12) Cleaning up request packet ID 44 with timestamp +650
freeradius_1 | Waking up in 1.9 seconds.
freeradius_1 | (10) Cleaning up request packet ID 60 with timestamp +647
freeradius_1 | Ready to process requests
freeradius_1 | (13) Received Accounting-Request Id 44 from 10.0.0.130:55561 to 10.0.0.132:1813 length 124
freeradius_1 | (13) User-Name = "testing"
freeradius_1 | (13) NAS-Port = 1
freeradius_1 | (13) Service-Type = Outbound-User
freeradius_1 | (13) Framed-Protocol = PPP
freeradius_1 | (13) Framed-IP-Address = 10.43.94.6
freeradius_1 | (13) Calling-Station-Id = "192.168.124.16"
freeradius_1 | (13) NAS-Identifier = "OpenVpn"
freeradius_1 | (13) Acct-Status-Type = Start
freeradius_1 | (13) Acct-Session-Id = "0154C4970869412AADDCB31682B0BCAE"
freeradius_1 | (13) NAS-Port-Type = Virtual
freeradius_1 | (13) # Executing section preacct from file /etc/raddb/sites-enabled/default
freeradius_1 | (13) preacct {
freeradius_1 | (13) policy mask_accounting_data {
freeradius_1 | (13) if ( yes == "no" ) {
freeradius_1 | (13) if ( yes == "no" ) -> FALSE
freeradius_1 | (13) } # policy mask_accounting_data = noop
freeradius_1 | (13) [preprocess] = ok
freeradius_1 | (13) policy acct_unique {
freeradius_1 | (13) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) {
freeradius_1 | (13) EXPAND %{string:Class}
freeradius_1 | (13) -->
freeradius_1 | (13) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE
freeradius_1 | (13) else {
freeradius_1 | (13) update request {
freeradius_1 | (13) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}
freeradius_1 | (13) --> 20053898ef643316d6ad912998984bfd
freeradius_1 | (13) &Acct-Unique-Session-Id := 20053898ef643316d6ad912998984bfd
freeradius_1 | (13) } # update request = noop
freeradius_1 | (13) } # else = noop
freeradius_1 | (13) } # policy acct_unique = noop
freeradius_1 | (13) suffix: Checking for suffix after "@"
freeradius_1 | (13) suffix: No '@' in User-Name = "testing", looking up realm NULL
freeradius_1 | (13) suffix: No such realm "NULL"
freeradius_1 | (13) [suffix] = noop
freeradius_1 | (13) [files] = noop
freeradius_1 | (13) } # preacct = ok
freeradius_1 | (13) # Executing section accounting from file /etc/raddb/sites-enabled/default
freeradius_1 | (13) accounting {
freeradius_1 | (13) sql: EXPAND %{tolower:type.%{Acct-Status-Type}.query}
freeradius_1 | (13) sql: --> type.start.query
freeradius_1 | (13) sql: Using query template 'query'
freeradius_1 | rlm_sql (sql): Reserved connection (16)
freeradius_1 | (13) sql: EXPAND %{User-Name}
freeradius_1 | (13) sql: --> testing
freeradius_1 | (13) sql: SQL-User-Name set to 'testing'
freeradius_1 | (13) sql: EXPAND %{User-Name}
freeradius_1 | (13) sql: --> testing
freeradius_1 | (13) sql: SQL-User-Name set to 'testing'
freeradius_1 | rlm_sql (sql): Reserved connection (15)
freeradius_1 | (13) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = "testing" ORDER BY priority LIMIT 1
freeradius_1 | rlm_sql (sql): Released connection (15)
freeradius_1 | Need 8 more connections to reach 10 spares
freeradius_1 | rlm_sql (sql): Opening additional connection (18), 1 of 29 pending slots used
freeradius_1 | rlm_sql_mysql: Starting connect to MySQL server
freeradius_1 | rlm_sql_mysql: Connected to database 'radius' on mysql via TCP/IP, server version 5.7.22, protocol version 10
freeradius_1 | (13) sql: EXPAND INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, 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}', '%{sql:SELECT groupname FROM radusergroup WHERE username = "%{SQL-User-Name}" ORDER BY priority LIMIT 1}', '%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', FROM_UNIXTIME(%{integer:Event-Timestamp}), FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')
freeradius_1 | (13) sql: --> INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('0154C4970869412AADDCB31682B0BCAE', '20053898ef643316d6ad912998984bfd', 'testing', 'test', '', '10.0.0.130', '1', 'Virtual', FROM_UNIXTIME(1551805570), FROM_UNIXTIME(1551805570), NULL, '0', '', '', '', '0', '0', '', '192.168.124.16', '', 'Outbound-User', 'PPP', '10.43.94.6')
freeradius_1 | (13) sql: Executing query: INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('0154C4970869412AADDCB31682B0BCAE', '20053898ef643316d6ad912998984bfd', 'testing', 'test', '', '10.0.0.130', '1', 'Virtual', FROM_UNIXTIME(1551805570), FROM_UNIXTIME(1551805570), NULL, '0', '', '', '', '0', '0', '', '192.168.124.16', '', 'Outbound-User', 'PPP', '10.43.94.6')
freeradius_1 | (13) sql: ERROR: rlm_sql_mysql: ERROR 1054 (Unknown column 'groupname' in 'field list'): 42S22
freeradius_1 | (13) sql: SQL query returned: server error
freeradius_1 | rlm_sql (sql): Released connection (16)
freeradius_1 | (13) [sql] = fail
freeradius_1 | (13) } # accounting = fail
freeradius_1 | (13) Not sending reply to client.
freeradius_1 | (13) Finished request
freeradius_1 | (13) Cleaning up request packet ID 44 with timestamp +653
freeradius_1 | Ready to process requests
freeradius_1 | (14) Received Accounting-Request Id 44 from 10.0.0.130:42505 to 10.0.0.132:1813 length 124
freeradius_1 | (14) User-Name = "testing"
freeradius_1 | (14) NAS-Port = 1
freeradius_1 | (14) Service-Type = Outbound-User
freeradius_1 | (14) Framed-Protocol = PPP
freeradius_1 | (14) Framed-IP-Address = 10.43.94.6
freeradius_1 | (14) Calling-Station-Id = "192.168.124.16"
freeradius_1 | (14) NAS-Identifier = "OpenVpn"
freeradius_1 | (14) Acct-Status-Type = Start
freeradius_1 | (14) Acct-Session-Id = "0154C4970869412AADDCB31682B0BCAE"
freeradius_1 | (14) NAS-Port-Type = Virtual
freeradius_1 | (14) # Executing section preacct from file /etc/raddb/sites-enabled/default
freeradius_1 | (14) preacct {
freeradius_1 | (14) policy mask_accounting_data {
freeradius_1 | (14) if ( yes == "no" ) {
freeradius_1 | (14) if ( yes == "no" ) -> FALSE
freeradius_1 | (14) } # policy mask_accounting_data = noop
freeradius_1 | (14) [preprocess] = ok
freeradius_1 | (14) policy acct_unique {
freeradius_1 | (14) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) {
freeradius_1 | (14) EXPAND %{string:Class}
freeradius_1 | (14) -->
freeradius_1 | (14) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE
freeradius_1 | (14) else {
freeradius_1 | (14) update request {
freeradius_1 | (14) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}
freeradius_1 | (14) --> 20053898ef643316d6ad912998984bfd
freeradius_1 | (14) &Acct-Unique-Session-Id := 20053898ef643316d6ad912998984bfd
freeradius_1 | (14) } # update request = noop
freeradius_1 | (14) } # else = noop
freeradius_1 | (14) } # policy acct_unique = noop
freeradius_1 | (14) suffix: Checking for suffix after "@"
freeradius_1 | (14) suffix: No '@' in User-Name = "testing", looking up realm NULL
freeradius_1 | (14) suffix: No such realm "NULL"
freeradius_1 | (14) [suffix] = noop
freeradius_1 | (14) [files] = noop
freeradius_1 | (14) } # preacct = ok
freeradius_1 | (14) # Executing section accounting from file /etc/raddb/sites-enabled/default
freeradius_1 | (14) accounting {
freeradius_1 | (14) sql: EXPAND %{tolower:type.%{Acct-Status-Type}.query}
freeradius_1 | (14) sql: --> type.start.query
freeradius_1 | (14) sql: Using query template 'query'
freeradius_1 | rlm_sql (sql): Reserved connection (17)
freeradius_1 | (14) sql: EXPAND %{User-Name}
freeradius_1 | (14) sql: --> testing
freeradius_1 | (14) sql: SQL-User-Name set to 'testing'
freeradius_1 | (14) sql: EXPAND %{User-Name}
freeradius_1 | (14) sql: --> testing
freeradius_1 | (14) sql: SQL-User-Name set to 'testing'
freeradius_1 | rlm_sql (sql): Reserved connection (16)
freeradius_1 | (14) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = "testing" ORDER BY priority LIMIT 1
freeradius_1 | rlm_sql (sql): Released connection (16)
freeradius_1 | Need 7 more connections to reach 10 spares
freeradius_1 | rlm_sql (sql): Opening additional connection (19), 1 of 28 pending slots used
freeradius_1 | rlm_sql_mysql: Starting connect to MySQL server
freeradius_1 | rlm_sql_mysql: Connected to database 'radius' on mysql via TCP/IP, server version 5.7.22, protocol version 10
freeradius_1 | (14) sql: EXPAND INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, 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}', '%{sql:SELECT groupname FROM radusergroup WHERE username = "%{SQL-User-Name}" ORDER BY priority LIMIT 1}', '%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', FROM_UNIXTIME(%{integer:Event-Timestamp}), FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')
freeradius_1 | (14) sql: --> INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('0154C4970869412AADDCB31682B0BCAE', '20053898ef643316d6ad912998984bfd', 'testing', 'test', '', '10.0.0.130', '1', 'Virtual', FROM_UNIXTIME(1551805573), FROM_UNIXTIME(1551805573), NULL, '0', '', '', '', '0', '0', '', '192.168.124.16', '', 'Outbound-User', 'PPP', '10.43.94.6')
freeradius_1 | (14) sql: Executing query: INSERT INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('0154C4970869412AADDCB31682B0BCAE', '20053898ef643316d6ad912998984bfd', 'testing', 'test', '', '10.0.0.130', '1', 'Virtual', FROM_UNIXTIME(1551805573), FROM_UNIXTIME(1551805573), NULL, '0', '', '', '', '0', '0', '', '192.168.124.16', '', 'Outbound-User', 'PPP', '10.43.94.6')
freeradius_1 | (14) sql: ERROR: rlm_sql_mysql: ERROR 1054 (Unknown column 'groupname' in 'field list'): 42S22
freeradius_1 | (14) sql: SQL query returned: server error
freeradius_1 | rlm_sql (sql): Released connection (17)
freeradius_1 | (14) [sql] = fail
freeradius_1 | (14) } # accounting = fail
freeradius_1 | (14) Not sending reply to client.
freeradius_1 | (14) Finished request
freeradius_1 | (14) Cleaning up request packet ID 44 with timestamp +656
freeradius_1 | Ready to process requests
ovpn_1 | Tue Mar 5 17:06:13 2019 RADIUS-PLUGIN: BACKGROUND ACCT: Error: Start packet couldn't send.
ovpn_1 |
ovpn_1 | !
ovpn_1 | Tue Mar 5 17:06:13 2019 Error: RADIUS-PLUGIN: FOREGROUND: Accounting failed for user:testing!
ovpn_1 |
ovpn_1 | testing/192.168.124.16:32965 PLUGIN_CALL: POST /usr/lib/openvpn/radiusplugin.so/PLUGIN_CLIENT_CONNECT status=1
ovpn_1 | testing/192.168.124.16:32965 PLUGIN_CALL: plugin function PLUGIN_CLIENT_CONNECT failed with status 1: /usr/lib/openvpn/radiusplugin.so
ovpn_1 | testing/192.168.124.16:32965 WARNING: client-connect plugin call failed
ovpn_1 | testing/192.168.124.16:32965 PUSH: Received control message: 'PUSH_REQUEST'
ovpn_1 | testing/192.168.124.16:32965 Delayed exit in 5 seconds
ovpn_1 | testing/192.168.124.16:32965 SENT CONTROL [testing]: 'AUTH_FAILED' (status=1)
ovpn_1 | testing/192.168.124.16:32965 PUSH: Received control message: 'PUSH_REQUEST'
ovpn_1 | testing/192.168.124.16:32965 Delayed exit in 5 seconds
ovpn_1 | testing/192.168.124.16:32965 SENT CONTROL [testing]: 'AUTH_FAILED' (status=1)
ovpn_1 | testing/192.168.124.16:32965 SIGTERM[soft,delayed-exit] received, client-instance exiting
I noticed that there are some errors between freeradius and mysql query.Have you got the error in your testing?