Hi Jovan,
I created Mysql tables a below.And also can any one please check my
kannel configuration if any mistake is there please let me know what is
wrong. I want to test message priority and message response (dlr-mask).
Database name *kannel*:
CREATE TABLE* dlr* (
*smsc* varchar(40),
* ts* varchar(40),
*destination* varchar(40),
*source* varchar(40),
*service* varchar(40),
*url *varchar(255),
*mask* int(10),
*status* int(10),
*boxc* varchar(40)
)
_*My Kannel.conf
*_#------ Kannel Box Admin Conf
group = core
admin-port = 13000
smsbox-port = 13001
admin-password = kiran
dlr-storage = mysql
log-file = "/var/log/kannel/bearerbox.log"
store-file = "/var/log/kannel/kannel.store"
access-log = "/var/log/kannel/access.log"
log-level = 0
#--- mysql connection
group = mysql-connection
id = mydlr
host = localhost
port = 3306
username = root
password = shaker
database = kannel
max-connections = 1
#---- DLR table structure
group = dlr-db
id = mydlr
table = kannel_dlr
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
#---- This is connection to smpp simulater
#group = smsc
#smsc = smpp
#smsc-id = testsmsc
#host = <a href="http://test.host.com"; target="_blank">test.host.com</a>
#port = 2775
#receive-port = 2775
#smsc-username = 'smppclient'
#smsc-password = password
#system-type = 'VMA'
#service-type = 'test'
#interface-version = 34
#address-range = ''
#msg-id-type = 0
group = smsc
smsc = fake
smsc-id = test
port = 13005
#allowed-prefix = 07
log-file = "/var/log/kannel/fake.log"
log-level = 0
#connect-allow-ip = 127.0.0.1
group = smsbox
bearerbox-host = localhost
sendsms-port = 13013
global-sender = 59898
mo-recode=true
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
access-log = "/var/log/kannel/access.log"
group = sendsms-user
username = kiran
password = kiran
default-smsc = test
concatenation= true
max-messages = 3
forced-smsc = "test"
# SMS SERVICE 'default'
group = sms-service
keyword = nop
text = "You asked nothing and I did it!"
catch-all = true # Catch all incoming messages
# regarding the keyword. If you
# define other services, remove
# this line.
# SMS SERVICE for receiving sms messages
# If you're about to implement service to receive sms messages.
# group = sms-service
# keyword = yourkeyword
# get-url =
http://server.domain/moodle/receivesms.php?q=%k&sender=%p&message=%a
_*Send SMS URL
*_http://192.168.1.93:13013/cgi-bin/sendsms?username=kiran&password=kiran&to=919036971573&text=This+is+testfor
priority and message response&dlr-mask=31&priority=3
<http://192.168.1.93:13013/cgi-bin/sendsms?username=kiran&password=kiran&to=919036971573&text=This+msg+is+sent+from+saga%27s+computer+with+kannel+please+reply+back+if+u+received+it&dlr-mask=31>
above url is correct or not
<http://192.168.1.93:13013/cgi-bin/sendsms?username=kiran&password=kiran&to=919036971573&text=This+msg+is+sent+from+saga%27s+computer+with+kannel+please+reply+back+if+u+received+it&dlr-mask=31>
**
*
Warm Regards,
Kiran Reddy
MPOWER
91-9036971573
P Please consider the environment before printing this email.
Visit us at: www.mpowerglobal.in <http://www.mpowerglobal.in/>
*
Jovan Kostovski wrote:
On Wed, Dec 30, 2009 at 9:56 AM, kiran.re...@mpowerglobal.in
<kiran.re...@mpowerglobal.in> wrote:
Hi All,
The mysql database structure for storing kannel response from SMPP ?
What kind of response? SMS? DLR?
What kind of data do you need to store in the database?
BR, Jovan
