[Freeswitch-users] Failover with Postgresql

[Gilad Abada]

These are my settings for postgresql and they work.

 /etc/odbc.ini [$YOUR_DSN_NAME]Description         = PostgreSQL
UnicodeDriver              = PostgreSQL UnicodeTrace               =
NoTraceFile           = /tmp/psqlodbc.logDatabase            =
$YOUR_DSN_NAMEServername          = 127.0.0.1UserName            =
$YOUR_DB_USERNAMEPassword            = $YOUR_DB_PASSWORDPort
     = 5432ReadOnly            = YesRowVersioning       =
NoShowSystemTables    = NoShowOidColumn       = NoFakeOidIndex
= NoConnSettings        =ODBC
/etc/odbcinst.ini[PostgreSQL ANSI] Description            = PostgreSQL
ODBC driver (ANSI version)Driver          =
/usr/lib/odbc/psqlodbca.soSetup           =
/usr/lib/odbc/libodbcpsqlS.soDebug           = 0CommLog         =
1UsageCount              = 1Threading = 0[PostgreSQL
Unicode]Description             = PostgreSQL ODBC driver (Unicode
version)Driver          = /usr/lib/odbc/psqlodbcw.soSetup           =
/usr/lib/odbc/libodbcpsqlS.soDebug           = 0CommLog         =
1UsageCount              = 1Threading = 0MaxLongVarcharSize = 65536
On Fri, Dec 23, 2011 at 9:36 AM,  <B.Tietz at pinguin.ag> wrote:
> 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
>>
>
> _________________________________________________________________________
> 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.