Symptoms
Cisco Connectrix DCNM 7.2.1 on Windows serverPostgres databaseCisco DCNM web client issue: unable to create DCNM web client user as user account already exists error occursHowever listing of users in DCNM web client does not show the user as created.
Cause
postgres database entry exists for user already to query the postgres database for dcnm user entries use the following procedure from DCNM server :1. Login to SQL Shell(psql).Click Start - Program files - PostgreSQL 8.3 - SQL Shell(psql)Server : localhostDatabase : dcmdbPort : 5432Username : Password : 2. Check user already exists in databasedcmdb=> select userid, password, role from dcnmuser;
Resolution
Using SQL Shell(psql) remove the existing user entry and recreate the user thereafter in DCNM web client1. Login to SQL Shell(psql).click Start - Program files - PostgreSQL 8.3 - SQL Shell(psql)Server : localhostDatabase : dcmdbPort : 5432Username : Password : 2. Delete user dcmdb=> delete from dcnmuser where userid='';dcmdb=> commit;NOTE: make sure to put username in normal single quotes3. verify username is removed :dcmdb=> select userid, password, role from dcnmuser;4. recreate the DCNM web client user from DCNM web client Admin, Local menu
