Hey Guys, This list seems to be rather quite these days, perhaps due to the rugby world cup? Only jokes. I know many are busy so hoping perhaps someone could do some cheap consultation for me to fix my issues with DLRs not always displaying but queuing.
The problem I see is sometimes the DLR of 8 comes through however the message remains in the dlr mysql store until a dlr of 1 is received, sometimes when i restart my kannel they get processed other times they dont. From looking at my providers web queue I see the message as delivered and according to them they are sending me the DLR's. It appears the problem is my end. As per below config I use kannel, bearerbox, smsbox & sqlbox. I'm willing to pay a small fee for some help please. thanks Barry On Mon, 12 Sep 2011 20:32:00 +1200, Barry Murphy <[email protected]> wrote: > Hey Guys, > > I'm starting to beleive the issue is with my config, perhaps not > understanding the smsbox-id / allowed-smsc-id parameters. What I've done > now is comment out everything and left just 1 provider in my kannel... > below is a copy of my config, the problem remains that the DLR's are just > being queued and the only way for me to process them is to restart all the > processes. > > ### /etc/kannel/kannel.conf ### > group = core > admin-port = 13000 > smsbox-port = 13001 > admin-password = ADMINPASS123 > log-file = "/var/log/kannel/bearerbox.log" > log-level = 0 > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1;192.168.1.22" > dlr-storage = mysql > #store-location = "/root/kannel.store/" > #store-type=spool > > group=smsc > smsc=smpp > smsc-id=smsw > preferred-smsc-id=smsw > allowed-smsc-id="smsw;allsmsc" > interface-version=34 > host=212.7.1.1 > port=2775 > system-id=username > smsc-password=password > system-type=VMA > transceiver-mode=true > source-addr-ton=1 > source-addr-npi=1 > dest-addr-ton=1 > dest-addr-npi=1 > keepalive = 55 > throughput = 6 > idle-timeout = 45 > enquire-link-interval = 10 > reconnect-delay = 5 > log-level = 0 > > group = smsbox > bearerbox-host = 127.0.0.1 > smsbox-id=asmsbox > sendsms-port = 13013 > log-file = "/var/log/kannel/smsbox.log" > log-level = 0 > global-sender = 6121234567 > > group = sendsms-user > username = username > password = password > concatenation= true > max-messages = 10 > > # SMS SERVICE 'default' > group = sms-service > keyword = nop > text = "You asked nothing and I did it!" > catch-all = true # Catch all incoming messages > # regarding the keyword. If you > # define other services, remove > # this line. > > group = sms-service > keyword = default > #text = "No service specified" > text=<480 Characters with spaces> > get-url = > "http://www.websms.co.nz/dlr.php?cust_id=$cust_id&message_id=$last_id&dlr=%d";; > concatenation=true > max-messages=5 > > group = mysql-connection > id = mydlr > host = 120.136.7.82 > port = 3306 > username = username > password = password > database = database > max-connections = 4 > > 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 > > > ### /etc/kannel/sqlbox.conf ### > group = sqlbox > id = sqlbox-db > smsbox-id = asmsbox > bearerbox-host = localhost > bearerbox-port = 13001 > smsbox-port = 13003 > sql-log-table = sqlbox_sent_sms > sql-insert-table = sqlbox_send_sms > log-file = "/var/log/kannel/kannel-sqlbox.log" > log-level = 0 > > group = mysql-connection > id = sqlbox-db > host = 120.136.7.82 > port = 3306 > username = database_username > password = database_password > database = database > max-connections = 4 > > > ### Method to send ### > insert into sqlbox_send_sms set msgdata='testing > smsw',sender='614999999',receiver='64274901111',smsc_id='smsware',sms_type='2',dlr_mask='31',dlr_url='http://www.websms.co.nz/urlkfordlr.php?cust_id=$cust_id&message_id=$last_id&dlr=%d' > > Could someone please point me in the right direction and advise why my > dlr's are being stuck in queue. > > Thanks > Barry > > > > > On Sun, 11 Sep 2011 15:08:38 +1200, Barry Murphy <[email protected]> wrote: >> It would appear that the DLR's are queued (even though they get removed >> from 'dlr' in mysql, when i restart kannel then they get dequeued. >> >> SMS: received 0 (0 queued), sent 1 (0 queued), store size -1 >> SMS: inbound (0.00,0.00,0.00) msg/sec, outbound (0.02,0.01,0.01) msg/sec >> >> DLR: received 1, sent 0 >> DLR: inbound (0.02,0.01,0.01) msg/sec, outbound (0.00,0.00,0.00) msg/sec >> DLR: 1 queued, using mysql storage >> >> Again thanks in advance. >> >> barry >> >> >> >> >> On Sun, 11 Sep 2011 14:07:01 +1200, Barry Murphy <[email protected]> > wrote: >>> Hey Guys, >>> >>> I have a strange problem that my DLR-URL is not always being initiated. >> I >>> can confirm from the logs (when in debug mode) I dont see the dlr-url >> being >>> initiated, however when this happens I see the DLR appear in >>> sqlbox_sent_sms . >>> >>> In some cases my dlr-url will not be called at all. >>> In some cases my dlr-url will get a dlr of 8, message queued at SMSC > but >>> not get dlr 1 (while sqlbox_sent_sms does receive it). >>> >>> I have 3 smsc's configured but i'm only sending via 1 at the moment for >>> troubleshooting purposes. >>> >>> group=smsc >>> smsc=smpp >>> smsc-id=smsware >>> preferred-smsc-id=smsware >>> allowed-smsc-id=smsware >>> interface-version=34 >>> host=212.1.1.1 >>> port=2775 >>> system-id=myuserid >>> smsc-password=mypasswd >>> system-type=VMA >>> transceiver-mode=true >>> source-addr-ton=1 >>> source-addr-npi=1 >>> dest-addr-ton=1 >>> dest-addr-npi=1 >>> keepalive = 55 >>> throughput = 6 >>> idle-timeout = 45 >>> enquire-link-interval = 10 >>> reconnect-delay = 5 >>> log-level = 0 >>> >>> Here is an example of how i send a message using sqlbox.. >>> insert into sqlbox_send_sms set msgdata='testing smsware >>> >> > dlr',sender='614999999',receiver='64274901111',smsc_id='smsware',sms_type='2',dlr_mask='31',dlr_url='http://www.websms.co.nz/urlkfordlr.php?cust_id=$cust_id&message_id=$last_id&dlr=%d >>> >>> Any help would be much appreciated. >>> >>> Thanks >>> Barry -- This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it. Thank you. Please note that this communication does not designate an information system for the purposes of the Electronic Transactions Act 2002.
