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 ----- Ursprungligt meddelande ----- 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 ----- Ursprungligt meddelande ----- 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 ----- <blockquote> 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 </blockquote>
