[GRASS-user] Unable to link to postgis/postgresql
Benoit ANDRE
benoit.andre at bcgeol.be
Tue Sep 27 06:25:01 PDT 2016
Hi Moritz,
It works fine with your suggestion... Thank you.
First : I erase ./grass7/dblogin (outside grass)
2nd : I go into grass 7.0.4
3th :
- db.connect driver=pg database=administration
- db.login driver=pg database=administration user=benoit
password=rien host=192.168.1.200 port=5432
No matter if a password is necessary in my case
Then, I had to reconnect map to table with
4th : v.db.connect -o map=survey_bcg at benoit driver=pg
database=administration table=public.survey_bcg
The only place where host and port arise is in the 'db.login' function.
OK. Now, I'm able to make the jump to grass 7.
Thank you again, Moritz.
Cheers,
Ben.
Le 27/09/16 14:52, Stefan Lüdtke a écrit :
> 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>
>>>
--
*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/20160927/c6ca2ed7/attachment-0002.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160927/c6ca2ed7/attachment-0003.html>
-------------- 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/20160927/c6ca2ed7/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/20160927/c6ca2ed7/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/20160927/c6ca2ed7/attachment-0002.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/20160927/c6ca2ed7/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/20160927/c6ca2ed7/attachment-0003.png>
More information about the grass-user
mailing list