Re: Error installation sqlbox

2012-01-02 Thread Jorge Raimundo
You have to insert the messages directly on the send_sms table, the sql box
will generate the message and pass it to the sent_sms.

So, you insert on the send_sms and sqlbox will process it and pass it to
the sent_sms.
At the end you'll have an empty send_sms and the sent_sms will have your
message.

Check
http://www.blogalex.com/wp-content/uploads/2008/11/userguide.html#AEN478

Best regrads,
Jorge

On Sat, Dec 31, 2011 at 6:47 PM, Bui Duong The buiduong...@gmail.comwrote:

 thanks! but
 I am install  http://www.the-stagg.co.uk/?p=11
 and viiew file config attach

 
 Khi Con Đặt Hết Tâm Hồn Vào Đó, Đó Là Thứ Tuyệt Vời Nhất ! !(^-^)!
 Information Technology: Network Manager, Design Website, PC's Trouble's...
 Name: Bùi Dương Thế
 Email: buiduong...@gmail.com
 Skype: buiduongthe
 Phone: 0976570931

 



 On 1 January 2012 00:40, mohamed keita keita1...@hotmail.fr wrote:

  Hello.

  I managed to install sqlbox with the command ./configure  - with-kannel-dir
 = / etc / kannel .  / etc / kannel is the installation folder of  kannel.
 Now i have one problem, configuring sqlbox.  Here is my sqlbox
 configuration file. I managed to boot sqlbox but i have nothing in sent_sms
 and send_sms tables.



  group = sqlbox
  id = sqlbox-db
 smsbox-id = sqlbox
 #global-sender = 
 bearerbox-host = localhost
 bearerbox-port = 13001
 smsbox-port = 13008
 sql-log-table = sent_sms
 sql-insert-table = send_sms
 log-file = /var/log/kannel/sqlbox.log
 log-level = 0

 # Configuration connection mysql
 group = mysql-connection
 id = sqlbox-db
 host = localhost
 username = root
 password = fyle
 database = kannel
 max-connections =2


 is that the bearerbox-host must be identical to the smsbox-port in core
 group?

 thanks in advance.





-- 

  [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


Re: Sqlbox doesn't save any sms into mysql tables

2012-01-02 Thread Jorge Raimundo
You have to insert the messages directly on the send_sms table, the sql box
will generate the message and pass it to the sent_sms.

So, you insert on the send_sms and sqlbox will process it and pass it to
the sent_sms.
At the end you'll have an empty send_sms and the sent_sms will have your
message.

Checkhttp://www.blogalex.com/wp-content/uploads/2008/11/userguide.html#AEN478

Best regrads,
Jorge



On Sun, Jan 1, 2012 at 7:12 PM, Suranga Ranjith sura.btac...@gmail.comwrote:

  Hi All,

 I setup kannel gw with sqlbox. somhow it creates 2 tables (send_sms 
 sent_sms), but no sms within that tables at anytime.

 How can I resolve this?

 #sqlbox.conf

 group = sqlbox


 id = sqlbox-db


 smsbox-id = sqlbox


 bearerbox-host = localhost


 bearerbox-port = 13001


 smsbox-port = 13005


 smsbox-port-ssl = false


 sql-log-table = sent_sms


 sql-insert-table = send_sms


 log-file = /var/log/kannel/kannel-sqlbox.log


 log-level = 0


 group = mysql-connection


 id = sqlbox-db


 host = localhost


 username = root


 password = root

 database = kannel

  Thank you!




-- 

  [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


Re: DLR with sqlbox

2012-01-02 Thread Jorge Raimundo
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


 mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where
 dlr_url='141b2de2';
 +--+--+--+--+
 | momt | receiver | dlr_mask | dlr_url  |
 +--+--+--+--+
 | MT   | +569775 |   19 | 141b2de2 |
 | DLR  | +569775 |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 +, 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 = 0x8004
  [2447] [6] DEBUG:   command_status: 69 = 0x0045
  [2447] [6] DEBUG:   sequence_number: 252 = 0x00fc
  [2447] [6] DEBUG:   message_id: NULL
  [2447] [6] DEBUG: SMPP PDU dump ends.
  [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045
  (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 0x0045),
  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


Re: DLR with sqlbox

2012-01-02 Thread Alejandro Guerrieri
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
 
 
 mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where
 dlr_url='141b2de2';
 +--+--+--+--+
 | momt | receiver | dlr_mask | dlr_url  |
 +--+--+--+--+
 | MT   | +569775 |   19 | 141b2de2 |
 | DLR  | +569775 |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 +, 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 = 0x8004
  [2447] [6] DEBUG:   command_status: 69 = 0x0045
  [2447] [6] DEBUG:   sequence_number: 252 = 0x00fc
  [2447] [6] DEBUG:   message_id: NULL
  [2447] [6] DEBUG: SMPP PDU dump ends.
  [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045
  (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 0x0045),
  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
 
 
 
 
 -- 
 
   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
 


Re: DLR with sqlbox

2012-01-02 Thread Jorge Raimundo
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


 mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where
 dlr_url='141b2de2';
 +--+--+--+--+
 | momt | receiver | dlr_mask | dlr_url  |
 +--+--+--+--+
 | MT   | +569775 |   19 | 141b2de2 |
 | DLR  | +569775 |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 +, 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 = 0x8004
  [2447] [6] DEBUG:   command_status: 69 = 0x0045
  [2447] [6] DEBUG:   sequence_number: 252 = 0x00fc
  [2447] [6] DEBUG:   message_id: NULL
  [2447] [6] DEBUG: SMPP PDU dump ends.
  [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045
  (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 0x0045),
  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


Re: DLR with sqlbox

2012-01-02 Thread Alejandro Guerrieri
No, afaik messages can only be routed to a single box.

Regards,

Alex

On Mon, Jan 2, 2012 at 11:29 AM, Jorge Raimundo 
jorge.raimu...@multivision.pt wrote:

 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


 mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where
 dlr_url='141b2de2';
 +--+--+--+--+
 | momt | receiver | dlr_mask | dlr_url  |
 +--+--+--+--+
 | MT   | +569775 |   19 | 141b2de2 |
 | DLR  | +569775 |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 +, 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 = 0x8004
  [2447] [6] DEBUG:   command_status: 69 = 0x0045
  [2447] [6] DEBUG:   sequence_number: 252 = 0x00fc
  [2447] [6] DEBUG:   message_id: NULL
  [2447] [6] DEBUG: SMPP PDU dump ends.
  [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045
  (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 0x0045),
  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, 

DLR error - parameter mismatch or unknown parameters

2012-01-02 Thread Suranga Ranjith
Hi all,

I got a trouble with DLR. I'm using SMPPSim to simulate SMPP connections.
Somehow it doesn't interpret the parameters or it may be some kind of a
parameter mismatch.
You can see *ts=4*, but it is not the time-stamp but message_id.
Sendsms URL and BB log is there.
Help me to solve this. (If this happens because of SMPPSim what can I do to
simulate this?)
I really appreciate any kind of help.

Thank you!

Suranga.

---
http://localhost:13013/cgi-bin/sendsms?username=apassword=afrom=1234to=8282928text=hello+surangadlr-mask=31


2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP PDU 0x911ea38 dump:
2012-01-02 19:31:34 [3127] [6] DEBUG:   type_name: submit_sm_resp
2012-01-02 19:31:34 [3127] [6] DEBUG:   command_id: 2147483652 = 0x8004
2012-01-02 19:31:34 [3127] [6] DEBUG:   command_status: 0 = 0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   sequence_number: 138 = 0x008a
2012-01-02 19:31:34 [3127] [6] DEBUG:   message_id: 4
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP PDU dump ends.
2012-01-02 19:31:34 [3127] [6] DEBUG: DLR[mysql]: Adding DLR smsc=SMPPSim,*ts=4
*, src=1234, dst=8282928, mask=31, boxc=mysmsbox
2012-01-02 19:31:34 [3127] [6] DEBUG: adding DLR entry into database
*2012-01-02 19:31:34 [3127] [6] DEBUG: sql: INSERT INTO `dlr` (`smsc`,
`ts`, `source`, `destination`, `service`, `url`, `mask`, `boxc`, `status`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0)*
2012-01-02 19:31:34 [3127] [6] DEBUG: SMSC[SMPPSim]: creating DLR message
2012-01-02 19:31:34 [3127] [6] DEBUG: SMSC[SMPPSim]: DLR =
2012-01-02 19:31:34 [3127] [10] DEBUG: send_msg: sending msg to boxc:
mysmsbox
2012-01-02 19:31:34 [3127] [10] DEBUG: boxc_sender: sent message to
127.0.0.1
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP[SMPPSim]: throughput (1.00,0.00)
2012-01-02 19:31:34 [3127] [9] DEBUG: boxc_receiver: got ack
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP[SMPPSim]: throughput (1.00,0.00)
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP[SMPPSim]: Got PDU:
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP PDU 0x911ea38 dump:
2012-01-02 19:31:34 [3127] [6] DEBUG:   type_name: deliver_sm
2012-01-02 19:31:34 [3127] [6] DEBUG:   command_id: 5 = 0x0005
2012-01-02 19:31:34 [3127] [6] DEBUG:   command_status: 0 = 0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   sequence_number: 11 = 0x000b
2012-01-02 19:31:34 [3127] [6] DEBUG:   service_type: NULL
2012-01-02 19:31:34 [3127] [6] DEBUG:   source_addr_ton: 2 = 0x0002
2012-01-02 19:31:34 [3127] [6] DEBUG:   source_addr_npi: 1 = 0x0001
2012-01-02 19:31:34 [3127] [6] DEBUG:   source_addr: 1234
2012-01-02 19:31:34 [3127] [6] DEBUG:   dest_addr_ton: 2 = 0x0002
2012-01-02 19:31:34 [3127] [6] DEBUG:   dest_addr_npi: 1 = 0x0001
2012-01-02 19:31:34 [3127] [6] DEBUG:   destination_addr: 8282928
2012-01-02 19:31:34 [3127] [6] DEBUG:   esm_class: 3 = 0x0003
2012-01-02 19:31:34 [3127] [6] DEBUG:   protocol_id: 0 = 0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   priority_flag: 0 = 0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   schedule_delivery_time: NULL
2012-01-02 19:31:34 [3127] [6] DEBUG:   validity_period: NULL
2012-01-02 19:31:34 [3127] [6] DEBUG:   registered_delivery: 1 = 0x0001
2012-01-02 19:31:34 [3127] [6] DEBUG:   replace_if_present_flag: 0 =
0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   data_coding: 0 = 0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   sm_default_msg_id: 0 = 0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   sm_length: 13 = 0x000d
2012-01-02 19:31:34 [3127] [6] DEBUG:   short_message: hello suranga
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP PDU dump ends.
2012-01-02 19:31:34 [3127] [6] WARNING: smsbox_list empty!
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP[SMPPSim]: Sending PDU:
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP PDU 0x912a5e8 dump:
2012-01-02 19:31:34 [3127] [6] DEBUG:   type_name: deliver_sm_resp
2012-01-02 19:31:34 [3127] [6] DEBUG:   command_id: 2147483653 = 0x8005
2012-01-02 19:31:34 [3127] [6] DEBUG:   command_status: 0 = 0x
2012-01-02 19:31:34 [3127] [6] DEBUG:   sequence_number: 11 = 0x000b
2012-01-02 19:31:34 [3127] [6] DEBUG:   message_id: NULL
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP PDU dump ends.
2012-01-02 19:31:34 [3127] [6] DEBUG: SMPP[SMPPSim]: throughput (1.00,0.00)
2012-01-02 19:31:37 [3127] [9] DEBUG: boxc_receiver: heartbeat with load
value 0 received
2012-01-02 19:31:43 [3127] [6] DEBUG: SMPP[SMPPSim]: Sending enquire link:
2012-01-02 19:31:43 [3127] [6] DEBUG: SMPP PDU 0x912a5e8 dump:
2012-01-02 19:31:43 [3127] [6] DEBUG:   type_name: enquire_link
2012-01-02 19:31:43 [3127] [6] DEBUG:   command_id: 21 = 0x0015
2012-01-02 19:31:43 [3127] [6]