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/02/27 13:06:56 UTC
[GitHub] [incubator-superset] ilyakitaev opened a new issue #9216: Using
oracle as DataSource
ilyakitaev opened a new issue #9216: Using oracle as DataSource
URL: https://github.com/apache/incubator-superset/issues/9216
Hello, just as a solution and for future development.
Quick fix
1. First you need to download oracle client with libraries and put them into superset image
2. install cx_Oracle and libaio1 inside container
`apt update; apt install -y libaio1; pip install cx_Oracle`
3. For normal language support set env variable (in the superset_config.py for example)
NLS_LANG=RUSSIAN_RUSSIA.AL32UTF8 # for Russian with UTF-8
4. Superset does not detect oracle and uses postgres specs for that datasource. So you need to comment this line to fix SQL Lab error
superset/db_engine_specs/postgres.py +52
# cursor.tzinfo_factory = FixedOffsetTimezone
hope it will be helpfull
----------------------------------------------------------------
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] stale[bot] commented on issue #9216: Using oracle as DataSource in superset with Docker
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9216:
URL: https://github.com/apache/incubator-superset/issues/9216#issuecomment-620371004
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] ilyakitaev commented on issue #9216: Using oracle as DataSource in superset with Docker
Posted by GitBox <gi...@apache.org>.
ilyakitaev commented on issue #9216:
URL: https://github.com/apache/incubator-superset/issues/9216#issuecomment-641990442
> Thanks
> The only error I have is when I run queries in SQL Lab : `oracle error: 'cx_Oracle.Cursor' object has no attribute 'tzinfo_factory'`
> I run it from the docker image so I don't really know where to look for the logs, I can provide them if you tell me
m.b. you really need to restart container with docker-compose restart after fixing sources. If you recreate containers with down/up your fix will be removed
You can view logs with docker-compose logs <service name>
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] ilyakitaev commented on issue #9216: Using oracle as DataSource in superset with Docker
Posted by GitBox <gi...@apache.org>.
ilyakitaev commented on issue #9216:
URL: https://github.com/apache/incubator-superset/issues/9216#issuecomment-641949349
> I think I have the problem you fix with your 4th point, but doing that didn't change anything, should I restart something ?
can you provide any logs? That was quickfix for demo, m.b. I can help 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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] nk-fouque commented on issue #9216: Using oracle as DataSource in superset with Docker
Posted by GitBox <gi...@apache.org>.
nk-fouque commented on issue #9216:
URL: https://github.com/apache/incubator-superset/issues/9216#issuecomment-641915398
I think I have the problem you fix with your 4th point, but doing that didn't change anything, should I restart something ?
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] nk-fouque commented on issue #9216: Using oracle as DataSource in superset with Docker
Posted by GitBox <gi...@apache.org>.
nk-fouque commented on issue #9216:
URL: https://github.com/apache/incubator-superset/issues/9216#issuecomment-641958647
Thanks
The only error I have is when I run queries in SQL Lab : `oracle error: 'cx_Oracle.Cursor' object has no attribute 'tzinfo_factory'`
I run it from the docker image so I don't really know where to look for the logs, I can provide them if you tell me
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org