[GRASS-user] Grass PostgreSQL problem

[Martin Album Ytre-Eide]

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 :) )

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 at lists.osgeo.org [grass-user-bounces at lists.osgeo.org] på vegne av Martin Album Ytre-Eide [Martin.Album.Ytre-Eide at nrpa.no]
Sendt: 27. september 2013 12:46
Til: Markus Neteler
Kopi: grass-user at 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 at gmail.com [neteler.osgeo at gmail.com] på vegne av Markus Neteler [neteler at osgeo.org]
Sendt: 26. september 2013 12:11
Til: Martin Album Ytre-Eide
Kopi: grass-user at 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 at 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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user