Hi Andrew,
Il 23/03/2018 15:11, Andrew Geery ha scritto:
I downloaded and ran syncope-standalone-2.0.8-distribution.zip.
The app starts up and I am able to get into the application as an admin.
However, after I create a new user and then try to set their password,
I get the error below about the EMAIL column not existing in the user
table.
Looking in
$TOMCAT_HOME/webapps/syncope-fit-build-tools/WEB-INF/classes/testdb.sql,
I see the definition for the user table and it is indeed missing an
email column.
Am I doing something wrong or is that a known issue?
the error message is given by the soap resource during a propagation.
Thanks
Andrew
09:55:31.972 ERROR
net.tirasa.connid.bundles.soap.provisioning.interfaces.Provisioning -
Search operation failed
org.h2.jdbc.JdbcSQLException: Column "EMAIL" not found; SQL statement:
SELECT * FROM user WHERE email='[email protected]
<mailto:[email protected]>' [42122-196]
at org.h2.engine.SessionRemote.done(SessionRemote.java:629)
~[h2-1.4.196.jar:1.4.196]
at org.h2.command.CommandRemote.prepare(CommandRemote.java:83)
~[h2-1.4.196.jar:1.4.196]
at org.h2.command.CommandRemote.<init>(CommandRemote.java:49)
~[h2-1.4.196.jar:1.4.196]
at
org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:499)
~[h2-1.4.196.jar:1.4.196]
at
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
~[h2-1.4.196.jar:1.4.196]
at
org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:73)
~[h2-1.4.196.jar:1.4.196]
at
org.apache.syncope.fit.buildtools.cxf.ProvisioningImpl.query(ProvisioningImpl.java:205)
[classes/:?]
You are working with resources that are used to test Syncope, so don't
consider if there are some errors.If you are not interested to Soap
resource you can remove it from the topology.
Otherwise, I suggest you to start from scratch. Stop Tomcat andreplace
syncope-standalone-2.0.8/apache-tomcat-8.5.29/webapps/syncope/WEB-INF/classes/domains/MasterContent.xml
with this [1].
Regards
Marco
[1]
https://github.com/apache/syncope/blob/syncope-2.0.8/core/persistence-jpa/src/main/resources/domains/MasterContent.xml
[2] https://syncope.apache.org/docs/getting-started.html#standalone
[3] https://syncope.apache.org/docs/reference-guide.html
--
Dott. Marco Di Sabatino Di Diodoro
Tel. +39 3939065570
Tirasa S.r.l.
Viale Vittoria Colonna, 97 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net
Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/
