<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Seems I found the problem.<div class="">Openshift has old Postgres JDBC driver (8.4, JDBC 3) Should be 9.2 JDBC4. (See <a href="https://access.redhat.com/articles/111663" class="">https://access.redhat.com/articles/111663</a>)<br class=""><div class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class="Apple-interchange-newline">Thanks,</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Libor Krzyžanek</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="http://jboss.org" class="">jboss.org</a> Development Team</div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On 25 Mar 2015, at 11:15, Libor Krzyžanek <<a href="mailto:lkrzyzan@redhat.com" class="">lkrzyzan@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">When I switch to ExampleDS (H2 DB) everything works as expected.<div class=""><div class=""><br class="webkit-block-placeholder"></div><div class="">Doesn’t work with PostgreSQLDS</div><div class="">
<div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class="Apple-interchange-newline">Thanks,</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Libor Krzyžanek</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="http://jboss.org/" class="">jboss.org</a> Development Team</div>
</div>
<br class=""><div class=""><blockquote type="cite" class=""><div class="">On 25 Mar 2015, at 11:07, Libor Krzyžanek <<a href="mailto:lkrzyzan@redhat.com" class="">lkrzyzan@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">Hi,<br class="">I have the latest 1.2.0-Beta1 installation and I cannot login via admin/admin to master realm after fresh installation.<br class=""><br class="">I see tables in postgres but cannot login.<br class=""><br class="">Deployment is EAP 6.3 with proper modules + Postgres 9.2.8 (everything on Openshift, in keycloak-server.json I uses Openshift’s Postgres datasource defined in standalone.xml)<br class=""><br class="">I’m checking tables and I see<br class=""><br class="">keycloak=# select * from USER_ENTITY;<br class=""> id | email | email_constraint | email_verified | enabled | federation_link | first_name | last_name | realm_id | totp | username<br class="">--------------------------------------+-------+--------------------------------------+----------------+---------+-----------------+------------+-----------+----------+------+----------<br class=""> e8620950-494a-422a-9430-bf8a001b64b6 | | 05634ab8-5856-4587-a42b-9dadb1eef591 | f | t | | | | master | f | admin<br class="">(1 row)<br class=""><br class="">keycloak=# select * from credential where user_id='e8620950-494a-422a-9430-bf8a001b64b6';<br class=""> id | device | hash_iterations | salt | type | value | user_id<br class="">--------------------------------------+--------+-----------------+------------------------------------+----------+------------------------------------------------------------------------------------------+--------------------------------------<br class=""> 675d7483-746e-4195-a544-327027890492 | | 1 | \xa1a0aa3ca2e4ef65e26794805ed1248c | password | b8Ue+oLgrvdUWp4bzKAXoFfSli90ENUSPp439uIqks8iOMcMypjetKYbwZI8Qu1sTwXVZwdEJ6hVf/9hGa66FQ== | e8620950-494a-422a-9430-bf8a001b64b6<br class="">(1 row)<br class=""><br class="">However USERNAME_LOGIN_FAILURE is empty.<br class=""><br class="">rhdssodev2=# select * from USERNAME_LOGIN_FAILURE;<br class=""> realm_id | username | failed_login_not_before | last_failure | last_ip_failure | num_failures<br class="">----------+----------+-------------------------+--------------+-----------------+--------------<br class="">(0 rows)<br class=""><br class=""><br class="">Is it known issue?<br class=""><br class=""><br class="">Here is snippet from log:<br class="">2015/03/25 06:02:34,378 WARN [org.jboss.resteasy.core.ResourceLocator] (http-/127.5.255.129:8080-3) Field uriInfo of subresource org.keycloak.services.resources.LoginActionsService will not be injected according to spec<br class="">2015/03/25 06:02:34,378 WARN [org.jboss.resteasy.core.ResourceLocator] (http-/127.5.255.129:8080-3) Field clientConnection of subresource org.keycloak.services.resources.LoginActionsService will not be injected according to spec<br class="">2015/03/25 06:02:34,378 WARN [org.jboss.resteasy.core.ResourceLocator] (http-/127.5.255.129:8080-3) Field providers of subresource org.keycloak.services.resources.LoginActionsService will not be injected according to spec<br class="">2015/03/25 06:02:34,378 WARN [org.jboss.resteasy.core.ResourceLocator] (http-/127.5.255.129:8080-3) Field session of subresource org.keycloak.services.resources.LoginActionsService will not be injected according to spec<br class="">2015/03/25 06:02:34,423 DEBUG [org.keycloak.services.managers.AuthenticationManager] (http-/127.5.255.129:8080-3) validating password for user: admin<br class="">2015/03/25 06:02:34,424 DEBUG [org.keycloak.services.managers.AuthenticationManager] (http-/127.5.255.129:8080-3) Expiring remember me cookie<br class="">2015/03/25 06:02:34,425 DEBUG [org.keycloak.services.managers.AuthenticationManager] (http-/127.5.255.129:8080-3) Expiring cookie: KEYCLOAK_REMEMBER_ME path: /auth/realms/master<br class="">2015/03/25 06:02:34,431 DEBUG [freemarker.cache] (http-/127.5.255.129:8080-3) "template.ftl"["en_US",UTF-8,parsed] using cached since vfs:/content/ROOT.war/WEB-INF/lib/keycloak-forms-common-themes-1.2.0.Beta1-SNAPSHOT.jar/theme/base/login/template.ftl didn't change.<br class=""><br class=""><br class=""><br class="">Thanks,<br class=""><br class="">Libor Krzyžanek<br class=""><a href="http://jboss.org/" class="">jboss.org</a> Development Team<br class=""><br class=""><br class="">_______________________________________________<br class="">keycloak-dev mailing list<br class=""><a href="mailto:keycloak-dev@lists.jboss.org" class="">keycloak-dev@lists.jboss.org</a><br class=""><a href="https://lists.jboss.org/mailman/listinfo/keycloak-dev" class="">https://lists.jboss.org/mailman/listinfo/keycloak-dev</a></div></blockquote></div><br class=""></div></div>_______________________________________________<br class="">keycloak-dev mailing list<br class=""><a href="mailto:keycloak-dev@lists.jboss.org" class="">keycloak-dev@lists.jboss.org</a><br class="">https://lists.jboss.org/mailman/listinfo/keycloak-dev</div></blockquote></div><br class=""></div></body></html>