最近在调电话系统,想要调一下Freeswitch的数据库,最后发现它自带的是比较简单的类型,最后决定替换成Mysql。查阅了书后发现无果,也从网上找了挺多,但是都不怎么全,现在已经调好了,和大家分享一下这次的成果。
替换MySQL数据库
1.安装ODBC连接包
yum install unixODBC-devel mysql-connector-odbc
2.修改连接所用核心文件
[root@localhost etc]# vi /etc/odbcinst.ini
# Example driver definitions
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
UsageCount = 1
Threading = 0
3、创建文件 odbc.ini 注意 Socket = /tmp/mysql.sock 为/etc/my.cnf 中的 socket
[root@localhost etc]# vi /etc/odbc.ini
[freeswitch]:
Driver = MySQL
SERVER = localhost
USER = root
PASSWORD = a3781b0ae8
PORT = 3306
DATABASE = freeswitch
OPTION = 67108864
Socket = /tmp/mysql.sock
4、测试连接 isql -v 数据库 用户名 密码
isql -v freeswitch freeswitch freeswitch
5.重新编译freeswitch
make&& make install