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.

Reply via email to