Bug 157975

Summary: Conflict with Mozilla and Konqueror by using APACHE and MySQL
Product: [openSUSE] SUSE LINUX 10.0 Reporter: Michael Lanczak <mlmuit>
Component: OtherAssignee: E-mail List <bnc-team-screening>
Status: RESOLVED INVALID QA Contact: E-mail List <qa-bugs>
Severity: Normal    
Priority: P5 - None CC: suse-beta
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: SuSE Linux 10.0   
Whiteboard:
Found By: System Test Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---

Description Michael Lanczak 2006-03-14 15:49:56 UTC
Mozilla is only able to safe or open PHP-data, executing is not possible.

If I use and execute a PHP-data, it works with Konqueror correct. 
But if I install the Apache-Server with MySQL, I can't perform any links or transmit any form data by PHP-data. Then appears a form which orders to open or safing this data as text-file! Executing is now not possible!

I did following experiment, that I am sure:
I installed LINUX complete new, run the same PHP-data, and it works correctly.
But if I install the Apache-Server with MySQL, I get the same problem.
Firefox handles this permanent correctly!
Comment 1 Michael Gross 2006-03-15 15:01:14 UTC
This has nothing to do with the used browser. If you save the file, what is its contents? Can you see the PHP code or does it contain the processed HTML code? Looks like a configuration problem to me. Which machine are you trying this on? Rootserver providers sometimes corrupt the standard-installation as a feature, had a similiar problem lately.
Comment 2 Michael Lanczak 2006-03-16 11:22:26 UTC
Answer from esddss@freenet.de, Michael Lanczak

If I call a HTML or PHP-data by the Konqueror-browser, then I get the correct  processed code from the browser, so a performable webside. 
But the strange problem is the transmitting any form data by HTML- or PHP-data with the command <form action ...>, if I installed the Apache-Server with MySQL. Then appears a form which orders to safe this (source code)data by another form ('Speichern unter', 'Safe with') or open as text-file with the texteditor 'Kate', but no transmitting runs! 
Before installing the Apache-Server with MySQL, the transmitting runs correct!

Please test following test data 'ein.html' and 'aus.php' (called by ein.html)
1) Before installing with Apache-Server with MySQL
2) After installing with Apache-Server with MySQL:

Data 'ein.html':
<html>
<body>
  <form action="aus.php" method="post">
    Bitte Text eingeben: <input type="text" name="buchtitel">
    <br/><br/>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Passwort: <input type="password" name="pass">
    <br/><br/>
    <input type="checkbox" name="grossklein" checked value="angekreuzt">
    Gross- und Kleinschreibung
    <br/><br/>
    Bitte die Sprache der B&uuml;cher angeben:<br/>
    <input type="radio" name="sprache" checked value="d">Deutsch
    <input type="radio" name="sprache" value="e">English
    <input type="radio" name="sprache" value="a">Esperanto
    <br/><br/>

    <input type="reset" value="Eingabe l&ouml;schen">
    <input type="submit">
  </form>
</body>
</html>

Data aus.php':
<html>
<body>
  <?php
    printf("<pre>Browser: %s",$HTTP_USER_AGENT);
    printf("<br/>Nutzer IP-Adresse: %s",$REMOTE_ADDR);
    printf("<br/>Aufruf von URL: %s</pre>",$HTTP_REFERER);
    printf("<br/><br/>");

    printf("<br/>Eingabe war: ");
    print $_POST["buchtitel"];
    printf("<br/>Passwort = ");
    print $_POST["pass"];
    printf("<br/>");

    if($_POST["grossklein"] == "angekreuzt")
	{
	printf("Checkbox angekreuzt<br/>");
	}
    else
	{
	printf("Checkbox nicht angekreuzt<br/>");
	}

    switch($_POST["sprache"])
	{
	case "d":  printf("Deutsch");break;
	case "e":  printf("English");break;
	case "a":  printf("Esperanto");break;
	default: printf("Deutsch");
	}
  ?>
<br/><br/>
<a href="ein.html">zur Eingabe</a>
</body>
</html>

By the way, with variables like '$HTTP_USER_AGENT' you see no output, they are empty!
I work with a machine with Pentium4 3GHz, Cache 2048, LINUX GRUB-Bootsystem with Windows and Linux Operatingsystems on one harddisk.
Comment 3 Christian Boltz 2006-03-16 12:25:23 UTC
(In reply to comment #2)
> By the way, with variables like '$HTTP_USER_AGENT' you see no output, they 
> are empty!

That's because register_globals is off. Use $_SERVER['HTTP_USER_AGENT'] instead.

The main issue still remains (but it doesn't seem to be a general problem because I have Apache, PHP and MySQL running).
BTW: Does it work again after   rpm -e php4-mysql ; rcapache restart   ?

BTW2: Forgotten to reset NEEDINFO?
Comment 4 Michael Gross 2006-03-16 13:00:48 UTC
I don't think this makes sense for me to test that way. Provide more information: Which versions of Apache and PHP are you using (rpm -qv apache*, rpm -qv php*)?

Attach the following files/directories:
/etc/apache2 (complete dir)
/etc/php.ini

Try setting safe_mode=off in /etc/php.ini but notice the security losses.
Does the script work if you use <form action="ein.php"> in `ein.php' - posting the data to the same script, not another?

Why don't you get any output from the server? Perform your tests and attach the last 50 lines of your apache logs for this (virtual) server.

Furthermore attach /var/log/apache2/error_log here.
Comment 5 Michael Lanczak 2006-03-17 21:04:25 UTC
My answer to Comment #3:
A lot of thanks for your valuable hint with the variables like  $_SERVER['HTTP_USER_AGENT'] ! All works now correctly! 
Here I must say, that's the same problem like my commants about the exercises by the newest edition(!) of a professional exercise book from a High-School for information science with the register_globals!
----------------------------------------
My answer to Comment #4:
----------------------------------------
Versions: apache2-2.0.54-10.x86_64.rpm
mysql-4.1.13-3.x86_64.rpm
for SUSE-NOVELL LINUX 10.0
----------------------------------------
The command <form action='aus.php'> with '...' unfortunately doesn't solve this problem.
Sorry, there are no indications in /var/log/apache2/error_log, and safe_mode = off in /etc/php.ini is registrationed (by standard)!
Comment 6 Michael Gross 2006-03-20 12:36:19 UTC
Michael, sorry, but this bugzilla is not a support forum. If you need help, consult the mailing lists, IRC-channels or another source of help. If there is an actual problem, narrow it down and state it.