syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francesco Chicchiriccò <ilgro...@apache.org>
Subject Re: quartz tables not installing
Date Tue, 03 Apr 2018 08:30:59 GMT
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ò <ilgrosso@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/


Mime
View raw message