AppSuite:Drop Stored Procedures

Revision as of 08:38, 14 September 2015 by Martin.schneider (talk | contribs) (Created page with "{{VersionFrom|7.8.0}} <div class="title">Remove obsolete MySQL Stored Procedures from databases</div> '''Summary''': This article tells you why and how to remove already exi...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
This information is valid from 7.8.0 on.
Remove obsolete MySQL Stored Procedures from databases

Summary: This article tells you why and how to remove already existing but obsolete MySQL Stored Procedures from the various databases.

Why to manually remove the existing Stored Procedures?

The Stored Procedures mentioned within the next paragraph aren't needed any more by the Open-Xchange groupware. Because of the reduced privileges Open Xchange recommends with version 7.8.0 (see AppSuite:DB_user_privileges for more information) introduced due to security reasons the existing 'openexchange' database user isn't able to detect the existing Stored Procedures.

Which Stored Procedures are affected?

The following Stored Procedures have to be removed from your configured config database:

  • get_context_id, get_configdb_id

The following Stored Procedures have to be removed from the context schematas:

  • get_attachment_id, get_calendar_id, get_contact_id, get_folder_id, get_forum_id, get_gid_number_id, get_gui_setting_id, get_ical_id, get_infostore_id, get_mail_service_id, get_pinboard_id, get_principal_id, get_project_id, get_resource_group_id, get_resource_id, get_task_id, get_uid_number_id, get_unique_id, get_webdav_id

How to remove affected Stored Procedures?

To remove the obsolete Stored Procedures please execute the following statements with a database user having the appropriate privileges.

DROP PROCEDURE get_configdb_id;