> 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" <[email protected]> wrote:
>
>> > In group = opensmppbox, you need to set bearerbox-port = 13005 in order for
>> > sqlbox to "see" the messages.
>> >
>> > == Rene
>> >
>> > -----Original Message-----
>> > From: [email protected] [mailto:[email protected]] On Behalf
>> > Of Michael van der Poel
>> > Sent: Tuesday, 28 June, 2011 21:27
>> > To: [email protected]
>> > 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
>> >
>> >
>> >
>> >
>> >
>> >
>> >
