install Streaming SQL Console error

[#1]

cdp7.1.6

SQL_STREAM_BUILDER-1.12-csa1.4.1.0-cdh7.1.6.0-297-15479260

[#2]

@dfdf as the error suggests:  You need to install the mysql connector.  I believe this link will get you there:

https://docs.cloudera.com/csa/1.3.0/installation/topics/csa-ssb-configuring-mysql.html#ariaid-title3

[#3]

According to the above documents to install psycopg2, error remains

[#4]

after install ,error remains

[#5]

Fun with python,  you are going to need to resolve all dependencies.  I am not familiar with the last error, but its definitely saying psycopg2 is not found.. 

[#6]

@dfdf ,

In Cloudera Manager, please go to SQL Stream Builder > Configuration and check that the below property is set correctly:

If it's not set to the /usr/share/python3 directory, please set it to that, save and restart the service.

Cheers,

André

[#7]

Follow the steps to install, lack _psycopg psycopg2 package. Py files

The solution

1:wget https://github.com/psycopg/psycopg2/archive/refs/tags/2_8_5.tar.gz

2:tar -xf 2_8_5.tar.gz

3:python setup.py build

   python setup.py install
4:cp psycopg2-2.8.5-py3.7-linux-x86_64.egg/psycopg2 /usr/share/python3