[GRASS-dev] [GRASS GIS] #3167: db.connect: connection to remote database does not work

[GRASS GIS]

#3167: db.connect: connection to remote database does not work
--------------------------+-----------------------------------
  Reporter:  mlennert     |      Owner:  grass-dev@…
      Type:  defect       |     Status:  new
  Priority:  blocker      |  Milestone:  7.0.5
 Component:  Database     |    Version:  unspecified
Resolution:               |   Keywords:  postgresql db.connect
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+-----------------------------------

Comment (by mlennert):

 Replying to [comment:2 martinl]:
 > Replying to [ticket:3167 mlennert]:
 > > {{{
 > > createdb -h myRemoteServer testgrass
 > > grass70 -c /data/GRASS/DATA7/nc_spm_08/postgres_test
 > > db.connect driver=pg database="host=myRemoteServer,dbname=testgrass"
 > > }}}
 >
 > did you tried
 >
 > {{{
 > db.connect driver=pg database=testgrass
 > db.login driver=pg database=testgrass host=myRemoteServer
 > }}}
 >

 Doesn't work:


 {{{
 rm .grass7/dblogin
 db.connect driver=pg database=testgrass
 db.login driver=pg database=testgrass host=myRemoteServer
 db.tables -p
 DBMI-PostgreSQL erreur de pilote :
 Connection failed.
 FATAL:  la base de données « testgrass » n'existe pas


 DBMI-PostgreSQL erreur de pilote :
 Connection failed.
 FATAL:  la base de données « testgrass » n'existe pas


 ERREUR :Unable to open database <testgrass>
 }}}

 and with DEBUG=3


 {{{
 D1/3: G_set_program_name(): db.tables
 D2/3: G_file_name(): path = /data/GRASS/DATA7/nc_spm_08/postgres_test
 D2/3: dbDbmscap(): opendir
 [/data/home/mlennert/SRC/GRASS/grass70_release/dist.x86_64-pc-linux-
 gnu/driver/db/]
 D2/3: dbDbmscap(): opendir
 [/data/home/mlennert/SRC/GRASS/grass70_release/dist.x86_64-pc-linux-
 gnu/driver/db/]
 D1/3: db_d_init_error(): PostgreSQL
 D3/3: db_get_login(): drv=[pg] db=[testgrass]
 D3/3: read_file(): DB login file = </home/mlennert/.grass7/dblogin>
 D3/3: ret = 2 : drv=[pg] db=[testgrass] usr=[] pwd=[] host=[], port=[]
 D3/3: db_driver_open_database(): driver=pg database definition =
 'testgrass'
 D3/3: parse_conn: 'testgrass'
 D3/3: db_get_login(): drv=[pg] db=[testgrass]
 D3/3: read_file(): DB login file = </home/mlennert/.grass7/dblogin>
 D3/3: ret = 2 : drv=[pg] db=[testgrass] usr=[] pwd=[] host=[], port=[]
 D3/3: db_driver_open_database(): host = (null), port = (null), options =
 (null), tty = (null), dbname = testgrass, user = (null), password = (null)
 schema = (null)
 }}}

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3167#comment:3>
GRASS GIS <https://grass.osgeo.org>