[Freeswitch-users] freeswitch with postgres setup process?

[jungle Boogie]

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