[Freeswitch-users] Failover with Postgresql

Gilad Abada ga at steadfasttelecom.com
Fri Dec 23 18:22:41 MSK 2011


my encoding is UTF8

On Fri, Dec 23, 2011 at 10:07 AM,  <B.Tietz at pinguin.ag> wrote:
> If you are in the psql-cli make '\l' for listing the databases and you will see the coding of the databases...
>
> VG,
> Benjamin T.
>
>
> Betreff: Re: [Freeswitch-users] Failover with Postgresql
>
> What do you mean?
> I am using postgresql
>
>
>
> On Fri, Dec 23, 2011 at 9:52 AM,  <B.Tietz at pinguin.ag> wrote:
>> Hi Gilad,
>>
>> and what is the coding of your database for freeswitch?
>>
>> VG,
>> Benjamin T.
>>
>>
>> Betreff: Re: [Freeswitch-users] Failover with Postgresql
>>
>> 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-us
>>> e
>>> rs
>>> 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.
>>
>> ______________________________________________________________________
>> ___ 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-use
>> rs
>> http://www.freeswitch.org
>>
>> ______________________________________________________________________
>> ___ 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-use
>> rs
>> 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.
>
> _________________________________________________________________________
> 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
>
> _________________________________________________________________________
> 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