You are viewing limited content. For full access, please sign in.

Question

Question

Connect multiple forms servers to one repository

Forms Version 10
Updated March 27, 2017
asked on March 23, 2017

Hi everyone,

Forms server version: 10.2.0.774

LF server version: 10.2.0.839

 

We have a scenario where we have two different forms servers that would authenticate users from one single repository. 

The problem we're having is that whenever we configure one of the forms servers to use laserfiche server for authentication, the connection is dropped on the other forms server.

 

We have tested using different users to establish the connection, but the problem persists. 

 

Is it all possible to even set up this scenario?

0 0

Answer

SELECTED ANSWER
replied on March 23, 2017 • Show version history

If you want to use one repository for multiple Forms sites, you need to manually synchronize the password for the built-in FORMSUSR$ which is used to connect to the repository for the multiple Forms sites:

  • Open the User Authentication tab for these Forms Configuration for the multiple sites and check on which Forms server the  message appear after the repository name is "The connection to repository has been verified"
  • If the message is "The connection to repository is not valid" for one site, then please do following steps:
    • Get the password for FORMSUSER$ from [dbo].[cf_users] table of the database which the site show "The connection to repository has been verified" message
    • Update the password for FORMSUSER$ in the other database which the site show "The connection to repository is not valid" to be the same
    • Open the repository tab for both sites again and check the message is " The connection to repository has been verified" for both sites

The FORMSUSER$ password will be reset every time you change the repository settings on the User Authentication tab, so you have to synchronize the password among databases if you use one repository for multiple Forms databases.

1 0
replied on March 24, 2017

Hi!
 

I tried your suggestion, but I keep getting the "Unable to connect to Laserfiche". I went as far as copying the data through SQL query directly for every column of the FORMSUSER$ user, restarted the Forms and LF Server service, and still got the same problem. 

0 0
replied on March 27, 2017

It should because the EncryptionKey stored in the cf_options table which is used to encrypt the password are different from the two databases. You can get the EncryptionKey from the database which it shows "The connection has been verified." on the Forms Configuration then paste to the other database and test again. Please backup the EncyptionKey you before you modify it. This encryption key will be used when encrypt password for self-added participants as well, so you may need to reset the password for those participants if you change it.

1 0
replied on March 27, 2017

Thank you!

 

That solved the problem!

0 0

Replies

replied on March 23, 2017

Are you running RIO with LFDS?

0 0
replied on March 23, 2017

No, just Avante.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...