hello,
i am very new to kannel so maybe answer to my question is trivial, but i
am not able to figure it out. i would like to set up kannel so that i
will put messages in sqlbox send_sms table, sqlbox will send the
messages to bearerbox which will send it to smsc and then it will
receive from smsc dlrs, pass them to sqlbox which will store them in
sent_sms table probably. is this possible? everything seems to work for
me except the dlrs. what confuses me is the dlr-url, as i do not want to
call any http service but instead want to parse the dlr info from
database table.
this is how i create the message:
INSERT INTO kannel_send_sms (
momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url
) VALUES (
'MT', '1234', '1234567890', 'Hello world', 2, 31, 'id=1&status=%d'
);
here is what i get from bearerbox:
2010-12-04 20:55:02 [20856] [8] DEBUG: boxc_receiver: sms received
2010-12-04 20:55:02 [20856] [8] DEBUG: DLR[pgsql]: Adding DLR smsc=FAKE,
ts=9dd3ef97-a2b6-463f-9c95-5da3cc932eff, src=1234, dst=1234567890,
mask=31, boxc=
2010-12-04 20:55:02 [20856] [8] DEBUG: sql: INSERT INTO "kannel_dlr"
("smsc", "ts", "source", "destination", "service", "url", "mask",
"boxc", "status") VALUES ('FAKE',
'9dd3ef97-a2b6-463f-9c95-5da3cc932eff', '1234', '1234567890', '',
'id=1&status=%d', '31', '', '0');
2010-12-04 20:55:02 [20856] [8] DEBUG: send_msg: sending msg to boxc:
<sqlbox>
2010-12-04 20:55:02 [20856] [6] DEBUG: smsc_fake: sending message to client
2010-12-04 20:55:02 [20856] [6] DEBUG: SMSC[FAKE]: creating DLR message
2010-12-04 20:55:02 [20856] [6] DEBUG: SMSC[FAKE]: DLR = id=1&status=%d
2010-12-04 20:55:02 [20856] [6] WARNING: smsbox_list empty!
2010-12-04 20:55:02 [20856] [6] DEBUG: DLR[pgsql]: Looking for DLR
smsc=FAKE, ts=9dd3ef97-a2b6-463f-9c95-5da3cc932eff, dst=1234567890, type=1
2010-12-04 20:55:02 [20856] [6] DEBUG: sql: SELECT "mask", "service",
"url", "source", "destination", "boxc" FROM "kannel_dlr" WHERE
"smsc"='FAKE' AND "ts"='9dd3ef97-a2b6-463f-9c95-5da3cc932eff' LIMIT 1;
2010-12-04 20:55:02 [20856] [6] DEBUG: Found entry, col1=31, col2=,
col3=id=1&status=%d, col4=1234, col5=1234567890 col6=
2010-12-04 20:55:02 [20856] [6] DEBUG: DLR[pgsql]: created DLR message
for URL <id=1&status=%d>
2010-12-04 20:55:02 [20856] [6] DEBUG: removing DLR from database
2010-12-04 20:55:02 [20856] [6] DEBUG: sql: DELETE FROM "kannel_dlr"
WHERE oid = (SELECT oid FROM "kannel_dlr" WHERE "smsc"='FAKE' AND
"ts"='9dd3ef97-a2b6-463f-9c95-5da3cc932eff' LIMIT 1);
fakesmsc receives the message too:
2010-12-04 20:55:03 [20998] [0] DEBUG: Got message 4: <1234 1234567890
text Hello world>
sqlbox logs nothing about the messages though it aparently passes
messages to bearerbox and moves them to sms_sent.
i have also smsbox set up but not running as the main functionality that
i need now is sqlbox messaging. also i have another test smsc set up in
the config file but that is not running either, but i think none of
these is cause of not getting the dlrs.
so i want to ask, is it possible to get the dlrs in sent_sms table for
example, without any call to http service? and if so, how to configure that?
thanks for any help.
miroslav
