From 96e8bad5665bbb35bea8082f9d4c2e1b23283a51 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Fri, 19 Sep 2008 03:31:55 +0000 Subject: Bug 432708: Installation Instructions For Oracle - Patch by Xiaoou and Frédéric Buclin r=mkanat MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- docs/en/xml/installation.xml | 161 +++++++++++++++++++++++++++++++++++-------- 1 file changed, 131 insertions(+), 30 deletions(-) (limited to 'docs') diff --git a/docs/en/xml/installation.xml b/docs/en/xml/installation.xml index 916fd84e8..e82cfb317 100644 --- a/docs/en/xml/installation.xml +++ b/docs/en/xml/installation.xml @@ -1,5 +1,5 @@ - + Installing Bugzilla @@ -88,7 +88,7 @@
Perl - Installed Version Test: perl -v + Installed Version Test: perl -v Any machine that doesn't have Perl on it is a sad machine indeed. If you don't have it and your OS doesn't provide official packages, @@ -101,13 +101,14 @@
Database Engine - From Bugzilla 2.20, support is included for using both the MySQL and - PostgreSQL database servers. You only require one of these systems to make - use of Bugzilla. + + Bugzilla supports MySQL, PostgreSQL and Oracle as database servers. + You only require one of these systems to make use of Bugzilla. +
MySQL - Installed Version Test: mysql -V + Installed Version Test: mysql -V If you don't have it and your OS doesn't provide official packages, @@ -134,7 +135,7 @@
PostgreSQL - Installed Version Test: psql -V + Installed Version Test: psql -V If you don't have it and your OS doesn't provide official packages, @@ -148,7 +149,27 @@ PostgreSQL server is started when the machine boots.
- + +
+ Oracle + + Installed Version Test: select * from v$version + (you first have to log in into your DB) + + + + If you don't have it and your OS doesn't provide official packages, + visit . You need Oracle + version &min-oracle-ver; or higher. + + + + If you install from something other than a packaging/installation + system, such as .rpm (Redhat Package), .deb (Debian Package), .exe + (Windows Executable), or .msi (Microsoft Installer), make sure the + Oracle server is started when the machine boots. + +
@@ -315,6 +336,12 @@ + + + DBD::Oracle (&min-dbd-oracle-ver;) if using Oracle + + + File::Spec (&min-file-spec-ver;) @@ -682,13 +709,22 @@ - Load this file in your editor. The only value you - need to change is $db_pass, the password for + Load this file in your editor. The only two values you + need to change are $db_driver and $db_pass, + respectively the type of the database and the password for the user you will create for your database. Pick a strong password (for simplicity, it should not contain single quote - characters) and put it here. + characters) and put it here. $db_driver can be either 'mysql', + 'Pg' or 'oracle'. + + + In Oracle, $db_name should actually be + the SID name of your database (e.g. "XE" if you are using Oracle XE). + + + You may need to change the value of webservergroup if your web server does not @@ -713,16 +749,8 @@ The other options in the localconfig file are documented by their accompanying comments. If you have a slightly - non-standard MySQL setup, you may wish to change one or more of - the other "$db_*" parameters. - - - - You may also wish to change the names of - the priorities, severities, operating systems and platforms for your - installation. However, you can always change these after installation - has finished; if you then re-run checksetup.pl, - the changes will get picked up. + non-standard database setup, you may wish to change one or more of + the other "$db_*" parameters.
@@ -730,8 +758,9 @@ Database Server This section deals with configuring your database server for use - with Bugzilla. Currently, MySQL () and - PostgreSQL () are available. + with Bugzilla. Currently, MySQL (), + PostgreSQL () and Oracle () + are available.
@@ -838,14 +867,15 @@ Run the mysql command-line client and enter: - mysql> GRANT SELECT, INSERT, + + mysql> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES, CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.* TO bugs@localhost IDENTIFIED BY '$db_pass'; - mysql> FLUSH PRIVILEGES; + mysql> FLUSH PRIVILEGES; + +
-
-
Permit attachments table to grow beyond 4GB @@ -864,9 +894,9 @@ - mysql> use $bugs_db - mysql> ALTER TABLE attachments - AVG_ROW_LENGTH=1000000, MAX_ROWS=20000; + mysql> use $bugs_db + mysql> ALTER TABLE attachments + AVG_ROW_LENGTH=1000000, MAX_ROWS=20000; @@ -936,6 +966,77 @@ to the one you picked previously, while setting up the account.
+ +
+ Oracle +
+ Create a New Tablespace + + + You can use the existing tablespace or create a new one for Bugzilla. + To create a new tablespace, run the following command: + + + + CREATE TABLESPACE bugs + DATAFILE '$path_to_datafile' SIZE 500M + AUTOEXTEND ON NEXT 30M MAXSIZE UNLIMITED + + + + Here, the name of the tablespace is 'bugs', but you can + choose another name. $path_to_datafile is + the path to the file containing your database, for instance + /u01/oradata/bugzilla.dbf. + The initial size of the database file is set in this example to 500 Mb, + with an increment of 30 Mb everytime we reach the size limit of the file. + +
+ +
+ Add a User to Oracle + + + The user name and password must match what you set in + localconfig ($db_user + and $db_pass, respectively). Here, we assume that + the user name is 'bugs' and the tablespace name is the same + as above. + + + + CREATE USER bugs + IDENTIFIED BY "$db_pass" + DEFAULT TABLESPACE bugs + TEMPORARY TABLESPACE TEMP + PROFILE DEFAULT; + -- GRANT/REVOKE ROLE PRIVILEGES + GRANT CONNECT TO bugs; + GRANT RESOURCE TO bugs; + -- GRANT/REVOKE SYSTEM PRIVILEGES + GRANT UNLIMITED TABLESPACE TO bugs; + GRANT EXECUTE ON CTXSYS.CTX_DDL TO bugs; + +
+ +
+ Configure the Web Server + + + If you use Apache, append these lines to httpd.conf + to set ORACLE_HOME and LD_LIBRARY_PATH. For instance: + + + + SetEnv ORACLE_HOME /u01/app/oracle/product/10.2.0/ + SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/10.2.0/lib/ + + + + When this is done, restart your web server. + +
+
-- cgit v1.2.3-24-g4f1b