[Devel] openserctl adding a new domain

Daniel-Constantin Mierla daniel at voice-system.ro
Wed Nov 2 21:11:09 CET 2005


Hello,

On 11/02/05 19:35, Klaus Darilion wrote:
> Norman Brandinger wrote:
>> 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
>
> does this work with both, mysql and postgres?
if does not work for bot, maybe we can use the 'date' command from the 
system. At least for dbtext, this should be the solution.

Cheers,
Daniel
>
> regards
> klaus
>
>>
>> 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
>>
>>
>>
>>
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>
>>
>
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>



More information about the Devel mailing list