[Devel] openserctl adding a new domain
Norman Brandinger
norm at goes.com
Wed Nov 2 18:19:28 CET 2005
Tried to post this to the sourceforge site but it's down.
When adding a new domain using /usr/local/sbin/openserctl, the
last_modified column isn't populated.
Changing the query as shown below for the "domain add" function within
openserctl resolved this problem
QUERY="insert into $DOMAIN_TABLE (domain, last_modified) VALUES ('$1',
now());"
An alternate solution might be to update the database definition for
domain.last_modified as follows:
ALTER TABLE `domain` CHANGE `last_modified` `last_modified` TIMESTAMP
NOT NULL DEFAULT CURRENT_TIMESTAMP
Each solution solves the problem and offers different benefits in terms
of user control and simplicity of programming. I feel that one of the
above should be implemented.
Regards,
Norm
More information about the Devel
mailing list