netreg-users: [Fwd: NetReg andApache2]

[Holger Honert]

Hi again,

after browsing in the archives I am step further.

I have added netreg at localhost as mentioned in thread

http://lists.andrew.cmu.edu/pipermail/netreg-users/2007-February/000274.html

(Thx Matt!)

But now I got the error in my browser : "Unable to view user information 
(authenticated as: )."

The apache-log says:

[Fri Apr 18 10:05:02 2008] [error] [client 172.27.100.16] [Fri Apr 18 
10:05:02 2008] netreg.pl: /srv/netreg/lib/CMU/Netdb/va
lidity.pm:267 :>Validation of credentials.authid (undef) failed: -12 at 
/srv/netreg/lib/CMU/Netdb/validity.pm line 267., ref
erer: https://netreg.nwf.local/

The mysql-log says:

080418 10:05:02       2 Connect     netreg-web at localhost on netdb
                      2 Query       set autocommit=1
                      2 Query       SELECT sys_value FROM _sys_info 
WHERE sys_key = 'DB_OFFLINE'
                      2 Query       SELECT G.id, U.flags
FROM        credentials AS C
  LEFT JOIN users AS U ON C.user = U.id
  LEFT JOIN memberships AS M ON M.uid = U.id
  LEFT JOIN groups AS G on G.id = M.gid
WHERE C.authid = 'netreg' AND
      (G.name like 'netreg:%' OR
       FIND_IN_SET('suspend', U.flags))
                      2 Query       SELECT STRAIGHT_JOIN P.tid FROM 
credentials AS C JOIN users as U ON C.user = U.id LEFT J
OIN memberships as M ON U.id = M.uid, protections as P WHERE C.authid = 
'netreg' AND P.tname = 'users'
AND FIND_IN_SET('READ', P.rights)
AND (P.identity = 0 OR (U.id = P.identity)OR (M.gid * -1 = P.identity))
AND P.tid = 0
                      2 Query       SELECT DISTINCT users.id, 
users.version, users.flags, users.comment, credentials.id, cre
dentials.version, credentials.user, credentials.authid, 
credentials.description FROM users JOIN credentials ON credentials.u
ser = users.id WHERE credentials.authid = ''
                      2 Query       SELECT G.id, U.flags
FROM        credentials AS C
  LEFT JOIN users AS U ON C.user = U.id
  LEFT JOIN memberships AS M ON M.uid = U.id
  LEFT JOIN groups AS G on G.id = M.gid
WHERE C.authid = '' AND
      (G.name like 'netreg:%' OR
       FIND_IN_SET('suspend', U.flags))
                      2 Quit


My versions are :

mysqld  Ver 5.0.26-log for suse-linux on i686 (SUSE MySQL RPM)

apache2-prefork-2.2.3-16.15

Kind Regards

Holger



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/20080418/a32c7f5b/attachment.vcf