Unable to register geodatabase. Bad login user

2984
1
10-21-2016 06:17 AM
GianniContino
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

Gianni

0 Kudos
1 Reply
KenGalliher1
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 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.

Ken