[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):

 {{{
 g.gisenv set=DEBUG=3
 db.tables -p
 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=[host=myRemoteServer,dbname=testgrass]
 D3/3: read_file(): DB login file = </home/mlennert/.grass7/dblogin>
 D3/3: login file does not exist
 D3/3: db_driver_open_database(): driver=pg database definition =
 'host=myRemoteServer,dbname=testgrass'
 D3/3: parse_conn: 'host=myRemoteServer,dbname=testgrass'
 D3/3: token 0 : host=myRemoteServer
 D3/3: token 1 : dbname=testgrass
 D3/3: db_get_login(): drv=[pg] db=[host=myRemoteServer,dbname=testgrass]
 D3/3: read_file(): DB login file = </home/mlennert/.grass7/dblogin>
 D3/3: login file does not exist
 D3/3: db_driver_open_database(): host = (null), port = (null), options =
 (null), tty = (null), dbname = testgrass, user = (null), password = (null)
 schema = (null)
 }}}


 {{{
 db.login driver=pg database=host=myRemoteServer,dbname=testgrass
 db.tables -pD1/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=[host=myRemoteServer,dbname=testgrass]
 D3/3: read_file(): DB login file = </home/mlennert/.grass7/dblogin>
 D3/3: ret = 2 : drv=[pg] db=[host=myRemoteServer,dbname=testgrass] usr=[]
 pwd=[] host=[], port=[]
 D3/3: db_driver_open_database(): driver=pg database definition =
 'host=myRemoteServer,dbname=testgrass'
 D3/3: parse_conn: 'host=myRemoteServer,dbname=testgrass'
 D3/3: token 0 : host=myRemoteServer
 D3/3: token 1 : dbname=testgrass
 D3/3: db_get_login(): drv=[pg] db=[host=myRemoteServer,dbname=testgrass]
 D3/3: read_file(): DB login file = </home/mlennert/.grass7/dblogin>
 D3/3: ret = 2 : drv=[pg] db=[host=myRemoteServer,dbname=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)
 }}}

 So the host name gets lost somewhere on the way.

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