Filemaker Server 17 won't open some of our database files that do open in Filemaker Server 15. We skipped version 16.
All database files are password protected. What am I missing? Thanks!
Any files set automatically to log-on with [Full Access] Accounts?
Does the total number of files exceed the number you have set to be allowed to open?
Steven H. Blackwell
Platinum Member Emeritus, FileMaker Business Alliance
Adding to the list:
- FM Cloud or on-premise FMS?
- do some of the files have no pw set for a Full Access account (like the default Admin / <blank> )?
Yes one of the files that won't open is set to automatically open with a full access account.
I couldn't find out where you set the number of databases allowed to open in the Server 17 console.
We only have four files that we need to open. Two of them open fine and the other two do not.
This is a pretty simple network with four iMacs and one Mac Mini server.
All accounts have a pw and some have full access (administrators) and the rest have lesser access.
All local networking.
I copied the database file that won't open on the server 17 to one of the iMacs and tried opening it with FMPA 17. It opened just fine. So it must be some setting on the FMS 17 on the Mac Mini, right?
Like FMS16, 17 doesn’t open ‘insecure” files unless you do a config change. In 17 that needs to be done from the CLI or admin API.
Since this shop didn't migrate from FMS15 to FMS16 I'm not familiar with this change so when we went from FMS15 to FMS17 we ran into this problem. I can't find any documentation that addresses this and really need some help to get the server to open this database file.
Do you mean using the Server Console in FMS17, or using the Manage Security menu after opening the file using FMPA17? I can't find anything anywhere in the console to make the database file secure. All user accounts that access this database file have username/passwords. Isn't that what secure means? How do you make a database file more secure than to have a username/password in order to open it? I assume there is a way to do this in order to open this database file on FMS17, but I don't know where or how to do that. I'm totally confused. Any specific help would be much appreciated. Thanks in advance.
webstyr wrote: Do you mean using the Server Console in FMS17, or using the Manage Security menu after opening the file using FMPA17?
Do you mean using the Server Console in FMS17, or using the Manage Security menu after opening the file using FMPA17?
It's a server config setting, but it is not available in the Admin Console. You need to use either the Admin CLI or the Admin API to make the configuration change to allow FMS to host files that are not secure. Usually that means that there is at least one account with no pw set.
The other possibility is that you put files in the FMS folder called 'secure', which has even stricter rules (the same as FM Cloud) in that the files also need to be encrypted.
Also see the extensive white papers that were released with FMS17 that describe the config options across the Console, the CLI and the API:
And the wrappers around the Admin API that the community have built so far:
Forgot to mention: the FMS event log will tell you exactly why FMS refuses to open a file, so look there first.
Thank you everyone for all your help! From what you've said in your replies it sounds like that will solve the problem and I think I know what to do now! I will implement it first thing Monday morning! Thanks again!
Retrieving data ...