[Freeswitch-users] Failover with Postgresql

Gilad Abada ga at steadfasttelecom.com
Fri Dec 23 17:08:05 MSK 2011


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
>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.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
>



-- 
Gilad Abada

SteadFast Telecommunications, Inc.

Call us to find out how much you can save with VoIP!

V: 212.589.1001
F: 212.589.1011


For 35 years, Steadfast Telecommunications has been providing
state-of-the-art communications technology to businesses and
government agencies - large and small. Steadfast Telecommunications
tailors Unified Communications and Voice-Over IP Solutions to
single-site offices or multi-site and worldwide enterprises.   Make
your virtual office a reality.  Enjoy the freedom to travel while
remaining connected to your office.



Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list