yum install -y mariadb mariadb-server
service mariadb start
systemctl enable mariadb
mysql_secure_installation 			
			
			

			
[root@netkiller ~]# dnf install -y freeswitch-database-mariadb			
			
			

			
[root@netkiller ~]# cat /etc/freeswitch/autoload_configs/pre_load_modules.conf.xml
<configuration name="pre_load_modules.conf" description="Modules">
  <modules>
    <!-- Databases -->
    <!-- <load module="mod_mariadb"/> -->
    <load module="mod_pgsql"/>
  </modules>
</configuration>		
			
			

注释 mod_pgsql 启用 mod_mariadb

			
    <load module="mod_mariadb"/>
    <!-- <load module="mod_pgsql"/> -->
			
			

			
[root@netkiller ~]# cat /etc/freeswitch/autoload_configs/db.conf.xml 
<configuration name="db.conf" description="LIMIT DB Configuration">
  <settings>
    <!--<param name="odbc-dsn" value="dsn:user:pass"/>-->
  </settings>
</configuration>			
			
			

			
<configuration name="db.conf" description="LIMIT DB Configuration">
  <settings>
    <param name="core-db-dsn" value="mariadb://Server=192.168.0.11;Port=3307;Database=freeswitch;Uid=root;Pwd=123456;" />
  </settings>
</configuration>
			
			
			

修改下面文件中的 core-db-dsn

			
[root@netkiller ~]# vim /etc/freeswitch/autoload_configs/switch.conf.xml		
			
			

			
[root@netkiller ~]# cat /etc/freeswitch/autoload_configs/switch.conf.xml | grep dsn
    <!-- <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE'" /> -->
    <!-- <param name="core-db-dsn" value="postgresql://freeswitch:@127.0.0.1/freeswitch?options=-c%20client_min_messages%3DNOTICE" /> -->
    <param name="core-db-dsn" value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=pass;" />
    <!-- <param name="core-db-dsn" value="dsn:username:password" /> -->			
			
			

数据源格式

			
mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=pass;		
			
			

修改下面文件中的 odbc-dsn

			
[root@netkiller ~]# vim /etc/freeswitch/autoload_configs/switch.conf.xml
[root@netkiller ~]# vim /etc/freeswitch/autoload_configs/db.conf.xml
[root@netkiller ~]# vim /etc/freeswitch/sip_profiles/internal.xml
[root@netkiller ~]# vim /etc/freeswitch/sip_profiles/internal-ipv6.xml
			
			

用下面命令检查是否遗漏

			
[root@netkiller ~]# grep -r 'odbc-dsn' /etc/freeswitch/*/*.xml
[root@netkiller ~]# grep -r 'core-db-dsn' /etc/freeswitch/*/*.xml