Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error configuring for database mariadb #993

Closed
publicocean0 opened this issue Nov 29, 2022 · 1 comment
Closed

Error configuring for database mariadb #993

publicocean0 opened this issue Nov 29, 2022 · 1 comment
Assignees
Labels
status: duplicate A duplicate of another issue

Comments

@publicocean0
Copy link

Describe the bug
I tryed to configure with mariadb . I created the 3 tables as defined in the folder resources in the project. The fields with datatype timestamp dont accept default null. In addition when i try to login in the app client appears the error below.

To Reproduce
try to login

Expected behavior
error during login

Sample

Caused by: java.sql.SQLSyntaxErrorException: (conn=34) Could not convert [{"@Class":"java.util.Collections$UnmodifiableMap","java.security.Principal":{"@Class":"org.springframework.security.authentication.UsernamePasswordAuthenticationToken","authorities":["java.util.Collections$UnmodifiableRandomAccessList",[{"@Class":"org.springframework.security.core.authority.SimpleGrantedAuthority","authority":"ROLE_USER"}]],"details":{"@Class":"org.springframework.security.web.authentication.WebAuthenticationDetails","remoteAddress":"0:0:0:0:0:0:0:1","sessionId":"8DFC9AB94CC27404DACA40DE225C3C6F"},"authenticated":true,"principal":{"@Class":"org.springframework.security.core.userdetails.User","password":null,"username":"user1","authorities":["java.util.Collections$UnmodifiableSet",[{"@Class":"org.springframework.security.core.authority.SimpleGrantedAuthority","authority":"ROLE_USER"}]],"accountNonExpired":true,"accountNonLocked":true,"credentialsNonExpired":true,"enabled":true},"credentials":null},"org.springframework.security.oauth2.core.endpoint.OAuth2AuthorizationRequest":{"@Class":"org.springframework.security.oauth2.core.endpoint.OAuth2AuthorizationRequest","authorizationUri":"http://localhost:9000/oauth2/authorize","authorizationGrantType":{"value":"authorization_code"},"responseType":{"value":"code"},"clientId":"messaging-client","redirectUri":"http://127.0.0.1:8080/login/oauth2/code/messaging-client-oidc","scopes":["java.util.Collections$UnmodifiableSet",["openid","profile"]],"state":"YjEMJ2JDHIBp3fXgI_0ONWGj-C4rXkp1Nhxv76lBk5k=","additionalParameters":{"@Class":"java.util.Collections$UnmodifiableMap","nonce":"FRpIQzY0EJkXkQ-52ZsSZR9SkSUACAMpbQG-A3pg-DQ"},"authorizationRequestUri":"http://localhost:9000/oauth2/authorize?response_type=code&client_id=messaging-client&scope=openid%20profile&state=YjEMJ2JDHIBp3fXgI_0ONWGj-C4rXkp1Nhxv76lBk5k%3D&redirect_uri=http://127.0.0.1:8080/login/oauth2/code/messaging-client-oidc&nonce=FRpIQzY0EJkXkQ-52ZsSZR9SkSUACAMpbQG-A3pg-DQ","attributes":{"@Class":"java.util.Collections$UnmodifiableMap"}},"state":"cfUaG3bvcm-F3DCJHTv2jpI50ZLGJuaVFFP0ZLpxlgE="}] to -4

@publicocean0 publicocean0 added the type: bug A general bug label Nov 29, 2022
@jgrandja
Copy link
Collaborator

jgrandja commented Dec 9, 2022

@publicocean0 Closing this as a duplicate of gh-774.

For additional details, please see this comment.

@jgrandja jgrandja closed this as completed Dec 9, 2022
@jgrandja jgrandja self-assigned this Dec 9, 2022
@jgrandja jgrandja added status: duplicate A duplicate of another issue and removed type: bug A general bug labels Dec 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: duplicate A duplicate of another issue
Projects
None yet
Development

No branches or pull requests

2 participants