Ι don't think that's a problem.
I think that this dlr concerns a message that sent when your storage was
internal, and it can't find the message in database now.
Try to send again.
----- Original Message -----
From: Andreas Bergman
To: Πετσούκα Τάνια
Cc: users@kannel.org
Sent: Tuesday, May 17, 2011 3:10 PM
Subject: Re: SQLbox, dlr-url and smsbox-route
No, there is no special reason. So i changed to MySQL and the bearerbox.log
now says:
Looking for DLR smsc=beepsend, ts=92871305633904213, dst=46708768300, type=1
2011-05-17 14:05:06 [5952] [6] DEBUG: sql: SELECT `mask`, `service`, `url`,
`source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND `ts`=? LIMIT 1
2011-05-17 14:05:06 [5952] [6] DEBUG: column=mask buffer_type=253
max_length=0 length=11
2011-05-17 14:05:06 [5952] [6] DEBUG: column=service buffer_type=253
max_length=0 length=11
2011-05-17 14:05:06 [5952] [6] DEBUG: column=url buffer_type=253 max_length=0
length=45
2011-05-17 14:05:06 [5952] [6] DEBUG: column=source buffer_type=253
max_length=0 length=11
2011-05-17 14:05:06 [5952] [6] DEBUG: column=destination buffer_type=253
max_length=0 length=11
2011-05-17 14:05:06 [5952] [6] DEBUG: column=boxc buffer_type=253
max_length=0 length=11
2011-05-17 14:05:06 [5952] [6] WARNING: DLR[mysql]: DLR from SMSC<beepsend>
for DST<46708768300> not found.
2011-05-17 14:05:06 [5952] [6] ERROR: SMPP[beepsend]: got DLR but could not
find message or was not interested in it id<92871305633904213>
dst<46708768300>, type<1>
The database contains a record for the DLR, with ts and smsc-values.
I think that WHERE `smsc`=? AND `ts`=? is the problem, but how do I change
that?
/A
------------------------------------------------------------------------------
Från: "Πετσούκα Τάνια" <ta...@tessera.gr>
Till: "Andreas Bergman" <andr...@abergman.se>
Kopia: users@kannel.org
Skickat: tisdag, 17 maj 2011 13:54:09
Ämne: Re: SQLbox, dlr-url and smsbox-route
Is there a reason that you use internal dlr-type?
I suggest you to change that.
----- Original Message -----
From: Andreas Bergman
To: Πετσούκα Τάνια
Cc: users@kannel.org
Sent: Tuesday, May 17, 2011 2:37 PM
Subject: Re: SQLbox, dlr-url and smsbox-route
Hi!
I tried doing that, when cheking the bearerlog it looks like this:
It seems to add the DLR
DLR[internal]: Adding DLR smsc=beepsend, ts=9223372036854775807,
src=abergman, dst=46708768300, mask=1, boxc=smsbox
and then some rows down it says:
DLR[internal]: Looking for DLR smsc=beepsend, ts=73131305632029382,
dst=46708768300, type=1
2011-05-17 13:33:50 [5398] [6] WARNING: DLR[internal]: DLR from
SMSC<beepsend> for DST<46708768300> not found.
2011-05-17 13:33:50 [5398] [6] ERROR: SMPP[beepsend]: got DLR but could not
find message or was not interested in it id<73131305632029382>
dst<46708768300>, type<1>
Any ideas on why?
I changed the start order so that the smsbox is started before the sqlbox,
but it didn't make any difference. Should the smsbox be connected to the
bearerbox via the sqlbox?
Br
Andreas
----------------------------------------------------------------------------
Från: "Πετσούκα Τάνια" <ta...@tessera.gr>
Till: "Andreas Bergman" <andr...@abergman.se>, users@kannel.org
Skickat: tisdag, 17 maj 2011 12:19:40
Ämne: Re: SQLbox, dlr-url and smsbox-route
Furthermore, don't use the included sqlbox version in 1.5.
Download latest sqlbox from svn trunk.
(This has nothing to do with your previous problem, but you may come up
against other issues with that version)
----- Original Message -----
From: Andreas Bergman
To: users@kannel.org
Sent: Tuesday, May 17, 2011 12:26 PM
Subject: SQLbox, dlr-url and smsbox-route
Hi,
I know that this issue/problem has been discussed before, but i can't get
a grip on if it is a feature or a bug.
What i want to achieve:
* Add msg to send_sms
* The msg is sent
* The SMPP module receives the status report
* The report is sent to the smsbox and the dlr-url invoked.
What is happening:* Add msg to send_sms
* The msg is sent
* The SMPP module receives the status report
* The report is sent to the sqlbox and stored in sent_sms.
My config looks like this:
===Core, smsbox, smsc (kannel.conf)===
group = core
admin-port = 13000
admin-password = XXXX
#status-password = XXXX
#admin-deny-ip = ""
#admin-allow-ip = ""
smsbox-port = 13001
#wapbox-port = 13002
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
wdp-interface-name = "*"
log-file = "/var/log/kannel/bearerbox.log"
log-level = 0
group = smsc
smsc-id=beepsend
smsc = smpp
host =
port = 7337
receive-port = 7337
transceiver-mode=true
smsc-username = ""
smsc-password =
system-type = "VMA"
msg-id-type = 0x01
address-range = ""
source-addr-npi=1
source-addr-ton=5group = smsbox
dest-addr-ton=1
dest-addr-npi=1
enquire-link-interval=60s
group = smsbox
smsbox-id = smsbox
bearerbox-host = 127.0.0.1
bearerbox-port = 13001
log-file = "/var/log/kannel/smsbox.log"
sendsms-port = 13013
group = sendsms-user
username = "abergman"
password = "XXXX"
group = smsbox-route
smsbox-id = smsbox
smsc-id =beepsend
====SQLBOX===
group = sqlbox
id=sqlbox
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13005
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/sqlbox.log"
log-level = 0
group = mysql-connection
id = sqlbox
host = localhost
username = root
password = XXXX
database = kannel
max-connections = 1
The flow looks like this
<smsbox> <---> <bearerbox> <---> <smsc>
<sqlbox> <---->
I'm using kannel 1.5 (devel) and the sqlbox shipped with it, no extra
patches.
Is this supposed to work?
br
Andreas
