Hi All
I am struggling to get dlr's to work properly with the sms box
configuration. I write the record to the send_sms table with the dlr-mask
and dlr-url populated. I encoded the dlr-url as the explained in the manual.
Not sure if this helps but the following error gets logged to the
kannel-sqlbox.log
2009-07-12 00:39:47 [28684] [2] ERROR: MYSQL: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ''id:1241145349 sub:001 dlvrd:001 submit
date:1207090049 done date:1207090049 sta' at line 1
My kannel status page shows many messages in the que as well which i presume
is the dlrs:
Box connections:
smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 1h 54m 4s)
smsbox:sqlbox, IP 127.0.0.1 (33 queued), (on-line 0d 1h 53m 55s)
Please help
Thanks
Samir
