Hi, failover with PGSQL now working. I had to change the datatype for the "metadata"-coloumn from the sip_recovery-table to character varying (65536). regards, Benjamin T. Betreff: Re: [Freeswitch-users] Failover with Postgresql my encoding is UTF8 On Fri, Dec 23, 2011 at 10:07 AM, <B.Tietz@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@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@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-u s 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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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
_____________________________________________________________________ _ ___ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org