Re: CF8 cfexecute Problem
Hmmm... This runs via cfhttp url=http://www.myserverdev.com/ipi_grabber/get.cfm?w=#xWaitDocTime#s=#lcase(attributes.website)# result=grabResult /. So the caller is on a different server than the webshot program. The caller of the CF program is really irrelevant here. It's the user account used to run the CF program that matters. Wherever get.cfm is, that's the user account you're worried about. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
That worked! Thank you so much! Is it because both the program Webshot and ColdFusion were installed under my user account? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Running systeminfo with CFEXECUTE returns an empty string. Why?
Any ideas what I'm doing wrong? Here's my code: cfexecute name=c:\windows\system32\systeminfo.exe arguments=/FO CSV variable=data timeout=10 / cfdump var=#data# I've also tried running it without the arguments (see below). Both the code above and the code below return an empty string: cfexecute name=c:\windows\system32\systeminfo.exe variable=data timeout=10 / cfdump var=#data# Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
That worked! Thank you so much! Is it because both the program Webshot and ColdFusion were installed under my user account? It's possible, but it's also possible that it was something not quite the same, but somewhat similar. I realize that's not a very satisfactory explanation, but I'd need to see more to be sure of the exact cause. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Running systeminfo with CFEXECUTE returns an empty string. Why?
Logon to the CF server using the name of the user that CF was installed with and try running systeminfo.exe using a CMD prompt. My guess is that it is using a user that doesn't have permission to run that process, as I tried the second command you provided, and it worked just fine... -Original Message- From: Scott Niven [mailto:scott_ni...@ncsu.edu] Sent: Wednesday, August 03, 2011 11:39 AM To: cf-talk Subject: Running systeminfo with CFEXECUTE returns an empty string. Why? Any ideas what I'm doing wrong? Here's my code: cfexecute name=c:\windows\system32\systeminfo.exe arguments=/FO CSV variable=data timeout=10 / cfdump var=#data# I've also tried running it without the arguments (see below). Both the code above and the code below return an empty string: cfexecute name=c:\windows\system32\systeminfo.exe variable=data timeout=10 / cfdump var=#data# Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 cfexecute Problem
I can run a screen capture program executable from a Windows Server 2008 (32bit) cmd line and it captures a flash website fine. However, when I try this from cfexecute, it says no flash player is installed. Latest Flash Player has been installed for IE 8 32 bit. Please advise. Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
I can run a screen capture program executable from a Windows Server 2008 (32bit) cmd line and it captures a flash website fine. However, when I try this from cfexecute, it says no flash player is installed. Latest Flash Player has been installed for IE 8 32 bit. Please advise. Thanks. Try logging in as the user that runs CF, and running the screen capture program. If you're running CF as SYSTEM rather than a specific user, you'll probably have to change that to a specific user account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
I can run a screen capture program executable from a Windows Server 2008 (32bit) cmd line and it captures a flash website fine. However, when I try this from cfexecute, it says no flash player is installed. Latest Flash Player has been installed for IE 8 32 bit. Please advise. Thanks. Try logging in as the user that runs CF, and running the screen capture program. If you're running CF as SYSTEM rather than a specific user, you'll probably have to change that to a specific user account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
Hmmm... This runs via cfhttp url=http://www.myserverdev.com/ipi_grabber/get.cfm?w=#xWaitDocTime#s=#lcase(attributes.website)# result=grabResult /. So the caller is on a different server than the webshot program. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFexecute and licenses
Ok, we have a program that we are running using cfexecute. It requires the license for that program to be placed in the folder that holds the program that calls it. Right now, the program doesn't run since cfexecute is the calling program. In this case, thus I assume I'll need to place the program's license file somewhere in a coldfusion folder. So, where do I put it? CFIDE? Jrun? Thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFexecute and licenses
Ok, we have a program that we are running using cfexecute. It requires the license for that program to be placed in the folder that holds the program that calls it. Right now, the program doesn't run since cfexecute is the calling program. In this case, thus I assume I'll need to place the program's license file somewhere in a coldfusion folder. So, where do I put it? CFIDE? Jrun? You could call cmd.exe and pass this program as an argument to it, then put the license in your system folder. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFexecute and licenses
Ok, we have a program that we are running using cfexecute. It requires the license for that program to be placed in the folder that holds the program that calls it. Right now, the program doesn't run since cfexecute is the calling program. In this case, thus I assume I'll need to place the program's license file somewhere in a coldfusion folder. So, where do I put it? CFIDE? Jrun? You could call cmd.exe and pass this program as an argument to it, then put the license in your system folder. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFexecute and licenses
The program is a batch screen capture program. Got the cfexecute to work by putting the license in the jrun folder. So that worked! But now it fails to load the flash plug-in that accompanies IE 8. It works like a charm if run by clicking on a batch file that resides in the folder that has the exe. How to get it to capture a flash website is my next challenge. Any insight to that would be greatly appreciated. Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 cfexecute issues.
Hi, Michael... Have you eliminated the possibility that some of the files you working with on this run through are causing problems? Did you run these files through CF8 to see if they work there? I haven't worked with converting images avi mpg, so I have no experience with the process, but thought it could perhaps be a corrupt source file causing a problem. Rick -Original Message- From: Michael Reick [mailto:mich...@widgethq.com] Sent: Monday, April 04, 2011 1:45 AM To: cf-talk Subject: CF9 cfexecute issues. Let me just say I hate CF9 so far. I just upgraded from CF7 and it's been an absolute nightmare. The current nightmare I'm dealing with is a template that will not return or timeout. I've got a global timeout set in the admin. I've tried setting a page timeout with cfsetting requesttimeout. On the template itself, I've got a bunch of cfexecutes doing command line batch processing. Roughly 30 doing imageMagick image manipulations (which I could probably combine into one batch file, now that I think about it.) And two problem children. One that runs a batch file that converts the images into an .avi file. This one takes awhile, about 9 minutes. And a second batch file that runs ffmpeg to add an mp3 file and convert that avi into an mpg. I've tried putting timeouts on the cfexecutes for the last two and nothing. The page never returns. The thread shows up in Server Monitor, and goes away 10 minutes or so later, but the page just hangs. I've even tried putting a cfabort after the last cfexecute, but nothing. The log file just shows the steps in the batch file, which is simply migrating to the directory and calling the .vbs file, or ffmpeg on the appropriate files. When I run the bat files on the server logging in with the same account as CF runs under, the command prompt pops up for the appropriate amount of time, then goes away. cfexecute name=c:\windows\system32\cmd timeout=600 arguments=/c #pathToBatFile#createAVI.bat outputFile=c:\logs\createAVI#IDField#.txt / Once I get it running correctly, I'll probably move it to another server and schedule it, but I need it working correctly first. Any ideas? I'm going nuts here. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 cfexecute issues.
are the batch files actually being executed and doing their job? Are any errors occurring in the batch file ? you need to do some tests to determine what is causing the problem. Make a simple batch file that does something basic like an echo command or somehting, and see if that works, If not, then it would tell you that executing batch file sis the problem or cfexecute itself. If it does work, then try doing the original image manipulation but just 1 image and see if that works. Then work forward from here, if 1 image works, then increase the iterations of images processed until you get the problem, and then check if it was just perhaps that image causing a problem, or does it seem related to number of iterations, oer perhaps it could be the time it takes to execute, If you gradually exclude all the possible causes, you should be left with the prime suspect. On Mon, Apr 4, 2011 at 2:30 PM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, Michael... Have you eliminated the possibility that some of the files you working with on this run through are causing problems? Did you run these files through CF8 to see if they work there? I haven't worked with converting images avi mpg, so I have no experience with the process, but thought it could perhaps be a corrupt source file causing a problem. Rick -Original Message- From: Michael Reick [mailto:mich...@widgethq.com] Sent: Monday, April 04, 2011 1:45 AM To: cf-talk Subject: CF9 cfexecute issues. Let me just say I hate CF9 so far. I just upgraded from CF7 and it's been an absolute nightmare. The current nightmare I'm dealing with is a template that will not return or timeout. I've got a global timeout set in the admin. I've tried setting a page timeout with cfsetting requesttimeout. On the template itself, I've got a bunch of cfexecutes doing command line batch processing. Roughly 30 doing imageMagick image manipulations (which I could probably combine into one batch file, now that I think about it.) And two problem children. One that runs a batch file that converts the images into an .avi file. This one takes awhile, about 9 minutes. And a second batch file that runs ffmpeg to add an mp3 file and convert that avi into an mpg. I've tried putting timeouts on the cfexecutes for the last two and nothing. The page never returns. The thread shows up in Server Monitor, and goes away 10 minutes or so later, but the page just hangs. I've even tried putting a cfabort after the last cfexecute, but nothing. The log file just shows the steps in the batch file, which is simply migrating to the directory and calling the .vbs file, or ffmpeg on the appropriate files. When I run the bat files on the server logging in with the same account as CF runs under, the command prompt pops up for the appropriate amount of time, then goes away. cfexecute name=c:\windows\system32\cmd timeout=600 arguments=/c #pathToBatFile#createAVI.bat outputFile=c:\logs\createAVI#IDField#.txt / Once I get it running correctly, I'll probably move it to another server and schedule it, but I need it working correctly first. Any ideas? I'm going nuts here. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 cfexecute issues.
Let me just say I hate CF9 so far. I just upgraded from CF7 and it's been an absolute nightmare. The current nightmare I'm dealing with is a template that will not return or timeout. I've got a global timeout set in the admin. I've tried setting a page timeout with cfsetting requesttimeout. On the template itself, I've got a bunch of cfexecutes doing command line batch processing. Roughly 30 doing imageMagick image manipulations (which I could probably combine into one batch file, now that I think about it.) And two problem children. One that runs a batch file that converts the images into an .avi file. This one takes awhile, about 9 minutes. And a second batch file that runs ffmpeg to add an mp3 file and convert that avi into an mpg. I've tried putting timeouts on the cfexecutes for the last two and nothing. The page never returns. The thread shows up in Server Monitor, and goes away 10 minutes or so later, but the page just hangs. I've even tried putting a cfabort after the last cfexecute, but nothing. The log file just shows the steps in the batch file, which is simply migrating to the directory and calling the .vbs file, or ffmpeg on the appropriate files. When I run the bat files on the server logging in with the same account as CF runs under, the command prompt pops up for the appropriate amount of time, then goes away. cfexecute name=c:\windows\system32\cmd timeout=600 arguments=/c #pathToBatFile#createAVI.bat outputFile=c:\logs\createAVI#IDField#.txt / Once I get it running correctly, I'll probably move it to another server and schedule it, but I need it working correctly first. Any ideas? I'm going nuts here. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFEXECUTE output Access Report
Im stuck here, and after all my years as a programmer, never have I been faced with this and on a shirt deadline. There is a pretty complex MS Access report that takes in an ID and outputs a report, how the heck can I get this to run online??? Im poking through cfexecute but no luck yet. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why, oh why won't my batch file run via cfexecute?
Run ProcMon while making the request. http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx If all else fails, it may be worth trying the System Command contribution on Ria. http://systemcommand.riaforge.org/ That way you can get the error returned to the output. http://systemcommand.riaforge.org/ -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why, oh why won't my batch file run via cfexecute?
Before having a chance to run with ProcMon, I reinstalled CF9 tested the bat file without success, decided to change the logon account setting to Interact with Desktop (or whatever it says), as I remember having an issue with that...but I think that was when I was trying to use a third party FTP program instead of cfftp to download files. I did see something on the sitepoint.com forums about port conflicts between CF9 and CFB, but I'm not using CFB...and I couldn't find any port settings in the jvm.config file which the author in the forum said he modified to resolve the conflict. (I couldn't even *find* the jvm.config file...) I did check the cf server log and notice a null reference error. The only thing I'm doing differently with the installation (since I started this past weekend with the install of CF9) is to use a .car file to import my settings form CF8. I did notice in the server log a reference to the .car file deployment, so I'm reinstalling CF9 without using the .car file to see if that keeps CF9 running. -Original Message- From: Matthew Small [mailto:chestypul...@beachbum.net] Sent: Tuesday, March 02, 2010 11:36 AM To: cf-talk Subject: Re: Why, oh why won't my batch file run via cfexecute? Run ProcMon while making the request. http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx If all else fails, it may be worth trying the System Command contribution on Ria. http://systemcommand.riaforge.org/ That way you can get the error returned to the output. http://systemcommand.riaforge.org/ -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why, oh why won't my batch file run via cfexecute?
Well, it turns out that the problem (up to this point) was the
account that the CF service was running under. It was on the default
Local Account. I changed that to allow Interact with Desktop, but that
wasn't enough. I then changed to the service to run under my personal
user account and that seems to have done the trick.
At least I have been able to use cfexecute to successfully run a couple
of .bat files.
It seems, as someone mentioned earlier, that the pickiness of Windows 7
concerning the path capitalization wasn't a problem in this case.
I have the drive letter in the cfexecute tag in lower case. I also
have all lower case in the .bat file executable path...and there are about
10 capital letter typically in that path. I didn't get any error about
volume label, or syntax problems...
So, it turns out that the account under which the CF service is running
is critical for executing .bat files involving local software.
Thanks to everyone for your help and input!
Rick
-Original Message-
From: Judah McAuley [mailto:ju...@wiredotter.com]
Sent: Tuesday, March 02, 2010 1:06 AM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
The next two things I would try are to execute a .bat file using
cfexecute in another directory to see if CF is just having problems
with cfexecute, period, and if you are able to run a bat file that
does something like del myfile.txt, try putting the bat file you
really want to execute in that directory.
It seems to me that the most likely scenarios are some combination of:
CF can't execute a bat file in that directory because it doesn't have
permission
CF really can't see that directory for some reason but it could
execute that file in another directory
CF is borked somehow and can't use cfexecute properly
Also, a note on your testing about running the .bat file from a cmd
window. CF is normally installed as a service running as System. There
are restrictions on that setup that aren't immediately obvious, like
not being able to interact with the Desktop (I believe) and doing
things over the network. You also have the option of running the
service as a named system account which would give CF more explicit
permissions as a real user. Those permissions are not necessarily
greater but they are more obvious and explicit. What is CF running as
on your box?
Judah
On Mon, Mar 1, 2010 at 9:54 PM, Rick Faircloth r...@whitestonemedia.com
wrote:
I did try running the batch file from an elevated cmd window.
I ran cmd by typing cmd in the start field and using ctrl-shift-enter.
When I ran the batch file that way, it worked...at least from the
command prompt.
I also ran the batch file from a non-elevated cmd window, and
it worked fine, too.
All bat files are on a local drive.
I tested one of the other bat files in the same directory and
still got the error message:
The filename, directory name, or volume label syntax is incorrect.
???
-Original Message-
From: Judah McAuley [mailto:ju...@wiredotter.com]
Sent: Tuesday, March 02, 2010 12:30 AM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
Was this working on Win 7 before or was it on a previous version of
Windows, say XP? Because Windows 7 has permissions locked down much
more tightly than XP did and I've seen issues reported as can't find
something when it really means I'm not allowed to look at it.
Also, can you get any .bat files to run from cfexecute or is it only
this bat file? Is this bat file on a local drive or a maped/unc drive?
Judah
On Mon, Mar 1, 2010 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com
wrote:
Thanks for the tip, Dave, but it didn't help...
I tried:
cfexecute name = c:\windows\system32\cmd.exe
arguments = /c
/#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
timeout = 100
errorVariable = errorVariable /
And, I tried leaving off the /c in the arguments...that didn't help.
I also tried hard coding the .bat path...no good.
At least now I'm getting a different error, but can't figure out
what to change to make things work:
errorVariable returns as The filename, directory name, or volume label
syntax is incorrect.
I can't figure out what that error is referencing.
Did I use cmd.exe properly?
Are the arguments set up properly?
I tried every variation I could think of.
Rick
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, March 01, 2010 11:03 PM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
What happens if you run cmd.exe using your batch file
Re: Why, oh why won't my batch file run via cfexecute?
Before having a chance to run with ProcMon, I reinstalled CF9 tested the bat file without success, decided to change the logon account setting to Interact with Desktop (or whatever it says), as I remember having an issue with that...but I think that was when I was trying to use a third party FTP program instead of cfftp to download files. That's not needed to run batch files. I did see something on the sitepoint.com forums about port conflicts between CF9 and CFB, but I'm not using CFB...and I couldn't find any port settings in the jvm.config file which the author in the forum said he modified to resolve the conflict. (I couldn't even *find* the jvm.config file...) You should always be able to find your jvm.config file, or any other file when you know the name of the file. To find it, you simply open a command prompt, navigate to the directory or drive where you know the file is located, and type: dir jvm.config /s This will recurse through subdirectories. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why, oh why won't my batch file run via cfexecute?
So, it turns out that the account under which the CF service is running is critical for executing .bat files involving local software. Service accounts may often have trouble running things that you can run under your own account. This could be caused by permissions or different environment variables. If you want to run CF as something other than your own user account, you could create an account, log into Windows with that account, and see if it can run your program. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why, oh why won't my batch file run via cfexecute?
Thanks for the help and tips, Dave! It would be nice to know for *certain* what the issue was. I'm still not sure what was causing CF9 to go offline and then refuse to restart after attempting to run some of the .bat files. I'm not even sure that was the problem. With this last install of CF9, I didn't use my .car files for settings and that seems to have left CF9 in a more stable state. That was my first attempt to use a .car file...and probably my last based on current experience. Thanks, again! Rick -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, March 02, 2010 4:33 PM To: cf-talk Subject: Re: Why, oh why won't my batch file run via cfexecute? So, it turns out that the account under which the CF service is running is critical for executing .bat files involving local software. Service accounts may often have trouble running things that you can run under your own account. This could be caused by permissions or different environment variables. If you want to run CF as something other than your own user account, you could create an account, log into Windows with that account, and see if it can run your program. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Why, oh why won't my batch file run via cfexecute?
Hi, all.
I've been running batch files with cfexecute on CF 8 for a couple
of years now.
I just reformatted my computer and installed Win7 32-bit and CF 9 on a
machine that exists just to process data.
Like a dummy, I didn't back up my data import profiles in Navicat,
the software I use to manage MySQL.
The batch files look like this one, which is load_hmls_active_photos.bat :
c:\program files\premiumsoft\navicat mysql\navicat.exe /import wsm-2
real_estate_data load_hmls_active_photos
The path to the executable above is correct. The line above is the same as
it was before the rebuild of my system.
(I had that saved.)
And the problem is not with the load_hmls_active_photos import profile in
Navicat.I can run it manually
and it loads the data from a text file into the database with problem.
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
.I don't get any errors that I can tell, even when I use the above cfexecute
code
by itself and use errorVariable. errorVariable is blank when the code is
run.but not data
is loaded into the database table specified in the Navicat import profile.
I've also verified that the path is correct when fully expanded.
Suggestions, anyone?
Thanks,
Rick
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331233
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why, oh why won't my batch file run via cfexecute?
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
What happens if you run cmd.exe using your batch file as an argument?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331235
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why, oh why won't my batch file run via cfexecute?
Thanks for the tip, Dave, but it didn't help...
I tried:
cfexecute name = c:\windows\system32\cmd.exe
arguments = /c
/#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
timeout= 100
errorVariable = errorVariable /
And, I tried leaving off the /c in the arguments...that didn't help.
I also tried hard coding the .bat path...no good.
At least now I'm getting a different error, but can't figure out
what to change to make things work:
errorVariable returns as The filename, directory name, or volume label
syntax is incorrect.
I can't figure out what that error is referencing.
Did I use cmd.exe properly?
Are the arguments set up properly?
I tried every variation I could think of.
Rick
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, March 01, 2010 11:03 PM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
What happens if you run cmd.exe using your batch file as an argument?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331236
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why, oh why won't my batch file run via cfexecute?
Was this working on Win 7 before or was it on a previous version of
Windows, say XP? Because Windows 7 has permissions locked down much
more tightly than XP did and I've seen issues reported as can't find
something when it really means I'm not allowed to look at it.
Also, can you get any .bat files to run from cfexecute or is it only
this bat file? Is this bat file on a local drive or a maped/unc drive?
Judah
On Mon, Mar 1, 2010 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com wrote:
Thanks for the tip, Dave, but it didn't help...
I tried:
cfexecute name = c:\windows\system32\cmd.exe
arguments = /c
/#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
timeout = 100
errorVariable = errorVariable /
And, I tried leaving off the /c in the arguments...that didn't help.
I also tried hard coding the .bat path...no good.
At least now I'm getting a different error, but can't figure out
what to change to make things work:
errorVariable returns as The filename, directory name, or volume label
syntax is incorrect.
I can't figure out what that error is referencing.
Did I use cmd.exe properly?
Are the arguments set up properly?
I tried every variation I could think of.
Rick
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, March 01, 2010 11:03 PM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
What happens if you run cmd.exe using your batch file as an argument?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331237
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Why, oh why won't my batch file run via cfexecute?
I've had it running on Win 7 RC (the release candidate) until
yesterday. Now it's on Win 7 Home Premium RTM.
I wonder if the permissions between RC and RTM are different?
-Original Message-
From: Judah McAuley [mailto:ju...@wiredotter.com]
Sent: Tuesday, March 02, 2010 12:30 AM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
Was this working on Win 7 before or was it on a previous version of
Windows, say XP? Because Windows 7 has permissions locked down much
more tightly than XP did and I've seen issues reported as can't find
something when it really means I'm not allowed to look at it.
Also, can you get any .bat files to run from cfexecute or is it only
this bat file? Is this bat file on a local drive or a maped/unc drive?
Judah
On Mon, Mar 1, 2010 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com
wrote:
Thanks for the tip, Dave, but it didn't help...
I tried:
cfexecute name = c:\windows\system32\cmd.exe
arguments = /c
/#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
timeout = 100
errorVariable = errorVariable /
And, I tried leaving off the /c in the arguments...that didn't help.
I also tried hard coding the .bat path...no good.
At least now I'm getting a different error, but can't figure out
what to change to make things work:
errorVariable returns as The filename, directory name, or volume label
syntax is incorrect.
I can't figure out what that error is referencing.
Did I use cmd.exe properly?
Are the arguments set up properly?
I tried every variation I could think of.
Rick
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, March 01, 2010 11:03 PM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
What happens if you run cmd.exe using your batch file as an argument?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331238
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why, oh why won't my batch file run via cfexecute?
I did try running the batch file from an elevated cmd window.
I ran cmd by typing cmd in the start field and using ctrl-shift-enter.
When I ran the batch file that way, it worked...at least from the
command prompt.
I also ran the batch file from a non-elevated cmd window, and
it worked fine, too.
All bat files are on a local drive.
I tested one of the other bat files in the same directory and
still got the error message:
The filename, directory name, or volume label syntax is incorrect.
???
-Original Message-
From: Judah McAuley [mailto:ju...@wiredotter.com]
Sent: Tuesday, March 02, 2010 12:30 AM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
Was this working on Win 7 before or was it on a previous version of
Windows, say XP? Because Windows 7 has permissions locked down much
more tightly than XP did and I've seen issues reported as can't find
something when it really means I'm not allowed to look at it.
Also, can you get any .bat files to run from cfexecute or is it only
this bat file? Is this bat file on a local drive or a maped/unc drive?
Judah
On Mon, Mar 1, 2010 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com
wrote:
Thanks for the tip, Dave, but it didn't help...
I tried:
cfexecute name = c:\windows\system32\cmd.exe
arguments = /c
/#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
timeout = 100
errorVariable = errorVariable /
And, I tried leaving off the /c in the arguments...that didn't help.
I also tried hard coding the .bat path...no good.
At least now I'm getting a different error, but can't figure out
what to change to make things work:
errorVariable returns as The filename, directory name, or volume label
syntax is incorrect.
I can't figure out what that error is referencing.
Did I use cmd.exe properly?
Are the arguments set up properly?
I tried every variation I could think of.
Rick
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, March 01, 2010 11:03 PM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
What happens if you run cmd.exe using your batch file as an argument?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331239
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why, oh why won't my batch file run via cfexecute?
I tested one of the other bat files in the same directory and still got the error message: The filename, directory name, or volume label syntax is incorrect. Do you have any spaces in your path that are getting escaped when you run it manually, maybe through tab completion? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why, oh why won't my batch file run via cfexecute?
Rick, I had an issue like this with an app called BarTender for generating Barcodes. It ran fine on XP, It also worked from a CMD prompt, but in Windows 7 it would not work with cfexecute. It was because the path was not using the EXACT correct path and volume label. eg: c:\program files\bartender\ this did not work C:\Program Files\BarTender\... this works It is worth a shot anyways, Win 7 is much more strict than XP. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why, oh why won't my batch file run via cfexecute?
The next two things I would try are to execute a .bat file using
cfexecute in another directory to see if CF is just having problems
with cfexecute, period, and if you are able to run a bat file that
does something like del myfile.txt, try putting the bat file you
really want to execute in that directory.
It seems to me that the most likely scenarios are some combination of:
CF can't execute a bat file in that directory because it doesn't have permission
CF really can't see that directory for some reason but it could
execute that file in another directory
CF is borked somehow and can't use cfexecute properly
Also, a note on your testing about running the .bat file from a cmd
window. CF is normally installed as a service running as System. There
are restrictions on that setup that aren't immediately obvious, like
not being able to interact with the Desktop (I believe) and doing
things over the network. You also have the option of running the
service as a named system account which would give CF more explicit
permissions as a real user. Those permissions are not necessarily
greater but they are more obvious and explicit. What is CF running as
on your box?
Judah
On Mon, Mar 1, 2010 at 9:54 PM, Rick Faircloth r...@whitestonemedia.com wrote:
I did try running the batch file from an elevated cmd window.
I ran cmd by typing cmd in the start field and using ctrl-shift-enter.
When I ran the batch file that way, it worked...at least from the
command prompt.
I also ran the batch file from a non-elevated cmd window, and
it worked fine, too.
All bat files are on a local drive.
I tested one of the other bat files in the same directory and
still got the error message:
The filename, directory name, or volume label syntax is incorrect.
???
-Original Message-
From: Judah McAuley [mailto:ju...@wiredotter.com]
Sent: Tuesday, March 02, 2010 12:30 AM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
Was this working on Win 7 before or was it on a previous version of
Windows, say XP? Because Windows 7 has permissions locked down much
more tightly than XP did and I've seen issues reported as can't find
something when it really means I'm not allowed to look at it.
Also, can you get any .bat files to run from cfexecute or is it only
this bat file? Is this bat file on a local drive or a maped/unc drive?
Judah
On Mon, Mar 1, 2010 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com
wrote:
Thanks for the tip, Dave, but it didn't help...
I tried:
cfexecute name = c:\windows\system32\cmd.exe
arguments = /c
/#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
timeout = 100
errorVariable = errorVariable /
And, I tried leaving off the /c in the arguments...that didn't help.
I also tried hard coding the .bat path...no good.
At least now I'm getting a different error, but can't figure out
what to change to make things work:
errorVariable returns as The filename, directory name, or volume label
syntax is incorrect.
I can't figure out what that error is referencing.
Did I use cmd.exe properly?
Are the arguments set up properly?
I tried every variation I could think of.
Rick
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, March 01, 2010 11:03 PM
To: cf-talk
Subject: Re: Why, oh why won't my batch file run via cfexecute?
However, when I try to use.
cfexecute name =
#expandPath('/real_estate_data/hmls/10_hmls_batch_files/load_hmls_active_ph
otos.bat')#
arguments = /c
timeout = 5000
/cfexecute
What happens if you run cmd.exe using your batch file as an argument?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331242
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why, oh why won't my batch file run via cfexecute?
If all else fails, it may be worth trying the System Command contribution on Ria. http://systemcommand.riaforge.org/ That way you can get the error returned to the output. http://systemcommand.riaforge.org/ -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why, oh why won't my batch file run via cfexecute?
If you're referring to the bat path, then no, there are no spaces in the bat path: e:\inetpub\webroot\real_estate_data\hmls\hmls_batch_files\load_hmls_active_p hotos.bat When I double-click on this bat file, it executes normally and the table is filled with data. I can execute this bat file in every way manually and I can execute the profile load_hmls_active_photos that I created in Navicat and that the bat file is supposed to run, but I just can't get it to execute within cfexecute as it did just this past Sunday before I changed to Win7 RTM and from CF8 to CF9. I've been searching all over the Internet, too, but just can't find a solution. bummer...and I need to get this machine processing data. It's supposed to run these bat files every day and process a ton of real estate data from a data feed and put it into my database and onto my client's sites. Sigh...I hate upgrading systems...something always goes awry... -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, March 02, 2010 1:03 AM To: cf-talk Subject: Re: Why, oh why won't my batch file run via cfexecute? I tested one of the other bat files in the same directory and still got the error message: The filename, directory name, or volume label syntax is incorrect. Do you have any spaces in your path that are getting escaped when you run it manually, maybe through tab completion? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why, oh why won't my batch file run via cfexecute?
Thanks for the tips, Kevin, et al... before I can try any more ideas, I've got to get CF running again! For some reason, it went offline and now I can't get it started, even after rebooting! It's 1:44 am here on the East Coast of the US and I'm beat! Perhaps some sleep will clear things up tomorrow. I'm tired of beating my head on this brick wall for tonight... Until tomorrow! Rick -Original Message- From: Kevin Pepperman [mailto:chorno...@gmail.com] Sent: Tuesday, March 02, 2010 1:04 AM To: cf-talk Subject: Re: Why, oh why won't my batch file run via cfexecute? Rick, I had an issue like this with an app called BarTender for generating Barcodes. It ran fine on XP, It also worked from a CMD prompt, but in Windows 7 it would not work with cfexecute. It was because the path was not using the EXACT correct path and volume label. eg: c:\program files\bartender\ this did not work C:\Program Files\BarTender\... this works It is worth a shot anyways, Win 7 is much more strict than XP. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute problems
Hey all, I'm working on an admin panel for my webhosting - basically what I'm struggling with is getting coldfusion to execute batch files to start and stop other programs on my server. I'm running Windows Server 2003 x64 with Coldfusion Enterprise 8.0.1 x64. I've come across some pretty weird findings, basically I can run the following command from a batch file or through cmd directly but not via coldfusion; taskkill /f /fi Windowtitle eq Server* /im * When I try to execute the bat file via coldfusion with the above line in it I get an error saying that no process's were found matching the criteria. However if I use this in the batch file it works fine; TASKKILL /F /IM server.exe Problem is, I'm running more than one server.exe, each instance of the program has a unique windowtitle which is why I really need to get the original batch file working. The code I'm using to execute the batch file is; cffile action='write' file='C:\stop.bat' output='TASKKILL /F /IM #session.username#.exe' cfexecute name = 'C:\stop.bat' outputFile = 'C:\output.txt' arguments = '/C' timeout = '1' /cfexecute The batch file is created and has the correct info written into it. I've searched all over the place trying to find others that might be having this issue but I can't seem to find anything solid. I heard it might be a x64 issue but as far as I know as of 8.0.1 x64 was fully supported. Any help would be appreciated. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfexecute problems
Hey all, I'm working on an admin panel for my webhosting - basically what I'm struggling with is getting coldfusion to execute batch files to start and stop other programs on my server. I'm running Windows Server 2003 x64 with Coldfusion Enterprise 8.0.1 x64. I've come across some pretty weird findings, basically I can run the following command from a batch file or through cmd directly but not via coldfusion; taskkill /f /fi Windowtitle eq Server* /im * When I try to execute the bat file via coldfusion with the above line in it I get an error saying that no process's were found matching the criteria. However if I use this in the batch file it works fine; TASKKILL /F /IM server.exe Problem is, I'm running more than one server.exe, each instance of the program has a unique windowtitle which is why I really need to get the original batch file working. The code I'm using to execute the batch file is; cffile action='write' file='C:\stop.bat' output='TASKKILL /F /IM #session.username#.exe' cfexecute name = 'C:\stop.bat' outputFile = 'C:\output.txt' arguments = '/C' timeout = '1' /cfexecute The batch file is created and has the correct info written into it. I've searched all over the place trying to find others that might be having this issue but I can't seem to find anything solid. I heard it might be a x64 issue but as far as I know as of 8.0.1 x64 was fully supported. Any help would be appreciated. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute running a batch file not return all the output
We are using cfexecute to run an ant script (the build file uses ant4cf, if that matters) via a batch file. If the build succeeds, we get all of the output returned (BUILD FILE SUCCESSFUL). However, if the build fails, we don't get BUILD FILE FAILED followed by the failure reason. I've verified that if we run the batch file directly (not using ColdFusion), the output does show up. Is there something we need to do to get the failure output to return? We'd like to store the failure reason when our builds run. Here's our batch file code: @ECHO OFF REM Create environment variables SET JAVA_HOME = C:\Program Files\Java\jdk1.6.0_16 SET ANT_HOME = C:\apache-ant-1.7.1 REM Run build.xml C:\apache-ant-1.7.1\bin\ant -buildfile d:\web_roots\ant4cf\builds\build.xml -quiet @ECHO ON Scott -- - Scott Brady http://www.scottbrady.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute running a batch file not return all the output
We are using cfexecute to run an ant script ... I am definitely not the one to advise you on ant ;-) But if it writes to stderr, you may want to try redirecting stderr in your cfexecute call. Just for grins. There were a few issues with that in earlier versions. Though I think that issue was corrected in one of the CF8 updates. http://www.forta.com/blog/index.cfm/2006/9/11/A-Couple-Of-CFEXECUTE-Gotchas -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute running a batch file not return all the output
On Thu, Oct 22, 2009 at 6:57 AM, Leigh cfsearch...@yahoo.com wrote: I am definitely not the one to advise you on ant ;-) But if it writes to stderr, you may want to try redirecting stderr in your cfexecute call. Just for grins. There were a few issues with that in earlier versions. Though I think that issue was corrected in one of the CF8 updates. http://www.forta.com/blog/index.cfm/2006/9/11/A-Couple-Of-CFEXECUTE-Gotchas Yep, that was the fix. I didn't realize the error output and standard output is virtually identical to the eye or that cfexecute doesn't read error output. Redirecting it to stdout did the trick. Thanks! Scott -- - Scott Brady http://www.scottbrady.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute running a batch file not return all the output
Yep, that was the fix. I didn't realize the error output and standard output is virtually identical to the eye or that cfexecute doesn't read error output. Yes, neither did I until I ran into the same problem ;-) Cheers -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with CFEXECUTE
On Wed, Sep 2, 2009 at 11:24 PM, Steve Lichtenberg wrote: cfexecute name = #runpath# arguments = #argslist# outputfile=#file_directory#fcdc.out timeout=2 / If I run it with no timeout, I get the display page but the execute never runs. If I put anything in the timeout parameter, the process times out no matter what. I have tried values from 1 - 200 for timeouts with consistent results. Log in as the user that the CF server process is started (local system?) and try running the command from the command line. That should get the fingerprint of the remote server accepted and after that it should work from CF too. Or is gives some other error you can fix :) -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with CFEXECUTE
I am running the following code: cfset File_Directory = ExpandPath(/download/) cfset runpath=D:\Additional Software\plink.exe cfset argslist= -v -batch -ssh 12.144.48.30 -l user -pw pwd /usr/local/bin/load-prod #uploadfile.serverfile# #variables.sessionuid# cftry cfexecute name = #runpath# arguments = #argslist# outputfile=#file_directory#fcdc.out timeout=2 / cfcatch cfdump var=#cfcatch# /cfcatch /cftry If I run it with no timeout, I get the display page but the execute never runs. If I put anything in the timeout parameter, the process times out no matter what. I have tried values from 1 - 200 for timeouts with consistent results. Does anyone know the magic trick to making this work? Thanks --S ^ -- Stephen Leacock - I detest life-insurance agents: they always argue that I shall some day die, which is not so. - http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute to wait
hi i am running a cfexecute to run the mysqldump command at set times of the day. i want it to produce the dump file, zip up the file, and then email it to us before deleting the files. i have got it all working but the problem is: how can i detect when a cfexecute has finished. i could obviously set a timeout on the tag but the timeout varies and sometimes takes very long. the problem is that even if the dump has not finished the cfzip command starts to run thanks for any help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute to wait
in case anyone stumbles on this thread and has a similar issue, i managed to do a work around which looks at the file size every 3 seconds. if the file size has changed it reloops as it knows it is still building it. when the file size does not change then it knows it has finished and comes out of the loop: cfset sleepObject = createObject(java, java.lang.Thread) / cfset executeComplete = false / cfset currentFileSize = 0 / !--- run through a loop every 5 seconds to see if the size of the file has changed, if yes then it means it is still executing, else it has finished and the loop can stop --- cfloop condition=executeComplete eq false cfset sleepObject.sleep(5000) cfset fileSize = getfileinfo(#filepath#.sql) / cfif fileSize.Size neq currentFileSize cfset currentFileSize = fileSize.Size / cfelse cfset executeComplete = true / /cfif /cfloop hi i am running a cfexecute to run the mysqldump command at set times of the day. i want it to produce the dump file, zip up the file, and then email it to us before deleting the files. i have got it all working but the problem is: how can i detect when a cfexecute has finished. i could obviously set a timeout on the tag but the timeout varies and sometimes takes very long. the problem is that even if the dump has not finished the cfzip command starts to run thanks for any help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321410 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFexecute Tag
Are you logged in to the server's console using the same credentials as the CF service? If the CF service is running as a different user, then it can't display a window in another user's session. Mike -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Sunday, October 19, 2008 4:34 PM To: cf-talk Subject: CFexecute Tag I don't understand why the following code, won't bring up a 'window' of 'DOS' command prompt on my server/local box. OS=Windows XP; CF version=CF8 Standard (licensed copy). cfexecute name = C:\Windows\System32\cmd.exe /cfexecute No error code, no security issue. I also try the notepad.exe with same outcome. What's the expected result for CFEXECUTE (last time I used it probably years ago...). Thanks. Chunshen Li (Don) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314135 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFexecute Tag
Are you logged in to the server's console using the same credentials as the CF service? If the CF service is running as a different user, then it can't display a window in another user's session. Mike Good thought, Mike, thank you. So, I reset cf8 logon account to be the same as XP logon session/account and restarted, and went a step further, disabled firewalls including XP's own, however, same outcome (the command prompt did not show up). What else could be in the way? Don ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314149 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFexecute Tag
Good thought, Mike, thank you. So, I reset cf8 logon account to be the same as XP logon session/account and restarted, and went a step further, disabled firewalls including XP's own, however, same outcome (the command prompt did not show up). What else could be in the way? By default, services don't interact with the desktop, even if the service is running in the same context as the logged-in user. I'm pretty confident you'd see the process in Task Manager, though. To enable desktop interaction, check the Allow service to interact with desktop option in the Log On tab for the service in the Services control panel. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfexecute and ffmpeg
I thought I had this sorted a while ago but now the problem has changed slightly and I'm not sure how to fix it. I've used ffmpeg in the past to convert to .flv files and that's all working. But now I want to use it to get the dimensions of a video without converting. If you use the following on the command line: ffmpeg -i some_file.mpg You get an error but in that error are the dimensions of the video. I want this available to me in CF so I can extract it. I would prefer to have the output in a variable and not written to a file. Can anyone suggest what might be wrong with the following line: cfexecute name=ffmpeg.exe arguments=-i #LOCAL.file_details.file_path# timeout=2 variable=LOCAL.output / cfdump var=#LOCAL.output# I've tried no timeout, a timeout of 0, of 1, of 99 and still LOCAL.output is an empty string. My though is that ffmpeg is actually throwing an error and so this isn't available as the output of cfexecute. Any thoughts? Thanks. Adrian Lynch Building a database of ColdFusion errors at http://cferror.org/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfexecute and ffmpeg
Just had a read of the fixes in CF 8.0.1 and discovered errorVariable is a new attribute for cfexecute. I knew I'd heard something like that. All sorted now :O) Adrian -Original Message- From: Adrian Lynch Sent: 20 October 2008 18:29 To: cf-talk Subject: cfexecute and ffmpeg I thought I had this sorted a while ago but now the problem has changed slightly and I'm not sure how to fix it. I've used ffmpeg in the past to convert to .flv files and that's all working. But now I want to use it to get the dimensions of a video without converting. If you use the following on the command line: ffmpeg -i some_file.mpg You get an error but in that error are the dimensions of the video. I want this available to me in CF so I can extract it. I would prefer to have the output in a variable and not written to a file. Can anyone suggest what might be wrong with the following line: cfexecute name=ffmpeg.exe arguments=-i #LOCAL.file_details.file_path# timeout=2 variable=LOCAL.output / cfdump var=#LOCAL.output# I've tried no timeout, a timeout of 0, of 1, of 99 and still LOCAL.output is an empty string. My though is that ffmpeg is actually throwing an error and so this isn't available as the output of cfexecute. Any thoughts? Thanks. Adrian Lynch Building a database of ColdFusion errors at http://cferror.org/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFexecute Tag
Don, May be inserting a timeout parameter could be display the DOS prompt??? Cheers Marco Antonio On Sun, Oct 19, 2008 at 7:34 PM, Don L [EMAIL PROTECTED] wrote: I don't understand why the following code, won't bring up a 'window' of 'DOS' command prompt on my server/local box. OS=Windows XP; CF version=CF8 Standard (licensed copy). cfexecute name = C:\Windows\System32\cmd.exe /cfexecute No error code, no security issue. I also try the notepad.exe with same outcome. What's the expected result for CFEXECUTE (last time I used it probably years ago...). Thanks. Chunshen Li (Don) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFexecute Tag
Don, May be inserting a timeout parameter could be display the DOS prompt??? Cheers Marco Antonio Marco, interesting idea, tried it, now I'm getting some 'meaningful' debugging info, Timeout period expired without completion of C:\Windows\system32\cmd.exe I've set Timeout to 3 and 6 respectively with same problem. Dave, the Allow interactive with desktop is only applicable to Local System account while I now set CF8 Server to use an XP user account for log on, hence, can't use it unless there's some manual approach, have you done anything like that for this option? Thanks, guys. Don ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFexecute Tag
Dave, the Allow interactive with desktop is only applicable to Local System account while I now set CF8 Server to use an XP user account for log on, hence, can't use it unless there's some manual approach, have you done anything like that for this option? You can set CF to run as SYSTEM again. I don't know any other way to have CF interact with the desktop. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFexecute Tag
I don't understand why the following code, won't bring up a 'window' of 'DOS' command prompt on my server/local box. OS=Windows XP; CF version=CF8 Standard (licensed copy). cfexecute name = C:\Windows\System32\cmd.exe /cfexecute No error code, no security issue. I also try the notepad.exe with same outcome. What's the expected result for CFEXECUTE (last time I used it probably years ago...). Thanks. Chunshen Li (Don) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute, Windows 2003 and runas
I have a standalone Windows 2003 SP2 server running ColdFusion 8.01 Enterprise in multi-server mode. I have created 2 additional Windows accounts on this server, mediumpriv and lowpriv with /expires:never and /passwordchg:no. The mediumpriv account has been granted the Log on as a Service privilege and the ColdFusion service is configured to run under the mediumpriv account. This all works as it should. I have a CF template that uses cfexecute to start a batch file named bootstrap.bat. bootstrap.bat runs under the same account as CF, mediumpriv. At the end of bootstrap.bat I have a runas command: runas /user:lowpriv /savecred D:\lowpriv\run.bat %RunName% What happens is that bootstrap.bat runs fine and spawns a new cmd.exe process that indeed runs as lowpriv. Only that newly spawned process doesn't do anything, it sits there without consuming any CPU time or producing any output. Not even when the first line of run,bat is: echo 'Started run %1' d:\lowpriv\run.log The really weird thing is that I can make the process work by using runas myself to start a command line as the mediumpriv user and then starting CF manually from that command line. That runs as the same user, with the same environment and works, whereas CF as a service doesn't. Can anybody provide any insight into this problem? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute, Windows 2003 and runas
I believe there are 6 items in the mmc you need to give that user, including run as service. If I remember right, one was the batch process one. Lemme go see if I can dig up the MS KB article. We have to do this all the time, and it ends up being a pain! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute, Windows 2003 and runas
Are you referring to 812614? Jochem - What would be interesting to see is why the batch file is in a hang condition. You can inspect the condition of the process by getting a hang dump of the process and examine it's callstack (I assume there's only one thread). Follow these steps and provide a place for me to download the dump from, I'll look at it if you like: 1) Download, install, and launch the DebugDiag v1.1 tool. You can get it from the Microsoft website 2) Launch your CFM template that creates the batch process 3) On the processes tab, find the batch process, right click on Create Full Userdump 4) Zip it up and put it on an FTP or web site and tell me how to get it. - Matt Small I believe there are 6 items in the mmc you need to give that user, including run as service. If I remember right, one was the batch process one. Lemme go see if I can dig up the MS KB article. We have to do this all the time, and it ends up being a pain! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfexecute, Windows 2003 and runas
I have a CF template that uses cfexecute to start a batch file named bootstrap.bat. bootstrap.bat runs under the same account as CF, mediumpriv. At the end of bootstrap.bat I have a runas command: runas /user:lowpriv /savecred D:\lowpriv\run.bat %RunName% Maybe you need to specify the path to runas? C:\windows\system32\runas.exe That's the only thing I can think of offhand. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute, Windows 2003 and runas
yeah 812614 lays out the IIS permissions for the box. We also had to apply some of these to a custom user running CF 8.x in order to get some things working right http://support.microsoft.com/kb/812614/en-us ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute, Windows 2003 and runas
Matthew Small wrote: Are you referring to 812614? IIS permissions are probably not very relevant when the system runs Apache, not IIS, and shows the same behaviour through the builtin webserver. Jochem - What would be interesting to see is why the batch file is in a hang condition. That is the $64k question. My best guess is that I need something like 'Interact with Desktop' so the cmd.exe under the lowpriv account can do something with its stderr and stdout. But 'Interact with Desktop' is only available for services under the Local System account, not under the mediumpriv account. 1) Download, install, and launch the DebugDiag v1.1 tool. You can get it from the Microsoft website I'm working on getting more tooling available on the server. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute, Windows 2003 and runas
Dave Watts wrote: I have a CF template that uses cfexecute to start a batch file named bootstrap.bat. bootstrap.bat runs under the same account as CF, mediumpriv. At the end of bootstrap.bat I have a runas command: runas /user:lowpriv /savecred D:\lowpriv\run.bat %RunName% Maybe you need to specify the path to runas? C:\windows\system32\runas.exe No, the process gets started under the lowpriv account just as it should, it just doesn't do anything anymore. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312951 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute, Windows 2003 and runas
You said the command works fine when you run it as your user then fire the runas right? Is your user a local/domain admin? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312952 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute, Windows 2003 and runas
Dana Kowalski wrote: You said the command works fine when you run it as your user then fire the runas right? Is your user a local/domain admin? The command runs fine when I: - log on to Windows as the mediumpriv user; - start cf using jrun -config instance1.config -start instance1 - call the CF template with the cfexecute command. The command does not run when I: - start instance1 as a Windows Service under the mediumpriv account; - call the CF template with the cfexecute command. The mediumpriv user is a regular user that is a member of the Users group and has the 'Log on as a Service' privilege. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312954 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute, Windows 2003 and runas
I know this exact issue has been a problem since CF 6.x. I've always thought it was a permissions problem, but to be honest I've never used cfexecute. We're just not allowed to =\ Is your CF install running as local system? If it's running as a specific user, you could try making the user starting the service a local/domain admin and see quick if it runs then. Obviously if it does, CF is lacking a permission to run it correctly. If you browse livedocs you'll see your exact issue wa back in 6.1 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p25.htm There are a couple workarounds those people tried with varying success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute, Windows 2003 and runas
You also might want to run Process Monitor on the server while executing this and see if it gives you any clue. - Matt Small I know this exact issue has been a problem since CF 6.x. I've always thought it was a permissions problem, but to be honest I've never used cfexecute. We're just not allowed to =\ Is your CF install running as local system? If it's running as a specific user, you could try making the user starting the service a local/domain admin and see quick if it runs then. Obviously if it does, CF is lacking a permission to run it correctly. If you browse livedocs you'll see your exact issue wa back in 6.1 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p25.htm There are a couple workarounds those people tried with varying success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute, Windows 2003 and runas
Dana Kowalski wrote: Is your CF install running as local system? No, it is running as mediumpriv. If it's running as a specific user, you could try making the user starting the service a local/domain admin and see quick if it runs then. It doesn't when I run CF as a service, it does when I run CF interactively. So the same as the mediumpriv account. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with CFExecute...
Hi, all... I'm trying to run this cfexecute tag... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\getfiles.bat timeout= 2 /cfexecute which is supposed to fire off this batch file: c:\program files\rhinosoft.com\ftp voyager\ftpvoyager.exe profile=MLXChange get=IF20080917_010257_RES_1.zip local=e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\voyager (Line breaks have been added for readability...) The above batch file runs perfectly from the command line. However, when initialized with cfexecute, the cfthread (if I use one) just runs with no files transferred, or, if I don't use cfthread, the template just runs with no files transferred. There are no errors in the log, except when I use cfthread and have to abort the thread. When cfthread is used, I get a Get_Data:null error. (Get_Data being the name of the thread I have to eventually abort) Suggestions, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with CFExecute...
Rick Faircloth wrote: c:\program files\rhinosoft.com\ftp voyager\ftpvoyager.exe profile=MLXChange get=IF20080917_010257_RES_1.zip local=e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\voyager The above batch file runs perfectly from the command line. However, when initialized with cfexecute, the cfthread (if I use one) just runs with no files transferred, or, if I don't use cfthread, the template just runs with no files transferred. If you execute it from the command line, do you use the same user account as CF uses? I have never used ftp voyager, but from the looks of it MLXChange is a profile that is stored somewhere user specific (like in %APPDATA%). Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem with CFExecute...
Changing CF log on as to my personal account seems to have done the trick. Any ramifications for changing the log on as for CF that I should be aware of? Thanks, Jochem. Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 2:15 PM To: CF-Talk Subject: Re: Problem with CFExecute... Rick Faircloth wrote: c:\program files\rhinosoft.com\ftp voyager\ftpvoyager.exe profile=MLXChange get=IF20080917_010257_RES_1.zip local=e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\voyager The above batch file runs perfectly from the command line. However, when initialized with cfexecute, the cfthread (if I use one) just runs with no files transferred, or, if I don't use cfthread, the template just runs with no files transferred. If you execute it from the command line, do you use the same user account as CF uses? I have never used ftp voyager, but from the looks of it MLXChange is a profile that is stored somewhere user specific (like in %APPDATA%). Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with CFExecute...
Rick Faircloth wrote: Changing CF log on as to my personal account seems to have done the trick. Any ramifications for changing the log on as for CF that I should be aware of? Use an account with the least privileges and never use an account that is used by a user as well. (Just imagine what would happen if that user enters his password incorrectly 3 times and is locked out.) Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with CFExecute...
Jochem van Dieten wrote: (Just imagine what would happen if that user enters his password incorrectly 3 times and is locked out.) Or leaves the company and the user account is deactivated. Or changes their password after three months as often is network policy. I've seen it all. Do as Jochem suggests and create a user account just for the ColdFusion service and give it only what permissions you know you want ColdFusion applications working with. But otherwise this is a very common setup. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Problem with CFExecute...
Thanks for the feedback, guys! Rick -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 4:04 PM To: CF-Talk Subject: Re: Problem with CFExecute... Jochem van Dieten wrote: (Just imagine what would happen if that user enters his password incorrectly 3 times and is locked out.) Or leaves the company and the user account is deactivated. Or changes their password after three months as often is network policy. I've seen it all. Do as Jochem suggests and create a user account just for the ColdFusion service and give it only what permissions you know you want ColdFusion applications working with. But otherwise this is a very common setup. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to use cfexecute to run batch file...
Trying the cfexecute this way didn't work, either: cfexecute name=c:\windows\systems32\cmd.exe arguments=/c e:\adobe_site\getfiles.bat timeout=30 /cfexecute ??? Thanks, Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 11:55 PM To: CF-Talk Subject: Trying to use cfexecute to run batch file... I'm trying to use cfexecute to run this bath file content: ftp -s:getfiles.txt The batch file reads its commands from getfiles.txt, which has the following code: open datalink.interealty.com [username] [password] cd /DataLinkOutput/SAV/SAV_119201 prompt mget *.* bye I can run the batch file manually and all is well. However, I can't get any results except a timeout when I use cfexecute to run the batch file. I've googled and tried everything I can think of, but obviously something's not right. Here's the cfexecute code: cfexecute name=e:\adobe_site\getfiles.bat timeout=60 But that's not working. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Trying to use cfexecute to run batch file...
On Sat, Sep 6, 2008 at 8:17 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Trying the cfexecute this way didn't work, either: cfexecute name=c:\windows\systems32\cmd.exe arguments=/c e:\adobe_site\getfiles.bat timeout=30 /cfexecute I'm guessing the context of the cfexecute is some other directory than what you actually want it to be. Change your directory in your batch file with: cd c:\adobe_site That way it can find the ftp command file. Alternatively, you can put in the full path to the ftp command file: ftp -s:c:\adobe_site\getfiles.txt and within that command file you could change your the local directory to wherever you want the files dumped: lcd c:\somedirectorywhereiwantthefiles\ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to use cfexecute to run batch file...
I'm trying to use cfexecute to run this bath file content: ftp -s:getfiles.txt Specify the full path to getfiles.txt. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to use cfexecute to run batch file...
However, I can't get any results except a timeout when I use
cfexecute to run the batch file.
cfexecute name=e:\adobe_site\getfiles.bat
timeout=60
Based on the file sized that you're likely dealing with, the timeout is too
low. I run my CDEXECUTE with a timeout of 10800 for IDX downloads...
cfsetting requesttimeout=10800 /
cfexecute name=#expandPath('.\FTPBatch.cmd')# timeout=10800 /
FTPBatch.cmd is in the same folder as the calling script and has all of the
commands needed to get to the proper folder and run the ftp command line:
@echo off
e:
cd \inetpub\wwwroot\mls\imports
ftp -n -s:..\FTPScript.txt
FTPScript.txt is also in the same folder as the calling script and has the
actual FTP commands to execute (connect, user, pass, get, etc.). In my case
the imports folder is directly below the folder where all the scripts and
such are located.
--
Justin Scott, http://www.tlson.com/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312118
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Trying to use cfexecute to run batch file...
Thanks, everyone, for the suggestions.
Here's the final solution:
cfexecute code:
cfexecute
name=C:\WINDOWS\system32\cmd.exe
arguments=/c
e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\getfiles.bat
timeout=10800
/cfexecute
batch file:
ftp
-s:e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\getfiles.txt
ftp commands file:
open datalink.interealty.com
anonymous
IDX292A
prompt
cd /DataLinkOutput/SAV/SAV_119201
lcd e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files
mget *.*
bye
Glad that's working! Got to move forward with this app!
@Justin: I think I'm going to have to get a second account with MLXchange, too.
I don't see how the data-handling can be done when I'm just sent incremental
data
each day, but don't know whether those files are for insertion, deletion, or
updating!
Rick
-Original Message-
From: Justin D. Scott [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 06, 2008 12:54 PM
To: CF-Talk
Subject: RE: Trying to use cfexecute to run batch file...
However, I can't get any results except a timeout when I use
cfexecute to run the batch file.
cfexecute name=e:\adobe_site\getfiles.bat
timeout=60
Based on the file sized that you're likely dealing with, the timeout is too
low. I run my CDEXECUTE with a timeout of 10800 for IDX downloads...
cfsetting requesttimeout=10800 /
cfexecute name=#expandPath('.\FTPBatch.cmd')# timeout=10800 /
FTPBatch.cmd is in the same folder as the calling script and has all of the
commands needed to get to the proper folder and run the ftp command line:
@echo off
e:
cd \inetpub\wwwroot\mls\imports
ftp -n -s:..\FTPScript.txt
FTPScript.txt is also in the same folder as the calling script and has the
actual FTP commands to execute (connect, user, pass, get, etc.). In my case
the imports folder is directly below the folder where all the scripts and
such are located.
--
Justin Scott, http://www.tlson.com/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312126
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Trying to use cfexecute to run batch file...
I'm trying to use cfexecute to run this bath file content: ftp -s:getfiles.txt The batch file reads its commands from getfiles.txt, which has the following code: open datalink.interealty.com [username] [password] cd /DataLinkOutput/SAV/SAV_119201 prompt mget *.* bye I can run the batch file manually and all is well. However, I can't get any results except a timeout when I use cfexecute to run the batch file. I've googled and tried everything I can think of, but obviously something's not right. Here's the cfexecute code: cfexecute name=e:\adobe_site\getfiles.bat timeout=60 But that's not working. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute batch file not working
Marcus Goedeker wrote: I have a very simple batch file that i can run fine on its own, but can't seem to get it to work using cfexecute. I used cfexecute a couple years ago and had no problems, but i can't seem to get it to work with this particular batch file. The cfexecute code is very simple...cfexecute name=C:\test.bat outputfile=C:\output.txt/cfexecute Try: cfexecute name=c:\windows\system32\cmd.exe arguments=c:\test.bat outputfile=c:\output.txt / Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute batch file not working
Try: cfexecute name=c:\windows\system32\cmd.exe arguments=c:\test.bat outputfile=c:\output.txt / Jochem Thanks for the reply. I tried it and it doesn't work. It doesn't output anything in the file either. Marcus ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfexecute batch file not working
Is CF logged in as a service or a user? -Original Message- From: Marcus Goedeker [mailto:[EMAIL PROTECTED] Sent: 12 August 2008 14:42 To: CF-Talk Subject: Re: cfexecute batch file not working Try: cfexecute name=c:\windows\system32\cmd.exe arguments=c:\test.bat outputfile=c:\output.txt / Jochem Thanks for the reply. I tried it and it doesn't work. It doesn't output anything in the file either. Marcus ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute batch file not working
I have a very simple batch file Don't forget that the default directory used by the bat file is not the one the bat file resides, but the on from which it is run. In this occurrence, it is the CF directory. Then you may have to set the working directory from inside the bat file itself. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute batch file not working
Is CF logged in as a service or a user? Thanks for the reply. I tried it and it doesn't work. It doesn't output anything in the file either. Marcus A service. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute batch file not working
I have a very simple batch file Don't forget that the default directory used by the bat file is not the one the bat file resides, but the on from which it is run. In this occurrence, it is the CF directory. Then you may have to set the working directory from inside the bat file itself. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. If I run the output in the CF directory, it works also, so that doesn't seem to be the issue. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfexecute batch file not working
Did you try it logged in as Admin? -Original Message- From: Marcus Goedeker [mailto:[EMAIL PROTECTED] Sent: 12 August 2008 15:25 To: CF-Talk Subject: Re: cfexecute batch file not working Is CF logged in as a service or a user? Thanks for the reply. I tried it and it doesn't work. It doesn't output anything in the file either. Marcus A service. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute batch file not working
Did you try it logged in as Admin? A service. Yes, i am the admin. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute batch file not working
One thing i have noticed is that the output file has a line break before and after the actual command output. I don't think this would make a difference, but I guess you never know. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfexecute batch file not working
Umm, just to be clear, I meant with Coldfusion logged in as Administrator, not sure if it will help but it certainly might. -Original Message- From: Marcus Goedeker [mailto:[EMAIL PROTECTED] Sent: 12 August 2008 16:20 To: CF-Talk Subject: Re: cfexecute batch file not working Did you try it logged in as Admin? A service. Yes, i am the admin. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute batch file not working
have you tried setting a timeout for the cfexecute ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute batch file not working
I have a very simple batch file that i can run fine on its own, but can't seem to get it to work using cfexecute. I used cfexecute a couple years ago and had no problems, but i can't seem to get it to work with this particular batch file. The cfexecute code is very simple...cfexecute name=C:\test.bat outputfile=C:\output.txt/cfexecute I can run the output in the command line also and it works perfectly. For some reason coldfusion won't execute it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310775 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute and logparser
I need to be able to parse the application log file and send a team member a list of all error or issues. I have installed the MS logparser application and I am trying to connect to it using the cfexecute. When I run the script from the command promote it works fine and I get the information, but when I try to use the cfexecute it runs the exe file but only the default help information is returned. I believe it has to do with the () in the string, I have tried to use #chr(32)# and double quotes but nothing is working. Anythoughs would be helpful. Here is what I have now. cfoutputcfsavecontent variable=querytouselogparser select * from C:\ColdFusion8\logs\application.log -i:csv/cfsavecontent/cfoutput !--- cfsavecontent variable=querytouselogparser -h -c/cfsavecontent --- cfexecute name = C:\Program Files\Log Parser 2.2\logparser.exe arguments = #querytouse# variable=items timeout = 1 /cfexecute cfoutput#items#cfoutput Matt Friedman ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute and logparser
As a hunch (I've not used cfexecute) I'd suggest: cfsavecontent variable=querytouseselect * from C:\ColdFusion8\logs\application.log -i:csv/cfsavecontent ie. ditch the logparser command, you have already told cfexecute to execute logparser.exe HTH Dominic 2008/7/2 Matthew Friedman [EMAIL PROTECTED]: I need to be able to parse the application log file and send a team member a list of all error or issues. I have installed the MS logparser application and I am trying to connect to it using the cfexecute. When I run the script from the command promote it works fine and I get the information, but when I try to use the cfexecute it runs the exe file but only the default help information is returned. I believe it has to do with the () in the string, I have tried to use #chr(32)# and double quotes but nothing is working. Anythoughs would be helpful. Here is what I have now. cfoutputcfsavecontent variable=querytouselogparser select * from C:\ColdFusion8\logs\application.log -i:csv/cfsavecontent/cfoutput !--- cfsavecontent variable=querytouselogparser -h -c/cfsavecontent --- cfexecute name = C:\Program Files\Log Parser 2.2\logparser.exe arguments = #querytouse# variable=items timeout = 1 /cfexecute cfoutput#items#cfoutput Matt Friedman ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute and logparser
Keep in mind I am reading this with only half a brain today ..
Here is what I have now.
cfoutputcfsavecontent variable=querytouselogparser select *
from C:\ColdFusion8\logs\application.log
-i:csv/cfsavecontent/cfoutput
It looks like you have the .exe (logparser) in the arguments. If that is not a
typo, try removing it.
I believe it has to do with the () in the string, I have tried to use
#chr(32)# and double quotes but nothing is working.
Try wrapping the arguments value in single quotes ('). Any change?
cfsavecontent variable=querytouse
select * from C:\ColdFusion8\logs\application.log -i:csv
/cfsavecontent
cfexecute name = C:\Program Files\Log Parser 2.2\logparser.exe
arguments='#querytouse#'
variable=items
timeout = 1
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308493
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute and logparser
ie. ditch the logparser command Yes .. what he said ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute - at my wits end!
Do you have quoted values in your arguments? CFEXECUTE won't handle those correctly. However, you can pass an array of arguments (instead of a string), and those should work. Yes! I will check into the array thing. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute - at my wits end!
Okay, I have taken both of your suggestions. I changed coldfusion to run under my user account. That caused it to be able to launch the sox application successfully, SOMETIMES. I did the array of arguments. That didn't affect anything, but I left it that way. So now my problem is that when it works, sox stays in memory. I even tried going with a batch file, and I get the same result. It is like sox isn't closing and leaving memory like it should be, but if I run it directly from the command line, I don't have that problem. Please help with any other ideas. Thanks, Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute - at my wits end!
It is like sox isn't closing and leaving memory like it should be, but if I run it directly from the command line, I don't have that problem. Try Ben Forta's tip of adding /c as an argument. This tells the command interpreter to run and terminate upon completion. I had a similar problem with ffmpeg and using \c solved it for me. http://www.forta.com/blog/index.cfm/2006/7/31/Using-CFEXECUTE-To-Execute-Command-Line-Utilities ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfexecute - at my wits end!
Hi all, I am trying to combine two wav files from the command prompt using coldfusion and sox (http://sox.sourceforge.net/). I am using cfexecute. I can output my 'name' and 'arguments' attribute for cfexecute to the screen, copy and paste them to the command prompt and the program executes perfectly. However, when I run the cfexecute, the program apparently does not execute. I'm on a windows system, with MX 7. I can't explain why. I've tried using the output variable and I just get an empty text file. Does anyone have any ideas? If you know of any other COM object or library I could use instead, that would be fine too. I'm just needing to combine wave files from within my CF app. Thanks, Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute - at my wits end!
Have you got your ColdFusion Service running with a user account? If not, try using the same account that you use to log onto the server with. On Thu, Apr 24, 2008 at 8:54 AM, Dave Phillips [EMAIL PROTECTED] wrote: Hi all, I am trying to combine two wav files from the command prompt using coldfusion and sox (http://sox.sourceforge.net/). I am using cfexecute. I can output my 'name' and 'arguments' attribute for cfexecute to the screen, copy and paste them to the command prompt and the program executes perfectly. However, when I run the cfexecute, the program apparently does not execute. I'm on a windows system, with MX 7. I can't explain why. I've tried using the output variable and I just get an empty text file. Does anyone have any ideas? If you know of any other COM object or library I could use instead, that would be fine too. I'm just needing to combine wave files from within my CF app. Thanks, Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute - at my wits end!
Do you have quoted values in your arguments? CFEXECUTE won't handle those correctly. However, you can pass an array of arguments (instead of a string), and those should work. That being said, I usually go to an intermediary shell script (or BAT file) when I have to shell out from CF. That gives me better control over the execution. cheers, barneyb On Wed, Apr 23, 2008 at 5:54 PM, Dave Phillips [EMAIL PROTECTED] wrote: Hi all, I am trying to combine two wav files from the command prompt using coldfusion and sox (http://sox.sourceforge.net/). I am using cfexecute. I can output my 'name' and 'arguments' attribute for cfexecute to the screen, copy and paste them to the command prompt and the program executes perfectly. However, when I run the cfexecute, the program apparently does not execute. I'm on a windows system, with MX 7. I can't explain why. I've tried using the output variable and I just get an empty text file. Does anyone have any ideas? If you know of any other COM object or library I could use instead, that would be fine too. I'm just needing to combine wave files from within my CF app. Thanks, Dave -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
