On Tue, 2012-02-07 at 09:51, Trevor Benedict wrote: > 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. ^^^^^^^^^^^^^^^^^^^^^ Read userguide carefully.
dlr-storage is temporary 'place' where Kannel keeps DLR's until it process them. After Kannel finishes with them it then deletes them from temporary storage, be it xxSQL, file or memory. You can use sqlbox (or script/program) if you want to save incoming/outgoing data. > 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 > -- Kind regards, Milan -------------------------------------------------- Arvanta, IT Security http://www.arvanta.net Please do not send me e-mail containing HTML code or documents in proprietary format (word, excel, pps and so on)
