[OpenSER-Users] CPL and Postgres problems.

[Bogdan-Andrei Iancu]

Hmm....that 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, 2008 at 11:57 AM, Bogdan-Andrei Iancu 
> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>
>     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 I got a  \ instead of 0x01 så figured something was
>     > wrong getting stuff out of the database.
>     >
>     > /Ola
>     >
>     > On Mon, Apr 7, 2008 at 10:50 AM, Bogdan-Andrei Iancu
>     > <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>
>     <mailto:bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>>>
>     wrote:
>     >
>     >     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!
>     >
>     >         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.
>     >
>     >         '<cpl>\012  <incoming>\012         <reject status="reject"
>     >         reason="I reject anonymous calls"/>\012
>     >         </incoming>\012</cpl>\012\012'
>     >
>     >         Loading it with openserctl that gets translated to this
>     in the
>     >         cpl_bin field.
>     >
>     >        
>      '\001\001\000\000\000\006\002\001\000\000\000\006\026\000\002\000\000\000\002[\000\001\000\031I
>     >         reject anonymous calls\000\000'
>     >
>     >         The reason I figure that postgres could have something to do
>     >         with this is that I've got this working before(before being
>     >         quite a while ago though. )  with MySQL.
>     >
>     >         Turning on debugging gives this information.
>     >
>     >         Mar 31 18:13:18 fuj /sbin/openser[601]: cpl-c B4script
>     >         Mar 31 18:13:18 fuj /sbin/openser[601]:
>     >         DBG:cpl-c:get_dest_user: trying to get user from new_uri
>     >         Mar 31 18:13:18 fuj /sbin/openser[601]:
>     >         DBG:cpl-c:get_dest_user: trying to get user from R_uri
>     >         Mar 31 18:13:18 fuj /sbin/openser[601]:
>     >         DBG:cpl-c:get_user_script: fetching script for user <olak>
>     >         Mar 31 18:13:18 fuj /sbin/openser[601]:
>     >         DBG:cpl-c:get_user_script: we got the script len=0
>     >         Mar 31 18:13:18 fuj /sbin/openser[601]: cpl-c After Script
>     >
>     >         OpenSER says that the length of the script is 0 whatever
>     >         script I load?.
>     >         I changed that in the CPL-C module so we get the right
>     length
>     >         of the compiled script but then it falls over on the sanity
>     >         check for NODE_CPL = 001 , and if you skip that check it
>     >         starts complaining about unknown nodes ( in my case 92 ) ...
>     >
>     >         So my question is if anyone uses postgres and CPL, if so can
>     >         you give me some pointers?
>     >         Would be good to know if this happens to be a bug or an
>     >         untested area in that case I have no problem fixing the
>     >         problem just don't want to burn alot of time on something
>     >         already fixed or me doing something stupid with
>     configuration.
>     >
>     >         Regards
>     >         /Ola Karlsson
>     >        
>     ------------------------------------------------------------------------
>     >
>     >         _______________________________________________
>     >         Users mailing list
>     >         Users at lists.openser.org <mailto:Users at lists.openser.org>
>     <mailto:Users at lists.openser.org <mailto:Users at lists.openser.org>>
>     >         http://lists.openser.org/cgi-bin/mailman/listinfo/users
>     >
>     >
>     >
>     >
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.openser.org <mailto:Users at lists.openser.org>
>     http://lists.openser.org/cgi-bin/mailman/listinfo/users
>
>