[keycloak-user] keycloak database

[Andrew Meyer]

 I found my problem:
2019-03-27 15:29:53,192 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([    ("subsystem" => "datasources"),    ("data-source" => "Keycloak1DS")]) - failure description: {    "WFLYCTL0412: Required services that are not installed:" => [        "jboss.jdbc-driver.mysql",        "jboss.jdbc-driver.mysql"    ],    "WFLYCTL0180: Services with missing/unavailable dependencies" => [        "jboss.driver-demander.java:jboss/datasources/mysqlDS is missing [jboss.jdbc-driver.mysql]",        "org.wildfly.data-source.Keycloak1DS is missing [jboss.jdbc-driver.mysql]",        "org.wildfly.data-source.Keycloak1DS is missing [jboss.jdbc-driver.mysql]"    ]}


I don't understand why i'm getting this error.  The driver is there.
    On Wednesday, March 27, 2019, 4:06:51 PM CDT, Andrew Meyer <andrewm659 at yahoo.com> wrote:  
 
 Hmm...here is what my database config looks like.
Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 48002Server version: 10.1.38-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use keycloak;Database changedMariaDB [keycloak]> SELECT @@character_set_database, @@collation_database;+--------------------------+----------------------+| @@character_set_database | @@collation_database |+--------------------------+----------------------+| utf8                     | utf8_unicode_ci      |+--------------------------+----------------------+1 row in set (0.00 sec)
MariaDB [keycloak]> 
Is there something else I need to do to populate the database?

Sent from Yahoo Mail on Android 
 
  On Wed, Mar 27, 2019 at 2:22 PM, Marek Posolda<mposolda at redhat.com> wrote:   On 27/03/2019 19:50, Andrew Meyer wrote:
> So I've created the keycloak database, but when I login to the admin side and set it all up should there be any other databases/tables that get added to MariaDB/MySQL/ or PostGreSQL?
> I see a blank database.  Did I miss something?

Yes, you should see tables in the DB after you start Keycloak and login 
to admin console. If you don't see it, you probably configured the DB 
wrongly or you're looking at some bad place?

Marek

> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user