ERROR: relation "gpt_user" does not exist

[MiragliaClaudio]

Hello,
Hi,
I installed GeoPortal 10 but still having the same problem: ERROR: relation "gpt_user" does not exist.
How can I fix it.
Thanks
Claudio

[SachinChand]

Hi Claudio, I'm getting the same error w/Geoportal 1.0.  Did you manage to get this resolved?

[IonutSandric]

Hi:

In geoportal.xml check if url="jdbc:postgresql://servername:5432/postgres" if postgres is the name of your geodatabase for your geoportal

Ionut

[SachinChand]

Hi:

In geoportal.xml check if url="jdbc:postgresql://servername:5432/postgres" if postgres is the name of your geodatabase for your geoportal

Ionut

Thanks for the response ionut, that was probably my issue as the geoportal geodb name should have been "geoportal", not "postgres".  In trying to resolve the issue, however, yesterday I deleted the geoportal geodb (named "geoportal") and create it again and run the geodb scripts on it again.
Now there is no "Register" link on the geoportal page and there seems to be no login authentication. I'm still using LDAP, however, I can login with any credentials, fake or real. I get a green welcome message. I didn't change anything else so I'm not sure why the "Register" button disappeared and there is no authentication going on.

[SachinChand]

Hi:

In geoportal.xml check if url="jdbc:postgresql://servername:5432/postgres" if postgres is the name of your geodatabase for your geoportal

Ionut

Also, the ESRI documentation says the default geoportal database name is "geoportal", so why would the geoportal.xml file have "postgres"?

i.e the grants_pg script has the following variable:[database] is the database name for the geoportal. Default = postgres
And the create_schema_pg script has the following: [geoportal database] is the geoportal database name. Default = geoportal

Whats the difference between the two variables?  Because they have different default values.

[mehulnahar]

Hi

I am also getting the same problem also when i hit "Browse" it does not show me anything except the box ....

If you could solve this problem please so let me know.

Thanks
Mehul

[mehulnahar]

Problem solved : Check gpt.xml file un comment the <ldapAdapter> tab. Also check settings as per the guide.

Mehul

[mehulnahar]

And comment ldapConnectionProperties

So the code looks like

<!--
          <ldapConnectionProperties
              providerURL="ldap://ldap_host_name:ldap_port"
              initialContextFactoryName="com.sun.jndi.ldap.LdapCtxFactory"
              securityAuthentication="simple"
              securityProtocol="">
              <ldapServiceAccount
                  securityPrincipal="ldap_admin_user"
                  securityCredentials="ldap_admin_password"
                  encrypted="false"
                  catalogAdminDN="catalog_admin_distinguished_name"/>
          </ldapConnectionProperties>
       
          <singleSignOn
              active="false"
              credentialLocation="userPrincipal"
              anonymousValue=""
              logoutOutcome=""/>
           
          <selfCareSupport
              supportsLogin="true"
              supportsLogout="true"
              supportsUserRegistration="true"
              supportsUserProfileManagement="true"
              supportsPasswordChange="true"
              supportsPasswordRecovery="true"/>
           
          <roles authenticatedUserRequiresRole="true">
              <role
                  key="gptRegisteredUser"
                  groupDN="group_distinguished_name_for_registered_user"/>
              <role
                  key="gptPublisher"
                  inherits="gptRegisteredUser"
                  groupDN="group_distinguished_name_for_publisher"/>
              <role
                  key="gptAdministrator"
                  inherits="gptPublisher"
                  groupDN="group_distinguished_name_for_administrator"/>
          </roles>
       
          <users
              displayNameAttribute="cn"
              passwordEncryptionAlgorithm="SHA"
              newUserDNPattern="cn={0},Users_Node_DN"
              usernameSearchPattern="(&amp;(objectclass=person)(cn={0}))"
              searchDIT="Users_Node_DN">
              <requiredObjectClasses>
                  <objectClass name="top"/>
                  <objectClass name="person"/>
                  <objectClass name="organizationalPerson"/>
                  <objectClass name="inetOrgPerson"/>
              </requiredObjectClasses>
              <userAttributeMap>
                  <attribute key="username"     ldapName="uid"/>
                  <attribute key="password"     ldapName="userPassword"/>
                  <attribute key="email"        ldapName="mail"/>
                  <attribute key="firstName"    ldapName="givenName"/>
                  <attribute key="lastName"     ldapName="sn"/>
                  <attribute key="organization" ldapName="o"/>
                  <attribute key="affiliation"  ldapName="businessCategory"/>
                  <attribute key="street"       ldapName="street"/>
                  <attribute key="city"         ldapName="l"/>
                  <attribute key="stateOrProv"  ldapName="st"/>
                  <attribute key="postalCode"   ldapName="postalCode"/>
                  <attribute key="country"      ldapName=""/>
                  <attribute key="phone"        ldapName="telephoneNumber"/>
              </userAttributeMap>
          </users>
     
          <groups
              displayNameAttribute="cn"
              dynamicMemberOfGroupsAttribute=""
              dynamicMembersAttribute=""
              memberAttribute="uniquemember"
              memberSearchPattern="(&amp;(objectclass=groupOfUniqueNames)(uniquemember={0}))"
              searchDIT="Groups_Node_DN">
    
          <!--
          <metadataManagementGroup
              name="Region 1"
              groupDN="group_distinguished_name"/>
          <metadataManagementGroup
              name="Region 2"
              groupDN="group_distinguished_name"/>
          -->
          </groups>
       </ldapAdapter>
-->