you need to set first the sqlbox to listen to the bearerbox and then the smsbox to listen to the sqlbox instead the bearerbox
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" 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 = sqlbox-db smsbox-id = smsbox bearerbox-host = localhost bearerbox-port = 13015 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/usr/local/kannel-mblox/log/sqlbox.log" log-level = 0 # SMSBOX SETUP group = smsbox bearerbox-host = localhost bearerbox-port = 13005 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 -----Original Message----- From: Rolandow [EMAIL PROTECTED] Sent: 03 ???????? 2007 ?. To: seik Subject:MO Messages don't get to SQLBox > 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.
