Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 You will get results similar to the example below except it will show your ldap entries:

Image Modified

Now as an example I want to remove the entry corresponding with id number 9. (circled in blue)

...

 Then if you run the select * from ldap_server_connection;  again, you will notice the entry has been deleted:

Image Modified

But there is a new problem here because the index numbers (Circled in Red) are now out of sequence.  We are missing number 2.  So, you need to re-index the table.

To do this, we use the following command

Code Block
languagesql
Update ldap_server_connection set ldap_server_connections_idx = ldap_server_connections_idx  1 where ldap_server_connections_idx > #

(replacing the # with the index number that has been deleted)

 So for my example index number 2 has been deleted, so I type in

Code Block
languagesql
Update ldap_server_connection set ldap_server_connections_idx = ldap_server_connections_idx  1 where ldap_server_connections_idx > 2;

 And then if we run the select * from command again you can see the index numbers are back in order.

Image Modified

You then need to restart the DualShield Server service.