>From the DB.
#############
`momt`, `sender`, `receiver`, `udhdata` , `msgdata`, ....
'MT', 'coyName', '0000000000000', 0x0605040b8423f0, 0x1b0601ae02056a, ....
#############
2010/1/25 Nikos Balkanas <[email protected]
<mailto:[email protected]>>
Wap push is sent as binary sms. Wouldn't hurt to try. Provide a
select from the DB to verify that you have inserted the correct
msgtext. The INSERT statement you have provided is not a log,
therefore no verification that what you think was actually sent.
Not really necessary to resend bb logs.
----- Original Message -----
*From:* Sam <mailto:[email protected]>
*To:* Nikos Balkanas <mailto:[email protected]> ; Alejandro
Guerrieri <mailto:[email protected]>
*Cc:* [email protected] <mailto:[email protected]>
*Sent:* Monday, January 25, 2010 12:45 AM
*Subject:* Re: sqlbox and wap push
Hi,
Am sending a wap push.
Without even specifying coding=2 & charset=utf in the
send-url, all WORK FINE. So i don think this is the problem.
The problem is when i try to use SQLBOX for the same message.
One thing that i noticed is that when i insert into the DB,
the message data get truncated on 0x00 as you would also see
in the log. I guess this is where the problem is and i will be
grateful if you can help provide information on how to resolve
this.
Thank you.
2010/1/24 Nikos Balkanas <[email protected]
<mailto:[email protected]>>
Hi,
Well, I am sure you understand that no one enjoys long
mails each day on weekends in their box.
When sending binary SMS, you have to specify coding=2 &
charset=utf in your send-url. I assume your text is UTF.
BR,
Nikos
----- Original Message -----
*From:* Sam <mailto:[email protected]>
*To:* Nikos Balkanas <mailto:[email protected]> ;
Alejandro Guerrieri
<mailto:[email protected]>
*Cc:* [email protected] <mailto:[email protected]>
*Sent:* Monday, January 25, 2010 12:20 AM
*Subject:* Re: sqlbox and wap push
Hi,
Come on Nikos, I appreciate your effort to offer
assistance but you really do not have to insult. Kind
words are sufficient and professional !
Anyways, I have changed the field to binary as advised
by Alex. Plus i am sure the issue if not from PHP. I
am using direct copy of the URL into the browser
(works fine) and also direct INSERT in to the DB. See
the logs below.
One thing that i noticed however is that when i insert
into the DB, the message data get truncated on 0x00 as
you would also see in the log. I guess this is where
the problem is and i will be grateful if you can help
provide information on how to resolve this.
Thank you.
--Sam
############################## SENDING OVER HTTP
#######################################################
http://www.hostname.com:13290/cgi-bin/sendsms?user=kannel&pass=rL4y90&udh=%06%05%04%0B%84%23%F0&text=%1B%06%01%AE%02%05%6A%00%45%C6%0C%03%77%77%77%2E%63%6F%79%6E%61%6D%65%2E%63%6F%6D%2F%69%6D%61%67%65%2E%6A%70%67%00%01%03%57%61%70%00%01%01&dlr-mask=31&from=coyName&to=000000000000
<http://www.hostname.com:13290/cgi-bin/sendsms?user=kannel&pass=rL4y90&udh=%06%05%04%0B%84%23%F0&text=%1B%06%01%AE%02%05%6A%00%45%C6%0C%03%77%77%77%2E%63%6F%79%6E%61%6D%65%2E%63%6F%6D%2F%69%6D%61%67%65%2E%6A%70%67%00%01%03%57%61%70%00%01%01&dlr-mask=31&from=coyName&to=000000000000>
2010-01-24 22:47:49 [32012] [6] DEBUG: SMPP[nuSMSC]:
Sending PDU:
2010-01-24 22:47:49 [32012] [6] DEBUG: SMPP PDU
0xb0513a80 dump:
2010-01-24 22:47:49 [32012] [6] DEBUG: type_name:
submit_sm
2010-01-24 22:47:49 [32012] [6] DEBUG: command_id: 4
= 0x00000004
2010-01-24 22:47:49 [32012] [6] DEBUG:
command_status: 0 = 0x00000000
2010-01-24 22:47:49 [32012] [6] DEBUG:
sequence_number: 45807 = 0x0000b2ef
2010-01-24 22:47:49 [32012] [6] DEBUG: service_type:
NULL
2010-01-24 22:47:49 [32012] [6] DEBUG:
source_addr_ton: 5 = 0x00000005
2010-01-24 22:47:49 [32012] [6] DEBUG:
source_addr_npi: 0 = 0x00000000
2010-01-24 22:47:49 [32012] [6] DEBUG: source_addr:
"coyName"
2010-01-24 22:47:49 [32012] [6] DEBUG:
dest_addr_ton: 2 = 0x00000002
2010-01-24 22:47:49 [32012] [6] DEBUG:
dest_addr_npi: 1 = 0x00000001
2010-01-24 22:47:49 [32012] [6] DEBUG:
destination_addr: "000000000000"
2010-01-24 22:47:49 [32012] [6] DEBUG: esm_class: 67
= 0x00000043
2010-01-24 22:47:49 [32012] [6] DEBUG: protocol_id:
0 = 0x00000000
2010-01-24 22:47:49 [32012] [6] DEBUG:
priority_flag: 0 = 0x00000000
2010-01-24 22:47:49 [32012] [6] DEBUG:
schedule_delivery_time: NULL
2010-01-24 22:47:49 [32012] [6] DEBUG:
validity_period: NULL
2010-01-24 22:47:49 [32012] [6] DEBUG:
registered_delivery: 1 = 0x00000001
2010-01-24 22:47:49 [32012] [6] DEBUG:
replace_if_present_flag: 0 = 0x00000000
2010-01-24 22:47:49 [32012] [6] DEBUG: data_coding:
4 = 0x00000004
2010-01-24 22:47:49 [32012] [6] DEBUG:
sm_default_msg_id: 0 = 0x00000000
2010-01-24 22:47:49 [32012] [6] DEBUG: sm_length: 53
= 0x00000035
2010-01-24 22:47:49 [32012] [6] DEBUG: short_message:
2010-01-24 22:47:49 [32012] [6] DEBUG: Octet string
at 0xb0513a20:
2010-01-24 22:47:49 [32012] [6] DEBUG: len: 53
2010-01-24 22:47:49 [32012] [6] DEBUG: size: 1024
2010-01-24 22:47:49 [32012] [6] DEBUG: immutable: 0
2010-01-24 22:47:49 [32012] [6] DEBUG: data: 06
05 04 0b 84 23 f0 1b 06 01 ae 02 05 6a 00 45
.....#.......j.E
2010-01-24 22:47:49 [32012] [6] DEBUG: data: c6
0c 03 77 77 77 2e 63 6f 79 6e 61 6d 65 2e 63
...www.coyname.c
2010-01-24 22:47:49 [32012] [6] DEBUG: data: 6f
6d 2f 69 6d 61 67 65 2e 6a 70 67 00 01 03 57
om/image.jpg...W
2010-01-24 22:47:49 [32012] [6] DEBUG: data: 61
70 00 01 01 ap...
2010-01-24 22:47:49 [32012] [6] DEBUG: Octet string
dump ends.
############################## SENDING OVER
SQLBOX ####################################################
INSERT INTO send_sms (`momt`, `sender`, `receiver`,
`msgdata`, `sms_type`, `dlr_mask`, `udhdata` )
VALUES ('MT', 'coyName', '000000000000', CHAR (0x1B,
0x06, 0x01, 0xAE, 0x02, 0x05, 0x6A, 0x00, 0x45, 0xC6,
0x0C, 0x03, 0x77, 0x77, 0x77, 0x2E, 0x63, 0x6F, 0x79,
0x6E, 0x61, 0x6D, 0x65, 0x2E, 0x63, 0x6F, 0x6D, 0x2F,
0x69, 0x6D, 0x61, 0x67, 0x65, 0x2E, 0x6A, 0x70, 0x67,
0x00, 0x01, 0x03, 0x57, 0x61, 0x70, 0x00, 0x01, 0x01),
2, 31, CHAR(0x06, 0x05, 0x04, 0x0B, 0x84, 0x23, 0xf0) )
2010-01-24 22:53:00 [32012] [6] DEBUG: SMPP[nuSMSC]:
Sending PDU:
2010-01-24 22:53:00 [32012] [6] DEBUG: SMPP PDU
0xb0513a80 dump:
2010-01-24 22:53:00 [32012] [6] DEBUG: type_name:
submit_sm
2010-01-24 22:53:00 [32012] [6] DEBUG: command_id: 4
= 0x00000004
2010-01-24 22:53:00 [32012] [6] DEBUG:
command_status: 0 = 0x00000000
2010-01-24 22:53:00 [32012] [6] DEBUG:
sequence_number: 45818 = 0x0000b2fa
2010-01-24 22:53:00 [32012] [6] DEBUG: service_type:
NULL
2010-01-24 22:53:00 [32012] [6] DEBUG:
source_addr_ton: 5 = 0x00000005
2010-01-24 22:53:00 [32012] [6] DEBUG:
source_addr_npi: 0 = 0x00000000
2010-01-24 22:53:00 [32012] [6] DEBUG: source_addr:
"coyName"
2010-01-24 22:53:00 [32012] [6] DEBUG:
dest_addr_ton: 2 = 0x00000002
2010-01-24 22:53:00 [32012] [6] DEBUG:
dest_addr_npi: 1 = 0x00000001
2010-01-24 22:53:00 [32012] [6] DEBUG:
destination_addr: "000000000000"
2010-01-24 22:53:00 [32012] [6] DEBUG: esm_class: 67
= 0x00000043
2010-01-24 22:53:00 [32012] [6] DEBUG: protocol_id:
0 = 0x00000000
2010-01-24 22:53:00 [32012] [6] DEBUG:
priority_flag: 0 = 0x00000000
2010-01-24 22:53:00 [32012] [6] DEBUG:
schedule_delivery_time: NULL
2010-01-24 22:53:00 [32012] [6] DEBUG:
validity_period: NULL
2010-01-24 22:53:00 [32012] [6] DEBUG:
registered_delivery: 1 = 0x00000001
2010-01-24 22:53:00 [32012] [6] DEBUG:
replace_if_present_flag: 0 = 0x00000000
2010-01-24 22:53:00 [32012] [6] DEBUG: data_coding:
4 = 0x00000004
2010-01-24 22:53:00 [32012] [6] DEBUG:
sm_default_msg_id: 0 = 0x00000000
2010-01-24 22:53:00 [32012] [6] DEBUG: sm_length: 14
= 0x0000000e
2010-01-24 22:53:00 [32012] [6] DEBUG: short_message:
2010-01-24 22:53:00 [32012] [6] DEBUG: Octet string
at 0xb0513998:
2010-01-24 22:53:00 [32012] [6] DEBUG: len: 14
2010-01-24 22:53:00 [32012] [6] DEBUG: size: 1024
2010-01-24 22:53:00 [32012] [6] DEBUG: immutable: 0
2010-01-24 22:53:00 [32012] [6] DEBUG: data: 06
05 04 0b 84 23 f0 1b 06 01 ae 02 05 6a
.....#.......j
2010-01-24 22:53:00 [32012] [6] DEBUG: Octet string
dump ends.
##########################################################################################################
2010/1/24 Nikos Balkanas <[email protected]
<mailto:[email protected]>>
Hi,
Actually you have not. Alex told you that 0x00
could be a problem 3 days ago. Sorry to say, but
the only thing you have shown is inability to
think for yourself. This will not affect your
other SMS. Have you verified that the binary text
is inserted OK in your (binary) DB? If not, you
have a problem in your php. I trust you are not
asking this group to solve your php issues.
BR,
Nikos
[..snip..]
