Yes. Your problem is that you are connecting smppbox directly to bb, not
sqlbox. Therefore no traffic goes through sqlbox. To inplement your flow you
need to change in group openssmppbox:
bearerbox-port = 33009
BR,
Nikos
----- Original Message -----
From: Adeagbo Tunji
To: Nikos Balkanas
Cc: [email protected]
Sent: Tuesday, November 23, 2010 4:29 PM
Subject: Re: smppbox with sqlbox
Thanks Nikos
Find below the configuration
=== sqlbox=====
group = sqlbox
id = sqlbox-db
smsbox-id = abu
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 23005
smsbox-port = 33009
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/nvsmpp/test_smpp/sqlbox.log"
log-level = 0
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = ][23
database = SMPP_Router
# you can increase this upon a higher load
max-connections = 1
==== kannel.conf =======
group = core
admin-port = 13005
smsbox-port = 23005
admin-password = bar
status-password = foo
#admin-deny-ip = ""
#admin-allow-ip = ""
log-file = "/var/log/smpp/smsc.log"
log-level = 0
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
#wdp-interface-name = "*"
#unified-prefix = "+358,00358,0;+,00"
access-log = "/var/log/smpp/access.log"
#ssl-server-cert-file = "cert.pem"
#ssl-server-key-file = "key.pem"
#ssl-certkey-file = "mycertandprivkeyfile.pem"
#dlr-storage = mysql
# SMSC CONNECTIONS
group = smsc
smsc = smpp
smsc-id = smpp
port =
host =
receive-port =
smsc-username =
smsc-password =
system-type = ""
address-range = ""
interface-version = 0x33
enquire-link-interval = 60
msg-id-type = 0x01
source-addr-ton = 1
source-addr-npi = 1
dest-addr-ton = 1
dest-addr-npi = 1
allowed-smsc-id = test_smpp
#alt-charset = LATIN1
#snpi = 1
#validityperiod = 360
#msg-id-type = "12345678901"
group = smsbox-route
smsbox-id = abu
smsc-id = test_smpp
# SMSBOX SETUP
group = smsbox
bearerbox-host = localhost
sendsms-port = 33099
#global-sender =
#my-number = 38000
#sendsms-chars = "0123456789 +-"
log-file = "/var/log/nsg/ware_smpp/smsbox.log"
log-level = 0
access-log = "/var/log/nsg/ware_smpp/sms_access.log"
# SERVICES
# There should be always a 'default' service. This service is used when no
# other 'sms-service' is applied.
group = sms-service
keyword = default
text = "No service specified"
===== smpp.conf =====
# sample opensmppbox.conf
group = core
#dlr-storage = mysql
# this group defines your opensmppbox
group = opensmppbox
# our boxc type
opensmppbox-id = nvsmpp
# the port to listen on for smpp connections
opensmppbox-port = 2348
# we connect to the following host as a box
bearerbox-host = localhost
bearerbox-port = 23005
log-level = 0
log-file = "/var/log/smpp/smppbox.log"
our-system-id = smpp_router
#use-systemid-as-smsboxid = false
route-to-smsc = test_smpp
# see sample smpplogins.txt
smpp-logins = "/etc/smpp/smpplogin1.txt"
======Startup Flow =====
Start bearerbox
start smppbox
start sqlbox
Thanks
Tunji
2010/11/23 Nikos Balkanas <[email protected]>
Hi,
This is not much help. If you are going to postconfiguration, please include
all config files, along with a few detailed startup lox of all components.
BR,
Nikos
----- Original Message ----- From: Adeagbo Tunji
To: [email protected]
Sent: Tuesday, November 23, 2010 8:31 AM
Subject: smppbox with sqlbox
Hi Team
I had setup opensmppbox to connect to bearerbox and its working fine. But I
need to introduce sqlbox in between to log MO and MT from
smppbox. I tried but no entry in send and sent table. kindly help with
working sqlbox config see below the flow
[SMPP client]<-->[smppbox]<-->[sqlbox]<-->[bearerbox]
=====sqlbox.conf======group = sqlbox
id = sqlbox-dbsmsbox-id = billy
bearerbox-host = localhostbearerbox-port = 23005
smsbox-port = 33009smsbox-port-ssl = false
sql-log-table = sent_smssql-insert-table = Nsend_sms
log-file = "/var/log/nvsmpp/test_smpp/sqlbox.log"log-level = 0
