nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Monitor 2023 DB installation question

Anonymous User

I have a question on the installation part of Monitor 2023. During the installation, do we have to install the DB anywhere or does it autoamtically come installed with the program? Is the only specific thing that we need to configure after installation is the SQL DB component? I am a bit confused on this part and how the postgres DB plays into Monitor.

@AndrewSakowicz

@DerekLaw

タグ付けされた投稿をもっと見る

Accepted answers

GrantSmith122

Thanks Josh! Appreciate it.

All comments

GeoJosh

@GrantSmith122,

Please add new entries to the very bottom of the file and make sure to leave off "#" at the beginning.

Josh

GrantSmith122

Hey GeoJosh,

Can this new line of information be placed anywhere in the pg_hba.conf file as long as there is no # in front of it, or does it need to go somewhere specific?

HarryPlendl

I eventually broke down and opened a support ticket for my issue and when I finally received a phone call from the person on the case, a new release had come out. They kindly asked me my version and to my surprise there was a newer release. The only thing I hadn't tried was wait for a new release to fix the issue.

Solution was to install the latest release that addresses the bug (?) . The same license authorization file generated for 2023.3 worked 2023.3.1 . The whole reinstall only took a couple minutes at best.

ArcGIS Monitor 2023.3 version is currently being used

There is a newer version that was released at the end of January (2023.3.1)

ArcGIS Monitor 2023.3 Release Notes (esri.com)

The support was good with a lot of case updates and the scheduling was just difficult as priorities higher for other tasks. Looking forward to seeing the attendees at the FedGIS conference to ask those questions.

HarryPlendl

Cannot get the ArcGIS Monitor 2023 to connect to the PostgreSQL datbase in the setup Monitor step. Any suggestions are welcome.

Steps to tried to connect ArcGIS Monitor 2023 to PostgreSQL database:

1. Updated the pg_hba.conf File

Updated the pg_hba.conf file on your PostgreSQL server to allow connections from your ArcGIS client machines. Ran the pg_ctl reload and restarted the postgresql service.

2. Attempted Connection via Web Browsers on and off the hosting server

Tried connecting to the database using both Firefox and Chrome browsers on the server where the database instance is locally hosted. This was to test if the issue was with the database server or the client machine.

3. Tested Connection from Desktop

Was able to connect to the database from your desktop using ArcGIS Pro. This suggests that the issue is not with the database itself, but possibly with the connection between the ArcGIS Monitor and the database.

4. Encountered Connection Pool Error

Received an error message stating Authentication or address for database failed "Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?"

This suggests that all connections in the pool are being used and none are currently available. Tried various “hostname:port” configurations.

dcoley

This is very helpful @GeoJosh - thanks very much for this. To me, this:

"By default, only clients running on the same machine as the PostgreSQL database cluster can connect to it."

is just not clear that 'clients' is referring to the Monitor Server.

I also would have preferred to name the db differently as you have, but the help example names the db the same as the owner, which as a SQL Server admin I would never do. But I don't know/didn't know that/if Monitor Server is expecting the database to be named 'agm' - so it looks like it can be....

GeoJosh

Hello @DavidColey,

For step 3, consider this scenario:

My database name is "monitor"
The database user I am using to connect is "agm"
The IP address of the ArcGIS Monitor Server machine is "1.2.3.4" with an IP mask of "32
The authentication method is "scram-sha-256"

In this scenario, I would add the following line to the pg_hba.conf file (located in C:\Program Files\PostgreSQL\14\data by default):

host    monitor    agm    1.2.3.4/32    scram-sha-256

Please note that each value in the row is separated by spaces, not tabs. In my testing, using tabs instead of spaces will cause the Postgres service to crash.

For step 4, you can either open pgAdmin, connect to the database, and issue this command...

SELECT pg_reload_conf()

...or open a command prompt on the machine where Postgres is installed, navigate to the installation directory (C:\Program Files\PostgreSQL\14\bin by default) and issue the following command:

pg_ctl reload

Please note that this set of steps only needs to be done if Postgres is installed on a different machine from ArcGIS Monitor Server. If ArcGIS Monitor Server and Postgres are installed on the same host, these steps should not be necessary. Please let me know if I can elaborate further or if there are any other questions.

Best,

Josh

dcoley

Hi @AndrewSakowicz , @Anonymous User - I was able to muddle my way through setting up postgreSQL version 14.6 (the latest version on MyEsri) and was able to create the 'agm' user database per the help doc above using the pgAdmin gui.

However, do either of you have a practical example of steps 3 and 4?

Configure the database to allow connections

By default, only clients running on the same machine as the PostgreSQL database cluster can connect to it. To allow remote clients to connect to the database cluster, alter the PostgreSQL pg_hba.conf configuration file. The entries you place in the pg_hba.conf file vary depending on your security policies and configurations.

Complete the following steps to allow remote connections from clients to the PostgreSQL server:

Make a backup copy of the pg_hba.conf file before you alter it.
Open the pg_hba.conf file in a text editor.
Add the Monitor Server IP address, designate the database that it can connect to, and specify the authentication methods used for connections using the following example:
```
# TYPE    DATABASE        USER         ADDRESS                          METHOD
host      <monitor_db>    <db_user>    <monitor_server_ip>/<ip/mask>    <auth_method>
```
For more information, refer to the PostgreSQL documentation.
Reload server configuration settings using a PostgreSQL function such as pg_ctl reload or SELECT pg_reload_conf().

Thanks in advance for anything you can provide . . .

David

AndrewSakowicz

Please see https://doc.arcgis.com/en/monitor/latest/install/windows/arcgis-monitor-system-requirements.htm . This step needs to be completed by a user before the setup step. We are in the process of providing additional clarification.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.