[OpenSER-Users] CPL and Postgres problems.

[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!
>
> 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
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>