use mysql guide.txt

Enable Freeswitch use mysql instead of sqlite

  1: yum install unixODBC-devel mysql-connector-odbc mysql-server

  2: edit file /etc/odbcinst.ini:
[MySQL]
Description     = ODBC for MySQL
#check file libmyodbc3_r.so + libodbcmyS.so in the folder /usr/lib
Driver          = /usr/lib/libmyodbc3_r.so
Setup           = /usr/lib/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc3_r.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1

  3: edit file /etc/odbc.ini:
[freeswitch]
Driver          = MySQL
SERVER          = 127.0.0.1
PORT            = 3306
DATABASE        = freeswitch
OPTION          = 67108864
Socket          = /var/lib/mysql/mysql.sock
USER            = test2            # insert your db username
PASSWORD        = pass    # insert your db password here

  4: edit file /opt/freeswitch/conf/sip_profiles/internal.xml
    <!--<param name="odbc-dsn" value="dsn:user:pass"/>--> change to     <param name="odbc-dsn" value="freeswitch:test2:pass"/>
	
  5: if you dont edit file /opt/freeswitch/conf/autoload_configs/switch.conf.xml and change the below line:
    <!-- <param name="core-db-dsn" value="dsn:username:password" /> -->
    <param name="core-db-dsn" value="freeswitch:test2:pass" />