[GRASS-user] Unable to link to postgis/postgresql
Moritz Lennert
mlennert at club.worldonline.be
Wed Sep 28 05:08:42 PDT 2016
On 27/09/16 14:52, Stefan Lüdtke wrote:
> 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.
Thanks, I can confirm this.
You should be able to import your layers on the command line using:
v.in.ogr input="PG:dbname=YourDatabase host=YourRemoteServer"
layer=YourTable out=OutputName
If possible for you, could you please give future feedback in the trac
ticket: https://trac.osgeo.org/grass/ticket/3167 ? This would help
archive all the discussions in one place.
Thanks !
Moritz
>
> 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>
>>>
>>
>
More information about the grass-user
mailing list