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 > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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 > > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> > 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 > > [email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>> > > http://lists.openser.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > _______________________________________________ > Users mailing list > [email protected] <mailto:[email protected]> > http://lists.openser.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
