[GRASS-dev] [GRASS GIS] #2797: db.databases will not connect to postgres database in GRASS 7.0.2RC2 on Win7 and Ubuntu 15.10

GDAL · November 13, 2015, 12:45pm

#2797: db.databases will not connect to postgres database in GRASS 7.0.2RC2 on
Win7 and Ubuntu 15.10
---------------------------------------+---------------------------------
Reporter: pshapley | Owner: grass-dev@…
Type: defect | Status: new
Priority: normal | Milestone: 7.0.2
Component: Database | Version: svn-releasebranch70
Keywords: login database connection | CPU: x86-64
Platform: MSWindows 7 |
---------------------------------------+---------------------------------
If i try to 'link external vector data' to a postgres driver i get the
following:-

db.databases location=db.databases driver=pg location=host="###.###.##
port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
ERROR: Unable to list databases. Try to define correct connection settings
by db.login.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2797>
GRASS GIS <https://grass.osgeo.org>

GDAL · December 1, 2015, 1:11pm

#2797: db.databases will not connect to postgres database in GRASS 7.0.2RC2 on
Win7 and Ubuntu 15.10
-----------------------+---------------------------------------
  Reporter: pshapley | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.0.3
Component: Database | Version: svn-releasebranch70
Resolution: | Keywords: login database connection
       CPU: x86-64 | Platform: MSWindows 7
-----------------------+---------------------------------------

Comment (by harrikoo):

1. Your command line is incorrect. You write:

`db.databases location=db.databases driver=pg location=host="###.###.##
port=5432"`

and this should be

`db.databases driver=pg location="host=###.###.## port=5432"`

Note where the quotations marks are, both the `host` and the `port` must
be within the quotation marks.

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

GDAL · December 19, 2015, 10:17pm

#2797: db.databases will not connect to postgres database in GRASS 7.0.2RC2 on
Win7 and Ubuntu 15.10
-----------------------+---------------------------------------
  Reporter: pshapley | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.0.3
Component: Database | Version: svn-releasebranch70
Resolution: | Keywords: login database connection
       CPU: x86-64 | Platform: MSWindows 7
-----------------------+---------------------------------------
Description changed by neteler:

Old description:

If i try to 'link external vector data' to a postgres driver i get the
following:-

db.databases location=db.databases driver=pg location=host="###.###.##
port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
ERROR: Unable to list databases. Try to define correct connection
settings by db.login.

New description:

If i try to 'link external vector data' to a postgres driver i get the
following:-

db.databases location=db.databases driver=pg location=host="###.###.##
{{{
port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
ERROR: Unable to list databases. Try to define correct connection settings
by db.login.
}}}

--

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

GDAL · December 19, 2015, 10:18pm

#2797: db.databases will not connect to postgres database in GRASS 7.0.2RC2 on
Win7 and Ubuntu 15.10
-----------------------+---------------------------------------
  Reporter: pshapley | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.0.3
Component: Database | Version: svn-releasebranch70
Resolution: | Keywords: login database connection
       CPU: x86-64 | Platform: MSWindows 7
-----------------------+---------------------------------------
Description changed by neteler:

Old description:

If i try to 'link external vector data' to a postgres driver i get the
following:-

db.databases location=db.databases driver=pg location=host="###.###.##
{{{
port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
ERROR: Unable to list databases. Try to define correct connection
settings by db.login.
}}}

New description:

If i try to 'link external vector data' to a postgres driver i get the
following:-

{{{
db.databases location=db.databases driver=pg location=host="###.###.##
port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
DBMI-PostgreSQL driver error:
Unknown option in database definition for PostgreSQL:
db.databases driver=pg location=host="###.###.## port=5432"
ERROR: Unable to list databases. Try to define correct connection settings
by db.login.
}}}

--

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

GDAL · December 19, 2015, 10:18pm

#2797: db.databases will not connect to postgres database in GRASS 7.0.2RC2 on
Win7 and Ubuntu 15.10
-----------------------+---------------------------------------
  Reporter: pshapley | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: normal | Milestone: 7.0.3
Component: Database | Version: svn-releasebranch70
Resolution: invalid | Keywords: login database connection
       CPU: x86-64 | Platform: MSWindows 7
-----------------------+---------------------------------------
Changes (by neteler):

* status: new => closed
* resolution: => invalid

Comment:

Closing due to user error. Feel free to reopen otherwise.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2797#comment:5>
GRASS GIS <https://grass.osgeo.org>