Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I tried to connect DSS and PostgreSQL, everyhting seems fine until i try to Import tables to dataset.
I get the following error :
Hi @Alexx ,
Can you please try removing the "Use custom JDBC URL" checkbox. This would then allow you to enter the hostname/ip and port of you PostgreSQL install.
Thanks,
Hi,
The error is in French because of the locale of the VM. Either way it suggests that username/password are incorrect.
If you have PostgreSQL access you can try re-running :
psql -h localhost
CREATE DATABASE dku;
\c dku
CREATE SCHEMA dku_churn;
CREATE USER matthieu WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO matthieu;
CREATE SCHEMA dku_tshirt;
CREATE USER dku_tshirt_admin WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin;
\q
I have the same issue and have verified my tables in Postgres terminal are as per below:
postgres=# \du
List of roles
Role name | Attributes | Member of
------------------+------------------------------------------------------------+-----------
angelo | | {}
dku_tshirt_admin | | {}
matthieu | | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
postgres=# \dn
List of schemas
Name | Owner
---------------+----------
dku_churn | postgres
dku_tshirt | postgres
futurexschema | postgres
public | postgres
(4 rows)
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-----------------------------+-----------------------------+-----------------------
dku | postgres | UTF8 | English_United Kingdom.1252 | English_United Kingdom.1252 |
postgres | postgres | UTF8 | English_United Kingdom.1252 | English_United Kingdom.1252 |
template0 | postgres | UTF8 | English_United Kingdom.1252 | English_United Kingdom.1252 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | English_United Kingdom.1252 | English_United Kingdom.1252 | =c/postgres +
| | | | | postgres=CTc/postgres
When I try to test the connection from DSS to Postgres I get a user authentication error:
FATAL: password authentication failed for user "dku_tshirt_admin"
Can you please suggest what I'm doing wrong and how to proceed from here?
@Alexx I don't think it makes a difference in terms of fixing the issue, but I noticed in your screenshot that you haven't set the schema to "dku_tshirt" on the top right "Naming rules for new datasets" section.
I tried with or without but I'm still getting an authentication error.
@CoreyS this is an old thread but I'm having the same problem and thought I won't open a new thread rather than figure out what the solution was here. What would be your suggestion going forward?