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
