[ 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 christian_boltz
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: Database
Group: SVN (please specify revision!)
Status: Open
Resolution: None
>Priority: 6
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: 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