Connect Error due to MYSQL_USER not being root in DEV Mode (mariadb)

[dminkovski]

Describe the bug JDL Setup

application { config { baseName gateway, applicationType gateway, packageName com.test.application, authenticationType oauth2, prodDatabaseType mariadb, databaseType sql, devDatabaseType mariadb, serverPort 8080, clientFramework react, blueprint quarkus, buildTool maven, languages [en, de], nativeLanguage en, serviceDiscoveryType eureka, skipUserManagement true, } }

When you setup the quarkus application and use mariadb you get a connect error because the default user of the properties is the application name whereas the config yml uses root as the username. This can easily be fixed by changing the username to root.

%dev.quarkus.datasource.username=root

To Reproduce

1. RUN jhipster-quarkus jdl .\jhipster-jdl.jdl (authenticationType oauth2)
2. RUN jhipster-quarkus docker-compose
3. Go to src/main/docker and RUN docker-compose -f .\mariadb.yml up
4. Go to gateway folder and RUN .\mvnw
5. Error in connecting to the database

Expected behavior Connection to the datatabase works and the application starts up.

Screenshots

Desktop:

• OS: Windows 10

[dminkovski]

This would be fixed in the PR : Added new keycloak realm config jsons for quarkus authorization bug #169

[avdev4j]

is it related to it ?

https://github.com/jhipster/generator-jhipster/pull/14477#issuecomment-808906522