netreg-users: [Fwd: NetReg andApache2]
Holger Honert
holger.honert at signal-iduna.org
Tue Apr 22 09:31:06 EDT 2008
Hi David,
here is the requested output :
mysql> select * from credentials;
+---------------------+----+--------------+------+-----------------------------+
| version | id | authid | user |
description |
+---------------------+----+--------------+------+-----------------------------+
| 2001-12-28 12:37:18 | 1 | netreg | 1 | Network Registration
System |
| 2008-04-18 13:32:06 | 2 | netreg-admin | 2 | Mr.
Admin |
+---------------------+----+--------------+------+-----------------------------+
2 rows in set (0.00 sec)
Regards,
Holger
David Nolan schrieb:
> 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
>>
>>
> ----------------------------------------------------------------
> NetReg Users -- www.cmu.edu/lists -- www.net.cmu.edu/netreg
>
>
>
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: holger_honert.vcf
Type: text/x-vcard
Size: 290 bytes
Desc: not available
Url : http://lists.andrew.cmu.edu/pipermail/netreg-users/attachments/20080422/149a79db/attachment.vcf
More information about the Netreg-users
mailing list