[GRASS-user] Grass PostgreSQL problem

GRASS GRASS user
1

After trying different options - I now get :
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: No such file or directory
  Is the server running locally and accepting
  connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
(The same problem for grass 6.4.2)

Postgres use the unix_domain_socket /tmp/ - so it seems to me that grass is listening to the wrong place. This could be changed in postgresql.conf file at database build time.

Is there a way to change what unix_domain_socket grass is listening to?

postgres server and databases seems to be working ok, and I can connect trough psql.

Martin

________________________________________
Fra: neteler.osgeo@gmail.com [neteler.osgeo@gmail.com] på vegne av Markus Neteler [neteler@osgeo.org]
Sendt: 26. september 2013 12:11
Til: Martin Album Ytre-Eide
Kopi: grass-user@lists.osgeo.org
Emne: Re: [GRASS-user] Grass70 PostgreSQL problem

On Wed, Sep 25, 2013 at 10:51 AM, Martin Album Ytre-Eide
<Martin.Album.Ytre-Eide@nrpa.no> wrote:

Hello all.

I have done this before on different installs, but this time I can't get it
right.

I am trying to add a table to a postgres database, by importing a .shp-file.
It fails to import the table and gives this error:

DBMI-PostgreSQL driver error:
Connection failed.
fe_sendauth: no password supplied

This is probably a backend setup error (not related to GRASS itself).
See for example (random link):

http://superuser.com/questions/565510/postgresql-authentication-failure-with-trust-option

Markus

2

SOLVED - somehow.
I thought that this was a unix domain socket problem, but It was not. (I help to look at the db.test output :slight_smile: )

I upgraded both psql and postgres to 9.1 and had it working.
I made pgadmin3 up and running. (fixed privliges and div. for postgres and my user name).
Made changes to the .grasslogin64.

I have earlier done some changes to pg_hba.conf. - suggested by Markus. - changed some connections to trust.

tried db.test, and everything seems fine. Hope this can help others.

Martin

________________________________________
Fra: grass-user-bounces@lists.osgeo.org [grass-user-bounces@lists.osgeo.org] p&#229; vegne av Martin Album Ytre-Eide [Martin.Album.Ytre-Eide@nrpa.no]
Sendt: 27. september 2013 12:46
Til: Markus Neteler
Kopi: grass-user@lists.osgeo.org
Emne: Re: [GRASS-user] Grass PostgreSQL problem

After trying different options - I now get :
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
(The same problem for grass 6.4.2)

Postgres use the unix_domain_socket /tmp/ - so it seems to me that grass is listening to the wrong place. This could be changed in postgresql.conf file at database build time.

Is there a way to change what unix_domain_socket grass is listening to?

postgres server and databases seems to be working ok, and I can connect trough psql.

Martin

________________________________________
Fra: neteler.osgeo@gmail.com [neteler.osgeo@gmail.com] p&#229; vegne av Markus Neteler [neteler@osgeo.org]
Sendt: 26. september 2013 12:11
Til: Martin Album Ytre-Eide
Kopi: grass-user@lists.osgeo.org
Emne: Re: [GRASS-user] Grass70 PostgreSQL problem

On Wed, Sep 25, 2013 at 10:51 AM, Martin Album Ytre-Eide
<Martin.Album.Ytre-Eide@nrpa.no> wrote:

Hello all.

I have done this before on different installs, but this time I can't get it
right.

I am trying to add a table to a postgres database, by importing a .shp-file.
It fails to import the table and gives this error:

DBMI-PostgreSQL driver error:
Connection failed.
fe_sendauth: no password supplied

This is probably a backend setup error (not related to GRASS itself).
See for example (random link):

http://superuser.com/questions/565510/postgresql-authentication-failure-with-trust-option

Markus
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user