You will get results similar to the example below except it will show your ldap entries:
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:
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
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
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.
You then need to restart the DualShield Server service.