alexromanelli Posted November 3, 2023 Share Posted November 3, 2023 Hi, everyone. I need remote access to my PostgreSQL database at 65.19.141.77:5432 (or through domain name resolution), named alexromanelli_chuchu, with username alexromanelli_chuchuzao. []'s Link to comment Share on other sites More sharing options...
Talk Sick Posted November 3, 2023 Share Posted November 3, 2023 This support request is being escalated to our root admins. Link to comment Share on other sites More sharing options...
alexromanelli Posted November 4, 2023 Author Share Posted November 4, 2023 I am trying to connect remotely using DBeaver, which uses PostgreSQL JDBC Driver, and the following error message is displayed. I should ask you, friends, if I need to add all the configuration files for PostgreSQL. In the affirmative case, I'd need to know where is the correct location for them. FATAL: no pg_hba.conf entry for host "177.39.24.7", user "alexromanelli_chuchuzao", database "alexromanelli_chuchu", SSL on org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "177.39.24.7", user "alexromanelli_chuchuzao", database "alexromanelli_chuchu", SSL on at org.postgresql.Driver$ConnectThread.getResult(Driver.java:385) at org.postgresql.Driver.connect(Driver.java:298) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.lambda$1(JDBCDataSource.java:246) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.lambda$0(JDBCDataSource.java:259) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.openConnection(JDBCDataSource.java:278) at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.openConnection(PostgreDataSource.java:551) at org.jkiss.dbeaver.model.impl.jdbc.JDBCExecutionContext.connect(JDBCExecutionContext.java:103) at org.jkiss.dbeaver.model.impl.jdbc.JDBCRemoteInstance.initializeMainContext(JDBCRemoteInstance.java:102) at org.jkiss.dbeaver.ext.postgresql.model.PostgreDatabase.checkInstanceConnection(PostgreDatabase.java:233) at org.jkiss.dbeaver.ext.postgresql.model.PostgreDatabase.<init>(PostgreDatabase.java:120) at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.createDatabaseImpl(PostgreDataSource.java:277) at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.initializeRemoteInstance(PostgreDataSource.java:172) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.<init>(JDBCDataSource.java:107) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.<init>(JDBCDataSource.java:98) at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.<init>(PostgreDataSource.java:105) at org.jkiss.dbeaver.ext.postgresql.PostgreDataSourceProvider.openDataSource(PostgreDataSourceProvider.java:114) at org.jkiss.dbeaver.registry.DataSourceDescriptor.openDataSource(DataSourceDescriptor.java:1280) at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect0(DataSourceDescriptor.java:1117) at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect(DataSourceDescriptor.java:950) at org.jkiss.dbeaver.runtime.jobs.ConnectJob.run(ConnectJob.java:77) at org.jkiss.dbeaver.runtime.jobs.ConnectJob.runSync(ConnectJob.java:104) at org.jkiss.dbeaver.ui.actions.datasource.DataSourceHandler.connectToDataSource(DataSourceHandler.java:115) at org.jkiss.dbeaver.ui.actions.datasource.UIServiceConnectionsImpl.initConnection(UIServiceConnectionsImpl.java:87) at org.jkiss.dbeaver.model.DBUtils.initDataSource(DBUtils.java:2535) at org.jkiss.dbeaver.model.navigator.DBNDataSource.initializeNode(DBNDataSource.java:151) at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:225) at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:1) at org.jkiss.dbeaver.model.navigator.DBNUtils.getNodeChildrenFiltered(DBNUtils.java:91) at org.jkiss.dbeaver.ui.navigator.database.load.TreeLoadService.evaluate(TreeLoadService.java:49) at org.jkiss.dbeaver.ui.navigator.database.load.TreeLoadService.evaluate(TreeLoadService.java:1) at org.jkiss.dbeaver.ui.LoadingJob.run(LoadingJob.java:88) at org.jkiss.dbeaver.ui.LoadingJob.run(LoadingJob.java:72) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Suppressed: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "177.39.24.7", user "alexromanelli_chuchuzao", database "alexromanelli_chuchu", SSL off at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:693) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:203) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:267) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:253) at org.postgresql.Driver.makeConnection(Driver.java:434) at org.postgresql.Driver.access$100(Driver.java:61) at org.postgresql.Driver$ConnectThread.run(Driver.java:344) at java.base/java.lang.Thread.run(Thread.java:840) Link to comment Share on other sites More sharing options...
wolstech Posted November 4, 2023 Share Posted November 4, 2023 That message is what you get when the remote access is not enabled on our end. It hasn't been set up yet. Krydos will post here when it's been completed. I'm not sure how quickly this will be worked as he has been dealing with a server outage for some of our VPS customers. Link to comment Share on other sites More sharing options...
alexromanelli Posted November 4, 2023 Author Share Posted November 4, 2023 2 hours ago, wolstech said: That message is what you get when the remote access is not enabled on our end. It hasn't been set up yet. Krydos will post here when it's been completed. I'm not sure how quickly this will be worked as he has been dealing with a server outage for some of our VPS customers. No problem at all, man Link to comment Share on other sites More sharing options...
Krydos Posted November 4, 2023 Share Posted November 4, 2023 Remote access enabled. Use the host 65.19.141.77 Link to comment Share on other sites More sharing options...
Recommended Posts