massively change the permissions of all folders

Question

Hello Everyone,

It's been a while since I last posted a question.

I'm resuming my evaluation of CompleteFTP as a replacement for my old Filezilla Server.

I was able to import the users without any problems.

Now I have a question: I would like to massively change the permissions of all folders for non-Windows users. Is there a way to do this without having to do it one by one?

Regards,

Comments

All users with the same permissions set?

---

Yes. All non-Windows users will have the same permissions: upload files, list folder contents, and change into folders. All other permissions will be disabled.

Answer 1

You can do bulk permissions updates directly to the CompleteFTP config database as follows:

1. Close CompleteFTP Manager if it’s running

2. Stop the CompleteFTP service

3. Back up your existing configuration by copying the file at the following path to another directory

   C:\ProgramData\Enterprise Distributed Technologies\Complete FTP\config.sdf

4. Open a Windows command prompt as Administrator

5. Execute the following command:

   "C:\Program Files\Complete FTP\Server\cftpconfig.exe" /q "UPDATE [Node] SET [Permissions] = '750' WHERE GroupID = '8a9b1ba4-5d1b-41f6-893a-f99a319be033'"

   The permissions are Unix style, so 750 in this example means full-control by owner, read-only by group and none for anyone else. The where clause restricts the changes to the users group.

6. Start the CompleteFTP service

7. Open CompleteFTP Manager and check if the paths changed as you expected.

8. If the changes are not as you expected then restore the config.sdf file that you backed up in step 3 and try again.

Comments

Hello.

This solution did not work 100% for my environment. However, it gave me some good tips on how to solve the problem. Let me tell you what I did.

In item 3, I do not have the config.sdf file, but I do have the config.db (in the same directory). I believe that because the CompleteFTP version I am using is 25.0.0, things may have changed a bit.

So I made a backup of the config.db and edited it using DB Browser.

The most valuable tip in your answer was which table I had to edit: NODE.

I realized that the lines in this table that referred to the folders would have to have the content 'c2,0,0' in the Permissions column.

I made the necessary changes to the lines and everything worked out.

Thank you for your support and sorry for my poor English.