No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Alternative way to enable U2000 admin user

Publication Date:  2012-07-25 Views:  129 Downloads:  1
Issue Description
Admin user account is disabled. Now customer can not have all rights on other users, and can not return admin account to be enabled.


Alarm Information
According to documentation:

The users in the SMManagers group cannot activate the admin user.
If you need to activate the admin user, run the following command on the U2000 server:
In Solaris or SUSE Linux, run the following command:

#cd installation path
#. ./svc_profile.sh
#. ./bin/svc_enableUser user name

In Windows, run the following command:
>cd /d %IMAP_ROOT%
>svc_enableUser user name
 

Handling Process
On a U2000 test installation I was able to see which tables in database are used to store informations about users.

Tried to disable a test account and observed that information is updated in imapsmdb.tbl_SMUser.

The column in database which confirms if a user is disabled is: imap_accountvalidity (0 if account is  disabled, 1 if account is enabled).

Below actions were performed on live server:

1. Login with nmsuser credentials  
2. cd /opt/sybase/OCS-15_0/bin
3. ./isql -SDBSVR -Usa -P<password>
4. > use imapsmdb
5. > go
6. > update tbl_SMUser SET imap_accountvalidity=1 WHERE username='admin'
7. > go
8. > quit

Login to U2000 server with admin user and enable account from U2000/User management menu




Root Cause
When I've tried to run procedure specified in documentation, solaris reported that some libraries are missing.
In these conditions I was forced to look for alternative solutions.



Suggestions
I strongly recommend to enable user as from documentation.

In case of users which don't have strong command line knowledge, please use a Database browser.

U2000 database structure might be different on different releases.
Above procedure was tested on U2000 V1R2C1SPC003.


END