Good morning,
Recently, we needed to move some user's account from one Active Directory OU to another. After that, our user's could not loggin anymore into vCOps console.
After playing a little bit with dbAccessQuery.action, I've found that VMware is basing the authentication from the AD distinguishedName field and not on the SID of the user (bad thing).
Query :
Select userid, username, domainname from useraccount
where userId=x
I've tried to modify the domainname field directly in the database via the dbAccessQuery.action with the following Query, in order to repair the login process:
Variant A base on SQL commands:
UPDATE useraccount
SET domainname = 'wanted value'
Where userId='x'
Variant B base on Postgrep SQL commands:
UPDATE useraccount
SET domainname =replace(domainname, ‘initial value’', 'wanted value', Where useraccount.userId='x')
Result :
An error occurred on the page, please contact support.
Error Message: org.postgresql.util.PSQLException: ERROR: syntax error at or near “SET” Position: 42
Is there any other URL to modify the database directly or am I doing something wrong in the query?
Thanks in advance for the advices.