Got a strange problem on my hands that I can't seem to figure out... I've
got mysql and would like to store any messages coming in our out in my
database, the database is set up with:
#CREATE TABLE SmsEvent (
#smsc VARCHAR(255),
#ts VARCHAR(255),
#destination VARCHAR(255),
#service VARCHAR(255),
#url VARCHAR(255),
#mask VARCHAR(255),
#status VARCHAR(255),
#boxc VARCHAR(255),
#source VARCHAR(255),
#PRIMARY KEY(smsc) )
#;
However when I check the actual database after sending/recieving messages
there is nothing in it....
The status of the boxes looks like this:
Kannel bearerbox version `cvs-20031101'. System Linux, release
2.4.20-gentoo-r6, version #1 Fri Sep 26 23:43:56 BST 2003, machine i686.
Hostname jarlco, IP 192.168.0.10. Libxml version 20508. Using OpenSSL 0.9.6k
30 Sep 2003. Using MySQL 4.0.14. Using native malloc.
Status: running, uptime 0d 0h 22m 7s
WDP: received 0 (0 queued), sent 0 (0 queued)
SMS: received 0 (0 queued), sent 3 (0 queued), store size 0
SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec
DLR: 0 queued, using mysql storage
Box connections:
smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 14m 6s)
SMSC connections:
wavecom_1 AT2[wavecom_1] (online 1327s, rcvd 0, sent 3, failed 0,
queued 0 msgs)
and my config file looks like this:
------------------------------------------
group = core
admin-port = 13000
admin-password = bar
smsbox-port = 13001
store-file = "/tmp/kannel.store"
log-level = 2
log-file = "/tmp/kannel.log"
access-log = /tmp/kannel.access
dlr-storage = mysql
# SMSC CONNECTIONS
group = smsc
smsc = at
smsc-id = wavecom_1
allowed-smsc-id = wavecom_1
modemtype = wavecom
device = /dev/ttyS0
speed = 9600
# MODEM GROUP
group = modems
id = wavecom
name = Wavecom
detect-string = "WAVECOM"
# SMSBOX SETUP
group = smsbox
bearerbox-host = localhost
sendsms-port = 13013
sendsms-url = "/cgi-bin/sendsms"
sendota-url = "/cgi-bin/sendota"
sendsms-chars = "0123456789 +-"
global-sender = 079
reply-couldnotfetch = "Sorry, service was unable to fetch content..."
reply-couldnotrepresent = "Sorry, real message could not be represented as
SMS"
reply-requestfailed = "Sorry, the request failed"
reply-emptymessage = "Empty SMS was recieved"
log-file = "/tmp/smsbox.log"
access-log = "/tmp/kannel.access"
log-level = 3
# SEND SMS USER CONFIG
group = sendsms-user
username = jarl
password = cornell
group = sendsms-user
username = tester
password = foobar
# SMS SERVICE
group = sms-service
keyword = xxx
aliases = "af;ta;argh;tsk"
name = test1
header = Jarl's SMS Service
footer = J.C
text = xxx service
group = sms-service
keyword = www
get-url = "http://%S";
group = sms-service
keyword = vote
text = "Thank you for your vote it will now be processed"
group = sms-service
keyword = nop
text = "service"
# DEFAULT SERVICE
group = sms-service
keyword = default
text = "default"
# MYSQL CONFIGURATION
group = mysql-connection
id = mydlr1
host = localhost
mysql-username = jarl
mysql-password = xxx
database = kannel
# STORAGE GROUP
group = dlr-db
id = mydlr1
table = SmsEvent
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
field-source = source
Cheers a lot for any help in this matter, I'm sure i'm just not
understanding this properly, which is why I'm hoping someone here will
maybe..
/Jarl
