Your opensmppbox logs don't show any connection. How do you send messages? If by smsbox, please post the url that you are sending from.
== Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Michael van der Poel Sent: Tuesday, 28 June, 2011 22:40 To: users@kannel.org Subject: Re: Problem configuring opensmppbox Thanks, Rene! I have made that change. I just sent a message: still no joy. below is what the logs show. I am afraid, there is more to it. Maybe you spot something else. Any help you could give, would be great. Today, I am at a loss, after many hours reading, testing.. Thanks, Michael Bearerbox log: 2011-06-28 20:13:17 [31932] [5] DEBUG: Started thread 8 (gw/bb_boxc.c:function) 2011-06-28 20:13:17 [31932] [8] DEBUG: Thread 8 (gw/bb_boxc.c:function) maps to pid 31932. 2011-06-28 20:13:17 [31932] [8] DEBUG: Started thread 9 (gw/bb_boxc.c:boxc_sender) 2011-06-28 20:13:17 [31932] [9] DEBUG: Thread 9 (gw/bb_boxc.c:boxc_sender) maps to pid 31932. 2011-06-28 20:13:17 [31932] [8] DEBUG: boxc_receiver: got boxc_id <sqlbox> from <127.0.0.1> 2011-06-28 20:13:48 [31932] [8] DEBUG: boxc_receiver: sms received 2011-06-28 20:13:48 [31932] [8] DEBUG: send_msg: sending msg to boxc: <sqlbox> 2011-06-28 20:13:49 [31932] [9] DEBUG: send_msg: sending msg to boxc: <sqlbox> 2011-06-28 20:13:49 [31932] [9] DEBUG: boxc_sender: sent message to <127.0.0.1> 2011-06-28 20:13:49 [31932] [8] DEBUG: boxc_receiver: got ack Sqlbox log: 2011-06-28 18:38:12 [28464] [0] DEBUG: Immutable octet strings: 65. 2011-06-28 20:13:17 [31945] [0] INFO: Added logfile `/var/log/kannel/kannel-sqlbox.log' with level `0'. 2011-06-28 20:13:17 [31945] [0] INFO: MYSQL: Connected to server at localhost. 2011-06-28 20:13:17 [31945] [0] INFO: MYSQL: server version 5.0.92-community, client version 5.0.92. 2011-06-28 20:13:17 [31945] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2011-06-28 20:13:17 [31945] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 31945. 2011-06-28 20:13:17 [31945] [1] DEBUG: Connecting to <127.0.0.1> 2011-06-28 20:13:17 [31945] [1] INFO: Connected to bearerbox at localhost port 13003. 2011-06-28 20:13:17 [31945] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2011-06-28 20:13:17 [31945] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 31945. smpp-SMSC log: 2011-06-28 20:18:11 [31932] [6] DEBUG: SMPP[smpp-SMSC]: throughput (0.00,10.00) 2011-06-28 20:18:11 [31932] [6] DEBUG: SMPP[smpp-nexmo]: throughput (0.00,10.00) 2011-06-28 20:18:11 [31932] [6] DEBUG: SMPP[smpp-nexmo]: Got PDU: 2011-06-28 20:18:11 [31932] [6] DEBUG: SMPP PDU 0x11852750 dump: 2011-06-28 20:18:11 [31932] [6] DEBUG: type_name: enquire_link_resp 2011-06-28 20:18:11 [31932] [6] DEBUG: command_id: 2147483669 = 0x80000015 2011-06-28 20:18:11 [31932] [6] DEBUG: command_status: 0 = 0x00000000 2011-06-28 20:18:11 [31932] [6] DEBUG: sequence_number: 14 = 0x0000000e 2011-06-28 20:18:11 [31932] [6] DEBUG: SMPP PDU dump ends. 2011-06-28 20:18:11 [31932] [6] DEBUG: SMPP[smpp-nexmo]: throughput (0.00,10.00) Opensmppbox log: 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. 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. 2011-06-28 18:58:06 [28589] [0] DEBUG: Immutable octet strings: 112. 2011-06-28 20:12:46 [31943] [0] INFO: Added logfile `/var/log/kannel/opensmppbox.log' with level `0'. 2011-06-28 20:12:46 [31943] [0] INFO: Waiting for SMPP connections on port 8000. On 28/6/11 21:04, "Rene Kluwen" <rene.klu...@chimit.nl> wrote: > 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 > > > > > > >