Jump to content

"Access restrictions" problems...


xtrim
 Share

This topic is 6535 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi

I've encountered a strange and annoying problem :

I have a large DB with hundreds of users. almost all of them are using it through the web (html).

I've made some modification to the DB to enhance web capabilities...

It is working perfectly..sometime...

Once in a while the users suddenly get a "access restriction" error message, and when I go and check the FMPU,

most of the menu objects are suddenly greyed out....so...I restart FMPU and again it is working fine...for a while..

Any ideas what could be the cause to it??

Link to comment
Share on other sites

I have had similar problems when a user performes a large search and the user cancelled the action before filemaker was finished processing. In filemaker it looked like the password used on the server to start the databases was overruled by the password I set in the websecurity database.

I am not sure it is the same problem. I also did not find a solution nor a workaround yet, so I hope this info helps. I even tried a remotely triggered script to close and reopen the database by means of a "reset" but it only works when I do it manually on the server.

Wouter

Link to comment
Share on other sites

Hi

Tnx for the tip....I'm not using the security DB..I'm using the built in acces privileges.

So basicaly if FMP gets "confused" it is going down to the lowest password in the "file -> access privileges -> passwords" list. is that correct?

if so then the simplest solution will be to make the lower password with the minimum setting for editing and browsing records...

Or would it go automatically to "no access at all" no matter what is in that list....??

Any other suggestion?

Link to comment
Share on other sites

Well, I'm glad to say that it worked...when FMPU gets "confused" it's going down to the lowest (weakest) access privileges automatically !!! in my case it is the "no password" password...

I've modified the "no pasword" to enable edit and browse records, and now it is working.

But i'm sad to say that for someone who need tighter security..this sucks !!!

This is a major bug !!! and it doesn't matter if you use FM built-in security or the security DB...

Does FMI knows about this? how come so few people encounterd this bug?

FMPU is used all over the world serving as web engines, and almost no one encounterd this bug??!!

Link to comment
Share on other sites

"I have a large DB with hundreds of users. ALMOST ALL of them are using it through the web (html)."

Have you tested for simultaneous peer-to-peer / web client actions. It is important to remember that unlike the peer-to-peer client the web client interacts in a stateless manner.

Link to comment
Share on other sites

For me the problem happens with just one user (me) accessing the database over the web. No peer-to-peer access is allowed. The database itself is about 50000 records big and there are recordlevel access restrictions that force the database to do a find even when all records are displayed.

This leaves the option open for this problem to occur even when just one user goes to a listview and cancels before it is displayed.

Wouter

Link to comment
Share on other sites

This topic is 6535 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.