You need smsbox to do that. You need to use sqlbox between smsbox and bearerbox, sp sqlbox can log the traffic and smsbox hit the drl-url and/or the services.
Regards, -- Alex Guerrieri On Jan 2, 2012, at 10:57, Jorge Raimundo <[email protected]> wrote: > Ok, finally I got it working. > > There was a smsbox-route section missing. Now I'm routing the incoming > messages to the sqlbox and I can see the DLR entries on the database :) > > My problem now is that the dlr_url is not being called. > > I could use the solution Carlos suggests (thank you Carlos), and it's still a > possibility, but it would be better for me if I could use a url with a script > of my own. > > I'm inserting this on the database: > > INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, > dlr_url ) VALUES ('MT', 'MV', '+35191******7', 'Hello world', 2, 31, > 'http%3A%2F%2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D%25d'); > > I do get the dlr entry on the database, but the url isn't accessed. > > Any ideas on what's wrong? > > Best regards, > Jorge > > > On Thu, Dec 22, 2011 at 5:01 PM, Carlos Massoglia Lillo > <[email protected]> wrote: > Jorge, > > If you insert directly into send_sms table, I think you must set an > unique id in dlr_url. This because the same info you insert into > send_sms is inserted into sent_sms, and to track DLR for messages, yu > must compare dlr_url in rows with "momt" field set to DLR and the > dlr_url. > > By example > > > mysql>select momt,receiver,dlr_mask,dlr_url from sent_sms where > dlr_url='141b2de2'; > +------+--------------+----------+----------+ > | momt | receiver | dlr_mask | dlr_url | > +------+--------------+----------+----------+ > | MT | +569775XXXX | 19 | 141b2de2 | > | DLR | +569775XXXX | 1 | 141b2de2 | > +------+--------------+----------+----------+ > 2 rows in set (0.00 sec) > > > As you see, setting dlr_url to a unique id for each message I can track > the DLR for each one. > > Best regards, > > El jue, 22-12-2011 a las 15:20 +0000, Jorge Raimundo escribió: > > Hi all! > > > > I've installed smsbox and successfully sent an SMS using it, but I'm > > not being able to receive the DLR info. > > > > Right now the SMSC is rejecting my SMSes because I have no credits > > there and I am using this situation to test the DLR. > > I should have DLR information on the database that tells me that the > > SMSC is rejecting my messages. > > > > On the database I'm doing this: > > INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, > > dlr_mask, dlr_url ) > > VALUES ( > > 'MT', 'MV', '+3519******67', 'Hello world', 2, 31, 'http%3A%2F% > > 2F******%2Fteste.php%3Fdestination%3D7%26type%3D%25d' > > ) > > > > On the smsc log I get the following: > > [2447] [6] DEBUG: SMPP PDU 0x7dde00 dump: > > [2447] [6] DEBUG: type_name: submit_sm_resp > > [2447] [6] DEBUG: command_id: 2147483652 = 0x80000004 > > [2447] [6] DEBUG: command_status: 69 = 0x00000045 > > [2447] [6] DEBUG: sequence_number: 252 = 0x000000fc > > [2447] [6] DEBUG: message_id: NULL > > [2447] [6] DEBUG: SMPP PDU dump ends. > > [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x00000045 > > (Submit failed) in response to submit_sm. > > [2447] [6] DEBUG: SMSC[ROUTO]: creating DLR message > > [2447] [6] DEBUG: SMSC[ROUTO]: DLR = http%3A%2F% > > 2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Fdestination%3D7% > > 26type%3D%25d > > [2447] [6] WARNING: smsbox_list empty! > > > > I'm getting command_status: 69 (SMSC returned error code 0x00000045), > > this is the code used by my SMSC to tell me that the SMS was rejected, > > so this should translate to a status of 16 on dlr, but nothing was > > passed to my side. > > > > The sent_sms has no dlr data and the link I passed on dlr-url was not > > called... > > > > What's wrong in here? > > > > Best regards, > > Jorge > > > > -- > > > > Multivision > > Jorge Raimundo > > > > RAN Consultant | > > [email protected] > > . > > Rua António Albino Machado, Nº33, > > 2ºB. > > S. Domingos de Benfica, 1600 - 870 > > Lisboa > > Fixed PT: +351 21 155 20 53 | > > Mobile PT: +351 91 933 13 67 > > www.multivision.pt > > > > -- > Carlos Massoglia Lillo > Gerencia de Innovación y Desarrollo > MindFree Ingeniería Limitada > www.mindfree.cl > > > > > -- > > Jorge Raimundo > RAN Consultant | [email protected] > . > Rua António Albino Machado, Nº33, 2ºB. > S. Domingos de Benfica, 1600 - 870 Lisboa > Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 > www.multivision.pt >
