>
><CFEXECUTE NAME="/home/postgres/nsvm_backupdb"
> OUTPUTFILE="#dirExport#dblog_#iNewId#.txt"
> TIMEOUT="0">
Siew,
I'm presuming the nsvm_backupdb script works fine when executed manually
from the command line and that your problem lies within the cfexecute
implementation.
First, check that the user cfmx runs under has permissions to execute
nsvm_backupdb (a quick hack for testing purposes would be to chmod 777 the
script).
Also, though I'm not entirely sure if this following logic applies to the
OUTPUTFILE directove, however I have found that kind of string concatenation
doesn't work within the ARGUMENTS directive of cfexecute. The workaround
I've used in such situations is to declare the concatenated string as a
variable immediately before the cfexecute call and use the variable therein.
So, in your case I would try:
<cfset outputfile = "#dirExport#dblog_#iNewId#.txt">
<CFEXECUTE NAME="/home/postgres/nsvm_backupdb" OUTPUTFILE="#outputfile#"
TIMEOUT="0">
I would also try increasing the timeout value, however in most cases,
problems with cfexecute are attributable to permissions on the executable
itself. This is usually particularly difficult to determine as it tends to
not show up in the logs.
HTH,
Dave
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
