[osgeo4w-dev] [osgeo4w] #398: Unable to connect to PostgreSQL DB in GRASS 7.0svn on Win 7

OSGeo4W trac_osgeo4w at osgeo.org
Sat Dec 14 08:24:23 PST 2013


#398: Unable to connect to PostgreSQL DB in GRASS 7.0svn on Win 7
-------------------+--------------------------------------------------------
Reporter:  GG1234  |       Owner:  osgeo4w-dev@…              
    Type:  defect  |      Status:  new                        
Priority:  minor   |   Component:  Package                    
 Version:          |    Keywords:                             
-------------------+--------------------------------------------------------
 Hello,

 I have been trying to connect to a postgresql database in Grass without
 success with the following linecode :


 {{{
 GRASS 7.0.svn> g.gisenv set="DEBUG=3"
 GRASS 7.0.svn> db.connect driver=pg
 database="host=localhost,dbname=mabasepg"
 D2/3: G_file_name(): path = C:\DATA\GRASS/France/Scripting
 D2/3: dbDbmscap(): opendir
 [C:\OSGeo4W\apps\grass\grass-7.0.svn\driver\db\]
 GRASS 7.0.svn> db.login driver=pg
 database="host=localhost,dbname=mabasepg" user=
 postgres password="mypassword"
 D2/3: G_file_name(): path = C:\DATA\GRASS/France/Scripting
 D2/3: dbDbmscap(): opendir
 [C:\OSGeo4W\apps\grass\grass-7.0.svn\driver\db\]
 D3/3: db_set_login(): drv=[pg] db=[host=localhost,dbname=schift]
 usr=[postgres]
 pwd=[mypassword]
 D3/3: DB login file = <C:\Users\Cev/.grass7/dblogin>
 D3/3: login file does not exist
 D3/3: DB login file = <C:\Users\Cev/.grass7/dblogin>
 ERREUR :Unable to set user/password
 }}}

 It seems it cannot store the user/password data into the storage file,
 maybe because of that nasty mix in "\" and "/" characters.
 I do not know if I am correct and if so where to change this. I guess in
 my environment variables bat file ?

 Does someone have a clue ?

 I tried with the GUI, same result.

 Thanks to all, and bravo for the excellent work going on in the open
 source community !

 Cev.

-- 
Ticket URL: <http://trac.osgeo.org/osgeo4w/ticket/398>
OSGeo4W <http://trac.osgeo.org/osgeo4w>
OSGeo4W is the Windows installer and package environment for the OSGeo stack.


More information about the osgeo4w-dev mailing list