vi app/controllers/users_controller.rb
@events_by_day = events.group_by(&:event_date)
if !User.current.admin?
render_404
return
end
rake tmp:cache:clear
rake tmp:sessions:clear
touch tmp/restart.txt
vi app/views/reports/issue_report.html.erb
<%= render :partial => 'simple', :locals => { :data => @issues_by_priority, :field_name => "priority_id", :rows => @priorities } %>
<br />
<% if User.current.admin? %>
<h3><%=l(:field_assigned_to)%> <%= link_to image_tag('zoom_in.png'), :action => 'issue_report_details', :detail => 'assigned_to' %></h3>
<%= render :partial => 'simple', :locals => { :data => @issues_by_assigned_to, :field_name => "assigned_to_id", :rows => @assignees } %>
<h3><%=l(:field_author)%> <%= link_to image_tag('zoom_in.png'), :action => 'issue_report_details', :detail => 'author' %></h3>
<%= render :partial => 'simple', :locals => { :data => @issues_by_author, :field_name => "author_id", :rows => @authors } %>
<% end %>
vi app/controllers/reports_controller.rb
when "assigned_to"
if User.current.admin?
@field = "assigned_to_id"
@rows = (Setting.issue_group_assignment? ? @project.principals : @project.users).sort
@data = Issue.by_assigned_to(@project)
@report_title = l(:field_assigned_to)
end
when "author"
if User.current.admin?
@field = "author_id"
@rows = @project.users.sort
@data = Issue.by_author(@project)
@report_title = l(:field_author)
endif
...
vi app/models/query.rb
users = principals.select {|p| p.is_a?(User)}
if User.current.admin?
assigned_to_values = []
assigned_to_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
assigned_to_values += (Setting.issue_group_assignment? ? principals : users).collect{|s| [s.name, s.id.to_s] }
@available_filters["assigned_to_id"] = { :type => :list_optional, 
rder => 4, :values => assigned_to_values } unless assigned_to_values.empty?
author_values = []
author_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
author_values += users.collect{|s| [s.name, s.id.to_s] }
@available_filters["author_id"] = { :type => :list, rder => 5, :values => author_values } unless author_values.empty?
group_values = Group.all.collect {|g| [g.name, g.id.to_s] }
@available_filters["member_of_group"] = { :type => :list_optional, rder => 6, :values => group_values } unless group_values.empty?
role_values = Role.givable.collect {|r| [r.name, r.id.to_s] }
@available_filters["assigned_to_role"] = { :type => :list_optional, rder => 7, :values => role_values } unless role_values.empty?
if User.current.logged?
@available_filters["watcher_id"] = { :type => :list, rder => 15, :values => [["<< #{l(:label_me)} >>", "me"]] }
end
end
...
rake tmp:cache:clear
rake tmp:sessions:clear
touch tmp/restart.txt
rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm yum install --enablerepo=webtatic git-core
cd vendor/plugins/ git clone git://github.com/resilva/Redmine-Fields-permissions.git cd .. cd .. rake db:migrate_plugins RAILS_ENV=production rake tmp:cache:clear rake tmp:sessions:clear touch tmp/restart.txt
ActionView::TemplateError (uninitialized constant ActionView::Base::CompiledTemplates::TabularFormBuilder) on line #1 of vendor/plugins/Redmine-Fields-permissions/app/views/issues/_attributes.rhtml:
cd lib wget http://svn.ohwr.org/ohr-support/trunk/lib/tabular_form_builder.rb rake tmp:cache:clear rake tmp:sessions:clear touch tmp/restart.txt
vi app/views/projects/_members_box.html.erb
<% if @users_by_role.any? %>
to
<% if User.current.admin? %>
rake tmp:cache:clear
rake tmp:sessions:clear
touch tmp/restart.txt
Dell PowerEdge 2900 III
RAID-Controller -- Dell Perc 6/i (3 HDD -- HUA723020ALA640 A7K3000 2 TB)
USB-Stick -- Corsair Voyager GT 8GB
Openfiler 2.99.1 & USB boot
Openfiler 2.99 is much easier to install on a USB stick than 2.3, because it loads USB drivers earlier in the boot process.
Patch the new install to 2.99.2
Login with SSH or the console and run
conary sync group-openfileresa-appliance conary updateall --keep-required
Openfiler 2.99.2 & Creating a Physical Large Volume
But it only uses 95% of the free space.
Login with SSH or the console and run
parted /dev/sdb (parted) rm 1 (parted) mkpart primary ext3 0 -1 (parted) set 1 lvm on
parted /dev/sdb GNU Parted 1.8.8 Using /dev/sdb Welcome to GNU Parted! Type 'help' to view a list of commands. (parted) print Model: DELL PERC 6/i (scsi) Disk /dev/sdb: 4000GB Sector size (logical/physical): 512B/512B Partition Table: gpt Number Start End Size File system Name Flags 1 17.4kB 3814GB 3814GB primary lvm (parted) rm 1 (parted) mkpart primary ext3 0 -1 (parted) print Model: DELL PERC 6/i (scsi) Disk /dev/sdb: 4000GB Sector size (logical/physical): 512B/512B Partition Table: gpt Number Start End Size File system Name Flags 1 17.4kB 4000GB 4000GB primary msftres (parted) set 1 lvm on (parted) print Model: DELL PERC 6/i (scsi) Disk /dev/sdb: 4000GB Sector size (logical/physical): 512B/512B Partition Table: gpt Number Start End Size File system Name Flags 1 17.4kB 4000GB 4000GB primary lvm (parted)
You should now be presented with 100% space
Openfiler 2.99.2 & iSCSI & Samba
Create a New Volume Group
You should now be presented with a new Volume Group that looks like this
Add New Volume for iSCSI
You should now be presented with a new Volume for iSCSI that looks like this:
Add New Volume for Samba
You will need to setup Volumes with either XFS or EXT3 filesystems (you cannot create shares from iSCSI volumes).
You should now be presented with a new Volume for Samba that looks like this
Enable the iSCSI and Samba Target Service
Network Access Configuration
Add iSCSI Target
Map the LUN
You now need to map a LUN to your iSCSI target
Allow access to the iSCSI Target:
Use LDAP
Add Network Shares
Synchronise Time
Links
Using Openfiler and vSphere ESX / ESXi 4
Imtall graphviz
# wget -O /etc/yum.repos.d/graphviz-rhel.repo http://www.graphviz.org/graphviz-rhel.repo # yum install graphviz.x86_64 # yum install graphviz-gd # yum install graphviz-ruby
Imtall wiki_graphviz_plugin
/opt/redmine/vendor/plugins/wiki_graphviz_plugin/
# mkdir /opt/redmine/tmp/wiki_graphviz_plugin # chown -R apache:apache /opt/redmine/tmp/ # cd /opt/redmine # /etc/init.d/httpd restart
not ok 4 - last request threw an uncaught exception RuntimeException: PHP sent a warning error at C:\jenkins\workspace\ris\db\mssql\os\win\src\apps\frontend\modules\img\actions\actions.class.php line 56 (Cannot modify header information - headers already sent by (output started at C:\Programme\PHP\PEAR\PHPUnit\Util\Printer.php:173)) # Failed test (.\lib\vendor\symfony\lib\test\sfTestFunctionalBase.class.php at line 541)
If you do unit testing and encounter “headers already sent” errors in “Printer” on line 173, add “–stderr” to the command call. PHPUnit will then output everything to stderr and cease throwing ErrorExceptions.
USE master EXEC sp_addextendedpro[delme]c xp_ndo_enumusergroups, 'C:\Programme\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\xp_ndo.dll' GO GRANT EXECUTE ON [xp_ndo_enumusergroups] TO PUBLIC GO
Redmine configuration
RIS risRedminePlugin configuration
all:
pagination:
redmineprojects: 10
redminetasks: 10
redmine:
url: http://localhost:8000
key: 77b08c3b1c17ff101a25c3fc2113dc8c8fa5c28a
custom_field_uuid_id: 1
priority_id: 4
tracker_id: 2
<?php
//date_default_timezone_set('UTC');
date_default_timezone_set('Europe/Berlin');
require_once dirname(__FILE__).'/../lib/vendor/symfony/lib/autoload/sfCoreAutoload.class.php';
sfCoreAutoload::register();
class ProjectConfiguration extends sfProjectConfiguration
{
public function setup()
{
$this->enablePlugins('sfPropel15Plugin', 'sfProtoculousPlugin', 'sfDateTime2Plugin', 'sfFormExtraPlugin', 'sfPropelUuidBehaviorPlugin', 'sfFormButtonsPlugin', 'sfAmfPlugin', 'risRedminePlugin', 'sfPhpExcelPlugin');
$this->setIncludePath();
}
public function setIncludePath()
{
sfToolkit::addIncludePath(dirname(__FILE__).'/../lib/vendor/PEAR/', 'front');
}
}
Projekt in Redmine importieren(ohne Vorgänge)
Folgende Daten werden mittels REST-API von RIS zu Redmine automatisch übergeben:
Ticket in Redmine importieren / aktualisieren
Folgende Daten werden mittels REST-API von RIS zu Redmine automatisch übergeben:
Zuordnung Mitarbeiter vom Rillsoft Ressourcenpool zu Redmine-Mitglied wird über E-Mail-Adresse gemacht
Übername von aufgewendeter Zeit aus Redmine
Create RIS database (MS SQL Server Express Edition 2005/2008)
SQLCMD -S (local)\SQLEXPRESS -E
-- Create database CREATE DATABASE ris GO -- Create login CREATE LOGIN ris WITH PASSWORD = 'myPassword', DEFAULT_DATABASE = ris, DEFAULT_LANGUAGE = english; GO -- Create user CREATE USER ris; USE ris; CREATE USER ris FOR LOGIN ris; GO -- Define role EXEC sys.sp_addrolemember @membername = 'ris', @rolename = 'db_owner'
EXIT
Configure PHP for MS SQL
... extension=php_sqlsrv_53_ts_vc6.dll extension=php_pdo_sqlsrv_53_ts_vc6.dll ...
RIS Database configuration for MS SQL
dev:
propel:
param:
classname: DebugPDO
debug:
realmemoryusage: true
details:
time: { enabled: true }
slow: { enabled: true, threshold: 0.1 }
mem: { enabled: true }
mempeak: { enabled: true }
method: { enabled: true }
memdelta: { enabled: true }
querycount: { enabled: true }
test:
propel:
param:
classname: DebugPDO
all:
propel:
class: sfPropelDatabase
param:
classname: PropelPDO
dsn: sqlsrv:Server=localhost\SQLEXPRESS,1031;Database=ris
username: ris
password: myPassword
encoding: utf-8
persistent: true
pooling: true
propel.targetPackage = lib.model
propel.packageObjectModel = true
propel.project = ris
propel.database = mssql
propel.database.driver = mssql
propel.database.url = sqlsrv:Server=localhost\SQLEXPRESS,1031;Database=ris
propel.database.createUrl = ${propel.database.url}
propel.database.user = ris
propel.database.password = myPassword
propel.database.encoding = utf-8
...