[GRASS-dev] db.login with postgresql and non standard port

[Luca Delucchi]

Hi devs,

I have a problem using db backend different to SQLite.
I have a postgresql server running on port 5433, I set up the
connection like this

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

but if I try to create new vector with v.random for example I get this error

v.random -z output=random npoints=50 column=zz
D1/1: G_set_program_name(): v.random
D1/1: Vect_open_new(): is_tmp = 0
D1/1: Vect_open_new(): name = random with_z = 1 is_tmp = 0
D1/1: Vect_set_thresh(): thresh = 0.000000
D1/1: G_find_vector2(): name=random mapset=osm_compare
D1/1: V1_open_new_nat(): name = random with_z = 1 is_tmp = 0
D1/1: dig__write_head()
D1/1: write coor size (0) to head
D1/1: dig_spidx_init(), 2 dims
D1/1: Vect_open_sidx(): name = random mapset= osm_compare mode = new
D1/1: Memory based spatial index
D1/1: Vect_default_field_info(): map = random field = 1
D1/1: db_d_init_error(): PostgreSQL
DBMI-PostgreSQL errore del driver:
Connection failed.
connessione al server fallita: File o directory non esistente
        Verifica che il server locale sia in funzione e che
        accetti connessioni sul socket di dominio Unix
"/var/run/postgresql/.s.PGSQL.5432"


DBMI-PostgreSQL errore del driver:
Connection failed.
connessione al server fallita: File o directory non esistente
        Verifica che il server locale sia in funzione e che
        accetti connessioni sul socket di dominio Unix
"/var/run/postgresql/.s.PGSQL.5432"


ATTENZIONE: Impossibile aprire il database <grassdata> dal driver <pg>
ERRORE: Impossibile aprire il database <grassdata> col driver <pg>
D1/1: Vect_close(): name = random, mapset = osm_compare, format = 0,
level = 1, is_tmp = 0
D1/1: close history file
D1/1: V1_close_nat(): name = random mapset= osm_compare
D1/1: get coor info:
/home/lucadelu/grassdata/utm32N/osm_compare/vector/random/coor
D1/1: Vect_coor_info(): Info->size = 0, Info->mtime = 1457452927
D1/1: dig__write_head()
D1/1: write coor size (0) to head
D1/1: Vect_write_dblinks(): map = random, mapset = osm_compare
D1/1: Dblinks written
D1/1: Vect__open_old(): name = random, mapset = osm_compare, layer =
NULL, update = 0, head_only = 1, is_tmp = 0
D1/1: Vect_set_thresh(): thresh = 0.000000
D1/1: dig_spidx_init(), 2 dims
D1/1: G_find_vector2(): name=random mapset=osm_compare
D1/1: Map: name = random, mapset = osm_compare, temporary = 0
D1/1: Vector format: 0 (native)
D1/1: Vect_set_thresh(): thresh = 0.000000
D1/1: Vect__read_head(): vector = random at osm_compare
D1/1: Vect_set_thresh(): thresh = 0.000000
D1/1: Level request = 1
D1/1: Vect__open_old(): vector opened on level 1
D1/1: Vect_read_dblinks(): map = random, mapset = osm_compare
D1/1: Dblinks read
D1/1: dbln file: /home/lucadelu/grassdata/utm32N/osm_compare/vector/random/dbln
D1/1: Vect_close(): name = random, mapset = osm_compare, format = 0,
level = 1, is_tmp = 0
D1/1: close history file
D1/1: G_set_program_name(): g.gisenv

Is this a bug or I'm doing something wrong?

-- 
ciao
Luca

http://gis.cri.fmach.it/delucchi/
www.lucadelu.org