Re: [OpenSER-Users] CPL and Postgres problems.

2008-04-09 Thread Bogdan-Andrei Iancu
Hmmthat is something strange - probably there is something mixed with the postgres data types. Could you open a bug report for further investigation? Regards, Bogdan Ola Karlsson wrote: > It was TEXT and I changed it to BYTEA and that seemed to do the trick. > > /Ola > > On Mon, Apr 7,

Re: [OpenSER-Users] CPL and Postgres problems.

2008-04-07 Thread Henning Westerholt
On Monday 07 April 2008, Bogdan-Andrei Iancu wrote: > So, you only changed the column type (for cpl_bin) from BLOB to BYTEA ? Hi Bogdan, hi Ola, the default column type for cpl_bin in postgres is 'TEXT' since 1.2.0 or so. A column type of 'BYTEA' should result in a 'DB_BLOB' type. This is exactl

Re: [OpenSER-Users] CPL and Postgres problems.

2008-04-07 Thread Bogdan-Andrei Iancu
So, you only changed the column type (for cpl_bin) from BLOB to BYTEA ? Regards, Bogdan Ola Karlsson wrote: > Bogdan.. > > I changed the column type in the database to bytea for cgi-bin and > stuff started working , seems the decode only happened for BLOB type > not for text. > > When debugging

Re: [OpenSER-Users] CPL and Postgres problems.

2008-04-07 Thread Bogdan-Andrei Iancu
Hello Ola, That is strange as the len of the script is taken from the postgres driver (via openser API) - the returned columns must be BLOB type. Check the types of the cpl_* columns; otherwise I suspect a postgres driver (in openser) issue. Best regards, Bogdan Ola Karlsson wrote: > Hi Users

[OpenSER-Users] CPL and Postgres problems.

2008-03-31 Thread Ola Karlsson
Hi Users! Have a problem with CPL scripts and postgres. I've tried to make the simplest possible script for debugging which resulted in the following in the 'cpl_xml' column. '\012 \012 \012 \012\012\012' Loading it with openserctl that gets translated to this in the cpl_bin field. '