1 Reply Latest reply on Jan 18, 2008 6:23 AM by Newsgroup_User

    Read/write files on shared folder in cluster

    Al Baker Level 1
      I have a small cluster of servers with two running ColdFusion and two others running SQL. It turns out that SQL doesn't do a good job of deleting old backups so I want to write a scheduled task that will weekly delete all files on a folder on each SQL server that are older than 32 days.

      I marked the folders as shared on the DB servers with administrative and system permissions for R/W and mapped them to drives on the server running ColdFusion.

      But when I run the scheduled task, it gets a connection failure. My guess is that the <cfdirectory> and <cffile> tags (which do work on this instance of CF) are unable to access the shared folders on the mapped drives.

      How do I set the permissions for this to work? Or, is there another way to gain R/W access to folders on the SQL servers so that I can control them using CF on one of the web servers?
        • 1. Re: Read/write files on shared folder in cluster
          Level 7
          Al Baker wrote:
          > But when I run the scheduled task, it gets a connection failure. My guess is
          > that the <cfdirectory> and <cffile> tags (which do work on this instance of CF)
          > are unable to access the shared folders on the mapped drives.

          What user does your ColdFusion servers run under. The default Windows
          flavor of ColdFusion runs under a 'localSystem' user and this user
          usually does not have any permissions to write to resources not on the
          local server system. You just need to create or use a domain user that
          has the write/delete permissions to the desired resources and this
          assign this user to be the one ColdFusion runs under.

          Again, for the Windows flavor, you change the 'logon' user of the
          ColdFusion service in the Windows Services Panel.

          Most likely the mappings you created where associated with your personal
          account and is not available to the ColdFusion server. Mappings are
          usually not neccessary and the prefered method is to just use an UNC
          path of \\serverName\directory\file.ext once the necessary permissions
          are assigned to ColdFusion.