Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

privacyIdea UI is unavaible #1750

Closed
tamaro-skaljic opened this issue Jul 18, 2019 · 2 comments

Comments

@tamaro-skaljic
Copy link
Contributor

commented Jul 18, 2019

Our current master branch produce this message in a json response on each site of the privacyidea-UI. Also you can't authenticate against privacyIdea.

"(pymysql.err.ProgrammingError) (1146, u\"Table 'pi.policycondition' doesn't exist\")\n[SQL: SELECT policy.id AS policy_id, policy.active AS policy_active, policy.check_all_resolvers AS policy_check_all_resolvers, policy.name AS policy_name, policy.scope AS policy_scope, policy.action AS policy_action, policy.realm AS policy_realm, policy.adminrealm AS policy_adminrealm, policy.resolver AS policy_resolver, policy.user AS policy_user, policy.client AS policy_client, policy.time AS policy_time, policy.priority AS policy_priority, policycondition_1.id AS policycondition_1_id, policycondition_1.policy_id AS policycondition_1_policy_id, policycondition_1.section AS policycondition_1_section, policycondition_1.`Key` AS `policycondition_1_Key`, policycondition_1.comparator AS policycondition_1_comparator, policycondition_1.`Value` AS `policycondition_1_Value`, policycondition_1.active AS policycondition_1_active \nFROM policy LEFT OUTER JOIN policycondition AS policycondition_1 ON policy.id = policycondition_1.policy_id ORDER BY policycondition_1.id]\n(Background on this error at: http://sqlalche.me/e/f405)"
@fredreichbier

This comment has been minimized.

Copy link
Member

commented Jul 18, 2019

Hi Tamaro, this is actually not a bug :-)
We changed the SQL database schema in the meantime (for example, we added a new table policycondition). Whenever this happens, you need to migrate your local database to the new database schema by running

pi-manage db upgrade -d /path/to/your/privacyidea/checkout/migrations

which will, among other things, create the new table policycondition.

@tamaro-skaljic

This comment has been minimized.

Copy link
Contributor Author

commented Jul 22, 2019

Ah thanks... This happens when anybody don't know how privacyIdea works.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.