Thanks a lot! That did the trick. The broken lines where caused by my mailclient, it's not like that in the config-file.
Br Gunnar Gilhoff Den 14. des. 2010 13:17, skrev Nikos Balkanas: > Just comment out msg-id-type and you should be OK. BTW what's the deal > with the broken lines in your configuration? I hope it is not like that. > > BR, > Nikos > ----- Original Message ----- From: "Gunnar Gilhoff" > <[email protected]> > To: "Nikos Balkanas" <[email protected]> > Cc: <[email protected]> > Sent: Tuesday, December 14, 2010 10:35 AM > Subject: Re: Dlr problem > > >> Hi, >> >> Here it is >> >> group = core >> admin-port = 15008 >> smsbox-port = 15009 >> admin-password = pw >> status-password = pw >> log-level = 0 >> box-deny-ip = "*.*.*.*" >> box-allow-ip = "127.0.0.1" >> unified-prefix = ",0034" >> log-file = >> "/home/kannel/logs/smpp.log" >> >> access-log = >> "/home/kannel/logs/access.log" >> >> store-type = >> "spool" >> >> store-location = >> "/home/kannel/spool/conn_123" >> >> dlr-storage = >> mysql >> >> >> >> group = >> smsc >> >> smsc = >> smpp >> >> smsc-id = >> CONN_123 >> >> host = >> 111.222.333.444 >> >> port = >> 3600 >> >> preferred-smsc-id = >> CONN_123 >> >> transceiver-mode = >> yes >> >> smsc-username = >> "un" >> >> smsc-password = >> pw >> >> system-type = >> "MESS" >> >> alt-charset = >> "ISO-8859-1" >> >> address-range = >> "" >> >> dest-addr-ton = >> 1 >> >> source-addr-ton = >> 0 >> >> source-addr-npi = >> 1 >> >> interface-version = >> "34" >> >> throughput = 5 >> msg-id-type = >> 1 >> >> >> # SMSBOX SETUP >> group = smsbox >> bearerbox-host = localhost >> sendsms-port = 15017 >> immediate-sendsms-reply = true >> sendsms-chars = "0123456789 +-" >> log-file = "/home/kannel/logs/smsbox.log" >> >> >> # SEND-SMS USERS >> group = sendsms-user >> username = un >> password = pw >> user-deny-ip = "*" >> user-allow-ip = "127.0.0.1" >> max-messages = 5 >> concatenation = true >> >> >> # SERVICES >> >> # there should be default always >> >> group = sms-service >> keyword = default >> get-url="http://localhost/sms.php?sms=%a&mobilnummer=%p&konto=%P&udh=%u"; >> max-messages = 5 >> concatenation = true >> accept-x-kannel-headers = true >> omit-empty = true >> >> group = mysql-connection >> id = mydlr >> host = localhost >> username = un >> password = pw >> database = kannel >> # max count of connections that will be opened for dbpool >> # default is 1 >> max-connections = 1 >> >> group = dlr-db >> id = mydlr >> table = dlr >> field-smsc = smsc >> field-timestamp = ts >> field-destination = destination >> field-source = source >> field-service = service >> field-url = url >> field-mask = mask >> field-status = status >> field-boxc-id = boxc >> >> >> Br >> >> Gunnar Gilhoff >> >> >> Den 13. des. 2010 20:14, skrev Nikos Balkanas: >>> Hi, >>> >>> Please post your configuration. >>> >>> BR, >>> Nikos >>> ----- Original Message ----- From: "Gunnar Gilhoff" >>> <[email protected]> >>> To: <[email protected]> >>> Sent: Tuesday, December 14, 2010 2:03 AM >>> Subject: Dlr problem >>> >>> >>>> Hi, >>>> >>>> I'm having a problem with dlr and mysql. It seems the messageid >>>> assigned >>>> by the smsc are altered to a different value when used in >>>> sql-sentences. >>>> The problem is that the value is the same for all messages, >>>> 9223372036854775807, which is the max value if an unsigned bigint. >>>> The original messageid is eg. 12ce1e325e0ac103ffffffffb9579f1c >>>> >>>> 2010-12-13 23:39:08 [15400] [8] DEBUG: boxc_receiver: sms received >>>> 2010-12-13 23:39:08 [15400] [8] DEBUG: send_msg: sending msg to box: >>>> <127.0.0.1> >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP[CONN_123]: throughput >>>> (0.00,5.00) >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP[CONN_123]: Manually forced >>>> source addr ton = 0, source add npi = 1 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP[CONN_123]: Sending PDU: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP PDU 0x1d45480 dump: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: type_name: submit_sm >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: command_id: 4 = 0x00000004 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: command_status: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: sequence_number: 9912 = >>>> 0x000026b8 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: service_type: NULL >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: source_addr_ton: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: source_addr_npi: 1 = >>>> 0x00000001 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: source_addr: "xxxx" >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: dest_addr_ton: 1 = 0x00000001 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: destination_addr: >>>> "xxxxxxxxxx" >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: esm_class: 3 = 0x00000003 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: protocol_id: 0 = 0x00000000 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: priority_flag: 3 = 0x00000003 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: schedule_delivery_time: NULL >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: validity_period: NULL >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: registered_delivery: 1 = >>>> 0x00000001 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: replace_if_present_flag: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: data_coding: 241 = 0x000000f1 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: sm_default_msg_id: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: sm_length: 40 = 0x00000028 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: short_message: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: Octet string at 0x1d29900: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: len: 40 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: size: 41 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: immutable: 0 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: data: 4d 65 6c 64 69 6e 67 >>>> 65 6e 20 64 69 6e 20 62 6c Meldingen din bl >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: data: 65 20 73 65 6e 64 74 >>>> 20 75 74 20 74 69 6c 20 39 e sendt ut til 9 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: data: 20 62 72 75 6b 65 72 >>>> 65 brukere >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: Octet string dump ends. >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP PDU dump ends. >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP[CONN_123]: throughput >>>> (1.00,5.00) >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP[CONN_123]: throughput >>>> (1.00,5.00) >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP[CONN_123]: Got PDU: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP PDU 0x1d45480 dump: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: type_name: submit_sm_resp >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: command_id: 2147483652 = >>>> 0x80000004 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: command_status: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: sequence_number: 9912 = >>>> 0x000026b8 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: message_id: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: Octet string at 0x1d29900: >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: len: 32 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: size: 33 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: immutable: 0 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: data: 31 32 63 65 31 65 33 >>>> 32 35 65 30 61 63 31 30 33 12ce1e325e0ac103 >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: data: 66 66 66 66 66 66 66 >>>> 66 62 39 35 37 39 66 31 63 ffffffffb9579f1c >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: Octet string dump ends. >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP PDU dump ends. >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: DLR[mysql]: Adding DLR >>>> smsc=CONN_123, ts=9223372036854775807, src=xxxx, dst=xxxxxxxxxx, >>>> mask=31, boxc= >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: adding DLR entry into database >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: sql: INSERT INTO `dlr` (`smsc`, >>>> `ts`, `source`, `destination`, `service`, `url`, `mask`, `boxc`, >>>> `status`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0) >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMSC[CONN_123]: creating DLR >>>> message >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMSC[CONN_123]: DLR = >>>> http://localhost/dlr.php?id=8972625&status=%d >>>> 2010-12-13 23:39:08 [15400] [9] DEBUG: send_msg: sending msg to box: >>>> <127.0.0.1> >>>> 2010-12-13 23:39:08 [15400] [9] DEBUG: boxc_sender: sent message to >>>> <127.0.0.1> >>>> 2010-12-13 23:39:08 [15400] [6] DEBUG: SMPP[CONN_123]: throughput >>>> (1.00,5.00) >>>> 2010-12-13 23:39:08 [15400] [8] DEBUG: boxc_receiver: got ack >>>> >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP[CONN_123]: throughput >>>> (0.00,5.00) >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Optional parameter tag (0x0427) >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Optional parameter length read >>>> as 1 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Optional parameter tag (0x001e) >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Optional parameter length read >>>> as 33 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP[CONN_123]: Got PDU: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP PDU 0x1d4e920 dump: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: type_name: deliver_sm >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: command_id: 5 = 0x00000005 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: command_status: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: sequence_number: 792 = >>>> 0x00000318 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: service_type: NULL >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: source_addr_ton: 1 = >>>> 0x00000001 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: source_addr_npi: 1 = >>>> 0x00000001 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: source_addr: "xxxxxxxxxx" >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: dest_addr_ton: 0 = 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: destination_addr: "xxxx" >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: esm_class: 4 = 0x00000004 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: protocol_id: 0 = 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: priority_flag: 0 = 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: schedule_delivery_time: NULL >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: validity_period: NULL >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: registered_delivery: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: replace_if_present_flag: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data_coding: 3 = 0x00000003 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: sm_default_msg_id: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: sm_length: 144 = 0x00000090 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: short_message: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Octet string at 0x1d28240: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: len: 144 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: size: 145 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: immutable: 0 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 69 64 3a 31 32 63 65 >>>> 31 65 33 32 35 65 30 61 63 id:12ce1e325e0ac >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 31 30 33 66 66 66 66 >>>> 66 66 66 66 62 39 35 37 39 103ffffffffb9579 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 66 31 63 20 73 75 62 >>>> 3a 30 30 31 20 64 6c 76 72 f1c sub:001 dlvr >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 64 3a 30 30 31 20 73 >>>> 75 62 6d 69 74 20 64 61 74 d:001 submit dat >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 65 3a 31 30 31 32 31 >>>> 33 32 33 33 39 20 64 6f 6e e:1012132339 don >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 65 20 64 61 74 65 3a >>>> 31 30 31 32 31 33 32 33 33 e date:101213233 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 39 20 73 74 61 74 3a >>>> 44 45 4c 49 56 52 44 20 65 9 stat:DELIVRD e >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 72 72 3a 30 30 30 20 >>>> 74 65 78 74 3a 20 20 20 20 rr:000 text: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 20 20 20 20 20 20 20 >>>> 20 20 20 20 20 20 20 20 20 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Octet string dump ends. >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: message_state: 2 = 0x00000002 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: receipted_message_id: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Octet string at 0x1d153a0: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: len: 32 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: size: 33 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: immutable: 0 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 31 32 63 65 31 65 33 >>>> 32 35 65 30 61 63 31 30 33 12ce1e325e0ac103 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: data: 66 66 66 66 66 66 66 >>>> 66 62 39 35 37 39 66 31 63 ffffffffb9579f1c >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: Octet string dump ends. >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP PDU dump ends. >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP[CONN_123] handle_pdu, got >>>> DLR >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: DLR[mysql]: Looking for DLR >>>> smsc=CONN_123, ts=9223372036854775807, dst=xxxxxxxxxx, type=1 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: sql: SELECT `mask`, `service`, >>>> `url`, `source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND >>>> `ts`=? LIMIT 1 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: column=mask buffer_type=1 >>>> max_length=0 length=2 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: column=service buffer_type=253 >>>> max_length=0 length=15 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: column=url buffer_type=253 >>>> max_length=0 length=255 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: column=source buffer_type=253 >>>> max_length=0 length=5 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: column=destination >>>> buffer_type=253 max_length=0 length=40 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: column=boxc buffer_type=253 >>>> max_length=0 length=40 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: DLR[mysql]: created DLR message >>>> for URL <http://localhost/dlr.php?id=8972625&status=%d> >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: removing DLR from database >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: sql: DELETE FROM `dlr` WHERE >>>> `smsc`=? AND `ts`=? LIMIT 1 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: new group created `smpp' >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: group=`smpp' key=`dlr_err' >>>> value=`000' >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP[CONN_123]: Sending PDU: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP PDU 0x1d45ec0 dump: >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: type_name: deliver_sm_resp >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: command_id: 2147483653 = >>>> 0x80000005 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: command_status: 0 = >>>> 0x00000000 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: sequence_number: 792 = >>>> 0x00000318 >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: message_id: NULL >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP PDU dump ends. >>>> 2010-12-13 23:39:20 [15400] [6] DEBUG: SMPP[CONN_123]: throughput >>>> (0.00,5.00) >>>> 2010-12-13 23:39:20 [15400] [9] DEBUG: send_msg: sending msg to box: >>>> <127.0.0.1> >>>> 2010-12-13 23:39:20 [15400] [9] DEBUG: boxc_sender: sent message to >>>> <127.0.0.1> >>>> 2010-12-13 23:39:20 [15400] [8] DEBUG: boxc_receiver: got ack >>>> >>>> It will work as long as the DR is received before the next MT is sent. >>>> Else I would get a duplicate entry in the dlr-table and DR's will be >>>> lost. >>>> >>>> Any help would be appreciated. >>>> >>>> >>>> Br >>>> >>>> Gunnar Gilhoff >>>> >>> >
