ADempiere ERP Business Suite / Discussion / Help: Error JDBC connection (Win 8.1)

A full ERP system - moved to GitHub. See full description for details.

Error JDBC connection (Win 8.1)

Forum: Help

Creator: SonBH

Created: 2018-04-10

Updated: 2018-04-11

SonBH - 2018-04-10

Hi guy,
I have a problem with adempiere installation (Windows 8.1 pro),
I see the following message in the DOS prompt
2018-04-10 20:45:15.021 Adempiere Log (CLogFile)
20:45:15.020 CLogMgt.setLevel: CONFIG [1]
20:45:15.430 Setup.<init>: ADempiere(r) Release 3.9.0_2017-08-01 -Smart Suite ERP,CRM and SCM- (c) 1999-2017 ADempiere(r); Implementation: ADempiere 20170801-2141 - ADempiere [1]
20:45:15.573 ConfigurationData.load: Defaults [1]
20:46:32.504 Config.test: OK: JavaHome=C:\Program Files\Java\jdk1.8.0_121 [26]
20:46:32.505 ConfigurationData.testAdempiere: OK: AdempiereHome = C:\Adempiere [26]
20:46:32.575 KeyStoreMgt.<init>: C:\Adempiere\keystore\myKeystore [26]
20:46:32.817 KeyStoreMgt.getCertificate: Alias=adempiere [26]
20:46:32.828 ConfigurationData.testAdempiere: OK: KeyStore = C:\Adempiere\keystore\myKeystore [26]
20:46:32.832 Config.test: OK: AppsServer = Developer/192.168.0.102 [26]
20:46:32.833 Config.test: OK: Deploy Directory = C:\Adempiere\tomcat\webapps [26]
20:46:34.047 Config.test: OK: Web Port = 8888 [26]
20:46:38.858 Config.test: OK: SSL Port = 4444 [26]
20:46:38.859 Config.test: OK: Database Server = Developer/192.168.0.102 [26]
20:46:38.861 Config.test: OK: Database Port = 5432 [26]
===========> Driver.connect: Connection error: [26]
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "192.168.0.102", user "postgres", database "template1", SSL off; State=28000; ErrorCode=0
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:431)
at org.postgresql.Driver.connect(Driver.java:247)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.compiere.db.DB_PostgreSQL.getDriverConnection(DB_PostgreSQL.java:641)
at org.compiere.install.ConfigPostgreSQL.testJDBC(ConfigPostgreSQL.java:175)
at org.compiere.install.ConfigPostgreSQL.test(ConfigPostgreSQL.java:120)
at org.compiere.install.ConfigurationData.testDatabase(ConfigurationData.java:1444)
at org.compiere.install.ConfigurationData.test(ConfigurationData.java:400)
at org.compiere.install.ConfigurationPanel.test(ConfigurationPanel.java:666)
at org.compiere.install.ConfigurationPanel.access$400(ConfigurationPanel.java:62)
at org.compiere.install.ConfigurationPanel$1.construct(ConfigurationPanel.java:625)
at org.compiere.apps.SwingWorker$2.run(SwingWorker.java:68)

===========> Driver.connect: Connection error: [26]
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "192.168.0.102", user "postgres", database "template1", SSL off; State=28000; ErrorCode=0
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:431)
at org.postgresql.Driver.connect(Driver.java:247)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.compiere.db.DB_PostgreSQL.getDriverConnection(DB_PostgreSQL.java:641)
at org.compiere.install.ConfigPostgreSQL.testJDBC(ConfigPostgreSQL.java:175)
at org.compiere.install.ConfigPostgreSQL.test(ConfigPostgreSQL.java:120)
at org.compiere.install.ConfigurationData.testDatabase(ConfigurationData.java:1444)
at org.compiere.install.ConfigurationData.test(ConfigurationData.java:400)
at org.compiere.install.ConfigurationPanel.test(ConfigurationPanel.java:666)
at org.compiere.install.ConfigurationPanel.access$400(ConfigurationPanel.java:62)
at org.compiere.install.ConfigurationPanel$1.construct(ConfigurationPanel.java:625)
at org.compiere.apps.SwingWorker$2.run(SwingWorker.java:68)

===========> Config.testJDBC: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "192.168.0.102", user "postgres", database "template1", SSL off [26]
-----------> ConfigurationData.test: Error connecting: jdbc:postgresql://Developer:5432/template1 - postgres/adempiere [26]
===========> ConfigurationPanel$1.finished: Error JDBC Connection
(Error connecting: jdbc:postgresql://Developer:5432/template1 - postgres/adempiere) [16]
========================================================
Any ideas on where to look to solve this problem?
Thanks!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- John Agudelo - 2018-04-11
  
  You need configure access of portgres in
  pg_hba.conf
  El El mar, 10 de abr. de 2018 a las 9:11 a. m., SonBH sonbh@users.sourceforge.net escribió:
  
  Hi guy,
  I have a problem with adempiere installation (Windows 8.1 pro),
  I see the following message in the DOS prompt
  2018-04-10 20:45:15.021 Adempiere Log (CLogFile)
  20:45:15.020 CLogMgt.setLevel: CONFIG [1]
  20:45:15.430 Setup.<init>: ADempiere(r) Release 3.9.0_2017-08-01 -Smart
  Suite ERP,CRM and SCM- (c) 1999-2017 ADempiere(r); Implementation:
  ADempiere 20170801-2141 - ADempiere [1]
  20:45:15.573 ConfigurationData.load: Defaults [1]
  20:46:32.504 Config.test: OK: JavaHome=C:\Program Files\Java\jdk1.8.0_121
  [26]
  20:46:32.505 ConfigurationData.testAdempiere: OK: AdempiereHome =
  C:\Adempiere [26]
  20:46:32.575 KeyStoreMgt.<init>: C:\Adempiere\keystore\myKeystore [26]
  20:46:32.817 KeyStoreMgt.getCertificate: Alias=adempiere [26]
  20:46:32.828 ConfigurationData.testAdempiere: OK: KeyStore =
  C:\Adempiere\keystore\myKeystore [26]
  20:46:32.832 Config.test: OK: AppsServer = Developer/192.168.0.102 [26]
  20:46:32.833 Config.test: OK: Deploy Directory =
  C:\Adempiere\tomcat\webapps [26]
  20:46:34.047 Config.test: OK: Web Port = 8888 [26]
  20:46:38.858 Config.test: OK: SSL Port = 4444 [26]
  20:46:38.859 Config.test: OK: Database Server = Developer/192.168.0.102
  [26]
  20:46:38.861 Config.test: OK: Database Port = 5432 [26]
  ===========> Driver.connect: Connection error: [26]
  org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host
  "192.168.0.102", user "postgres", database "template1", SSL off;
  State=28000; ErrorCode=0
  at
  org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
  at
  org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
  at
  org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
  at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
  at org.postgresql.Driver.makeConnection(Driver.java:431)
  at org.postgresql.Driver.connect(Driver.java:247)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at
  org.compiere.db.DB_PostgreSQL.getDriverConnection(DB_PostgreSQL.java:641)
  at
  org.compiere.install.ConfigPostgreSQL.testJDBC(ConfigPostgreSQL.java:175)
  at org.compiere.install.ConfigPostgreSQL.test(ConfigPostgreSQL.java:120)
  at
  org.compiere.install.ConfigurationData.testDatabase(ConfigurationData.java:1444)
  at org.compiere.install.ConfigurationData.test(ConfigurationData.java:400)
  at
  org.compiere.install.ConfigurationPanel.test(ConfigurationPanel.java:666)
  at
  org.compiere.install.ConfigurationPanel.access$400(ConfigurationPanel.java:62)
  at
  org.compiere.install.ConfigurationPanel$1.construct(ConfigurationPanel.java:625)
  at org.compiere.apps.SwingWorker$2.run(SwingWorker.java:68)
  
  ===========> Driver.connect: Connection error: [26]
  org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host
  "192.168.0.102", user "postgres", database "template1", SSL off;
  State=28000; ErrorCode=0
  at
  org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
  at
  org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
  at
  org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
  at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
  at org.postgresql.Driver.makeConnection(Driver.java:431)
  at org.postgresql.Driver.connect(Driver.java:247)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at
  org.compiere.db.DB_PostgreSQL.getDriverConnection(DB_PostgreSQL.java:641)
  at
  org.compiere.install.ConfigPostgreSQL.testJDBC(ConfigPostgreSQL.java:175)
  at org.compiere.install.ConfigPostgreSQL.test(ConfigPostgreSQL.java:120)
  at
  org.compiere.install.ConfigurationData.testDatabase(ConfigurationData.java:1444)
  at org.compiere.install.ConfigurationData.test(ConfigurationData.java:400)
  at
  org.compiere.install.ConfigurationPanel.test(ConfigurationPanel.java:666)
  at
  org.compiere.install.ConfigurationPanel.access$400(ConfigurationPanel.java:62)
  at
  org.compiere.install.ConfigurationPanel$1.construct(ConfigurationPanel.java:625)
  at org.compiere.apps.SwingWorker$2.run(SwingWorker.java:68)
  
  ===========> Config.testJDBC: org.postgresql.util.PSQLException: FATAL: no
  pg_hba.conf entry for host "192.168.0.102", user "postgres", database
  "template1", SSL off [26]
  -----------> ConfigurationData.test: Error connecting:
  jdbc:postgresql://Developer:5432/template1 - postgres/adempiere [26]
  ===========> ConfigurationPanel$1.finished: Error JDBC Connection
  (Error connecting: jdbc:postgresql://Developer:5432/template1 -
  postgres/adempiere) [16]
  ========================================================
  Any ideas on where to look to solve this problem?
  Thanks!
  ------------------------------
  
  Error JDBC connection (Win 8.1)
  https://sourceforge.net/p/adempiere/discussion/610547/thread/c90535d3/?limit=25#6e22
  
  Sent from sourceforge.net because you indicated interest in
  https://sourceforge.net/p/adempiere/discussion/610547/
  
  To unsubscribe from further messages, please visit
  https://sourceforge.net/auth/subscriptions/
  
  alternate
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Error JDBC connection (Win 8.1)

A full ERP system - moved to GitHub. See full description for details.

Forums

Help

Error JDBC connection (Win 8.1) document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Error JDBC connection (Win 8.1)