How to change/reset the OrientDB root password

How To

Summary

This document is meant to show the necessary steps to change/reset the OrientDB root password when it is in use with the IBM Application Discovery products.
The indication that you probably have an incorrect OrientDB/IBM AD Batch Server setup is when you receive the following error message:

ERROR 2019-04-17 16:13:32,579 [Worker-3] com.ez.gdb.core.utils.ConnectionUtils - while testing orientdb connection remote:localhost:2424 for user root
com.orientechnologies.orient.core.exception.OStorageException: Cannot connect to the remote server/database 'remote:localhost:2424/'
at sun.reflect.GeneratedConstructorAccessor29.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:57)
at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
at com.orientechnologies.common.log.OLogManager.error(OLogManager.java:215)
at com.orientechnologies.orient.client.remote.OServerAdmin.connect (OServerAdmin.java:114)
at com.ez.gdb.core.utils.ConnectionUtils.checkConnection (ConnectionUtils.java:40)
at com.ez.gdb.core.preferences.pages.GlobalODBSettingsPage$3.run (GlobalODBSettingsPage.java:186)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: com.orientechnologies.orient.core.exception.OSecurityAccessException: Wrong user/password to [connect] to the remote OrientDB Server instance.
Get the user/password from the config/orientdb-server-config.xml file
at com.orientechnologies.orient.server.OServer.serverLogin(OServer.java:522)
at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.connect(ONetworkProtocolBinary.java:821)
at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:281)
at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:223)
at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:77)

Steps

1) Open the Microsoft Windows Services by running the below command:
services.msc

2) Stop all "IBM Application Discovery *" services by right clicking each running service and selecting "Stop."

3) Open the Windows Task Manager and make sure no Application Discovery process is still running; If any is still up, please terminate it.

4) Edit the "orientdb-server-config.xml" normally located at:
    "C:\Program Files\IBM Application Discovery and Delivery Intelligence\IBM Application Discovery Batch Server\orientdb\orientdb-community-2.1.5_ezpatch1\config"

    Removing all <users></users> section like below:

            <users>
                <user resources="*" password="root" name="root"/>
                <user resources="connect,server.listDatabases,server.dblist" password="guest" name="guest"/>
            </users>

   After removing the <users> section "SAVE" the file and close it.

5) Execute the Server.bat as Administrator to set the new password for the ROOT user id;
    It is located at: "C:\Program Files\IBM Application Discovery and Delivery Intelligence\IBM Application Discovery Batch Server\orientdb\orientdb-community-2.1.5_ezpatch1\bin"

After entering the new password, hit enter and after seeing the below message you can close by issuing "CTRL+C" and confirming with "Y" as below:

6) Open the "orientdb-server-config.xml" file again and look for the ROOT user id into the <users></users> section and check if the new password is displayed there.

7) Start only the "IBMApplicationDiscoveryGraphDBService" service under Microsoft Windows Services page

8) Execute the console.bat as Administrator;
    It is located at: "C:\Program Files\IBM Application Discovery and Delivery Intelligence\IBM Application Discovery Batch Server\orientdb\orientdb-community-2.1.5_ezpatch1\bin"
    Issue the command below:

        connect localhost root <new root password>

    A message like below should show up, indicating that the OrientDB is up and accessible
    Connecting to remote Server instance [localhost] with user 'root'...OK

    ** Please note that the OrientDB address may change depending on your configuration **
        In this setup, it is installed on the same server as all other services, that's why it can be reached as "localhost."

9) Start the other services as follow: "IBMApplicationDiscoveryConfigurationService", "IBMApplicationDiscoveryConfigurationAdminService", "IBMApplicationDiscoveryBatchService"

10) From Internet Browser, open the URL http://localhost:8080 then, select "localhost:2181" --> "Environments" --> "Your Environment Name" --> "Configurations" --> "DEFAULT" --> "Graph Database"
and click "EDIT" and update the root password with the one previously set and SAVE it.

11) Execute the gdbUserSetup.bat as Administrator to set the new password for the ROOT user id for IBM AD Batch Server;
It is located at: "C:\Program Files\IBM Application Discovery and Delivery Intelligence\IBM Application Discovery Batch Server\"

12) Now that everything is set, open the IBM Application Discover Build Client using its Desktop shortcut and open your test project.

Execute the full Build on it to trigger the graphdb import.

Document Location

Worldwide

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSKK7E","label":"IBM Application Delivery Intelligence for IBM Z"},"Component":"OrientDB","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.0.5.*","Edition":"OrientDB v2.1.5","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Product Synonym

AD
ADDI

Was this topic helpful?

Document Information

More support for:
IBM Application Delivery Intelligence for IBM Z

Software version:
5.0.5.*

Operating system(s):
Windows

Document number:
882408

Modified date:
13 October 2020

UID

ibm10882408

IBM Support

Tips