Univention Bugzilla – Bug 43400
Database integration: allow database creation for database app user , don't create database
Last modified: 2019-01-03 07:18:28 CET
At least the oxseforucs app needs the following changes to the appcenter database integration: * oxseforucs uses multiple databases (and creates these database during the setup). Easiest solution is to grant the database user all rights. * oxseforucs does not like the have the configdb created before the setup. We need a parameter to disable the creation of the database in the app center database registration. Workaround. * Fake DatabaseName in ini * preinst to give database user all grants import univention.appcenter.database import univention.appcenter from univention.appcenter.log import get_base_logger, log_to_logfile from univention.appcenter import AppManager log_to_logfile() database_logger = get_base_logger().getChild('database') oxseforucs_id = 'oxseforucs' #app = AppManager.find(oxseforucs_id, latest=True) app = AppManager.find(oxseforucs_id, app_version='1-docker') mysql_connector = univention.appcenter.database.MySQL(app) mysql_connector.install() mysql_connector.create_database() passwd = mysql_connector.get_db_password() mysql_connector.execute("GRANT ALL PRIVILEGES ON *.* TO 'openexchange'@'%%' IDENTIFIED BY '%s'" % passwd)
This issue has been filled against UCS 4.1. The maintenance with bug and security fixes for UCS 4.1 has ended on 5st of April 2018. Customers still on UCS 4.1 are encouraged to update to UCS 4.3. Please contact your partner or Univention for any questions. If this issue still occurs in newer UCS versions, please use "Clone this bug" or simply reopen the issue. In this case please provide detailed information on how this issue is affecting you.