Re: SQLBox DLR Problem

Nikos Balkanas Thu, 11 Nov 2010 10:09:32 -0800

Yes, that's what i was asking before. Detailed smsbox logs. They will showattempts to fetch the dlr-url and any failures to do so. The question is ifyour dlrs are even reaching smsbox, which should be the case for thesmsbox-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 thedlr 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 stuckin 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 reachsmsbox just as if you sent them from sendsms. Try one last shot, but i doubtif 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 ithelps.


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 getany 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 3131 33 34 30 31 31 34 id:50111113401142010-11-11 22:40:12 [9447] [6] DEBUG: data: 37 39 35 33 20 73 75 62 3a30 30 31 20 64 6c 76 7953 sub:001 dlv2010-11-11 22:40:12 [9447] [6] DEBUG: data: 72 64 3a 30 30 31 20 73 7562 6d 69 74 20 64 61 rd:001 submit da2010-11-11 22:40:12 [9447] [6] DEBUG: data: 74 65 3a 31 30 31 31 31 3131 33 34 30 20 64 6f te:1011111340 do2010-11-11 22:40:12 [9447] [6] DEBUG: data: 6e 65 20 64 61 74 65 3a 3130 31 31 31 31 31 33 ne date:101111132010-11-11 22:40:12 [9447] [6] DEBUG: data: 34 30 20 73 74 61 74 3a 4445 4c 49 56 52 44 20 40 stat:DELIVRD2010-11-11 22:40:12 [9447] [6] DEBUG: data: 65 72 72 3a 30 30 30 20 494d 53 49 3a 35 32 30 err:000 IMSI:5202010-11-11 22:40:12 [9447] [6] DEBUG: data: 39 39 31 30 30 39 34 36 3338 32 36 20 4d 53 43 991009463826 MSC2010-11-11 22:40:12 [9447] [6] DEBUG: data: 3a 36 36 38 39 31 30 32 2020 48 4c 52 3a 36 36 :6689102 HLR:662010-11-11 22:40:12 [9447] [6] DEBUG: data: 38 39 31 30 32 33 38 33 3420 4f 52 4e 3a 54 72 891023834 ORN:Tr2010-11-11 22:40:12 [9447] [6] DEBUG: data: 75 65 20 4d 6f 76 65 20 436f 6d 70 61 6e 79 20 ue Move Company2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 50 4f 4e 3a 54 72 75 6520 4d 6f 76 65 20 43 PON:True Move C2010-11-11 22:40:12 [9447] [6] DEBUG: data: 6f 6d 70 61 6e 79 20 20 524f 4e 3a 54 72 75 65 ompany RON:True2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 4d 6f 76 65 20 43 6f 6d70 61 6e 79 20 20 52 Move Company R2010-11-11 22:40:12 [9447] [6] DEBUG: data: 4f 43 3a 54 48 20 4d 43 434d 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 2020 20 20 20 20 20 20 Thailand2010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 20 20 20 20 20 20 2020 20 20 20 20 20 202010-11-11 22:40:12 [9447] [6] DEBUG: data: 20 20 20 20 20 20 20 20 2020 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: 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 6520 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 6520 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 6520 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 3833 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 DLRsmsc=smsc_2_1, ts=50111113401147953, dst=xxxx, type=12010-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 12010-11-11 22:40:12 [9447] [6] DEBUG: column=mask buffer_type=253max_length=0 length=2552010-11-11 22:40:12 [9447] [6] DEBUG: column=service buffer_type=253max_length=0 length=322010-11-11 22:40:12 [9447] [6] DEBUG: column=url buffer_type=253max_length=0 length=2552010-11-11 22:40:12 [9447] [6] DEBUG: column=source buffer_type=253max_length=0 length=202010-11-11 22:40:12 [9447] [6] DEBUG: column=destination buffer_type=253max_length=0 length=202010-11-11 22:40:12 [9447] [6] DEBUG: column=boxc buffer_type=253max_length=0 length=322010-11-11 22:40:12 [9447] [6] DEBUG: DLR[mysql]: created DLR message forURL<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 =0x00a5eb7f2010-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. Idon't think that it supports lists.2) Please post detailed bb logs with at least 1 deliver_sm PDU and a fewlines 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 andcan 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. ReadUG 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, orbearerbox? 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_smstables, 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 forURL<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 forURL<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 whenI 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

Re: SQLBox DLR Problem

Reply via email to