Difference between revisions of "Core Databases"
From FusionPBX
(→ODBC) |
(→switch.conf.xml) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==SQLite== | ==SQLite== | ||
| + | SQLite is the FreeSWITCH default. Databases are located in the freeswitch/db directory. | ||
| + | |||
==ODBC== | ==ODBC== | ||
http://wiki.freeswitch.org/wiki/ODBC | http://wiki.freeswitch.org/wiki/ODBC | ||
| Line 14: | 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
Contents
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'" />
