Hi,
To get MTs recorded to sqlbox DB, you need to use the following schema:
MT->smsbox->sqlbox->bearerbox
BR,
Nikos
----- Original Message -----
From: [email protected]
To: [email protected]
Sent: Tuesday, October 05, 2010 2:13 PM
Subject: help with sms-service and sqlbox
Hey fellows my kannel server keeps telling me that it can not fetch content
even when i specified the directives required in the get-url as you can see
below.Then i have installed sqlbox on my fedora 13 but what baffles me is
when i send the messages using the httpd interface nothing is recorded in
the table sent_sms even if the message is successfully sent.But when i do a
manual send in the database with the insert command on the mysql database
the messages are sent and stored in the database.Any idea what i should to
do in order for the messages to be recorded in the database when i send
using the http interface.
I defined the table message with fields msg,sender and time and wrote a
script that was supposed to insert the values into these fields specified by
the incomming message.Could you correct me if am wrong because in my
understanding %a,%t and %p are variables for message,time and phone number
respectively.Hence i used msg,time and sender as my variables for my php
script that was required to insert the messages into the table defined.
The smskannel and sqlbox are successfully starting but there are in two
seperate configurations but are both in the same directory.
smskannel configuration file
group = core
admin-port = 13000
smsbox-port = 13001
admin-password = camcom
status-password = camcom
#admin-deny-ip = ""
#admin-allow-ip = ""
#log-file = "/tmp/kannel.log"
#log-level = 0
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
#unified-prefix = "+358,00358,0;+,00"
#access-log = "/tmp/access.log"
#store-file = "kannel.store"
#ssl-server-cert-file = "cert.pem"
#ssl-server-key-file = "key.pem"
#ssl-certkey-file = "mycertandprivkeyfile.pem"
dlr-storage = mysql
#group = smsc
#smsc = fake
#smsc-id = FAKE
#port = 20000
#connect-allow-ip = 127.0.0.1
group = smsc
smsc = at
modemtype = auto
device = /dev/ttyUSB0
my-number = 0888959802
log-level = 0
sim-buffering = true
group = smsbox
bearerbox-host = localhost
sendsms-port = 13013
sendsms-chars = "0123456789"
global-sender = "0888959802"
access-log = "/home/camcom/kannel.access"
log-file = "/home/camcom/smsbox.log"
log-level = 0
#sendsms-chars = "0123456789 +-"
#log-file = "/tmp/smsbox.log"
#access-log = "/tmp/access.log"
group = sendsms-user
username = camcom
password = camcom
max-messages = 2
concatenation = true
group = sms-service
keyword = default
#text = "You asked nothing and I did it!"
get-url =
"http://127.0.0.1:80/var/www/html/receive.php?msg=%a&time=%t&sender=%p";
max-messages = 1
concatenation = true
#group = sms-service
#keyword = default
#text = "No service specified"
group = mysql-connection
id = mydlr
host = localhost
username = root
password = camcom
database = dlr
# max count of connections that will be opened for dbpool
#default is 1
#max-connections = 1
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
group = modems
id = huawei_e160
name = "huawei_e160"
detect-string = "huawei"
init-string = "ATZ"
init-string = "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0"
init-string = "AT+CNMI= 2,0,0,2,0"
message-storage = sm
speed = 9600
sqlbox configuration
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 13001
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
#ssl-client-certkey-file = ""
#ssl-server-cert-file = ""
#ssl-server-key-file = ""
#ssl-trusted-ca-file = ""
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = camcom
database = dlr
max-connections = 1
