Hi
I 'm start using sqlbox and have 2 issues:
A) When started with log in debug mode I get:
user@peru8:/etc/init.d# tail -f -n 500 /var/log/kannel/sqlbox.log
2014-06-12 23:04:31 [29053] [0] INFO: Added logfile
`/var/log/kannel/sqlbox.log' with level `0'.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost.
2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version
5.5.37-0ubuntu0.12.04.1, client version 5.5.37.
2014-06-12 23:04:31 [29053] [0] DEBUG: Started thread 1
(sqlbox.c:sql_to_bearerbox)
2014-06-12 23:04:31 [29053] [1] DEBUG: Thread 1
(sqlbox.c:sql_to_bearerbox) maps to pid 29053.
2014-06-12 23:04:31 [29053] [1] DEBUG: Connecting to <127.0.0.1>
2014-06-12 23:04:31 [29053] [1] INFO: Connected to bearerbox at
localhost port 13001.
2014-06-12 23:04:31 [29053] [1] DEBUG: Started thread 2
(sqlbox.c:bearerbox_to_sql)
2014-06-12 23:04:31 [29053] [2] DEBUG: Thread 2
(sqlbox.c:bearerbox_to_sql) maps to pid 29053.
After this, no other info is logged, not with traffic, not on
"stand-by", not on sqlbox shutdown. Nothing until I restart sqlbox
when it logs the same info.
However sqlbox works properly. Messages are being sent and records are
moved to sent_sms.
B) dlr_url is not called.
I'm running sqlbox with the same user/credentials as bearerbox and
smsbox; those calls dlr-url with no problems.
This is my insert:
INSERT INTO send_sms (momt, sender, receiver, udhdata, msgdata,
smsc_id, sms_type, coding, compress, validity, dlr_mask, dlr_url )
VALUES ('MT', '991212213', '991212211', NULL, 'abcde12345-4',
'Peru-C', NULL, NULL, NULL, 4200,
31,'http://127.0.0.1/sms/dlr.php?type=8&slid=5248&uid=10&smsc=smsc2email&sender_id=MiSender'
);
and this is my table content:
(root@app2) [playsms]> 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 | foreign_id |
+--------+------+-----------+-----------+---------+--------------+------------+---------+---------+---------+------+----------+--------+------+--------+----------+----------+----------+----------+---------------------------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+-----------+------------+
| 1 | MT | 991212213 | 991212211 | NULL | abcde12345-2 |
NULL | Peru-C | NULL | NULL | NULL | 2 | NULL | NULL
| 2 | NULL | 4200 | NULL | 31 |
http://127.0.0.1/sms/dlr.php?type=8&slid=5248&uid=10&smsc=smsc2email&sender_id=MiSender
| NULL | NULL | NULL | NULL | sqlbox | NULL | NULL | 1
|
| 2 | DLR | 991212213 | 991212211 | NULL | ACK%2F |
1402628190 | Peru-C1 | NULL | NULL | NULL | 3 | NULL |
NULL | NULL | NULL | NULL | NULL | 8 |
http://127.0.0.1/sms/dlr.php?type=8&slid=5248&uid=10&smsc=smsc2email&sender_id=MiSender
| NULL | NULL | NULL | NULL | sqlbox | NULL | NULL | 20
|
+--------+------+-----------+-----------+---------+--------------+------------+---------+---------+---------+------+----------+--------+------+--------+----------+----------+----------+----------+---------------------------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+-----------+------------+
2 rows in set (0.00 sec)
This is my 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/sqlbox.log"
log-level = 0
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = pass
database = kannel
max-connections = 8
my kannel.conf:
#CORE BEARERBOX
group = core
admin-port = 13000
smsbox-port = 13001
wapbox-port = 13002
dlr-storage = mysql
admin-password=admin
status-password=status
box-allow-ip = "127.0.0.1"
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
# SMSBOX SETUP
#
group = smsbox
bearerbox-host = 127.0.0.1
sendsms-chars = "0123456789 +"
sendsms-port = 13013
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
access-log = "/var/log/kannel/smsaccess.log"
http-request-retry = 10
http-queue-delay = 60
# SEND-SMS USERS
group = sendsms-user
username = user
password = pass
name = sms
# SMS SERVICE
group = sms-service
keyword = default
get-url =
"http://localhost/sms/geturl.php?t=%t&q=%q&a=%a&inc_smsc=%i&coding=%c&charset=%C";
max-messages = 0
concatenation = true
accept-x-kannel-headers = true
#
my proceses:
root 29465 1 0 23:27 ? 00:00:00
/usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file
/var/run/kannel_bbox.pid /etc/kannel/kannel.conf
root 29467 29465 0 23:27 ? 00:00:00
/usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file
/var/run/kannel_bbox.pid /etc/kannel/kannel.conf
root 29518 1 0 23:27 ? 00:00:00 /usr/local/sbin/smsbox
-v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid
/etc/kannel/kannel.conf
root 29520 29518 0 23:27 ? 00:00:00 /usr/local/sbin/smsbox
-v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid
/etc/kannel/kannel.conf
root 29532 1 0 23:27 ? 00:00:00 /usr/local/sbin/sqlbox
-v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid
/etc/kannel/sqlbox.conf
root 29534 29532 0 23:27 ? 00:00:00 /usr/local/sbin/sqlbox
-v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid
/etc/kannel/sqlbox.conf
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
