Hi Emile,
On 03-Apr-01 Emiliano wrote:
> Ralf Eisinger wrote:
>>
>> Hi,
>>
>> I have setup midgard with apache 1.3.14, php4 (latest revision: 1.4.pl1).
>> Compiling and installing leed to no problems.
>> When I try to access the admin site, the user auth is requested. After
>> typing
>> the user and password,
>> netscape tells me, that the URL contains no data :-(
>
> We've been seeing problems with PHP compiled with the internal
> libmysqlclient (not
> a Midgard problem only, any extension that uses MySQL like Midgard will
> have
> this problem. When compiling PHP, use --with-mysql=/path/, not just
> --with-mysql. If anyone knows how to detect this during configure, I'd
> appreciate the info.
>
> If that isn't the issue, do a strace against httpd -X, and turn on MySQL
> logging to gather context so we have an idea where/why this is
> happening.
I have compiled all once again with --with-mysql=/usr, but sorry, same problem:
the mysql logfile shows:
----- snip ----
010403 11:04:44 2 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='www.hvw-online.or
g' AND port IN (0,80) AND prefix=Left('/admin/',Length(prefix)) AND
IF(7>=Length(prefix),MID('/admin/',1+Length(prefix),1) IN (
'','/'),0)=1 AND online=1 ORDER BY prefix DESC, port DESC
2 Query SELECT info&2 FROM page WHERE id=5
2 Query SELECT name,value FROM pageelement WHERE
page=5 AND info&1=1
2 Query SELECT name,value FROM pageelement WHERE
page=5 AND info&1=0
2 Query SELECT title,content,author,style,info&1
FROM page WHERE id=5
2 Query SELECT CONCAT(firstname,' ',lastname) FROM
person WHERE id=1
2 Query SELECT admingroup FROM sitegroup WHERE id=0
2 Query SELECT person.id,person.password FROM
person,member WHERE person.username='admin' AND person.sitegroup=0 A
ND member.uid = person.id AND member.gid=0
2 Query SELECT gid FROM member WHERE uid=1 AND
sitegroup in (0, 0) ORDER BY gid DESC
2 Query SELECT type FROM style WHERE id=1
2 Query SELECT name,value FROM element WHERE style=1
2 Query SELECT up FROM style WHERE id=1
---- snap ------
The Query "SELECT type FROM style WHERE id=1" didn't work, because there
is no column "type" in the style table. But I think, that is not the reason for
crashing.
strace (only the last lines):
---- snip ------
...
read(5, "\6table1\3745\2<TABLE BORDER=\"0\" CELL"..., 575) = 575
read(5, "\220\6\0\22", 4) = 4
read(5, "\6table2\374\206\6<TABLE BORDER=\"0\" CELL"..., 1680) = 1680
read(5, "\202\1\0\23", 4) = 4
read(5, "\7version\374w\1<!--\nMidgard Admin Si"..., 386) = 386
read(5, "\1\0\0\24", 4) = 4
read(5, "\376", 1) = 1
shmat(5, 0, 0x4ptrace: umoven: Input/output error
) = ?
read(5, 0x81595e0, 8192) = -1 EAGAIN (Resource temporarily
unavailable)
shmat(5, 0, 0x4ptrace: umoven: Input/output error
) = ?
write(5, " \0\0\0\3SELECT up FROM style WHERE "..., 36) = 36
read(5, "\1\0\0\1", 4) = 4
read(5, "\1", 1) = 1
read(5, "\23\0\0\2", 4) = 4
read(5, "\5style\2up\3\v\0\0\1\3\3\t@\0", 19) = 19
read(5, "\1\0\0\3", 4) = 4
read(5, "\376", 1) = 1
read(5, "\2\0\0\4", 4) = 4
read(5, "\0010", 2) = 2
read(5, "\1\0\0\5", 4) = 4
read(5, "\376", 1) = 1
time(NULL) = 986292387
write(15, "[Tue Apr 3 12:06:27 2001] [debu"..., 117) = 117
time(NULL) = 986292387
write(15, "[Tue Apr 3 12:06:27 2001] [debu"..., 149) = 149
stat64("/usr/lib/apache/midgard-root.php", {st_mode=S_IFREG|0644, st_size=955,
...}) = 0
lstat64("/usr", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat64("/usr/lib", {st_mode=S_IFDIR|0755, st_size=16384, ...}) = 0
lstat64("/usr/lib/apache", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat64("/usr/lib/apache/midgard-root.php", {st_mode=S_IFREG|0644, st_size=955,
...}) = 0
alarm(300) = 0
umask(077) = 022
umask(022) = 077
setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={300, 0}}, NULL) = 0
rt_sigaction(SIGPROF, {0x40345540, [PROF], SA_RESTART|0x4000000}, {SIG_DFL}, 8)
= 0
rt_sigprocmask(SIG_UNBLOCK, [PROF], NULL, 8) = 0
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
--- snap --------
I have collected some more additional infos:
httpd -v:
Apache/1.3.14 (Unix) (SuSE/Linux) Midgard/1.4.1-dev/SG PHP/4.0.4pl1
mod_ssl/2.7.1 OpenSSL/0.9.6
mysql --version:
mysql Ver 11.12 Distrib 3.23.33
My options to the different configure scripts:
# Midgard-Lib
./configure --with-mysql=/usr --with-sitegroups --with-expat
--with-repligard-owner
# Mod_Midgard
./configure --with-apxs --with-mysql=/usr
# PHP4
./configure --with-mysql=/usr
# MOD_MIDGARD_PHP
./mkall
Hope that helps you (and me too ;-)
Thanks
Ralf Eisinger
-------------------
IHS - University of Stuttgart, Germany
Pfaffenwaldring 10
70150 Stuttgart
Phone: (0049)-711-685-3201
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]