Hi all,
I am trying to get sqlbox running. When I recieve a MO message though,
the message doesn't get to the sqlbox. Here is my log from the bearerbox:
2007-12-03 15:51:11 [26303] [6] DEBUG: SMPP PDU 0x81aeec0 dump:
2007-12-03 15:51:11 [26303] [6] DEBUG: type_name: deliver_sm
2007-12-03 15:51:11 [26303] [6] DEBUG: command_id: 5 = 0x00000005
2007-12-03 15:51:11 [26303] [6] DEBUG: command_status: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: sequence_number: 1 = 0x00000001
2007-12-03 15:51:11 [26303] [6] DEBUG: service_type: "1050"
2007-12-03 15:51:11 [26303] [6] DEBUG: source_addr_ton: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: source_addr_npi: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: source_addr: "19317873889"
2007-12-03 15:51:11 [26303] [6] DEBUG: dest_addr_ton: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: dest_addr_npi: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: destination_addr: "63333"
2007-12-03 15:51:11 [26303] [6] DEBUG: esm_class: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: protocol_id: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: priority_flag: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: schedule_delivery_time: NULL
2007-12-03 15:51:11 [26303] [6] DEBUG: validity_period: NULL
2007-12-03 15:51:11 [26303] [6] DEBUG: registered_delivery: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: replace_if_present_flag: 0 =
0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: data_coding: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000
2007-12-03 15:51:11 [26303] [6] DEBUG: sm_length: 10 = 0x0000000a
2007-12-03 15:51:11 [26303] [6] DEBUG: short_message: "Live chat?"
2007-12-03 15:51:11 [26303] [6] DEBUG: mblox_operator: "31003"
2007-12-03 15:51:11 [26303] [6] DEBUG: SMPP PDU dump ends.
2007-12-03 15:51:11 [26303] [6] WARNING: smsbox_list empty!
I use the standalone sqlbox. My config files are therefore two configs:
one for kannel, one for sqlbox. They look like this:
group = core
admin-port = 13012
admin-port-ssl = no
smsbox-port = 13015
admin-password = mbridges
admin-deny-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1;192.168.0.*"
log-file = "/usr/local/kannel-mblox/log/bearerbox.log"
log-level = 0
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1;85.158.201.163;85.158.201.165"
# SMSC CONNECTIONS
include = "/usr/local/kannel-mblox/conf/mblox.conf"
# SMSBOX SETUP
group = smsbox
bearerbox-host = localhost
bearerbox-port = 13016
smsbox-id = smsbox
sendsms-port = 13013
sendsms-port-ssl = no
#sendsms-chars = "0123456789 +-"
log-file = "/usr/local/kannel-mblox/log/smsbox.log"
access-log = "/usr/local/kannel-mblox/log/smsbox_access.log"
log-level = 0
# SEND-SMS USERS
group = sendsms-user
username = mbridges
password = *removed*
user-allow-ip = "127.0.0.1"
# SERVICES
group = smsbox-route
smsbox-id = smsbox
smsc-id = "mblox"
My sqlbox.conf:
group = mysql-connection
id = sqlbox-db
host = "localhost"
port = 3306
username = "xxx"
password = "xxx"
database = "xxx"
max-connections = 10
# SQL BOX CONFIG
group = sqlbox
# id corresponds to id in group = mysql-connection.
# this is analogous to id in group = dlr-db
id = sqlbox-db
# smsbox-id indicates the box where SQL-injected messages appear to be
coming fr
smsbox-id = sqlbox
# bearerbox host to connect to
bearerbox-host = localhost
bearerbox-port = 13012
# smsbox port to be listening on
smsbox-port = 13016
smsbox-port-ssl = false
# sql-log-table is the table used to log all sent messages
sql-log-table = sent_sms
# sql-insert-table is the table that is monitored for new messages to send
sql-insert-table = send_sms
# global sender: If no sender is specified in sql-insert-table then this
# value is used.
#global-sender = 06121
log-file = "/usr/local/kannel-mblox/log/sqlbox.log"
log-level = 0
#ssl-client-certkey-file = ""
#ssl-server-cert-file = ""
#ssl-server-key-file = ""
#ssl-trusted-ca-file = ""
Can somebody please help and tell me what I am doing wrong here?
Thanks in advance!
Kind regards,
Roland.
