JPA schema is somehow set wrong
Richard Frovarp
richard.frovarp at ndsu.edu
Mon Jun 8 18:29:08 UTC 2020
I'm getting the following on 3.4:
2020-06-08 11:53:45,105 - ERROR
[org.opensaml.storage.impl.JPAStorageService:698] - Error running
cleanup task for 1591635225099
java.io.IOException: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute
statement
at
org.opensaml.storage.impl.JPAStorageService.deleteImpl(JPAStorageServic
e.java:631)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute
statement
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityM
anagerImpl.java:1763)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute statement
at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLEx
ceptionTypeDelegate.java:80)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'shib.storagerecords' doesn't exist
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
The problem is that the user this is running as in MariaDB isn't shib,
but something else. So obviously it isn't going to find the table with
the shib schema / db prefix.
My question is where is that set? I'm providing the correct username
value, that's how it is succeeding in logging into MariaDB to begin
with. Usually I grep my way through everything to figure out where it
is being set or pulling a default. That doesn't work too well in this
case.
Thanks,
Richard
More information about the users
mailing list