Hi Checking at my mysql dlrs, I found that field timestamp (TS) on my kannel_dlr table is always empty.
changing the kannel log to debug shows me that kannel is trying to update the timestamp field with the response of the AT+CSMG. I also discovered that this value loops from 0 to 255. Why is kannel using this value instead of the real time stamp?? I'm using Mysql server version 5.0.27, client version 5.0.27. under fedora 6 and Kannel bearerbox II version cvs-20070614 Regards Alvaro 2007-10-31 17:59:46 [3013] [6] DEBUG: AT2[tc]: TP-Validity-Period: 24.0 hours 2007-10-31 17:59:46 [3013] [6] DEBUG: AT2[tc]: --> AT+CMGS=147^M 2007-10-31 17:59:46 [3013] [6] DEBUG: AT2[tc]: <-- > 2007-10-31 17:59:46 [3013] [6] DEBUG: AT2[tc]: send command status: 1 2007-10-31 17:59:46 [3013] [6] DEBUG: AT2[tc]: --> 0031000C912568987034590012A798D33A682C2F93D3F437089D86BFE9E571589E7E83E8E9B2BB0C0AD3E5E1F91B442E8366A076D93DAF87D96972985C9E83EC65F7384D0ECF41F0B03C0C2297E96577590E2AB34170F97B5C9EBF41EABA3C4D4E8FDF2090396C7FCB41E432485E0EB3D3FAB01C34AF83E0E1F31BF406B1D9E17658EE7ECF4161360816C3C1603199CC669BC940 2007-10-31 17:59:46 [3013] [6] DEBUG: AT2[tc]: --> ^Z 2007-10-31 17:59:52 [3013] [6] DEBUG: AT2[tc]: <-- > 2007-10-31 17:59:52 [3013] [6] DEBUG: AT2[tc]: <-- +CMGS: 119 2007-10-31 17:59:52 [3013] [6] DEBUG: AT2[tc]: <-- OK 2007-10-31 17:59:52 [3013] [6] DEBUG: AT2[tc]: send command status: 0 2007-10-31 17:59:52 [3013] [6] DEBUG: DLR[mysql]: Adding DLR smsc=tc, ts=119, src=+52 55 1473-1839, dst=+528689074395, mask=31, boxc= 2007-10-31 17:59:52 [3013] [6] DEBUG: sql: INSERT INTO tblkannel_dlr (smsc, ts, source, destination, service, url, mask, boxc, status) VALUES ('tc', '119', '+52 55 1473-1839', '+528689074395', 'playsms', 'http://127.0.0.1/sms/plugin/gateway/kannel/dlr.php?type=%d&slid=3678&uid=98&smsc_id=tc&inc_smsc=tc', '31', '', '0'); 2007-10-31 17:59:52 [3013] [6] DEBUG: SMSC[tc]: creating DLR message 2007-10-31 17:59:52 [3013] [6] DEBUG: SMSC[tc]: DLR = http://127.0.0.1/sms/plugin/gateway/kannel/dlr.php?type=%d&slid=3678&uid=98&smsc_id=tc&inc_smsc=tc #### CONEXION A MYSQL LOCALHOST group = mysql-connection id = mydlr host = localhost username = user password = pass database = kannel_dlr max-connections = 5 #### DLR DB DEFINITION group = dlr-db id = mydlr table = tblkannel_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