RunningJon / TPC-DS

Greenplum TPC-DS benchmark
113 stars 96 forks source link

请教问题 #24

Closed MURH17 closed 3 years ago

MURH17 commented 3 years ago

请问为什么会执行脚本的时候要求输出密码呢? grammar_support.o keywords.o list.o nulls.o permute.o print.o QgenMain.o query_handler.o r_params.o scaling.o StringBuffer.o substitution.o tdefs.o text.o tokenizer.o w_inventory.o y.tab.o release.o scd.o build_support.o parallel.o -lm gcc -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -DYYDEBUG -DLINUX -g -Wall -c -o checksum.o checksum.c gcc -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -DYYDEBUG -DLINUX -g -Wall -o checksum checksum.o -lm Password: gsql: FATAL: Invalid username/password,login denied.

RunningJon commented 3 years ago

I believe you don't have your Greenplum cluster initialized correctly. The gpadmin account doesn't appear to have passwordless ssh setup to the nodes in the cluster which is a requirement for Greenplum and TPC-DS.

MURH17 commented 3 years ago

I believe you don't have your Greenplum cluster initialized correctly. The gpadmin account doesn't appear to have passwordless ssh setup to the nodes in the cluster which is a requirement for Greenplum and TPC-DS.

In a newly installed cluster environment, there is only one omm user. There is no password to enter the omm user through the root user, but I don't know why this happens?

RunningJon commented 3 years ago

Try editing the tpcds_variables.sh file and change the admin user from gpadmin to omm.

You should also know that you may run into other problems using Greenplum when you are using a non-standard user to run the database.

RunningJon commented 3 years ago

You should review the other variables too. The default is 3TB which is pretty large for most systems.

MURH17 commented 3 years ago

Try editing the tpcds_variables.sh file and change the admin user from gpadmin to omm.

You should also know that you may run into other problems using Greenplum when you are using a non-standard user to run the database.

Hello, I really appreciate your help. You reminded me that I have solved the problem now, thank you! I wish you a happy life! Best wishes!