# The default storage engine that will be used when create new tables when - default-storage-engine=INNODB + default-storage-engine=MyISAM
C:\> net stop MySQL C:\> net start MySQL
#############################################
# Scarab Site Settings
scarab.site.name=Khufu's Pyramid Project Issue Tracking System ( Scarab 1.0 )
scarab.timezone=Asia/Tokyo
#############################################
# Scarab Database Settings
#
# 1)It is a cheap solution that the ROOT user connects with RDB.
# However, it is very difficult to prepare the limited auth user
# of RDB for the scarab system.
#
# 2)Old JDBC Driver can't handle new 41 bytes passowrd hash of MySQL4.1.
# a) Download the newest JDBC Driver and copy it to \scarab-1.0-b19\lib
# b) Delete \scarab-1.0-b19\www\repository\mm.mysql completely.
scarab.database.type=mysql
scarab.database.username=root
scarab.database.password=amygdale
scarab.database.encoding.querystring = ?useUnicode=true&characterEncoding=utf8
scarab.jdbc.driver.jar=mysql-connector-java-*.jar
#############################################
# Scarab Administraotr Settings
#
# 1)JDBC Driver can't parse '00-00-00 00:00:00'.
# So, you must rewrite the turbine_user table as following.
# mysql> use scarab;
# mysql> update turbine_user set created=now(),last_login=now();
#
# 2)The initial password of ${scarab.user.username} is 1.
# Rewrite password and email address of ${scarab.user.username}
# after building the scarab system.
scarab.user.username=Administrator
#############################################
# Scarab Mail Settings
#
# 1)The Runtime properties file,
# \scarab-1.0-b19\tomcat\webapps\scarab\WEB-INF\conf\CustomSettings.properties
# , is not used by scarab system.
# So, write following on
# \scarab-1.0-b19\src\conf\conf\CustomSettings.properties
# BEFORE ant build process.
#
# system.mail.host=mail.amen.ra
# system.mail.smtp.from=root@${system.mail.host}
scarab.email.encoding=iso-2022-jp
scarab.email.register.fromAddress=osiris@amen.ra
scarab.email.forgotpassword.fromAddress=isis@amen.ra
scarab.email.archive.toAddress=horus@amen.ra
#############################################
# Don't generate sample module
skip.seed.data=true# Settings for SMTP Server system.mail.host=foo.bar system.mail.smtp.from=root@foo.bar # Settings for Character set of the export data of Scarab scarab.dataexport.encoding=sjis
# Role requests for these roles will be granted automatically # when a user requests a role in a module through the role request # UI screens. scarab.automatic.role.approval=Developer,Observer,QA,Partner ・・・ # These properties are used when generating links to scarab. In # many cases, if these properties are left blank, an appropriate default will # be used. But functionality which does not have access to the servlet engine # context/configuration will need this information to create valid links, # e.g. xml import. # In the following url: http://my.company.com:8081/issues/id/PACS1 # scheme=http, domain=my.company.com, port=8080, and scriptname=/issues # IMPORTANT NOTE: Setting these values has no effect on the servlet engine # and/or web server. These values should be set to values that # correspond to the configuration of the web server and/or servlet engine which # provides access to the scarab application. scarab.http.domain=scarab.foo.bar scarab.http.scheme=http scarab.http.scriptname=/scarab/issues scarab.http.port=8080
\scarab-1.0-b19\scarab-1.0-b19\tomcat\webapps\scarab\WEB-INF\conf\CustomSettings.propertiesを見て動作しません、変更があった場合にはアプリケーションのビルドをやり直します(databaseはそのままでよい)。
set MYSQL_HOME=C:\mysql set ANT_HOME=C:\apache-ant-1.5.4 set JAVA_HOME=C:\j2sdk1.4.2_05 set PATH=%ANT_HOME%\bin;%MYSQL_HOME\bin;%JAVA_HOME%\bin;%PATH% cd build ant
set MYSQL_HOME=C:\mysql set ANT_HOME=C:\apache-ant-1.5.4 set JAVA_HOME=C:\j2sdk1.4.2_05 set PATH=%ANT_HOME%\bin;%MYSQL_HOME\bin;%JAVA_HOME%\bin;%PATH% cd build ant create-db
ant create-dbでAdministrator ユーザが登録されます。
mysql> use scarab; mysql> update turbine_user set created=now(),last_login=now();
C:\scarab-1.0-b19\tomcat\bin\startup.bat
を実行すると
http://localhost:8080/scarab/
でscarabシステムにアクセスすることができる。
終了するときには、
C:\scarab-1.0-b19\tomcat\bin\shutdown.bat
を実行する
Administratorでログインすると、Global Module を編集することができます。
Global Moduleは、Scarabシステムの共通設定を行うための特別なモジュールです。
| 案件種別 | 内容 |
| Defect | 瑕疵対応要求 |
| Enhancement | 機能追加要求 |
| Feature | 見栄え・使い勝手の改善要求 |
| Patch | パッチ適用要求 |
| Task | その他の依頼 |
| 権限-ロール | Developer | Observer | Partner | Project Owner | QA | Root |
| Domain Admin | X | X | X | X | X | O |
| Domain Edit | X | X | X | X | X | O |
| Issue Assign | O | X | X | O | O | O |
| Issue Attach | O | O | O | O | O | O |
| Issue Edit | O | X | X | O | O | O |
| Issue Enter | O | O | X | O | O | O |
| Issue Move | O | X | X | O | O | O |
| Issue Search | O | O | O | O | O | O |
| Issue View | O | O | O | O | O | O |
| Item Approve | X | X | X | O | X | O |
| Item Delete | X | X | X | O | X | O |
| Module Add | O | X | X | O | O | O |
| Module Configure | X | X | X | O | X | O |
| Module Edit | X | X | X | O | X | O |
| User Approve Roles | X | X | X | O | X | O |
| User Edit Preferences | O | O | O | O | O | O |
| Vote Manage | X | X | X | O | X | O |
サンプルプロジェクトを作って運用してみます
詳細: --------------------------------------------------------------------- ようこそ Ramsesses II, 登録ありがとうございます!! あなたの確認コードは: SNQlXKCZrt あなたのアカウントを確認するために以下のURLにて確認コードを入力して下さい。 http://localhost:8080/scarab/issues/template/Confirm.vm/confirm/SNQlXKCZrt/username/Ramsesses ありがとうございます。 --------------------------------------------------------------------- This message is automatically generated by the Scarab issue tracking system. For more information: http://scarab.tigris.org/
以下のURLで案件の詳細を見ることが出来ます:
http://redwood:8080/scarab/issues/id/SNDB1
種別
Defect
案件ID
SNDB1 (虫が出ました)
編集者
Scarab Administrator
Administrator (scarab_admin@foo.bar)
この案件に対して次のように変更されました:
---------------------------------------------------------------------
Status changed from "New" to "Resolved"
理由:
掃除しました
---------------------------------------------------------------------
This message is automatically generated by the Scarab
issue tracking system. For more information:
http://scarab.tigris.org/Status Unconfirmed New Assigned Reopened Resolved Verified Closed ======= ======= ======= ======= ======= ======= ======= ======= 2005-03-27 19:00 0 0 0 0 0 0 0 2005-03-28 19:00 0 0 0 0 0 0 0 2005-03-29 19:00 0 0 0 0 0 0 1 2005-03-30 19:00
C:\scarab-1.0-b19\tomcat\webapps\scarabを実行したいサーブレットエンジン上の \webapps フォルダにコピーすればよい。
C:\Tomcat50\webappsにコピーする。
# Settings for SMTP Server system.mail.host=foo.bar system.mail.smtp.from=root@foo.bar # Settings for Character set of the export data of Scarab scarab.dataexport.encoding=sjis
# Role requests for these roles will be granted automatically # when a user requests a role in a module through the role request # UI screens. scarab.automatic.role.approval=Developer,Observer,QA,Partner ・・・ # These properties are used when generating links to scarab. In # many cases, if these properties are left blank, an appropriate default will # be used. But functionality which does not have access to the servlet engine # context/configuration will need this information to create valid links, # e.g. xml import. # In the following url: http://my.company.com:8081/issues/id/PACS1 # scheme=http, domain=my.company.com, port=8080, and scriptname=/issues # IMPORTANT NOTE: Setting these values has no effect on the servlet engine # and/or web server. These values should be set to values that # correspond to the configuration of the web server and/or servlet engine which # provides access to the scarab application. scarab.http.domain=scarab.foo.bar scarab.http.scheme=http scarab.http.scriptname=/scarab/issues scarab.http.port=8080
すみませんが、211.43.222.21(Korea Network Information Center)からのSPAMが酷いのでコメント欄を削除します
佐藤? (2007-03-15 (木) 16:56:51)
WindowsではC:\Program Files\Apache Software Foundation\Tomcat 6.0\webappsの下にscarabをフォルダコピーし、複数起動したのですが、linuxで同じようにscarab.warを名前変更しコピーして起動後、”Stack Trace”とでます。複数起動の対処方法、ご助言いただけませんでしょうか?
さとう? (2007-02-24 (土) 02:07:27)
始めまして B20にてExcel出力すると日本語が??になります。b19以降は??になるとScarab-jaに記載されていたのですが、本ページを見るとB19でも日本語です。そこでご質問ですが、$scarab_root\src\conf\conf\にcoustomsetting.propertiesがありませんがこれは新規に作成するのでしょうか?自分環境 OS:Windows Xpapache-ant1.7.0/scarab-1.0-b20/apache-tomcat-6.0.7/mysql-4.0.17-winで起動しております。
もし宜しければおしえてください