This documentation is for Live Forms 9.1. v9.1 is a Cloud Only release. Not for you? Earlier documentation is available too.

COVID-19 Response Info: At frevvo, our top priorities have always been employees and customers. We have taken several steps to promote the well-being of our people, to minimize services disruptions, and to help where we can. Visit our website for updates.

FAQ - Live Forms and LDAP

How to configure multiple users and group bases?

The Users Base and Groups Base fields on the /wiki/spaces/frevvo91/pages/901492728 define a root node to search for entries. The searches are recursive and will traverse the hierarchy starting from those nodes.  If your multiple paths share a common base you can configure that value in these properties. For instance, lets assume the following bases:

CN=Sales,CN=Users,DC=test,DC=windows,DC=frevvo,DC=com 
CN=HR,CN=Users,DC=test,DC=windows,DC=frevvo,DC=com 
CN=Marketing,CN=Users,DC=test,DC=windows,DC=frevvo,DC=com

A common path among these is CN=Users,DC=test,DC=windows,DC=frevvo,DC=com and that is what you can configure in the Users Base field.

Can I have more than one LDAP tenant?

Yes, you can configure as many tenants as you want. Each tenant can have its own LDAP configuration.

Can I connect to more than one LDAP Server?

Each tenant can connect to only one LDAP server. However each tenant can connect to a different LDAP server.

LDAP Troubleshooting

If things are not working as you expected:

  1. The primary source of information is the  log file. In most cases, the LDAP connector will try to indicate what the problem is in the logs. In the log file, look for lines with LDAPSecurityManager or LdapDao.
  2. It is useful to have an LDAP browser at hand, for instance, the Apache Directory Studio. With the browser you can:
    1.  Check if the connection parameters that you configured in  are correct.
    2.  Run queries against LDAP and make sure that the expressions you configured in   are correct and returning what you expect.
  3. If you can't spot the problem and need to contact frevvo support:
    1. Stop 
    2. Go to <frevvo-home>/tomcat/logs/frevvo.log.
    3. Follow these steps to change the log level from INFO to DEBUG
    4. Restart 
    5. Execute the steps that is causing problems.
    6. Send the log file (zip) to Live Forms support (support@frevvo.com) with a description of the problem.
    7. Restore the log level to INFO.

Below are some common cases to help with troubleshooting. All of them assume that the connectivity is working, meaning that you tested, from the same box where  is running and that the connection parameters to the LDAP server you configured in  are correct. 

As an admin I can't list the users or groups for the LDAP tenant

This is can be a problem with the expression you configured in All Users Filter (for users) and/or All Groups Filter (for groups) on the Edit Tenant screen. Also verify that the search bases are correct in the Users Base (users) and Groups Base (groups) fields. The LDAP Browser is useful here. Execute a search directly on your LDAP server using the same expression and bases you configured in  and check if the result is correct.

A user that should be a designer logs in but can't design forms

  1. Login to your LDAP/AD Server.
  2. Make sure you have a group defined for the designer role and it is named frevvo.Designers.
  3. Make sure the user having the problem is a member of the frevvo.Designers group.

Another potential issue is case sensitivity. Please refer to the topic /wiki/spaces/frevvo91/pages/901492728 .

A user that should be an administrator logs in but can't manage the tenant

  1. Login to your LDAP/AD Server.
  2. Make sure you have a group defined for the tenant admin role and it is named frevvo.TenantAdmin.
  3. Make sure the user having the problem is a member of the frevvo.TenantAdmin group. 

Another potential issue is case sensitivity. Please refer to the topic /wiki/spaces/frevvo91/pages/901492728.

I can authenticate against LDAP via the Live Forms login page but SSO is not working

  1. In IIS:
    1. Make sure Windows Authentication is set in the Default Web App (or the web app used to send requests to )
    2. Verify that Anonymous Authentication is NOT set in the default Web App  (or the web used to send requests to )
  2. In :
    1. Open FREVVO_HOME/tomcat/conf/server.xml
    2. Look at the AJP connector configuration.
    3. Verify that it has the attribute tomcatAuthentication="false" 

Admin Search for a task locked by a user does not show all LDAP users

Although the user list from the LDAP appears correct, the user does not appear in the admin search for a task locked by a user.

  1.  Verify that your LDAP configuration is correct.
  2. Check if the MaxPageSize property is set in Active Directory.  Look for "MaxPageSize" on this Microsoft Support Page for reference. The default value is 1000.
  3. Change the MaxPageSize from 1000 to the number of users/groups in your Active Directory.

LDAP Errors

The table below lists LDAP errors you may encounter when configuring your tenant with the LDAP Security Manager. Verify the recommended values to resolve.

ParametersValue to VerifyError on Edit Tenant page
Connection URLWrong URL

Group access failure: AuthenticationException?: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903A9, comment: AcceptSecurityContext error, data 52e, v1db1]

Verify the values in Connection URL,Connection User and Connection Password fields

Connection UserWrong username

Group access failure: AuthenticationException?: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece]

Verify the values in Connection URL,Connection User and Connection Password fields

Connection PasswordWrong password

Group access failure: AuthenticationException?: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 52e, vece]

Verify the values in Connection URL,Connection User and Connection Password fields

Users BaseWrong CN"User access failure: NameNotFoundException?: [LDAP: error code 32 - 0000208D: NameErr: DSID-031001CD, problem 2001 (NO_OBJECT), data 0, best match of: 'DC=frevvo,DC=com' ]
Users BaseWrong DCUser access failure: UnknownHostException?: frevvod.com
Groups BaseWrong CNGroup access failure: NameNotFoundException?: [LDAP: error code 32 - 0000208D: NameErr: DSID-031001CD, problem 2001 (NO_OBJECT), data 0, best match of: 'DC=frevvo,DC=com' ]
Groups BaseWrong DCGroup access failure: UnknownHostException?: fqrevvo.com
All Groups FilterSyntax error like mismatched bracketsGroup access failure: InvalidSearchFilterException?: Unbalanced parenthesis
All Groups FilterInvalid search e.g. (objectClasses=group) instead of (objectClass=group)Group access failure: InvalidSearchFilterException?: [LDAP: error code 18 - 0000216B: AtrErr: DSID-03140274, #1: 0: 0000216B: DSID-03140274, problem 1004 (WRONG_MATCH_OPER), data 0, Att 180006 (objectClasses) ]
All Groups FilterWrong value e.g. (objectClass=groups) instead of (objectClass=group)Tenant updates successfully
All Users FilterSame as all groups filterSame as all groups filter
Certifcate ErrorVerify that the certificate is signed by a valid Certificate Authority. Self-signed certificates are not recommended and will not work for LDAP(s) in the Cloud.Group Access failure:SunCertPathBuilderException:Unable to find valid certification path to requested target