Ok, you could try inserting the binary code instead of the "%" encoded data. Something like CHAR(0x1B, 0x06, 0x01...) etc.
Regards, Alex -- Alejandro Guerrieri aguerri...@kannel.org On Sat, Jan 9, 2010 at 1:42 AM, Sam <nu.e...@gmail.com> wrote: > Thanks Alex .. as you would see below.. the problem is not with the UDH but > with the "msgtext". Unfortunately i dont have any idea on how to fix this. > Please advise I have included here my BB log for both cases and the SQL > statement i am using to insert into SQLBox. > > TIA. > > #################################### SEND SMS FROM KANNEL URL > ######################################### > 2010-01-09 01:36:07 [32012] [9] DEBUG: boxc_receiver: sms received > 2010-01-09 01:36:08 [32012] [9] DEBUG: send_msg: sending msg to boxc: > <mysmsbox> > 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP[nuSMSC]: throughput (0.00,0.00) > 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP[nuSMSC]: Sending PDU: > 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP PDU 0x9252680 dump: > 2010-01-09 01:36:08 [32012] [6] DEBUG: type_name: submit_sm > 2010-01-09 01:36:08 [32012] [6] DEBUG: command_id: 4 = 0x00000004 > 2010-01-09 01:36:08 [32012] [6] DEBUG: command_status: 0 = 0x00000000 > 2010-01-09 01:36:08 [32012] [6] DEBUG: sequence_number: 56 = 0x00000038 > 2010-01-09 01:36:08 [32012] [6] DEBUG: service_type: NULL > 2010-01-09 01:36:08 [32012] [6] DEBUG: source_addr_ton: 5 = 0x00000005 > 2010-01-09 01:36:08 [32012] [6] DEBUG: source_addr_npi: 0 = 0x00000000 > 2010-01-09 01:36:08 [32012] [6] DEBUG: source_addr: "sender" > 2010-01-09 01:36:08 [32012] [6] DEBUG: dest_addr_ton: 2 = 0x00000002 > 2010-01-09 01:36:08 [32012] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 > 2010-01-09 01:36:08 [32012] [6] DEBUG: destination_addr: "0000000000000" > 2010-01-09 01:36:08 [32012] [6] DEBUG: esm_class: 67 = 0x00000043 > 2010-01-09 01:36:08 [32012] [6] DEBUG: protocol_id: 0 = 0x00000000 > 2010-01-09 01:36:08 [32012] [6] DEBUG: priority_flag: 0 = 0x00000000 > 2010-01-09 01:36:08 [32012] [6] DEBUG: schedule_delivery_time: NULL > 2010-01-09 01:36:08 [32012] [6] DEBUG: validity_period: NULL > 2010-01-09 01:36:08 [32012] [6] DEBUG: registered_delivery: 1 = > 0x00000001 > 2010-01-09 01:36:08 [32012] [6] DEBUG: replace_if_present_flag: 0 = > 0x00000000 > 2010-01-09 01:36:08 [32012] [6] DEBUG: data_coding: 4 = 0x00000004 > 2010-01-09 01:36:08 [32012] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 > 2010-01-09 01:36:08 [32012] [6] DEBUG: sm_length: 76 = 0x0000004c > 2010-01-09 01:36:08 [32012] [6] DEBUG: short_message: > 2010-01-09 01:36:08 [32012] [6] DEBUG: Octet string at 0x9268890: > 2010-01-09 01:36:08 [32012] [6] DEBUG: len: 76 > 2010-01-09 01:36:08 [32012] [6] DEBUG: size: 1024 > 2010-01-09 01:36:08 [32012] [6] DEBUG: immutable: 0 > 2010-01-09 01:36:08 [32012] [6] DEBUG: data: 06 05 04 0b 84 23 f0 1b > 06 01 ae 02 05 6a 00 45 .....#.......j.E > 2010-01-09 01:36:08 [32012] [6] DEBUG: data: c6 0c 03 68 74 74 70 3a > 2f 2f 6e 61 6d 65 6e 61 ...http://namena > 2010-01-09 01:36:08 [32012] [6] DEBUG: data: 6d 65 73 2e 63 6f 6d 2f > 76 6f 69 63 65 2f 65 63 mes.com/voice/ec > 2010-01-09 01:36:08 [32012] [6] DEBUG: data: 6f 73 73 65 2e 6a 70 67 > 00 01 03 54 68 65 20 69 osse.jpg...The i > 2010-01-09 01:36:08 [32012] [6] DEBUG: data: 6d 61 67 65 20 68 65 72 > 65 00 01 01 mage here... > 2010-01-09 01:36:08 [32012] [6] DEBUG: Octet string dump ends. > 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP PDU dump ends. > > ################################################################################## > > > > ######################################### SQLBOX insert > ######################################### > > INSERT INTO send_sms (`momt`, `sender`, `receiver`, `msgdata`, `sms_type`, > `dlr_mask`, `udhdata` ) > VALUES ('MT', 'sender', '0000000000000', > '%1B%06%01%AE%02%05%6A%00%45%C6%0C%03%68%74%74%70%3A%2F%2F%6E%61%6D%65%6E%61%6D%65%73%2E%63%6F%6D%2F%76%6F%69%63%65%2F%65%63%6F%73%73%65%2E%6A%70%67%00%01%03%54%68%65%20%69%6D%61%67%65%20%68%65%72%65%00%01%01', > 2, 31, CHAR(0x06, 0x05, 0x04, 0x0B, 0x84, 0x23, 0xf0) ) > > ####################################### SEND SMS FROM SQLBOX > ######################################### > 2010-01-09 01:33:08 [32012] [11] DEBUG: boxc_receiver: sms received > 2010-01-09 01:33:08 [32012] [11] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP[nuSMSC]: throughput (0.00,0.00) > 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP[nuSMSC]: Sending PDU: > 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP PDU 0x9252680 dump: > 2010-01-09 01:33:08 [32012] [6] DEBUG: type_name: submit_sm > 2010-01-09 01:33:08 [32012] [6] DEBUG: command_id: 4 = 0x00000004 > 2010-01-09 01:33:08 [32012] [6] DEBUG: command_status: 0 = 0x00000000 > 2010-01-09 01:33:08 [32012] [6] DEBUG: sequence_number: 49 = 0x00000031 > 2010-01-09 01:33:08 [32012] [6] DEBUG: service_type: NULL > 2010-01-09 01:33:08 [32012] [6] DEBUG: source_addr_ton: 5 = 0x00000005 > 2010-01-09 01:33:08 [32012] [6] DEBUG: source_addr_npi: 0 = 0x00000000 > 2010-01-09 01:33:08 [32012] [6] DEBUG: source_addr: "sender" > 2010-01-09 01:33:08 [32012] [6] DEBUG: dest_addr_ton: 2 = 0x00000002 > 2010-01-09 01:33:08 [32012] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 > 2010-01-09 01:33:08 [32012] [6] DEBUG: destination_addr: "0000000000000" > 2010-01-09 01:33:08 [32012] [6] DEBUG: esm_class: 67 = 0x00000043 > 2010-01-09 01:33:08 [32012] [6] DEBUG: protocol_id: 0 = 0x00000000 > 2010-01-09 01:33:08 [32012] [6] DEBUG: priority_flag: 0 = 0x00000000 > 2010-01-09 01:33:08 [32012] [6] DEBUG: schedule_delivery_time: NULL > 2010-01-09 01:33:08 [32012] [6] DEBUG: validity_period: NULL > 2010-01-09 01:33:08 [32012] [6] DEBUG: registered_delivery: 1 = > 0x00000001 > 2010-01-09 01:33:08 [32012] [6] DEBUG: replace_if_present_flag: 0 = > 0x00000000 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data_coding: 4 = 0x00000004 > 2010-01-09 01:33:08 [32012] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 > 2010-01-09 01:33:08 [32012] [6] DEBUG: sm_length: 214 = 0x000000d6 > 2010-01-09 01:33:08 [32012] [6] DEBUG: short_message: > 2010-01-09 01:33:08 [32012] [6] DEBUG: Octet string at 0x92523e8: > 2010-01-09 01:33:08 [32012] [6] DEBUG: len: 214 > 2010-01-09 01:33:08 [32012] [6] DEBUG: size: 1024 > 2010-01-09 01:33:08 [32012] [6] DEBUG: immutable: 0 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 06 05 04 0b 84 23 f0 25 > 31 42 25 30 36 25 30 31 .....#.%1B%06%01 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 25 41 45 25 30 32 25 30 > 35 25 36 41 25 30 30 25 %AE%02%05%6A%00% > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 34 35 25 43 36 25 30 43 > 25 30 33 25 36 38 25 37 45%C6%0C%03%68%7 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 34 25 37 34 25 37 30 25 > 33 41 25 32 46 25 32 46 4%74%70%3A%2F%2F > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 25 36 45 25 36 31 25 36 > 44 25 36 35 25 36 45 25 %6E%61%6D%65%6E% > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 36 31 25 36 44 25 36 35 > 25 37 33 25 32 45 25 36 61%6D%65%73%2E%6 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 33 25 36 46 25 36 44 25 > 32 46 25 37 36 25 36 46 3%6F%6D%2F%76%6F > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 25 36 39 25 36 33 25 36 > 35 25 32 46 25 36 35 25 %69%63%65%2F%65% > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 36 33 25 36 46 25 37 33 > 25 37 33 25 36 35 25 32 63%6F%73%73%65%2 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 45 25 36 41 25 37 30 25 > 36 37 25 30 30 25 30 31 E%6A%70%67%00%01 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 25 30 33 25 35 34 25 36 > 38 25 36 35 25 32 30 25 %03%54%68%65%20% > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 36 39 25 36 44 25 36 31 > 25 36 37 25 36 35 25 32 69%6D%61%67%65%2 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 30 25 36 38 25 36 35 25 > 37 32 25 36 35 25 30 30 0%68%65%72%65%00 > 2010-01-09 01:33:08 [32012] [6] DEBUG: data: 25 30 31 25 30 31 > %01%01 > 2010-01-09 01:33:08 [32012] [6] DEBUG: Octet string dump ends. > 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP PDU dump ends. > > ################################################################################## > > > > > > On Mon, Jan 4, 2010 at 11:21 AM, Alejandro Guerrieri < > aguerri...@kannel.org> wrote: > >> Have you checked the logs? You need to put the _binary_ data on the "udh" >> field, not the %XX stuff, btw. >> >> Compare the logs when sending from sendsms and sqlbox, you'll probably >> find differences. >> >> Regards, >> >> Alex >> -- >> Alejandro Guerrieri >> aguerri...@kannel.org >> >> >> >> On 03/01/2010, at 23:23, Sam wrote: >> >> Hi, >> >> Yes, I have used the full url. >> >> $fields[udh] into `udhdata` >> $fields[text] into `msgdata` >> >> and other relevant fields. >> >> Yet message does not come to the phone or phone does not understand it. >> However, if i past the URL directly on the sendsms http interface, the >> message get delivered right. >> >> Am worried if i was supposed to insert $fields[text] into `msgdata` >> directly. >> >> >> On Sun, Jan 3, 2010 at 11:15 PM, Alejandro Guerrieri < >> alejandro.guerri...@gmail.com> wrote: >> >>> Wap push uses udh data, try using the full url my code generates. >>> >>> Regards, >>> >>> Alex >>> >>> >>> On Sun, Jan 3, 2010 at 10:45 PM, Sam <nu.e...@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> I have tried to use Alex php code here http://www.blogalex.com/wp- >>>> content/uploads/2008/09/send_wap_push.php.txt >>>> >>>> by inserting the content of $fields[text] into `msgdata` field of the >>>> SQLbox table but this is not working. >>>> >>>> >>>> <?php >>>> $fields = array ( >>>> 'from' => '9912345678', >>>> 'to' => '9987654321', >>>> 'smsc' => 'mysmsc', >>>> 'link' => 'www.my-funny-link.com/myfile.mid', >>>> 'title' => 'Hi, look at this' >>>> ); >>>> >>>> $kannel = array ( >>>> 'host' => 'localhost', >>>> 'port' => 13013, >>>> 'user' => 'foo', >>>> 'pass' => 'bar' >>>> ); >>>> >>>> $result = sendwappush ( $fields, $kannel ); >>>> print "SENT<br>$result<br>"; >>>> >>>> >>>> /* >>>> sendwappush function. >>>> Copyleft 2004 by Alejandro Guerrieri >>>> This code is open source and GPL licensed >>>> */ >>>> function send_wap_push ( $fields, $kannel ) { >>>> $fields[udh] = '%06%05%04%0B%84%23%F0'; >>>> $fields[text] = '%1B%06%01%AE%02%05%6A%00%45%C6%0C%03'. >>>> hex_encode($fields['link'], '%'). >>>> '%00%01%03'. >>>> hex_encode($fields['title'], '%'). >>>> '%00%01%01'; >>>> unset ( $fields['title'], $fields['link'] ); >>>> >>>> while(list($k,$v) = each($fields)) { >>>> if ( $v != "" ) { >>>> $string .= "&$k=$v"; >>>> } >>>> } >>>> $request = 'http://'.$kannel['host'].':'.$kannel[port]. >>>> '/cgi-bin/sendsms'. >>>> '?user='.$kannel['user']. >>>> '&pass='.$kannel['pass']. >>>> $string; >>>> $result = @file( $request ); >>>> return 'ok'; >>>> } >>>> >>>> function hex_encode( $text, $joiner='' ) { >>>> for ($l=0; $l<strlen($text); $l++) { >>>> $letter = substr($text, $l, 1); >>>> $ret .= sprintf("%s%02X", $joiner, ord($letter)); >>>> } >>>> return $ret; >>>> } >>>> ?> >>>> >>>> >>>> >>>> 2010/1/3 Nikos Balkanas <nbalka...@gmail.com> >>>> >>>> Hi, >>>>> >>>>> With SQLbox you'll have to push it like sms. For a php example for >>>>> simple pushes please search archives for Alejandro Guerrieri's code. >>>>> >>>>> BR, >>>>> Nikos >>>>> >>>>> ----- Original Message ----- >>>>> *From:* Sam <nu.e...@gmail.com> >>>>> *To:* users@kannel.org >>>>> *Sent:* Sunday, January 03, 2010 11:23 PM >>>>> *Subject:* Re: sqlbox and wap push >>>>> >>>>> Hi, >>>>> >>>>> Please how do i make SQLBOX to handle a simple Service Load Wap push >>>>> like the following to a mobile? >>>>> >>>>> >>>>> >>>>> <?xml version="1.0"?> >>>>> <!DOCTYPE sl PUBLIC "-//WAPFORUM//DTD SL 1.0//EN" >>>>> "www.wapforum.org/DTD/sl.dtd"> >>>>> <sl href="http://domain.com/images2.jpg"/> >>>>> >>>>> >>>>> >>>>> >>>>> N.B. Giving that the the appropriate UDH has been defined. >>>>> >>>>> TIA >>>>> >>>>> --Sam. >>>>> >>>>> >>>>> >>>>> 2009/12/9 Nikos Balkanas <nbalka...@gmail.com> >>>>> >>>>>> I don't have an example. Use Alex's link. And don't spam. 1 email is >>>>>> plenth. >>>>>> >>>>>> BR, >>>>>> Nikos >>>>>> >>>>>> ----- Original Message ----- >>>>>> *From:* Sam <nu.e...@gmail.com> >>>>>> *To:* Nikos Balkanas <n...@amdtelecom.net> >>>>>> *Cc:* users@kannel.org >>>>>> *Sent:* Wednesday, December 09, 2009 11:10 AM >>>>>> *Subject:* Re: sqlbox and wap push >>>>>> >>>>>> The goal is to make it work with sqlbox. Thus i would need to convert >>>>>> to wbxml. This is where i need your example. >>>>>> >>>>>> >>>>>> 2009/12/9 Nikos Balkanas <n...@amdtelecom.net> >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Use Alex's link. Otherwise it is too lengthy to describe the >>>>>>> protocol. If you are interested the spec is: >>>>>>> >>>>>>> WAP-249-PPGService-20010713-a >>>>>>> An example would be meaningless. It is different for each message. >>>>>>> Wapbox will do the same thing for you, but it doesn't work with SQLbox. >>>>>>> >>>>>>> BR, >>>>>>> Nikos >>>>>>> >>>>>>> ----- Original Message ----- >>>>>>> *From:* Sam <nu.e...@gmail.com> >>>>>>> *To:* Nikos Balkanas <nbalka...@gmail.com> >>>>>>> *Cc:* users@kannel.org >>>>>>> *Sent:* Wednesday, December 09, 2009 10:39 AM >>>>>>> *Subject:* Re: sqlbox and wap push >>>>>>> >>>>>>> Thanks Nikos, >>>>>>> >>>>>>> I understand the UDH stuff, however how do i convert to wbxml? Please >>>>>>> could you do me an example? >>>>>>> >>>>>>> Also, would this code ( >>>>>>> http://www.blogalex.com/wp-content/uploads/2008/09/send_wap_push.php.txt) >>>>>>> help in anyway? >>>>>>> >>>>>>> Thanks in advance. >>>>>>> >>>>>>> --Sam >>>>>>> >>>>>>> >>>>>>> >>>>>>> 2009/12/9 Nikos Balkanas <nbalka...@gmail.com> >>>>>>> >>>>>>>> Yes. >>>>>>>> >>>>>>>> You will have to do some work, though. >>>>>>>> >>>>>>>> 1) Use the appropriate udh for wap-push: >>>>>>>> >>>>>>>> &udh=%06%05%04%0B%84%23%F0 >>>>>>>> >>>>>>>> in your sendsms url (url-encoded) >>>>>>>> >>>>>>>> 2) You have to convert your text first to wbxml and then urlencode >>>>>>>> it as well in your URL. >>>>>>>> >>>>>>>> BR, >>>>>>>> Nikos >>>>>>>> >>>>>>>> ----- Original Message ----- >>>>>>>> *From:* Sam <nu.e...@gmail.com> >>>>>>>> *To:* users@kannel.org >>>>>>>> *Sent:* Wednesday, December 09, 2009 9:43 AM >>>>>>>> *Subject:* sqlbox and wap push >>>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> Please can i use sqlbox for wap push? >>>>>>>> >>>>>>>> --Sam >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >> >