wap push via SQLBOX on Postgres

Сергей Бочаров <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
Hello! 
I try to send wap push message with sqlbox and postgres but no luck
 
I have code :

 $sms_msg='chr(27)||chr(6)||chr(1)||chr(174)||chr(2)||chr(5)||chr(106)||chr(0)||chr(69)||chr(198)||chr(12)||chr(3)||'.
      "'http:\\test.com'||".
      'chr(0)||chr(1)||chr(3)||'.
      "'test link'||".
      'chr(0)||chr(1)||chr(1)';
      
 $ssql="insert into send_sms (momt, sender, receiver,msgdata,time,smsc_id,account,sms_type,dlr_mask,dlr_url,mclass,mwi,udhdata) 
                          values ('MT', '$sms_from', '$sms_to',$sms_msg,'".time()."','$smsc',$uid,0,31,'$dlr_url',-1,-1,chr(6)||chr(5)||chr(4)||chr(11)||chr(132)||chr(35)||chr(240))";


I have in sqlbox log (when it try to insert to sent_sms):
--------

2010-11-10 11:25:46 [3454] [1] ERROR: PGSQL: ERROR:  invalid byte sequence for encoding "UTF8": 0x84
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
------

bearerbox log:
-------------

2010-11-10 12:02:38 [18360] [6] DEBUG: SMPP PDU 0x81be100 dump:
2010-11-10 12:02:38 [18360] [6] DEBUG:   type_name: submit_sm
2010-11-10 12:02:38 [18360] [6] DEBUG:   command_id: 4 = 0x00000004
2010-11-10 12:02:38 [18360] [6] DEBUG:   command_status: 0 = 0x00000000
2010-11-10 12:02:38 [18360] [6] DEBUG:   sequence_number: 16882 = 0x000041f2
2010-11-10 12:02:38 [18360] [6] DEBUG:   service_type: NULL
2010-11-10 12:02:38 [18360] [6] DEBUG:   source_addr_ton: 5 = 0x00000005
2010-11-10 12:02:38 [18360] [6] DEBUG:   source_addr_npi: 0 = 0x00000000
2010-11-10 12:02:38 [18360] [6] DEBUG:   source_addr: "ADMIN"
2010-11-10 12:02:38 [18360] [6] DEBUG:   dest_addr_ton: 1 = 0x00000001
2010-11-10 12:02:38 [18360] [6] DEBUG:   dest_addr_npi: 1 = 0x00000001
2010-11-10 12:02:38 [18360] [6] DEBUG:   destination_addr: "79250103663"
2010-11-10 12:02:38 [18360] [6] DEBUG:   esm_class: 67 = 0x00000043
2010-11-10 12:02:38 [18360] [6] DEBUG:   protocol_id: 0 = 0x00000000
2010-11-10 12:02:38 [18360] [6] DEBUG:   priority_flag: 0 = 0x00000000
2010-11-10 12:02:38 [18360] [6] DEBUG:   schedule_delivery_time: "101110090238000+"
2010-11-10 12:02:38 [18360] [6] DEBUG:   validity_period: "101110090238000+"
2010-11-10 12:02:38 [18360] [6] DEBUG:   registered_delivery: 1 = 0x00000001
2010-11-10 12:02:38 [18360] [6] DEBUG:   replace_if_present_flag: 0 = 0x00000000
2010-11-10 12:02:38 [18360] [6] DEBUG:   data_coding: 0 = 0x00000000
2010-11-10 12:02:38 [18360] [6] DEBUG:   sm_default_msg_id: 0 = 0x00000000
2010-11-10 12:02:38 [18360] [6] DEBUG:   sm_length: 14 = 0x0000000e
2010-11-10 12:02:38 [18360] [6] DEBUG:   short_message:
2010-11-10 12:02:38 [18360] [6] DEBUG:    Octet string at 0x81c2780:
2010-11-10 12:02:38 [18360] [6] DEBUG:      len:  14
2010-11-10 12:02:38 [18360] [6] DEBUG:      size: 1024
2010-11-10 12:02:38 [18360] [6] DEBUG:      immutable: 0
2010-11-10 12:02:38 [18360] [6] DEBUG:      data: 06 05 04 0b 84 23 f0 3f 3f 3f 3f 3f 3f 6a         .....#.??????j
2010-11-10 12:02:38 [18360] [6] DEBUG:    Octet string dump ends.
2010-11-10 12:02:38 [18360] [6] DEBUG: SMPP PDU dump ends.
-----------

 data is:  06 05 04 0b 84 23 f0 3f 3f 3f 3f 3f 3f 6a         .....#.??????j     
where 06 05 04 0b 84 23 f0 - is udhdata content, but what is '3f 3f 3f 3f 3f 3f 6a' ? i think it must be my message but not
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.