FreeRadius3 of CentOS7: [sql] = notfound

作者: lesca 分类: CentOS,Troubleshoot 发布时间: 2015-03-04 14:11

Problem

(0) sql :       expand: "%{User-Name}" -> 'demo'
(0) sql : SQL-User-Name set to 'demo'
rlm_sql (sql): Reserved connection (4)
(0) sql :       expand: "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" -> 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'demo' ORDER BY id'
rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'demo' ORDER BY id'
(0) sql :       expand: "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" -> 'SELECT groupname FROM radusergroup WHERE username = 'demo' ORDER BY priority'
rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 'demo' ORDER BY priority'
rlm_sql (sql): Released connection (4)
rlm_sql (sql): Closing connection (0): Too many free connections (5 > 3)
(0)   [sql] = notfound

Solution

Make sure the driver is correct in the enabled module – sql

vim /etc/raddb/mods-enabled/sql
driver = "rlm_sql_mysql"

版权声明

本文出自 Lesca 技术宅,转载时请注明出处及相应链接。

本文永久链接: https://www.lesca.cn/archives/freeradius3-of-centos7-sql-notfound.html

如果觉得我的文章对您有用,请随意赞赏。您的支持将鼓励我继续创作!