CentOS5 安裝 bugzilla 筆記
1 安裝相關必須套件(可能有些是多餘的, 因為後面會自動處理?!):
yum install gd gd-devel httpd mysqld gcc g++ make
yum install perl-XML-Twig ImageMagick-perl mod_perl perl-HTML-Parser perl-Email-MIME-Attachment-Stripper perl-Chart perl-PatchReader perl-Net-LDAP
yum install httpd mysql-server
2 安裝bugzilla套件
yum install bugzilla
3 建立 資料庫使用者 bugs
useradd bugs
passwd bugs
4 建立資料庫
4.1 建立server資料表
CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT='MySQL Foreign Servers table';
4.2 建立bugs 資料庫
# mysql -u root –p
Enter password:
mysql> create database bugs;
mysql> use bugs;
mysql>GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE, LOCK TABLES,DROP,REFERENCES ON bugs.* TO bugs@localhost IDENTIFIED BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
mysql> quit;
4.3 修改 /etc/bugzilla/localconfig 中的幾項設定
# The name of the database
# 按照步驟3的名稱設定
$db_name = 'bugs';
# Who we connect to the database as.
# 按照步驟4.2的名稱設定
$db_user = 'bugs';
# Enter your database password here. It's normally advisable to specify
# a password for your bugzilla database user.
# 按照步驟4.2的最後一欄設定
$db_pass = 'PASSWORD';
4.4 執行bugzilla內建檢查程式, 如有需要安裝選配的plugins,然後設定管理者的信箱帳號密碼
cd /usr/share/bugzilla/
./checksetup.pl
4.5 登入 http://你的serverIP/bugzilla
4.6 第一次需要輸入管理參數 設定好存檔 即可
延伸閱讀:
fedora7安装bugzilla
http://blog.csdn.net/qiongguishanglu/archive/2010/05/05/5559587.aspx
Bugzilla:Linux Distro Installation
https://wiki.mozilla.org/Bugzilla:Linux_Distro_Installation
Bugfix: MySQL Forums :: Install :: Table 'mysql.servers' doesn't exist
http://forums.mysql.com/read.php?11,142598,188705#msg-188705
MySQL基本語法
http://amzshar.blogspot.com/2007/11/dba-mysqlsql.html
yum install gd gd-devel httpd mysqld gcc g++ make
yum install perl-XML-Twig ImageMagick-perl mod_perl perl-HTML-Parser perl-Email-MIME-Attachment-Stripper perl-Chart perl-PatchReader perl-Net-LDAP
yum install httpd mysql-server
2 安裝bugzilla套件
yum install bugzilla
3 建立 資料庫使用者 bugs
useradd bugs
passwd bugs
4 建立資料庫
4.1 建立server資料表
CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT='MySQL Foreign Servers table';
4.2 建立bugs 資料庫
# mysql -u root –p
Enter password:
mysql> create database bugs;
mysql> use bugs;
mysql>GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE, LOCK TABLES,DROP,REFERENCES ON bugs.* TO bugs@localhost IDENTIFIED BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
mysql> quit;
4.3 修改 /etc/bugzilla/localconfig 中的幾項設定
# The name of the database
# 按照步驟3的名稱設定
$db_name = 'bugs';
# Who we connect to the database as.
# 按照步驟4.2的名稱設定
$db_user = 'bugs';
# Enter your database password here. It's normally advisable to specify
# a password for your bugzilla database user.
# 按照步驟4.2的最後一欄設定
$db_pass = 'PASSWORD';
4.4 執行bugzilla內建檢查程式, 如有需要安裝選配的plugins,然後設定管理者的信箱帳號密碼
cd /usr/share/bugzilla/
./checksetup.pl
4.5 登入 http://你的serverIP/bugzilla
4.6 第一次需要輸入管理參數 設定好存檔 即可
延伸閱讀:
fedora7安装bugzilla
http://blog.csdn.net/qiongguishanglu/archive/2010/05/05/5559587.aspx
Bugzilla:Linux Distro Installation
https://wiki.mozilla.org/Bugzilla:Linux_Distro_Installation
Bugfix: MySQL Forums :: Install :: Table 'mysql.servers' doesn't exist
http://forums.mysql.com/read.php?11,142598,188705#msg-188705
MySQL基本語法
http://amzshar.blogspot.com/2007/11/dba-mysqlsql.html
留言