[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