I now changed my MySQL setup, so that it doesn't connect over localohost but the actual hostname.

[niclas@f1 niclas]$ MySQL -h niclas.hedhman.org -u XOOPS -pSplendidDay
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1090371 to server version: 3.23.57

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

I can even connect from any machine (password is changed by now).

Then I did my simple php script, and it connects !
I also added the create table, and it creates and executes;

$conn = mysql_connect( "niclas.hedhman.org", "xoops", "WhatAWonderfulDay" );
mysql_query( "CREATE TABLE xoops.Niclas (Abd TEXT)", $conn );
?>

SO, I thought I had something going, so let's start over...

cd www/portal/
rm -rf *
cp -r ~/xoops-2.0.6/html/* .
chmod g+w,o+w uploads/ cache/ templates_c/ mainfile.php

hit the browser to http://niclas.hedhman.org/portal

Step through everything.... BLANK screen after "confirm database settings".

Putting in the explicit connect and "create table" into that place in your code, and it doesn't work.

Is this somehow related to that the HTTP Server is running as an untrusted user?
Or can one tell PHP/Apache that network connections are not allowed, or something along these lines?

Any debug information that can help me?

Niclas

Btw, yes, I do control the whole server and can make whatever changes are required to get this running...

Ok, I give up... Too bad.

Hi,

I had the same BLANK screen prolem in my local Mandrake Linux installation, and after many hours I realized that I had not installed the MySQL module for php. I installed it, restarted httpd service and finally worked.

Hope it helps you

Good look