Hi I've setup my kannel to use mysql as its dlr database.
Everithing looks OK except that the timestamp on the dlr is allways 0000-00-00 00:00:00. I've chequed that field "field-timestamp" is a timestamp field, I've also manually inserted a test dlr into the table and it worked fine.. I'm running latest CVS under fedora 5. Here is my kannel cfg: #CORE BEARERBOX group = core admin-port = 13000 smsbox-port = 13001 dlr-storage = mysql admin-password = bar # box-deny-ip = "*.*.*.*" box-allow-ip = "*.*.*.*" log-file = "/var/log/kannel/bearerbox.log" log-level = 0 access-log = "/var/log/kannel/beareraccess.log" # LOG LEVEL 0 = DEBUG, 4 = INFO # SMSBOX SETUP # group = smsbox bearerbox-host = 127.0.0.1 sendsms-chars = "0123456789 +" sendsms-port = 13013 smsbox-id = "smsl" global-sender = Sms log-file = "/var/log/kannel/smsbox.log" log-level = 0 access-log = "/var/log/kannel/smsaccess.log" http-request-retry = 3 http-queue-delay = 10 #### CONEXION A MYSQL LOCALHOST group = mysql-connection id = mydlr host = 127.0.0.1 username = mysqluser password = mysqlpass database = kannel_dlr max-connections = 2 #### 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 any ideas??
