I'm trying ti register a geodatabase PostgreSQL 9.3 in ArcGIS Server 10.4.
ArcGIS Server is installed on Ubuntu (Linux) machine.
I'm experiencing this error:
machine='ubuntu' process='26' thread='23' >
The connection property set was missing a required property or the property value was unrecognized.
Bad login user.
I tried to add ubuntu arcgis user to postgresql, but I can't solve this issue.
I tried to make the process throught sde user, but nothing.
Please help me. Thanks
Does the database reside in a location different than the ArcGIS Server machine? If so, make sure to alter the pg_hba.conf file to allow the IP address of the ArcGIS Server machine to connect.
For example, the pg_hba.conf file could contain:
Entries for both ipv4 and ipv6 connection types, the second line, indicates that any user from any machine can connect.
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 0.0.0.0/0 md5 # <-- add the specific address of the ArcGIS Server machine if desired.
# IPv6 local connections:
host all all ::1/128 md5
host all all ::/0 md5
If this is the case, the "bad login user" error may sound misleading. However, from PostgreSQL's point of view, the proper credentials were never actually passed to the database.