jerowe opened a new issue #4471: Trying to migrate to mysql backend
URL: https://github.com/apache/incubator-superset/issues/4471
 
 
   - [x] I have checked the superset logs for python stacktraces and included 
it here as text if any
   - [x] I have reproduced the issue with at least the latest released version 
of superset
   - [ ] I have checked the issue tracker for the same issue and I haven't 
found one similar
   
   There are similar issues, but none recent or using the same version.
   
   ### Superset version
   Superset 0.22.1
   
   ### Expected results
   
   
   ### Actual results
   I can initialize the mysql database, create an admin user, but the web 
interface does not seem to be using it.
   
   ### Steps to reproduce
   ```
   #/home/$USER/.supserset/superset_config.py
   SQLALCHEMY_DATABASE_URI = 'mysql://superset:$password@$host/superset'
   ```
   ```
   export PYTHONPATH="/home/$USER/.superset/:$PYTHONPATH"
   rm ~/.superset/superset.db
   fabmanager create-admin --app superset
   superset db upgrade
   superset load_examples
   superset init
   ```
   
   ```
   ?  ~ superset runserver
   Loaded your LOCAL configuration at 
[/home/jdr400/.superset/superset_config.pyc]
   Starting server with command:
   gunicorn -w 2 --timeout 60 -b  0.0.0.0:8088 --limit-request-line 0 
--limit-request-field_size 0 superset:app
   
   [2018-02-23 09:20:57 +0000] [4060] [INFO] Starting gunicorn 19.7.1
   [2018-02-23 09:20:57 +0000] [4060] [INFO] Listening at: http://0.0.0.0:8088 
(4060)
   [2018-02-23 09:20:57 +0000] [4060] [INFO] Using worker: sync
   [2018-02-23 09:20:57 +0000] [4065] [INFO] Booting worker with pid: 4065
   [2018-02-23 09:20:57 +0000] [4066] [INFO] Booting worker with pid: 4066
   Loaded your LOCAL configuration at 
[/home/jdr400/.superset/superset_config.pyc]
   Loaded your LOCAL configuration at 
[/home/jdr400/.superset/superset_config.pyc]
   ```
   
   If I check the mysql database I see the admin user as expected.  But then 
when I go to login to the web interface I get either an 'Internal service 
error' or a long stack trace that indicates superset is still trying to use the 
superset.db sqlite database.
   
   ```
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", 
line 470, in do_execute
       cursor.execute(statement, parameters)
   OperationalError: (sqlite3.OperationalError) no such table: ab_role [SQL: 
u'SELECT ab_role.id AS ab_role_id, ab_role.name AS ab_role_name \nFROM ab_role 
\nWHERE ab_role.name = ?\n LIMIT ? OFFSET ?'] [parameters: ('Public', 1, 0)]
   ```
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to