Cannot create admin account during installation with CentOS 6.6

[dkhwangbo]

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if any
• 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

Superset version

0.13.2 (latest)

Expected results

Well done.

Actual results

(test) [druid-ssd-test] hbadmin@hbase-md15b1-020:~/.virtualenvs/temp 17:05:01> fabmanager create-admin --app
/home/hbadmin/.virtualenvs/test/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/home/hbadmin/.virtualenvs/test/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
Username [admin]:
User first name [admin]:
User last name [user]:
Email [[email protected]]:
Password:
Repeat for confirmation:
/home/hbadmin/.virtualenvs/test/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.script is deprecated, use flask_script instead.
  .format(x=modname), ExtDeprecationWarning
/home/hbadmin/.virtualenvs/test/lib/python2.7/site-packages/flask_cache/__init__.py:152: UserWarning: Flask-Cache: CACHE_TYPE is set to null, caching is effectively disabled.
  warnings.warn("Flask-Cache: CACHE_TYPE is set to null, "
/home/hbadmin/.virtualenvs/test/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.cache is deprecated, use flask_cache instead.
  .format(x=modname), ExtDeprecationWarning
/home/hbadmin/.virtualenvs/test/lib/python2.7/site-packages/sqlalchemy/engine/default.py:298: SAWarning: Exception attempting to detect unicode returns: OperationalError('(sqlite3.OperationalError) near "\xf1\x90\x81\x93\xf1\x90\x81\x8c\xf5\x80\x81\x83\
xf0\xb0\x80\xa0\xf4\xb0\x81\x81\xfa\x80\x81\x94\xfd\x80\x80\xa7\xfc\xb0\x81\xa5\xf8\x80\x81\xb4\xfb\x80\x81\xb0\xfa\x90\x81\xa1\xf8\x80\x81\xae\xf9\x90\x81\xb2\xfd\x90\x81\xb4\xfb\xa0\x81\xb2\xf9\xb0\x81\xb3\xf0\x90\x80\xa0\xf8\x80\x81\x93\xf0\x90\x81\x
96\xf0\xb0\x81\x92\xf0\x90\x81\x88\xfa\x80\x81\x92\xfc\x80\x80\xb6\xfa\x90\x80\xa9\xf0\x90\x80\xa0\xf8\x80\x81\x93\xfb\xa0\x81\xa1\xfb\xa0\x81\xaf\xfc\x90\x81\x9f": syntax error',)
  "detect unicode returns: %r" % de)
/home/hbadmin/.virtualenvs/test/lib/python2.7/site-packages/sqlalchemy/engine/default.py:298: SAWarning: Exception attempting to detect unicode returns: OperationalError('(sqlite3.OperationalError) near "\xf1\x90\x81\x93\xf1\x90\x81\x8c\xf5\x80\x81\x83\
xf0\xb0\x80\xa0\xf4\xb0\x81\x81\xfa\x80\x81\x94\xfd\x80\x80\xa7\xfc\xb0\x81\xa5\xf8\x80\x81\xb4\xfb\xa0\x81\xb5\xf8\xb0\x81\xa9\xf9\x80\x81\xaf\xf8\x80\x81\xa5\xf9\x90\x81\xb2\xfd\x90\x81\xb4\xfb\xa0\x81\xb2\xf9\xb0\x81\xb3\xf0\x90\x80\xa0\xf8\x80\x81\x
93\xf0\x90\x81\x96\xf0\xb0\x81\x92\xf0\x90\x81\x88\xfa\x80\x81\x92\xfc\x80\x80\xb6\xfa\x90\x80\xa9\xf0\x90\x80\xa0\xf8\x80\x81\x93\xfb\xa0\x81\xa1\xfb\xa0\x81\xaf\xfc\x90\x81\x9f": syntax error',)
  "detect unicode returns: %r" % de)

Steps to reproduce

$ pip install superset
$ fabmanager create-admin --app superset

Version info

Python 2.7.12
Pip 9.0.1
sqlite 3.15.1

(test) [druid-ssd-test] hbadmin@hbase-md15b1-020:~/.virtualenvs/temp 17:26:51> pip list superset --format columns 
Package          Version
---------------- --------
alembic          0.8.8
amqp             1.4.9
anyjson          0.3.3
Babel            2.3.4
billiard         3.3.0.23
celery           3.1.23
cffi             1.9.1
click            6.6
colorama         0.3.7
cryptography     1.5.3
enum34           1.1.6
Flask            0.11.1
Flask-AppBuilder 1.8.1
Flask-Babel      0.11.1
Flask-Cache      0.13.1
Flask-Login      0.2.11
Flask-Migrate    1.5.1
Flask-OpenID     1.2.5
Flask-Script     2.0.5
Flask-SQLAlchemy 2.0
Flask-Testing    0.5.0
Flask-WTF        0.13.1
future           0.16.0
gunicorn         19.6.0
humanize         0.5.1
idna             2.1
ipaddress        1.0.17
itsdangerous     0.24
Jinja2           2.8
kombu            3.0.37
Mako             1.0.6
Markdown         2.6.6
MarkupSafe       0.23
numpy            1.11.2
pandas           0.18.1
parsedatetime    2.0
pip              9.0.1
pyasn1           0.1.9
pycparser        2.17
pydruid          0.3.0
PyHive           0.2.1
python-dateutil  2.5.3
python-editor    1.0.1
python-openid    2.2.5
pytz             2016.7
requests         2.10.0
sasl             0.2.1
setuptools       28.8.0
simplejson       3.8.2
six              1.10.0
SQLAlchemy       1.0.13
SQLAlchemy-Utils 0.32.7
sqlparse         0.1.19
superset         0.13.2
thrift           0.9.3
thrift-sasl      0.2.1
Werkzeug         0.11.10
wheel            0.29.0  
WTForms          2.1   

[bcambel]

👍 same issue with Ubuntu 16.04 btw I haven't also accomplish with 3.5.2 as well and defaulted to the docker image.

[fangyeqing]

you can see #1557

[dkhwangbo]

Hi @fangyeqing Thanks for your comment.
I apply that solution but same problem is occurred. I think this issue is different from #1557.

[dkhwangbo]

Anyway, Finally, I can install superset with Flask-appbuilder integrated with MySQL.

[zhmg23]

I think I have a similar problem with you
Version info：
Python 2.7.12
Pip 9.0.1

$ fabmanager create-admin --app superset
/usr/local/lib/python2.7/site-packages/flask_sqlalchemy/init.py:30: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
from flask.ext.sqlalchemy._compat import iteritems, itervalues, xrange,
/usr/local/lib/python2.7/site-packages/flask_sqlalchemy/init.py:30: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
from flask.ext.sqlalchemy._compat import iteritems, itervalues, xrange,
Username [admin]:
User first name [admin]:
User last name [user]:
Email [[email protected]]:
Password:
Repeat for confirmation:
/usr/local/lib/python2.7/site-packages/flask_migrate/init.py:4: ExtDeprecationWarning: Importing flask.ext.script is deprecated, use flask_script instead.
from flask.ext.script import Manager
/usr/local/lib/python2.7/site-packages/flask_cache/init.py:152: UserWarning: Flask-Cache: CACHE_TYPE is set to null, caching is effectively disabled.
warnings.warn("Flask-Cache: CACHE_TYPE is set to null, "
/usr/local/lib/python2.7/site-packages/flask_cache/jinja2ext.py:33: ExtDeprecationWarning: Importing flask.ext.cache is deprecated, use flask_cache instead.
from flask.ext.cache import make_template_fragment_key
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py:305: SAWarning: Exception attempting to detect unicode returns: OperationalError('(sqlite3.OperationalError) near "\xf1\x90\x81\x93\xf1\x90\x81\x8c\xf5\x80\x81\x83\xf0\xb0\x80\xa0\xf4\xb0\x81\x81\xfa\x80\x81\x94\xfd\x80\x80\xa7\xfc\xb0\x81\xa5\xf8\x80\x81\xb4\xfb\x80\x81\xb0\xfa\x90\x81\xa1\xf8\x80\x81\xae\xf9\x90\x81\xb2\xfd\x90\x81\xb4\xfb\xa0\x81\xb2\xf9\xb0\x81\xb3\xf0\x90\x80\xa0\xf8\x80\x81\x93\xf0\x90\x81\x96\xf0\xb0\x81\x92\xf0\x90\x81\x88\xfa\x80\x81\x92\xfc\x80\x80\xb6\xfa\x90\x80\xa9\xf0\x90\x80\xa0\xf8\x80\x81\x93\xfb\xa0\x81\xa1\xfb\xa0\x81\xaf\xfc\x90\x81\x9f": syntax error',)
"detect unicode returns: %r" % de)
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py:305: SAWarning: Exception attempting to detect unicode returns: OperationalError('(sqlite3.OperationalError) near "\xf1\x90\x81\x93\xf1\x90\x81\x8c\xf5\x80\x81\x83\xf0\xb0\x80\xa0\xf4\xb0\x81\x81\xfa\x80\x81\x94\xfd\x80\x80\xa7\xfc\xb0\x81\xa5\xf8\x80\x81\xb4\xfb\xa0\x81\xb5\xf8\xb0\x81\xa9\xf9\x80\x81\xaf\xf8\x80\x81\xa5\xf9\x90\x81\xb2\xfd\x90\x81\xb4\xfb\xa0\x81\xb2\xf9\xb0\x81\xb3\xf0\x90\x80\xa0\xf8\x80\x81\x93\xf0\x90\x81\x96\xf0\xb0\x81\x92\xf0\x90\x81\x88\xfa\x80\x81\x92\xfc\x80\x80\xb6\xfa\x90\x80\xa9\xf0\x90\x80\xa0\xf8\x80\x81\x93\xfb\xa0\x81\xa1\xfb\xa0\x81\xaf\xfc\x90\x81\x9f": syntax error',)
"detect unicode returns: %r" % de)
Traceback (most recent call last):
File "/usr/local/lib/python2.7/logging/init.py", line 861, in emit
msg = self.format(record)
File "/usr/local/lib/python2.7/logging/init.py", line 734, in format
return fmt.format(record)
File "/usr/local/lib/python2.7/logging/init.py", line 476, in format
raise e
UnicodeDecodeError: 'ascii' codec can't decode byte 0xf1 in position 72: ordinal not in range(128)
Logged from file manager.py, line 81

Could you tell me the detailed solution?
Thank you very much.

[xrmx]

What encoding are you using? BTW please give it a try to python3 as it may well just work.

[mistercrunch]

Notice: this issue has been closed because it has been inactive for 425 days. Feel free to comment and request for this issue to be reopened.