account is used to run the scheduler as it is accessing everything it
needs and making the request to Oracle. There is somthing about that
connection/session that oracle doesn't like.
This sounds really stupid, but if you don't have anything better to
try why not call the template you are trying to execute via cfhttp.
Then setup the template which makes teh cfhttp call in the scheduler.
I would imagine if it has anything to do at all with how the scheduler
processes the template, this should work.
What drivers are you using?
-Adam
----- Original Message -----
From: Samuel Neff <[EMAIL PROTECTED]>
Date: Fri, 24 Sep 2004 11:12:22 -0400
Subject: RE: Oracle connection refused error with CFSCHEDULE task only
To: CF-Talk <[EMAIL PROTECTED]>
We're not using any type of HTTP-level authentication and users browsing the
site don't have any accounts or anythign on the server. It's all default
setup for CF server users.
And besides that, the error is on the query, before we ever get to the file
write.
Could what you describe still be the problem?
Thanks,
Sam
-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, September 24, 2004 11:13 AM
To: CF-Talk
Subject: Re: Oracle connection refused error with CFSCHEDULE task only
One of the first things I always check with CFSHEDULE problems is does the
user account that the Cold Fusion service run as, usually system if not
modified, have permission to all the resources necessary to do its task. In
your case I would check the file security on the directories to which you
are trying to write. You may also want to double check the permissions to
Oracle as well.
The basic issue is that when you "browse" to the template the system uses
your premisssions and can access resources that you have permission to
utilize. But when CFSHEDULE runs the same template it can only use the
permissions of the account used by the CF service and these are usually very
limited if left to the defaults.
Hope that helps.
Ian
BloodSource
www.bloodsource.org________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
