Page 1 sur 1
connexion SSH
Posté : ven. août 28, 2020 8:28 am
par Jérôme76
Bonjour,
J'ai installé la version multipostes sur un serveur et je voudrai accéder à la base de données Postgres au travers d'un tunnel SSH.
J'ai suivi la procédure pour paramétrer le tunnel comme indiqué dans le manuel mais ça ne fonctionne pas. J'ai regardé dans les logs et il n'y a nul part de création de connexion SSH. Par contre ça fonctionne bien si je cré manuellement la connexion avec une redirection de port 5432.
Pouvez-vous m'aider ?
Salutations.
Re: connexion SSH
Posté : sam. août 29, 2020 1:04 pm
par guillaume
Bonjour,
Il faut regarder les logs d'OpenConcerto.
Sans infos, difficile de vous aider.
Cordialement,
Re: connexion SSH
Posté : dim. août 30, 2020 4:59 pm
par Jérôme76
Voici les derniers logs si ça peut vous aider :
août 30, 2020 6:43:33 PM org.openconcerto.sql.PropsConfiguration createServer
INFOS: Connecting with SSL to XX.XX.XX:22
août 30, 2020 6:43:34 PM org.postgresql.core.v3.ConnectionFactoryImpl log
AVERTISSEMENT: ConnectException occurred while connecting to 127.0.0.1:5432
java.net.ConnectException: Connexion refusée (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.base/java.net.Socket.connect(Socket.java:609)
at org.postgresql.core.PGStream.<init>(PGStream.java:69)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:156)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.access$100(Driver.java:61)
at org.postgresql.Driver$ConnectThread.run(Driver.java:362)
at java.base/java.lang.Thread.run(Thread.java:834)
août 30, 2020 6:43:34 PM org.postgresql.Driver connect
GRAVE: Connection error:
org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:403)
at org.postgresql.Driver.connect(Driver.java:261)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.openconcerto.sql.model.SQLDataSource$5.makeObject(SQLDataSource.java:1647)
at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1691)
at org.apache.commons.pool.impl.GenericObjectPool.ensureMinIdle(GenericObjectPool.java:1648)
at org.apache.commons.pool.impl.GenericObjectPool.access$700(GenericObjectPool.java:192)
at org.apache.commons.pool.impl.GenericObjectPool$Evictor.run(GenericObjectPool.java:1784)
at java.base/java.util.TimerThread.mainLoop(Timer.java:556)
at java.base/java.util.TimerThread.run(Timer.java:506)
Caused by: java.net.ConnectException: Connexion refusée (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.base/java.net.Socket.connect(Socket.java:609)
at org.postgresql.core.PGStream.<init>(PGStream.java:69)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:156)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.access$100(Driver.java:61)
at org.postgresql.Driver$ConnectThread.run(Driver.java:362)
at java.base/java.lang.Thread.run(Thread.java:834)
août 30, 2020 6:43:37 PM org.postgresql.core.v3.ConnectionFactoryImpl log
AVERTISSEMENT: ConnectException occurred while connecting to 127.0.0.1:5432
java.net.ConnectException: Connexion refusée (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.base/java.net.Socket.connect(Socket.java:609)
at org.postgresql.core.PGStream.<init>(PGStream.java:69)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:156)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.access$100(Driver.java:61)
at org.postgresql.Driver$ConnectThread.run(Driver.java:362)
at java.base/java.lang.Thread.run(Thread.java:834)
août 30, 2020 6:43:37 PM org.postgresql.Driver connect
GRAVE: Connection error:
org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:403)
at org.postgresql.Driver.connect(Driver.java:261)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.openconcerto.sql.model.SQLDataSource$5.makeObject(SQLDataSource.java:1647)
at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1691)
at org.apache.commons.pool.impl.GenericObjectPool.ensureMinIdle(GenericObjectPool.java:1648)
at org.apache.commons.pool.impl.GenericObjectPool.access$700(GenericObjectPool.java:192)
at org.apache.commons.pool.impl.GenericObjectPool$Evictor.run(GenericObjectPool.java:1784)
at java.base/java.util.TimerThread.mainLoop(Timer.java:556)
at java.base/java.util.TimerThread.run(Timer.java:506)
Caused by: java.net.ConnectException: Connexion refusée (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.base/java.net.Socket.connect(Socket.java:609)
at org.postgresql.core.PGStream.<init>(PGStream.java:69)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:156)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.access$100(Driver.java:61)
at org.postgresql.Driver$ConnectThread.run(Driver.java:362)
at java.base/java.lang.Thread.run(Thread.java:834)
août 30, 2020 6:43:37 PM org.postgresql.core.v3.ConnectionFactoryImpl log
AVERTISSEMENT: ConnectException occurred while connecting to 127.0.0.1:5432
java.net.ConnectException: Connexion refusée (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.base/java.net.Socket.connect(Socket.java:609)
at org.postgresql.core.PGStream.<init>(PGStream.java:69)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:156)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.access$100(Driver.java:61)
at org.postgresql.Driver$ConnectThread.run(Driver.java:362)
at java.base/java.lang.Thread.run(Thread.java:834)
août 30, 2020 6:43:37 PM org.postgresql.Driver connect
GRAVE: Connection error:
org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:403)
at org.postgresql.Driver.connect(Driver.java:261)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.openconcerto.sql.model.SQLDataSource$5.makeObject(SQLDataSource.java:1647)
at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1691)
at org.apache.commons.pool.impl.GenericObjectPool.ensureMinIdle(GenericObjectPool.java:1648)
at org.apache.commons.pool.impl.GenericObjectPool.access$700(GenericObjectPool.java:192)
at org.apache.commons.pool.impl.GenericObjectPool$Evictor.run(GenericObjectPool.java:1784)
at java.base/java.util.TimerThread.mainLoop(Timer.java:556)
at java.base/java.util.TimerThread.run(Timer.java:506)
Caused by: java.net.ConnectException: Connexion refusée (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.base/java.net.Socket.connect(Socket.java:609)
at org.postgresql.core.PGStream.<init>(PGStream.java:69)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:156)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.access$100(Driver.java:61)
at org.postgresql.Driver$ConnectThread.run(Driver.java:362)
at java.base/java.lang.Thread.run(Thread.java:834)
Re: connexion SSH
Posté : dim. sept. 06, 2020 11:10 am
par guillaume
Bonjour,
D’après les logs, la connexion ssh est établie mais la connexion au port 5432 est refusée,
il faut donc vérifier votre configuration de PostgreSQL (postgresql.conf et pg_hba.conf).
Cordialement,
Re: connexion SSH
Posté : dim. sept. 06, 2020 12:24 pm
par Jérôme76
Bonjour,
Pouvez-vous me dire quelle ligne dans les logs vous permet de dire que la connexion SSH est établie car quand je crée la connexion manuellement en intégrant le port 5432 dans le tunnel SSH, ça fonctionne très bien ?
Salutations.
Re: connexion SSH
Posté : dim. sept. 06, 2020 12:41 pm
par guillaume
INFOS: Connecting with SSL to XX.XX.XX:22
Indique que vous avez configuré le SSH correctement car pas d'erreur relative à la connexion ensuite.
De plus,
AVERTISSEMENT: ConnectException occurred while connecting to 127.0.0.1:5432
indique qu'OpenConcerto essaye bien de se connecter en local via le tunnel.
Cordialement,
Re: connexion SSH
Posté : dim. sept. 06, 2020 5:03 pm
par Jérôme76
Merci pour votre réponse.
Dans quel répertoire doit-on déposer les clefs SSH ?
Salutations.
Re: connexion SSH
Posté : lun. sept. 07, 2020 5:02 pm
par guillaume
Il n'y a pas de clef à mettre, la connexion ssh est faite avec les login/pass que vous configurez.
Cordialement,