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]

Reply via email to