Hi @violetdragon,
I’m sorry you are having difficulties. It looks like your user does not have permission on the scheme you want to work on.
Grant Schema Permissions: Ensure that the user has the necessary permissions (USAGE, CREATE, CONNECT, etc.) on the public schema. You can grant permissions using SQL commands like:
GRANT USAGE ON SCHEMA public TO your_user;
But this seems a bit off. You may want to double-check your JDBC connection URL to ensure it specifies the correct database name, user, and password.
Also would be way more easier to use Keycloak on docker container.
install docker from here (if you don’t already have it.)
GitHub - HarunOr/keycloak-compose: Keycloak based on the PostgreSQL database with Prometheus monitoring that visualize data in Grafana - This one is with PostgreSQL
GitHub - ozdemirrulass/keycloak-compose: Keycloak based on the MYSQL database with Prometheus monitoring that visualize data in Grafana - This one is with MySQL
Simply clone the repo you want to run, configure the versions you want and get the project up using the command in the repository explanation. It seems like you are new and this way is way easier to setup and experiment on it.
PS: You can get rid of prometheus and grafana they are just monitoring tools but also fun to play with I’d keep it 