*Hello Everyone,*
I'm need of your help.
Currently, I'm developing a Bulk SMS Application, So I'm using Kannel as
SMS Gateway.
First I was configuring Bearerbox and SMSBox for push messages to connected
SMPP server through HTTP. I was send each message to kannel using HTTP Url.
but It is failed when I'm sending Bulk SMS up to 50K to 100K. My HTTP has
been crashed due to kannel HTTP send sms url.
Like this
"http://localhost:15010/cgi-bin/sendsms?parameters"
Now I'm handle this problem using SQLBox. So SQLBox creates two table in
DB: *send_sms* & *sent_sms*.
I'm inserting each request into send_sms table through HTTP.
But the problem is that SQLBox does not update each message DLR in
*sent_sms* table.
So I want to know that what is the probelm behind this:
Please find I'm attaching my configuration files below.
Thanks,
Aditya Khanna
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Single Group "CORE"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = core
admin-port = "15000"
admin-password = "bulksms"
status-password = "bulksms"
smsbox-port = "15001"
log-file = "mykannel.log"
log-level = "0"
access-log = "myaccess.log"
dlr-storage = "mysql"
#sms-incoming-queue-limit = "100"
#sms-outgoing-queue-limit = "100"
#sms-resend-freq = "1"
sms-resend-retry = "-1"
#smsbox-max-pending = "100"
admin-allow-ip="127.0.0.1"
box-allow-ip = "127.0.0.1"
#admin-deny-ip="127.0.0.1"
#box-deny-ip = "127.0.0.1"
http-proxy-host="127.0.0.1"
http-proxy-port="80"
#store-type="file"
#store-location="store"
#wapbox-port = "15002"
#wdp-interface-name = "*"
#maximum-queue-length = "1000000"
#sms-combine-concatenated-mo = ""
#sms-combine-concatenated-mo-timeout = "600"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Single Group "smsbox"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = smsbox
smsbox-id = "mysmsbox"
bearerbox-host = "127.0.0.1"
bearerbox-port = "15001"
sendsms-port = "15010"
log-file = "mysmsbox.log"
log-level = "0"
access-log="sms_access.log"
sendsms-chars = "0123456789+ "
max-pending-requests = "512"
#sendsms-url="/cgi-bin/sendsms"
#global-sender = "123456"
#ms-length = "140"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Multi Group "SMSC"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = smsc
smsc = "smpp"
smsc-id = "mysmsc1"
log-file = "mysmsc1.log"
log-level = "0"
host = "127.0.0.1"
port = "1111"
smsc-username = "test1"
smsc-password = "test1"
denied-smsc-id =
"mysmsc2;mysmsc3;mysmsc4;mysmsc5;mysmsc6;mysmsc7;mysmsc8;mysmsc9;mysmsc10;"
allowed-smsc-id = "mysmsc1"
preferred-smsc-id = "mysmsc1"
source-addr-ton = "0"
source-addr-npi = "1"
dest-addr-ton = "1"
dest-addr-npi = "1"
service-type = "CMT"
validityperiod = "600"
system-type = "VMA"
address-range = "^$"
bind-addr-ton = "0"
bind-addr-npi = "0"
enquire-link-interval = "200000"
reconnect-delay = "60"
transceiver-mode = "true"
interface-version = "34"
connection-timeout = "200000"
throughput = "10000000.00"
max-pending-submits="10"
#reroute="true"
#reroute-smsc-id="mysmsc1"
reroute-dlr="true"
#--------------------------------------------------------------------------------------------------------------------------------------------
group = smsc
smsc = "smpp"
smsc-id = "mysmsc2"
log-file = "mysmsc2.log"
log-level = "0"
host = "127.0.0.1"
port = "2222"
smsc-username = "test2"
smsc-password = "test2"
denied-smsc-id =
"mysmsc1;mysmsc3;mysmsc4;mysmsc5;mysmsc6;mysmsc7;mysmsc8;mysmsc9;mysmsc10;"
allowed-smsc-id = "mysmsc2"
preferred-smsc-id = "mysmsc2"
source-addr-ton = "0"
source-addr-npi = "1"
dest-addr-ton = "1"
dest-addr-npi = "1"
service-type = "CMT"
validityperiod = "600"
system-type = "VMA"
address-range = "^$"
bind-addr-ton = "0"
bind-addr-npi = "0"
enquire-link-interval = "200000"
reconnect-delay = "60"
transceiver-mode = "true"
interface-version = "34"
connection-timeout = "200000"
throughput = "10000000.00"
max-pending-submits="10"
#reroute="true"
#reroute-smsc-id="mysmsc2"
reroute-dlr="true"
#--------------------------------------------------------------------------------------------------------------------------------------------
group = smsc
smsc = "smpp"
smsc-id = "mysmsc3"
log-file = "mysmsc3.log"
log-level = "0"
host = "127.0.0.1"
port = "3333"
smsc-username = "test3"
smsc-password = "test3"
denied-smsc-id =
"mysmsc1;mysmsc2;mysmsc4;mysmsc5;mysmsc6;mysmsc7;mysmsc8;mysmsc9;mysmsc10;"
allowed-smsc-id = "mysmsc3"
preferred-smsc-id = "mysmsc3"
source-addr-ton = "0"
source-addr-npi = "1"
dest-addr-ton = "1"
dest-addr-npi = "1"
service-type = "VMN"
validityperiod = "600"
system-type = "VMA"
address-range = "^$"
bind-addr-ton = "0"
bind-addr-npi = "0"
enquire-link-interval = "200000"
reconnect-delay = "60"
transceiver-mode = "true"
interface-version = "34"
connection-timeout = "200000"
throughput = "10000000.00"
max-pending-submits="10"
#reroute="true"
#reroute-smsc-id="mysmsc3"
reroute-dlr="true"
#--------------------------------------------------------------------------------------------------------------------------------------------
group = smsc
smsc = "smpp"
smsc-id = "mysmsc4"
log-file = "mysmsc4.log"
log-level = "0"
host = "127.0.0.1"
port = "4444"
smsc-username = "test4"
smsc-password = "test4"
denied-smsc-id =
"mysmsc1;mysmsc2;mysmsc3;mysmsc5;mysmsc6;mysmsc7;mysmsc8;mysmsc9;mysmsc10;"
allowed-smsc-id = "mysmsc4"
preferred-smsc-id = "mysmsc4"
source-addr-ton = "0"
source-addr-npi = "1"
dest-addr-ton = "1"
dest-addr-npi = "1"
service-type = "VMA"
validityperiod = "600"
system-type = "VMA"
address-range = "^$"
bind-addr-ton = "0"
bind-addr-npi = "0"
enquire-link-interval = "200000"
reconnect-delay = "60"
transceiver-mode = "true"
interface-version = "34"
connection-timeout = "200000"
throughput = "10000000.00"
max-pending-submits="10"
#reroute="true"
#reroute-smsc-id="mysmsc4"
reroute-dlr="true"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Multi Group "smsbox-route"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = smsbox-route
smsbox-id = "mysmsbox"
smsc-id = "mysmsc1;mysmsc2;mysmsc3;mysmsc4;mysmsc5;mysmsc6"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Multi Group "sms-service"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
#group = sms-service
#keyword = "nop"
#text = "You asked nothing and I did it!"
#catch-all = "true"
#send-sender="true"
#group = sms-service
#name = "mysmsservice"
#keyword = "www"
#get-url = "http://%s"
#faked-sender = "123456"
#aliases = ""
#url = ""
#post-url = ""
#post-xml = ""
#file = ""
#text = ""
#exec = ""
#accepted-smsc = ""
#accepted-smsc-regex = ""
#accepted-account = ""
#accepted-account-regex = ""
#forced-smsc = ""
#default-smsc = ""
#max-messages = ""
#concatenation = ""
#split-chars = ""
#split-suffix = ""
#omit-empty = ""
#header = ""
#footer = ""
#prefix = ""
#suffix = ""
#assume-plain-text = ""
#accept-x-kannel-headers = ""
#strip-keyword = ""
#send-sender = ""
#catch-all = ""
#allowed-prefix = ""
#allowed-prefix-regex = ""
#denied-prefix = ""
#denied-prefix-regex = ""
#allowed-receiver-prefix = ""
#allowed-receiver-prefix-regex = ""
#denied-receiver-prefix = ""
#denied-receiver-prefix-regex = ""
#white-list = ""
#white-list-regex = ""
#black-list = ""
#black-list-regex = ""
#dlr-url = ""
#keyword-regex = ""
# 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"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Multi Group "sendsms-user"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = sendsms-user
name = "mysendsmsuser1"
username = "tester1"
password = "tester1"
forced-smsc = "mysmsc1"
#default-smsc= "mysmsc1"
user-allow-ip="*.*.*.*"
max-messages="10"
group = sendsms-user
name = "mysendsmsuser2"
username = "tester2"
password = "tester2"
forced-smsc = "mysmsc2"
#default-smsc= "mysmsc2"
user-allow-ip="*.*.*.*"
max-messages="10"
group = sendsms-user
name = "mysendsmsuser3"
username = "tester3"
password = "tester3"
forced-smsc = "mysmsc3"
#default-smsc= "mysmsc3"
user-allow-ip="*.*.*.*"
max-messages="10"
group = sendsms-user
name = "mysendsmsuser4"
username = "tester4"
password = "tester4"
forced-smsc = "mysmsc4"
#default-smsc= "mysmsc4"
user-allow-ip="*.*.*.*"
max-messages="10"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Multi Group "mysql-connection"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = mysql-connection
id = sqlbox-db
host="127.0.0.1"
username = "root"
password = ""
database = "bulk_sms"
max-connections = "1"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Single Group "dlr-db"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = dlr-db
id = mydlr
table = 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
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# SQL BOX CONFIG
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = sqlbox
id = sqlbox-db
smsbox-id = mysmsbox
global-sender = ""
bearerbox-host = localhost
bearerbox-port = 15001
smsbox-port = 15002
smsbox-port-ssl = false
sql-log-table = sqlbox_sent_sms
sql-insert-table = sqlbox_send_sms
log-file = "sqlbox.log"
log-level = 0
#ssl-client-certkey-file = ""
#ssl-server-cert-file = ""
#ssl-server-key-file = ""
#ssl-trusted-ca-file = ""
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Example MYSQL Connection
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
group = mysql-connection
id = sqlbox-db
host="127.0.0.1"
port = 3306
username = "root"
password = ""
database = "bulk_sms"
#max-connections = "1"
#--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------