Postgres Error authentication 10 type not supported
Hi. We recently needed to update the database passwords in our account setting. We have two users who have created accounts to the same database. One user's account is working fine. The second user is getting the following error:
Error setting up SQL connection. The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
Nothing changed about the account setup for this second user other than the database password. They tried creating a new account and are receiving the same error. Any ideas on what might be causing this?
Best Answer
-
@kenyayvette Yes, the Accounts section of the Data Center it will show how many datasets are associated with that account. If you hover over "DataSets" on the right side and click "Change Owner" you should see a new dialogue to either transfer the datasets to a new owner or new account.
0
Answers
-
@kenyayvette Do the users have the same database access? If so, is the user with the working account able to share the Domo account with the other?
0 -
The users do have the same access, and yes, the one with the working account can share with the other. I'm assuming the solution in that case would just be to use the shared working account. The problem is the user with the non-working account has over 100 datasets that use those account credentials. Is there a way to bulk update which account is used, then?
0 -
@kenyayvette Yes, the Accounts section of the Data Center it will show how many datasets are associated with that account. If you hover over "DataSets" on the right side and click "Change Owner" you should see a new dialogue to either transfer the datasets to a new owner or new account.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive