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 <[email protected]>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 > [email protected] > > > > 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 < > [email protected]> 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 <[email protected]> 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 <[email protected]> >>> >>> 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 <[email protected]> >>>> *To:* [email protected] >>>> *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 <[email protected]> >>>> >>>>> I don't have an example. Use Alex's link. And don't spam. 1 email is >>>>> plenth. >>>>> >>>>> BR, >>>>> Nikos >>>>> >>>>> ----- Original Message ----- >>>>> *From:* Sam <[email protected]> >>>>> *To:* Nikos Balkanas <[email protected]> >>>>> *Cc:* [email protected] >>>>> *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 <[email protected]> >>>>> >>>>>> 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 <[email protected]> >>>>>> *To:* Nikos Balkanas <[email protected]> >>>>>> *Cc:* [email protected] >>>>>> *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 <[email protected]> >>>>>> >>>>>>> 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 <[email protected]> >>>>>>> *To:* [email protected] >>>>>>> *Sent:* Wednesday, December 09, 2009 9:43 AM >>>>>>> *Subject:* sqlbox and wap push >>>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Please can i use sqlbox for wap push? >>>>>>> >>>>>>> --Sam >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > >
![http://domain.com/images2.jpg"/](http://domain.com/images2.jpg"/){kind=link}