Trying to connect VCS to PGSQL

[Jacques Zemron]

Thanks a lot Phil, it works

regards

Jacques ZEMRON
  
AutoEntrepreneur


37 Avenue de Paris
LE LION D'OR
14370 MERY-BISSIERES-EN-AUGE

Portable : 06 82 68 60 08
Mailto:jacky at aec-ri.com

> Le 24 sept. 2024 à 13:19, Phil (OmnisList) <phil at pgpotter.co.uk> a écrit :
> 
> Hi Jacques,
> 
> As it says, there is no entry in the hba file for your computer to be
> allowed to connect to the PG server...
> 
> you need to add an entry that includes the IP you are using for your
> computer...
> 
> ie:
> host   all     all     172.16.1.2/24     scram-sha-256
> 
> if your local network is 172.16.1.* and its the same for both the server
> and your machine, then something like the line above should work for you..
> Assuming you are an admin and can edit the hba file?
> 
> regards
> Phil Potter
> Based in Chester in the UK.
> 
> On 24/09/2024 11:13, Jacques Zemron wrote:
>> Hi everybody,
>> 
>> I'm trying to connect VCS to a new PGSQL server and I have this message an Idea ?
>> 
>> The SQL Browser was unable to log on :
>> FATAL: aucune entrée dans pg_hba.conf pour l'hôte «
>> https://mibc-fr-02.mailinblack.com/securelink/?url=http://10.0.1.193&key=eyJsYW5nIjoiRlIiLCJ1cmwiOiJodHRwOi8vMTAuMC4xLjE5MyIsInRva2VuIjoiZ0FBQUFBQm04cUE1OFZxT3RULWhoc0hsX0ppYl82bTc3NDNrNENCMEdWTUx6ckZ5UHExaVRUOEFjZFdhdEZwX25OZmtSZ0ZMZUV3VWlYOEUxNXQ3aklnNEkwNHM0cmp3bE84QjFrTTQ1UVJZSmd0dG9qRWZ4XzRPMGFabnJoNVBWYzdzODFmT2V1OVdUanM1UVpJU0g1TFdfc280ek40U1QwbktTWHhWalFPNHZ5UHVTdzBEZWFPbEZhdU5ZcGNkVFV1WVNwb245ZzZuREUwT1otTjN3d0F1MDBhOHF6NHlMZjlwdGRxMS1EZmFyaDZRNm51T1VoRzZaNC0zVGtkMG9DdVZfa3MyTUhuMm1oam1OS0FxRmpUNVRPYjFFS2RRTVkyYWt6SjJEYXpONXl2dkwxYWtQcDdnTG53eTZTd3U4Nld1Snc3SlBwTGwifQ== », utilisateur « MATZ », base de données « VCS », SSL inactif
>> 
>> 
>> I have another PGSQL installed on another server and the connection is OK. I've tried to see differences but dont't find them.
>> 
>> Any Idea ?
>> 
>> Regards
>> 
>> Jacques ZEMRON
>> 
>> AutoEntrepreneur
>> 
>> 
>> 37 Avenue de Paris
>> LE LION D'OR
>> 14370 MERY-BISSIERES-EN-AUGE
>> 
>> Portable : 06 82 68 60 08
>> Mailto:jacky at aec-ri.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions athttps://lists.omnis-dev.com
>> Start a new message https://mibc-fr-02.mailinblack.com/securelink/?key=eyJsYW5nIjoiRlIiLCJ1cmwiOiItPm1haWx0bzpvbW5pc2Rldi1lbkBsaXN0cy5vbW5pcy1kZXYuY29tIiwidG9rZW4iOiJnQUFBQUFCbThxQTV4QWlOb2dnMWxzd19wUmxPLUxvNWhQVFc0Q1E3eDJhbUdJaklQa0dfOVdON1Q3anlzMDFHckRZVWVvTEVDM1drLXpOMnZBSnk1VFpTbXBOTWxJdlJqTUxLWmc1TndJeWt1NHRXYW9YcF90VGMyNThJT05JTkM4YkdHUXRDLVJHeUhuYzhnNGNtTGtkRWNadzh6RnI5UHNtbGFHNWFheE0xZ0FSaUNzMVpvamx4bWp6LWJYSlRxNHdzeFNRT0haOTQ0QnpQWUphY082eHo4NTRpNDhGQ0FaSWN3V2s2QVNVQ09vQndrenJIcldrenRPVm5jR1dieHNxSU44aWc1TVM2c2FHTEhUcFl4M194TGxFRF9TZzlmNzk4VGxmNzBoZXlkbFItNnpOLTkyYVdNdXdXMVM0Q0tpZkxXWXppWUMwSiJ9
> _____________________________________________________________
> Manage your list subscriptions at https://mibc-fr-02.mailinblack.com/securelink/?url=https://lists.omnis-dev.com&key=eyJsYW5nIjoiRlIiLCJ1cmwiOiJodHRwczovL2xpc3RzLm9tbmlzLWRldi5jb20iLCJ0b2tlbiI6ImdBQUFBQUJtOHFBNVFHTmhhS1BFSVRySzZ4cE5SNE00dFpneDV6eXEtRWpNNVhvYzJQeGVmOHNpSzFDeUJUc2FPTFh6aTcwd3Jod0JjMkZlazhuQVB2cTk4N0NGV2FsLWIyVFhXTkgyYXZRLThZZVRZcXgtakZPWDB5NTRBV3o4TGdSNE1TZVhtYTNObEEySlhLUk5oZ1kyMk9UcXBQZVpWcERhS0hhS0VCd1VvOGNrMjM1c19fVmU5UWp4N1RndF9GdFpVWmpSWUFKWkZoM3NLT1ZVWnV1NnJQemJDbncxenVYanh5X2RlMVhUZFJpZTVKVEIyVjZvTWl3amlGWk1IcDVkV2I1bG5VUG8yQVprZHNUUXZvTzBZS1BrNWhqVi1jNlRYYVBYZWRFMjM0OXVscTRoRTk0NTM3b2d4YWY4N3d0SGVZRkNBdUpxIn0=
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com