Summary | migration script db user rights |
Queue | Horde Base |
Queue Version | Git master |
Type | Enhancement |
State | Accepted |
Priority | 1. Low |
Owners | |
Requester | rsalmon (at) mbpgroup (dot) com |
Created | 01/28/2011 (5220 days ago) |
Due | |
Updated | 01/29/2011 (5219 days ago) |
Assigned | |
Resolved | |
Milestone | |
Patch | No |
configuration entries. 1st because most people probably don't care and
use the same db user anyway, and 2nd because those that *do* care
probably don't want to put some superuser's credentials in a plain
text configuration file either.
State ⇒ Accepted
shouldn't need CREATE privileges anymore, since we won't be using
sequence tables.
using different credentials, or just adding another set of SQL
configs for administrative/table management use. Could be useful for
eventual table management UI, too.
this request.
State ⇒ Feedback
shouldn't need CREATE privileges anymore, since we won't be using
sequence tables.
I can see adding command-line arguments to the migration script for
using different credentials, or just adding another set of SQL configs
for administrative/table management use. Could be useful for eventual
table management UI, too.
of Horde, and the fact that up to now, horde sql user never had the
ALTER privilege, can the migration script check for all needed sql
privilege before running ?
admins will already get an error message if the migration fails. It's
up to the database to provide a useful error message.
consider adding user/password parameters to the migration script at
a later point.
script uses the sql user configured in horde.
permissions to create sequence tables. I don't see a good reason to
grant CREATE and DELETE permissions but not ALTER permissions.
to run the migration script, then the migration script doesn't need a
user/password parameters.
So, since lots of admin/user are going to update to the new version of
Horde, and the fact that up to now, horde sql user never had the ALTER
privilege, can the migration script check for all needed sql privilege
before running ?
This should prevent users from asking on the horde lists (or file a
bug) because the migration script doesn't run correctly. Right now the
migration script assume that sql user has all required privileges.
State ⇒ Rejected
adding user/password parameters to the migration script at a later
point.
But actually the Horde SQL user *always* needed at least CREATE
permissions to create sequence tables. I don't see a good reason to
grant CREATE and DELETE permissions but not ALTER permissions.
migration scripts are run with the sql user configured in horde now?
But I don't think this is a problem, unless you want a dedicated SQL
user for the migration tool.
State ⇒ Feedback
You didn't mention this, but I guess the real problem is that the
migration scripts are run with the sql user configured in horde now?
State ⇒ New
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Base
Summary ⇒ migration script db user rights
Type ⇒ Enhancement
Priority ⇒ 1. Low
the recent new migration scripts require the DB user to have the ALTER
privilege.
Can someone update scripts/sql/create.mysql.sql and add ALTER privilege.
I'm guessing that anyone who will update from Horde 3 to Horde 4 will
run into this issue.
Can the migration scripts check, before running, that the DB user has
the required privileges ?