debian8中将freeswitch1.6的 core数据库换成mysql

1、安装mysql

 

2、安装ODBC

apt-get install unixodbc-dev
apt-get install libmyodbc

3、配置ODBC
vi /etc/odbc.ini加入
[freeswitch]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
SERVER = localhost
PORT = 3306
DATABASE = freeswitch
OPTION = 67108864
USER = freeswitch
PASSWORD = 123456


vi /etc/odbcinst.ini加入
[mysql]
Description = MySQL driver
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
UsageCount = 1
FileUsage = 1
Threading = 0

您的支持，是我持续创作的动力！！！！

4、建立数据库
 mysql -u root -p  

insert into mysql.user(Host,User,Password) values("localhost","freeswitch",password("123456"));

或create user 'freeswitch'@'%' identified by '123456';

create database freeswitch;
grant all privileges on freeswitch.* to 'freeswitch'@'%' identified by "123456";
flush  privileges;
exit;


5.      测试连接
isql -v freeswitch


数据库默认位置/var/lib/mysql


6、重新编译freeswitch
rm config.cache
./configure -C
make

make install

 

7、指定数据库连接

修改conf\autoload_configs\switch.conf 中的core-db-dsn
<param name="core-db-dsn" value="odbc://freeswitch:freeswitch:123456"/>
说明：odbc://连接方式
     freeswitch：数据库名
     freeswitch：用户名
     123456：密码