J823 Posted January 19, 2021 Posted January 19, 2021 myjdbc url jdbc:postgresql://tommy.heliohost.org/newfire_login?verifyServerCertificate=false&requiredSSL=false i am using spring security and jdbc to connect with postgressql databasewhich i am using on my local machine to coonect with postgresql db on heliohost username=newfire error org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "49.33.215.146", user "newfire_root", database "newfire_login", SSL off at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.Driver.makeConnection(Driver.java:454) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.Driver.connect(Driver.java:256) ~[postgresql-42.2.5.jar:42.2.5] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) ~[HikariCP-2.7.9.jar:na] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123) ~[HikariCP-2.7.9.jar:na] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) ~[HikariCP-2.7.9.jar:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) ~[HikariCP-2.7.9.jar:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) [HikariCP-2.7.9.jar:na] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:534) [HikariCP-2.7.9.jar:na] at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-2.7.9.jar:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-2.7.9.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151) [spring-jdbc-5.0.11.RELEASE.jar:5.0.11.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) [spring-jdbc-5.0.11.RELEASE.jar:5.0.11.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) [spring-jdbc-5.0.11.RELEASE.jar:5.0.11.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:600) [spring-jdbc-5.0.11.RELEASE.jar:5.0.11.RELEASE]
wolstech Posted January 19, 2021 Posted January 19, 2021 We don't allow remote access by default. Krydos has to specifically enable it if you want it. Since the username and database name are in the error, I'll escalate this to be set up. 1
OnEnemy Posted January 20, 2021 Posted January 20, 2021 please allow remote access connectionPlease remain patient. Krydos will enable access when he sees this post.
J823 Posted January 21, 2021 Author Posted January 21, 2021 please Enable remote connection for postgresql database username newfire database_name newfire_login jdbc:postgresql://tommy.heliohost.org/newfire_login?
OnEnemy Posted January 21, 2021 Posted January 21, 2021 This support request is being escalated to our root admins.
Recommended Posts