It is currently Tue Jan 26, 2021 6:25 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Postgres 13 (PB5.73b2) does not work
PostPosted: Sun Oct 11, 2020 7:33 pm 
Offline
Enthusiast
Enthusiast

Joined: Tue Jun 08, 2004 10:29 am
Posts: 282
Location: Zurich, Switzerland
I can not open a Postgres 13 database with PureBasic:

Code:
OpenDatabase(0, "host=localhost port=5432", "postgres", "secret", #PB_Database_PostgreSQL)
Debug DatabaseError()

gives the following error:
Code:
authentication method 10 not supported

Opening a Postgres 12 database works fine...

_________________
As you walk on by, Will you call my name? Or will you walk away?


Top
 Profile  
Reply with quote  
 Post subject: Re: Postgres 13 (PB5.73b2) does not work
PostPosted: Mon Oct 12, 2020 6:40 am 
Offline
Addict
Addict

Joined: Sat Feb 08, 2014 3:26 pm
Posts: 967
Confirmed
Code:
UsePostgreSQLDatabase()

If OpenDatabase(0, "host=localhost port=5432", "postgresql", "postgresql")
    Debug "Connected to PostgreSQL"
Else
    Debug "Connection failed: " + DatabaseError()
EndIf

Code:
Connection failed: authentication method 10 not supported

Postgresql 13 works
Code:
C:\>chcp 1252
Page de codes active : 1252

C:\>"Program Files\PostgreSQL\13\bin\psql.exe" -h localhost -U postgres -d template1 -p 5432
Mot de passe pour l'utilisateur postgres :
psql (13.0)
Saisissez « help » pour l'aide.

template1=#
template1=# \q

C:\>


Notes:
Same PB 5.72, 5.46
Other tools works (i.e Heidisql)
There is change in PG 13 in authentification (see Security Enhancements)
https://www.postgresql.org/about/news/postgresql-13-released-2077/


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye