Difference between revisions of "Core Databases"

From FusionPBX
Jump to: navigation, search
(Additional Information)
(switch.conf.xml)
 
Line 16: Line 16:
  
 
===switch.conf.xml===
 
===switch.conf.xml===
 +
Under the Settings area insert the following line
 +
 
  <param name="core-db-dsn" value="pgsql;hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
 
  <param name="core-db-dsn" value="pgsql;hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
  
 
===Additional Information===
 
===Additional Information===
 
http://wiki.freeswitch.org/wiki/PostgreSQL_in_the_core
 
http://wiki.freeswitch.org/wiki/PostgreSQL_in_the_core

Latest revision as of 00:33, 5 January 2014

SQLite

SQLite is the FreeSWITCH default. Databases are located in the freeswitch/db directory.

ODBC

http://wiki.freeswitch.org/wiki/ODBC

Postgres

Postgres native support will be in FreeSWITCH 1.2.4 but has been available in the Main GIT branch.

Dependencies

libpq and the associated dev packages are required

Configure

To enable PostgresSQL as a native client in FreeSWITCH you must enable it during the build when running configure.

./configure --enable-core-pgsql-support

switch.conf.xml

Under the Settings area insert the following line

<param name="core-db-dsn" value="pgsql;hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password= options='-c client_min_messages=NOTICE' application_name='freeswitch'" />

Additional Information

http://wiki.freeswitch.org/wiki/PostgreSQL_in_the_core