bitnami redmine mysql 密码_Bitnami redmine 安装后查看数据库以及更改url
Bitnami redmine 安装后，有关url的配置，主要步骤参考了官方说明 ， 根据自己的实际配置经验，做了部分修改整合
1. 查看数据库
可以用安装时填写的账户登录phpmyadmin，但是看不到redmine的数据库；改用root，则可以看到redmine-default数据库
2. 更改URL
a. 更改默认安装的URL(http://localhost:8087/redmine to http://localhost:8087/projects)
打开installdir/apps/redmine/conf/redmine.conf 文件 ，修改内容为：
#ProxyPass /redminebalancer://redminecluster
#ProxyPassReverse /redminebalancer://redminecluster
BalancerMember http://127.0.0.1:3001/redmine
BalancerMember http://127.0.0.1:3002/redmine
注：文件中“redmine”改为“projects”
打开 installdir/apps/redmine/htdocs/config/additional_environment.rb 文件，修改内容如下：
config.action_controller.relative_url_root = '/redmine'
将“redmine” 改为 “projects”
打开 installdir/apps/redmine/scripts/serviceinstall.bat文件 ，查找文件中如下内容
"installdir/apps/redmine/htdocs" --prefix /redmine
"installdir/apps/redmine/htdocs" --prefix /redmine
将文件中 --prefix /redmine的"redmine"改为"projects"
运行如下命令 卸载redmineThin1 redmineThin2 服务，并重新安装
> cd installdir/apps/redmine/scripts
> serviceinstall.bat uninstall
> serviceinstall.bat INSTALL
重启apache服务，完了
b. 更改URL到根目录(http://localhost:8087/redmine/ to http://localhost:8087/)
先停止服务，然后卸载服务
> cd installdir(installdir，是安装根目录)
> serviceinstall.bat uninstall
编辑 installdir/apps/redmine/conf/redmine.conf 文件，删除文件中的redmine。注意不是redminecluster,变为如下内容
ServerAdmin webmaster@your_server_name
ServerName your_server_name.your_domain_name.local
ServerAlias michael
ErrorLog "logs/rubystack_apache_error.log"
CustomLog "logs/rubystack_apache_access.log" combined
# this not only blocks access to .svn directories, but makes it
# appear as though they aren't even there, not just that they are
# forbidden
ErrorDocument 403 /404.html
Order allow,deny
Deny from all
Satisfy All
# This passes through remote_user to mongrel
RewriteEngine On
# Redirect non-static requests to cluster
RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_FILENAME} !-f
RewriteRule ^/(.*)$ balancer://redminecluster%{REQUEST_URI} [P,QSA,L]
#ProxyPass / balancer://redminecluster
#ProxyPassReverse / balancer://redminecluster
BalancerMember http://127.0.0.1:3001
BalancerMember http://127.0.0.1:3002
注意红色端口部分，根据自己安装情况更新
如果不想从redmine trunk升级最新的redmine安装， 这个配置节可以忽略不管
下面是在一台服务器上如果有多个域控制器是的，情况，参考一下，如果没有这种情况，略过
If you have multiple domains and subdomains on your server you must place the ProxyPass and Proxy balancer lines into the Virtual Host, or every domain will try to be passed to Redmine!
Like this:
ServerAdmin your @ email .com
ServerName subdomain . yourdomain . tld
ServerAlias www . subdomain . yourdomain . tld
ErrorLog "logs/rubystack_apache_error.log"
CustomLog "logs/rubystack_apache_access.log" combined
# this not only blocks access to .svn directories, but makes it
# appear as though they aren't even there, not just that they are
# forbidden
ErrorDocument 403 /404.html
Order allow,deny
Deny from all
Satisfy All
# This passes through remote_user to mongrel
RewriteEngine On
# Redirect non-static requests to cluster
RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_FILENAME} !-f
RewriteRule ^/(.*)$ balancer://redminecluster%{REQUEST_URI} [P,QSA,L]
#ProxyPass / balancer://redminecluster
#ProxyPassReverse / balancer://redminecluster
BalancerMember http:// 127.0.0.1:3001
BalancerMember http:// 127.0.0.1:3002
Hope this is useful to someone, took me a little while to figure why my Virtual Hosts were not working!
编辑 installdir/apps/redmine/scripts/serviceinstall.bat文件，删除其中的“--prefix /redmine”内容
编辑 installdir/apps/redmine/htdocs/config/additional_environment.rb 文件,删除其中的"/redmine"内容。注意，一定是“/redmine”，而不是“redmine”，否则样式表没了
运行如下命令安装所有服务
> cd installdir(installdir，是安装根目录)
> serviceinstall.bat INSTALL
刷新页面，清除cache，访问http://localhost:8087，就可以正常访问redmine
这时，如果通过http://localhost:8087/phpmyadmin/，则会提示找不到页面
那如何通过上述访问phpmyadmin呢
编辑 installdir/apps/phpmyadmin/conf/phpmyadmin.conf文件，添加如下配置节内容(红色部分)
DocumentRoot "C:/Program Files/BitNami Redmine Stack/apps/phpmyadmin/htdocs"
ServerName 127.0.0.1
ServerAlias 127.0.0.1
# AuthType Basic
# AuthName phpMyAdmin
# AuthUserFile "installdir/apache2/users"
# Require valid-user
Order allow,deny
Allow from 127.0.0.1
#Allow from all
Satisfy all
= 2.3>
Require local
ErrorDocument 403 "For security reasons, this URL is only accesible using localhost (127.0.0.1) as the hostname"
重启apache服务，从本地地址访问则会转向phpadmin，其他则会转向redmine
注：将文中installdir更换为实际安装位置