[Freeswitch-users] freeswitch with postgres setup process?

[Ken Rice]

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 at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of jungle
Boogie
Sent: Sunday, April 10, 2016 11:23 AM
To: FreeSWITCH Users Help <freeswitch-users at 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 at sip2sip.info
xmpp: jungle-boogie at jit.si

_________________________________________________________________________
Professional FreeSWITCH Consulting Services: 
consulting at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org