Thanks Keita. It works. Now I can see messages in the sent_sms table. Actually now I know how boxes connect each other because of you explanation. I have another problem and it also solved partially with this, but still have.
So let me explain about that somehow. (I'm a student and I don't have real SMPP connections. Therefore I use SMPPSim) 1) Before your solution ================ When I tried to store DLRs, earlier those DLRs did not store in the dlr table and it was empty. And I got some kind of bb log, you can see it on below. 2) After your solution (separate conf files for each box) ======================================= Now it stores DLRs, but TimeStamp value is different (looks like message_id to me). And the bb.log is still same for sql query. This is the dlr table after your solution. +---------------+--------+--------------------+-----------+---------+------+---------+---------+-----------------+ | smsc | ts | destination | source | service | url | mask | status | boxc | +---------------+--------+--------------------+-----------+---------+------+----------+---------+-----------------+ | SMPPSim | 1847 | 94718282928 | 1234 | a | | 31 | 0 | mysmsbox | | SMPPSim | 2185 | 94718282928 | 1234 | a | | 31 | 0 | mysmsbox | | SMPPSim | 2192 | 94718282928 | 1234 | a | | 31 | 0 | mysmsbox | | SMPPSim | 2400 | 94718282928 | 1234 | a | | 31 | 0 | mysmsbox | | SMPPSim | 2401 | 94718282928 | 55555 | a | | 31 | 0 | mysmsbox | | SMPPSim | 2402 | 94718282928 | 55555 | a | | 31 | 0 | mysmsbox | | SMPPSim | 2403 | 94718282928 | 55555 | a | | 31 | 0 | mysmsbox | | SMPPSim | 2404 | 94718282928 | 55555 | a | | 31 | 0 | mysmsbox | *|SMPPSim | 3 | 94718282920 | 55555 | a | | 31 | 0 | mysmsbox | <------ This just was removed after bb got the response.* +---------------+--------+--------------------+-----------+---------+------+---------+---------+------------------+ This is some part of the bb log and it is same way like earlier. ........................................................................................................................................ SMPP[SMPPSim]: Sending PDU: 2012-01-04 01:41:39 [1778] [6] DEBUG: SMPP PDU 0x9181f00 dump: 2012-01-04 01:41:39 [1778] [6] DEBUG: type_name: submit_sm 2012-01-04 01:41:39 [1778] [6] DEBUG: command_id: 4 = 0x00000004 2012-01-04 01:41:39 [1778] [6] DEBUG: command_status: 0 = 0x00000000 2012-01-04 01:41:39 [1778] [6] DEBUG: sequence_number: 57 = 0x00000039 2012-01-04 01:41:39 [1778] [6] DEBUG: service_type: NULL 2012-01-04 01:41:39 [1778] [6] DEBUG: source_addr_ton: 2 = 0x00000002 2012-01-04 01:41:39 [1778] [6] DEBUG: source_addr_npi: 1 = 0x00000001 2012-01-04 01:41:39 [1778] [6] DEBUG: source_addr: "55555" 2012-01-04 01:41:39 [1778] [6] DEBUG: dest_addr_ton: 2 = 0x00000002 2012-01-04 01:41:39 [1778] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2012-01-04 01:41:39 [1778] [6] DEBUG: destination_addr: "94718282920" 2012-01-04 01:41:39 [1778] [6] DEBUG: esm_class: 3 = 0x00000003 2012-01-04 01:41:39 [1778] [6] DEBUG: protocol_id: 0 = 0x00000000 2012-01-04 01:41:39 [1778] [6] DEBUG: priority_flag: 0 = 0x00000000 2012-01-04 01:41:39 [1778] [6] DEBUG: schedule_delivery_time: NULL 2012-01-04 01:41:39 [1778] [6] DEBUG: validity_period: NULL 2012-01-04 01:41:39 [1778] [6] DEBUG: registered_delivery: 1 = 0x00000001 2012-01-04 01:41:39 [1778] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-01-04 01:41:39 [1778] [6] DEBUG: data_coding: 0 = 0x00000000 2012-01-04 01:41:39 [1778] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-01-04 01:41:39 [1778] [6] DEBUG: sm_length: 13 = 0x0000000d 2012-01-04 01:41:39 [1778] [6] DEBUG: short_message: "hello suranga" 2012-01-04 01:41:39 [1778] [6] DEBUG: SMPP PDU dump ends. 2012-01-04 01:41:39 [1778] [11] DEBUG: send_msg: sending msg to boxc: <mysmsbox> 2012-01-04 01:41:39 [1778] [6] DEBUG: SMPP[SMPPSim]: throughput (1.00,0.00) 2012-01-04 01:41:39 [1778] [6] DEBUG: SMPP[SMPPSim]: throughput (1.00,0.00) 2012-01-04 01:41:39 [1778] [6] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-01-04 01:41:39 [1778] [6] DEBUG: SMPP PDU 0x917ed48 dump: 2012-01-04 01:41:39 [1778] [6] DEBUG: type_name: submit_sm_resp 2012-01-04 01:41:39 [1778] [6] DEBUG: command_id: 2147483652 = 0x80000004 2012-01-04 01:41:39 [1778] [6] DEBUG: command_status: 0 = 0x00000000 2012-01-04 01:41:39 [1778] [6] DEBUG: sequence_number: 57 = 0x00000039 2012-01-04 01:41:39 [1778] [6] DEBUG: *message_id: "3"* 2012-01-04 01:41:39 [1778] [6] DEBUG: SMPP PDU dump ends. 2012-01-04 01:41:39 [1778] [6] DEBUG: DLR[mysql]: Adding DLR smsc=SMPPSim, * ts=3*, src=55555, dst=94718282920, mask=31, boxc=mysmsbox 2012-01-04 01:41:39 [1778] [6] DEBUG: adding DLR entry into database 2012-01-04 01:41:39 [1778] [6] DEBUG: sql: INSERT INTO `dlr` (`smsc`, `ts`, `source`, `destination`, `service`, `url`, `mask`, `boxc`, `status`) *VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0)* 2012-01-04 01:41:39 [1778] [6] DEBUG: SMSC[SMPPSim]: creating DLR message 2012-01-04 01:41:39 [1778] [6] DEBUG: SMSC[SMPPSim]: DLR = 2012-01-04 01:41:39 [1778] [12] DEBUG: send_msg: sending msg to boxc: <mysmsbox> 2012-01-04 01:41:39 [1778] [12] DEBUG: boxc_sender: sent message to <127.0.0.1> .............. .............. .............. 2012-01-04 01:45:35 [1778] [6] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-01-04 01:45:35 [1778] [6] DEBUG: SMPP PDU 0x91823b8 dump: 2012-01-04 01:45:35 [1778] [6] DEBUG: type_name: deliver_sm 2012-01-04 01:45:35 [1778] [6] DEBUG: command_id: 5 = 0x00000005 2012-01-04 01:45:35 [1778] [6] DEBUG: command_status: 0 = 0x00000000 2012-01-04 01:45:35 [1778] [6] DEBUG: sequence_number: 10 = 0x0000000a 2012-01-04 01:45:35 [1778] [6] DEBUG: service_type: NULL 2012-01-04 01:45:35 [1778] [6] DEBUG: source_addr_ton: 2 = 0x00000002 2012-01-04 01:45:35 [1778] [6] DEBUG: source_addr_npi: 1 = 0x00000001 2012-01-04 01:45:35 [1778] [6] DEBUG: source_addr: "94718282920" 2012-01-04 01:45:35 [1778] [6] DEBUG: dest_addr_ton: 2 = 0x00000002 2012-01-04 01:45:35 [1778] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2012-01-04 01:45:35 [1778] [6] DEBUG: destination_addr: "55555" 2012-01-04 01:45:35 [1778] [6] DEBUG: esm_class: 4 = 0x00000004 2012-01-04 01:45:35 [1778] [6] DEBUG: protocol_id: 0 = 0x00000000 2012-01-04 01:45:35 [1778] [6] DEBUG: priority_flag: 0 = 0x00000000 2012-01-04 01:45:35 [1778] [6] DEBUG: schedule_delivery_time: NULL 2012-01-04 01:45:35 [1778] [6] DEBUG: validity_period: NULL 2012-01-04 01:45:35 [1778] [6] DEBUG: registered_delivery: 0 = 0x00000000 2012-01-04 01:45:35 [1778] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-01-04 01:45:35 [1778] [6] DEBUG: data_coding: 0 = 0x00000000 2012-01-04 01:45:35 [1778] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-01-04 01:45:35 [1778] [6] DEBUG: sm_length: 106 = 0x0000006a 2012-01-04 01:45:35 [1778] [6] DEBUG: short_message: 2012-01-04 01:45:35 [1778] [6] DEBUG: Octet string at 0x918c770: 2012-01-04 01:45:35 [1778] [6] DEBUG: len: 106 2012-01-04 01:45:35 [1778] [6] DEBUG: size: 107 2012-01-04 01:45:35 [1778] [6] DEBUG: immutable: 0 2012-01-04 01:45:35 [1778] [6] DEBUG: data: 69 64 3a 33 20 73 75 62 3a 30 30 31 20 64 6c 76 *id:3* sub:001 dlv 2012-01-04 01:45:35 [1778] [6] DEBUG: data: 72 64 3a 30 30 31 20 73 75 62 6d 69 74 20 64 61 rd:001 submit da 2012-01-04 01:45:35 [1778] [6] DEBUG: data: 74 65 3a 31 32 30 31 30 34 30 37 31 35 20 64 6f te:1201040715 do 2012-01-04 01:45:35 [1778] [6] DEBUG: data: 6e 65 20 64 61 74 65 3a 31 32 30 31 30 34 30 37 ne date:12010407 2012-01-04 01:45:35 [1778] [6] DEBUG: data: 31 35 20 73 74 61 74 3a 44 45 4c 49 56 52 44 20 15 stat:DELIVRD 2012-01-04 01:45:35 [1778] [6] DEBUG: data: 65 72 72 3a 30 30 30 20 54 65 78 74 3a 68 65 6c err:000 Text:hel 2012-01-04 01:45:35 [1778] [6] DEBUG: data: 6c 6f 20 73 75 72 61 6e 67 61 lo suranga 2012-01-04 01:45:35 [1778] [6] DEBUG: Octet string dump ends. 2012-01-04 01:45:35 [1778] [6] DEBUG: SMPP PDU dump ends. 2012-01-04 01:45:35 [1778] [6] DEBUG: SMPP[SMPPSim] handle_pdu, got DLR 2012-01-04 01:45:35 [1778] [6] DEBUG: DLR[mysql]: Looking for DLR smsc=SMPPSim,* ts=3*, dst=94718282920, type=1 2012-01-04 01:45:35 [1778] [6] DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `destination`, `boxc` FROM `dlr` WHERE *`smsc`=? AND `ts`=?* LIMIT 1 2012-01-04 01:45:35 [1778] [6] DEBUG: column=mask buffer_type=3 max_length=0 length=10 2012-01-04 01:45:35 [1778] [6] DEBUG: column=service buffer_type=253 max_length=0 length=40 2012-01-04 01:45:35 [1778] [6] DEBUG: column=url buffer_type=253 max_length=0 length=255 2012-01-04 01:45:35 [1778] [6] DEBUG: column=source buffer_type=253 max_length=0 length=40 2012-01-04 01:45:35 [1778] [6] DEBUG: column=destination buffer_type=253 max_length=0 length=40 2012-01-04 01:45:35 [1778] [6] DEBUG: column=boxc buffer_type=253 max_length=0 length=40 2012-01-04 01:45:35 [1778] [6] DEBUG: DLR[mysql]: created DLR message for URL <> 2012-01-04 01:45:35 [1778] [6] DEBUG: removing DLR from database 2012-01-04 01:45:35 [1778] [6] DEBUG: sql: DELETE FROM `dlr` WHERE `*smsc`=? AND `ts`=?* LIMIT 1 2012-01-04 01:45:35 [1778] [6] DEBUG: new group created `smpp' 2012-01-04 01:45:35 [1778] [6] DEBUG: group=`smpp' key=`dlr_err' value=`000' 2012-01-04 01:45:36 [1778] [12] DEBUG: send_msg: sending msg to boxc: <mysmsbox> 2012-01-04 01:45:36 [1778] [12] DEBUG: boxc_sender: sent message to <127.0.0.1> ........................................................................................................................................................................................................... What I want to know is, you can see that TimeStamp is strange (and there are *? *marks on* *the log relevant to the dlr) . Can you tell me, this is OK or why this is happening or if it is a problem then how can it be resolved.... Thank You. Suranga.
