<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Moritz, <br>
<br>
It works fine with your suggestion... Thank you.<br>
<br>
First : I erase ./grass7/dblogin (outside grass)<br>
2nd : I go into grass 7.0.4<br>
3th :<br>
- db.connect driver=pg database=administration<br>
- db.login driver=pg database=administration user=benoit
password=rien host=192.168.1.200 port=5432<br>
<br>
No matter if a password is necessary in my case<br>
<br>
Then, I had to reconnect map to table with<br>
4th : v.db.connect -o map=survey_bcg@benoit driver=pg
database=administration table=public.survey_bcg<br>
<br>
The only place where host and port arise is in the 'db.login'
function.<br>
<br>
OK. Now, I'm able to make the jump to grass 7.<br>
<br>
Thank you again, Moritz.<br>
<br>
Cheers, <br>
<br>
Ben.<br>
<br>
<div class="moz-cite-prefix">Le 27/09/16 14:52, Stefan Lüdtke a
écrit :<br>
</div>
<blockquote class=" cite"
id="mid_0610f74d_b1a1_ade9_47c0_43fc97a2ffd9_gfz_potsdam_de"
cite="mid:0610f74d-b1a1-ade9-47c0-43fc97a2ffd9@gfz-potsdam.de"
type="cite">
<pre wrap="">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:
</pre>
<blockquote class=" cite" id="Cite_8117646" type="cite">
<pre wrap="">Hi Benoît and Stefan,
On 26/09/16 14:20, Benoit ANDRE wrote:
</pre>
<blockquote class=" cite" id="Cite_963249" type="cite">
<pre wrap="">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...
</pre>
</blockquote>
<pre wrap="">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] <a class="moz-txt-link-freetext" href="https://trac.osgeo.org/grass/ticket/3167">https://trac.osgeo.org/grass/ticket/3167</a>
</pre>
<blockquote class=" cite" id="Cite_9002245" type="cite">
<pre wrap="">Benoit
Le 14/09/16 12:26, Moritz Lennert a écrit :
</pre>
<blockquote class=" cite" id="Cite_3876460" type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:benoit.andre@bcgeol.be"><benoit.andre@bcgeol.be></a> a écrit :
</pre>
<blockquote class=" cite" id="Cite_559805" type="cite">
<pre wrap="">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 :
</pre>
<blockquote class=" cite" id="Cite_6923427" type="cite">
<pre wrap="">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
<a class="moz-txt-link-rfc2396E" href="mailto:pkg-grass-devel@lists.alioth.debian.org"><pkg-grass-devel@lists.alioth.debian.org></a> 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: <a class="moz-txt-link-freetext" href="http://grass.osgeo.org/">http://grass.osgeo.org/</a>
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
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">--
*Benoit André*
*Directeur - Gérant*
<a class="moz-txt-link-abbreviated" href="mailto:benoit.andre@bcgeol.be">benoit.andre@bcgeol.be</a> <a class="moz-txt-link-rfc2396E" href="mailto:benoit.andre@bcgeol.be"><mailto:benoit.andre@bcgeol.be></a>
Tel. | +32 475 61 84 94
skype | benoit_andre_bcg
Voir le profil de Benoit André sur LinkedIn
<a class="moz-txt-link-rfc2396E" href="https://be.linkedin.com/in/benoitandre"><https://be.linkedin.com/in/benoitandre></a>
*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
<a class="moz-txt-link-abbreviated" href="http://www.bcgeol.be">www.bcgeol.be</a> <a class="moz-txt-link-rfc2396E" href="http://www.bcgeol.be"><http://www.bcgeol.be></a> - plan d'accès
<a class="moz-txt-link-rfc2396E" href="https://maps.google.be/maps/ms?msid=210366068780572446312.0004dc0b834462107c00f&msa=0&ll=50.460427,4.856445&spn=0.001279,0.002411&iwloc=0004dc0b8345e35a35a20"><https://maps.google.be/maps/ms?msid=210366068780572446312.0004dc0b834462107c00f&msa=0&ll=50.460427,4.856445&spn=0.001279,0.002411&iwloc=0004dc0b8345e35a35a20></a>
BCG LOGO <a class="moz-txt-link-rfc2396E" href="http://www.bcgeol.be"><http://www.bcgeol.be></a>
Suivez-nous sur Lien Linkedin
<a class="moz-txt-link-rfc2396E" href="https://www.linkedin.com/company/bureau-conseil-en-g%C3%A9ologie-sprl"><https://www.linkedin.com/company/bureau-conseil-en-g%C3%A9ologie-sprl></a> Lien
Facebook
<a class="moz-txt-link-rfc2396E" href="https://www.facebook.com/Bureau-Conseil-en-G%C3%A9ologie-153924548320189/?ref=hl"><https://www.facebook.com/Bureau-Conseil-en-G%C3%A9ologie-153924548320189/?ref=hl></a>
Allons plus loin dans le respect de l'environnement : N'utilisons que
des produits sans empreinte écologiqueLogo Modere
<a class="moz-txt-link-rfc2396E" href="https://www.modere.eu/?referralCode=050281"><https://www.modere.eu/?referralCode=050281></a>
</pre>
</blockquote>
</blockquote>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<table border="0" cellpadding="0" cellspacing="0" height="230"
width="422">
<tbody>
<tr>
<td style="padding-top:15px; padding-left:25px;
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:12px; color:#663515" valign="top" width="25"> <br>
</td>
<td style="padding-top:15px; padding-left:25px;
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:12px; color:#663515" valign="top" width="271">
<p style="margin-bottom:5px; padding:0"> <strong
style="font-size:14px; font-family:Verdana, Arial,
Helvetica, sans-serif; color:#00b1e6"><font
color="#00b1e6">Benoit André</font></strong><br>
<strong><font color="#663515">Directeur - Gérant</font></strong>
</p>
<p style="margin-bottom:5px; margin-top:0; padding:0"> <font
color="#663515"><a
href="mailto:benoit.andre@bcgeol.be"
style="color:#00b1e6">benoit.andre@bcgeol.be</a></font><br>
<font color="#663515">Tel. <span style="color:#00b1e6">|</span>
+32 475 61 84 94</font><br>
<font color="#663515">skype <span style="color:#00b1e6">|</span>
benoit_andre_bcg</font><br>
<a href="https://be.linkedin.com/in/benoitandre"><img
src="cid:part2.08080400.02030005@bcgeol.be"
alt="Voir le profil de Benoit André sur LinkedIn"
border="0" height="15" width="80"></a> </p>
<p style="margin-bottom:5px; padding:0; font-size:11px"> <strong><font
color="#663515">BCG SPRL</font></strong><br>
<font color="#663515">Tél. <span style="color:#00b1e6">|</span>
+32(0)81 58 26 11</font><br>
<font color="#663515">Fax <span style="color:#00b1e6">|</span>
+32(0)81 58 26 12</font><br>
<font color="#663515">Chemin de la Foliette, 4 Bte 2<br>
B-5000 - Namur</font><br>
<font color="#663515"><a href="http://www.bcgeol.be"
style="color:#00b1e6">www.bcgeol.be</a> - <a
href="https://maps.google.be/maps/ms?msid=210366068780572446312.0004dc0b834462107c00f&msa=0&ll=50.460427,4.856445&spn=0.001279,0.002411&iwloc=0004dc0b8345e35a35a20"
style="color:#00b1e6">plan d'accès</a></font> </p>
</td>
<td valign="top" width="151"> <a
href="http://www.bcgeol.be"><img
src="cid:part6.06000503.06050601@bcgeol.be" alt="BCG
LOGO" border="0" height="112" width="151"></a> </td>
</tr>
<tr>
<td colspan="3" height="64" valign="top"> <img
src="cid:part8.06070206.03010309@bcgeol.be" height="64"
width="422"> </td>
</tr>
</tbody>
</table>
<p style="font-size:11px"> <font color="#663515">Suivez-nous sur
<span style="padding: 5px;"><a
href="https://www.linkedin.com/company/bureau-conseil-en-g%C3%A9ologie-sprl"><img
src="cid:part9.06070200.01050201@bcgeol.be" alt="Lien
Linkedin" border="0" height="15"></a> <a
href="https://www.facebook.com/Bureau-Conseil-en-G%C3%A9ologie-153924548320189/?ref=hl"><img
src="cid:part11.06090403.07020803@bcgeol.be" alt="Lien
Facebook" border="0" height="18"></a> </span> </font><br>
</p>
<p style="color: #008000; font-size: 9px; "> Allons plus loin dans
le respect de l'environnement : <a
href="https://www.modere.eu/?referralCode=050281"
style="color: #008000; ">N'utilisons que des produits sans
empreinte écologique<img
src="cid:part13.03020205.03080206@bcgeol.be" alt="Logo
Modere" border="0" height="27" width="30"></a>
</p>
</div>
</body>
</html>