Thank you Alejandro.
Is it possible that both sqlbox and smsbox receive the dlr? Is it possible
to route a message to more than one box?
Best regards,
Jorge
On Mon, Jan 2, 2012 at 4:21 PM, Alejandro Guerrieri <
alejandro.guerri...@gmail.com> wrote:
> 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 <jorge.raimu...@multivision.pt>
> 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 <
> carlos.massog...@mindfree.cl> 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 |
>> > jorge.raimu...@multivision.pt
>> > .
>> > 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 | jorge.raimu...@multivision.pt . 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
>
>
--
[image: Multivision] *Jorge Raimundo
* RAN Consultant | jorge.raimu...@multivision.pt . 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
