privacyIDEA 2.23.5 install (DEB) Ubuntu 14.04.5 install
Webpage localhost/#/login
Not loading proper page. loads an MySQL error:
“(OperationalError) (1054, “Unknown column ‘token.resolver’ in ‘field list’”)
‘SELECT count(*) AS count_1 \nFROM (SELECT token.id AS token_id, token.description AS token_description, token.serial AS token_serial, token.tokentype AS token_tokentype, token.user_pin AS token_user_pin, token.user_pin_iv AS token_user_pin_iv, token.so_pin AS token_so_pin, token.so_pin_iv AS token_so_pin_iv, token.resolver AS token_resolver, token.resolver_type AS token_resolver_type, token.user_id AS token_user_id, token.pin_seed AS token_pin_seed, token.otplen AS token_otplen, token.pin_hash AS token_pin_hash, token.key_enc AS token_key_enc, token.key_iv AS token_key_iv, token.maxfail AS token_maxfail, token.active AS token_active, token.revoked AS token_revoked, token.locked AS token_locked, token.failcount AS token_failcount, token.count AS token_count, token.count_window AS token_count_window, token.sync_window AS token_sync_window, token.rollout_state AS token_rollout_state \nFROM token \nWHERE token.user_id != %s AND token.active = true) AS anon_1’ (’’,)”
PI.cfg:
SQLALCHEMY_DATABASE_URI = ‘mysql://privacyidea:mypassword@localhost/privacyidea’
privacyidea.ini:
sqlalchemy.url = mysql://privacyidea:mypassword@localhost/privacyidea
args = (’/var/log/privacyidea/privacyidea.log’,‘a’, 10000000, 4)
who.log_file = /var/log/privacyidea/privacyidea.log
privacyideaURL = https://localhost
privacyideaURL.disable_SSL=True
phpMyAdmin shows no rows for anything but [admin] and [ alembic_version] all other table like token are empty
fallowed PDF privacyIDEA Authentication System, Release 2.23.3 and https://www.privacyidea.org/documentation/howtos/howto-run-privacyidea-with-apache2-and-mysql/
Don’t seem to find any instructions on MySQL setup that address tables needed or how to install them
Thanks James