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> >> > -- Stefan Lüdtke Section 5.4- Hydrology Phone: +49(0)331-288-2821 Fax: +49(0)331-288-1570 Email: [email protected] ___________________________________________ Helmholtz Centre Potsdam GFZ German Research Centre for Geosciences Foundation under public law of the federal state of Brandenburg Telegrafenberg, D-14473 Potsdam
signature.asc
Description: OpenPGP digital signature
_______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
