我正在将mysql作为数据源添加到wildfly
i可以通过jboss-cli.sh
插入 usessl = false 参数到连接-url标签这可以很好地工作,但是当我启动服务器时,它告诉我明确设置 usessl = false
/subsystem=datasources/data-source=KeycloakMysqlDS:add(
jndi-name=java:jboss/datasources/KeycloakMysqlDS,
driver-name=mysql,
connection-url=jdbc:mysql://localhost:3306/keycloak,
user-name=keycloak,
password=keycloak,
max-pool-size=15,
min-pool-size=5
)
如果我将其与jboss-cli.sh
一起使用connection-url=jdbc:mysql://localhost:3306/keycloak?useSSL=false
我得到此错误
{
"outcome" => "failed",
"failure-description" => "WFLYCTL0097: Wrong type for 'connection-url'. Expected [EXPRESSION, STRING] but was OBJECT",
"rolled-back" => true
}
有没有办法通过jboss-cli.sh?
该行失败,因为它包含双重分配。您应该逃脱URL查询的符号(useSSL=false
(。
这个:
[standalone@localhost:9990 /] /subsystem=datasources/data-source=KeycloakMysqlDS:add(
> jndi-name=java:jboss/datasources/KeycloakMysqlDS,
> driver-name=mysql,
> connection-url=jdbcmysql://localhost:3306/keycloak?useSSL=false,
> user-name=keycloak,
> password=keycloak,
> max-pool-size=15,
> min-pool-size=5
> )
{
"outcome" => "success",
"response-headers" => {"process-state" => "reload-required"}
}
应该工作。