To enter credentials, select the component monitor check boxes and click Assign Credentials. Modify the settings of the template and component monitors based on the metrics you want to monitor.SolarWinds recommends creating a copy of the template. In the SolarWinds Platform Web Console, click Settings > All Settings > SAM Settings > Manage Templates.$ su - dbuserIDĬonfigure and assign a SAM template with the credentials. Test access to the database using the newly created account credentials. Next, grant privileges for your PostgreSQL database (TestDatabase) to the user account: template1=# GRANT ALL PRIVILEGES ON DATABASE TestDatabase to dbuserID # adduser dbuserIDĪt the prompt, create the dbuserID account with the Password password: template1=# CREATE USER dbuserID WITH PASSWORD 'Password' The next commands login as the database superuser to the ProgreSQL server and modify the created user. The example of commands adds a user account dbuserID with the password Password to the Linux-based computer. If not, download and install the unixODBC driver to the Linux-based computer.ĭownload and install the PostgreSQL ODBC driver on the target Linux-based computer. (Required) To begin, you should have unixODBC installed to support Microsoft Windows ODBC. You will need to create a user account on the server and in the PostgreSQL database. Log in to the Linux-based computer with administrator privileges. Where 192.168.3.198 is IP address of your SolarWinds Platform server.Ĭonfigurations for SolarWinds Platform agent for Linuxįor the following instructions, you should have PostgreSQL installed on a Linux-based computer. On the PostgreSQL Server, find the following file:Ĭ:\Program Files\PostgreSQL\9.0\data\pg_hba.confĪnd add the following line to allow remote connections for the SolarWinds Platform server: On the SolarWinds Platform, download and install the PostgreSQL 9 ODBC driver from the following location. This template supports the SolarWinds Platform Agent for Linux. This SAM application monitor template assesses the performance of a PostgreSQL 9 Server database by retrieving performance data from the built-in pg_stat_database, pg_locks, pg_trigger, pg_proc, pg_stat_all_tables and pg_indexes views.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |