Hi,
it seems I am not able to replicate your issues; here are my detailed steps:
1. created Docker container from official ubuntu:16.04 image
2. installed Oracle JDK, Maven 3.5.2, Tomcat 8.5.29 (from tar.gz)
3. downloaded [1] onto $CATALINA_HOME/lib
4. created new Syncope 2.0.8 Maven project as from [2] and built
according to [3]
5. copied */target/*war to $CATALINA_HOME/webapps
6. installed the latest PostgreSQL 9.5 as per instructions from [4]
7. created a database 'syncope', fully granted to user 'syncope' with
password 'syncope'
8. started Tomcat
At that point, I connected to the PostgreSQL database where I could find:
public | qrtz_blob_triggers | table | syncope
public | qrtz_calendars | table | syncope
public | qrtz_cron_triggers | table | syncope
public | qrtz_fired_triggers | table | syncope
public | qrtz_job_details | table | syncope
public | qrtz_locks | table | syncope
public | qrtz_paused_trigger_grps | table | syncope
public | qrtz_scheduler_state | table | syncope
public | qrtz_simple_triggers | table | syncope
public | qrtz_simprop_triggers | table | syncope
public | qrtz_triggers | table | syncope
Sorry, I cannot figure out what could go wrong with your deployment.
Regards.
[1] https://jdbc.postgresql.org/download/postgresql-42.2.2.jar
[2] http://syncope.apache.org/docs/getting-started.html#create-project
[3] https://syncope.apache.org/docs/reference-guide.html#customization
[4] https://www.postgresql.org/download/linux/ubuntu/
On 02/04/2018 19:28, Dave Varon wrote:
Hi,
I should've included more detail. I apologize for that. The good news is I
followed those instructions--the bad news is, despite that, I experienced
the issue.
Postgresql
version
-----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.5.8 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit
JDBC: postgresql-42.1.4.jar
Server version: Apache Tomcat/8.0.32 (Ubuntu)
Server built: Jan 16 2017 13:18:27 UTC
Server number: 8.0.32.0
OS Name: Linux
OS Version: 4.4.0-93-generic
Architecture: amd64
JVM Version: 1.8.0_131-8u131-b11-2ubuntu1.16.04.3-b11
JVM Vendor: Oracle Corporation
core/src/main/resources/provisioning.properties:
asyncConnectorFacadeExecutor.poolSize=10
# see
http://docs.spring.io/spring/docs/current/spring-framework-reference/html/scheduling.html#scheduling-task-namespace-executor
propagationTaskExecutorAsyncExecutor.poolSize=5-25
propagationTaskExecutorAsyncExecutor.queueCapacity=100
propagationTaskExecutor=
org.apache.syncope.core.provisioning.java.propagation.PriorityPropagationTaskExecutor
userProvisioningManager=
org.apache.syncope.core.provisioning.java.DefaultUserProvisioningManager
groupProvisioningManager=
org.apache.syncope.core.provisioning.java.DefaultGroupProvisioningManager
anyObjectProvisioningManager=
org.apache.syncope.core.provisioning.java.DefaultAnyObjectProvisioningManager
virAttrCache=
org.apache.syncope.core.provisioning.java.cache.MemoryVirAttrCache
quartz.jobstore=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
quartz.sql=tables_postgres.sql
quartz.disableInstance=false
Thanks!
Dave
On Mon, Apr 2, 2018 at 12:38 PM, Francesco Chicchiriccò <ilgro...@apache.org
wrote:
Hi Dave,
please see my replies embedded below.
On 02/04/2018 17:30, Dave Varon wrote:
Hi,
Starting with an empty postgres database, executing 'mvn clean verify' and
deploying the war files,
If you are planning to deploy the generated WAR files, 'mvn clean verify'
is not enough, please check
https://syncope.apache.org/docs/reference-guide.html#customization
hence, it should rather be something like as
$ mvn clean verify \
-Dconf.directory=/opt/syncope/conf \
-Dbundles.directory=/opt/syncope/bundles \
-Dlog.directory=/opt/syncope/log
$ cp core/target/classes/*properties /opt/syncope/conf
$ cp console/target/classes/*properties /opt/syncope/conf
$ cp enduser/target/classes/*properties /opt/syncope/conf
$ cp enduser/target/classes/customForm.json /opt/syncope/conf
my logs indicate the quartz db scripts executed,
but alas the tables do not exist.
core.log:14:42:22.558 INFO
org.springframework.jdbc.datasource.init.ScriptUtils
- Executing SQL script from class path resource
[quartz/tables_postgres.sql]
core.log:14:42:22.594 INFO
org.springframework.jdbc.datasource.init.ScriptUtils
- Executed SQL script from class path resource
[quartz/tables_postgres.sql]
in 36 ms.
Execution of the script after the fact succeeds.
I suspect this may be a configuration issue (perhaps maven or properties,
or maybe privs?) but if not I can submit a bug.
Which PostgreSQL version? Which Postgres JDBC driver? Which OS?
Can you please paste the content of
core/src/main/resources/provisioning.properties
?
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
