I am having a hell of a hard time trying to get bearerbox to save incoming smpp pdu's into the database. What am I doing wrong? Ive spent the last 3 days trying to get this working.
Ver: SVN Build `Feb 3 2012 10:44:12' Libxml version 2.7.8 Ubuntu 11.10 DEBUG: SMPP PDU 0x2624740 dump: DEBUG: type_name: deliver_sm DEBUG: command_id: 5 = 0x00000005 DEBUG: command_status: 0 = 0x00000000 DEBUG: sequence_number: 92 = 0x0000005c DEBUG: service_type: NULL DEBUG: source_addr_ton: 1 = 0x00000001 DEBUG: source_addr_npi: 1 = 0x00000001 DEBUG: source_addr: "119784068219" DEBUG: dest_addr_ton: 0 = 0x00000000 DEBUG: dest_addr_npi: 1 = 0x00000001 DEBUG: destination_addr: "41080197" DEBUG: esm_class: 4 = 0x00000004 DEBUG: protocol_id: 0 = 0x00000000 DEBUG: priority_flag: 0 = 0x00000000 DEBUG: schedule_delivery_time: NULL DEBUG: validity_period: NULL DEBUG: registered_delivery: 2 = 0x00000002 DEBUG: replace_if_present_flag: 0 = 0x00000000 DEBUG: data_coding: 0 = 0x00000000 DEBUG: sm_default_msg_id: 0 = 0x00000000 DEBUG: sm_length: 119 = 0x00000077 DEBUG: short_message: DEBUG: Octet string at 0x2625680: DEBUG: len: 119 DEBUG: size: 120 DEBUG: immutable: 0 DEBUG: data: 69 64 3a 34 37 37 31 44 46 36 39 20 73 75 62 3a id:4771DF69 sub: DEBUG: data: 30 30 31 20 64 6c 76 72 64 3a 30 30 30 20 73 75 001 dlvrd:000 su DEBUG: data: 62 6d 69 74 20 64 61 74 65 3a 31 30 30 35 31 30 bmit date:100510 DEBUG: data: 31 36 34 39 20 64 6f 6e 65 20 64 61 74 65 3a 31 1649 done date:1 DEBUG: data: 30 30 35 31 30 31 36 34 39 20 73 74 61 74 3a 52 005101649 stat:R DEBUG: data: 45 4a 45 43 54 44 20 65 72 72 3a 30 30 42 20 74 EJECTD err:00B t DEBUG: data: 65 78 74 3a 2b 58 54 3a 31 30 31 30 2c 31 30 35 ext:+XT:1010,105 DEBUG: data: 31 32 2c 32 30 39 2e 12,209. DEBUG: Octet string dump ends. DEBUG: message_state: 5 = 0x00000005 DEBUG: receipted_message_id: "4771DF69" DEBUG: SMPP PDU dump ends. DEBUG: SMPP['kore_smsc'] handle_pdu, got DLR DEBUG: DLR[mysql]: Looking for DLR smsc='kore_smsc', ts=1198645097, dst=119784068219, type=2 DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND `ts`=? LIMIT 1 DEBUG: column=mask buffer_type=3 max_length=0 length=10 DEBUG: column=service buffer_type=253 max_length=0 length=40 DEBUG: column=url buffer_type=253 max_length=0 length=255 DEBUG: column=source buffer_type=253 max_length=0 length=40 DEBUG: column=destination buffer_type=253 max_length=0 length=40 DEBUG: column=boxc buffer_type=253 max_length=0 length=40 WARNING: DLR[mysql]: DLR from SMSC<'kore_smsc'> for DST<119784068219> not found. ERROR: SMPP['kore_smsc']: got DLR but could not find message or was not interested in it id<1198645097> dst<119784068219>, type<2> group = smsc smsc = smpp host = xxx.com port = 2777 receive-port = 2777 smsc-username = xxxuser smsc-password = xxxpass keepalive = 55 system-type = 'VMA' interface-version = 34 transceiver-mode = 0 wait-ack = 60 smsc-id = 'kore_smsc' my-number= '89014104' source-addr-ton = 0 source-addr-npi = 1 dest-addr-ton = 1 dest-addr-npi = 1 bind-addr-ton = 0 bind-addr-npi = 0 connection-timeout = 60 throughput = 1 msg-id-type = "0x02" group = core admin-port = 13000 admin-password = bar #admin-deny-ip = "*.*.*.*" admin-allow-ip = "*.*.*.*" wapbox-port = 13002 wdp-interface-name = "*" log-file = "/var/log/kannel/bearerbox.log" #box-deny-ip = "*.*.*.*" box-allow-ip = "*.*.*.*" smsbox-port = 13003 dlr-storage = mysql store-type = file store-location = "/tmp/kannel.store" group = sms-service accepted-smsc = "kore_smsc" #tried a few things here keyword = id: catch-all = true omit-empty = true #doesnt work... exec = "echo '%a' >> /tmp/sms_in.txt" group = smsbox-route smsbox-id = "smsb" smsc-id = "kore_smsc" #shortcode = "8901" group = smsbox bearerbox-host = localhost #bearerbox-port = 13005 smsbox-id = "smsb" mo-recode = true group = mysql-connection id = mydlr host = 10.0.0.20 username = xxxmysql password = xxxmysql database = kannel 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
