Run httpd with
/etc/rc.d/init.d/httpd start
Create a test file /var/www/html/test.php containing the following line
Use a web browser to browse to http://localhost/test.php
If PHP is working, this should display your settings.
Sincxe RedHat7.2 on uses PostgreSQL instead of MySQL you will have to change a number of settings.
Note in particular that the default PHP is not installed with MySQL support.
PHP-Nuke Web Portal System
Need a working Linux box with Apache (www.apache.org)
PHP 4.0.4 or better with mod_php Apache module (www.php.net)
mySQL database server (www.mysql.com)
Run /usr/bin/mysql_install_db to install initial MySql tables. This is safe to do at any time.
Set a password for the MySQL root user with
mysqladmin -u root -p password 'new-password'
mysqladmin -u root -h localhost.localdomain -p password 'new-password'
Test installation withÂ
cd sql-bench ; run-all-tests
However this is not installed with the RedHat7.2 standard rpms. MySQL commands are in /usr/bin
mysqladmin version
mysqladmin variables
To see the MySQL databases
mysqlshow
mysqlshow databasename
Good instructions at http://www.camalott.com/~jtpolk/psqlrh5.html
Â@
Â@
Run mySql with
/etc/rc.d/init.d/mysqld start
Create table for PHP-NUke with
mysqladmin create nuke
Then fill the databases with
mysql nuke
NukePHP manual at http://web-dj.net/manual/
To connect to a MySQL database PHP needs MySQL extensions. These can be found in php-mysql-4.0.6-7.i386.rpm
To make it easier to administer MySQL databases, install phpMyAdmin
Access it at http://localhost/phpMyAdmin-2.3.0/
Â@
su - postgres createdb nuke psql nuke
I got a load of errors :(
So I found a version of NukePHP that supports PostgreSQL at www.bluewolverine.com
Download nuke_pg.sql
Â@
su - postgres createdb nuke cat /root/nuke_pg.sql | psql nuke
 Lots of messages as it runs but no errors! Cool!
Next problem, Looking at http://localhost/test/admin.php shows lots of errors;
Warning: Supplied argument is not a valid PostgreSQL link resource in /var/www/html/test/includes/sql_layer.php on line 197
Lo ts of messages about this on the BlueWolverine forums so try their version of phpnuke. It looks like replacing my version of includes/sql_layer.php with theirs might do the job. Bit better, just a lot of errors at line 303 in sql_layer.php
Put the @ back in line 303 like the comment suggests.
$res=@pq_exec($id,$query);
Great! Now only 1 error.
Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port 5432? in /var/www/html/test/includes/sql_layer.php on line 92
I added "-o -i" options to /etc/rc.d/init.d/postgresql as follows:
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -o -i -D $PGDATA -p /usr/bin/postmaster start > /dev/null 2>&1"
Now restart Postgres and httpd
/etc/rc.d/init.d/postgresql restart
/etc/rc.d/init.d/httpd restart
Getting close, a new error:
Warning: Unable to connect to PostgreSQL server: FATAL 1: user "root" does not exist in /var/www/html/test/includes/sql_layer.php on line 92
Looks like the user is wrong in config.php. Fix it:
$dbuname="postgres";
$dbpass="";
Hmm another error:
Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/test/themes/NukeNews/theme.php on line 57
It looks like my Linux box (a P166 with only 80Mb ram) is too slow and PHP is timing out. Modify the max_execution_time in /etc/php.ini to a bigger value
max_execution_time=480;
Â
Â