[GRASS-dev] [GRASS GIS] #2960: db.login port parameter

GDAL · March 10, 2016, 2:37pm

#2960: db.login port parameter
--------------------------------------------+-------------------------
Reporter: lucadelu | Owner: grass-dev@…
Type: defect | Status: new
Priority: major | Milestone: 7.0.4
Component: Datasets | Version: svn-trunk
Keywords: database, postgresql, db.login | CPU: Unspecified
Platform: Unspecified |
--------------------------------------------+-------------------------
It seems that PostgreSQL database library is not working correctly with
port different from the standard 5432.

Following the steps I did
{{{
db.connect driver=pg database=grassdata

db.login driver=pg database=grassdata user=lucadelu port=5433
host=localhost
db.login -p

pg|grassdata|lucadelu|||

cat /home/lucadelu/.grass7/dblogin

pg|grassdata|lucadelu||localhost|5433

db.tables

   DBMI-PostgreSQL driver error:
   Connection failed.
   could not connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?

ERROR: Unable to open database <grassdata>
}}}

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

GDAL · April 9, 2016, 12:34pm

#2960: db.login port parameter
--------------------------+--------------------------------------------
  Reporter: lucadelu | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: major | Milestone: 7.1.0
Component: Datasets | Version: svn-trunk
Resolution: | Keywords: database, postgresql, db.login
       CPU: Unspecified | Platform: Unspecified
--------------------------+--------------------------------------------
Changes (by martinl):

* milestone: 7.0.4 => 7.1.0

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

GDAL · April 9, 2016, 12:34pm

#2960: db.login port parameter
--------------------------+--------------------------------------------
  Reporter: lucadelu | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: major | Milestone: 7.1.0
Component: Database | Version: svn-trunk
Resolution: | Keywords: database, postgresql, db.login
       CPU: Unspecified | Platform: Unspecified
--------------------------+--------------------------------------------
Changes (by martinl):

* component: Datasets => Database

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

GDAL · August 30, 2016, 10:10am

#2960: db.login port parameter
--------------------------+--------------------------------------------
  Reporter: lucadelu | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: major | Milestone: 7.2.0
Component: Database | Version: svn-trunk
Resolution: | Keywords: database, postgresql, db.login
       CPU: Unspecified | Platform: Unspecified
--------------------------+--------------------------------------------

Comment (by mlennert):

What's the status of this bug ? Would be nice to have it fixed for 7.2.

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

GDAL · September 29, 2016, 7:08am

#2960: db.login port parameter
--------------------------+--------------------------------------------
  Reporter: lucadelu | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: major | Milestone: 7.2.0
Component: Database | Version: svn-trunk
Resolution: | Keywords: database, postgresql, db.login
       CPU: Unspecified | Platform: Unspecified
--------------------------+--------------------------------------------

Comment (by mlennert):

I imagine that this is the same issue as #3167 which was fixed. Could you
see if you still have this issue ?

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

GDAL · September 29, 2016, 7:38pm

#2960: db.login port parameter
--------------------------+--------------------------------------------
  Reporter: lucadelu | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: major | Milestone: 7.2.0
Component: Database | Version: svn-trunk
Resolution: fixed | Keywords: database, postgresql, db.login
       CPU: Unspecified | Platform: Unspecified
--------------------------+--------------------------------------------
Changes (by martinl):

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

Comment:

Replying to [comment:5 mlennert]:
> I imagine that this is the same issue as #3167 which was fixed. Could
you see if you still have this issue ?

Right, seems to be like that. I tested PG database cluster running on port
5433.

{{{
db.login dri=pg data=db port=5433
db.tables -p
}}}

Worked. Closing, feel free to re-open if needed.

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