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

Question

Question

Forms synchronization with Active Directory

Forms License Manager Version 9
Updated October 8, 2014
asked on October 7, 2014

Hi there:

We recently configured Laserfiche to use Active Directory for authentication in addition to the native Laserfiche authentication.  We can see the 5 Active Directory users we've added as a test in the Laserfiche webadmin console (see attached picture)

 

 

When we go over to forms though, we are only seeing one of the AD users, who happens to be an AD admin (not sure if that makes a difference).  Moreover, it doesn't look like synchronization is occurring since according to the system the last  synchronization happened 8 days ago (when it was originally set up).  We've tried multiple time to synchronize, but it doesn't seem to work.

 

 

Any help or suggestions as to how to get the synchronization working would be greatly appreciated.

 

Regards,

 

Sam

0 0

Answer

APPROVED ANSWER
replied on October 8, 2014

The MEDICINE\LFDEV$ account is the Local System account for the LFDEV server. That account is being used to try and connect to SQL, but is failing.

Check the service account used for the Laserfiche Forms Routing Service as well as the identity used for the FormsAppPool application pool in IIS. If any of those are using the Local System account, try changing to a domain account that has local admin rights to LFDEV, but also rights to SQL.

0 0

Replies

replied on October 7, 2014

We have been seeing some synching problems as well. I would recommend opening a support case with your VAR so they can create with Laserfiche to look into it.

1 0
replied on October 8, 2014

Thanks - yes we've contacted them for assistance, although not sure if they've opened a case with Laserfiche).

 

sam

0 0
replied on October 7, 2014

In your Rio environment, can you confirm that the Windows accounts are added under the Named Users and Devices node in the License Manager Administration Console?

Also, when you tried synchronizing users and noticed that the "Last synchronization" wasn't updated, were there any error messages recorded in the application event log on the Forms server?

0 0
replied on October 8, 2014

Hi there - yes we did confirm the Windows accounts are added under Named Users and Devices (see attached image).  I'll have our sys admin check the event logs for the Forms server

 

0 0
replied on October 8, 2014

This is what we can see in  log file.

I have no idea about  this user  :Message: Login failed for user 'MEDICINE\LFDEV$'.

 

 

 

Message: The underlying provider failed on Open.

Stack trace: at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)

at System.Data.EntityClient.EntityConnection.Open()

at System.Data.Objects.ObjectContext.EnsureConnection()

at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)

at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()

at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)

at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)

at Laserfiche.Forms.EntityModels.cf_settings.GetSyncConfig(IEntityContext appContext)

at Laserfiche.Forms.Routing.UserSyncer.SyncUserInternal()

Message: Login failed for user 'MEDICINE\LFDEV$'.

Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions)

at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)

at System.Data.SqlClient.SqlConnection.Open()

at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)

 

0 0
replied on October 8, 2014

Tkanks is working now! 

Changed the  local account to the service account for laserfiche Forms Routing service and sync is fine now.

 

Heidar

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

Sign in to reply to this post.

Details
Related Posts
Loading ...