I have an issue where all messages do not log in the sent_sms table. I can send exact same message 10 times and only 5 will log in database one time and maybe 3 the next.
I have looked at logs and have been unable to determine what or where to find the point of failure. >From what I can tell is doing the following. Based on my last last test the results are as follows 1) I sent 9 messages from 123, 234, 345, 456, 567, 678, 789,890, and 901 2) 3 messages processed and posted to the database correctly from 456, 567, and 901 3) In the smsbox.log it logged only the messages that did not log to database 5) In bearbox.log it showed all messages none were missing. As I understand it The architecture of is divided in three kinds of processes called boxes: 1. BearerBox is the core of the architecture - it implements the WDP layer (provide basic core services) 2. SMSBox implements the rest of the SMS gateway functionality (can have multiple SMSBox) 3. WAPBox implements WAP protocol stack and WAP Push (can have multiple WAPBox) I am not using any wap so only configured bearbox and smsbox I would assume that something between bearbox and either smsbox sqlbox or database is causing the failure just cannot find what or where. Is there special logging or other troubleshooting I need to do to find where it is failing. ****************************** Kannel.conf ********* #CORE group = core admin-port = 13000 smsbox-port = 13001 admin-password = hostin wdp-interface-name = "*" log-file = "/var/log/kannel/bearerbox.log" store-file = "/var/log/kannel/kannel.store" log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "*.*.*.*" dlr-storage = internal #SMSBOX SETUP group = smsbox smsbox-id = "mysmsc" bearerbox-host = localhost sendsms-port = 13013 log-file = "/var/log/kannel/smsbox.log" log-level = 0 http-request-retry = 3 http-queue-delay = 15 sendsms-chars = "0123456789 +-,~!@#$%^&*()" global-sender = 12345 mo-recode = true group = smsbox-route smsbox-id = "mysmsc" smsc-id = "mysmsc" group = sms-service keyword = default catch-all = true max-messages = 0 get-url = http://localhost/receivesms.php?sender=%p&text=%b # SMSC SMPP group = smsc smsc-id = "mysmsc" smsc = smpp host = xxx.xxx.xxx.xxx port = 16400 receive-port = 16400 smsc-username = Track smsc-password = Track system-type = "" address-range = "" group = sendsms-user username = root password = hostin max-messages = 10 group = mysql-connection id = mydlr host = localhost username = root password = "hostin" database = dlr max-connections = 10 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 ********* #Group sqlbox group = sqlbox id = mysmsc smsbox-id = mysmsc bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13003 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 group = mysql-connection id = mysmsc host = localhost username = root password = hostin database = dlr max-connections = 10
