|
|
Line 1: |
Line 1: |
− | {{VersionFrom|7.8.0}} | + | {{Migration|title=DB-User Privileges|link=https://documentation.open-xchange.com/7.10.2/middleware/administration/db_user_privileges.html}} |
− | | |
− | <div class="title">Remove obsolete MySQL Stored Procedures from databases</div>
| |
− | | |
− | '''Summary''': This article tells you why and how to remove already existing but obsolete MySQL Stored Procedures from the various databases.
| |
− | | |
− | __TOC__
| |
− | | |
− | == 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:
| |
− | | |
− | <code><pre>get_context_id, get_configdb_id</pre></code>
| |
− | | |
− | The following Stored Procedures have to be removed from the context schematas:
| |
− | | |
− | <code><pre>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</pre></code>
| |
− | | |
− | == How to remove affected Stored Procedures? ==
| |
− | | |
− | Connect to mysql as a privileged user and run the following commands.
| |
− | | |
− | List all procedures owned/created by openexchange (assuming you did not change the default
| |
− | name of that account):
| |
− | | |
− | <pre>
| |
− | mysql> SELECT name,definer FROM mysql.proc WHERE definer LIKE "openexchange@%";
| |
− | +-----------------------+------------------------+
| |
− | | name | definer |
| |
− | +-----------------------+------------------------+
| |
− | | get_context_id | openexchange@localhost |
| |
− | | get_configdb_id | openexchange@localhost |
| |
− | | get_gid_number_id | openexchange@localhost |
| |
− | | get_mail_service_id | openexchange@localhost |
| |
− | | get_infostore_id | openexchange@localhost |
| |
− | | get_forum_id | openexchange@localhost |
| |
− | | get_pinboard_id | openexchange@localhost |
| |
− | | get_gui_setting_id | openexchange@localhost |
| |
− | | get_ical_id | openexchange@localhost |
| |
− | | get_attachment_id | openexchange@localhost |
| |
− | | get_webdav_id | openexchange@localhost |
| |
− | | get_uid_number_id | openexchange@localhost |
| |
− | | get_unique_id | openexchange@localhost |
| |
− | | get_resource_id | openexchange@localhost |
| |
− | | get_resource_group_id | openexchange@localhost |
| |
− | | get_principal_id | openexchange@localhost |
| |
− | | get_folder_id | openexchange@localhost |
| |
− | | get_calendar_id | openexchange@localhost |
| |
− | | get_contact_id | openexchange@localhost |
| |
− | | get_task_id | openexchange@localhost |
| |
− | | get_project_id | openexchange@localhost |
| |
− | +-----------------------+------------------------+
| |
− | 21 rows in set (0.00 sec)
| |
− | </pre>
| |
− | | |
− | | |
− | If this list seems ok, delete these procedures using the command below:
| |
− | | |
− | <pre>
| |
− | mysql> DELETE FROM mysql.proc WHERE definer LIKE "openexchange@%";
| |
− | Query OK, 21 rows affected (0.00 sec)
| |
− | </pre>
| |
− | | |
− | | |
− | [[Category: OX7]]
| |
− | [[Category: AppSuite]]
| |
− | [[Category: Administrator]]
| |
− | [[Category: Database]]
| |
− | [[Category: Security]]
| |