netreg-users: [Fwd: NetReg andApache2]

[David Nolan]

Holger,

Can you show us a 'select * from credentials' as well please?  The
actual userids are stored in the credentials table, as a single netreg
user can have multiple userids.

-David

2008/4/22 Holger Honert <holger.honert at signal-iduna.org>:
> Hi Frank,
>
>  thx for your advice, but my problem solved your hint on erwin.wpi.edu for
> "Prepare for MySQL 5".
>  Now I am able to view the zones but unable to add a new one (step by step
> I'm deeper in the jungle ;-)).
>
>  My version of mysql is the folllowing:
>
>  mysql  Ver 14.12 Distrib 5.0.26, for suse-linux (i686) using readline 5.1
>
>  In my opinion the user is member of the group netreg:admins:
>
>  mysql> select * from groups
>    -> ;
>
> +---------------------+-----+-----------------+-----------------+------------------------+--------------+--------------+
>  | version             | id  | name            | flags           |
> description            | comment_lvl9 | comment_lvl5 |
>
> +---------------------+-----+-----------------+-----------------+------------------------+--------------+--------------+
>  | 2001-11-15 11:23:34 |   1 | netreg:admins   | purge_mailusers | Network
> Administrators |              |              |
>  | 2001-12-28 14:09:26 | 150 | dept:president  |                 |
> Presidents Office      |              |              |
>  | 2001-12-28 14:09:17 | 149 | dept:compserv   |                 | Computing
> Services     |              |              |
>  | 2001-12-28 12:36:29 | 148 | netreg:fullread |                 | NetReg
> Readers         |              |              |
>
> +---------------------+-----+-----------------+-----------------+------------------------+--------------+--------------+
>  4 rows in set (0.00 sec)
>
>  mysql> select * from users;
>  +---------------------+----+-------+-----------------------------+
>  | version             | id | flags | comment                     |
>  +---------------------+----+-------+-----------------------------+
>  | 2001-12-28 12:37:18 |  1 |       | Network Registration System |
>  | 2008-04-18 13:31:13 |  2 |       | NetReg Admin Account        |
>  +---------------------+----+-------+-----------------------------+
>  2 rows in set (0.00 sec)
>
>  mysql> select * from memberships
>    -> ;
>  +---------------------+----+-----+-----+
>  | version             | id | uid | gid |
>  +---------------------+----+-----+-----+
>  | 2001-12-28 12:40:41 |  1 |   1 |   1 |
>  | 2008-04-18 13:32:22 |  2 |   2 |   1 |
>  +---------------------+----+-----+-----+
>  2 rows in set (0.00 sec)
>
>
>
>  Kind Regards
>
>  Holger
>
>
>
>  Frank Sweetser schrieb:
>
> > Holger Honert wrote:
> >
> >
> > > Hi again,
> > >
> > > due to the hints from Danial and Frank I am now able to log in ;-)
> > > Thx a lot guys!
> > >
> > > But with the user which I created accordingly in the step "Database
> Installation" from the admin manual, I am not able to manage or create e.g.
> Zones.
> > >
> > > Do I have to give this special user additional rights ?
> > >
> > >
> >
> > Try adding the user to the netreg:admins group.
> >
> >
> >
>
>
>
>
>  SIGNAL Krankenversicherung a. G.
>  Sitz: Dortmund, HR B 2405 AG Dortmund, Ust-IdNr. DE 124906350
>  IDUNA Vereinigte Lebensversicherung aG fur Handwerk, Handel und Gewerbe
>  Sitz: Hamburg, HR B 2740 AG Hamburg, Ust-IdNr. DE 118617622
>  SIGNAL Unfallversicherung a. G.
>  Sitz: Dortmund, HR B 2220, AG Dortmund, Ust-IdNr. DE 124906341
>  SIGNAL IDUNA Allgemeine Versicherung AG
>  Sitz: Dortmund, HR B 19108, AG Dortmund, Ust-IdNr. DE 118617622
>
>  Vorstande:
>  Reinhold Schulte (Vorsitzender), Dr. Karl-Josef Bierth, Michael Johnigk,
>  Ulrich Leitermann, Michael Petmecky, Dr. Klaus Sticker, Vorsitzender der
>  Aufsichtsrate: Gunter Kutz
>
>  SIGNAL IDUNA Gruppe Hauptverwaltungen, Internet: www.signal-iduna.de,
>  E-Mail: info at signal-iduna.de
>
>  44121 Dortmund, Hausanschrift: Joseph-Scherer-Str. 3, 44139 Dortmund,
>  Telefon: (02 31) 1 35-0, Telefax: (02 31) 1 35-46 38
>
>  20351 Hamburg, Hausanschrift: Neue Rabenstra?e 15-19, 20354 Hamburg,
>  Telefon: (0 40) 41 24-0, Telefax: (0 40) 41 24-29 58
>
> ----------------------------------------------------------------
>  NetReg Users -- www.cmu.edu/lists -- www.net.cmu.edu/netreg
>