found what i was missing. i had to specify route to route the messages
to the sqlbox:
group = smsbox-route
smsbox-id = sqlbox
smsc-id = FAKE
miroslav
Dne 4.12.2010 22:03, Miroslav Šulc napsal(a):
> 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
>
>
