Support Questions

Find answers, ask questions, and share your expertise
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!

install Streaming SQL Console error

avatar
Explorer

cdp7.1.6

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

 

dfdf_0-1653977014012.png

 

dfdf_1-1653977074571.png

 

6 REPLIES 6

avatar
Super Collaborator

@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

 

 

 

avatar
Explorer

According to the above documents to install psycopg2, error remains

avatar
Explorer

dfdf_0-1654571537581.png

after install ,error remains

dfdf_1-1654571584421.png

 

avatar
Super Collaborator

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

avatar
Master Collaborator

@dfdf ,

 

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

araujo_0-1654745164574.png

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

 

Cheers,

André

 

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
Explorer

dfdf_0-1654845095103.png

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

dfdf_1-1654845427474.pngdfdf_2-1654845450266.png

 

 

Labels