freeradius连接mysql数据库慢问题

【环境说明】

 服务器版本             redHat5.3

 mysql版本              MySQL5.6.22

 freeradius版本       2.1.12

【问题描述】

  配置好freeradius的sql.conf中的数据库地址，以及登录用户名和密码后，使用“radiusd -X”调试模式启动radius，控制台一直在漫长的输出尝试连接mysql的日 志，如下所示：

2014-12-30 09:27:39 DEBUG sql.c 93 - [RLM_SQL] Starting 0

2014-12-30 09:27:39 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #0

2014-12-30 09:27:39 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #0

2014-12-30 09:27:56 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #0

2014-12-30 09:27:56 DEBUG sql.c 93 - [RLM_SQL] Starting 1

2014-12-30 09:27:56 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #1

2014-12-30 09:27:56 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #1

2014-12-30 09:28:12 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #1

2014-12-30 09:28:12 DEBUG sql.c 93 - [RLM_SQL] Starting 2

2014-12-30 09:28:12 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #2

2014-12-30 09:28:12 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #2

2014-12-30 09:28:28 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #2

2014-12-30 09:28:28 DEBUG sql.c 93 - [RLM_SQL] Starting 3

2014-12-30 09:28:28 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #3

2014-12-30 09:28:28 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #3

2014-12-30 09:28:44 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #3

2014-12-30 09:28:44 DEBUG sql.c 93 - [RLM_SQL] Starting 4

2014-12-30 09:28:44 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #4

2014-12-30 09:28:44 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #4

2014-12-30 09:29:00 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #4

2014-12-30 09:29:00 DEBUG sql.c 93 - [RLM_SQL] Starting 5

2014-12-30 09:29:00 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #5

2014-12-30 09:29:00 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #5

2014-12-30 09:29:17 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #5

2014-12-30 09:29:17 DEBUG sql.c 93 - [RLM_SQL] Starting 6

2014-12-30 09:29:17 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #6

2014-12-30 09:29:17 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #6

2014-12-30 09:29:32 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #6

2014-12-30 09:29:32 DEBUG sql.c 93 - [RLM_SQL] Starting 7

2014-12-30 09:29:32 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #7

2014-12-30 09:29:32 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #7

2014-12-30 09:29:48 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #7

2014-12-30 09:29:48 DEBUG sql.c 93 - [RLM_SQL] Starting 8

2014-12-30 09:29:48 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #8

2014-12-30 09:29:48 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #8

2014-12-30 09:30:04 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #8

2014-12-30 09:30:04 DEBUG sql.c 93 - [RLM_SQL] Starting 9

2014-12-30 09:30:04 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #9

2014-12-30 09:30:04 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #9

2014-12-30 09:30:21 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #9

2014-12-30 09:30:21 DEBUG sql.c 93 - [RLM_SQL] Starting 10

2014-12-30 09:30:21 INFO sql.c 54 - [RLM_SQL] Attempting to connect rlm_sql_mysql #10

2014-12-30 09:30:21 INFO sql_mysql.c 79 - [RLM_SQL_MYSQL] Starting connect to MySQL server for #10

2014-12-30 09:30:37 INFO sql.c 58 - [RLM_SQL] Connected new DB handle, #10

到99以后提示失败，经查阅相关资料，进行如下处理即解决问题

【原因分析】

mysql域名反向解析

【解决办法】

步骤：

        1 vim /usr/my.cnf; mysql5.6.22版的配置文件在/usr/下，编辑my.cnf，在[mysqld]下增加一行“skip-name-resovle”,保存退出；

        2 重启mysql；

        3 重新启动radius；

 【可能存在问题】

        mysql客户端连接服务器时，服务器会对客户端进行反向域名解析，因此这个是耗时多的原因，取消域名解析以后，mysql的权限表（user表）中将不能再使用类似localhost之类的主机名，而必须使用ip地址。

---- <仅供参考> ----