Re: [GRASS-dev] [GRASS GIS] #2627: v.out.postgis uses wrong database name or port

[GRASS GIS]

#2627: v.out.postgis uses wrong database name or port
--+---
  Reporter:  wenzeslaus   |  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  normal   |  Milestone:  7.2.0
 Component:  Default  |Version:  svn-trunk
Resolution:   |   Keywords:  PostgreSQL, postgres, PostGIS
   CPU:  Unspecified  |   Platform:  Unspecified
--+---

Comment (by wenzeslaus):

 I can't test this right now, can somebody else test it (same for #2626)?
 The issue here seemed to be non-standard port.

--
Ticket URL: 
GRASS GIS 

___
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

Re: [GRASS-dev] [GRASS GIS] #2627: v.out.postgis uses wrong database name or port

[GRASS GIS]

#2627: v.out.postgis uses wrong database name or port
--+---
  Reporter:  wenzeslaus   |  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  normal   |  Milestone:  7.2.0
 Component:  Default  |Version:  svn-trunk
Resolution:   |   Keywords:  PostgreSQL, postgres, PostGIS
   CPU:  Unspecified  |   Platform:  Unspecified
--+---

Comment (by neteler):

 ping

--
Ticket URL: 
GRASS GIS 

___
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

Re: [GRASS-dev] [GRASS GIS] #2627: v.out.postgis uses wrong database name or port

[GRASS GIS]

#2627: v.out.postgis uses wrong database name or port
--+---
  Reporter:  wenzeslaus   |  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  normal   |  Milestone:  7.2.0
 Component:  Default  |Version:  svn-trunk
Resolution:   |   Keywords:  PostgreSQL, postgres, PostGIS
   CPU:  Unspecified  |   Platform:  Unspecified
--+---

Comment (by mlennert):

 The handling of host and port info have changed (use db.login instead of
 db.connect for that info). Could you test whether this is still an issue
 for you in 7.2 ?

--
Ticket URL: 
GRASS GIS 

___
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

[GRASS-dev] [GRASS GIS] #2627: v.out.postgis uses wrong database name or port

[GRASS GIS]

#2627: v.out.postgis uses wrong database name or port
---+
 Reporter:  wenzeslaus |   Owner:  grass-dev@…  

 Type:  defect |  Status:  new  

 Priority:  normal |   Milestone:  7.1.0

Component:  Default| Version:  svn-trunk

 Keywords:  PostgreSQL, postgres, PostGIS  |Platform:  Unspecified  

  Cpu:  Unspecified|  
---+
 After using `db.connect` and `db.login`:

 {{{
 db.connect driver=pg database="host=0.0.0.0,port=25432,dbname=gis"
 db.login user=docker password=docker
 }}}

 v.out.postgis uses wrong database name or port (or both) and then fails to
 connect to the database and then crashes or hangs.

 In the following reports I used `g.gisenv set=DEBUG=5` but the behavior is
 the same for no debug. Note the name of database in debug messages is once
 "grass", then NULL and then "grass" plus some unknown/non-printable
 character. It also seems that it calls the `read_file()` function twice.
 Finally, it mentions 5432 before it ends.

 Hangs:

 {{{
 D2/5: V1_open_new_pg(): name = busroutesall with_z = 0
 D1/5: V1_open_new_pg(): conninfo='dbname=grass' table='busroutesall'
 D3/5: db_get_login(): drv=[pg] db=[grass]
 D3/5: read_file(): DB login file = 
 D3/5: ret = 4 : drv=[pg] db=[host=localhost,port=25432,dbname=gis]
 usr=[docker] pwd=[docker]
 D3/5: db_get_login(): drv=[pg] db=[(null)]
 D3/5: read_file(): DB login file = 
 D3/5: ret = 4 : drv=[pg] db=[host=localhost,port=25432,dbname=gis]
 usr=[docker] pwd=[docker]
 D1/5:PQconnectdb(): dbname=grass user=docker password=docker
 ERROR: Connection to PostgreSQL database failed. Try to set up
username/password by db.login.
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"?
 D1/5: Vect_close(): name = busroutesall, mapset = PERMANENT, format = 0,
 level = 2, is_tmp = 0
 D1/5: spatial index file closed
 D1/5: close history file
 D1/5: V1_close_nat(): name = busroutesall mapset= PERMANENT
 D1/5: file_handler: PG_27099
 D2/5: G_file_name(): path = /grassdata//nc_spm/postgis_test1/PG_27099
 }}}

 Aborted with "free(): invalid pointer":

 {{{
 D2/5: V1_open_new_pg(): name = busroutesall with_z = 0
 D1/5: V1_open_new_pg(): conninfo='dbname=grass' table='busroutesall'
 D3/5: db_get_login(): drv=[pg] db=[grass]
 D3/5: read_file(): DB login file = 
 D3/5: ret = 4 : drv=[pg] db=[host=localhost,port=25432,dbname=gis]
 usr=[docker] pwd=[docker]
 D3/5: db_get_login(): drv=[pg] db=[(null)]
 D3/5: read_file(): DB login file = 
 D3/5: ret = 4 : drv=[pg] db=[host=localhost,port=25432,dbname=gis]
 usr=[docker] pwd=[docker]
 D1/5:PQconnectdb(): dbname=grass user=docker password=docker
 ERROR: Connection to PostgreSQL database failed. Try to set up
username/password by db.login.
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"?
 D1/5: Vect_close(): name = busroutesall, mapset = PERMANENT, format = 0,
 level = 2, is_tmp = 0
 D1/5: spatial index file closed
 D1/5: close history file
 D1/5: V1_close_nat(): name = busroutesall mapset= PERMANENT
 D1/5: file_handler: PG_27257
 D2/5: G_file_name(): path = /grassdata//nc_spm/postgis_test1/PG_27257
 dbmi: Protocol error
 * Error in `v.out.postgis': free(): invalid pointer: 0x7f6fed3977e8 *
 Aborted (core dumped)
 }}}

 Segmentation fault:

 {{{
 D2/5: V1_open_new_pg(): name = busroutesall with_z = 0
 D1/5: V1_open_new_pg(): conninfo='dbname=grass' table='busroutesall'
 D3/5: db_get_login(): drv=[pg] db=[grass]
 D3/5: read_file(): DB login file = 
 D3/5: ret = 4 : drv=[pg] db=[host=localhost,port=25432,dbname=gis]
 usr=[docker] pwd=[docker]
 D3/5: db_get_login(): drv=[pg] db=[(null)]
 D3/5: read_file(): DB login file = 
 D3/5: ret = 4 : drv=[pg] db=[host=localhost,port=25432,dbname=gis]
 usr=[docker] pwd=[docker]
 D1/5:PQconnectdb(): dbname=grass user=docker password=docker
 ERROR: Connection to PostgreSQL database failed. Try to set up
username/password by db.login.
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"?
 D1/5: Vect_close(): name = busroutesall, mapset = PERMANENT, format = 0,
 level = 2, is_tmp = 0
 D1/5: spatial index file closed
 D1/5: close history file
 D1/5: V1_close_nat(): name = busroutesall mapset= PERMANENT
 D1/5: file_handler: PG_27267
 D2/5: G_file_name(): path = /grassd