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

Stefan Lüdtke sluedtke at gfz-potsdam.de
Tue Sep 27 05:52:50 PDT 2016 

Hi,

if I do not set all parameters with db.login I do have empty fields in
that file, even though I put that parameters in the db.connect command.

If everything is in db.login, I can connect to the db (as reported
earlier) and list tables. However I can neither link nor import them
because they are not listed in the gui box.

Cheers,
Stefan

On 27/09/16 13:11, Moritz Lennert wrote:
> 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>
>>
> 

-- 
Stefan Lüdtke

Section 5.4- Hydrology
Phone: +49(0)331-288-2821
Fax: +49(0)331-288-1570
Email: sluedtke at gfz-potsdam.de
___________________________________________

Helmholtz Centre Potsdam
GFZ German Research Centre for Geosciences
Foundation under public law of the federal state
of Brandenburg
Telegrafenberg, D-14473 Potsdam

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160927/91c5adbf/attachment.sig>

More information about the grass-user mailing list