[GRASS-user] Unable to link to postgis/postgresql

Tue Sep 27 04:11:20 PDT 2016

Hi Benoît and Stefan,

On 26/09/16 14:20, Benoit ANDRE wrote:
> Hi Moritz,
>
> I tried with last release (7.0.5RC2) on my server (where postgresql is
> running) and not on a remote workstation.  Connection to database is
> then a local connection.  Here, there is no problem to work with
> postgresql.  The problem seems thus to be linked with a remote acces...

I think I have found the origin of the problem. Please see the 
discussion in the relevant bug report [1].

Both of you say that you did set usernam and password in db.login. Could 
you check the contents of .grass7/dblogin ? Are there empty fields 
before the host entry ?

Moritz

[1] https://trac.osgeo.org/grass/ticket/3167

>
> Benoit
>
> Le 14/09/16 12:26, Moritz Lennert a écrit :
>> This really is a serious issue.
>>
>> Would it be possible for you to provide a reproducible example ? Ideally
>> starting out from the North Caroline data. Something that creates a new
>> postgresql database, redefined db.connect to link to that, g.copy a few
>> maps and then see if the connection problem still happens ?
>>
>> Ideally this should go into a bug ticket and IMHO it should definitely
>> be a blocker for the upcoming releases as I would consider this basic
>> functionality.
>>
>> Moritz
>>
>>
>> Le Wed, 14 Sep 2016 11:22:57 +0200,
>> Benoit ANDRE <benoit.andre at bcgeol.be> a écrit :
>>
>>> Hi list,
>>>
>>> Always the same problem with a remote Postgresql connection, with
>>> grass 7.0.4 and above (7.2 and 7.3).  With grass 7.0.0, the
>>> connection to postgresql is perfect.  I don't try with 7.0.1, 7.0.2
>>> and 7.0.3
>>>
>>> All my other soft using Postgresql work fine (i.e. pgadmin, odoo,
>>> caldav, carddav, libreoffice, ...)
>>>
>>> The problem is the for all the PC on my network (server under Centos
>>> 7, workstations under Fedora 19, 21 or 22)
>>>
>>> Le 12/09/16 13:22, Stefan Lüdtke a écrit :
>>>> Hi list,
>>>>
>>>> I hope this is not a duplicate, but I could not find any solution
>>>> on the web by know.
>>>>
>>>> I trying to connect to a remote postgresql database, without
>>>> success.
>>>>
>>>> What I have done:
>>>>
>>>> 1)
>>>> db.connect driver=pg	       	
>>>> database="host=vmhydro27,dbname=cedim_rfra,port=5432"
>>>>
>>>> 2)db.login driver=pg database=cedim_rfra user=sluedtke
>>>> password=##### host=vmhydro27
>>>>
>>>> 3) db.tables -p
>>>>
>>>> DBMI-PostgreSQL driver error:
>>>> Connection failed.
>>>> 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"?
>>>> DBMI-PostgreSQL driver error:
>>>> Connection failed.
>>>> 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"?
>>>> ERROR: Unable to open database
>>>> <host=vmhydro27,dbname=cedim_rfra,port=5432>
>>>>
>>>> I tried all drivers (odbc, ogr, pg) that made sense to me, no
>>>> success.
>>>>
>>>> It is no problem to connect QGIS, R and python to this db and
>>>> visualize the data.
>>>>
>>>> I am using Kubuntu 16.04 with GRASS 7.04.
>>>>
>>>> [I]  /u/bin  apt-cache show grass
>>>>
>>>>
>>>>                              Mon 12 Sep 2016 13:20:37 CEST
>>>> Package: grass
>>>> Status: install ok installed
>>>> Priority: optional
>>>> Section: metapackages
>>>> Installed-Size: 33
>>>> Maintainer: Debian GIS Project
>>>> <pkg-grass-devel at lists.alioth.debian.org> Architecture: all
>>>> Version: 7.0.4-1~xenial2
>>>> Replaces: grass7, grass70
>>>> Provides: grass7, grass70
>>>> Depends: grass-core, grass-gui
>>>> Recommends: grass-doc
>>>> Suggests: grass-dev
>>>> Conflicts: grass7, grass70
>>>> Description: Geographic Resources Analysis Support System (GRASS
>>>> GIS) Commonly referred to as GRASS, this is a Geographic Information
>>>>   System (GIS) used for geospatial data management and analysis,
>>>>   image processing, graphics/map production, spatial modeling, and
>>>>   visualization. GRASS is currently used in academic and commercial
>>>>   settings around the world, as well as by many government agencies
>>>>   and environmental consulting companies.
>>>>   .
>>>>   Install this virtual package to get a full GRASS system.
>>>> Description-md5: 927e5df9adc0c220121824a1dcc21063
>>>> Homepage: http://grass.osgeo.org/
>>>>
>>>>
>>>> I am able to get info of a certain layer using ogrinfo with the
>>>> connection string.
>>>>
>>>> Any help is appreciated.
>>>>
>>>> Cheers,
>>>>
>>>> Stefan
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> grass-user mailing list
>>>> grass-user at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/grass-user
>
> --
>
> 	
>
> *Benoit André*
> *Directeur - Gérant*
>
> benoit.andre at bcgeol.be <mailto:benoit.andre at bcgeol.be>
> Tel. | +32 475 61 84 94
> skype | benoit_andre_bcg
> Voir le profil de Benoit André sur LinkedIn
> <https://be.linkedin.com/in/benoitandre>
>
> *BCG SPRL*
> Tél. | +32(0)81 58 26 11
> Fax | +32(0)81 58 26 12
> Chemin de la Foliette, 4 Bte 2
> B-5000 - Namur
> www.bcgeol.be <http://www.bcgeol.be>  -  plan d'accès
> <https://maps.google.be/maps/ms?msid=210366068780572446312.0004dc0b834462107c00f&msa=0&ll=50.460427,4.856445&spn=0.001279,0.002411&iwloc=0004dc0b8345e35a35a20>
>
>
> 	BCG LOGO <http://www.bcgeol.be>
>
> Suivez-nous sur  Lien Linkedin
> <https://www.linkedin.com/company/bureau-conseil-en-g%C3%A9ologie-sprl> Lien
> Facebook
> <https://www.facebook.com/Bureau-Conseil-en-G%C3%A9ologie-153924548320189/?ref=hl>
>
>
> Allons plus loin dans le respect de l'environnement : N'utilisons que
> des produits sans empreinte écologiqueLogo Modere
> <https://www.modere.eu/?referralCode=050281>
>