Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Strange error message when connecting to repository

  1. #1
    Join Date
    Aug 2007
    Posts
    151

    Default Strange error message when connecting to repository

    Hi!

    I was configuring a newly installed 2.5.1 Kettle to access a PostgreSQL repository that exists and I know it works (from another machine's connection). But all I get is the below error. My db is in IP "A", but Kettle complains about a completely different IP. Whay?
    ---
    Error connecting to database [XXXXX] : be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class org.postgresql.Driver)
    FATAL: no pg_hba.conf entry for host "10.15.7.193", user "XXXXX", database "XXXXX"


    be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class org.postgresql.Driver)
    FATAL: no pg_hba.conf entry for host "10.15.7.193", user "XXXXX", database "XXXXX"


    at be.ibridge.kettle.core.database.Database.normalConnect(Database.java:301)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:250)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:212)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:202)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(DatabaseDialog.java:1904)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:158)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:147)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3673)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3284)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:111)
    at be.ibridge.kettle.spoon.Spoon.createDatabaseWizard(Spoon.java:6879)
    at be.ibridge.kettle.spoon.Spoon.access$100(Spoon.java:234)
    at be.ibridge.kettle.spoon.Spoon$81.widgetSelected(Spoon.java:2566)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3673)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3284)
    at be.ibridge.kettle.spoon.Spoon.readAndDispatch(Spoon.java:964)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:7372)
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error connecting to database: (using class org.postgresql.Driver)
    FATAL: no pg_hba.conf entry for host "10.15.7.193", user "XXXXX", database "XXXXX"

    at be.ibridge.kettle.core.database.Database.connectUsingClass(Database.java:418)
    at be.ibridge.kettle.core.database.Database.normalConnect(Database.java:285)
    ... 24 more
    Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "XXXXX", user "XXXXX", database "XXXXX"
    at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:275)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
    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.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:382)
    at org.postgresql.Driver.connect(Driver.java:260)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at be.ibridge.kettle.core.database.Database.connectUsingClass(Database.java:399)
    ... 25 more

    Hostname : "A"
    Port : 5432
    Database name : XXXXX

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Have a look at the ktr file with a file editor... search for the offending IP address.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.