Advertisement
Guest User

Untitled

a guest
Jul 8th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.29 KB | None | 0 0
  1. <datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true">
  2. <connection-url>jdbc:postgresql://{REMOTE_IP}:5432/keycloak</connection-url>
  3. <driver>postgresql</driver>
  4. <pool>
  5. <max-pool-size>20</max-pool-size>
  6. </pool>
  7. <security>
  8. <user-name>keycloak</user-name>
  9. <password>{PASSWORD}</password>
  10. </security>
  11. </datasource>
  12.  
  13. ...
  14. Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  15. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
  16. at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
  17. at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
  18. at org.postgresql.Driver.makeConnection(Driver.java:404)
  19. at org.postgresql.Driver.connect(Driver.java:272)
  20. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  21. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  22. at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:86)
  23. at org.postgresql.ds.PGPoolingDataSource.getConnection(PGPoolingDataSource.java:309)
  24. at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:312)
  25. ... 43 more
  26. Caused by: java.net.ConnectException: Connection refused (Connection refused)
  27. at java.net.PlainSocketImpl.socketConnect(Native Method)
  28. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  29. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  30. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  31. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  32. at java.net.Socket.connect(Socket.java:589)
  33. at org.postgresql.core.PGStream.<init>(PGStream.java:61)
  34. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
  35. ... 52 more
  36.  
  37. # psql -h {REMOTE_IP} keycloak keycloak
  38. psql (9.5.7)
  39. SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
  40. bits: 256, compression: off)
  41. Type "help" for help.
  42.  
  43. keycloak=>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement