You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "duchuynh (via GitHub)" <gi...@apache.org> on 2023/11/01 16:26:40 UTC
Re: [I] Issue connecting Databases. Tried Postgres and MySQL [superset]
duchuynh commented on issue #25755:
URL: https://github.com/apache/superset/issues/25755#issuecomment-1789263581
Hi @sfirke , Thanks so much for your time. Your debugging suggestions definitely pointed me in the right direction.
Out of these commands:
sudo apt-get install pkg-config This and the command below worked.
pip install mysqlclient <-- Only this database driver was needed to be installed for MySQL
These are the drivers for the other types of databases, and can be used for connecting through other db types.
pip install cx_Oracle
pip install snowflake-sqlalchemy
pip install pymssql
pip install pyhive
pip install sqlalchemy-redshift
My problem was I did not install the drivers **inside** the Python environment. After you run the sudo apt-get install pkg-config command, superset shuts down, but the command to start superset again is:
superset run -p 8088 --with-threads --reload
Not: superset run -p 8088 --with-threads --reload –debugger <----- This command returns the cryptography error mentioned earlier(not sure why)
After you run everything, then the "MySQL" icon should populate in the superset ui:
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org