1 Installing phpwiki with Oracle
2 ------------------------------
4 (derived from the MySQL INSTALL file!)
6 This assumes that you have a working Oracle server and client setup.
7 Installing Oracle is beyond the scope of this document. If you cannot get
8 Oracle working together with PHP, look at:
9 http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html
11 The oci8 database backend (WikiDB/backend/oci8.php) has been developped with an
12 Oracle 10g database. It should work with earlier versions but no test has been
15 1. Create a database schema/user using the appropriate user interface
19 sqlplus system/manager
20 SQL> create user phpwiki identified by phpwiki
21 2 default tablespace users
22 3 temporary tablespace temp;
26 SQL> grant connect, resource to phpwiki;
30 SQL> revoke unlimited tablespace from phpwiki;
34 SQL> alter user phpwiki quota unlimited on users;
39 2. Create tables inside your database database schema
41 sqlplus phpwiki/phpwiki @ oci8-initialize.sql
44 The script uses 'phpwiki_' as object prefix. You have to define this
45 prefix in your phpWiki config.ini file.
46 You have to use a prefix to avoid issues with Oracle reserved names.
48 3. Edit your config/config.ini to reflect your settings.
50 a) DATABASE_TYPE should be set to 'SQL'.
51 b) DATABASE_DSN should be set to something like
52 'oci8://username:password@dbstring'.
53 (where 'dbstring' designates your database instance -- as defined
54 in your tnsnames.ora or a 10g Easy Connect string)
55 c) DATABASE_PREFIX should be 'phpwiki_'
56 (unless you modified the oci8-initialize.sql script)
57 d) DBAUTH_ parameters (need more testing): ensure all tables have the
58 'phpwiki_' prefix. You need to have at least the following 2 SQL
61 "SELECT prefs FROM phpwiki_pref WHERE userid='$userid'"
63 "UPDATE phpwiki_pref SET prefs='$pref_blob' where userid='$userid'"
65 That's it. phpwiki should now work.
68 Philippe.Vanhaesendonck@topgame.be