PHP/SQL error

Irongut

I'm setting up PHP nuke, and I've got the config.php setup with the (i think!) proper infos. Mysql is 4.0.11, php is 4.3.1 and I have apache 2.0.

Im getting this error though, perhaps it is a simple fix:

Warning: main(db/mysql.php) [function.main]: failed to create 

stream: No such file or directory 

in /var/www/html/nuke/db/db.php on line 53

Warning: main() [function.main]: Failed opening 'db/mysql.php' 

for inclusion (include_path='/etc/php') 

in /var/www/html/nuke/db/db.php on line 53

Fatal error: Cannot instantiate non-existent class: sql_db 

in /var/www/html/nuke/db/db.php on line 86

I'm a noob, but the files mysql.php are located in same folder as /var/www/html/nuke/db/db.php . Here is a link to my phpinfo http://blackdragon.zapto.org/phpinfo.php

planetsim

Most likely the path to the file mysql.php is wrong. Make sure though. The other errors will be fixed when you find the file i suspect.

thessoro

maybe the script try to access that file to modify it and it only have read permission: try chmod a+w the_file

Irongut

Thats what I thought too, but I think I may have found the answer, It needs globals on and I dont use them (only because it isn't recommended in the php.ini file). Would it be wiser to enable globals or re-write this page( here is the contents of the db.php file).

<?php
global $forum_admin;
if ($forum_admin == 1) {
    $the_include = "../../../db";
} elseif ($inside_mod == 1) {
    $the_include = "../../db";
} else {
    $the_include = "db";
}

switch($dbtype) {

case 'MySQL':
	include("".$the_include."/mysql.php");
	break;

case 'mysql4':
	include("".$the_include."/mysql4.php");
	break;

case 'postgres':
	include("".$the_include."/postgres7.php");
	break;

case 'mssql':
	include("".$the_include."/mssql.php");
	break;

case 'oracle':
	include("".$the_include."/oracle.php");
	break;

case 'msaccess':
	include("".$the_include."/msaccess.php");
	break;

case 'mssql-odbc':
	include("".$the_include."/mssql-odbc.php");
	break;

case 'db2':
	include("".$the_include."/db2.php");
	break;

}

$db = new sql_db($dbhost, $dbuname, $dbpass, $dbname, false);
if(!$db->db_connect_id) {
    message_die(CRITICAL_ERROR, "Could not connect to the database");
}

?>

thessoro

try enabling register_globals but as far as i know that will not affect your current script except if $forum_admin is passed using the POST or GET method or it is a cookie or session variable...
it has nothing to do with changing the scope of a variable to make it work inside a function.

modified:
or $db_type too, if it is posted through a form you should pick up using $POST['db_type'] or if is passed in a url using $GET['db_type']

Irongut

Ok, turning globals on didnt help, and I chmod a+w the file. No luck there. The path is correct to mysql.php (its in db/ from the root of phppnuke).

ereptur

did you try chmod a+x or chmod a+w. PHPNuke is probably trying to write to a file and execute permissions are really going to help in this case.

Irongut

Was a typo, i did a+w

ereptur

Just a thought (I've never used it before) does include_path override anything else. For example since include_path is set to /etc/php is it maybe not looking anywhere else for it's includes?

Irongut

Thats possible.

ereptur

what I guess I meant was that if you can, wipe out the include_dir value in your php.ini file and then restart your web server unless you are using the CGI version of PHP.

Irongut

Not using the CGI version afaik, but i changed the include path in php.ini from ":./etc/php" to "", rebooted, and now when I load up index.php I get this message:

Fatal error: Call to undefined function: message_die() in /var/www/html/nuke/db/db.php on line 88

$db = new sql_db($dbhost, $dbuname, $dbpass, $dbname, false);
if(!$db->db_connect_id) {
 /*line 88 */ message_die(CRITICAL_ERROR, "Could not connect to the database");
}

ereptur

well, where is message_die() declared? try a grep of all the files in the db directory to see if it's declared somewhere in there.

thessoro

just a punctual note: you don't need to reboot the whole system, just /etc/init.d/apache restart for all the changes to take effect.

ethanone

Irongut, I seem to be having the same problem:

I am trying to install phpnuke 6.5 on a winXP pro machine with IIS, PHP 4.3.2 and mySQL 4.0.13.

I know PHP and mySQL are working because I have other sites on the same machine working fine.

I have copied over the php files, created a 'nuke' database, populated the db with nuke.sql, and set up config.php which is the extent of the instructions.

However I still get errors like this:

Warning: main(db/mysql.php): failed to open stream: No such file or directory in C:\Inetpub\wwwroot\Nuke\db\db.php on line 53

Warning: main(): Failed opening 'db/mysql.php' for inclusion (include_path='c:\inetpub\wwwroot\') in C:\Inetpub\wwwroot\Nuke\db\db.php on line 53

Fatal error: Cannot instantiate non-existent class: sql_db in C:\Inetpub\wwwroot\Nuke\db\db.php on line 86

If i set $dbtype = "MySQL4"; then I only get the last error (but it still doesn't work), and I don't know why.

Did you figure out the solution?

P.S. I have also tried this on RedHat 8 and Apache and I get the same errors.