Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

install Streaming SQL Console error

avatar
Contributor

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

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

According to the above documents to install psycopg2, error remains

avatar
Contributor

dfdf_0-1654571537581.png

after install ,error remains

dfdf_1-1654571584421.png

 

avatar

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
Super Guru

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

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