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 >
