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")
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")
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
PostgreSQL Database : OpManager installed on Linux server:
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 :
| 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 |