[Freeswitch-users] Failover with Postgresql

[B.Tietz at pinguin.ag]

Hi,

cdr data still invalid. I have a Master-Master-MySQL-Setup over both machines where recovery works. Database has latin1 coding to. I just think MySQL is not that stable... That's why I'd like to try pgsql.

this is my odbcinst.ini

[PostgreSQLUnicode]
Description     = PostgreSQL ODBC driver (Unicode version)
Driver      = /usr/lib/odbc/psqlodbcw.so
Setup       = /usr/lib/odbc/libodbcpsqlS.so
Debug       = 0
CommLog     = 1
UsageCount      = 1
Threading = 0
MaxLongVarcharSize=65536

Here my odbc.ini

[fs_psql]
Description         = PostgreSQLUnicode
Driver              = PostgreSQLUnicode
Trace               = No
TraceFile           = /tmp/psqlodbc.log
Database            = freeswitch
Servername          = 1.2.3.4
UserName            = freeswitch
Password            =  xxx
Port                = 5432
ReadOnly            = Yes
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No
ConnSettings        =

pgsql-Database is LATIN1 coding

VG,
Benjamin T.


-----Ursprüngliche Nachricht-----

Hi Benjamin

Psql cuts off the characters in the sofia recover table. To fix this you need to add: "MaxLongVarcharSize = 65536"
under your psql ANSI in /etc/odbcinst.ini

Good luck
Gill

On Fri, Dec 23, 2011 at 8:39 AM,  <B.Tietz at pinguin.ag> wrote:
> Hi,
> I try to make sofia recover with two servers. Setup is slightly done 
> like described in Wiki.
> But if I try to make a sofia recover the call is not recovered. Here 
> is the Error Message from CLI:
> 2011-12-23 14:34:42.256728 [WARNING] sofia_glue.c:5418 Invalid cdr 
> data, call not recovered
> Both server can reach the pgsql-server via odbc. Data is written in 
> sip_recovery.
> I think the coding fort he database is wrong. Can anyone tell me what 
> would be the best encoding? UTF8 and ANSII is bad!
> regards,
>
> Benjamin
>