[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [udig-users] FATAL: no pg_hba.conf entry for host "127.0.1.1", user "postgres", database "gis_maps"
|
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
<nicholas.domnic.i@xxxxxxxxx> 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 <nicholas.domnic.i@xxxxxxxxx> 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
> udig-users@xxxxxxxxxxxxxxxxxxxxx
> http://lists.refractions.net/mailman/listinfo/udig-users
>
