I am trying to “undo” ssl.
java -cp h2-1.4.197.jar org.h2.tools.Shell -url “jdbc:h2:/opt/keycloak/standalone/data/keycloak.mv.db” -user sa -password sa -sql “update realm set ssl_required=‘NONE’ where id = ‘master’”
Error: org.h2.jdbc.JdbcSQLException: Table “REALM” not found; SQL statement:
update realm set ssl_required=‘NONE’ where id = ‘master’ [42102-197]
I am running this on Ubuntu 20. I am no longer able to login to the master realm to undo this. Let me know if this helps.