[MySQL] Centos6.0之mysql+freeradiu实现帐号统一认证

yum install -y httpd mysql* php*

yum install -y freeradius*

radtest steve testing 127.0.0.1 1812 testing123

mysql> create database radius;
mysql> grant all on radius.* to radius@localhost identified by 'radius123';

mysql -u root -p radius < /etc/raddb/sql/mysql/schema.sql
mysql -u root -p radius < /etc/raddb/sql/mysql/nas.sql

vim /etc/raddb/radiusd.conf
700     $INCLUDE sql.conf  # 启用sql文件

vim /etc/raddb/sql.conf
sql {
  database = "mysql"
  driver = "rlm_sql_${database}"
  server = "localhost"
  login = "radius"
  password = "radius123"
  radius_db = "radius"

实现相关模块对数据库的支持
authorize(认证)，accounting(审计)，session(会话，用于监测同时连接)，post_auth(记录) 子段加入sql关键字，如：

authorize {
      preprocess
      chap
      mschap
      suffix
      eap
      sql
      pap
}

mysql -u root -p

mysql> use radius;
mysql> insert into radcheck(username,attribute,value,op)values("lansgg","Cleartext-Password","password123","=");

radtest lansgg password123 localhost 10 testing123