> Set loglevel in apache to debug and you should be seeing midgard debug
> messages as well.
Ok, done.
I found an interesting entry in the errorlog after trying to edit content
with midgard admin interface:
[Fri Nov 29 15:26:17 2002] [debug] mod_midgard.c [client 10.55.111.25]
Midgard: host record for sntde123.de.draeger.com:80 not found
But: all 'name' columns in the host table are set to 'sntde123.draeger.com'
and all ports are set to 80.
There was no conspicious entry while trying to log in to aegir.
> As for the mysql error (selecting type from style) can you send me a bit
> more of the log (10-20 lines around the error) so I can look into it
better.
Here you are, the log from the beginning:
use midgard;
SELECT id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE name
='sntde123.de.draeger.com' AND port IN (0,80) AND prefix=Left
('/admin/group/person/',Length(prefix)\
) AND IF(20>=Length(prefix),MID('/admin/group/person/',1+Length(prefix),1)
IN ('','/'),0)=1 AND online=1 ORDER BY prefix DESC, port DESC;
SELECT info&2 FROM page WHERE id=5;
SELECT name,value FROM pageelement WHERE page=5 AND info&1=1;
SELECT id,style,info&1,info&2 FROM page WHERE up=5 AND name='group';
SELECT name,value FROM pageelement WHERE page=7 AND info&1=1;
SELECT id,style,info&1,info&2 FROM page WHERE up=7 AND name='person';
SELECT name,value FROM pageelement WHERE page=12 AND info&1=1;
SELECT name,value FROM pageelement WHERE page=12 AND info&1=0;
SELECT title,content,author,style,info&1,up FROM page WHERE id=12;
SELECT CONCAT(firstname,' ',lastname) FROM person WHERE id=1;
SELECT admingroup FROM sitegroup WHERE id=0;
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;
SELECT gid FROM member WHERE uid=1 AND sitegroup in (0, 0) ORDER BY gid
DESC;
##############
SELECT type FROM style WHERE id=1;
##############
SELECT name,value FROM element WHERE style=1;
SELECT up FROM style WHERE id=1;
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,sitegroup FROM host WHERE id=1 AND (sitegroup in (0, 0)
OR 1<>0);
SELECT domain,name,value FROM record_extension WHERE tablename='host' AND
oid=1;
SELECT id,firstname,lastname,username,Concat(firstname,If(firstname=''
||lastname='','',' '),lastname) AS name,Concat(lastname,If(firstname=''
||lastname='','',', '),firstnam\
e) AS rname,If(Left(password,2)='**',Substring(password,3),'') AS
password,street,postcode,city,Concat(street,If(street!=''&&(postcode!=''
||city!=''),', ',''),postcode,If(p\
ostcode!=''&&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 A\
S extrap,sitegroup,sitegroup FROM person WHERE id=1 AND (sitegroup in (0,
0) OR 1<>0);
SELECT domain,name,value FROM record_extension WHERE tablename='person' AND
oid=1;
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,sitegroup FROM host WHERE id=1 AND (sitegroup in (0, 0)
OR 1<>0);
SELECT domain,name,value FROM record_extension WHERE tablename='host' AND
oid=1;
SELECT
id,up,topic,name,title,abstract,content,author,Date_format(created,'%d.%m.%Y')
AS date,Date_format(created,'%D %b. %Y') AS adate,Date_format(created,'%D
%M %Y') AS a\
ldate,extra1,extra2,extra3,article.score,type,Unix_Timestamp(created) AS
created,creator,Unix_Timestamp(revised) AS
revised,revisor,revision,Unix_Timestamp(approved) AS app\
roved,approver,Unix_Timestamp(locked) AS
locked,locker,url,icon,view,print,If(IsNull(calstart),'',If(caldays=0,Date_Format(calstart,'%d.%m.%Y'),Concat(Date_Format(calstart,
If(Year(calstart)!=Year(From_Days(To_Days(calstart)
+caldays)),'%d.%m.%Y',If(Month(calstart)!=Month(From_Days(To_Days(calstart)
+caldays)),'%d.%m.','%d.'))),Date_Format(From_\
Days(To_Days(calstart)+caldays),'-%d.%m.%Y')))) AS
calendar,If(IsNull(calstart),'',If(caldays=0,Date_Format(calstart,'%D %b.
%Y'),Concat(Date_Format(calstart,If(Year(calsta\
rt)!=Year(From_Days(To_Days(calstart)+caldays)),'%D %b.
%Y',If(Month(calstart)!=Month(From_Days(To_Days(calstart)+caldays)),'%D
%b.','%D'))),Date_Format(From_Days(To_Days(c\
alstart)+caldays),'-%D %b. %Y')))) AS
acalendar,If(IsNull(calstart),'',If(caldays=0,Date_Format(calstart,'%D %M
%Y'),Concat(Date_Format(calstart,If(Year(calstart)!=Year(Fro\
m_Days(To_Days(calstart)+caldays)),'%D %M
%Y',If(Month(calstart)!=Month(From_Days(To_Days(calstart)+caldays)),'%D
%M','%D'))),Date_Format(From_Days(To_Days(calstart)+calday\
s),'-%D %M %Y')))) AS alcalendar,Unix_Timestamp(calstart) AS
startdate,Unix_Timestamp(Date_Add(calstart, INTERVAL caldays DAY)) AS
enddate,caldays,Date_Format(calstart,'%d.\
%m.%Y') AS calstart,Date_Format(From_Days(To_Days(calstart)
+caldays),'%d.%m.%Y') As calstop,sitegroup,sitegroup FROM article WHERE
id=1 AND (sitegroup in (0, 0) OR 1<>0);
SELECT domain,name,value FROM record_extension WHERE tablename='article'
AND oid=1;
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
