[Solved] Remote access to database

[alexromanelli]

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

[OnEnemy]

This support request is being escalated to our root admins.

[alexromanelli]

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)

 

[wolstech]

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.

[alexromanelli]

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

[Krydos]

Remote access enabled. Use the host 65.19.141.77