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