Intro to Data Eng: Week 4 Lab 3 Vector Database error

Course Q&A Data Engineering Introduction to Data Engineering
1

Hello,
I’m having an error to connect to the db. I’m copying the same password as got when typing terraform output vector_db_master_password

Here is the code

coder@f7c3e393ff2f:~/project$ psql --host=de-c1w4-vector-db.c1oo0wisaub1.us-east-1.rds.amazonaws.com --username=postgres --password --port=5432 -no-color
Password:
psql: error: connection to server at “de-c1w4-vector-db.c1oo0wisaub1.us-east-1.rds.amazonaws.com” (52.44.250.171), port 5432 failed: FATAL: password authentication failed for user “postgres”
connection to server at “de-c1w4-vector-db.c1oo0wisaub1.us-east-1.rds.amazonaws.com” (52.44.250.171), port 5432 failed: FATAL: no pg_hba.conf entry for host “50.16.135.185”, user “postgres”, database “postgres”, no encryption

2

Hello @Egonzalez,

I could reproduce the error, it seems you included the quotes when you copied the password in step 2.5.. It says Note : The outputs are printed in double quotes, which are not part of the username or password. Could you try without the quotes to connect. Hope it helps:

C1W4_psql_wrong_pass
C1W4_psql_wrong_pass1541×152 47.4 KB

3

Hello @Georgios
Thanks for your reply

Unfortunately, this doesn’t seem to be the cause, I copied it without the quotes.
Any other idea what could be happening? I retried and now the terminal just crashes and closes automatically without any error

4

Hello @Egonzalez,

Sorry for the inconvenience, the terminal crashed to me as well. There are two potential reasons and one is existing resources, the other could be bad configuration files for terraform init/plan. I had to delete the terraform folder and use get latest version to proceed (check this post since others had the same issue and hawraa explains 100%.

Aferwards to stop terraform apply from crashing you should instead use terraform apply -no-color 2> errors.txt and check errors.txt file for existing resources. Then delete them:

  1. rds connection

C1W4_rds_connection
C1W4_rds_connection1893×696 190 KB

  1. glue role

C1W4_glue_role_iam
C1W4_glue_role_iam1781×717 212 KB

  1. ml database

C1W4_glue_catalog_ml_db
C1W4_glue_catalog_ml_db1894×462 111 KB

Since the terminal crashed again you need to use source scripts/setup.sh to load the terraform variables before you go to terraform folder. Then run the terraform commands as usual and terraform apply -no-color 2> errors.txt to find more resources:

  1. The second time you might also need to delete the crawler

C1W4_glue_crawler
C1W4_glue_crawler1648×653 121 KB

The password that you used is probably the issue that you can’t connect. I got that error and used ctr+c to password (e.g. “p3VJhQmilAY”)without the quotes or spaces (p3VJhQmilAY) and ctr+v in the empty space. Hope it helps