Re: syncope-console HTTP Status 500 – Internal Server Error
I think i was using BOTH pool connections: - Application-managed (default); based on HikariCP, the related parameters can be tuned in the related domain configuration file, e.g. domains/Master.properties, for the Master domain. - JavaEE Container-managed, via the JNDI resource matching the name specified for a given domain, e.g. java:comp/env/jdbc/syncopeMasterDataSource for the Master domain. After deleting the quartz tables were finally created -- Sent from: http://syncope-user.1051894.n5.nabble.com/
Re: syncope-console HTTP Status 500 – Internal Server Error
Il 17/10/19 15:09, vesco ha scritto: Yeah i did follow [1] in facts all files that must be modified: - provisioning.properties - domains/Master.properties Were already ok, i mean i didn't have to edit nothing. My Postgre version is 12 cause in the reference it's written: "Apache Syncope 2.1.5 is verified with PostgreSQL server >= 10.3 and JDBC driver >= 42.2.6." So my PostgreSQL version is 12 ... ( 12 > 10.3 ;) ) Touchè, you're right :) And my JDBC is postgresql-42.2.8 [2] indeed fails; Thanks for the answer! Welcome, BTW IT tests are run against 11.5 version. I meant: maybe something has changed in PostgreSQL configuration from 10 to 12 version that causes tables creation failure? Does something change with a later version? Best regards, Andrea -- Sent from: http://syncope-user.1051894.n5.nabble.com/ -- Dott. Andrea Patricelli Tel. +39 3204524292 Engineer @ Tirasa S.r.l. Viale Vittoria Colonna 97 - 65127 Pescara Tel +39 0859116307 / FAX +39 085973 http://www.tirasa.net Apache Syncope PMC Member
Re: syncope-console HTTP Status 500 – Internal Server Error
Yeah i did follow [1] in facts all files that must be modified: - provisioning.properties - domains/Master.properties Were already ok, i mean i didn't have to edit nothing. My Postgre version is 12 cause in the reference it's written: "Apache Syncope 2.1.5 is verified with PostgreSQL server >= 10.3 and JDBC driver >= 42.2.6." So my PostgreSQL version is 12 ... ( 12 > 10.3 ;) ) And my JDBC is postgresql-42.2.8 [2] indeed fails; Thanks for the answer! -- Sent from: http://syncope-user.1051894.n5.nabble.com/
Re: syncope-console HTTP Status 500 – Internal Server Error
Hello, thanks for the answer i did a fresh new VM with the same characteristics as described above. i had to edit this: /var/lib/pgsql/12/data/pg_hba.conf and comment this: hostall all 127.0.0.1/32 ident cause syncope could not connect to the database while i could from another machine so now i can access to /syncope-console/ but i'm still getting errors on tables not getting created! *\var\lib\pgsql\12\data\log\postgresql-Thu.log* 2019-10-17 09:24:34.114 CEST [20645] ERROR: relation "qrtz_scheduler_state" does not exist at character 22 2019-10-17 09:24:34.114 CEST [20645] STATEMENT: SELECT COUNT(0) FROM QRTZ_SCHEDULER_STATE 2019-10-17 09:24:34.195 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.195 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_fired_triggers 2019-10-17 09:24:34.196 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.196 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_paused_trigger_grps 2019-10-17 09:24:34.196 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.196 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_scheduler_state 2019-10-17 09:24:34.197 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.197 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_locks 2019-10-17 09:24:34.197 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.197 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_simple_triggers 2019-10-17 09:24:34.197 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.197 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_cron_triggers 2019-10-17 09:24:34.197 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.197 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_simprop_triggers 2019-10-17 09:24:34.197 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.197 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_blob_triggers 2019-10-17 09:24:34.197 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.197 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_triggers 2019-10-17 09:24:34.197 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.197 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_job_details 2019-10-17 09:24:34.198 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.198 CEST [20645] STATEMENT: DROP TABLE IF EXISTS qrtz_calendars 2019-10-17 09:24:34.198 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.198 CEST [20645] STATEMENT: CREATE TABLE qrtz_job_details ( SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, DESCRIPTION VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BOOL NOT NULL, IS_NONCONCURRENT BOOL NOT NULL, IS_UPDATE_DATA BOOL NOT NULL, REQUESTS_RECOVERY BOOL NOT NULL, JOB_DATA BYTEA NULL, PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP) ) 2019-10-17 09:24:34.198 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.198 CEST [20645] STATEMENT: CREATE TABLE qrtz_triggers ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, DESCRIPTION VARCHAR(250) NULL, NEXT_FIRE_TIME BIGINT NULL, PREV_FIRE_TIME BIGINT NULL, PRIORITY INTEGER NULL, TRIGGER_STATE VARCHAR(16) NOT NULL, TRIGGER_TYPE VARCHAR(8) NOT NULL, START_TIME BIGINT NOT NULL, END_TIME BIGINT NULL, CALENDAR_NAME VARCHAR(200) NULL, MISFIRE_INSTR SMALLINT NULL, JOB_DATA BYTEA NULL, PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP) ) 2019-10-17 09:24:34.198 CEST [20645] ERROR: current transaction is aborted, commands ignored until end of transaction block 2019-10-17 09:24:34.198 CEST [20645] STATEMENT: CREATE TABLE qrtz_simple_triggers ( SCHED_NAME VARCHAR(120) NOT NULL, TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, REPEAT_COUNT BIGINT NOT NULL, REPEAT_INTERVAL BIGINT NOT NULL, TIMES_TRIGGERED BIGINT NOT NULL, PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) REFERENCES
Re: syncope-console HTTP Status 500 – Internal Server Error
Hi Vesco, The Quartz tables should be automatically created by Syncope at first startup. There's no need to import them manually. The fact that you had to apply this SQL files manually makes me think about some errors during startup. I suspect, from the error in core-rest.log, that something is missing on database, so the initial database population (made by Syncope when finds an empty persistence database) maybe failed somewhere. Could you share core-*.log files content during startup of the application? Restart Syncope with an empty database and "tail" the logs at Tomcat start. Best regards, Andrea Il 11/10/19 10:26, vesco ha scritto: Hello syncope team! I'm trying to build apache syncope on a Virtual Machine with this requirements: - Linux CentOS 7 - Apache Tomcat/9.0.26 - JVM 1.8.0_222-b10 - Postgres (PostgreSQL) 10.10 - /syncope Apache Syncope 2.1.5 Core - /syncope-console Apache Syncope 2.1.5 Console - /syncope-enduser Apache Syncope 2.1.5 Enduser First probem i've encountered was not getting any tables of quartz, so after digging up a bit i imported this sql into my postgres: /opt/syncope/core/src/main/resources/quartz/tables_postgres.sql the tables were finally created, rebuilt syncope with maven, and finally imported the 3 war files into apache now when i go to - /syncope-console/ i get HTTP Status 500 – Internal Server Error this were all the log i could find: */opt/syncope/log/console.log * 14:54:25.955 ERROR org.apache.syncope.client.console.SyncopeConsoleRequestCycleListener - Exception found org.apache.wicket.WicketRuntimeException: Unable to instantiate web session class org.apache.syncope.client.console.SyncopeConsoleSession at org.apache.wicket.authroles.authentication.AuthenticatedWebApplication.newSession(AuthenticatedWebApplication.java:121) ~[wicket-auth-roles-8.6.0.jar:8.6.0] at org.apache.wicket.Application.fetchCreateAndSetSession(Application.java:1555) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.Session.get(Session.java:176) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.authroles.authentication.AuthenticatedWebSession.get(AuthenticatedWebSession.java:39) ~[wicket-auth-roles-8.6.0.jar:8.6.0] at org.apache.syncope.client.console.SyncopeConsoleApplication.getHomePage(SyncopeConsoleApplication.java:267) ~[syncope-client-console-2.1.5.jar:2.1.5] at org.apache.wicket.DefaultMapperContext.getHomePageClass(DefaultMapperContext.java:113) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.core.request.mapper.MountedMapper.checkHomePage(MountedMapper.java:221) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.core.request.mapper.MountedMapper.parseRequest(MountedMapper.java:132) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.core.request.mapper.AbstractBookmarkableMapper.mapRequest(AbstractBookmarkableMapper.java:322) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.request.mapper.CompoundRequestMapper.mapRequest(CompoundRequestMapper.java:147) ~[wicket-request-8.6.0.jar:8.6.0] at org.apache.wicket.request.cycle.RequestCycle.resolveRequestHandler(RequestCycle.java:193) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:243) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70) ~[wicket-native-websocket-core-8.6.0.jar:8.6.0] at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299) ~[wicket-core-8.6.0.jar:8.6.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.26] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.26] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[catalina.jar:9.0.26] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[catalina.jar:9.0.26] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) ~[catalina.jar:9.0.26] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) ~[catalina.jar:9.0.26] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[catalina.jar:9.0.26] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) ~[catalina.jar:9.0.26] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[catalina.jar:9.0.26] at
Re: syncope-console HTTP Status 500 – Internal Server Error
uops ok sorry i've deleted my post and sent another mail http://syncope-user.1051894.n5.nabble.com/template/NamlServlet.jtp?new_topic -- Sent from: http://syncope-user.1051894.n5.nabble.com/
Re: syncope-console HTTP Status 500 – Internal Server Error
Hi, please send again your e-mail in English, this is a public resource of an Apache Software Foundation project, and we use that language as common ground to communicate across the different native languages, thanks. Regards. On 10/10/19 15:31, vesco wrote: > Buongiorno a tutti! > sto cercando di implementare syncope su una Virtual Machine avente: > - Linux CentOS 7 > - Apache Tomcat/9.0.26 > - JVM 1.8.0_222-b10 > - Postgres (PostgreSQL) 10.10 > - /syncopeApache Syncope 2.1.5 Core > - /syncope-console Apache Syncope 2.1.5 Console > - /syncope-enduser Apache Syncope 2.1.5 Enduser > > > D'apprima non venivano create le tabelle di quartz, per tanto ho eseguito > l'sql presente in: > /opt/syncope/core/src/main/resources/quartz/tables_postgres.sql > e le tabelle si sono create, ho ricreato, tramite maven, i 3 war e importati > in tomcat con > successo. > Ora quando entro in > - /syncope-console/ > da errore HTTP Status 500 – Internal Server Error > > /opt/syncope/log/console.log > 14:54:25.955 ERROR > org.apache.syncope.client.console.SyncopeConsoleRequestCycleListener - > Exception found > org.apache.wicket.WicketRuntimeException: Unable to instantiate web session > class org.apache.syncope.client.console.SyncopeConsoleSession > at > org.apache.wicket.authroles.authentication.AuthenticatedWebApplication.newSession(AuthenticatedWebApplication.java:121) > ~[wicket-auth-roles-8.6.0.jar:8.6.0] > at > org.apache.wicket.Application.fetchCreateAndSetSession(Application.java:1555) > ~[wicket-core-8.6.0.jar:8.6.0] > at org.apache.wicket.Session.get(Session.java:176) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.authroles.authentication.AuthenticatedWebSession.get(AuthenticatedWebSession.java:39) > ~[wicket-auth-roles-8.6.0.jar:8.6.0] > at > org.apache.syncope.client.console.SyncopeConsoleApplication.getHomePage(SyncopeConsoleApplication.java:267) > ~[syncope-client-console-2.1.5.jar:2.1.5] > at > org.apache.wicket.DefaultMapperContext.getHomePageClass(DefaultMapperContext.java:113) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.core.request.mapper.MountedMapper.checkHomePage(MountedMapper.java:221) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.core.request.mapper.MountedMapper.parseRequest(MountedMapper.java:132) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.core.request.mapper.AbstractBookmarkableMapper.mapRequest(AbstractBookmarkableMapper.java:322) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.request.mapper.CompoundRequestMapper.mapRequest(CompoundRequestMapper.java:147) > ~[wicket-request-8.6.0.jar:8.6.0] > at > org.apache.wicket.request.cycle.RequestCycle.resolveRequestHandler(RequestCycle.java:193) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:243) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70) > ~[wicket-native-websocket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299) > ~[wicket-core-8.6.0.jar:8.6.0] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) > ~[catalina.jar:9.0.26] > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) > ~[catalina.jar:9.0.26] > at > org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) > ~[tomcat-coyote.jar:9.0.26] > at > org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) > ~[tomcat-coyote.jar:9.0.26] > at >