Here is when I login with
admin*
password
**** error_log *******
[Thu Apr 5 15:11:12 2001] [debug] mod_midgard.c(1175): [client
65.193.90.132] midgard_translate_handler(latin1,
http://midgard.3abn.org:80/asgard)
[Thu Apr 5 15:11:12 2001] [debug]
/usr/local/midgard/include/midgard/select_db.h(20): [client
65.193.90.132] Midgard: select_database opened midgard
[Thu Apr 5 15:11:12 2001] [debug]
/usr/local/midgard/include/midgard/select_db.h(8): [client
65.193.90.132] Midgard: select_database kept current (midgard)
[Thu Apr 5 15:11:12 2001] [debug] mod_midgard.c(84): [client
65.193.90.132] Midgard: basic auth failed (-4)
**** end error_log ******
**** mysql.log *****
010405 15:12:59 7 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='midgard.3abn.org' AND port IN (0,80) AND
prefix=Left('/asgard',Length(prefix)) AND
IF(7>=Length(prefix),MID('/asgard',1+Length(prefix),1) IN ('','/'),0)=1
AND online=1 ORDER BY prefix DESC, port DESC
7 Query SELECT info&2 FROM page WHERE id=4
7 Query SELECT name,value FROM pageelement
WHERE page=4 AND info&1=1
7 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='midgard.3abn.org' AND port IN (0,80) AND
prefix=Left('/asgard',Length(prefix)) AND
IF(7>=Length(prefix),MID('/asgard',1+Length(prefix),1) IN ('','/'),0)=1
AND online=1 ORDER BY prefix DESC, port DESC
7 Query SELECT info&2 FROM page WHERE id=4
7 Query SELECT name,value FROM pageelement
WHERE page=4 AND info&1=1
010405 15:13:03 7 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='midgard.3abn.org' AND port IN (0,80) AND
prefix=Left('/asgard',Length(prefix)) AND
IF(7>=Length(prefix),MID('/asgard',1+Length(prefix),1) IN ('','/'),0)=1
AND online=1 ORDER BY prefix DESC, port DESC
7 Query SELECT info&2 FROM page WHERE id=4
7 Query SELECT name,value FROM pageelement
WHERE page=4 AND info&1=1
**** end mysql.log *****
When I login using
admin
password
Well it is more than you want to see, but since it works, it probally
looks just like any other logs.
So any insights?
When I'm logged in and I try to add a new person I get this, but there
are no errors. It just doesn't add them, or if it does I can't see them
with the interface.
[Thu Apr 5 15:16:58 2001] [debug] mod_midgard.c(1175): [client
65.193.90.132] midgard_translate_handler(latin1,
http://midgard.3abn.org:80/asgard/person//view/0.html)
[Thu Apr 5 15:16:58 2001] [debug]
/usr/local/midgard/include/midgard/select_db.h(20): [client
65.193.90.132] Midgard: select_database opened midgard
[Thu Apr 5 15:16:58 2001] [debug] mod_midgard.c(134): [client
65.193.90.132] Midgard: locating blob=[44]/view
[Thu Apr 5 15:16:58 2001] [debug]
/usr/local/midgard/include/midgard/select_db.h(8): [client
65.193.90.132] Midgard: select_database kept current (midgard)
[Thu Apr 5 15:16:58 2001] [debug] mod_midgard.c(1175): [client
65.193.90.132] midgard_translate_handler(latin1,
http://midgard.3abn.org:80/asgard/person//view/0.html)
[Thu Apr 5 15:16:58 2001] [debug]
/usr/local/midgard/include/midgard/select_db.h(45): [client
65.193.90.132] Midgard: select_database reused open (midgard)
[Thu Apr 5 15:16:58 2001] [debug] mod_midgard.c(134): [client
65.193.90.132] Midgard: locating blob=[44]/view
[Thu Apr 5 15:16:58 2001] [debug]
/usr/local/midgard/include/midgard/select_db.h(8): [client
65.193.90.132] Midgard: select_database kept current (midgard)
[Thu Apr 5 15:16:58 2001] [debug] mod_midgard.c(1272): [client
65.193.90.132] Midgard: using style #3 (44 elements)
[Thu Apr 5 15:16:58 2001] [debug]
/usr/local/midgard/include/midgard/select_db.h(8): [client
65.193.90.132] Midgard: select_database kept current (midgard)
and this
010405 15:16:58 9 Connect midgard@localhost on midgard
9 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='midgard.3abn.org' AND port IN (0,80) AND
prefix=Left('/asgard/person//view/0.html',Length(prefix)) AND
IF(27>=Length(prefix),MID('/asgard/person//view/0.html',1+Length(prefix)
,1) IN ('','/'),0)=1 AND online=1 ORDER BY prefix DESC, port DESC
9 Query SELECT info&2 FROM page WHERE id=4
9 Query SELECT name,value FROM pageelement
WHERE page=4 AND info&1=1
9 Query SELECT id,style,info&1,info&2 FROM
page WHERE up=4 AND name='person'
9 Query SELECT name,value FROM pageelement
WHERE page=44 AND info&1=1
9 Query SELECT id,style,info&1,info&2 FROM
page WHERE up=44 AND name='view'
9 Query SELECT id,location,mimetype FROM
blobs WHERE pid=44 AND ptable='page' AND name='view'
9 Query SELECT name,value FROM pageelement
WHERE page=44 AND info&1=0
9 Query SELECT
title,content,author,style,info&1 FROM page WHERE id=44
9 Query SELECT CONCAT(firstname,' ',lastname)
FROM person WHERE id=1
9 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='midgard.3abn.org' AND port IN (0,80) AND
prefix=Left('/asgard/person//view/0.html',Length(prefix)) AND
IF(27>=Length(prefix),MID('/asgard/person//view/0.html',1+Length(prefix)
,1) IN ('','/'),0)=1 AND online=1 ORDER BY prefix DESC, port DESC
9 Query SELECT info&2 FROM page WHERE id=4
9 Query SELECT name,value FROM pageelement
WHERE page=4 AND info&1=1
9 Query SELECT id,style,info&1,info&2 FROM
page WHERE up=4 AND name='person'
9 Query SELECT name,value FROM pageelement
WHERE page=44 AND info&1=1
9 Query SELECT id,style,info&1,info&2 FROM
page WHERE up=44 AND name='view'
9 Query SELECT id,location,mimetype FROM
blobs WHERE pid=44 AND ptable='page' AND name='view'
9 Query SELECT name,value FROM pageelement
WHERE page=44 AND info&1=0
9 Query SELECT
title,content,author,style,info&1 FROM page WHERE id=44
9 Query SELECT CONCAT(firstname,' ',lastname)
FROM person WHERE id=1
9 Query SELECT admingroup FROM sitegroup
WHERE id=0
9 Query SELECT person.id,person.password FROM
person,member WHERE person.username='admin' AND person.sitegroup=0 AND
member.uid = person.id AND member.gid=0
9 Query SELECT gid FROM member WHERE uid=1
AND sitegroup in (0, 0) ORDER BY gid DESC
9 Query SELECT type FROM style WHERE id=3
9 Query SELECT name,value FROM element WHERE
style=3
9 Query SELECT up FROM style WHERE id=3
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='debug') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=32 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='missing') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=19 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='tree') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=20 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Classes')
9 Query SELECT id FROM snippet WHERE (up=4
AND name='Template-base') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=11 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='user-options') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=21 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT
id,firstname,lastname,username,Concat(firstname,If(firstname=''||lastnam
e='','',' '),lastname) AS
name,Concat(lastname,If(firstname=''||lastname='','',', '),firstname) AS
rname,If(Left(password,2)='**',Substring(password,3),'') AS
password,street,postcode,city,Concat(street,If(street!=''&&(postcode!=''
||city!=''),', ',''),postcode,If(postcode!=''&&city!='',' ',''),city) AS
address,handphone,homephone,workphone,Concat(handphone,If(handphone=''||
(homephone=''&&workphone=''),'',',
'),homephone,If(homephone=''||workphone='','',',
'),workphone,If(workphone='','',' (työ)')) AS
phone,homepage,If(homepage='','',Concat('<a href=\"',homepage,'\"
title=\"',firstname,' ',lastname,'\">',homepage,'</a>')) AS
homepagelink,email,If(email='','',Concat('<a href=\"mailto:',email,'\"
title=\"',firstname,' ',lastname,'\">',email,'</a>')) AS
emaillink,Date_format(birthdate,'%d.%m.%Y') AS
birthdate,extra,img,topic,department,office,pgpkey,info&2=2 AS
addressp,info&4=4 as phonep,info&8=8 AS homepagep,info&16=16 AS
emailp,info&32=32 AS extrap,sitegroup FROM person WHERE id=1 AND
(sitegroup in (0, 0) OR 1<>0)
9 Query SELECT domain,name,value FROM
record_extension WHERE tablename='person' AND oid=1
9 Query SELECT domain,name,value FROM
record_extension WHERE (tablename='person' AND oid=1 AND
domain='Asgard') ORDER BY name
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='misc') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=8 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='msgparser') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=9 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Messages')
9 Query SELECT id FROM snippet WHERE (up=2
AND name='en_US') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=30 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT
id,name,port,online,root,style,info&1 AS
auth,owner,prefix,Concat('http', If(host.port=443, 's',''), '://',
host.name, If(host.port=0 || host.port=443, '', Concat(':',
host.port)),If(host.prefix='/', '/', Concat(host.prefix, '/'))) AS
hostname,sitegroup FROM host WHERE id=3 AND (sitegroup in (0, 0) OR
1<>0)
9 Query SELECT domain,name,value FROM
record_extension WHERE tablename='host' AND oid=3
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='basic') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=12 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='paths') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=5 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Functions')
9 Query SELECT id FROM snippet WHERE (up=3
AND name='help') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=6 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT id FROM snippetdir WHERE (up=0
AND name='Asgard')
9 Query SELECT id FROM snippetdir WHERE (up=1
AND name='Classes')
9 Query SELECT id FROM snippet WHERE (up=4
AND name='Tree') AND (sitegroup IN (0,0) OR 1<>0)
9 Query SELECT code,sitegroup FROM snippet
WHERE id=36 AND (sitegroup in (0, 0) OR 1<>0)
9 Query SELECT
id,firstname,lastname,username,Concat(firstname,If(firstname=''||lastnam
e='','',' '),lastname) AS
name,Concat(lastname,If(firstname=''||lastname='','',', '),firstname) AS
rname,If(Left(password,2)='**',Substring(password,3),'') AS
password,street,postcode,city,Concat(street,If(street!=''&&(postcode!=''
||city!=''),', ',''),postcode,If(postcode!=''&&city!='',' ',''),city) AS
address,handphone,homephone,workphone,Concat(handphone,If(handphone=''||
(homephone=''&&workphone=''),'',',
'),homephone,If(homephone=''||workphone='','',',
'),workphone,If(workphone='','',' (työ)')) AS
phone,homepage,If(homepage='','',Concat('<a href=\"',homepage,'\"
title=\"',firstname,' ',lastname,'\">',homepage,'</a>')) AS
homepagelink,email,If(email='','',Concat('<a href=\"mailto:',email,'\"
title=\"',firstname,' ',lastname,'\">',email,'</a>')) AS
emaillink,Date_format(birthdate,'%d.%m.%Y') AS
birthdate,extra,img,topic,department,office,pgpkey,info&2=2 AS
addressp,info&4=4 as phonep,info&8=8 AS homepagep,info&16=16 AS
emailp,info&32=32 AS extrap,sitegroup FROM person WHERE id=1 AND
(sitegroup in (0, 0) OR 1<>0)
9 Query SELECT domain,name,value FROM
record_extension WHERE tablename='person' AND oid=1
9 Query SELECT id,value,sitegroup FROM
record_extension WHERE tablename='person' AND oid=1 AND
domain='AsgardTreePerson' AND name='selected'
9 Query UPDATE record_extension SET
value='person0' WHERE id=41 AND (sitegroup = 0 OR 1<>0)
9 Query UPDATE repligard SET
changed=NULL,action='update' WHERE id=41 AND realm='record_extension'
9 Query SELECT domain,name,value FROM
record_extension WHERE (tablename='person' AND oid=1 AND
domain='AsgardTreePerson') ORDER BY name
9 Query SELECT * FROM sitegroup WHERE (1=1)
ORDER BY name
9 Query SELECT id,value,sitegroup FROM
record_extension WHERE tablename='person' AND oid=1 AND
domain='AsgardTreePerson' AND name='sitegroup0_person0'
9 Query UPDATE record_extension SET value='1'
WHERE id=42 AND (sitegroup = 0 OR 1<>0)
9 Query UPDATE repligard SET
changed=NULL,action='update' WHERE id=42 AND realm='record_extension'
9 Query SELECT
id,username,Concat(firstname,If(firstname=''||lastname='','','
'),lastname) AS name,Concat(lastname,If(firstname=''||lastname='','',',
'),firstname) AS rname,extra,topic,department,office,info&1 AS
admin,info>1 AS public,sitegroup FROM person WHERE (1=1) ORDER BY
lastname,firstname
9 Query SELECT
id,firstname,lastname,username,Concat(firstname,If(firstname=''||lastnam
e='','',' '),lastname) AS
name,Concat(lastname,If(firstname=''||lastname='','',', '),firstname) AS
rname,If(Left(password,2)='**',Substring(password,3),'') AS
password,street,postcode,city,Concat(street,If(street!=''&&(postcode!=''
||city!=''),', ',''),postcode,If(postcode!=''&&city!='',' ',''),city) AS
address,handphone,homephone,workphone,Concat(handphone,If(handphone=''||
(homephone=''&&workphone=''),'',',
'),homephone,If(homephone=''||workphone='','',',
'),workphone,If(workphone='','',' (työ)')) AS
phone,homepage,If(homepage='','',Concat('<a href=\"',homepage,'\"
title=\"',firstname,' ',lastname,'\">',homepage,'</a>')) AS
homepagelink,email,If(email='','',Concat('<a href=\"mailto:',email,'\"
title=\"',firstname,' ',lastname,'\">',email,'</a>')) AS
emaillink,Date_format(birthdate,'%d.%m.%Y') AS
birthdate,extra,img,topic,department,office,pgpkey,info&2=2 AS
addressp,info&4=4 as phonep,info&8=8 AS homepagep,info&16=16 AS
emailp,info&32=32 AS extrap,sitegroup FROM person WHERE id=1 AND
(sitegroup in (0, 0) OR 1<>0)
9 Query SELECT domain,name,value FROM
record_extension WHERE tablename='person' AND oid=1
9 Query SELECT
id,name,title,mimetype,score,author,created,sitegroup FROM blobs WHERE
(ptable='person' AND pid=1)
9 Query SELECT DISTINCT domain FROM
record_extension WHERE (tablename='person' AND oid=1) ORDER BY domain
9 Query SELECT distinct member.id AS id, gid,
IF(gid!=0,name,'Midgard Administrators') AS name,member.sitegroup FROM
grp,member WHERE (member.uid=1 AND member.gid IN (0,grp.id)) ORDER BY
name
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
