Difference between revisions of "Core Databases"
From FusionPBX
(Created page with "==SQLite== ==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 associate...") |
(→switch.conf.xml) |
||
| (3 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 | ||
| + | |||
==Postgres== | ==Postgres== | ||
Postgres native support will be in FreeSWITCH 1.2.4 but has been available in the Main GIT branch. | Postgres native support will be in FreeSWITCH 1.2.4 but has been available in the Main GIT branch. | ||
| Line 12: | 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'" />
