Postgres ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: column user0_.colaborator_id does not exist Position: 606

Hello,

I deployed wisemapping using postgres. I used the .sql file to create the database and the schemas.

I’m using FreeIPA as the LDAP server.

When I try to login with my user i’m getting the following error:

ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: column user0_.colaborator_id does not exist

here’s the relevant sections from app.properties

database.url=jdbc:postgresql://<local_ip>:5432/wisemapping
database.driver=org.postgresql.Driver
database.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
database.username=wisemapping
database.password=<redacted>
database.validation.enabled=false
#database.validation.query=
#database.validation.enabled=false

and

#######################################################################################
# Authentication Configuration Section
#######################################################################################

# Two type of security are supported:
#   - db: User are stored in the database. Registration is required in advance.
#   - ldap: Authentication takes place using a LDAP. In this case, security.ldap.* must be configured.
security.type=ldap

# LDAP Configuration properties.
security.ldap.server=ldap://<freeipa_ip>

# If anonymous password is required, change the wisemapping-security-ldap.xml removing the
security.ldap.server.user=<user>
security.ldap.server.password=<pass>
security.ldap.basedn=<base_dn>

# This will be concatenated as part of the DN. In this case, I will be "ou=people".
# In case this need to be changed, modify the wisemapping-security-ldap.xml.
security.ldap.subDn=cn=users

# Attribute used as authentication login (Eg: in this case, the user email will be used)
security.ldap.auth.attribute=mail
security.ldap.lastName.attribute=sn
security.ldap.firstName.attribute=givenName

I tried using a wrong pass for my user to see if LDAP was an issue and I get “the email or password you entered is not valid”. I assume LDAP is ok

I tried using the wrong postgres password to see if the error was when connecting to the database. I get a different error, as such I assume I can connect to my postgres db.

I saw that there’s apopulate-schemas.sql for mysql but none for postgres. Could that be the issue?

thanks,

‌

pm

Comments (4)