Two (possible) bugs with 1.4.0

"Johann du Preez" <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <000b01c509bd$92e1aee0$bf00a8c0@Pinotage>
Hi,

I installed Kannel 1.4.0 on a Fedora core 2 box and it is working fine. 
Thanks for all your efforts.

However, I discovered the following two things which I think may be bugs:

1.  I use postgresql (v 7.4.6) for dlr-storage, as can be seen from my 
config file below.  However, I get the following error when it seems that 
Kannel wants to delete the entries from the database:

2005-02-01 07:41:08 [1628] [6] ERROR: PGSQL: DELETE FROM dlr WHERE 
smsc='vodacom' AND ts='01/00/213d14b8/1127828553923' LIMIT 1;
2005-02-01 07:41:08 [1628] [6] ERROR: PGSQL: ERROR:  syntax error at or near 
"LIMIT" at character 76
2005-02-01 07:41:08 [1628] [6] ERROR: PGSQL: DB update failed!


2.  I cannot, for the life of me, get aliases to work for sms-services. 
None of the aliases for any of the services specified below works.

Thanks again for a great piece of software.

Johann

kannel.conf
========

group = core
admin-port = 13000
admin-password = xxxx
log-file = "/var/log/kannel/bearerbox.log"
log-level = 1
access-log = "/var/log/kannel/beareraccess.log"
smsbox-port = 13001
dlr-storage = pgsql

# SMSC SMPP
group = smsc
smsc = smpp
smsc-id = vodacom
host = xxxx
port = 1060
receive-port = 1060
smsc-username = xxxx
smsc-password = xxxx
system-type = "CMT"
transceiver-mode = 1
source-addr-ton = 1
dest-addr-ton = 1
throughput = 5
source-addr-autodetect = no

# SMSBOX SETUP

group = smsbox
bearerbox-host = localhost
sendsms-port = 13013
global-sender = xxxxxxx
log-file = "/var/log/kannel/smsbox.log"
log-level = 1
access-log = "/var/log/kannel/smsaccess.log"

# SEND-SMS USERS

group = sendsms-user
username = xxxxxx
password = xxxxxxxxx
dlr-url = 
"http://localhost/dlr/?msisdn=%p&msg=%a&smscid=%i&smsid=%I&dlrtype=%d&dlrsmsc=%A&time=%t"

# SMS SERVICES

group = sms-service
name = sdt
keyword = sdt
aliases = shinfo;sharedata
url = "http://22.22.22.22/jse/scripts/sd.asp?ticker=%s"
catch-all = true
omit-empty = true


group = sms-service
name = slots
keyword = slots
aliases = spin;play
url = "http://localhost:8080/play?cell=%p"
catch-all = true
omit-empty = true


#A simple test service
group = sms-service
name = nop
keyword = nop
text = "You asked nothing and I did it!"

# SMS SERVICE Default
# there should be default always
group = sms-service
keyword = default
text = "No service specified.  Please try again."



group = pgsql-connection
id = mydlr
host = localhost
username = xxxxxx
password = xxxxxx
database = kannel
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.