question Re: install Streaming SQL Console error in Support Questions

install Streaming SQL Console error

dfdf — Tue, 31 May 2022 06:06:06 GMT

cdp7.1.6

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

Re: install Streaming SQL Console error

steven-matison — Tue, 31 May 2022 12:48:57 GMT

@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

Re: install Streaming SQL Console error

dfdf — Tue, 07 Jun 2022 03:10:07 GMT

According to the above documents to install psycopg2, error remains

Re: install Streaming SQL Console error

dfdf — Tue, 07 Jun 2022 03:13:10 GMT

after install ,error remains

Re: install Streaming SQL Console error

steven-matison — Tue, 07 Jun 2022 12:20:33 GMT

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..

Re: install Streaming SQL Console error

araujo — Thu, 09 Jun 2022 03:26:43 GMT

@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é

Re: install Streaming SQL Console error

dfdf — Fri, 10 Jun 2022 07:17:38 GMT

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