Home > Software engineering >  SQLAlchemy/pgAdmin: Error: password authentication failed for user "root"
SQLAlchemy/pgAdmin: Error: password authentication failed for user "root"

Time:01-17

I'm conducting a study and I need to store some data. I found an open source data scraper and parser online: enter image description here

Above is the config file, and this is the .yml file enter image description here

I started by going into the pgAdmin folder and running "docker-compose up", after which, this was the result: enter image description here

I'm not sure if the "no privileges flag" means anything. Anyway, after this, I opened up a localhost:5050 in my browser and logged into pgAdmin. enter image description here

I named the database "materials" as this was what it was supposed to be named. enter image description here

Same thing with the username and password; both were named "root". However, when I run the command to parse the data, I'm getting this error: enter image description here

I've been stuck on this for a long time now, and I can't seem to find any solution. This is running in a python2.7 conda environment, as per the requirements. These were the other installed libraries (I'm not 100% sure those were the exact versions, but I tried to get them as close as possible).

psycopg2==2.7.3.1
requests>=2.20.0
SQLAlchemy==1.0.9
wheel==0.24.0

If I need to clarify anything please let me know. Thanks.

CodePudding user response:

I found an answer for this. I had to go into services, then to postgres, and stop it from running. I then had to kill the port "5432" and run it again.

  • Related