Не работает контекстное меню отправить windows 10

authentication method 10 not supported

Модератор: Дмитрий Юхтимовский

Вернуться в postgres и linux (deb-ные) для 1С

Кто сейчас на форуме

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 1

Please provide the following information when submitting an issue (feature requests or general comments can skip this):

1. pgBackRest version: v.2.43

2. PostgreSQL version: 14.6

3. Operating system/version — if you have more than one server (for example, a database server, a repository host server, one or more standbys), please specify each: amzn1.x86_64 v0.15 — [Experiment — Ignore] #1 SMP Sun Nov 27 06:09:45 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux**

4. Did you install pgBackRest from source or from a package? Source
   by downloading from
   curl -LO https://github.com/pgbackrest/pgbackrest/archive/release/2.43.tar.gz

5. Please attach the following as applicable:

   • pgbackrest.conf file(s)
   • postgresql.conf settings applicable to pgBackRest (archive_command, archive_mode, listen_addresses, max_wal_senders, wal_level, port)
   • errors in the postgresql log file before or during the time you experienced the issue
   • log file in /var/log/pgbackrest for the commands run (e.g. /var/log/pgbackrest/mystanza_backup.log)

6. Describe the issue:

Getting error message » authentication method 10 not supported» while trying to create stanza on postgres14 after upgrading postgres from v.10.2 to Postgres v.14.6.
I know the Postgres 14 uses scram-sha-256 authentication by default but I checked with md5 and scram-sha-256 authentication (in postgresql.conf) method also.

I tried after installing library package and getting the different error message like » SCRAM authentication requires libpq version 10 or above ERROR: [056]: unable to find primary cluster — cannot proceed»

Postgres is also installed from source on custom location
wget https://ftp.postgresql.org/pub/source/v14.6/postgresql-14.6.tar.gz

ls /opt/PostgreSQL-14/lib/

libecpg.a libecpg_compat.so.3.14 libpgcommon.a libpgport_shlib.a libpgtypes.so.3.14 libpq.so.5.14
libecpg_compat.a libecpg.so libpgcommon_shlib.a libpgtypes.a libpq.a pkgconfig
Error-pgbackrest.txt
pgbackrest settings.txt

libecpg_compat.so libecpg.so.6 libpgfeutils.a libpgtypes.so libpq.so postgresql
libecpg_compat.so.3 libecpg.so.6.14 libpgport.a libpgtypes.so.3 libpq.so.5

pgbackrest.conf entry:

cat /etc/pgbackrest/pgbackrest.conf

[global]
repo1-path=/opt/backups
repo1-retention-full=2

[test14]
pg1-path=/opt/PostgreSQL-14/data
pg1-port=5432
pg1-user=postgres
pg1-socket-path=/tmp

• I’m using PyQt6 (version 6.4.0) with Python 3.11, but I think my problem concerns Qt rather than the Python binding.

  When I run the test script below on Windows 10, using either Python 3.11 or Python 3.10, I get this:

  DEBUG:root:addDatabase: — this is ok, no error
  DEBUG:root:setDatabaseName, setHostName: — and so is this
  ERROR:root:db.open(): authentication method 10 not supported
  QPSQL: Unable to connect

  PostgreSQL 15 runs on the same machine. Running the script from a virtual machine with ArchLinux everything works as expected (of course in that case I need the real host name, not ‘localhost’). The PostgreSQL bin and lib directories are in the PATH. There are no older PostgreSQL versions on the machine and no older versions of PyQt / Qt.

  One thing seems clear: «authentication method 10» is the password authentication using scram-sha-256 which is PostgreSQL standard from version 14 and supported from version 10. So this problem is probably not new. I’m using QtSql more with SQLite, so I didn’t see it earlier.

  I found some answers for the error message, but nothing concerning Qt or PyQt. The answers all talk about old versions of libpq.dll, but I installed PyQt6 with its dependencies after Python 3.11 was released, only about a week ago. So where would I search for an old version and why should it be used by Qt?

  Test script (needs valid database name, user name and password, of course):

  #!/usr/bin/env python3
  
  import logging
  from PyQt6 import QtCore
  from PyQt6 import QtSql
  
  def createConnection():
      db = QtSql.QSqlDatabase.addDatabase("QPSQL")
      logging.debug("addDatabase: %s", db.lastError().text())
      db.setDatabaseName("xxx")
      db.setHostName("localhost")
      logging.debug("setDatabaseName, setHostName: %s", db.lastError().text())
      db.setUserName("xxx")
      db.setPassword("xxx")
      return db
  
  def test():
      logging.basicConfig(level=logging.DEBUG)
      app = QtCore.QCoreApplication([])
      db = createConnection()
      result = db.open()
      if result:
          print("Datenbankverbindung offen.")
      else:
          logging.error("db.open(): %s", db.lastError().text())
          
  if __name__ == "__main__":
      test() 
  
  

• I’m using PyQt6 (version 6.4.0) with Python 3.11, but I think my problem concerns Qt rather than the Python binding.

  When I run the test script below on Windows 10, using either Python 3.11 or Python 3.10, I get this:

  DEBUG:root:addDatabase: — this is ok, no error
  DEBUG:root:setDatabaseName, setHostName: — and so is this
  ERROR:root:db.open(): authentication method 10 not supported
  QPSQL: Unable to connect

  PostgreSQL 15 runs on the same machine. Running the script from a virtual machine with ArchLinux everything works as expected (of course in that case I need the real host name, not ‘localhost’). The PostgreSQL bin and lib directories are in the PATH. There are no older PostgreSQL versions on the machine and no older versions of PyQt / Qt.

  One thing seems clear: «authentication method 10» is the password authentication using scram-sha-256 which is PostgreSQL standard from version 14 and supported from version 10. So this problem is probably not new. I’m using QtSql more with SQLite, so I didn’t see it earlier.

  I found some answers for the error message, but nothing concerning Qt or PyQt. The answers all talk about old versions of libpq.dll, but I installed PyQt6 with its dependencies after Python 3.11 was released, only about a week ago. So where would I search for an old version and why should it be used by Qt?

  Test script (needs valid database name, user name and password, of course):

  #!/usr/bin/env python3
  
  import logging
  from PyQt6 import QtCore
  from PyQt6 import QtSql
  
  def createConnection():
      db = QtSql.QSqlDatabase.addDatabase("QPSQL")
      logging.debug("addDatabase: %s", db.lastError().text())
      db.setDatabaseName("xxx")
      db.setHostName("localhost")
      logging.debug("setDatabaseName, setHostName: %s", db.lastError().text())
      db.setUserName("xxx")
      db.setPassword("xxx")
      return db
  
  def test():
      logging.basicConfig(level=logging.DEBUG)
      app = QtCore.QCoreApplication([])
      db = createConnection()
      result = db.open()
      if result:
          print("Datenbankverbindung offen.")
      else:
          logging.error("db.open(): %s", db.lastError().text())
          
  if __name__ == "__main__":
      test() 
  
  

  @skoczian
  I would imagine the libpq.dll you are using supports older methods of authentication and not this «method 10». The fact that you have installed a recent Python/PyQt/Qt may not alter this fact.

  If @Christian-Ehrlicher sees this post, I believe he uses PostgreSQL and may be able to comment/help….

• I’m using PyQt6 (version 6.4.0) with Python 3.11, but I think my problem concerns Qt rather than the Python binding.

  When I run the test script below on Windows 10, using either Python 3.11 or Python 3.10, I get this:

  DEBUG:root:addDatabase: — this is ok, no error
  DEBUG:root:setDatabaseName, setHostName: — and so is this
  ERROR:root:db.open(): authentication method 10 not supported
  QPSQL: Unable to connect

  PostgreSQL 15 runs on the same machine. Running the script from a virtual machine with ArchLinux everything works as expected (of course in that case I need the real host name, not ‘localhost’). The PostgreSQL bin and lib directories are in the PATH. There are no older PostgreSQL versions on the machine and no older versions of PyQt / Qt.

  One thing seems clear: «authentication method 10» is the password authentication using scram-sha-256 which is PostgreSQL standard from version 14 and supported from version 10. So this problem is probably not new. I’m using QtSql more with SQLite, so I didn’t see it earlier.

  I found some answers for the error message, but nothing concerning Qt or PyQt. The answers all talk about old versions of libpq.dll, but I installed PyQt6 with its dependencies after Python 3.11 was released, only about a week ago. So where would I search for an old version and why should it be used by Qt?

  Test script (needs valid database name, user name and password, of course):

  #!/usr/bin/env python3
  
  import logging
  from PyQt6 import QtCore
  from PyQt6 import QtSql
  
  def createConnection():
      db = QtSql.QSqlDatabase.addDatabase("QPSQL")
      logging.debug("addDatabase: %s", db.lastError().text())
      db.setDatabaseName("xxx")
      db.setHostName("localhost")
      logging.debug("setDatabaseName, setHostName: %s", db.lastError().text())
      db.setUserName("xxx")
      db.setPassword("xxx")
      return db
  
  def test():
      logging.basicConfig(level=logging.DEBUG)
      app = QtCore.QCoreApplication([])
      db = createConnection()
      result = db.open()
      if result:
          print("Datenbankverbindung offen.")
      else:
          logging.error("db.open(): %s", db.lastError().text())
          
  if __name__ == "__main__":
      test() 
  
  

  Lifetime Qt Champion

  wrote on
  
  last edited by Christian Ehrlicher

  @skoczian said in QPSQL: authentication method 10 not supported:

  libpq.dll

  Can you find out the version of the library (right click -> properties)?

  In the meanwhile modify your config to use md5 instead the ‘new’ authenthication method as described here.

• I have this problem, too.
  I’m new to postgres, Installed latest version 3 days ago on my laptop.
  so my libpq.dll should be the newest available (15.0.1.22312).
  I use VisualStudio (newest version) writing a little C#-Program,
  just to connect to a postgres-db and executing a stupid select…
  I don’t know what to do.

• I have this problem, too.
  I’m new to postgres, Installed latest version 3 days ago on my laptop.
  so my libpq.dll should be the newest available (15.0.1.22312).
  I use VisualStudio (newest version) writing a little C#-Program,
  just to connect to a postgres-db and executing a stupid select…
  I don’t know what to do.

  Lifetime Qt Champion

  wrote on
  
  last edited by

  @drhammer said in QPSQL: authentication method 10 not supported:

  writing a little C#-Program

  How is this related to Qt then?

• I think it has nothing to do with Qt. I stripped everything out, tried to isolate the problem.
  It seems to be a pure postgres problem.

• @skoczian said in QPSQL: authentication method 10 not supported:

  libpq.dll

  Can you find out the version of the library (right click -> properties)?

  In the meanwhile modify your config to use md5 instead the ‘new’ authenthication method as described here.

  @Christian-Ehrlicher said in QPSQL: authentication method 10 not supported:

  @skoczian said in QPSQL: authentication method 10 not supported:

  libpq.dll

  Can you find out the version of the library (right click -> properties)?

  In the meanwhile modify your config to use md5 instead the ‘new’ authenthication method as described here.

  The libpq.dll belonging to PostgreSQL has version 15.0.1.22312. I searched the machine for another, older version that might be used by Qt, but didn’t find anything.

  I don’t think I’ll change the authentication method of PostgreSQL — that’s putting the cart before the horse in my view. Writing a GUI with PyQt and using psycopg for database access instead of QtSql is quite possible. And psycopg definitely works with PostgreSQL 15.

  But it’s interesting that C# or .NET seems to have the same problem!

• @Christian-Ehrlicher said in QPSQL: authentication method 10 not supported:

  @skoczian said in QPSQL: authentication method 10 not supported:

  libpq.dll

  Can you find out the version of the library (right click -> properties)?

  In the meanwhile modify your config to use md5 instead the ‘new’ authenthication method as described here.

  The libpq.dll belonging to PostgreSQL has version 15.0.1.22312. I searched the machine for another, older version that might be used by Qt, but didn’t find anything.

  I don’t think I’ll change the authentication method of PostgreSQL — that’s putting the cart before the horse in my view. Writing a GUI with PyQt and using psycopg for database access instead of QtSql is quite possible. And psycopg definitely works with PostgreSQL 15.

  But it’s interesting that C# or .NET seems to have the same problem!

  Lifetime Qt Champion

  wrote on
  
  last edited by

  @skoczian said in QPSQL: authentication method 10 not supported:

  I don’t think I’ll change the authentication method of PostgreSQL — that’s putting the cart before the horse in my view.

  It was meant
  a) as a test if it helps
  b) as a workaround

  But do whatever you like.

• For me it works now:
  In an C# / .NET / VisualStudio — Environment it has something to do with the Npgsql.dll.
  This is a wrapper for the MS ADO-Interface.
  I think it is not very stable yet. They released a new version a few days ago, I installed it and now it works (but still have problems with converting results …).Concerning Qt I don’t know at the moment.

• @skoczian said in QPSQL: authentication method 10 not supported:

  I don’t think I’ll change the authentication method of PostgreSQL — that’s putting the cart before the horse in my view.

  It was meant
  a) as a test if it helps
  b) as a workaround

  But do whatever you like.

  @Christian-Ehrlicher said in QPSQL: authentication method 10 not supported:

  It was meant
  a) as a test if it helps

  True, that should have given more information — but now the fog is even denser. The result, with the same test script: same error message with md5 in all the «host» or «local» records in pg_hba.conf, after restart of PostgreSQL. It works as expected with «trust» in the same places.

  I should perhaps add that I don’t use QtSql with PostgreSQL databases in earnest. I just have some test scripts — and it’s quite possible that I didn’t run them for every new PostgreSQL or PyQt version.

  I’ve had problems with QtSql using PostgreSQL or Interbase/Firebird before, but this is the first time I couldn’t even find a bug report for them.

Здравствуйте, вопрос такой, брал тестовое решение, аля «POSTGRES 1C» в котором локали ru.RU и в 8.3.18.1363 1С он просто не хочет базу создавать, даже свою, через галочку,но при этом я коннекчусь. Проблема у них в локалях и почему-то другие выбрать «низя» и их попросту нет.
Подумал и поставил обычный postgres, но теперь не могу в локальной сети приконнектится к друг-другу.
psql 13.2 & 1c 8.3.18.1363
Попросту пишет «authentication method 10 not supported», причем все данные введены верно, в консоли я работаю и через PG тоже. службы также запущены(очевидно)

В самом конфиге стоит » * «
Возможно нужно установить какие-то дополнения к 1С «типа» ODBC или что-то такое ?
Я просто смотрел даже обычные ролики на YT и там делается все в два клика, но не у меня…)
upd: и да, это я делаю в форточке, на линукс не хотят люди переходить, слишком сложно им.