CFFILE Read Issue From Mapped Drive

I am having real problems trying to work this one out !!

I have a folder called profiles on a server (192.168.0.120 which is fedora core3 with samba, READ Permission Only for user jimmy)

I have a CFMX6.1 Server (192.168.0.110 Windows 2003 Web Edition)

I have mapped a Drive(P:\) on the CFMX server to point to \\192.168.0.120\profiles and specified a username and password for it in the mapped drive options (jimmy, password)

I can open the mapped drive from the CFMX servers mycomputer and open up the xml files no problem within the mapped drive

However when i try to use the cffile tag within coldfusion i get the following errors:  -

With this code:  -
<cffile action="read" file="P:\ins00000304.xml" variable="myxml">

I get this error:  -

An error occurred when performing a file operation read on file P:\ins00000304.xml.  
The cause of this exception was: java.io.FileNotFoundException: P:\ins00000304.xml (The system cannot find the path specified).  

With this code: -
<cffile action="read" file="\\192.168.0.120\profiles\ins00000304.xml" variable="myxml">

I get this error: -

An error occurred when performing a file operation read on file \\192.168.0.120\profiles\ins00000304.xml.  
The cause of this exception was: java.io.FileNotFoundException: \\192.168.0.120\profiles\ins00000304.xml (Logon failure: unknown user name or bad password).  


I am logged into the CFMX server with the local admin account (administrator,password)
I have tried setting up an account with (Jimmy,password) on the CFMX server but this made no difference !?

Running out of ideas on how to overcome this issue ?!

Cheers

JT
jturkingtonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jtreherCommented:
Well, the second error makes sense because you aren't passing any logon info to the CFFILE. If your coldfusion user account doesn't have permission to the folder then you can't get to it. If you are using the local admin account, you will need to give that account permissions on the folder. The other server won't trust the other local coldfusion admin by default.
jturkingtonAuthor Commented:
im confused , the coldfusion server service runs under the local system account by default, it should have nothing to do with the local admin account ?!?

The CFFILE should work even when the CFMX server is sitting at the CTRL ALT DEL login page of windows with nobody logged in ??  right ?


Cheers

JT
Tacobell777Commented:
This is possible using UNC path or mapped drive. BUT you have to run CF service under a named account that has permissions to access that other computer.
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tacobell777Commented:
CF runs under and account, you can see this when you open up SERVICES and double click the coldfusion entry, this acocunt needs to have access to the drive you are trying to access.
jturkingtonAuthor Commented:
Tried setting the run as account under coldfusion server service to jimmy but it messed up coldfusion starting, what permission levels does the user account need to run the coldfusion server service happily , local admin, power user etc...

Cheers

JT
Tacobell777Commented:
why not leave that as it is and add the account cf is running under to the mapping, BUT also to the file system the mapping is to.
jturkingtonAuthor Commented:
EHH ??

The Coldfusion Server Service is running as the LOCAL system Account by default !

Is this the same as the local admin account  of the server ? (Slightly Confused on this one ?)

Cheers

JT
Tacobell777Commented:
Administrator account of that machine.
jtreherCommented:
As I originally said and Tacobell stated, don't mess with the cf server with this Jimmy business. Grant permission for the Coldfusion admin account to access the folder. This is by far the easiest method. Have you tried adding 'admin of computername' to the folder on the other server as a reader/writer? There is no reason for the other server to trust your coldfusion server local admin, it could be from a different company for all it knows. If you were running domain level admin accounts or created a domain level user account for coldfusion then you would have an easier time managing configs because you could properly group that bad boy as a domain admin.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jtreherCommented:
You know the MS way - always grant permissions to groups, not to users :)
trailblazzyr55Commented:
Mapped drives are specific to the currently logged in user. That's why UNC paths are much better in this case as they don't require the user to be actively logged in to work.

ie:   \\servername\sharename\filename

<cffile action="read" file="\\servername\profiles\ins00000304.xml" variable="myxml">

regards,
~trail
jtreherCommented:
I just ate at tacobell.
trailblazzyr55Commented:
LOL =)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.