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ò <[email protected]
> 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/
>
>
