[GRASS-user] Unable to link to postgis/postgresql

Wed Sep 14 08:43:24 PDT 2016

Hi Martin,

Here is my log :

.-(/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10)------------------------------------------------------------(benoit at pyrite)-
`--> db.connect dri=pg datab=administration
D1/3: G_set_program_name(): db.connect
D2/3: G_file_name(): path = /disques/grassdata/BCG_V7/benoit
D2/3: dbDbmscap(): opendir 
[/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10/dist.i686-pc-linux-gnu/driver/db/]
D3/3: db_get_login(): drv=[pg] db=[administration]
D3/3: read_file(): DB login file = </home/benoit/.grass7/dblogin>
.-(/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10)------------------------------------------------------------(benoit at pyrite)-
`--> db.login dri=pg datab=administration host=192.168.1.200 user=benoit 
port=5432
D1/3: G_set_program_name(): db.login
D2/3: G_file_name(): path = /disques/grassdata/BCG_V7/benoit
D2/3: dbDbmscap(): opendir 
[/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10/dist.i686-pc-linux-gnu/driver/db/]
D3/3: db_set_login(): drv=[pg] db=[administration] usr=[benoit] 
pwd=[(null)] host=[192.168.1.200] port=[5432]
D3/3: read_file(): DB login file = </home/benoit/.grass7/dblogin>
D3/3: write_file(): DB login file = </home/benoit/.grass7/dblogin>
.-(/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10)------------------------------------------------------------(benoit at pyrite)-
`--> db.tables -p
D1/3: G_set_program_name(): db.tables
D2/3: G_file_name(): path = /disques/grassdata/BCG_V7/benoit
D2/3: dbDbmscap(): opendir 
[/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10/dist.i686-pc-linux-gnu/driver/db/]
D2/3: dbDbmscap(): opendir 
[/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10/dist.i686-pc-linux-gnu/driver/db/]
D1/3: db_d_init_error(): PostgreSQL
D3/3: db_get_login(): drv=[pg] db=[administration]
D3/3: read_file(): DB login file = </home/benoit/.grass7/dblogin>
D3/3: ret = 3 : drv=[pg] db=[administration] usr=[benoit] pwd=[] 
host=[], port=[]
D3/3: db_driver_open_database(): driver=pg database definition = 
'administration'
D3/3: parse_conn: 'administration'
D3/3: db_driver_open_database(): host = (null), port = (null), options = 
(null), tty = (null), dbname = administration, user = (null), password = 
(null), host = (null), port = (null) schema = (null)
D3/3: db_get_login(): drv=[pg] db=[administration]
D3/3: read_file(): DB login file = </home/benoit/.grass7/dblogin>
D3/3: ret = 3 : drv=[pg] db=[administration] usr=[benoit] pwd=[] 
host=[], port=[]
DBMI-PostgreSQL erreur de pilote :
Connection failed.
n'a pas pu se connecter au serveur : Aucun fichier ou dossier de ce type
     Le serveur est-il actif localement et accepte-t-il les connexions 
sur la
      socket Unix « /var/run/postgresql/.s.PGSQL.5432 » ?

DBMI-PostgreSQL erreur de pilote :
Connection failed.
n'a pas pu se connecter au serveur : Aucun fichier ou dossier de ce type
     Le serveur est-il actif localement et accepte-t-il les connexions 
sur la
      socket Unix « /var/run/postgresql/.s.PGSQL.5432 » ?

ERREUR :Unable to open database <administration>
.-(/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10)------------------------------------------------------------(benoit at pyrite)-
`--> db.tables -p 2>&1 | grep open_database
D3/3: db_driver_open_database(): driver=pg database definition = 
'administration'
D3/3: db_driver_open_database(): host = (null), port = (null), options = 
(null), tty = (null), dbname = administration, user = (null), password = 
(null), host = (null), port = (null) schema = (null)
.-(/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10)------------------------------------------------------------(benoit at pyrite)-
`-->

Le 14/09/16 13:40, Martin Landa a écrit :
> Hi,
>
> 2016-09-14 13:06 GMT+02:00 Martin Landa <landa.martin at gmail.com>:
>
> I tested with 7.0.5.svn:
>
> db.connect dri=pg datab=mydb
> db.login dri=pg datab=mydb host=myhost user=myuser pass=mypw port=5432
> db.tables -p
>
> works. Could you try to enable debug message and post here relevant information:
>
> g.gisenv set=debug=3
> db.tables -p 2>&1 | grep open_database
>
> (be aware that the log will contain all login information including
> real password - good idea to change it before post here :-)
>
> Ma
>

-- 

*Benoit André*
*Directeur - Gérant*

benoit.andre at bcgeol.be <mailto:benoit.andre at bcgeol.be>
Tel. | +32 475 61 84 94
skype | benoit_andre_bcg
Voir le profil de Benoit André sur LinkedIn 
<https://be.linkedin.com/in/benoitandre>

*BCG SPRL*
Tél. | +32(0)81 58 26 11
Fax | +32(0)81 58 26 12
Chemin de la Foliette, 4 Bte 2
B-5000 - Namur
www.bcgeol.be <http://www.bcgeol.be>  - plan d'accès 
<https://maps.google.be/maps/ms?msid=210366068780572446312.0004dc0b834462107c00f&msa=0&ll=50.460427,4.856445&spn=0.001279,0.002411&iwloc=0004dc0b8345e35a35a20> 

	BCG LOGO <http://www.bcgeol.be>

Suivez-nous sur Lien Linkedin 
<https://www.linkedin.com/company/bureau-conseil-en-g%E9ologie-sprl> 
Lien Facebook 
<https://www.facebook.com/Bureau-Conseil-en-G%E9ologie-153924548320189/?ref=hl> 

Allons plus loin dans le respect de l'environnement : N'utilisons que 
des produits sans empreinte écologiqueLogo Modere 
<https://www.modere.eu/?referralCode=050281>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/4ca0d11d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: btn_liprofile_blue_80x15_fr_FR.png
Type: image/png
Size: 393 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/4ca0d11d/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bcg_logo.gif
Type: image/gif
Size: 4376 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/4ca0d11d/attachment-0003.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BCG_bas.gif
Type: image/gif
Size: 4888 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/4ca0d11d/attachment-0004.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: In-2C-21px-TM.png
Type: image/png
Size: 1242 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/4ca0d11d/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: icone_fb.gif
Type: image/gif
Size: 1317 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/4ca0d11d/attachment-0005.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Modere_SocialMarketer_logomark.png
Type: image/png
Size: 2910 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/4ca0d11d/attachment-0005.png>