You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/01/22 14:36:13 UTC
[GitHub] [incubator-superset] cabrinoob opened a new issue #8991: Trying to
install a database dependency
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 admin@fab.org --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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] cabrinoob commented on issue #8991: Trying to
install a database dependency
Posted by GitBox <gi...@apache.org>.
cabrinoob commented on issue #8991: Trying to install a database dependency
URL: https://github.com/apache/incubator-superset/issues/8991#issuecomment-577267164
Ok, thank you for your quick reply. I will do this
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dpgaspar commented on issue #8991: Trying to
install a database dependency
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #8991: Trying to install a database dependency
URL: https://github.com/apache/incubator-superset/issues/8991#issuecomment-577230800
Hi @cabrinoob,
Your not supposed to install any additional software on a container, you should change the docker image instead to account for this, then override the `image` key (https://github.com/helm/charts/blob/master/stable/superset/values.yaml#L9)
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dpgaspar closed issue #8991: Trying to install
a database dependency
Posted by GitBox <gi...@apache.org>.
dpgaspar closed issue #8991: Trying to install a database dependency
URL: https://github.com/apache/incubator-superset/issues/8991
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org