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 >> >> >> >> > >> > >> > >