Jump to content

Recommended Posts

Hello All,

I have a very old script (fmp 10?) that creates User Accounts and assigns Privilege Sets.  The users are then able to Login via WebDirect (primarily).  The Add Account function is used with the following parameters:

Add Account [ Account Name: _Parent Data::Parent1_Email_TrimAndRemoveReturns; Password: _Parent Data::
Parent1_WebPassword; Privilege Set: Web_User ]
[ Expire password ]

The Password is temporary (for first login only) that is randomly generated via Custom Function.   Users are required to change their password on first login.  

The account is created but for some reason the user cannot Login via Webdirect or Client (Invalid Account/Password).  I checked the privilege sets and they all check out.  I can manually change the password form the Security Console and require a new password - and everything works as expected.   Again this script worked for years - we typically only create accounts in the fall - so if there has been a major security update or some other new requirement  that would throw a wrench in the works - well, hoping you all can help me out.  

Thank you in advance!


Link to post
Share on other sites

Is an account actually created and enabled?


Is Access via FileMaker Network (fmapp) checked?

As for access via Webdirect...does the priv set you're assigning have this setting checked?



Link to post
Share on other sites
On 9/30/2020 at 4:17 PM, bcooney said:

Is an account actually created and enabled?


Yes - Account is created and enabled.  


On 9/30/2020 at 4:17 PM, bcooney said:

Is Access via FileMaker Network (fmapp) checked?

Permissions/Extended Privilege's sets are correctly enabled - again - if I reset the password for the newly created account - the user is able to login in both WebD and fmapp. 

Link to post
Share on other sites

In the Add Account Function  -> Password, I place a default, temporary (user has to reset pw on login), password of "camp1234" - notta - Still getting "authentication failed on database".  If I reset the password for the account (Security Console) everything works as expected.   

I added Reset Account Password  (with the Custom Function pw generator) immediately following Add Account function in my script -  everything works as expected.    While this is a temporary "fix" - something is really weird - I can't find anything on the web about this sort of behavior.   @bcooney I see you are a moderator - perhaps try moving me over to Security Concepts?   Not sure if anyone has had this issue.   Thanks for your efforts here!  Jim

Link to post
Share on other sites
  • 2 weeks later...

Mainers are really having a hard time with this social distancing thing - we are not use to being so close to so many people.  Had to take a break and head for the north woods for a couple of weeks.  I was hoping for some insight on this one.  Is this a bug?  Can anyone reproduce this behavior or is it just me?  Thanks in advance!

Link to post
Share on other sites

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
  • Similar Content

    • By JDW
      Our company still uses FMP 11 Advanced because hosting online via IWP is much, much cheaper than hosting with a modern version of FMP.  Currently, we pay double to have two different FMP 11 databases hosted online.  One database contains 900 records and is open to the public with no password, and the other has several thousand records and requires a password.  
      In hopes of cutting our hosting cost in half, I would like to combine the two databases into one database, such that we need only pay to host 1 database.  But our need to password protect certain records remains.  
      In other words, I want to put the content that doesn't require a password inside the FMP database file that has data we want to protect.  I know it's possible to combine the two databases, but that would mean we can no longer use a main password to lockout the entire file, as that would lock out everybody.  I would like to know if I can use FMP 11 Advanced to password protect only certain records within a single database file?
    • By Tony Diaz
      I'd like to add a condition to this to not do it if "id" already exists in the table:
      Set Field [ Moby_Countries_Values::ID ; JSONGetElement ( $record ; "id" ) ]
      So that value, 'id' is embedded within the blob that I'm parsing already. In that loop some of the array sets may exist, others many not already.
      If [ not IsEmpty( $countries ) ] Set Field [ ISBN::JSON_VariableView1 ; $countries ] Set Variable [ $Cover_Group_ID ; Value: ISBN::ISBN_ID ] Set Variable [ $n ; Value: ValueCount ( JSONListKeys ( $authors ; "" ) ) ] Freeze Window Go to Layout [ “ISBN_Meta” (ISBN_Meta) ; Animation: None ] Loop Set Variable [ $i ; Value: $i + 1 ] Exit Loop If [ $i > $n ] New Record/Request Set Field [ Moby_Countries_Meta::Cover_Group_ID ; $Cover_Group_ID ] Set Variable [ $record ; Value: JSONGetElement ( $countries ; $i - 1) ] Set Field [ Moby_Countries_Values::Name ; JSONGetElement ( $record ; "name" ) ] Set Field [ Moby_Countries_Values::Description ; JSONGetElement ( $record ; "desc" ) ] Set Field [ Moby_Countries_Values::ID ; JSONGetElement ( $record ; "id" ) ] End Loop Go to Layout [ original layout ; Animation: None ] End If  
      Because afterwards I'll do:
      Set Field [ Moby_Countries_Meta::ID ; JSONGetElement ( $record ; "id" ) ]
      ...and it will relate to the just added / or already now existing record.
    • By mvoogt
      I have started sending emails using the INSERT FROM URL method shown by soliant here:
      Emails are being sent out but many recipients seem to be getting my emails sent to their spam folders. I'm curious if this has anything to do with this method of sending emails.
    • By Joost Miltenburg
      Hi All,
      I added security to limit the DataAPI user from accessing certain records, with the limited option. I tested this while running these files on my HD no server. Worked like a charm. After moving the files to FMServer the DataAPI account can access all record in the table all of a sudden.
      Any thoughts as to why this is happening?
      Kind regards,
    • By Stickybeak
      I have been running a document creation and management solution for 2 years.
      My scribe maintenance subscription ran out so I bought a new license.
      Boom the whole things has collapsed.
      Scribe is throwing errors when a field in the database does not appear as a merge field in the document the attached being a typical error.
      This solution is vital to my practice but 360Work have no taken 2 working days with no solution - not responding to my emails when I tell them that their work arounds aren't working.
      This was suggested "ScribeSetErrorCapture(true)" - but that does not even appear in my steps in the script window.
      Utterly frustrated.

  • Create New...

Important Information

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