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
>
>
--
[image: 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
