OpenConcerto

Code : Tout sélectionner

Erreur de connexion à la base de données

Impossible d'obtenir une connexion sur jdbc:postgresql://127.0.0.1:5432/OpenConcerto: Cannot create PoolableConnectionFactory (Connexion refusée. Vérifiez que le nom de machine et le port sont corrects et que postmaster accepte les connexions TCP/IP.)
org.openconcerto.utils.ExceptionHandler: Erreur de connexion à la base de données
	at org.openconcerto.utils.ExceptionHandler.die(ExceptionHandler.java:106)
	at org.openconcerto.erp.config.Gestion.main(Gestion.java:219)
Caused by: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:postgresql://127.0.0.1:5432/OpenConcerto: Cannot create PoolableConnectionFactory (Connexion refusée. Vérifiez que le nom de machine et le port sont corrects et que postmaster accepte les connexions TCP/IP.)
	at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1093)
	at org.openconcerto.sql.model.SQLDataSource.borrowConnection(SQLDataSource.java:1032)
	at org.openconcerto.sql.model.SQLDataSource.getNewConnection(SQLDataSource.java:1014)
	at org.openconcerto.sql.model.SQLDataSource$QueryInfo.<init>(SQLDataSource.java:538)
	at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:444)
	at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:396)
	at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1352)
	at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1334)
	at org.openconcerto.sql.model.DBSystemRoot.setRootPathFromDS(DBSystemRoot.java:456)
	at org.openconcerto.sql.model.DBSystemRoot.setDS(DBSystemRoot.java:452)
	at org.openconcerto.sql.model.SQLBase.<init>(SQLBase.java:126)
	at org.openconcerto.sql.model.PGSQLBase.<init>(PGSQLBase.java:24)
	at org.openconcerto.sql.model.SQLSyntaxPG.createBase(SQLSyntaxPG.java:339)
	at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:370)
	at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:358)
	at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:419)
	at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:397)
	at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:378)
	at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:466)
	at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:535)
	at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:779)
	at org.openconcerto.erp.config.Gestion.main(Gestion.java:216)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connexion refusée. Vérifiez que le nom de machine et le port sont corrects et que postmaster accepte les connexions TCP/IP.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.openconcerto.sql.model.SQLDataSource.createDataSource(SQLDataSource.java:1120)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1076)
	... 21 more
Caused by: org.postgresql.util.PSQLException: Connexion refusée. Vérifiez que le nom de machine et le port sont corrects et que postmaster accepte les connexions TCP/IP.
	at org.postgresql.Driver$ConnectThread.getResult(Driver.java:348)
	at org.postgresql.Driver.connect(Driver.java:271)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
	... 24 more
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.access$100(Driver.java:47)
	at org.postgresql.Driver$ConnectThread.run(Driver.java:308)
	at java.lang.Thread.run(Unknown Source)

Code : Tout sélectionner

PSQLException: Connexion refusée. Vérifiez que le nom de machine et le port sont corrects et que postmaster accepte les connexions TCP/IP