#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> _______________________________________________ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev