VoIP服务器Yate设置MySql用户验证

(1)在MySQL里面添加个库yate,然后创建users用户表:

CREATE TABLE `users` (
  `username` varchar(50) NOT NULL,
  `password` varchar(50) DEFAULT '9999',
  `location` varchar(255) DEFAULT NULL,
  `expires` datetime DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

(2)设置MySql连接配置文件mysqldb.conf (conf.d目录下)主要是些地址和端口之类的,例如:

[yatetest];这个是连接引用名
host=localhost
port=3306
database=yate
user=root
password=9999

(3)设置register.conf文件:

[general]
;要处理的相关信息
user.auth=yes
user.register=yes
user.unregister=yes
call.route=yes
fallback=yes
[default]
priority=50
;Mysql.conf里的连接名
account=yatetest
[user.auth]
query=SELECT password FROM users WHERE username='${username}' AND password IS NOT NULL AND password<>''
result=password

[user.register]
;用户注册(上线)消息处理
query=UPDATE users SET location='${data}',expires=CURRENT_TIMESTAMP + INTERVAL ${expires} SECOND WHERE username='${username}'

[user.unregister]
;用户反注册(下线)消息处理
query=UPDATE users SET location=NULL,expires=NULL WHERE expires IS NOT NULL AND username='${username}'

[call.route]
;通话路由
offlineauto=yes
query=SELECT location,(CASE WHEN location IS NULL THEN 'offline' ELSE NULL END) AS error FROM users WHERE username='${called}'
result=location
priority=120

重启yate服务器,用客户端连接下！