Hi, I am submitting SMS from Kannel based SMPP client to a different server having kannel based setup+opensmppbox+sqlbox stack. The SMS is always getting REJECTED. The issuea are:
1.) Opemsmppbox is taking system-id (username in smpplogins.txt) as SMSC and then rejecting it 2.) SQLBOX shows no activity except an error: sql_id cannot be null I have this setup SMSC<---> BB <---> SQLBOX <----> Opensmppbox <---> SMPP client //------------ HERE ARE THE CONFIG FILES-------------// //Kannel.conf group=core admin-port = 14000 smsbox-port = 13001 admin-password = sam status-password = log-file = "/var/log/kannel/kannel.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" access-log = "/var/log/kannel/access.log" store-file = "kannel.store" dlr-storage = mysql #--------------------------------------------- # SMSC CONNECTIONS group=smsc smsc = smpp smsc-id = Promotional host = xxx.xx.xxx.xxx port = xxxx smsc-username = xxxxx smsc-password = xxxxx system-type = VMA source-addr-ton = 0 source-addr-npi = 0 dest-addr-ton = 0 dest-addr-npi = 0 allowed-smsc-id = Promotional transceiver-mode = true receive-port = xxxx #--------------------------------------------- # SMSBOX SETUP group=smsbox smsbox-id = main-box bearerbox-host = 127.0.0.1 sendsms-port = 14014 global-sender = 14014 log-file = "/tmp/smsbox.log" access-log = "/tmp/access.log" group=smsbox-route smsbox-id = smppclient smsc-id = Promotional #--------------------------------------------- # SEND-SMS USERS group=sendsms-user username = sam password = sam max-messages = 5 concatenation = true #--------------------------------------------- # SERVICES group=sms-service keyword = nop text = "You asked nothing and I did it!" group=sms-service keyword = default get-url = " http://domain.com/index.php?senderid=%P&phone=%p&reply=%a&smscid=%i" max-messages = 0 group = mysql-connection id = mydlr host = localhost username = xxxx_sam password = "xxxx" database = xxxx_xxx max-connections = 5 group = dlr-db id = mydlr table = sc_kannel_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 // Opensmppbox.conf group = core dlr-storage = mysql group = opensmppbox opensmppbox-id = nvsmpp opensmppbox-port = 2345 bearerbox-host = localhost bearerbox-port = 13014 use-systemid-as-smsboxid = true log-file = "/var/log/smpp/smppbox.log" our-system-id = "VSMSC" smpp-logins = smpplogins.txt group = mysql-connection id = mydlr host = localhost username = xxxx_xxx password = xxxx database = xxxx_xxx #DLR Table Structure group = dlr-db id = mydlr table = sc_smpp_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_id // SQLbox.conf group = sqlbox id = sqlbox-db smsbox-id = sqlbox bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13014 smsbox-port-ssl = false sql-log-table = sc_sqlbox_log sql-insert-table = sc_smpp_incoming log-file = "/var/log/nvsmpp/test_smpp/sqlbox.log" log-level = 0 group = mysql-connection id = sqlbox-db host = localhost username = xxxxx_xxx password = xxx database = xxxx_xxxx # you can increase this upon a higher load max-connections = 5 // SMPPlogins.txt file smppclient goodsmpp testsmpp *.*.*.* Now I've done everything as directed but still, its not working. Here is what I got from SMPPBOX>LOG file //-----------------------------------SMPP PDU DUMP------------- 2013-09-28 02:14:17 [2578] [11] DEBUG: SMPP[smppclient]: Got PDU: 2013-09-28 02:14:17 [2578] [11] DEBUG: SMPP PDU 0x7f9874001380 dump: 2013-09-28 02:14:17 [2578] [11] DEBUG: type_name: submit_sm 2013-09-28 02:14:17 [2578] [11] DEBUG: command_id: 4 = 0x00000004 2013-09-28 02:14:17 [2578] [11] DEBUG: command_status: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: sequence_number: 2377 = 0x00000949 2013-09-28 02:14:17 [2578] [11] DEBUG: service_type: NULL 2013-09-28 02:14:17 [2578] [11] DEBUG: source_addr_ton: 5 = 0x00000005 2013-09-28 02:14:17 [2578] [11] DEBUG: source_addr_npi: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: source_addr: "OPAUTO" 2013-09-28 02:14:17 [2578] [11] DEBUG: dest_addr_ton: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: dest_addr_npi: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: destination_addr: "9694304016" 2013-09-28 02:14:17 [2578] [11] DEBUG: esm_class: 3 = 0x00000003 2013-09-28 02:14:17 [2578] [11] DEBUG: protocol_id: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: priority_flag: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: schedule_delivery_time: NULL 2013-09-28 02:14:17 [2578] [11] DEBUG: validity_period: NULL 2013-09-28 02:14:17 [2578] [11] DEBUG: registered_delivery: 1 = 0x00000001 2013-09-28 02:14:17 [2578] [11] DEBUG: replace_if_present_flag: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: data_coding: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: sm_default_msg_id: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [11] DEBUG: sm_length: 18 = 0x00000012 2013-09-28 02:14:17 [2578] [11] DEBUG: short_message: "TEST using smppbox" 2013-09-28 02:14:17 [2578] [11] DEBUG: SMPP PDU dump ends. //------------------------------DB Operations in smppbox.log------------------ 2013-09-28 02:14:17 [2578] [11] DEBUG: DLR[mysql]: Adding DLR smsc=smppclient, ts=21f20c77, src=OPAUTO, dst=9694304016, mask=19, boxc=smppclient 2013-09-28 02:14:17 [2578] [11] DEBUG: adding DLR entry into database 2013-09-28 02:14:17 [2578] [11] DEBUG: sql: INSERT INTO `sc_smpp_dlr` (`smsc`, `timestamp`, `source`, `destination`, `service`, `url`, `mask`, `boxc_id`, `status`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0) 2013-09-28 02:14:17 [2578] [10] DEBUG: SMPP[smppclient]: Sending PDU: 2013-09-28 02:14:17 [2578] [10] DEBUG: SMPP PDU 0x7f9874000d70 dump: 2013-09-28 02:14:17 [2578] [10] DEBUG: type_name: submit_sm_resp 2013-09-28 02:14:17 [2578] [10] DEBUG: command_id: 2147483652 = 0x80000004 2013-09-28 02:14:17 [2578] [10] DEBUG: command_status: 69 = 0x00000045 2013-09-28 02:14:17 [2578] [10] DEBUG: sequence_number: 2377 = 0x00000949 2013-09-28 02:14:17 [2578] [10] DEBUG: message_id: NULL 2013-09-28 02:14:17 [2578] [10] DEBUG: SMPP PDU dump ends. 2013-09-28 02:14:17 [2578] [10] INFO: We received an SMS message. 2013-09-28 02:14:17 [2578] [10] DEBUG: DLR[mysql]: Looking for DLR smsc=smppclient, ts=21f20c77, dst=9694304016, type=16 2013-09-28 02:14:17 [2578] [10] DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `destination`, `boxc_id` FROM `sc_smpp_dlr` WHERE `smsc`=? AND `timestamp`=? LIMIT 1 2013-09-28 02:14:17 [2578] [10] DEBUG: column=mask buffer_type=253 max_length=0 length=250 2013-09-28 02:14:17 [2578] [10] DEBUG: column=service buffer_type=253 max_length=0 length=250 2013-09-28 02:14:17 [2578] [10] DEBUG: column=url buffer_type=252 max_length=0 length=16777215 2013-09-28 02:14:17 [2578] [10] DEBUG: column=source buffer_type=253 max_length=0 length=250 2013-09-28 02:14:17 [2578] [10] DEBUG: column=destination buffer_type=253 max_length=0 length=250 2013-09-28 02:14:17 [2578] [10] DEBUG: column=boxc_id buffer_type=253 max_length=0 length=250 2013-09-28 02:14:17 [2578] [10] DEBUG: DLR[mysql]: created DLR message for URL <21f20c77> 2013-09-28 02:14:17 [2578] [10] DEBUG: removing DLR from database 2013-09-28 02:14:17 [2578] [10] DEBUG: sql: DELETE FROM `sc_smpp_dlr` WHERE `smsc`=? AND `timestamp`=? LIMIT 1 //---------------------------RESPONSE --------------------------------------- 2013-09-28 02:14:17 [2578] [10] DEBUG: SMPP[smppclient]: Sending PDU: 2013-09-28 02:14:17 [2578] [10] DEBUG: SMPP PDU 0x7f9880003fd0 dump: 2013-09-28 02:14:17 [2578] [10] DEBUG: type_name: deliver_sm 2013-09-28 02:14:17 [2578] [10] DEBUG: command_id: 5 = 0x00000005 2013-09-28 02:14:17 [2578] [10] DEBUG: command_status: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: sequence_number: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: service_type: NULL 2013-09-28 02:14:17 [2578] [10] DEBUG: source_addr_ton: 2 = 0x00000002 2013-09-28 02:14:17 [2578] [10] DEBUG: source_addr_npi: 1 = 0x00000001 2013-09-28 02:14:17 [2578] [10] DEBUG: source_addr: "OPAUTO" 2013-09-28 02:14:17 [2578] [10] DEBUG: dest_addr_ton: 2 = 0x00000002 2013-09-28 02:14:17 [2578] [10] DEBUG: dest_addr_npi: 1 = 0x00000001 2013-09-28 02:14:17 [2578] [10] DEBUG: destination_addr: "9694304016" 2013-09-28 02:14:17 [2578] [10] DEBUG: esm_class: 4 = 0x00000004 2013-09-28 02:14:17 [2578] [10] DEBUG: protocol_id: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: priority_flag: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: schedule_delivery_time: NULL 2013-09-28 02:14:17 [2578] [10] DEBUG: validity_period: NULL 2013-09-28 02:14:17 [2578] [10] DEBUG: registered_delivery: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: replace_if_present_flag: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: data_coding: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: sm_default_msg_id: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: sm_length: 0 = 0x00000000 2013-09-28 02:14:17 [2578] [10] DEBUG: short_message: 2013-09-28 02:14:17 [2578] [10] DEBUG: Octet string at 0x7f988000ac90: 2013-09-28 02:14:17 [2578] [10] DEBUG: len: 112 2013-09-28 02:14:17 [2578] [10] DEBUG: size: 1024 2013-09-28 02:14:17 [2578] [10] DEBUG: immutable: 0 2013-09-28 02:14:17 [2578] [10] DEBUG: data: 69 64 3a 32 31 66 32 30 63 37 37 20 73 75 62 3a id:21f20c77 sub: 2013-09-28 02:14:17 [2578] [10] DEBUG: data: 30 30 31 20 64 6c 76 72 64 3a 30 30 30 20 73 75 001 dlvrd:000 su 2013-09-28 02:14:17 [2578] [10] DEBUG: data: 62 6d 69 74 20 64 61 74 65 3a 31 33 30 39 32 38 bmit date:130928 2013-09-28 02:14:17 [2578] [10] DEBUG: data: 30 32 31 34 20 64 6f 6e 65 20 64 61 74 65 3a 31 0214 done date:1 2013-09-28 02:14:17 [2578] [10] DEBUG: data: 33 30 39 32 38 30 32 31 34 20 73 74 61 74 3a 55 309280214 stat:U 2013-09-28 02:14:17 [2578] [10] DEBUG: data: 4e 44 45 4c 49 56 20 65 72 72 3a 30 30 30 20 74 NDELIV err:000 t 2013-09-28 02:14:17 [2578] [10] DEBUG: data: 65 78 74 3a 4e 41 43 4b 2f 6e 6f 20 53 4d 53 43 ext:NACK/no SMSC 2013-09-28 02:14:17 [2578] [10] DEBUG: Octet string dump ends. 2013-09-28 02:14:17 [2578] [10] DEBUG: message_state: 5 = 0x00000005 2013-09-28 02:14:17 [2578] [10] DEBUG: receipted_message_id: "21f20c77" 2013-09-28 02:14:17 [2578] [10] DEBUG: SMPP PDU dump ends. //--------------- Now you can clearly see NACK/No SMSC in the response. Please guide me how do I fix this.