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
