Yes, it should. But you should watch that opensmppbox connects to sqlbox(S)
with the same smsbox-id as sqlbox(S) to kannel(S), otherwise DLRs will never
reach opensmppbox and from there kannel(C).
BR,
Nikos
----- Original Message -----
From: krnrd b
To: Nikos Balkanas
Cc: users
Sent: Wednesday, January 05, 2011 8:08 AM
Subject: Re: kannel+OpenSMPPbox
Hi,
Yes Nikos i understood.
What about below mentioned configuration does it store submit and dlr's on
sqlbox(S).
I am using latest SVN kannel.
Flow
--------
Kannel(S) <-------> SQLBox(S) <-------> OPENSMPPBox <--------> Kannel(C)
<----------> SQLBox(C)
Kannel-Server Configuration
--------------------------------------------
group = core
admin-port = 13000
admin-password = krnr...@!
status-password = krnr...@!
dlr-storage = mysql
smsbox-port = 13001
group = smsc
smsc = smpp
smsc-id = Kannel-Server
host = xxx.xxx.xx.xxx
port = 11345
transceiver-mode = y
smsc-username = krnrdb
smsc-password = krnrdb1
system-type = "krnrdb"
address-range = ""
reconnect-delay = 2
alt-charset=1
reconnect-delay = 10
group = smsbox
bearerbox-host = localhost
sendsms-port = 13002
group = smsbox-route
smsbox-id = sqlbox
smsc-id = "Kannel-Server"
group = sendsms-user
username = krnrdb
password = krnrdb
group = mysql-connection
id = mydlr
host = localhost
username = root
password = root
database = KANNELSERVER
# max count of connections that will be opened for dbpool
# default is 1
max-connections = 1
group = dlr-db
id = mydlr
table = kannelserverdlr
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
SQLBox Server Configuration
----------------------------------------------
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13003
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = root
database = SQLBOX
# you can increase this upon a higher load
max-connections = 1
group = sdb-connection
id = sqlbox-db
url = mysql:host=localhost:db=SQLBOX:uid=root:pwd=root
OpenSMPPBox Configuration
----------------------------------------------
# opensmppbox.conf
group = core
dlr-storage = mysql
group = opensmppbox
opensmppbox-id = OpenSMPPBox1
opensmppbox-port = 2346
bearerbox-host = localhost
bearerbox-port = 13001
log-level = 0
log-file = opensmppbox.log
our-system-id = OpenSMPPBox
route-to-smsc = Kannel-Server
# see sample smpplogins.txt
smpp-logins =
"/usr/run/gateway1/addons/opensmppbox/example/smpplogins.txt.example"
# the following is just standard dlr configuration
group = mysql-connection
id = mydlr
host = localhost
username = root
password = root
database = SMPPBOX
# you can increase this upon a higher load
max-connections = 1
group = dlr-db
id = mydlr
table = smppdlr
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 = boxcid
KANNEL-Client Configuration
--------------------------------------------
group = core
admin-port = 14000
admin-password = test
status-password = test
dlr-storage = mysql
smsbox-port = 14001
group = smsc
smsc = smpp
smsc-id = kannel-client
host = localhost
port = 2346
smsc-username = test
smsc-password = test12
system-type = "test"
reconnect-delay = 2
alt-charset=1
transceiver-mode = true
group = smsbox-route
smsbox-id = sqlbox-c
smsc-id = "kannel-client"
group = smsbox
#smsbox-id = sqlbox-c
bearerbox-host = localhost
sendsms-port = 14002
group = sendsms-user
username = test1
password = test1
group = mysql-connection
id = mydlr
host = localhost
username = root
password = root
database = KANNELCLIENT
# max count of connections that will be opened for dbpool
# default is 1
max-connections = 1
group = dlr-db
id = mydlr
table = dlrclient
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
SQLBox Client
------------------------
group = sqlbox
id = sqlbox-db-c
smsbox-id = sqlbox-c
bearerbox-host = localhost
bearerbox-port = 14001
smsbox-port = 14003
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = root
database = SQLBOXClient
# you can increase this upon a higher load
max-connections = 1
group = sdb-connection
id = sqlbox-db-c
url = mysql:host=localhost:db=SQLBOXClient:uid=root:pwd=root
---------------------------------------------------------------------------------------------------------
Thanks,
KRNRDB
2011/1/4 Nikos Balkanas <nbalka...@gmail.com>
Hi,
Nope, you cannot do it. SQLbox(C) cannot connect to opensmppbox.
BR,
Nikos
----- Original Message ----- From: krnrd b
To: users
Sent: Tuesday, January 04, 2011 9:58 AM
Subject: kannel+OpenSMPPbox
Dear All,
I want to configure as fallows is this posible.
kannel (S) <-------> sqlbox(S) <-----> opensmppbox <---->sqlbox (C)
<-------> kannel (C)
If client sent push message first it has to reach sqlbox then opensmppbox
after then again sqlbox then it has to reach kannel.
In this case i want every sqlbox has to store the message and also dlr's.
If incase kannel(S) and sqlbox (S) is down messages will store on sqlbox
(C).
Thanks,
KRNRDB
