CREATE TABLE

CREATE TABLE wikiscore (
pagename VARCHAR(100) NOT NULL,
score INT NOT NULL DEFAULT 0,
PRIMARY KEY (pagename)
);

Step 3. Configure PhpWiki.

Next, you have to edit the config.php file in the C:\PostgresPlus\8.3\apache\htdocs\phpwiki\lib directory.

You'll need to make 2 edits, the first is that you need to change the variable WhichDatabase from 'default' to 'pgsql'. It's easy to do, just search for the comment box labeled Part Two: Database section, and edit the line that says $WhichDatabase =


Part Two:
Database section
// set your database here and edit the according section below.
// For PHP 4.0.4 and later you must use "dba" if you are using
// DBM files for storage. "dbm" uses the older deprecated
// interface.
// The option 'default' will choose either dbm or dba, depending
// on
// the version of PHP you are running.


$WhichDatabase = 'pgsql'; // use one of "dbm", "dba", "mysql",
// "pgsql", "msql", "mssql", or "file"


The second edit is that you have to tell PhpWiki how to connect to this database. Again, this is easy, you simply enter the information that you used to create the database and user earlier.

// PostgreSQL settings -- see INSTALL.pgsql for more details
} elseif ($WhichDatabase == 'pgsql') {
$pg_dbhost = "localhost";
$pg_dbport = "5432";
$pg_dbuser = "phpwiki"; // username as used in step 2 of
INSTALL.mysql
$pg_dbpass = "*******"; // password of above user
$WikiDataBase = "wiki"; // name of the database in Postgresql
$WikiPageStore = "wiki";
$ArchivePageStore = "archive";
$WikiLinksPageStore = "wikilinks";
$HotTopicsPageStore = "hottopics";
$HitCountPageStore = "hitcount";
include "lib/pgsql.php";

You should go

You should go into the database and set up a new user with Superuser privileges, see below.





Then you should create a database to hold your data.





Once you have done this, you need to create the schema that PhpWiki will use. It's easy to do, just copy the script below and paste it into the SQL Tool in pgAdmin III.

CREATE TABLE wiki (
pagename VARCHAR(100) NOT NULL,
version INT NOT NULL DEFAULT 1,
flags INT NOT NULL DEFAULT 0,
author VARCHAR(100),
lastmodified INT NOT NULL,
created INT NOT NULL,
content TEXT NOT NULL,
refs TEXT,
PRIMARY KEY (pagename)
);

CREATE TABLE archive (
pagename VARCHAR(100) NOT NULL,
version INT NOT NULL DEFAULT 1,
flags INT NOT NULL DEFAULT 0,
author VARCHAR(100),
lastmodified INT NOT NULL,
created INT NOT NULL,
content TEXT NOT NULL,
refs TEXT,
PRIMARY KEY (pagename)
);

CREATE TABLE wikilinks (
frompage VARCHAR(100) NOT NULL,
topage VARCHAR(100) NOT NULL,
PRIMARY KEY (frompage, topage)
);

CREATE TABLE hottopics (
pagename VARCHAR(100) NOT NULL,
lastmodified INT NOT NULL,
PRIMARY KEY (pagename, lastmodified)
);

CREATE TABLE hitcount (
pagename VARCHAR(100) NOT NULL,
hits INT NOT NULL DEFAULT 0,
PRIMARY KEY (pagename)

In your web

In your web browser, go to http://localhost:8080/phpBB2/install/install.php .

In the next screen, enter the database name, database user and password.





When you have entered all your information, press START INSTALL, and you'll see the next screen with a button "Finish Installation".

When you press FINISH INSTALLATION, you see the next screen.

Please note: you are told to remove 2 directories, they are:

C:\PostgresPlus\8.3\apache\htdoc\phpBB2\contrib and

C:\PostgresPlus\8.3\apache\htdoc\phpBB2\install

Please go ahead and do this, otherwise you won't be able to log in.





After you have deleted these directories, Click on the Log in link and enter your administrator id and password as shown below.





Click the "Log in" button and you will be logged into phpBB2.


# +-
Postgres Plus phpWiki Installation

phpWiki provides the infrastructure to create a site where everyone can collaborate on the content. Learn how to quickly setup a phpWiki instance using the Postgres Plus stack.

Step 1. Download and Extract PhpWiki.

Download the latest stable version of PhpWiki from here.

You should extract PhpWiki to the C:\PostgresPlus\8.3\apache\htdocs directory and call it phpwiki (i.e. ..\htdocs\phpwiki).

You will end up with a directory structure like the one below when you have finished.





Make sure that your Postgres Plus database is up and running because you need to set up the PhpWiki database and users.
Step 2. Create the PhpWiki Database and User.

If you need help setting up new database objects (like Users, Database and Tables), here is a quick cheat sheet.

Postgres

First of all you have to configure the wiki site by providing the wiki name, contact e-mail address, language of your wiki's interface, and the administrative account for performing maintenanace tasks.



Then you should customize the email setting for your wiki by simply enabling or disabling the options.





Finally you have to configure database which stores the content of wiki site and click "Install Media Wiki" button.





When you have installed mediawiki, you'll see the following confirmation:





Go ahead and move the config\LocalSettings.php config file, then follow the highlighted link on the MediaWiki Installation screen to see your wiki running on Postgres Plus.




# +-
Postgres Plus phpBB Installation

phpBB is the worlds leading Open Source flat style discussion forum software. Learn how to quickly setup a phpBB instance using the Postgres Plus stack.

Step 1. Download and Extract phpBB2.

Download the latest version of phpBB2 from here.

You should extract phpBB2 to the C:\PostgresPlus\8.3\apache\htdocs directory and call it phpBB2 (i.e. ..\htdocs\phpBB2).

Make sure that your Postgres Plus database is up and running because the phpBB2 installer will use it.
Step 2. Create the phpBB2 Database and User.

If you need help setting up new database objects (like Users, Database and Tables), here is a quick cheat sheet.

You should go into the database and set up a new user with Superuser privileges, see below.





Then you should create a database to hold your data.





The database user and the database will be used in the installer below.
Step 3. Configure phpBB2.

If you need

If you need help setting up new database objects (like Users, Database and Tables), here is a quick cheat sheet for Windows. Here's a cheat sheet for Linux.

You should go into the database and set up a new Wiki user (i.e. wikiuser).

Then you should create a database called wikidb to hold your Wiki data.

The database user and the database will be used in the MediaWiki configuration step below.
Step 3. Configure MediaWiki.

Start your browser and go to http://localhost:8080/wiki

You are now ready to set up MediaWiki.

When you click on the set up the wiki link, you will be transferred to the MediaWiki Installation page.



There's a lot on it, but don't worry, we'll step you through each option.