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

Wrong Postgres user #49

Open
pankus opened this issue Dec 30, 2018 · 2 comments
Open

Wrong Postgres user #49

pankus opened this issue Dec 30, 2018 · 2 comments

Comments

@pankus
Copy link

pankus commented Dec 30, 2018

I find this problem!
WARNING Traceback (most recent call last): conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: role "XXX" does not exist
It seems the plugin fails in getting the proper Postgres user: "XXX" is my Windows 10 user

@saberraz
Copy link
Contributor

Do you have proper right for the table? Could you try with the latest version?

@pankus
Copy link
Author

pankus commented Mar 18, 2019

First of all, thanks for this plugin. It is very useful, even though it does not work properly (for me).
The database is Postgresql running on localhost, so I don't think that the problem concerns rights (in this case). I installed the new version and something actually changed.
I can notice the following behaviour:

  1. if the database credentials (user and pwd) are stored in the project the plugin works. Yet, the configuration dialog box still has some glitches. For instance, in the selection of the available configurations, there are several empty lines. More importantly, and if I well understand, the dialogue tries to provide with suggestions for available connections: it works intermittently.
  2. conversely, when credentials are not stored in the project, I get the following error message:
    File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: password authentication failed for user "NULL" FATAL: password authentication failed for user "NULL"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants