GIS › udig-users

FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gis_maps"

3 messages Options
Embed this post
Permalink
Nicholas I

FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gis_maps"

Reply Threaded More More options
Print post
Permalink
Hi,


 when i try to connect to postgis, from udig i get the following error. any idea please.

Error:

 SEVERE: Could not obtain PostgisDBInfo
org.geotools.data.DataSourceException: Connection failed:org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gisdb"
    at org.geotools.data.jdbc.JDBC1DataStore.getConnection(JDBC1DataStore.java:1035)
    at org.geotools.data.postgis.PostgisDataStore.getTypeNames(PostgisDataStore.java:313)
    at net.refractions.udig.catalog.internal.postgis.PostGISServiceImpl.resources(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.EndConnectionState.run(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.Workflow.next(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.WorkflowWizardDialog$1.run(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.WorkflowWizardDialog$2.run(Unknown Source)
    at net.refractions.udig.ui.PlatformGIS$1.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gisdb"
    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:65)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
    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:369)
    at org.postgresql.Driver.connect(Driver.java:245)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:82)
    at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:65)
    at org.postgresql.ds.PGConnectionPoolDataSource.getPooledConnection(PGConnectionPoolDataSource.java:60)
    at org.geotools.data.jdbc.ConnectionPool.getConnection(ConnectionPool.java:122)
    at org.geotools.data.jdbc.JDBC2DataStore.createConnection(JDBC2DataStore.java:131)
    at org.geotools.data.jdbc.JDBC1DataStore.getConnection(JDBC1DataStore.java:1033)
    ... 12 more

-Nicholas I

_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Nicholas I

Re: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gis_maps"

Reply Threaded More More options
Print post
Permalink
The version that i am using her is, Udig Version: 1.1.0-SC1.

-Nicholas I


On Tue, Aug 18, 2009 at 1:29 PM, Nicholas I <[hidden email]> wrote:
Hi,


 when i try to connect to postgis, from udig i get the following error. any idea please.

Error:

 SEVERE: Could not obtain PostgisDBInfo
org.geotools.data.DataSourceException: Connection failed:org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gisdb"
    at org.geotools.data.jdbc.JDBC1DataStore.getConnection(JDBC1DataStore.java:1035)
    at org.geotools.data.postgis.PostgisDataStore.getTypeNames(PostgisDataStore.java:313)
    at net.refractions.udig.catalog.internal.postgis.PostGISServiceImpl.resources(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.EndConnectionState.run(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.Workflow.next(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.WorkflowWizardDialog$1.run(Unknown Source)
    at net.refractions.udig.catalog.ui.workflow.WorkflowWizardDialog$2.run(Unknown Source)
    at net.refractions.udig.ui.PlatformGIS$1.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gisdb"
    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:65)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
    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:369)
    at org.postgresql.Driver.connect(Driver.java:245)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:82)
    at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:65)
    at org.postgresql.ds.PGConnectionPoolDataSource.getPooledConnection(PGConnectionPoolDataSource.java:60)
    at org.geotools.data.jdbc.ConnectionPool.getConnection(ConnectionPool.java:122)
    at org.geotools.data.jdbc.JDBC2DataStore.createConnection(JDBC2DataStore.java:131)
    at org.geotools.data.jdbc.JDBC1DataStore.getConnection(JDBC1DataStore.java:1033)
    ... 12 more

-Nicholas I


_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Andrea Antonello

Re: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gis_maps"

Reply Threaded More More options
Print post
Permalink
This is not a udig problem, but your postgres configuration.

By default it permits to connected in trusted mode from localhost.

I note that:
no pg_hba.conf entry for host "127.0.1.1"

so I guess that for 127.0.1.1 a socket connection is not permitted,
i.e. it doesn't recognise the connection as coming from localhost.

You can check your host configuration or add an entry to the pg_hba.conf file.


Andrea


On Tue, Aug 18, 2009 at 10:00 AM, Nicholas I
<[hidden email]> wrote:

>
> The version that i am using her is, Udig Version: 1.1.0-SC1.
>
> -Nicholas I
>
>
> On Tue, Aug 18, 2009 at 1:29 PM, Nicholas I <[hidden email]> wrote:
>>
>> Hi,
>>
>>
>>  when i try to connect to postgis, from udig i get the following error. any idea please.
>>
>> Error:
>>
>>  SEVERE: Could not obtain PostgisDBInfo
>> org.geotools.data.DataSourceException: Connection failed:org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gisdb"
>>     at org.geotools.data.jdbc.JDBC1DataStore.getConnection(JDBC1DataStore.java:1035)
>>     at org.geotools.data.postgis.PostgisDataStore.getTypeNames(PostgisDataStore.java:313)
>>     at net.refractions.udig.catalog.internal.postgis.PostGISServiceImpl.resources(Unknown Source)
>>     at net.refractions.udig.catalog.ui.workflow.EndConnectionState.run(Unknown Source)
>>     at net.refractions.udig.catalog.ui.workflow.Workflow.next(Unknown Source)
>>     at net.refractions.udig.catalog.ui.workflow.WorkflowWizardDialog$1.run(Unknown Source)
>>     at net.refractions.udig.catalog.ui.workflow.WorkflowWizardDialog$2.run(Unknown Source)
>>     at net.refractions.udig.ui.PlatformGIS$1.call(Unknown Source)
>>     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>>     at java.util.concurrent.FutureTask.run(FutureTask.java:138)
>>     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
>>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
>>     at java.lang.Thread.run(Thread.java:619)
>> Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gisdb"
>>     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:65)
>>     at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
>>     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:369)
>>     at org.postgresql.Driver.connect(Driver.java:245)
>>     at java.sql.DriverManager.getConnection(DriverManager.java:582)
>>     at java.sql.DriverManager.getConnection(DriverManager.java:185)
>>     at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:82)
>>     at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:65)
>>     at org.postgresql.ds.PGConnectionPoolDataSource.getPooledConnection(PGConnectionPoolDataSource.java:60)
>>     at org.geotools.data.jdbc.ConnectionPool.getConnection(ConnectionPool.java:122)
>>     at org.geotools.data.jdbc.JDBC2DataStore.createConnection(JDBC2DataStore.java:131)
>>     at org.geotools.data.jdbc.JDBC1DataStore.getConnection(JDBC1DataStore.java:1033)
>>     ... 12 more
>>
>> -Nicholas I
>
>
> _______________________________________________
> udig-users mailing list
> [hidden email]
> http://lists.refractions.net/mailman/listinfo/udig-users
>
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Free Embeddable Forum Powered by Nabble Help