How to connect postgreSQL17 using jhipster (Angular, postgreSQL17 and Java).

[ishwarsharma]

I wanted to login by using default jhipster admin but it is not connected with database, as you can see my
application-dev.yml code:

===================================================================

Spring Boot configuration for the "dev" profile.

This configuration overrides the application.yml file.

More information on profiles: https://www.jhipster.tech/profiles/

More information on configuration properties: https://www.jhipster.tech/common-application-properties/

===================================================================

===================================================================

Standard Spring Boot properties.

Full reference is available at:

http://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html

===================================================================

logging:
level:
ROOT: DEBUG
tech.jhipster: DEBUG
org.hibernate.SQL: DEBUG
com.mycompany.myapp: DEBUG

spring:
devtools:
restart:
enabled: true
additional-exclude: static/**
livereload:
enabled: false # we use Webpack dev server + BrowserSync for livereload
jackson:
serialization:
indent-output: true
datasource:
type: com.zaxxer.hikari.HikariDataSource
url: jdbc:postgresql://localhost:5433/erap_ishwar
username: postgres
password: admin123
hikari:
poolName: Hikari
auto-commit: false
liquibase:
# Remove 'faker' if you do not want the sample data to be loaded automatically
contexts: dev, faker
url: jdbc:postgresql://localhost:5433/erap_ishwar
mail:
host: localhost
port: 25
username: postgres
password: admin123
messages:
cache-duration: PT1S # 1 second, see the ISO 8601 standard
r2dbc:
url: r2dbc:postgresql://localhost:5433/erap_ishwar
username: postgres
password: admin123
thymeleaf:
cache: false

server:
port: 8080

make sure requests the proxy uri instead of the server one

forward-headers-strategy: native

===================================================================

JHipster specific properties

Full reference is available at: https://www.jhipster.tech/common-application-properties/

===================================================================

jhipster:

CORS is only enabled by default with the "dev" profile

cors:
# Allow Ionic for JHipster by default (* no longer allowed in Spring Boot 2.4+)
allowed-origins: 'http://localhost:8100,https://localhost:8100,http://localhost:9000,https://localhost:9000,http://localhost:4200,https://localhost:4200'
# Enable CORS when running in GitHub Codespaces
allowed-origin-patterns: 'https://.githubpreview.dev'
allowed-methods: ''
allowed-headers: '*'
exposed-headers: 'Authorization,Link,X-Total-Count,X-${jhipster.clientApp.name}-alert,X-${jhipster.clientApp.name}-error,X-${jhipster.clientApp.name}-params'
allow-credentials: true
max-age: 1800
security:
authentication:
jwt:
# This token must be encoded using Base64 and be at least 256 bits long (you can type openssl rand -base64 64 on your command line to generate a 512 bits one)
base64-secret: MGI0MzhkMDgzODBhYjllYmM5MDkwNTliOGQxNGViNWQyNjRkMDgxMDIxZDY0OWNkY2ZkZTgyOWY5Nzc0NWY1NzNiYzdiMWI5YWJmOWZkOWJhNTZjYmJkM2I1MTYyZjJkNzUwYjZmYjA1N2RiNWQzMzljZmY1NDFjMGFkMWMxNjM=
# Token is valid 24 hours
token-validity-in-seconds: 86400
token-validity-in-seconds-for-remember-me: 2592000
mail: # specific JHipster mail property, for standard properties see MailProperties
base-url: http://127.0.0.1:8080
logging:
use-json-format: false # By default, logs are not in Json format
logstash: # Forward logs to logstash over a socket, used by LoggingConfiguration
enabled: false
host: localhost
port: 5000
ring-buffer-size: 512

===================================================================

Application specific properties

Add your own application properties here, see the ApplicationProperties class

to have type-safe configuration, like in the JHipsterProperties above

More documentation is available at:

https://www.jhipster.tech/common-application-properties/

===================================================================

application:

This is my frontend code when I try to login or register it shows an error:

This is your homepage

<div>
  @if (account() !== null) {
    <div class="alert alert-success">
      @if (account(); as accountRef) {
        <span id="home-logged-message">You are logged in as user &quot;{{ accountRef.login }}&quot;.</span>
      }
    </div>
  } @else {
    <div class="alert alert-warning">
      <span>If you want to </span>
      <a class="alert-link" (click)="login()">sign in</a>
      <!-- <span
        >, you can try the default accounts:<br />- Administrator (login=&quot;admin&quot; and password=&quot;admin&quot;) <br />- User
        (login=&quot;user&quot; and password=&quot;user&quot;).</span
      > -->
    </div>

    <div class="alert alert-warning">
      <span>You don&apos;t have an account yet?</span>&nbsp;
      <a class="alert-link" routerLink="/account/register">Register a new account</a>
    </div>
  }
</div>

As you can see my postgresSQl 17 database with name erap_ishwar but why it is not connect with the frontend....