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
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-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.
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
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-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.
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-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
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-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
_________________________________________________________________________ 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
-- 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.
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-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
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-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
_________________________________________________________________________ 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
-- 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.
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
participants (2)
-
B.Tietz＠pinguin.ag
-
Gilad Abada