Hi All! I'm trying to "generate" raw sql file for the latest keycloak 3.3.0.CR2, but without connection to the database (Oracle). Is't possible? Every time, I'm trying to start standalone.sh I'm getting an error: caused by: java.net.ConnectException: Connection refused My standalone.xml <cut> <datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" jta="true" use-java-context="true"> <connection-url> jdbc:oracle:thin:@127.0.0.1:1521:ORCLCDB </connection-url> <driver> oracle </driver> <security> <user-name>username</user-name> <password>password</password> </security> <new-connection-sql>select * from dual</new-connection-sql> </datasource> </cut> In drivers section: <cut> <driver name="oracle" module="com.oracle.db"> <xa-datasource-class>oracle. jdbc.xa.client.OracleXADataSource</xa-datasource-class> </driver> </cut> and strategy options: <cut> <properties> <property name="dataSource" value="java:jboss/datasources/KeycloakDS"/> <property name="initializeEmpty" value="false"/> <property name="migrationStrategy" value="manual"/> <property name="migrationExport" value="${jboss.home.dir}/keycloak-database-update.sql"/> </properties> </cut> I'm expecting keycloak-database-updata.sql file... Thanks! Regards, Mike _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user

No, you need to have connection open so that Liquibase that generates the script can check current database dialect. Keycloak does not support Liquibase offline mode [1] at the moment. If that is needed, feel free to create JIRA and describe your usecase. [1] http://www.liquibase.org/2015/07/without-a-connection.html On Thu, Oct 19, 2017 at 12:21 AM, mzmien <mzmien(a)onet.pl&gt; wrote: > Hi All! > > I'm trying to "generate" raw sql file for the latest keycloak 3.3.0.CR2, > but without connection to the database (Oracle). Is't possible? > Every time, I'm trying to start standalone.sh I'm getting an error: > > caused by: java.net.ConnectException: Connection refused > My standalone.xml > <cut> > <datasource jndi-name="java:jboss/datasources/KeycloakDS" > pool-name="KeycloakDS" enabled="true" jta="true" use-java-context="true"> > <connection-url> > jdbc:oracle:thin:@127.0.0.1:1521:ORCLCDB > </connection-url> > <driver> > oracle > </driver> > <security> > <user-name>username</user-name> > <password>password</password> > </security> > <new-connection-sql>select * from dual</new-connection-sql> > </datasource> > </cut> > > In drivers section: > <cut> > <driver name="oracle" module="com.oracle.db"> > <xa-datasource-class>oracle. > jdbc.xa.client.OracleXADataSource</xa-datasource-class> > </driver> > </cut> > > and strategy options: > <cut> > <properties> > <property name="dataSource" > value="java:jboss/datasources/KeycloakDS"/> > <property name="initializeEmpty" value="false"/> > <property name="migrationStrategy" value="manual"/> > <property name="migrationExport" > value="${jboss.home.dir}/keycloak-database-update.sql"/> > </properties> > </cut> > > I'm expecting keycloak-database-updata.sql file... > > Thanks! > > Regards, > Mike > _______________________________________________ > keycloak-user mailing list > keycloak-user(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/keycloak-user -- --Hynek _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user