cabrinoob opened a new issue #8991: Trying to install a database dependency URL: https://github.com/apache/incubator-superset/issues/8991 Hi, I'am running the v1.1.7 of the superset Helm chart. I'am trying to install the snowflake database dependency. To do so, I edit the `initFile` property of the Values.yaml file as follows : ``` initFile: |- /usr/local/bin/superset-init --username admin --firstname admin --lastname user --email [email protected] --password admin pip install snowflake-sqlalchemy --user superset runserver ``` ### Expected results Snowflake SQLAlchemy dialect is installed ### Actual results I have an error at init step : ``` 2020-01-22T14:29:49.065825597Z Loaded your LOCAL configuration at [/home/superset/superset_config.py] 2020-01-22T14:29:49.696222448Z The directory '/home/superset/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag. 2020-01-22T14:29:49.698718164Z The directory '/home/superset/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag. 2020-01-22T14:29:49.725374566Z Collecting snowflake-sqlalchemy 2020-01-22T14:29:49.8432481Z Downloading https://files.pythonhosted.org/packages/b3/b2/4a34c0587f8de1530902115935212c1643198c57ec7c9640b257e2eceaa6/snowflake_sqlalchemy-1.1.18-py2.py3-none-any.whl 2020-01-22T14:29:49.917514341Z Collecting snowflake-connector-python (from snowflake-sqlalchemy) 2020-01-22T14:29:50.02223452Z Downloading https://files.pythonhosted.org/packages/80/43/3640f38bfeb7fb9c1f69fda191a0402cac21e18a4586af4546b9953f6a6d/snowflake_connector_python-2.1.3-cp36-cp36m-manylinux2010_x86_64.whl (11.1MB) 2020-01-22T14:29:50.490570582Z Requirement already satisfied: sqlalchemy<2.0.0 in /usr/local/lib/python3.6/site-packages (from snowflake-sqlalchemy) (1.2.2) 2020-01-22T14:29:50.494490523Z Requirement already satisfied: idna<3.0.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (2.6) 2020-01-22T14:29:50.496562541Z Requirement already satisfied: requests<2.23.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (2.18.4) 2020-01-22T14:29:50.539369361Z Collecting azure-storage-blob<12.0.0 (from snowflake-connector-python->snowflake-sqlalchemy) 2020-01-22T14:29:50.567090037Z Downloading https://files.pythonhosted.org/packages/3e/84/610f379b46d7d3c2d48eadeed6a12b6d46a43100fea70534f5992d0ac996/azure_storage_blob-2.1.0-py2.py3-none-any.whl (88kB) 2020-01-22T14:29:50.603489006Z Requirement already satisfied: six<2.0.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (1.12.0) 2020-01-22T14:29:50.605432009Z Requirement already satisfied: urllib3<1.26.0,>=1.20 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (1.22) 2020-01-22T14:29:50.616982346Z Collecting asn1crypto<2.0.0,>0.24.0 (from snowflake-connector-python->snowflake-sqlalchemy) 2020-01-22T14:29:50.648397631Z Downloading https://files.pythonhosted.org/packages/e9/51/1db4a60049fb7390959be586b6eb743098e6cea3f6b2d3ed9e17fec62ba2/asn1crypto-1.3.0-py2.py3-none-any.whl (103kB) 2020-01-22T14:29:50.660118664Z Requirement already satisfied: pytz<2021.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (2018.5) 2020-01-22T14:29:50.662832965Z Requirement already satisfied: certifi<2021.0.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (2018.8.24) 2020-01-22T14:29:50.664523242Z Requirement already satisfied: cffi<1.14,>=1.9 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (1.11.5) 2020-01-22T14:29:50.666709407Z Requirement already satisfied: cryptography<3.0.0,>=1.8.2 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (1.9) 2020-01-22T14:29:50.675961384Z Requirement already satisfied: boto3<1.11.0,>=1.4.4 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (1.4.7) 2020-01-22T14:29:50.680527059Z Requirement already satisfied: ijson<3.0.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (2.3) 2020-01-22T14:29:50.681906562Z Requirement already satisfied: pyjwt<2.0.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (1.7.1) 2020-01-22T14:29:50.713099423Z Collecting azure-common<2.0.0 (from snowflake-connector-python->snowflake-sqlalchemy) 2020-01-22T14:29:50.746353994Z Downloading https://files.pythonhosted.org/packages/3f/4b/8881f8446853dfe3d404468689edcff33c0e2bf62ac2ddf31d08d739fadc/azure_common-1.1.24-py2.py3-none-any.whl 2020-01-22T14:29:50.776903598Z Requirement already satisfied: botocore<1.14.0,>=1.5.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (1.7.48) 2020-01-22T14:29:50.807127878Z Collecting pycryptodomex!=3.5.0,<4.0.0,>=3.2 (from snowflake-connector-python->snowflake-sqlalchemy) 2020-01-22T14:29:50.99185156Z Downloading https://files.pythonhosted.org/packages/46/a0/04a009917f8946e0e2aca0768bb703767c3845c700ac8e3d6589ce0c9026/pycryptodomex-3.9.4-cp36-cp36m-manylinux1_x86_64.whl (9.7MB) 2020-01-22T14:29:51.42693923Z Collecting pyOpenSSL<21.0.0,>=16.2.0 (from snowflake-connector-python->snowflake-sqlalchemy) 2020-01-22T14:29:51.461175604Z Downloading https://files.pythonhosted.org/packages/9e/de/f8342b68fa9e981d348039954657bdf681b2ab93de27443be51865ffa310/pyOpenSSL-19.1.0-py2.py3-none-any.whl (53kB) 2020-01-22T14:29:51.523556325Z Collecting oscrypto<2.0.0 (from snowflake-connector-python->snowflake-sqlalchemy) 2020-01-22T14:29:51.55281498Z Downloading https://files.pythonhosted.org/packages/2a/79/4849dadb88f6cddc8ad4c701c11be5cb36434f043c73cebc3b0494943e77/oscrypto-1.2.0-py2.py3-none-any.whl (192kB) 2020-01-22T14:29:51.598161845Z Requirement already satisfied: future<1.0.0 in /usr/local/lib/python3.6/site-packages (from snowflake-connector-python->snowflake-sqlalchemy) (0.16.0) 2020-01-22T14:29:51.600050271Z Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /usr/local/lib/python3.6/site-packages (from requests<2.23.0->snowflake-connector-python->snowflake-sqlalchemy) (3.0.4) 2020-01-22T14:29:51.625735768Z Collecting azure-storage-common~=2.1 (from azure-storage-blob<12.0.0->snowflake-connector-python->snowflake-sqlalchemy) 2020-01-22T14:29:51.650027438Z Downloading https://files.pythonhosted.org/packages/6b/a0/6794b318ce0118d1a4053bdf0149a60807407db9b710354f2b203c2f5975/azure_storage_common-2.1.0-py2.py3-none-any.whl (47kB) 2020-01-22T14:29:51.684710769Z Requirement already satisfied: pycparser in /usr/local/lib/python3.6/site-packages (from cffi<1.14,>=1.9->snowflake-connector-python->snowflake-sqlalchemy) (2.19) 2020-01-22T14:29:51.68651518Z Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in /usr/local/lib/python3.6/site-packages (from boto3<1.11.0,>=1.4.4->snowflake-connector-python->snowflake-sqlalchemy) (0.9.3) 2020-01-22T14:29:51.688656822Z Requirement already satisfied: s3transfer<0.2.0,>=0.1.10 in /usr/local/lib/python3.6/site-packages (from boto3<1.11.0,>=1.4.4->snowflake-connector-python->snowflake-sqlalchemy) (0.1.13) 2020-01-22T14:29:51.693035455Z Requirement already satisfied: python-dateutil<3.0.0,>=2.1 in /usr/local/lib/python3.6/site-packages (from botocore<1.14.0,>=1.5.0->snowflake-connector-python->snowflake-sqlalchemy) (2.6.1) 2020-01-22T14:29:51.695185711Z Requirement already satisfied: docutils>=0.10 in /usr/local/lib/python3.6/site-packages (from botocore<1.14.0,>=1.5.0->snowflake-connector-python->snowflake-sqlalchemy) (0.14) 2020-01-22T14:29:52.06831728Z pyopenssl 19.1.0 has requirement cryptography>=2.8, but you'll have cryptography 1.9 which is incompatible. 2020-01-22T14:29:52.068472375Z Installing collected packages: azure-common, azure-storage-common, azure-storage-blob, asn1crypto, pycryptodomex, pyOpenSSL, oscrypto, snowflake-connector-python, snowflake-sqlalchemy 2020-01-22T14:29:52.070048535Z Could not install packages due to an EnvironmentError: [Errno 30] Read-only file system: '/home/superset/.local' ``` ### To sum up the main error I have is : ``` Could not install packages due to an EnvironmentError: [Errno 30] Read-only file system: '/home/superset/.local' ``` When I try to do a `pip install snowflake-sqlalchemy` So is there a better way to install a database dependency ? Thank you
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
