I have performed an apt-get upgrade on a privacyIdea server running on Ubuntu 14.04 LTS. It was originally at version 2.13 and was upgraded to 2.20. Most things appear to still be working. I can authenticate with tokens and perform most token activities. However, when I try, as a user, to enroll a new token, the User Policy is not being enforced. Furthermore, if I log in as the admin and go to edit that User Policy, none of the actions show up. I see a brief flash of what seems like it attempting to display them, then nothing. I can’t seem very many log errors, save for a couple below that were generated when I pulled up the existing policy and then clicked “Create Policy”. If I try to make a NEW policy, I also don’t get any actions listed, but clicking “Create Policy” will actually create the (blank) policy without an error.
I feel like the Ubuntu apt-get upgrade process missed something. We tried upgrading this to an earlier privacyIdea version some months ago and ran in to odd problems with the upgrade that that time as well. The documentation seems to indicate that using apt-get is an acceptable form of upgrading privacyIDEA, and that no extra steps are involved. Is this not the case?
[2017-10-25 14:47:04,773][1309][-1256879296][ERROR][privacyidea.lib.auditmodules.sqlaudit:238] exception ProgrammingError(’(ProgrammingError) (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), ‘’, ‘admin’, ‘myrealm_User_Policy1’, ‘{u\\‘realm\\’: [u\\\\\‘myrealm\\\\\’], u\\‘action\\’: [u\\\\\’ at line 1”)’,)
[2017-10-25 14:47:04,774][1309][-1256879296][ERROR][privacyidea.lib.auditmodules.sqlaudit:239] DATA: {‘info’: u"{u’realm’: [u’myrealm’], u’action’: [u’setpin’, u’resync’, u’auditlog’, u’hotp_hashlib=sha256’, u’enrollHOTP’, u’reset’, u’disable’, u’hotp_otplen=8’, u’hotp_force_server_generate’, u’delete’], u’client’: [], u’user’: [], u’resolver’: u’’, u’time’: u’’, u’active’: True, u’scope’: u’user’, u’adminrealm’: []}", ‘administrator’: u’admin’, ‘realm’: [u’myrealm’], ‘success’: True, ‘privacyidea_server’: ‘tokensdev.mydomain.com’, ‘client_user_agent’: ‘firefox’, ‘token_type’: None, ‘client’: ‘10.10.10.3’, ‘user’: ‘’, ‘resolver’: ‘’, ‘action_detail’: u’myrealm_User_Policy1’, ‘action’: ‘POST /policy/’, ‘serial’: None}
[2017-10-25 14:47:35,603][1309][-1365984448][ERROR][privacyidea.lib.auditmodules.sqlaudit:238] exception ProgrammingError(’(ProgrammingError) (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), ‘’, ‘admin’, ‘myrealm_User_Policy1’, ‘{u\\‘realm\\’: [u\\\\\‘myrealm\\\\\’], u\\‘action\\’: [u\\\\\’ at line 1”)’,)
[2017-10-25 14:47:35,603][1309][-1365984448][ERROR][privacyidea.lib.auditmodules.sqlaudit:239] DATA: {‘info’: u"{u’realm’: [u’myrealm’], u’action’: [u’setpin’, u’resync’, u’auditlog’, u’hotp_hashlib=sha256’, u’enrollHOTP’, u’reset’, u’disable’, u’hotp_otplen=8’, u’hotp_force_server_generate’, u’delete’], u’client’: [], u’user’: [], u’resolver’: u’’, u’time’: u’’, u’active’: True, u’scope’: u’user’, u’adminrealm’: []}", ‘administrator’: u’admin’, ‘realm’: [u’myrealm’], ‘success’: True, ‘privacyidea_server’: ‘tokensdev.mydomain.com’, ‘client_user_agent’: ‘firefox’, ‘token_type’: None, ‘client’: ‘10.10.10.3’, ‘user’: ‘’, ‘resolver’: ‘’, ‘action_detail’: u’myrealm_User_Policy1’, ‘action’: ‘POST /policy/’, ‘serial’: None}