[ postfixadmin-Bugs-1942748 ] One admin, multiple domains not possible

[SourceForge.net <no...@so...>]

Bugs item #1942748, was opened at 2008-04-15 08:59
Message generated for change (Comment added) made by episodeiv
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1942748&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
>Category: None
Group: SVN (please specify revision!)
Status: Open
Resolution: None
>Priority: 5
Private: No
Submitted By: Dennis Lichtenthäler (episodeiv)
Assigned to: Nobody/Anonymous (nobody)
Summary: One admin, multiple domains not possible

Initial Comment:
Even in recent SVN versions (tested r331) it's not possible to give one admin (not super-admin) access to more than one domain.
The 'admin' and 'domain_admins' tables are indexed by the 'username' column. Accordingly, two rows with the same username are impossible and trying to create them results in:
Invalid query: Duplicate entry 'admin_address@domain' for key 1

----------------------------------------------------------------------

>Comment By: Dennis Lichtenthäler (episodeiv)
Date: 2008-04-18 08:46

Message:
Logged In: YES 
user_id=2062640
Originator: YES

Removing the primary key manually (alter table domain_admins drop primary
key;) now allows me to assign more than one domain to an admin... So I
guess this was a leftover from a previous version that didn't get cleaned
up by upgrade.php?

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2008-04-18 07:15

Message:
Logged In: NO 

I ran upgrade.php. Using MySQL...
Don't you have primary keys set on the username fields??

----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2008-04-18 00:58

Message:
Logged In: YES 
user_id=593261
Originator: NO

Hmm, at least this works in my local test installation with mysql...

Two questions:
- did you update your database with upgrade.php?
- do you use mysql or postgresql?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1942748&group_id=191583