Unable to register geodatabase. Bad login user

10-21-2016 06:17 AM
New Contributor III

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


0 Kudos
1 Reply
Esri Contributor

Hi Gianni,

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 md5
host all all 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.