FreeSWITCH if configured at build time to use postgresql can use it directly or via odbc just by setting the DSN settings appropriately in the configs. Check confluence for the various module configs where you might want to sue a DB backend -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of jungle Boogie Sent: Sunday, April 10, 2016 11:23 AM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: [Freeswitch-users] freeswitch with postgres setup process? Hello All, I have freeswitch installed from source on Debian 8.3 64 bit and Postgresql 9.4 installed from the Postgres packages[1]. What's the best way to have Freeswitch use a database that I'll setup and create? Do I need to recompile freeswitch with certain modules enabled? Do I need to enable to config flags? I've completed these things: install unixodbc-dev install odbc-postgresql update /etc/odbc.ini: [freeswitch] ; WARNING: The old psql odbc driver psqlodbc.so is now renamed psqlodbcw.so ; in version 08.x. Note that the library can also be installed under an other ; path than /usr/local/lib/ following your installation. Driver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so Description=Connection to LDAP/POSTGRESQL Servername=localhost Port=5432 Protocol=6.4 FetchBufferSize=99 Username=freeswitch Password=xxx Database=freeswitch ReadOnly=no Debug=1 CommLog=1 view etc/odbcinst.ini [PostgreSQL ANSI] Description=PostgreSQL ODBC driver (ANSI version) Driver=psqlodbca.so Setup=libodbcpsqlS.so Debug=0 CommLog=1 UsageCount=1 [PostgreSQL Unicode] Description=PostgreSQL ODBC driver (Unicode version) Driver=psqlodbcw.so Setup=libodbcpsqlS.so Debug=0 CommLog=1 UsageCount=1 And finally, test the connection: # isql -v freeswitch +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ [1] http://www.postgresql.org/download/linux/debian/ -- ------- inum: 883510009027723 sip: jungleboogie@sip2sip.info xmpp: jungle-boogie@jit.si _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org