Sergio Bruder wrote:
> SELECT person.id,person.password FROM person,member
> WHERE person.username='bruder' AND person.sitegroup=0 AND
> member.uid = person.id AND member.gid=0
> Empty set (0.01 sec)
This is an SG authorization query.
> HMmm. This 'member' table is new to me.
>
> select * from member where member.uid=2;
> +----+-----+-----+-------+------+-----------+
> | id | uid | gid | extra | info | sitegroup |
> +----+-----+-----+-------+------+-----------+
> | 5 | 2 | 1 | | | 0 |
> | 4 | 2 | 2 | | | 0 |
> | 7 | 2 | 4 | | | 0 |
> | 31 | 2 | 17 | | | 0 |
> +----+-----+-----+-------+------+-----------+
> 4 rows in set (0.00 sec)
>
> bruder account doenst have a row in member table with gid=0, that's
> it.
Adding that would make him root.
> Is that query correct for a non-sitegroup installation?
Nope. I just checked, and
distro.conectiva.com.br is running with SGs enabled.
Emile
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
