Installing a Web Portal

Step 4: Installing a Web Portal

Prev   Next

We don't want a simple html website, we want an interactive site - like this one!

Such a site is referred to as a "Web Portal" and contains very little html.
Instead, pages are generated on-the-fly by scripts that interact with a database.

There are many web portal systems out there, I used PHPNuke
Web site powered by PHP-Nuke
There is a pretty good packaged version available from PHPNUKE-CLAN.COM
Install documentation is available HERE
I am going to install both versions, just to give you a picture - visible below.

Decide which package you want to try, and download it.

To run a web portal system, we need an SQL database, fortunately MySQL is installed - it just isn't running.

We need to go to WebMin and choose "Servers"
Then we need "MySQL Database Server"


As I said, it isn't running, so press the "Start MySQL Server" button:


The database server is now ready to use.
We need to create a new database, we'll call it "nuke", and set permissions.


We're not going to use WebMin to install the database.  We'll use the bash prompt for that.

First, find the "nuke.sql" file that came with your distribution, and copy it to /var/www/html/
(remember, you can do this through Network Neighborhood)

Next, telnet into your Magnia. How to do that is covered here:
image2: Adding FULL FTP Access
Issue the commands (in black) you see below:

Red Hat Linux release 7.3 (Valhalla)
Kernel 2.4.18-3custom on an i686
bash-2.05a$ su -
[root@SG20 root]# cd /var/www/html
[root@SG20 html]# ls
config.php* index* manual/ nuke.sql* poweredby.jpg* test.php*
[root@SG20 html]#
mysqladmin create nuke

Going back to WebMin, and refreshing the MySQL page, we see we now have a new database:


We can't populate the database yet, though, because we don't have permissions.

Under "Global Options" we are going to select "User Permissions"


Lets "Create new user" and call them "nuke"
(use any username and password you like, make them hard to guess)
Select all permissions, then click "Save"


We are doing this TWICE, for both HOSTS
(username and password remain the same!)


Now we have a user that can be assigned database permissions.


Go back to the MySQL main menu, and choose "Database Permissions"


We need to "Create new database permissions" for "nuke"


Now we have permission:


The PNC package also wants a database called "vWar"
create it as above - if you are installing PNC.

[root@SG20 html]# mysqladmin create vWar

Give user nuke permission to access it.
(don't create another user)

Time to populate the Nuke database, return to your telnet session and issue the command:

[root@SG20 html]# mysql -h localhost -u nuke -p nuke < nuke.sql
Enter password:
[root@SG20 html]#

Hope you remember you password!
(You can now exit your telnet session - type "exit" twice)

If we view the Nukedatabase now, it has too many tables to display:


You don't need to populate the "vWar" database.

Studying the install steps on PHPCLAN.Com we can see that we have completed steps 1 & 2.

The next step is to copy all files from the package's html directory to the html directory
on the Magnia.  Easily done through network neighborhood.
(perhaps you'd like to kill any files currently in the directory before you start copying)

Skip step 4 from the install directions.

The final step is to run


This script (running on your site!) will ask for your username and password for the database.

Host will be "localhost" and Site URL will be ""
You may have to adjust Site URL if you serve the web,
or if you get a domain name.

Now we go to our website, and TADA! We are up and running!

Time to visit the admin pages of the site and play around!

Forums are incredibly slow > 60second page load times, got a fix? let me know!
They are disabled by default.


Here's what we look like with a PHPNuke installed
(v7.6 - DON'T expose this to the web without patching!)


image Step 3: Enable Web Server & Test

image Table of contents