postfixadmin-devel

Re: [Postfixadmin-devel] SF.net SVN: postfixadmin: [178] trunk/DOCUMENTS/SUPERADMIN.TXT

[Christian B. <pos...@cb...>]

Hello,

Am Samstag, 3. November 2007 schrieb Gin...@us...:
> Revision: 178
> Author:   GingerDog

> SUPERADMIN.TXT: updating docs

> +(The domain 'ALL' should already exist in the domain table; if not
> you'll need to recreate it)

Huh? I don't have 'ALL' in my domain table don't see problems.
Why do you think it should be added?


Regards,

Christian Boltz
-- 
Why do you focus so much on _new_ technology? -- New is better. Is
nothink old that is better than new. -- Yes there is. -- Da? Namink
one then. -- The Original Pentium versus counting on your fingers.
-- Da. Da. "Don't divide. Intel inside"  [Sid & Pitr in userfriendly]

Re: [Postfixadmin-devel] SF.net SVN: postfixadmin: [178] trunk/DOCUMENTS/SUPERADMIN.TXT

[David G. <da...@co...>]

Christian Boltz wrote :
> Hello,
> 
> Am Samstag, 3. November 2007 schrieb Gin...@us...:
> > Revision: 178
> > Author:   GingerDog
> 
> > SUPERADMIN.TXT: updating docs
> 
> > +(The domain 'ALL' should already exist in the domain table; if not
> > you'll need to recreate it)
> 
> Huh? I don't have 'ALL' in my domain table don't see problems.
> Why do you think it should be added?
> 

Certainly with PostgreSQL, there's a foreign key between
domain_admins.domain and domain.domain - hence domain.domain = 'ALL'
needs to exist first.

Perhaps MySQL either doesn't check the fkey, or doesn't have the fkey
there?

thanks
David.

-- 
David Goodwin 

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]

Re: [Postfixadmin-devel] SF.net SVN: postfixadmin: [178] trunk/DOCUMENTS/SUPERADMIN.TXT

[Christian B. <pos...@cb...>]

Hello,

Am Samstag, 3. November 2007 schrieb David Goodwin:
> Christian Boltz wrote :
> > Am Samstag, 3. November 2007 schrieb 
Gin...@us...:
> > > SUPERADMIN.TXT: updating docs
> > >
> > > +(The domain 'ALL' should already exist in the domain table; if
> > > not you'll need to recreate it)
> >
> > Huh? I don't have 'ALL' in my domain table don't see problems.
> > Why do you think it should be added?
>
> Certainly with PostgreSQL, there's a foreign key between
> domain_admins.domain and domain.domain - hence domain.domain = 'ALL'
> needs to exist first.
>
> Perhaps MySQL either doesn't check the fkey, or doesn't have the fkey
> there?

MySQL doesn't have this foreign key, and I don't think it is really 
useful.

OTOH, Postfix sees the domain "ALL" and will (theoretically) accept 
mails on it...

I vote for dropping the foreign key in PostgreSQL and then deleting 
the "ALL" domain from the database. Both should be done in upgrade.php.


Regards,

Christian Boltz
-- 
Linux - Life is too short for reboots

Re: [Postfixadmin-devel] SF.net SVN: postfixadmin: [178] trunk/DOCUMENTS/SUPERADMIN.TXT

[David G. <da...@co...>]

> MySQL doesn't have this foreign key, and I don't think it is really=20
> useful.
>=20
> OTOH, Postfix sees the domain "ALL" and will (theoretically) accept=20
> mails on it...
>=20
> I vote for dropping the foreign key in PostgreSQL and then deleting=20
> the "ALL" domain from the database. Both should be done in upgrade.php.

So, presumably a different way is needed to mark an admin as a
global-admin? Do we need a new field in the user table?

I presumed Postfix would never see the field, as it's set to inactive
(in the domain table) - isn't it?

thanks
David.

--=20
David Goodwin=20

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]