Имя пользователя Freeradius SQL установлено в ''
Я использую Freeradius с MySQL (в Docker с Alpine 3.7), но когда я пытаюсь подключиться, отправленное имя пользователя усекается, и мой запрос в MySQL поиска по пустому имени пользователя.
В моем query.conf я установил пользователю:
sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}"
Я получаю это сообщение, когда пытаюсь отправить аутентификацию. Имя пользователя не отправлено в мою базу данных в моей таблице "radpostauth", имя пользователя также пусто, но я получаю пароль и другие данные.
freeradius_1 | (0) Received Access-Request Id 32 from 10.224.100.252:53538 to 10.224.100.12:1812 length 45
freeradius_1 | (0) User-Name = "teste"
freeradius_1 | (0) User-Password = "q1w2e3r4"
freeradius_1 | (0) # Executing section authorize from file /etc/raddb/sites-enabled/default
freeradius_1 | (0) authorize {
freeradius_1 | (0) policy filter_username {
freeradius_1 | (0) if (&User-Name) {
freeradius_1 | (0) if (&User-Name) -> TRUE
freeradius_1 | (0) if (&User-Name) {
freeradius_1 | (0) if (&User-Name =~ / /) {
freeradius_1 | (0) if (&User-Name =~ / /) -> FALSE
freeradius_1 | (0) if (&User-Name =~ /@[^@]*@/ ) {
freeradius_1 | (0) if (&User-Name =~ /@[^@]*@/ ) -> FALSE
freeradius_1 | (0) if (&User-Name =~ /\.\./ ) {
freeradius_1 | (0) if (&User-Name =~ /\.\./ ) -> FALSE
freeradius_1 | (0) if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/)) {
freeradius_1 | (0) if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/)) -> FALSE
freeradius_1 | (0) if (&User-Name =~ /\.$/) {
freeradius_1 | (0) if (&User-Name =~ /\.$/) -> FALSE
freeradius_1 | (0) if (&User-Name =~ /@\./) {
freeradius_1 | (0) if (&User-Name =~ /@\./) -> FALSE
freeradius_1 | (0) } # if (&User-Name) = notfound
freeradius_1 | (0) } # policy filter_username = notfound
freeradius_1 | (0) [preprocess] = ok
freeradius_1 | (0) [chap] = noop
freeradius_1 | (0) [mschap] = noop
freeradius_1 | (0) [digest] = noop
freeradius_1 | (0) suffix: Checking for suffix after "@"
freeradius_1 | (0) suffix: No '@' in User-Name = "teste", looking up realm NULL
freeradius_1 | (0) suffix: No such realm "NULL"
freeradius_1 | (0) [suffix] = noop
freeradius_1 | (0) sql: EXPAND %{Stripped-User-Name}
freeradius_1 | (0) sql: -->
freeradius_1 | (0) sql: SQL-User-Name set to ''
freeradius_1 | rlm_sql (sql): Closing connection (0): Hit idle_timeout, was idle for 70 seconds
freeradius_1 | rlm_sql_mysql: Socket destructor called, closing socket
freeradius_1 | rlm_sql (sql): Closing connection (1): Hit idle_timeout, was idle for 70 seconds
freeradius_1 | rlm_sql_mysql: Socket destructor called, closing socket
freeradius_1 | rlm_sql (sql): Closing connection (2): Hit idle_timeout, was idle for 70 seconds
freeradius_1 | rlm_sql (sql): You probably need to lower "min"
freeradius_1 | rlm_sql_mysql: Socket destructor called, closing socket
freeradius_1 | rlm_sql (sql): Closing connection (3): Hit idle_timeout, was idle for 70 seconds
freeradius_1 | rlm_sql (sql): You probably need to lower "min"
freeradius_1 | rlm_sql_mysql: Socket destructor called, closing socket
freeradius_1 | rlm_sql (sql): Closing connection (4): Hit idle_timeout, was idle for 70 seconds
freeradius_1 | rlm_sql (sql): You probably need to lower "min"
freeradius_1 | rlm_sql_mysql: Socket destructor called, closing socket
freeradius_1 | rlm_sql (sql): 0 of 0 connections in use. You may need to increase "spare"
freeradius_1 | rlm_sql (sql): Opening additional connection (5), 1 of 32 pending slots used
freeradius_1 | rlm_sql_mysql: Starting connect to MySQL server
freeradius_1 | rlm_sql_mysql: Connected to database 'radius' on 10.224.100.12 via TCP/IP, server version 10.2.14-MariaDB-10.2.14+maria~jessie, protocol version 10
freeradius_1 | rlm_sql (sql): Reserved connection (5)
freeradius_1 | (0) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
freeradius_1 | (0) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '' ORDER BY id
freeradius_1 | (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '' ORDER BY id
freeradius_1 | (0) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority
freeradius_1 | (0) sql: --> SELECT groupname FROM radusergroup WHERE username = '' ORDER BY priority
freeradius_1 | (0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = '' ORDER BY priority
freeradius_1 | (0) sql: User not found in any groups
freeradius_1 | rlm_sql (sql): Released connection (5)
freeradius_1 | Need 2 more connections to reach min connections (3)
freeradius_1 | rlm_sql (sql): Opening additional connection (6), 1 of 31 pending slots used
freeradius_1 | rlm_sql_mysql: Starting connect to MySQL server
freeradius_1 | rlm_sql_mysql: Connected to database 'radius' on 10.224.100.12 via TCP/IP, server version 10.2.14-MariaDB-10.2.14+maria~jessie, protocol version 10
freeradius_1 | (0) [sql] = notfound
freeradius_1 | (0) [expiration] = noop
freeradius_1 | (0) [logintime] = noop
freeradius_1 | (0) pap: WARNING: No "known good" password found for the user. Not setting Auth-Type
freeradius_1 | (0) pap: WARNING: Authentication will fail unless a "known good" password is available
freeradius_1 | (0) [pap] = noop
freeradius_1 | (0) } # authorize = ok
freeradius_1 | (0) ERROR: No Auth-Type found: rejecting the user via Post-Auth-Type = Reject
freeradius_1 | (0) Failed to authenticate the user
freeradius_1 | (0) Using Post-Auth-Type Reject
freeradius_1 | (0) # Executing group from file /etc/raddb/sites-enabled/default
freeradius_1 | (0) Post-Auth-Type REJECT {
freeradius_1 | (0) sql: EXPAND .query
freeradius_1 | (0) sql: --> .query
freeradius_1 | (0) sql: Using query template 'query'
freeradius_1 | rlm_sql (sql): Reserved connection (5)
freeradius_1 | (0) sql: EXPAND %{Stripped-User-Name}
freeradius_1 | (0) sql: -->
freeradius_1 | (0) sql: SQL-User-Name set to ''
freeradius_1 | (0) sql: EXPAND INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')
freeradius_1 | (0) sql: --> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '', 'q1w2e3r4', 'Access-Reject', '2018-05-02 17:04:18')
freeradius_1 | (0) sql: Executing query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '', 'q1w2e3r4', 'Access-Reject', '2018-05-02 17:04:18')
freeradius_1 | (0) sql: SQL query returned: success
freeradius_1 | (0) sql: 1 record(s) updated
freeradius_1 | rlm_sql (sql): Released connection (5)
freeradius_1 | (0) [sql] = ok
freeradius_1 | (0) attr_filter.access_reject: EXPAND %{User-Name}
freeradius_1 | (0) attr_filter.access_reject: --> teste
freeradius_1 | (0) attr_filter.access_reject: Matched entry DEFAULT at line 11
freeradius_1 | (0) [attr_filter.access_reject] = updated
freeradius_1 | (0) policy remove_reply_message_if_eap {
freeradius_1 | (0) if (&reply:EAP-Message && &reply:Reply-Message) {
freeradius_1 | (0) if (&reply:EAP-Message && &reply:Reply-Message) -> FALSE
freeradius_1 | (0) else {
freeradius_1 | (0) [noop] = noop
freeradius_1 | (0) } # else = noop
freeradius_1 | (0) } # policy remove_reply_message_if_eap = noop
freeradius_1 | (0) } # Post-Auth-Type REJECT = updated
freeradius_1 | (0) Delaying response for 1.000000 seconds
freeradius_1 | Waking up in 0.3 seconds.
freeradius_1 | Waking up in 0.6 seconds.
freeradius_1 | (0) Sending delayed response
freeradius_1 | (0) Sent Access-Reject Id 32 from 10.224.100.12:1812 to 10.224.100.252:53538 length 20
freeradius_1 | Waking up in 3.9 seconds.
freeradius_1 | (0) Cleaning up request packet ID 32 with timestamp +70
freeradius_1 | Ready to process requests