Default Account Name/Default Password not working FM9 Server

March 21, 200817 yr

Clients - FM 9.3

Host – FM9 Server 9.2

Platform – all Macs – all 10.4 (not panther or leopard)

This is a bit weird but I hope someone can help. I recently developed two virtually identical databases for a client (one essentially a copy of the other) both developed in FM9 V3 Advanced.

I built in four privilege sets in the Accounts and Privileges:

MasterOne – Full Access

MasterTwo – Full Access

Manager – Limited Access

User – Limited Access

The databases are set to use the User account on startup. FM Server authenticates using Filemaker accounts only.

Originally these were hosted without FM Server, just locally. Everything was fine.

I recently moved the databases to a Mac G4 Server using FM Server 9.2.

Now what happens when a user is opening the databases is that despite me setting the db to open automatically with the User account the Filemaker ‘Open’ dialogue box comes up as if the user is holding down the ‘Alt.’ Key. They aren’t.

Even stranger, when the user actually enters manually the User account name and password Filemaker says they do not have the access privileges to perform that operation! It gets worse. The only account that will work as a default is the MasterOne account. However, with one of the databases it returns the privileges that are actually set for MasterOne, on the other database (which is identical) it returns the privileges for the User Limited Access account!

I hasten to add that these databases work fine when they are standalone and open as instructed. It’s just on the server that they do this weird stuff.

I have deleted and re-created all the accounts. Performed all the things one would normally do in case of a corrupt file.

I believe I have set up the server software properly. I am at a loss on this. Anyone out there have any ideas?

March 21, 200817 yr

First, upgrade the Server to 9.0v3, the latest v-rev.

Second, be sure that the fmapp Exteneded Privilege is set in the Privilege Sets attached to each of these Accounts. Otherwise, when hosted, they [color:red]will not open.

The auto-enter credentials feature requires both the Account Name and the password; be sure both are entered. This is not a particularly good practice in my view, inasmuch as it gives unchallenged access to the files. Once a user is admitted, there is a prospect of unauthorized privilege escalation.

Steven