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