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


          • 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 ...