Bitnamiredmine安装后查看数据库以及更改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 /redmine balancer://redminecluster
#ProxyPassReverse /redmine balancer://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,变为如下内容

8087>
  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

installdir/apps/phpmyadmin/htdocs">
# 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更换为实际安装位置