Setup FreeSWITCH - rubyists/tiny_call_center GitHub Wiki

For Mod_Callcenter db to be on postgres

Install psqlodbc and create the callcenter db

<youruser@yourhost ~>$ yaourt -S unixodbc psqlodbc
<youruser@yourhost ~>$ createdb -U postgres -O callcenter

Create odbcinst.ini, containing the following:

[PostgreSQL]
Description=PostgreSQL driver for Linux & Win32
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/psqlodbcw.so
UsageCount=1

Create odbc.ini, containing the following:

[CallCenter]
Description=Tiny Callcenter
Driver=PostgreSQL
Trace=Yes
TraceFile=callcenter\_sql.log
Database=callcenter
Servername=localhost
UserName=callcenter
Password=yourpassword
Port=5432
Protocol=6.4
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
ConnSettings=

Test your ODBC connection to the PostgreSQL DB using isql

isql callcenter