|
|
freeradius安装方法:apt-get install freeradius
mysql安装方法:apt-get install mysql-server-4.1
模块:apt-get install freeradius-mysql
安装完成后配置clients.conf、users.conf文件后,运行:radiusd -X 测试radius服务,出现以下错误:
……(此处省略多条运行读取的配置信息)
sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'"
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0"
sql: postauth_table = "radpostauth"
sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply acket-Type}', NOW())"
sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
段错误
小弟查阅过很多帖子,有的说是freeradius和mysql版本匹配的问题,但是我也尝试过使用编译的方法安装不同版本的匹配,但是仍然不行,请各位赐教。
个人认为是不是sql.conf中的配置存在不安全字符(不可见) |
|