It works for everyone else...I would compile bearerbox in debug mode, run it
through gdb and put a break in route_incoming_to_boxc. Then I would inspect
available smsboxes, and where it is planning to route it and why.
BR,
Nikos
----- Original Message -----
From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Friday, November 12, 2010 7:12 AM
Subject: Re: SQLBox DLR Problem
Hi Nikos,
Continued testing today.
Got latest source from svn (Kannel + Smsbox)
Tested using http sendsms (works 100%)
Tested url encoding / not encoding the dlr-url (in SQLBox)
Checked config files, ports & UG etc
Compiled sqlbox without any patches
Still nothing, when using SQLBox it doesnt touch SMSBox at all (nothing in
the logs), am I correct in saying there might be a bug with sms-route
(bearerbox routing)?
Regards,
J
On Fri, Nov 12, 2010 at 1:24 AM, James E <jam...@gmail.com> wrote:
Hi Nikos,
This is the smsbox log:
2010-11-12 01:38:14 [8782] [0] INFO: Added logfile
`/home/devblast/daemon/kannel/log/logsmsbox.log' with level `0'.
2010-11-12 01:38:14 [8782] [0] INFO: HTTP: Opening server at port 10780.
2010-11-12 01:38:14 [8782] [0] DEBUG: Started thread 1
(gwlib/fdset.c:poller)
2010-11-12 01:38:14 [8782] [0] DEBUG: Started thread 2
(gwlib/http.c:server_thread)
2010-11-12 01:38:14 [8782] [0] INFO: Set up send sms service at port 10780
2010-11-12 01:38:14 [8782] [0] DEBUG: Started thread 3
(gw/smsbox.c:sendsms_thread)
2010-11-12 01:38:14 [8782] [0] INFO: Using HTTP request queueing with 1024
retries, 600s delay.
2010-11-12 01:38:14 [8782] [0]
DEBUG: ----------------------------------------------
2010-11-12 01:38:14 [8782] [0] DEBUG: Kannel smsbox version 1.5.0 starting
2010-11-12 01:38:14 [8782] [0] DEBUG: dumping group (sendsms-user):
2010-11-12 01:38:14 [8782] [0] DEBUG: <user-allow-ip> = <127.0.0.1>
2010-11-12 01:38:14 [8782] [0] DEBUG: <default-sender> = <xxxx>
2010-11-12 01:38:14 [8782] [0] DEBUG: <omit-empty> = <true>
2010-11-12 01:38:14 [8782] [0] DEBUG: <user-deny-ip> = <*.*.*.*>
2010-11-12 01:38:14 [8782] [0] DEBUG: <group> = <sendsms-user>
2010-11-12 01:38:14 [8782] [0] DEBUG: <default-smsc> = <smsc_2_1>
2010-11-12 01:38:14 [8782] [0] DEBUG: <max-messages> = <10>
2010-11-12 01:38:14 [8782] [0] DEBUG: <username> = <xxxx>
2010-11-12 01:38:14 [8782] [0] DEBUG: <concatenation> = <true>
2010-11-12 01:38:14 [8782] [0] DEBUG: <password> = <xxxx>
2010-11-12 01:38:14 [8782] [0] DEBUG: Started thread 4
(gw/smsbox.c:obey_request_thread)
2010-11-12 01:38:14 [8782] [0] DEBUG: Started thread 5
(gw/smsbox.c:url_result_thread)
2010-11-12 01:38:14 [8782] [0] DEBUG: Started thread 6
(gw/smsbox.c:http_queue_thread)
2010-11-12 01:38:14 [8782] [0] DEBUG: Connecting to <127.0.0.1>
2010-11-12 01:38:14 [8782] [0] INFO: Connected to bearerbox at 127.0.0.1
port 10778.
2010-11-12 01:38:14 [8782] [0] DEBUG: Started thread 7
(gw/heartbeat.c:heartbeat_thread)
2010-11-12 01:38:14 [8782] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps
to pid 8782.
2010-11-12 01:38:14 [8782] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread)
maps to pid 8782.
2010-11-12 01:38:14 [8782] [2] DEBUG: HTTP: Including port 10780, fd 7 for
polling in server thread
2010-11-12 01:38:14 [8782] [3] DEBUG: Thread 3 (gw/smsbox.c:sendsms_thread)
maps to pid 8782.
2010-11-12 01:38:14 [8782] [4] DEBUG: Thread 4
(gw/smsbox.c:obey_request_thread) maps to pid 8782.
2010-11-12 01:38:14 [8782] [5] DEBUG: Thread 5
(gw/smsbox.c:url_result_thread) maps to pid 8782.
2010-11-12 01:38:14 [8782] [6] DEBUG: Thread 6
(gw/smsbox.c:http_queue_thread) maps to pid 8782.
2010-11-12 01:38:14 [8782] [7] DEBUG: Thread 7
(gw/heartbeat.c:heartbeat_thread) maps to pid 8782.
I can't see it going to SMSBOX, no errors etc.
Regards,
J
2010/11/12 Nikos Balkanas <nbalka...@gmail.com>
Yes, that's what i was asking before. Detailed smsbox logs. They will show
attempts to fetch the dlr-url and any failures to do so. The question is if
your dlrs are even reaching smsbox, which should be the case for the
smsbox-route.
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 7:51 PM
Subject: Re: SQLBox DLR Problem
Hi Nikos,
Nothing stuck in store (used /status and /store-status)
Here is status (simplified):
SMS: received 0 (0 queued), sent 1 (0 queued), store size 0
SMS: inbound (0.00,0.00,0.00) msg/sec, outbound (0.02,0.00,0.00) msg/sec
DLR: received 2, sent 0
DLR: inbound (0.02,0.01,0.00) msg/sec, outbound (0.00,0.00,0.00) msg/sec
DLR: 0 queued, using mysql storage
Here is store:
SMS ID Type Time Sender Receiver SMSC ID BOX ID UDH Message
----
Should there be some kind of log somewhere showing it push the info to the
dlr http url?
Regards,
J
2010/11/12 Nikos Balkanas <nbalka...@gmail.com>
Have you checked with the HTTP admin pages, to see if they are getting stuck
in store?
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 7:20 PM
Subject: Re: SQLBox DLR Problem
Hi Nikos,
Already tried that. No good.
Regards,
J
2010/11/12 Nikos Balkanas <nbalka...@gmail.com>
Ok then. I don't understand it though. With smsbox-route DLRs should reach
smsbox just as if you sent them from sendsms. Try one last shot, but i doubt
if that's the problem since you should be getting errors in smsbox.
Try inserting straight (not url-encoded) dlr-url in sqlbox and see if it
helps.
Good Luck,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 6:54 PM
Subject: Re: SQLBox DLR Problem
Hi Nikos,
I got 1.5.0 from: http://www.kannel.org/download/kannel-snapshot.tar.gz
Not the SVN.
No errors in smsbox or bb logs.
The only time a dlr works is by sending the sms through sendsms (http)
Thanks Nikos for your persistence with trying to fix this.
Regards,
James
2010/11/11 Nikos Balkanas <nbalka...@gmail.com>
So you practically run svn kannel. Are any DLRs reaching smsbox? Do you get
any errors in smsbox or bb logs?
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 4:51 PM
Subject: Re: SQLBox DLR Problem
Hi Nikos,
There has been a patch applied to the SQLBox which fixes the Unicode issues,
this was developed by Stipe as stated in an earlier email.
Regards,
J
2010/11/11 Nikos Balkanas <nbalka...@gmail.com>
Have you changed the sources?
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 2:50 PM
Subject: Re: SQLBox DLR Problem
Hi Nikos,
I have done this:
group = smsbox-route
smsbox-id = dlrbox
smsc-id = smsc_2_1
No change, also the UG says we can do multiple smscs in the smsc-id
Here is the BB log: (If you require more, please let me know
2010-11-11 22:40:12 [9447] [6] DEBUG: SMPP PDU 0x2aaaac01b840 dump:
2010-11-11 22:40:12 [9447] [6] DEBUG: type_name: deliver_sm
2010-11-11 22:40:12 [9447] [6] DEBUG: command_id: 5 = 0x00000005
2010-11-11 22:40:12 [9447] [6] DEBUG: command_status: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: sequence_number: 10873727 =
0x00a5eb7f
2010-11-11 22:40:12 [9447] [6] DEBUG: service_type: NULL
2010-11-11 22:40:12 [9447] [6] DEBUG: source_addr_ton: 1 = 0x00000001
2010-11-11 22:40:12 [9447] [6] DEBUG: source_addr_npi: 1 = 0x00000001
2010-11-11 22:40:12 [9447] [6] DEBUG: source_addr: "xxxxxxxxxxx"
2010-11-11 22:40:12 [9447] [6] DEBUG: dest_addr_ton: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: dest_addr_npi: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: destination_addr: "HLR"
2010-11-11 22:40:12 [9447] [6] DEBUG: esm_class: 4 = 0x00000004
2010-11-11 22:40:12 [9447] [6] DEBUG: protocol_id: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: priority_flag: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: schedule_delivery_time: NULL
2010-11-11 22:40:12 [9447] [6] DEBUG: validity_period: NULL
2010-11-11 22:40:12 [9447] [6] DEBUG: registered_delivery: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: replace_if_present_flag: 0 =
0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: data_coding: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: sm_length: 242 = 0x000000f2
2010-11-11 22:40:12 [9447] [6] DEBUG: short_message:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac01b7a0:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 242
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 243
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 69 64 3a 35 30 31 31 31 31
31 33 34 30 31 31 34 id:5011111340114
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 37 39 35 33 20 73 75 62 3a
30 30 31 20 64 6c 76 7953 sub:001 dlv
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 72 64 3a 30 30 31 20 73 75
62 6d 69 74 20 64 61 rd:001 submit da
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 74 65 3a 31 30 31 31 31 31
31 33 34 30 20 64 6f te:1011111340 do
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 6e 65 20 64 61 74 65 3a 31
30 31 31 31 31 31 33 ne date:10111113
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 34 30 20 73 74 61 74 3a 44
45 4c 49 56 52 44 20 40 stat:DELIVRD
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 65 72 72 3a 30 30 30 20 49
4d 53 49 3a 35 32 30 err:000 IMSI:520
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 39 39 31 30 30 39 34 36 33
38 32 36 20 4d 53 43 991009463826 MSC
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 3a 36 36 38 39 31 30 32 20
20 48 4c 52 3a 36 36 :6689102 HLR:66
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 38 39 31 30 32 33 38 33 34
20 4f 52 4e 3a 54 72 891023834 ORN:Tr
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 75 65 20 4d 6f 76 65 20 43
6f 6d 70 61 6e 79 20 ue Move Company
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 50 4f 4e 3a 54 72 75 65
20 4d 6f 76 65 20 43 PON:True Move C
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 6f 6d 70 61 6e 79 20 20 52
4f 4e 3a 54 72 75 65 ompany RON:True
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 4d 6f 76 65 20 43 6f 6d
70 61 6e 79 20 20 52 Move Company R
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 4f 43 3a 54 48 20 4d 43 43
4d 4e 43 3a 35 32 30 OC:TH MCCMNC:520
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 39 39 99
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: network_error_code:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac01bb30:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 3
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 4
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 03 00 00 ...
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: message_state: 2 = 0x00000002
2010-11-11 22:40:12 [9447] [6] DEBUG: receipted_message_id:
"50111113401147953"
2010-11-11 22:40:12 [9447] [6] DEBUG: OC:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac020870:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 51
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 52
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 54 68 61 69 6c 61 6e 64 20
20 20 20 20 20 20 20 Thailand
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 20 20 20 20 20 20 20
20 20 20 20 20 20 20
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 20 20 20 20 20 20 20
20 20 20 20 20 20 20
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 00 .
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: OCC:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac020a70:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 3
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 4
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 54 48 00 TH.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: RCC:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac01b2c0:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 3
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 4
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 54 48 00 TH.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: INC: "1"
2010-11-11 22:40:12 [9447] [6] DEBUG: OCP:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac021070:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 3
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 4
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 36 36 00 66.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: RCN:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac000f90:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 51
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 52
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 54 68 61 69 6c 61 6e 64 20
20 20 20 20 20 20 20 Thailand
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 20 20 20 20 20 20 20
20 20 20 20 20 20 20
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 20 20 20 20 20 20 20
20 20 20 20 20 20 20
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 00 .
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: RCP:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac0200b0:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 3
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 4
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 36 36 00 66.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: INP: "0"
2010-11-11 22:40:12 [9447] [6] DEBUG: ONN:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac000b50:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 22
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 23
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 54 72 75 65 20 4d 6f 76 65
20 43 6f 6d 70 61 6e True Move Compan
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 79 20 4c 74 64 00 y Ltd.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: PNN:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac000d30:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 22
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 23
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 54 72 75 65 20 4d 6f 76 65
20 43 6f 6d 70 61 6e True Move Compan
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 79 20 4c 74 64 00 y Ltd.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: PPM: "40"
2010-11-11 22:40:12 [9447] [6] DEBUG: RNN:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac000f10:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 22
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 23
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 54 72 75 65 20 4d 6f 76 65
20 43 6f 6d 70 61 6e True Move Compan
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 79 20 4c 74 64 00 y Ltd.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: RNP:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac01fed0:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 4
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 5
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 38 39 31 00 891.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: SHLR:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac01b620:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 12
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 13
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 36 36 38 39 31 30 32 33 38
33 34 00 66891023834.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: MCCMNC:
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string at 0x2aaaac01b4a0:
2010-11-11 22:40:12 [9447] [6] DEBUG: len: 6
2010-11-11 22:40:12 [9447] [6] DEBUG: size: 7
2010-11-11 22:40:12 [9447] [6] DEBUG: immutable: 0
2010-11-11 22:40:12 [9447] [6] DEBUG: data: 35 32 30 39 39 00 52099.
2010-11-11 22:40:12 [9447] [6] DEBUG: Octet string dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: SMPP PDU dump ends.
2010-11-11 22:40:12 [9447] [6] DEBUG: SMPP[smsc_2_1] handle_pdu, got DLR
2010-11-11 22:40:12 [9447] [6] DEBUG: DLR[mysql]: Looking for DLR
smsc=smsc_2_1, ts=50111113401147953, dst=xxxx, type=1
2010-11-11 22:40:12 [9447] [6] DEBUG: sql: SELECT `mask`, `service`, `url`,
`source`, `destination`, `boxc` FROM `tmp_kannel_dlr` WHERE `smsc`=? AND
`timestamp`=? LIMIT 1
2010-11-11 22:40:12 [9447] [6] DEBUG: column=mask buffer_type=253
max_length=0 length=255
2010-11-11 22:40:12 [9447] [6] DEBUG: column=service buffer_type=253
max_length=0 length=32
2010-11-11 22:40:12 [9447] [6] DEBUG: column=url buffer_type=253
max_length=0 length=255
2010-11-11 22:40:12 [9447] [6] DEBUG: column=source buffer_type=253
max_length=0 length=20
2010-11-11 22:40:12 [9447] [6] DEBUG: column=destination buffer_type=253
max_length=0 length=20
2010-11-11 22:40:12 [9447] [6] DEBUG: column=boxc buffer_type=253
max_length=0 length=32
2010-11-11 22:40:12 [9447] [6] DEBUG: DLR[mysql]: created DLR message for
URL
<http%3A%2F%2F127.0.0.1%3A81%2Fsmshdlr%2Ftest_dlr.php%3Fstate%3Dstate%26statustext%3Dttt%26msisdn%3Dsss%26operator%3DDEFAULT%26hlr%3Dggg>
2010-11-11 22:40:12 [9447] [6] DEBUG: removing DLR from database
2010-11-11 22:40:12 [9447] [6] DEBUG: sql: DELETE FROM `tmp_kannel_dlr`
WHERE `smsc`=? AND `timestamp`=? LIMIT 1
2010-11-11 22:40:12 [9447] [6] DEBUG: new group created `smpp'
2010-11-11 22:40:12 [9447] [6] DEBUG: group=`smpp' key=`dlr_err' value=`^C'
2010-11-11 22:40:12 [9447] [6] DEBUG: SMPP[smsc_2_1]: Sending PDU:
2010-11-11 22:40:12 [9447] [6] DEBUG: SMPP PDU 0x2aaaac024e40 dump:
2010-11-11 22:40:12 [9447] [6] DEBUG: type_name: deliver_sm_resp
2010-11-11 22:40:12 [9447] [6] DEBUG: command_id: 2147483653 = 0x80000005
2010-11-11 22:40:12 [9447] [6] DEBUG: command_status: 0 = 0x00000000
2010-11-11 22:40:12 [9447] [6] DEBUG: sequence_number: 10873727 =
0x00a5eb7f
2010-11-11 22:40:12 [9447] [13] DEBUG: send_msg: sending msg to boxc:
<sqlbox>
2010-11-11 22:40:12 [9447] [6] DEBUG: message_id: NULL
2010-11-11 22:40:12 [9447] [6] DEBUG: SMPP PDU dump ends.
2010-11-11 22:40:12 [9447] [13] DEBUG: boxc_sender: sent message to
<127.0.0.1>
2010-11-11 22:40:12 [9447] [6] DEBUG: SMPP[smsc_2_1]: throughput
(0.00,25.00)
2010-11-11 22:40:12 [9447] [12] DEBUG: boxc_receiver: got ack
2010-11-11 22:40:25 [9447] [9] DEBUG: Dumping 0 messages to store
2010/11/11 Nikos Balkanas <nbalka...@gmail.com>
OK. 2 more things.
1) I have asked you to split smsbox-route to 2 rules, one for each smsc. I
don't think that it supports lists.
2) Please post detailed bb logs with at least 1 deliver_sm PDU and a few
lines below.
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 12:51 PM
Subject: Re: SQLBox DLR Problem
As requested here is the config.. The config file for sqlbox is separate.
# Kannel Configuration
# ----------
# BEARERBOX (Single Group)
# ----------
group = core
admin-port = 10777
smsbox-port = 10778
#wapbox-port = 10779
admin-password = xxxx
admin-allow-ip = "127.0.0.1"
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
log-file = "/home/daemon/kannel/log/kannel-box.log"
log-level = 0
access-log = "/home/daemon/kannel/log/kannel-access.log"
store-file = "/home/daemon/kannel/log/kannel-insms-tmp"
dlr-storage=mysql
access-log-format="[SMSC:%i] [from:%p] [to:%P] [msg:%L:%b] [udh:%U:%u]"
#wdp-interface-name = "*"
# -------- SMSBOX ------- (Single Group)
# -----------------------
group = smsbox
smsbox-id = dlrbox
bearerbox-host=127.0.0.1
sendsms-port=10780
sendsms-url = "/sendsms"
http-request-retry = 1024
http-queue-delay = 600
mo-recode = true
log-file="/home/daemon/kannel/log/logsmsbox.log"
log-level=0
# ------- SMSC BULK CONNECTION --------- (Multi Group)
##--Connection--##
group = smsc
smsc = smpp
smsc-id = smsc_2_1
allowed-smsc-id = smsc_2_1
#msg-id-type = 0x01
host = xxxx
port = xxxx
# receive-port = 2775
transceiver-mode=true
smsc-username = xxxx
smsc-password = xxxx
enquire-link-interval=30
system-type="HLR"
interface-version=34
bind-addr-ton=1
bind-addr-npi=1
source-addr-ton=5
source-addr-npi=1
#source-addr-autodetect=yes
#dest-addr-ton=1
#dest-addr-npi=1
throughput=25
wait-ack-expire=0x02
##--Connection
group = smsc
smsc = smpp
smsc-id = smsc_1_2
allowed-smsc-id = smsc_1_2
host = xxxx
port = xxxx
# receive-port = 2775
transceiver-mode=true
smsc-username = xxxx
smsc-password = xxxx
enquire-link-interval=30
system-type="SMPP SERVER"
interface-version=34
bind-addr-ton=1
bind-addr-npi=1
source-addr-ton=5
source-addr-npi=1
#dest-addr-ton=1
#dest-addr-npi=1
throughput=50
wait-ack-expire=0x02
# ------- SEND-SMS USERS --------
# Needed to enable SMS Push
# -------------------------------
group = sendsms-user
max-messages=10
concatenation=true
username = xxxx
password = xxxx
user-deny-ip = "*.*.*.*"
user-allow-ip = "127.0.0.1"
default-sender = xxxx
omit-empty = true
default-smsc = "smsc_2_1"
# --- SMS SERVICE --
# ------------------
group = sms-service
accepted-smsc=smsc_2_1
max-messages=0
concatenation = true
keyword = default
catch-all= true
omit-empty=true
get-url =
"http://127.0.0.1:81/smshandler/reg_sms_bulksms.php?msisdn=%p&sms=%a&trx_date=%t&dest=%P&operator=DEFAULT";
# ------ SMS BOX ROUTE ---
#------------------------
group = smsbox-route
smsbox-id = dlrbox
smsc-id = "smsc_1_2;smsc_2_1"
# MySQL Connection for External Delivery Report
# ---------------------------------------------
group = mysql-connection
id = mydlr
host = 127.0.0.1
username = xxxx
password = xxxx
database = xxxx
max-connections = 4
group = dlr-db
id = mydlr
table = tmp_kannel_dlr
field-smsc = smsc
field-timestamp = timestamp
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
#########################################
##Sqlbox config (separate file)
##--SQLBOX CONFIG--##
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
global-sender = "xxxx"
bearerbox-host = localhost
bearerbox-port = 10778
smsbox-port = 10781
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/home/daemon/kannel/log/sqlbox.log"
log-level = 0
#ssl-client-certkey-file = ""
#ssl-server-cert-file = ""
#ssl-server-key-file = ""
#ssl-trusted-ca-file = ""
group = mysql-connection
id = sqlbox-db
host = localhost
username = xxxx
password = xxxx
database = xxxx
2010/11/11 Nikos Balkanas <nbalka...@gmail.com>
Ignore those warnings. They refer to smsc-reroute, which you don't have.
Please post your configuration
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 10:51 AM
Subject: Re: SQLBox DLR Problem
Interesting i see this in the bearerbox log:
2010-11-11 18:29:36 [3185] [0] DEBUG: Adding smsbox routing to id <dlrbox>
for smsc id <smsc_1_2>
2010-11-11 18:29:36 [3185] [0] DEBUG: Adding smsbox routing to id <dlrbox>
for smsc id <smsc_2_1>
Few lines down:
2010-11-11 18:29:36 [3185] [0] INFO: DLR rerouting for smsc id <smsc_2_1>
disabled.
2010-11-11 18:29:36 [3185] [0] INFO: DLR rerouting for smsc id <smsc_1_2>
disabled.
PS: I removed smsc_1_2 connection.
Is there some way to enable DLR rerouting? I am searching through the UG and
can not see it.
Regards,
James
On Thu, Nov 11, 2010 at 3:31 PM, James E <jam...@gmail.com> wrote:
Thanks Nikos,
I did just that, but still nothing.
Updated Config (simplified):
# -------- SMSBOX ------- (Single Group)
# -----------------------
group = smsbox
smsbox-id = dlrbox
bearerbox-host=127.0.0.1
sendsms-port=10780
# ------ SMS BOX ROUTE ---
#------------------------
group = smsbox-route
smsbox-id = dlrbox
smsc-id = "smsc_1_1;smsc_1_2;smsc_2_1"
Regards,
J
2010/11/11 Nikos Balkanas <nbalka...@gmail.com>
Hi,
You need to include an smsbox-route group to route DLRs to your smsbox. Read
UG about it.
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 8:57 AM
Subject: Re: SQLBox DLR Problem
Hi Nikos,
Sorry I misunderstood.
SMSBox is connected to Bearerbox
SQLBox is connected to Bearerbox
Here is the config (simplified)
# ----------
# BEARERBOX (Single Group)
# ----------
group = core
admin-port = 10777
smsbox-port = 10778
#wapbox-port = 10779
# -------- SMSBOX ------- (Single Group)
# -----------------------
group = smsbox
bearerbox-host=127.0.0.1
sendsms-port=10780
sendsms-url = "/sendsms"
##--SQLBOX CONFIG--##
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 10778
smsbox-port = 10781
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
2010/11/11 Nikos Balkanas <nbalka...@gmail.com>
This doesn't answer my question. Is smsbox connected to sqlbox, or
bearerbox? Yo also seem to mix up bearerbox logs with smsbox logs.
BR,
Nikos
----- Original Message ----- From: James E
To: Nikos Balkanas ; users@kannel.org
Sent: Thursday, November 11, 2010 8:41 AM
Subject: Re: SQLBox DLR Problem
I have:
1 Bearer box with SQLBox, SMSBox connection and 2x SMSC Connections
Kannel 1.5.0 with latest SQLBox (including unicode bug patch from Stipe)
I hit the smsbox with this:
http://127.0.0.1:10780/sendsms?username=xxx&password=xxx&smsc=smsc_2_1&to=1234&text=test&dlr-mask=31&dlr-url=http%3a%2f%2f127.0.0.1%3a81%2fsmshdlr%2ftest_dlr.php%3fstate%3dstate%26statustext%3dttt%26msisdn%3dsss%26operator%3dDEFAULT%26hlr%3dggg
In the SMSBox table I insert:
momt: MT
sender: test
receiver: 1234
msgdata: test
smsc_id: smsc_2_1
sms_type: 2
dlr_mask: 31
dlr_url:
http%3a%2f%2f127.0.0.1%3a81%2fsmshdlr%2ftest_dlr.php%3fstate%3dstate%26statustext%3dttt%26msisdn%3dsss%26operator%3dDEFAULT%26hlr%3dggg
--------------
In SQLBox try, everything works as per normal in send_sms and sent_sms
tables, but the dlr-url is not hit/touched at all.
I looked in the bearer box log, here is one difference i can see
SQLBOX try
2010-11-11 16:29:53 [12571] [6] DEBUG: DLR[mysql]: created DLR message for
URL
<http%3a%2f%2f127.0.0.1%3a81%2fsmshdlr%2ftest_dlr.php%3fstate%3dstate%26statustext%3dttt%26msisdn%3dsss%26operator%3dDEFAULT%26hlr%3dggg>
SMSBox try (successful)
2010-11-11 15:49:35 [12571] [6] DEBUG: DLR[mysql]: created DLR message for
URL
<http://127.0.0.1:81/smshdlr/test_dlr.php?state=state&statustext=ttt&msisdn=sss&operator=DEFAULT&hlr=ggg>
Regards,
J
2010/11/11 Nikos Balkanas <nbalka...@gmail.com>
Hi,
Please describe your sqlbox and smsbox connections in your flow.
BR,
Nikos
----- Original Message ----- From: James E
To: users@kannel.org
Sent: Thursday, November 11, 2010 7:56 AM
Subject: SQLBox DLR Problem
Hi,
I have tested for a few days now & read the manual.
Is anyone else having issues with DLRs when sending the sms through SQLBox?
I tested with SMSBOX (sendsms) and it hits the dlr-url no problems. But when
I send it with SQLBox the dlr-url is never touched.
I am url encoding the dlr-url, and dlr-mask=31
Anyones help would be appreciated.
J
