Hi All,
Currently we tried to install privacyIDEA 3.6.3. Previously I installed it within Ubuntu 20.04, and I upgraded it to 22.04. Everything was running smoothly until I still had access it from the browser in development server from GUI, but when i tried to update the privacyidea from 3.6.3 to 3.11.4, i got an issue it’s about sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, “Unknown column ‘resolverrealm.node_uuid’ in ‘SELECT’”)
[SQL: SELECT resolverrealm.id AS resolverrealm_id, resolverrealm.resolver_id AS resolverrealm_resolver_id, resolverrealm.realm_id AS resolverrealm_realm_id, resolverrealm.priority AS resolverrealm_priority, resolverrealm.node_uuid AS resolverrealm_node_uuid, resolver_1.id AS resolver_1_id, resolver_1.name AS resolver_1_name, resolver_1.rtype AS resolver_1_rtype
FROM resolverrealm LEFT OUTER JOIN resolver AS resolver_1 ON resolver_1.id = resolverrealm.resolver_id
WHERE %(param_1)s = resolverrealm.realm_id]
[parameters: {‘param_1’: 1}]
(Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)
Because of this, I couldn’t access it from the browser in GUI from the development server.
i don’t understand how to solve this. Before I upgrade the privacy idea in 3.6.3, I just see the database only show
MariaDB [privacyidea]> show columns from resolverrealm;
±------------±--------±-----±----±--------±---------------+
| Field | Type | Null | Key | Default | Extra |
±------------±--------±-----±----±--------±---------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| resolver_id | int(11) | YES | MUL | NULL | |
| realm_id | int(11) | YES | MUL | NULL | |
| priority | int(11) | YES | | NULL | |
±------------±--------±-----±----±--------±---------------+
Even though I upgraded it to 3.11.4, please help, as currently I am stuck. How can I access the privacyidea 3.11.4 in Ubuntu 22.04 from the browser in GUI?
Thanks,
Regards,