Connecting to the OpManager Database (Applicable for versions 12.4 and below)

Connecting to the OpManager Database (Applicable for versions 12.4 and below)

Question: How to connect to OpManager Database?

Solution: We can connect to the database from OpManager Web client itself ( Update Queries have to be executed by connecting to the database directly)

(Click on Support ícon on top right corner >DB Query or  try the  "URL: http://opmanagerip/name:port/SubmitQuery.do")

Ex: http://OpManager:9090/SubmitQuery.do , only database read operation is allowed)

If the user database in MSSQL, please log in to the SQL Studio, right-click on OpManagerDB (CentralDB or ProbeDB in case of enterprise edition) and select New Query option to execute queries.

If the database used is PgSQL, please follow the below steps :

To connect to the database directly, open Windows command prompt with "Run as Administrator" option, run the following command from \OpManager\mysql\bin or \OpManager\pgsql\bin directory :

PostgreSQL Database :OpManager installed on Windows server
OpManager Stand alone Database
 psql -U postgres -h127.0.0.1 -p13306 OpManagerDB
OpManager Central Database
 psql -U postgres  -h127.0.0.1 -p13307 CentralDB
OpManager Probe Database  
 psql -U postgres  -h127.0.0.1 -p13308 ProbeDB

PostgreSQL Database : OpManager installed on Linux server:
OpManager Stand alone Database
./psql -U postgres -p<port-number> -h <hostname> <dbname-case-sensitive>
Eg : ./psql -U postgres -p13306 -h127.0.0.1 OpManagerDB
OpManager Central Database
./psql -U postgres -p13307 -h127.0.0.1 CentralDB
OpManager Probe Database 
./psql -U postgres -p13308 -h127.0.0.1 ProbeDB
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • Related Articles

                      • REMOVING UNSOLICITED TRAPS FROM OPMANAGER DATABASE

                        Connect to OpManager database and execute the below query : Refer the link below  to connect to OpManager database : https://support.zoho.com/portal/manageengine/helpcenter/articles/connecting-to-the-opmanager-database 1. Run this command from the ...

                      • How to delete the SMS Queue from OpManager database?

                        Connect to OpManager database and  run the below database query : delete from sms_out; Refer the link below to connect to OpManaqger database : https://support.zoho.com/portal/manageengine/helpcenter/articles/connecting-to-the-opmanager-database

                      • How do I set a password for my OpManager pgsql database ?

                        1) Start OpManager service 2)Connect  to OpManager database :   a)Go to OpManager\pgsql\bin folder   b)Type psql -U postgres -h 127.0.0.1 -p13306  OpManagerDB   c)Once connected to the Database, execute the below query to set password          ALTER ...

                      • Database information in OpManager

                        Question: Where can I find my OpManager database  information? Solution:  OpManager database information is stored  in the file "database_params.conf"  under OpManager/conf folder. The database server name/IP , database name, database type   and user ...

                      • Reindex & Vacuum OpManager Database

                        Reindex & Vacuum OpManager Database Stop OpManager service Make sure there is no running postgres process running in the Task Manger Open a command prompt as an administrator and go to /OpManager/bin directory Execute startPgsql.bat to start PGSQL ...

                        Related Products