Are you sure registered_delivery is set on the messages going out? smsbox
should be receiving the dlr's back, there must be something on bearerbox
log and eventually smsbox log, do you have log-level 0 on both?
On Sat, Jun 14, 2014 at 9:53 AM, Alvaro Cornejo <cornejo.alv...@gmail.com>
wrote:
> Hi Alejandro
>
> No, there is nothing on smsbox log
>
> Regards
>
> Alvaro
>
> |-----------------------------------------------------------------------------------------------------------------|
> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> celular y Nextel
> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
> SMS y GPRS online
> Visitenos en www.perusms.com
>
>
> On Sat, Jun 14, 2014 at 12:55 AM, Alejandro Guerrieri
> <alejandro.guerri...@gmail.com> wrote:
> > I mean, the dlr's would be routed to smsbox along with the mo's, and
> smsbox
> > would be responsible for calling dlr-url as well.
> >
> >
> > On Sat, Jun 14, 2014 at 1:54 AM, Alejandro Guerrieri
> > <alejandro.guerri...@gmail.com> wrote:
> >>
> >> Is there anything on smsbox log?
> >>
> >>
> >> On Fri, Jun 13, 2014 at 11:54 PM, Alvaro Cornejo
> >> <cornejo.alv...@gmail.com> wrote:
> >>>
> >>> Hi Alejandro
> >>>
> >>> Thanks for your help. It works as you said; each box is working
> >>> independently; however sqlbox dlrs are not being called. I've tried by
> >>> adding sqlbox-id in boxc_id field to match sqlbox-id but nothing. If I
> >>> leave that field blanc, it gets automatically filed with sqlbox_id
> >>> (sqlbox).
> >>>
> >>> What is strange is that sqlbox logs shows nothing on it after a couple
> >>> of entries at box start. I've posted another question on list.
> >>>
> >>> In bearerbox I see the transaction and my http smsc responding
> >>> correctly to bearerbox but no dlr call.
> >>>
> >>> Regards
> >>>
> >>> Alvaro
> >>>
> >>>
> >>> This is my insert:
> >>>
> >>> INSERT INTO send_sms (momt, sender, receiver, udhdata, msgdata,
> >>> smsc_id, sms_type, coding, compress, validity, dlr_mask, dlr_url,
> >>> boxc_id ) VALUES ('MT', '991212213', '991212211', NULL, 'sqlbox
> >>> 10:30', 'smsc2email', 2, 2, NULL, 4200,
> >>>
> >>> 31,'
> http://127.0.0.1/sms/dlr.php?type=%d&slid=10499166&uid=10&smsc=smsc2email&sender_id=MiSender
> ',
> >>> 'sqlbox' )
> >>>
> >>>
> >>> mysql> SELECT * FROM sent_sms ;
> >>>
> >>>
> +--------+------+-----------+-----------+---------+----------------+------------+------------+---------+---------+------+----------+--------+------+--------+----------+------------+----------+----------+----------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+-----------+
> >>> | sql_id | momt | sender | receiver | udhdata | msgdata |
> >>> time | smsc_id | service | account | id | sms_type | mclass
> >>> | mwi | coding | compress | validity | deferred | dlr_mask |
> >>> dlr_url
> >>> | pid | alt_dcs | rpi | charset | boxc_id |
> >>> binfo | meta_data |
> >>>
> >>>
> +--------+------+-----------+-----------+---------+----------------+------------+------------+---------+---------+------+----------+--------+------+--------+----------+------------+----------+----------+----------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+-----------+
> >>> | 50 | MT | 991212213 | 991212211 | NULL | sqlbox+10%3A30 |
> >>> NULL | smsc2email | NULL | NULL | NULL | 2 | NULL |
> >>> NULL | 2 | NULL | 1402968893 | NULL | 31 |
> >>>
> >>>
> http://127.0.0.1/sms/dlr.php?type=%d&slid=10499166&uid=10&smsc=smsc2email&sender_id=MiSender
> >>> | NULL | NULL | NULL | NULL | sqlbox | NULL | NULL |
> >>> | 51 | DLR | 991212213 | 991212211 | NULL | ACK%2F |
> >>> 1402716894 | smsc2email | NULL | NULL | NULL | 3 | NULL
> >>> | NULL | NULL | NULL | NULL | NULL | 8 |
> >>>
> >>>
> http://127.0.0.1/sms/dlr.php?type=%d&slid=10499166&uid=10&smsc=smsc2email&sender_id=MiSender
> >>> | NULL | NULL | NULL | NULL | sqlbox | NULL | NULL |
> >>>
> >>>
> +--------+------+-----------+-----------+---------+----------------+------------+------------+---------+---------+------+----------+--------+------+--------+----------+------------+----------+----------+----------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+-----------+
> >>> 2 rows in set (0.00 sec)
> >>>
> >>> My updated sqlbox.conf:
> >>> group = sqlbox
> >>> id = sqlbox
> >>> smsbox-id = sqlbox
> >>> bearerbox-host = localhost
> >>> bearerbox-port = 13001
> >>> smsbox-port = 13005
> >>> sql-log-table = sent_sms
> >>> sql-insert-table = send_sms
> >>> log-file = "/var/log/kannel/sqlbox.log"
> >>> log-level = 0
> >>>
> >>> group = mysql-connection
> >>> id = sqlbox
> >>> host = localhost
> >>> username = root
> >>> password = pass
> >>> database = sms
> >>> max-connections = 2
> >>>
> >>>
> >>> My updated kannel.conf:
> >>> #CORE BEARERBOX
> >>> group = core
> >>> admin-port = 13000
> >>> smsbox-port = 13001
> >>> dlr-storage = mysql
> >>> admin-password = admin
> >>> status-password = status
> >>> box-allow-ip = "*.*.*.*"
> >>> box-deny-ip = "*.*.*.*"
> >>> log-file = "/var/log/kannel/bearerbox.log"
> >>> log-level = 0
> >>> access-log = "/var/log/kannel/beareraccess.log"
> >>> store-type = spool
> >>> store-location = /var/log/kannel/spool
> >>> wdp-interface-name = "*"
> >>> sms-incoming-queue-limit = 50
> >>>
> >>> group = smsbox-route
> >>> smsbox-id = sqlbox
> >>> smsc-id = sqlbox
> >>>
> >>> group = smsbox
> >>> bearerbox-host = 127.0.0.1
> >>> bearerbox-port=13001
> >>> sendsms-port = 13013
> >>> log-file = "/var/log/kannel/smsbox.log"
> >>> log-level = 0
> >>> http-request-retry = 10
> >>> http-queue-delay = 60
> >>>
> >>>
> >>> Bearerbox log:
> >>>
> >>> 2014-06-13 22:34:53 [20387] [22] DEBUG: boxc_receiver: sms received
> >>> 2014-06-13 22:34:53 [20387] [22] DEBUG: send_msg: sending msg to boxc:
> >>> <sqlbox>
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Queue contains 0 pending
> >>> requests.
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Parsing URL
> >>>
> >>> `
> http://localhost/sms/plugin/gateway/kannel/mail_smsc.php?u=nxtl_usr&p=nxtl_pass&to=991212211&from=991212213&msg=sqlbox+10%3A30
> ':
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Scheme: http://
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Host: localhost
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Port: 80
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Username: (null)
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Password: (null)
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Path:
> >>> /sms/plugin/gateway/kannel/mail_smsc.php
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Query:
> >>> u=nxtl_usr&p=nxtl_pass&to=991212211&from=991212213&msg=sqlbox+10%3A30
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Fragment: (null)
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Connecting nonblocking to
> >>> <127.0.0.1>
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: HTTP: Opening connection to
> >>> `localhost:80' (fd=74).
> >>> 2014-06-13 22:34:53 [20387] [25] DEBUG: Socket connecting
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: Get info about connecting
> socket
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: HTTP: Sending request:
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: Octet string at 0x9fcb440:
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: len: 168
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: size: 1024
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: immutable: 0
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 47 45 54 20 2f 73 6d
> >>> 73 2f 70 6c 75 67 69 6e 2f GET /sms/plugin/
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 67 61 74 65 77 61 79
> >>> 2f 6b 61 6e 6e 65 6c 2f 6d gateway/kannel/m
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 61 69 6c 5f 73 6d 73
> >>> 63 2e 70 68 70 3f 75 3d 6e ail_smsc.php?u=n
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 78 74 6c 5f 75 73 72
> >>> 26 70 3d 6e 78 74 6c 5f 70 xtl_usr&p=nxtl_p
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 61 73 73 26 74 6f 3d
> >>> 39 39 31 32 31 32 32 31 31 ass&to=991212211
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 26 66 72 6f 6d 3d 39
> >>> 39 31 32 31 32 32 31 33 26 &from=991212213&
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 6d 73 67 3d 73 71 6c
> >>> 62 6f 78 2b 31 30 25 33 41 msg=sqlbox+10%3A
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 33 30 20 48 54 54 50
> >>> 2f 31 2e 31 0d 0a 48 6f 73 30 HTTP/1.1..Hos
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 74 3a 20 6c 6f 63 61
> >>> 6c 68 6f 73 74 0d 0a 43 6f t: localhost..Co
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 6e 6e 65 63 74 69 6f
> >>> 6e 3a 20 6b 65 65 70 2d 61 nnection: keep-a
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: data: 6c 69 76 65 0d 0a 0d
> >>> 0a live....
> >>> 2014-06-13 22:34:53 [20387] [24] DEBUG: Octet string dump ends.
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: HTTP: Status line: <HTTP/1.1
> 200
> >>> OK>
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: HTTP: Received response:
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: Octet string at 0x9fcb4f0:
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: len: 351
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: size: 1024
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: immutable: 0
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 44 61 74 65 3a 20 53
> >>> 61 74 2c 20 31 34 20 4a 75 Date: Sat, 14 Ju
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 6e 20 32 30 31 34 20
> >>> 30 33 3a 33 34 3a 35 33 20 n 2014 03:34:53
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 47 4d 54 0d 0a 53 65
> >>> 72 76 65 72 3a 20 41 70 61 GMT..Server: Apa
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 63 68 65 2f 32 2e 32
> >>> 2e 31 34 20 28 46 65 64 6f che/2.2.14 (Fedo
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 72 61 29 0d 0a 53 65
> >>> 74 2d 43 6f 6f 6b 69 65 3a ra)..Set-Cookie:
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 20 53 45 53 53 49 44
> >>> 3d 62 62 38 71 32 61 6f 69 SESSID=bb8q2aoi
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 37 72 34 37 76 30 73
> >>> 72 71 65 73 37 67 39 33 73 7r47v0srqes7g93s
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 63 31 3b 20 70 61 74
> >>> 68 3d 2f 0d 0a 45 78 70 69 c1; path=/..Expi
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 72 65 73 3a 20 54 68
> >>> 75 2c 20 31 39 20 4e 6f 76 res: Thu, 19 Nov
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 20 31 39 38 31 20 30
> >>> 38 3a 35 32 3a 30 30 20 47 1981 08:52:00 G
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 4d 54 0d 0a 43 61 63
> >>> 68 65 2d 43 6f 6e 74 72 6f MT..Cache-Contro
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 6c 3a 20 6e 6f 2d 73
> >>> 74 6f 72 65 2c 20 6e 6f 2d l: no-store, no-
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 63 61 63 68 65 2c 20
> >>> 6d 75 73 74 2d 72 65 76 61 cache, must-reva
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 6c 69 64 61 74 65 2c
> >>> 20 70 6f 73 74 2d 63 68 65 lidate, post-che
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 63 6b 3d 30 2c 20 70
> >>> 72 65 2d 63 68 65 63 6b 3d ck=0, pre-check=
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 30 0d 0a 50 72 61 67
> >>> 6d 61 3a 20 6e 6f 2d 63 61 0..Pragma: no-ca
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 63 68 65 0d 0a 56 61
> >>> 72 79 3a 20 41 63 63 65 70 che..Vary: Accep
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 74 2d 45 6e 63 6f 64
> >>> 69 6e 67 0d 0a 43 6f 6e 74 t-Encoding..Cont
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 65 6e 74 2d 4c 65 6e
> >>> 67 74 68 3a 20 32 0d 0a 43 ent-Length: 2..C
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 6f 6e 6e 65 63 74 69
> >>> 6f 6e 3a 20 63 6c 6f 73 65 onnection: close
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 0d 0a 43 6f 6e 74 65
> >>> 6e 74 2d 54 79 70 65 3a 20 ..Content-Type:
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: data: 74 65 78 74 2f 68 74
> >>> 6d 6c 0d 0a 0d 0a 4f 4b text/html....OK
> >>> 2014-06-13 22:34:54 [20387] [24] DEBUG: Octet string dump ends.
> >>> 2014-06-13 22:34:54 [20387] [23] DEBUG: send_msg: sending msg to boxc:
> >>> <sqlbox>
> >>> 2014-06-13 22:34:54 [20387] [22] DEBUG: boxc_receiver: got ack
> >>> 2014-06-13 22:34:54 [20387] [23] DEBUG: boxc_sender: sent message to
> >>> <127.0.0.1>
> >>> 2014-06-13 22:34:55 [20387] [2] DEBUG: HTTP: Creating HTTPClient for
> >>> `127.0.0.1'.
> >>> 2014-06-13 22:34:55 [20387] [2] DEBUG: HTTP: Created HTTPClient area
> >>> 0xa9a00d38.
> >>>
> >>>
> >>>
> >>>
> |-----------------------------------------------------------------------------------------------------------------|
> >>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> >>> celular y Nextel
> >>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
> >>> SMS y GPRS online
> >>> Visitenos en www.perusms.com
> >>>
> >>>
> >>> On Fri, Jun 13, 2014 at 9:54 PM, Alejandro Guerrieri
> >>> <alejandro.guerri...@gmail.com> wrote:
> >>> > Yes, both would connect to bearerbox on the same port, but since
> sqlbox
> >>> > has
> >>> > and smsbox-id it would only receive traffic if you put a specific
> >>> > mo-route
> >>> > to it.
> >>> >
> >>> > Regards,
> >>> >
> >>> > Alejandro
> >>> >
> >>> >
> >>> > On Fri, Jun 13, 2014 at 8:21 PM, Alvaro Cornejo
> >>> > <cornejo.alv...@gmail.com>
> >>> > wrote:
> >>> >>
> >>> >> Hi Alejandro
> >>> >>
> >>> >> Is this what you mean?
> >>> >>
> >>> >> sqlbox < --[13001]--> bearerbox < --[13001]--> smsbox
> >>> >>
> >>> >> kannel.conf (to use with bearerbox):
> >>> >> group = core
> >>> >> smsbox-port = 13001
> >>> >> ...
> >>> >>
> >>> >> sqlbox.conf:
> >>> >> group = sqlbox
> >>> >> bearerbox-host = localhost
> >>> >> bearerbox-port = 13001
> >>> >> #smsbox-port = 13005 (No smsbox-port since no need to connect to
> >>> >> smsbox)
> >>> >> smsbox-id = sqlbox (This way all MO will go directly to smsbox)
> >>> >> ...
> >>> >>
> >>> >> smsbox.conf:
> >>> >> group = core
> >>> >> smsbox-port = 13001
> >>> >> #smsbox-id = sqlbox (No smsbox-id)
> >>> >> ...
> >>> >>
> >>> >>
> >>> >>
> |-----------------------------------------------------------------------------------------------------------------|
> >>> >> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde
> cualquier
> >>> >> celular y Nextel
> >>> >> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias
> via
> >>> >> SMS y GPRS online
> >>> >> Visitenos en www.perusms.com
> >>> >>
> >>> >>
> >>> >> On Thu, Jun 12, 2014 at 7:30 PM, Alejandro Guerrieri
> >>> >> <alejandro.guerri...@gmail.com> wrote:
> >>> >> > Yes, indeed. For mt, both will be able to send. To avoid sqlbox
> from
> >>> >> > receiving mo's, assign it an smsbox-id. If you want to route
> >>> >> > specific
> >>> >> > traffic to it you can add an smsbox-route, all the other traffic
> >>> >> > will go to
> >>> >> > the smsbox without smsbox-id.
> >>> >> >
> >>> >> > Check the user guide for more details.
> >>> >> > --
> >>> >> > Alex Guerrieri
> >>> >> >
> >>> >> >> On Jun 12, 2014, at 20:24, Alvaro Cornejo
> >>> >> >> <cornejo.alv...@gmail.com>
> >>> >> >> wrote:
> >>> >> >>
> >>> >> >> Hi
> >>> >> >>
> >>> >> >> Is it possible to have sqlbox and smsbox connected to the same
> >>> >> >> bearerbox at the same time?
> >>> >> >>
> >>> >> >> This is what we need:
> >>> >> >>
> >>> >> >> A) FOR MT
> >>> >> >>
> >>> >> >> I want to handle different services independently through each
> >>> >> >> service.
> >>> >> >>
> >>> >> >> sqlbox <-----\
> >>> >> >> ----> bearerbox <---> smsc
> >>> >> >> smsbox <-----/
> >>> >> >>
> >>> >> >> B) FOR MO:
> >>> >> >>
> >>> >> >> I want to route everything to smsbox
> >>> >> >>
> >>> >> >>
> >>> >> >> my config files:
> >>> >> >>
> >>> >> >> SQLBOX FILE:
> >>> >> >>
> >>> >> >> group = sqlbox
> >>> >> >> id = sqlbox-db
> >>> >> >> smsbox-id = sqlbox
> >>> >> >> bearerbox-host = localhost
> >>> >> >> bearerbox-port = 13001
> >>> >> >> # smsbox-port = 13005 not configured since I dont want sqlbox to
> go
> >>> >> >> through it
> >>> >> >>
> >>> >> >> KANNEL CONFIG FILE:
> >>> >> >> group = core
> >>> >> >> admin-port = 13000
> >>> >> >> smsbox-port = 13001
> >>> >> >> #wapbox-port = 13002
> >>> >> >> dlr-storage = mysql
> >>> >> >>
> >>> >> >> group = smsbox
> >>> >> >> bearerbox-host = 127.0.0.1
> >>> >> >> sendsms-chars = "0123456789 +"
> >>> >> >> sendsms-port = 13013
> >>> >> >>
> >>> >> >> # SEND-SMS USERS
> >>> >> >> group = sendsms-user
> >>> >> >> username = user
> >>> >> >> password = pass
> >>> >> >> name = send_der
> >>> >> >>
> >>> >> >>
> >>> >> >> # SMS SERVICE
> >>> >> >> group = sms-service
> >>> >> >> keyword = default
> >>> >> >> # concatenation = true
> >>> >> >> get-url =
> >>> >> >> "http://localhost/sms/geturl.php?t=%t&q=%q&a=%a&inc_smsc=%i
> >>> >> >> max-messages = 0
> >>> >> >> concatenation = true
> >>> >> >>
> >>> >> >> Regards
> >>> >> >>
> >>> >> >> Alvaro
> >>> >> >>
> >>> >> >>
> >>> >> >>
> >>> >> >>
> >>> >> >>
> |-----------------------------------------------------------------------------------------------------------------|
> >>> >> >> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde
> >>> >> >> cualquier
> >>> >> >> celular y Nextel
> >>> >> >> en el Perú, México y en mas de 180 paises. Use aplicaciones 2
> vias
> >>> >> >> via
> >>> >> >> SMS y GPRS online
> >>> >> >> Visitenos en www.perusms.com
> >>> >> >>
> >>> >
> >>> >
> >>
> >>
> >
>
