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@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 <[email protected]> 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
<[email protected]> 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
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
--
*Benoit André*
*Directeur - Gérant*
[email protected] <mailto:[email protected]>
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*
[email protected] <mailto:[email protected]>
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>
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
