In group = opensmppbox, you need to set bearerbox-port = 13005 in order for sqlbox to "see" the messages.
== Rene -----Original Message----- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Michael van der Poel Sent: Tuesday, 28 June, 2011 21:27 To: users@kannel.org Subject: Problem configuring opensmppbox Hi everyone, I am connecting to my SMSC through SMPP and I am impressed by Kannel's performance. I have HTTP before and I am glad, I have moved to Kannel. Kannel and sqlbox are working fine and now I would like to get delivery reports and store these in a MySQL database (tekstberichten) with a table called 'verslag'. A few days ago I have installed opensmppbox for that reason, hoping that thus I could link bearerbox to sqlbox to opensmppbox. opensmppbox seems to start ok but seems to be idle while I sent 3 messages: 2011-06-28 18:25:09 [28589] [0] INFO: MYSQL: Connected to server at localhost. 2011-06-28 18:25:09 [28589] [0] INFO: MYSQL: server version 5.0.92-community, client version 5.0.92. 2011-06-28 18:25:09 [28589] [0] INFO: DLR using storage type: mysql 2011-06-28 18:25:09 [28589] [0] INFO: Starting to log to file /var/log/kannel/opensmppbox.log level 0 2011-06-28 18:25:09 [28589] [0] INFO: Added logfile `/var/log/kannel/opensmppbox.log' with level `0'. 2011-06-28 18:25:09 [28589] [0] INFO: Waiting for SMPP connections on port 8000. 2011-06-28 18:58:06 [28589] [0] ERROR: SIGINT received, aborting program... 2011-06-28 18:58:06 [28589] [0] INFO: No more waiting for SMPP connections. Kannel starts: 2011-06-28 18:18:08 [28382] [0] INFO: MYSQL: Connected to server at localhost. 2011-06-28 18:18:08 [28382] [0] INFO: MYSQL: server version 5.0.92-community, client version 5.0.92. 2011-06-28 18:18:08 [28382] [0] INFO: DLR using storage type: mysql 2011-06-28 18:18:08 [28382] [0] INFO: Added logfile `/var/log/kannel/bearerbox.log' with level `0'. 2011-06-28 18:18:08 [28382] [0] INFO: HTTP: Opening server at port 13000. 2011-06-28 18:18:08 [28382] [0] INFO: BOXC: 'smsbox-max-pending' not set, using default (100). 2011-06-28 18:18:08 [28382] [0] INFO: Set SMS resend frequency to 60 seconds. 2011-06-28 18:18:08 [28382] [0] INFO: SMS resend retry set to unlimited. 2011-06-28 18:18:08 [28382] [0] INFO: Set throughput to 10.000 for smsc id <smpp-SMSC> 2011-06-28 18:18:08 [28382] [0] INFO: DLR rerouting for smsc id <smpp-SMSC> disabled. 2011-06-28 18:18:08 [28382] [0] INFO: Added logfile `/var/log/kannel/smpp-SMSC.log' with level `0'. 2011-06-28 18:18:08 [28382] [0] WARNING: SMPP: receive-port for transceiver mode defined, ignoring. 2011-06-28 18:18:08 [28382] [6] INFO: Logging thread `6' to logfile `/var/log/kannel/smpp-SMSC.log' with level `0'. 2011-06-28 18:18:08 [28382] [0] INFO: ---------------------------------------- 2011-06-28 18:18:08 [28382] [0] INFO: Kannel bearerbox II version 1.5.0 starting 2011-06-28 18:18:08 [28382] [0] INFO: MAIN: Start-up done, entering mainloop 2011-06-28 18:19:07 [28382] [5] INFO: Client connected from <127.0.0.1> and closes: 2011-06-28 18:38:12 [28382] [8] INFO: Connection closed by the box <127.0.0.1> 2011-06-28 18:38:13 [28382] [0] INFO: All flow threads have died, killing core 2011-06-28 18:38:13 [28382] [0] INFO: Total WDP messages: received 0, sent 0 2011-06-28 18:38:13 [28382] [0] INFO: Total SMS messages: received 0, dlr 3, sent 3, dlr 0 The "DLR rerouting disabled" and transceiver port ignored messages I find strange. This is my Kannel config file: group = core admin-port = 13000 admin-password = bar admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1" smsbox-port = 13003 log-file = "/var/log/kannel/bearerbox.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" dlr-storage=mysql log-level=0 group = smsbox bearerbox-host="localhost" sendsms-port = 13013 sendsms-chars = "+0123456789" log-file = "/var/log/kannel/smsbox.log" log-level = 0 access-log = "/var/log/kannel/access.log" log-level = 0 mo-recode = 1 group = smsc smsc = smpp smsc-id = smpp-SMSC host = msg1.SMSC.com port = 8000 receive-port = 8000 transceiver-mode = 1 throughput = 10 smsc-username = USERNAME smsc-password = PASSWORD system-type = bijzonder dest-addr-ton=1 log-file = "/var/log/kannel/smpp-SMSC.log" log-level = 0 msg-id-type=0x01 enquire-link-interval = 30 group = sendsms-user username = username password = pwd forced-smsc = smpp-SMSC name = users user-deny-ip = "*.*.*.*" user-allow-ip = "127.0.0.1" max-messages = 3 concatenation = 1 omit-empty = 1 # DLR SETUP #mysql connection group = mysql-connection id = mydlr host = localhost username = gebruikersnaam password = geheimwoord database = tekstberichten max-connections = 10 group = dlr-db id = mydlr table=verslag field-smsc=smsc field-timestamp=timestamp field-destination=destination field-source=source field-service=service field-url=url field-mask=mask field-status=status field-boxc-id=boxc_id group = sms-service keyword = keyword-regex = .* catch-all = yes max-messages = 0 sqlbox config file: group = sqlbox id = sqlbox-db smsbox-id = sqlbox global-sender = "me" bearerbox-host = localhost bearerbox-port = 13003 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 = gebruikersnaam password = geheimwoord database = tekstberichten max-connections = 1 This is the opensmppbox conf. I have been editing and experimenting a lot and it probably is a mess in its present form: group = core dlr-storage = mysql group = mysql-connection id = mydlr host = localhost username = gebruikersnaam password = geheimwoord database = tekstberichten max-connections = 10 group = dlr-db id = mydlr table=verslag field-smsc=smsc field-timestamp=timestamp field-destination=destination field-source=source field-service=service field-url=url field-mask=mask field-status=status field-boxc-id=boxc-id group = opensmppbox opensmppbox-id = smppbox opensmppbox-port = 8000 bearerbox-host = localhost bearerbox-port = 13003 log-level = 0 log-file = /var/log/kannel/opensmppbox.log our-system-id = opensmppid route-to-smsc = fc smpp-logins = "/usr/local/kannel.1.5/smpplogins.txt" Finally, the smpplogins.txt: bijzonder USERNAME PASSWORD *.*.*.* As you can see from the bearerbox, sqlbox and opensmpp logs, the opensmppbox just sits there and is being ignored while I sent 3 messages. bearerbox log: 2011-06-28 18:38:13 [28382] [0] DEBUG: Waiting for 2 (gwlib/http.c:server_thread) to terminate 2011-06-28 18:38:13 [28382] [3] DEBUG: HTTP: No clients with requests, quitting. 2011-06-28 18:38:13 [28382] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) terminates. 2011-06-28 18:38:13 [28382] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) terminates. 2011-06-28 18:38:13 [28382] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) terminates. 2011-06-28 18:38:13 [28382] [0] DEBUG: final clean-up for SMSCConn 2011-06-28 18:38:13 [28382] [0] DEBUG: MO concatenated message handling cleaned up 2011-06-28 18:38:13 [28382] [0] INFO: Total WDP messages: received 0, sent 0 2011-06-28 18:38:13 [28382] [0] INFO: Total SMS messages: received 0, dlr 3, sent 3, dlr 0 2011-06-28 18:38:13 [28382] [0] DEBUG: Immutable octet strings: 261. sqlbox log: 2011-06-28 18:19:07 [28464] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2011-06-28 18:19:07 [28464] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 28464. 2011-06-28 18:19:07 [28464] [1] DEBUG: Connecting to <127.0.0.1> 2011-06-28 18:19:07 [28464] [1] INFO: Connected to bearerbox at localhost port 13003. 2011-06-28 18:19:07 [28464] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2011-06-28 18:19:07 [28464] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 28464. 2011-06-28 18:38:12 [28464] [2] DEBUG: bearerbox_to_sql: Bearerbox told us to shutdown. 2011-06-28 18:38:12 [28464] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) terminates. 2011-06-28 18:38:12 [28464] [0] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) still running 2011-06-28 18:38:12 [28464] [0] DEBUG: Immutable octet strings: 65. opensmpp log: 2011-06-28 17:01:03 [26262] [0] INFO: Added logfile `/var/log/kannel/opensmppbox.log' with level `0'. 2011-06-28 17:01:03 [26262] [0] INFO: Waiting for SMPP connections on port 80000. 2011-06-28 17:20:38 [26262] [0] WARNING: SIGHUP received, catching and re-opening logs 2011-06-28 17:20:38 [26262] [0] WARNING: SIGHUP received, catching and re-opening logs 2011-06-28 18:25:09 [28589] [0] INFO: Added logfile `/var/log/kannel/opensmppbox.log' with level `0'. 2011-06-28 18:25:09 [28589] [0] INFO: Waiting for SMPP connections on port 8000. I have been working on this for a few days now and I am probably not seeing things clearly any more. Your guidance would be much appreciated! Regards, Michael
