Windows上配置bugzilla.doc

1. 准备工作软件名称版本下载地址备注Perl5.14postgreSQL9.0.4Mysql5.1.55需要使用DBD-mysql (v4.001或以上版本)，联网安装时找不到相关驱动，后台数据库暂时放弃mysql，改用pgBugzilla4.0.1Apache2.2为了和linux一致，弃用windows的IIS web服务器2. 安装bugzilla2.1. 安装Perl1. 双击ActivePerl-401-MSWin32-x86-294969.msi2. 选择“I accept。”3. 安装组件默认，安装路径默认4. 安装Perl参数设置，采用默认设置5. 执行安装6. 完成2.2. 安装数据库2.2.1. mysql1. 解压后双击mysql-essential-5.1.55-win32.msi，然后弹出安装向导界面，点击【next】2. 选择“I accept。”3. 选择“Typical”安装4. 准备安装界面，点击【Install】5. 执行安装6. 安装完成，进行服务器配置，也可以放到后面手工进行配置：7. 配置向导8. 选择【Detailed Configuration】9. 选择【Developer Machine】10. 选择【Multifunctional Database】11. 默认配置12. 修改并发连接13. 指定端口14. 设置默认字符集gbk15. 增加命令行的支持16. 配置root密码123456，注意要勾上“Enable root access from remote machines”，然后点击【Next】17. 点击【Execute】，执行配置18. 点击【Finish】完成19. 通过cmd切换到mysql的安装路径下，使用mysql自带的客户端工具cd C:Program FilesMySQLMySQL Server 5.1binmysql -uroot -P3306 -p12345620. 创建数据库create database bugs;21. 创建用户create user bugs% IDENTIFIED BY 123456;授权GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,REFERENCES,LOCK TABLES,CREATE TEMPORARY TABLES ON bugs.* TO bugs% IDENTIFIED BY 123456;2.2.2. postgreSQL1. 双击postgresql-9.0.4-1-windows.exe，在弹出的安装向导界面上点击【Next】2. 指定安装路径，可使用默认值3. 指定数据目录，可使用默认值4. 设置DBA的密码（123456）5. 设定数据库端口，可使用默认6. 设置默认字符集7. 准备安装8. 安装执行9. 安装完成10. 然后从【开始】【程序】【PostgreSQL 9.0】【pgAdmin III】，然后创建用户bugs，密码是123456，然后创建数据库bugs，属主是bugs2.3. 安装bugzilla1. 解压压缩包，例如解压到C:bugzilla下2. 运行命令行窗口，进入到解压路径，然后运行：perl checksetup.pl如果提示COMMANDS TO INSTALL REQUIRED MODULES (You *must* run all these commandsand then re-run this script): ppm install TimeDate ppm install DateTime ppm install DateTime-TimeZone ppm install Template-Toolkit ppm install Email-Send ppm install Email-MIME* Installation aborted. Read the messages above. *注意：需要在联网的状态在此路径下重新执行上述命令；如果不能联网的话，需要先从3. 安装完所有的模块后，再次运行perl checksetup.pl，如果主要的模块都正确安装，会在bugzilla的目录下生成一个localconfig文件修改该文件，主要是以下几个配置： $db_host = localhost ; $db_name = bugs ; $db_user = bugs ; $db_pass = 123456; 如果使用mysql数据库，那么$db_driver = mysql;如果使用PostgreSQL 则$db_driver = Pg;注意：这次我使用了pg，主要是安装DBD-mysql (v4.001或以上版本)，联网安装时找不到相关驱动，只好先弃用mysql了；另外网上有人说不要使用mysql5.x的版本，这一点我不太赞同，毕竟mysql4.x版本上有些功能不太完备。4. 最后，再次运行perl checksetup.pl，会看到一些创建表的信息，并且中途会提示你输入管理员的相关信息。5. 安装过程：C:bugzillaperl checksetup.pl* This is Bugzilla 3.6.5 on perl 5.14.1* Running on WinXP/.Net Build 2600 (Service Pack 2)Checking perl modules.Checking for CGI.pm (v3.51) ok: found v3.53Checking for Digest-SHA (any) ok: found v5.62Checking for TimeDate (v2.21) ok: found v2.24Checking for DateTime (v0.28) ok: found v0.70Checking for DateTime-TimeZone (v0.79) ok: found v1.35Checking for DBI (v1.41) ok: found v1.616Checking for Template-Toolkit (v2.22) ok: found v2.22Checking for Email-Send (v2.16) ok: found v2.198Checking for Email-MIME (v1.861) ok: found v1.908Checking for Email-MIME-Encodings (v1.313) ok: found v1.313Checking for Email-MIME-Modifier (v1.442) ok: found v1.908Checking for URI (any) ok: found v1.58Checking available perl DBD modules.Checking for DBD-Pg (v1.45) ok: found v2.17.2Checking for DBD-mysql (v4.00) not foundChecking for DBD-Oracle (v1.19) ok: found v1.27The following Perl modules are optional:Checking for GD (v1.20) ok: found v2.45Checking for Chart (v2.1) ok: found v2.4.2Checking for Template-GD (any) ok: found v1.56Checking for GDTextUtil (any) ok: found v0.86Checking for GDGraph (any) ok: found v1.44Checking for XML-Twig (any) ok: found v3.38Checking for MIME-tools (v5.406) ok: found v5.502Checking for libwww-perl (any) ok: found v6.02Checking for PatchReader (v0.9.4) ok: found v0.9.6Checking for perl-ldap (any) ok: found v0.4001Checking for Authen-SASL (any) ok: found v2.15Checking for RadiusPerl (any) ok: found v0.20Checking for SOAP-Lite (v0.710.06) not foundChecking for JSON-RPC (any) ok: found v0.96Use of uninitialized value in open at C:/Perl/site/lib/Test/Taint.pm line 334, line 522.Checking for Test-Taint (any) ok: found v1.04Checking for HTML-Parser (v3.40) ok: found v3.68Checking for HTML-Scrubber (any) ok: found v0.09Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.316Checking for Email-Reply (any) ok: found v1.202Checking for TheSchwartz (any) not foundChecking for Daemon-Generic (any) not foundChecking for mod_perl (v1.999022) not foundChecking for Math-Random-Secure (v0.05) ok: found v0.06* OPTIONAL MODULES * Certain Perl modules are not required by Bugzilla, but by * installing the latest version you gain access to additional * features. * * The optional modules you do not have installed are listed below, * with the name of the feature they enable. Below that table are the * commands to install each module. * MODULE NAME * ENABLES FEATURE(S) * SOAP-Lite * XML-RPC Interface * TheSchwartz * Mail Queueing * Daemon-Generic * Mail Queueing * mod_perl * mod_perl * Note For Windows Users * In order to install the modules listed below, you first have to run * the following command as an Administrator: * * ppm repo add theory58S http:/cpan.uwinnipeg.ca/PPMPackages/10xx/*COMMANDS TO INSTALL OPTIONAL MODULES: SOAP-Lite: ppm install SOAP-Lite TheSchwartz: ppm install TheSchwartz Daemon-Generic: ppm install Daemon-Generic mod_perl: ppm install mod_perlApache-SizeLimit: ppm install Apache-SizeLimitReading ./localconfig.OPTIONAL NOTE: If you want to be able to use the difference between twopatches feature of Bugzilla (which requires the PatchReader Perl moduleas well), you should install patchutils from: /tim/patchutils/Checking for DBD-Pg (v1.45) ok: found v2.17.2Checking for PostgreSQL (v8.00.0000) ok: found v09.00.0400Checking for DBD-Pg (v2.17.2) ok: found v2.17.2Adding new table bz_schema .Initializing the new Schema storage.Adding new table attach_data .Adding new table attachments .Adding new table bug_group_map .Adding new table bug_see_also .Adding new table bug_severity .Adding new table bug_status .Adding new table bugs .Adding new table bugs_activity .Adding new table bugs_fulltext .Adding new table category_group_map .Adding new table cc .Adding new table classifications .Adding new table component_cc .Adding new table components .Adding new table dependencies .Adding new table duplicates .Adding new table email_setting .Adding new table fielddefs .Adding new table flagexclusions .Adding new table flaginclusions .Adding new table flags .Adding new table flagtypes .Adding new table group_control_map .Adding new table group_group_map .Adding new table groups .Adding new table keyworddefs .Adding new table keywords .Adding new table login_failure .Adding new table logincookies .Adding new table longdescs .Adding new table milestones .Adding new table namedqueries .Adding new table namedqueries_link_in_footer .Adding new table namedquery_group_map .Adding new table op_sys .Adding new table priority .Adding new table products .Adding new table profile_search .Adding new table profile_setting .Adding new table profiles .Adding new table profiles_activity .Adding new table quips .Adding new table rep_platform .Adding new table resolution .Adding new table series .Adding new table series_categories .Adding new table series_data .Adding new table setting .Adding new table setting_value .Adding new table status_workflow .Adding new table tokens .Adding new table ts_error .Adding new table ts_exitstatus .Adding new table ts_funcmap .Adding new table ts_job .Adding new table ts_note .Adding new table user_group_map .Adding new table versions .Adding new table watch .Adding new table whine_events .Adding new table whine_queries .Adding new table whine_schedules .Creating function array_accum.Removing index bugs_fulltext_comments_idx from the bugs_fulltext table.Removing index bugs_fulltext_comments_noprivate_idx from the bugs_fulltext table.Adding new index profiles_login_name_lower_idx to the profiles table .Adding new index fielddefs_name_lower_idx to the fielddefs table .Adding new index keyworddefs_name_lower_idx to the keyworddefs table .Adding new index products_name_lower_idx to the products table .Inserting values into the bug_status table:UNCONFIRMED sortkey: 100CONFIRMED sortkey: 200IN_PROGRESS sortkey: 300RESOLVED sortkey: 400VERIFIED sortkey: 500Inserting values into the priority table:Highest sortkey: 100High sortkey: 200Normal sortkey: 300Low sortkey: 400Lowest sortkey: 500- sortkey: 600Inserting values into the rep_platform table:All sortkey: 100PC sortkey: 200Macintosh sortkey: 300Other sortkey: 400Inserting values into the resolution table: sortkey: 100FIXED sortkey: 200INVALID sortkey: 300WONTFIX sortkey: 400DUPLICATE sortkey: 500WORKSFORME sortkey: 600Inserting values into the op_sys table:All sortkey: 100Windows sortkey: 200Mac OS sortkey: 300Linux sortkey: 400Other sortkey: 500Inserting values into the bug_severity table:blocker sortkey: 100critical sortkey: 200major sortkey: 300normal sortkey: 400minor sortkey: 500trivial sortkey: 600enhancement sortkey: 700Creating ./data directory.Creating ./data/attachments directory.Creating ./data/extensions directory.Creating ./data/mining directory.Creating ./data/webdot directory.Creating ./graphs directory.Creating ./skins/custom directory.Creating ./data/extensions/additional.Creating ./data/mailer.testfile.Creating ./Bugzilla/.htaccess.Creating ./data/.htaccess.Creating ./data/attachments/.htaccess.Creating ./data/webdot/.htaccess.Creating ./graphs/.htaccess.Creating ./lib/.htaccess.Creating ./template/.htaccess.Creating contrib/.htaccess.Creating t/.htaccess.Creating xt/.htaccess.Bugzilla requires an SMTP server to function on Windows.Please enter your SMTP servers hostname: 51Precompiling templates.done.Initializing Dependency Tree Changes email_setting .Marking closed bug statuses as such.Creating default classification Unclassified.Adding foreign key: attach_data.id - attachments.attach_id.Adding foreign key: attachments.submitter_id - profiles.userid.Adding foreign key: attachments.bug_id - bugs.bug_id.Adding foreign key: bug_group_map.group_id - groups.id.Adding foreign key: bug_group_map.bug_id - bugs.bug_id.Adding foreign key: bug_see_also.bug_id - bugs.bug_id.Adding foreign key: duct_id - products.id.Adding foreign key: bugs.assigned_to - profiles.userid.Adding foreign key: bugs.qa_contact - profiles.userid.Adding foreign key: ponent_id - components.id.Adding foreign key: bugs.reporter - profiles.userid.Adding foreign key: bugs_activity.fieldid - fielddefs.id.Adding foreign key: bugs_ment_id - ment_id.Adding foreign key: bugs_activity.who - profiles.userid.Adding foreign key: bugs_activity.bug_id - bugs.bug_id.Adding foreign key: bugs_activity.attach_id - attachments.attach_id.Adding foreign key: bugs_fulltext.bug_id - bugs.bug_id.Adding foreign key: category_group_map.category_id -series_categories.id.Adding foreign key: category_group_map.group_id - groups.id.Adding foreign key: cc.who - profiles.userid.Adding foreign key: cc.bug_id - bugs.bug_id.Adding foreign key: component_ponent_id - components.id.Adding foreign key: component_cc.user_id - profiles.userid.Adding foreign key: components.initialowner - profiles.userid.Adding foreign key: duct_id - products.id.Adding foreign key: components.initialqacontact - profiles.userid.Adding foreign key: dependencies.dependson - bugs.bug_id.Adding foreign key: dependencies.blocked - bugs.bug_id.Adding foreign key: duplicates.dupe_of - bugs.bug_id.Adding foreign key: duplicates.dupe - bugs.bug_id.Adding foreign key: email_setting.user_id - profiles.userid.Adding foreign key: fielddefs.value_field_id - fielddefs.id.Adding foreign key: fielddefs.visibility_field_id - fielddefs.id.Adding foreign key: duct_id - products.id.Adding foreign key: flagexclusions.type_id - flagtypes.id.Adding foreign key: ponent_id - components.id.Adding foreign key: duct_id - products.id.Adding foreign key: flaginclusions.type_id - flagtypes.id.Adding foreign key: ponent_id - components.id.Adding foreign key: flags.type_id - flagtypes.id.Adding foreign key: flags.bug_id - bugs.bug_id.Adding foreign key: flags.setter_id - profiles.userid.Adding foreign key: flags.requestee_id - profiles.userid.Adding foreign key: flags.attach_id - attachments.attach_id.Adding foreign key: flagtypes.grant_group_id - groups.id.Adding foreign key: flagtypes.request_group_id - groups.id.Adding foreign key: group_control_duct_id - products.id.Adding foreign key: group_control_map.group_id - groups.id.Adding foreign key: group_group_map.member_id - groups.id.Adding foreign key: group_group_map.grantor_id - groups.id.Adding foreign key: keywords.keywordid - keyworddefs.id.Adding foreign key: keywords.bug_id - bugs.bug_id.Adding foreign key: login_failure.user_id - profiles.userid.Adding foreign key: logincookies.userid - profiles.userid.Adding foreign key: longdescs.who - profiles.userid.Adding foreign key: longdescs.bug_id - bugs.bug_id.Adding foreign key: duct_id - products.id.Adding foreign key: namedqueries.userid - profiles.userid.Adding foreign key: namedqueries_link_in_dquery_id -namedqueries.id.Adding foreign key: namedqueries_link_in_footer.user_id -profiles.userid.Adding foreign key: namedquery_group_dquery_id -namedqueries.id.Adding foreign key: namedquery_group_map.group_id - groups.id.Adding foreign key: products.classification_id - classifications.id.Adding foreign key: profile_setting.setting_name - .Adding foreign key: profile_setting.user_id - profiles.userid.Adding foreign key: profiles_activity.fieldid - fielddefs.id.Adding foreign key: profiles_activity.who - profiles.userid.Adding foreign key: profiles_activity.userid - profiles.userid.Adding foreign key: quips.userid - profiles.userid.Adding foreign key: series.subcategory - series_categories.id.Adding foreign key: series.creator - profiles.userid.Adding foreign key: series.category - series_categories.id.Adding foreign key: series_data.series_id - series.series_id.Adding foreign key: setting_ - .Adding foreign key: status_workflow.new_status - bug_status.id.Adding foreign key: status_workflow.old_status - bug_status.id.Adding foreign key: tokens.userid - profiles.userid.Adding foreign key: user_group_map.group_id - groups.id.Adding foreign key: user_group_map.user_id - profiles.userid.Adding foreign key: duct_id - products.id.Adding foreign key: watch.watcher - profiles.userid.Adding foreign key: watch.watched - profiles.userid.Adding foreign key: whine_events.owner_userid - profiles.userid.Adding foreign key: whine_queries.eventid - whine_events.id.Adding foreign key: whine_schedules.eventid - whine_events.id.Setting up the default status workflow.Creating group admin.Creating group tweakparams.Creating group editusers.Creating group creategroups.Creating group editclassifications.Creating group editcomponents.Creating group editkeywords.Creating group editbugs.Creating group