search

Waziup / WaziCloud

WAZIUP Cloud and local platform
31 stars 28 forks source link

Keycloak error: Table 'PROTOCOL_MAPPER' already exists #215

Open umucyoSoft opened 4 years ago

umucyoSoft commented 4 years ago

Hello, i am Jean Louis, Hereby trying to install waziup platform but gets the 3 errors:

keycloak_1 | 16:15:13,676 ERROR [stderr] (ServerService Thread Pool -- 50) Mon Feb 17 16:15:13 UTC 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

keycloak_1 | 16:15:19,370 ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool -- 50) Change Set META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva@redhat.com failed. Error: Table 'PROTOCOL_MAPPER' already exists [Failed SQL: CREATE TABLE keycloak.PROTOCOL_MAPPER (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, PROTOCOL VARCHAR(255) NOT NULL, PROTOCOL_MAPPER_NAME VARCHAR(255) NOT NULL, CONSENT_REQUIRED BIT(1) DEFAULT 0 NOT NULL, CONSENT_TEXT VARCHAR(255) NULL, CLIENT_ID VARCHAR(36) NOT NULL)]

keycloak_1 | 16:15:19,421 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 50) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./auth: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)

Please any help?Thanks in advance

cdupont commented 4 years ago

Hi umucyoSoft, I am sorry I didn't see your message. I am trying to reproduce your problem.

Did you follow the instructions of the README file: https://github.com/Waziup/WaziCloud/blob/master/README.md ? Did you have a previous version installed?