Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DBManager don't use authcfg with Oracle provider #58166

Open
2 tasks done
naub1n opened this issue Jul 18, 2024 · 2 comments
Open
2 tasks done

DBManager don't use authcfg with Oracle provider #58166

naub1n opened this issue Jul 18, 2024 · 2 comments
Labels
Authentication Related to the QGIS Authentication subsystem or user/password handling Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin Oracle data provider

Comments

@naub1n
Copy link

naub1n commented Jul 18, 2024

What is the bug or the crash?

I have an Oracle connection that use an authentication config with basic auth.
When I open the connection in QGIS Explorer, everything work fine.

image

But when I try to open the same connection with Db Manager, QGIS ask username and password because connection failed:

image

Steps to reproduce the issue

  1. Configure Oracle connection with authentication configuration (basic auth in Password Manager).
  2. Try to open the connection in DB Manager

Versions

Version de QGIS 3.34.7-Prizren Révision du code 6f7d735
Version de Qt 5.15.13
Version de Python 3.12.3
Version de GDAL/OGR 3.9.0
Version de Proj 9.4.0
Version de la base de données du registre EPSG v11.004 (2024-02-24)
Version de GEOS 3.12.1-CAPI-1.18.1
Version de SQLite 3.45.1
Version de PDAL 2.6.3
Version du client PostgreSQL 16.2
Version de SpatiaLite 5.1.0
Version de QWT 6.2.0
Version de QScintilla2 2.14.1
Version de l'OS Windows 10 Version 2009
       
Extensions Python actives
changeDataSource 3.1
datagrandest 2.2
plugin_reloader 0.9.4
qwc2_tools v1.3.0
db_manager 0.1.20
grassprovider 2.12.99
MetaSearch 0.3.6
processing 2.12.99
pg_service_parser 0.2.1
menu_from_project 2.1.0

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

Additional context

No response

@naub1n naub1n added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Jul 18, 2024
@naub1n
Copy link
Author

naub1n commented Jul 18, 2024

Same result with QGIS 3.38.0

@agiudiceandrea agiudiceandrea added DB Manager Relating to the DB Manager core plugin Authentication Related to the QGIS Authentication subsystem or user/password handling Oracle data provider labels Jul 21, 2024
@markusgis
Copy link

markusgis commented Sep 27, 2024

Issue exist with 3.28.9 and QGIS 3.34.11.
I also think that authentication configuration should be used in DB Manager. Now DB Manager asks username and password and if I then add layer using DB Manager QGIS stores my db credentials to project file.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Authentication Related to the QGIS Authentication subsystem or user/password handling Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin Oracle data provider
Projects
None yet
Development

No branches or pull requests

3 participants