How do you change the DBMS connection for Directory Server clients?

asked on August 21, 2021 • Show version history

With non-Directory server clients we simply change the DBMS connection and update the connection information. With the Directory Server interface I am at a loss.

When I open DS and it shows me that it can not connect to the SQL server, but the menu has not change DBMS connection like with standard LF installations.

There is an option to create a licensing site, but I don't want to do this, because your licensing site name must remain the same, and it already exists.

There is an option in the lower right corner to detach, and it prompts do you want to detach the licensing site. After clicking yes, it does not detach the licensing site, instead it just repeats the message regarding not being able to connect to SQL.

I have exhausted every option in the interface and I am uninstalling the entire program. Why is this happening?

Update:

The situation is getting even worse

I just uninstalled the program, re-installed it, I have no sites listed in my menu now. When I try to create the site I get this error:

This is certainly false.

The reason why my site display name is so important to me, is because when I have changed it in the past it caused many services across multiple servers to fail. This is a new stable version: 10.4.5.623

It is literally falling apart on me, all because of a simple DBMS change.

Update 2:

I went ahead with a new display name and it does not appear to have broken services, this might be an old 10.0 issue. Still baffled as to how a simple password change requires uninstalling the entire DS system. Also the message about the display site already existing is not true, if it already existed I would just use it instead of creating a new one.

0 0

replied on August 23, 2021 • Show version history

Hi Chad,

The SQL connection string can be changed in Settings > General > Modify connection string. You should change this connection string before changing anything in SQL. If this is not possible, or SQL has already been changed, you can do the following:

Note the currently attached licensing sites and their connection details
Backup and delete C:\ProgramData\Laserfiche\LFDS\connections.config
Restart the LFDS service
Manually attach the sites (do not press 'create') that were attached before deleting the file

This will allow you to re-attach the databases with the new connection details, including new password. When you attach a database, you can choose any display name you want including the old one.

0 0

View 2 previous replies

replied on August 23, 2021

Can we get these instructions added to the interface? I was able to use the interface of Admin Console, Forms, Workflow, and Audit Trail intuitively to update the SQL connection, but DS is not intuitive and doesn't provide these instructions on screen when you go to change the connection.

I am not sure how I would update the connections before the change in SQL exists? You can pre-configure it to connect to a future change on the SQL server that is not done yet?

With the other products it expects you to make the change after the environment has changed, because it wants to confirm the connection works.

0 0

replied on August 23, 2021

These instructions are just for the case you mentioned where the detach button doesn't work. You should be able to click that detach button and attach the site with the new credentials.

I'll file a feature request that allows you to change SQL credentials if we detect a failure to login.

0 0

replied on August 23, 2021

Ok that was what my intuition was telling me, if I can't modify, then I can delete and re-attach. But when clicking delete you get a message "Unable to connect to the SQL server". It doesn't need to connect to a SQL server to delete a configuration to an SQL server. The configuration should be file based.

0 0

replied on August 23, 2021

Yeah the detach operation should have resolved that error for you, not sure why it didn't unless this is an older version of LFDS. Correct, the SQL connection details are stored in C:\ProgramData\Laserfiche\LFDS\connections.config but the file is encrypted so you won't be able to alter it by hand.

0 0

replied on August 23, 2021

That makes sense, programdata is a hidden directory so that apps can store configurations and data permanently to the disk, not for direct interaction. The interface should give the ability to make config changes, and when saved, the app writes the changes from memory to disk. It works for all other LF apps, just not DS.

0 0

Question

Question

How do you change the DBMS connection for Directory Server clients?

Replies

Sign in to reply to this post.