Hi Alvaro,
Please make sure that the standard value for your timestamp field is
CURRENT_TIMSTAMP, like this:
`timeid` timestamp NOT NULL default CURRENT_TIMESTAMP
Then it will always insert the current timestamp, if nothing is specified.
......................................
Med venlig hilsen / Best Regards
*Mads N. Vestergaard*
*Teknisk ansvarlig / CTO CoolSMS*
www.coolsms.com <http://www.coolsms.com/>
Phone: +45 7026 1272
Fax: +45 7630 1046
Mobile: +45 5050 4222
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager. This message contains confidential information and is
intended only for the individual named. If you are not the named
addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system. If you are
not the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
information is strictly prohibited.
Alvaro Cornejo skrev:
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??
