Also make sure that your dlr table storage is MyISAM. On Mon, Nov 3, 2014 at 7:53 PM, MOSES KARIUKI <kariuk...@gmail.com> wrote:
> What issue are you facing? > > MT > > On Mon, Nov 3, 2014 at 5:09 PM, Aditya Khanna < > aditya.khanna111...@gmail.com> wrote: > >> *Hello Everyone,* >> >> I'm new with Kannel SMS Gateway. I have configured my application with >> Kannel SMS Gateway. >> >> I'm facing some serious problems regarding speed of sending bulk sms. >> >> This is my configuration Files. Please check and suggest me that where is >> the problem in configuration. >> >> *gateway.conf* >> >> #----------------------------------------- >> # 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 = "-1" >> sms-outgoing-queue-limit = "1000000" >> sms-resend-freq = "60" >> sms-resend-retry = "-1" >> #smsbox-max-pending = "100" >> #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" >> http-request-retry=5 >> >> #----------------------------------------- >> # 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 = "" >> 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 = "400000" >> reconnect-delay = "60" >> transceiver-mode = "true" >> interface-version = "34" >> connection-timeout = "400000" >> throughput = "10000000.00" >> max-pending-submits="10" >> #reroute="true" >> #reroute-smsc-id="mysmsc1" >> reroute-dlr="true" >> >> #----------------------------------------- >> # Multi Group "smsbox-route" >> #----------------------------------------- >> >> group = smsbox-route >> smsbox-id = "mysmsbox" >> smsc-id = "mysmsc1" >> >> #----------------------------------------- >> # Multi Group "sms-service" >> #----------------------------------------- >> >> 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" >> >> #----------------------------------------- >> # Multi Group "mysql-connection" >> #----------------------------------------- >> >> group = mysql-connection >> id = sqlbox-db >> host="127.0.0.1" >> username = "root" >> password = "" >> database = "bulk_sms" >> max-connections = "1" >> >> group = mysql-connection >> id = mydlr >> 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 >> >> #----------------------------------------- >> >> *sqlbox.conf* >> >> #----------------------------------------- >> # 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" >> >> #----------------------------------------- >> >> Please reply as soon as possible. I'm waiting for your valuable reply. >> >> Your reply will be appreciate. >> >> >> Thanks, >> Aditya Khanna >> >> >> >> >> >> >
