I am having trouble with delivery reports not being inserted into the
database. It seems that no one else has had this problem before, at
least not that I could find. The following appears in the log.
2007-08-21 17:15:23 [1225] [6] DEBUG: DLR[mysql]: Adding DLR smsc=test,
ts=79F69324, src=13013, dst=61425237321, mask=31, boxc=
2007-08-21 17:15:23 [1225] [6] DEBUG: sql: INSERT INTO KannelIn (smsc,
timestamp, source, destination, service, url, mask, boxc, status) VALUES
('test', '79F69324', '13013', '61425237321', 'test',
'http://localhost/system/dlr.php?smsID=40475&smscID=%i&dlr=%d&answer=%A&to=%p&from=%P&ts=%T&charset=%C&kannel_id=%I&msg=%a&bmsg=%b',
'31', '', '0');
2007-08-21 17:15:23 [1225] [6] ERROR: MYSQL: Unknown column 'service' in
'field list'
I can copy that query and run it successfully so the error return by
mysql makes no sense at all.
This is the relevant section in kannel.conf
group = dlr-db
id = mydlr
table = KannelIn
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
System and kannel info:
Kannel bearerbox version `cvs-20070803'.
Kannel smsbox version `cvs-20070803'.
Build `Aug 17 2007 12:03:33', compiler `4.1.2 20070502 (Red Hat 4.1.2-12)'.
System Linux, release 2.6.20-2925.13.fc7xen, version #1 SMP Tue Jul 17
10:38:27 EDT 2007, machine i686.
Hostname testbox, IP 127.0.0.1.
Libxml version 2.6.29.
Using OpenSSL 0.9.8b 04 May 2006.
Compiled with MySQL 5.0.37, using MySQL 5.0.37.
Using native malloc.
Any help or ideas would be much appreciated.
