Securing a Cloud SQL for PostgreSQL Instance のレビュー

mittal aarav · 3ヶ月前にレビュー済み

Mittal Aarav · 3ヶ月前にレビュー済み

Radadiya Dipal · 3ヶ月前にレビュー済み

De Pradyut kumar · 3ヶ月前にレビュー済み

고 재민 · 3ヶ月前にレビュー済み

J D · 3ヶ月前にレビュー済み

Lab unable to complete on 4th TRY also check below logs student_00_86488d85a6bf@cloudshell:~ (qwiklabs-gcp-04-86a5e84bd191)$ export USERNAME=$(gcloud config list --format="value(core.account)") export CLOUDSQL_INSTANCE=postgres-orders export POSTGRESQL_IP=$(gcloud sql instances describe $CLOUDSQL_INSTANCE --format="value(ipAddresses[0].ipAddress)") export PGPASSWORD=$(gcloud auth print-access-token) psql --host=$POSTGRESQL_IP $USERNAME --dbname=orders psql: error: connection to server at "34.83.161.241", port 5432 failed: FATAL: password authentication failed for user student-00-86488d85a6bf@qwiklabs.net connection to server at "34.83.161.241", port 5432 failed: FATAL: password authentication failed for user student-00-86488d85a6bf@qwiklabs.net student_00_86488d85a6bf@cloudshell:~ (qwiklabs-gcp-04-86a5e84bd191)$ gcloud sql connect postgres-orders --user=postgres --quiet Allowlisting your IP for incoming connection for 5 minutes...done. Connecting to database with SQL user [postgres].Password: psql (16.4 (Ubuntu 16.4-1.pgdg22.04+1), server 13.15) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off) Type "help" for help. postgres=> \c orders Password: psql (16.4 (Ubuntu 16.4-1.pgdg22.04+1), server 13.15) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off) You are now connected to database "orders" as user "postgres". orders=> You are now connected to database "orders" as user "postgres". orders-> orders-> GRANT ALL PRIVILEGES ON TABLE order_items TO student-00-86488d85a6bf@qwiklabs.net ERROR: syntax error at or near "export" LINE 1: export PGPASSWORD=$(gcloud auth print-access-token) ^ orders=> \c orders Password: psql (16.4 (Ubuntu 16.4-1.pgdg22.04+1), server 13.15) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off) You are now connected to database "orders" as user "postgres". orders=> GRANT ALL PRIVILEGES ON TABLE order_items TO student-00-86488d85a6bf@qwiklabs.net \q ERROR: role student-00-86488d85a6bf@qwiklabs.net does not exist ----- student_00_86488d85a6bf@cloudshell:~ (qwiklabs-gcp-04-86a5e84bd191)$ export PGPASSWORD=$(gcloud auth print-access-token) psql --host=$POSTGRESQL_IP $USERNAME --dbname=orders psql: error: connection to server at "34.83.161.241", port 5432 failed: FATAL: password authentication failed for user student-00-86488d85a6bf@qwiklabs.net connection to server at "34.83.161.241", port 5432 failed: FATAL: password authentication failed for user student-00-86488d85a6bf@qwiklabs.net student_00_86488d85a6bf@cloudshell:~ (qwiklabs-gcp-04-86a5e84bd191)$

Rajappan Rajkumar · 3ヶ月前にレビュー済み

great

Khammampati Praveen · 3ヶ月前にレビュー済み

Kacha Madhav · 3ヶ月前にレビュー済み

Akbar Malik · 3ヶ月前にレビュー済み

Gharami Ripan · 3ヶ月前にレビュー済み

Soares Rodrigo · 3ヶ月前にレビュー済み

Deshpande Yogiraj · 3ヶ月前にレビュー済み

hoy si pude completarlo

Lopez Ventura Norma Estela · 3ヶ月前にレビュー済み

김 민성 · 3ヶ月前にレビュー済み

Silva Aparecido · 3ヶ月前にレビュー済み

Great!!

Singh Ratnesh · 3ヶ月前にレビュー済み

Completed.

Soni Ashish · 3ヶ月前にレビュー済み

Dzikovskyi Taras · 3ヶ月前にレビュー済み

Khande Prabhat · 3ヶ月前にレビュー済み

password authentication fails for students even after following the steps in guide the second time it fails

Rajappan Rajkumar · 3ヶ月前にレビュー済み

Ahamed Shanawaz · 3ヶ月前にレビュー済み

Kumari Shilpi · 3ヶ月前にレビュー済み

Deshpande Yogiraj · 3ヶ月前にレビュー済み

na

MORE PRAFUL · 3ヶ月前にレビュー済み