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

Mon Sep 26 05:20:31 PDT 2016

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...

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>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160926/216c991f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: btn_liprofile_blue_80x15_fr_FR.png
Type: image/png
Size: 393 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160926/216c991f/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bcg_logo.gif
Type: image/gif
Size: 4376 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160926/216c991f/attachment-0003.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BCG_bas.gif
Type: image/gif
Size: 4888 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160926/216c991f/attachment-0004.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: In-2C-21px-TM.png
Type: image/png
Size: 1242 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160926/216c991f/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: icone_fb.gif
Type: image/gif
Size: 1317 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160926/216c991f/attachment-0005.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Modere_SocialMarketer_logomark.png
Type: image/png
Size: 2910 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160926/216c991f/attachment-0005.png>