netreg-users: [Fwd: NetReg andApache2]
Holger Honert
holger.honert at signal-iduna.org
Tue Apr 22 09:51:05 EDT 2008
Hi David,
I have additional maybe useful infos. I have increased the logging
($debug=10)and I am getting this in my apache error logs:
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: /srv/netreg/lib/CMU/Netdb/auth.pm:2576
:>get_user_admin_status row: 1, at /srv/netreg/lib/CMU/Netdb/auth.pm
line 2576., referer: https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: /srv/netreg/lib/CMU/Netdb/primitives.pm:111
:>CMU::Netdb::primitives::can_read_all query: SELECT STRAIGHT_JOIN P.tid
FROM credentials AS C JOIN users as U ON C.user = U.id LEFT JOIN
memberships as M ON U.id = M.uid, protections as P WHERE C.authid =
'netreg-admin' AND P.tname = 'attribute', referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: AND FIND_IN_SET('READ', P.rights), referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: AND (P.identity = 0 OR (U.id = P.identity)OR
(M.gid * -1 = P.identity)), referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: AND P.tid = 0, referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: , referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: /srv/netreg/lib/CMU/Netdb/primitives.pm:256
:>CMU::Netdb::primitives::list query: SELECT DISTINCT attribute.id,
attribute.version, attribute.spec, attribute.owner_table,
attribute.owner_tid, attribute.data, attribute_spec.id,
attribute_spec.version, attribute_spec.name, attribute_spec.format,
attribute_spec.scope, attribute_spec.type, attribute_spec.description,
attribute_spec.ntimes FROM attribute, attribute_spec WHERE
attribute_spec.name = 'background-color' AND attribute.owner_table =
'users' AND attribute.owner_tid = 2 AND attribute.spec =
attribute_spec.id , referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: /srv/netreg/lib/CMU/Netdb/primitives.pm:130:
entering prune_restricted_fields at Tue Apr 22 15:49:25 2008 with 0 rows
of data, with 14 columns., referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
[Tue Apr 22 15:49:25 2008] [error] [client 172.27.100.16] [Tue Apr 22
15:49:25 2008] netreg.pl: /srv/netreg/lib/CMU/Netdb/primitives.pm:172
:>CMU::Netdb::primitives::prune_restricted_fields: Returning (no work to
do) at Tue Apr 22 15:49:25 2008, referer:
https://netreg.nwf.local/bin/netreg.pl?op=zone_list
Regards
Hiolger
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/f575b754/attachment-0001.vcf
More information about the Netreg-users
mailing list