Archive

Archive for the ‘Rillsoft’ Category

RIS & Redmine

January 25, 2011 admin No comments

Redmine configuration

Administration - Custom fields
Administration - Settings - Autentification
My account - API access key

RIS risRedminePlugin configuration

  1. Open the plugin configuration file: C:\htdocs\ris\plugins\risRedminePlugin\config\app.yml
  2. Make sure to change url and key to match your Redmine url and API access key.
    all:
      pagination:
        redmineprojects:              10
        redminetasks:                 10
      redmine:
        url:                          http://localhost:8000
        key:                          77b08c3b1c17ff101a25c3fc2113dc8c8fa5c28a
        custom_field_uuid_id:         1
        priority_id:                  4
        tracker_id:                   2
    
  3. Open the plugin configuration file: C:\htdocs\ris\config\ProjectConfiguration.class.php
  4. Add risRedminePlugin to the enablePlugins array in your project Configuration
    <?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:

  • Name
  • Beschreibung
  • Kennung – UUID des Projekts


Ticket in Redmine importieren / aktualisieren


Folgende Daten werden mittels REST-API von RIS zu Redmine automatisch übergeben:

  • Thema – Vorgangsname
  • Beschreibung
  • Status – konfigurierbar für alle importierten Tickets
  • Priorität – konfigurierbar für alle importierten Tickets
  • Zugewiesen am Vorgangs – Mitarbeiter, bei dem das Kontrollkästchen “Besitzer” angekreuzt ist, oder der erste zugewiesene Mitarbeiter
  • Beginn
  • Abgabedatum
  • Geschätzter Aufwand
  • Beobachter – Alle Vorgangs-Mitarbeiter
  • Benutzerdefinierte Felder “uuid” – UUID des Vorgangs

Zuordnung Mitarbeiter vom Rillsoft Ressourcenpool zu Redmine-Mitglied wird über E-Mail-Adresse gemacht

Übername von aufgewendeter Zeit aus Redmine

  1. Aufgewendete Zeit wird von allen untergeordneten Tickets gesammelt und an Vorgangs-Mitarbeiter übernommen.
  2. Aufgewendete Zeit von Redmine-Mitglied, der nicht dem Vorgangs-Mitarbeiter zugeordnet ist, wird nicht übernommen.
  3. Wenn Ticket auf 100% erledigt ist, werden wie tatsächlich erbrachter Aufwand so auch Anfang und Ende aus aufgewendeter Zeit übernommen und der Vorgang wird als abgeschlossen markiert.






Categories: Redmine, Rillsoft Tags:

How to install RIS & MS SQL Server(Win 7)

January 17, 2011 admin No comments

Create RIS database (MS SQL Server Express Edition 2005/2008)

  1. Press the Start menu button and launch Command Prompt
    SQLCMD -S (local)\SQLEXPRESS -E
    
  2. Execute the following commands to create a new database and user:
    -- 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'
    
  3. Execute the following command to exit SQL Server console:
    EXIT
    

 

Configure PHP for MS SQL

  1. Download and Install Microsoft® SQL Server® 2008 R2 Native Client sqlncli.msi
  2. Download Microsoft Drivers for PHP for SQL Server SQLSRV20.EXE
  3. Installed the SQLSRV20.EXE in C:\Program Files\PHP\ext
  4. Open the PHP configuration file: C:\Program Files\PHP\php.ini
  5. Insert the following configuration parameters:
    ...
    extension=php_sqlsrv_53_ts_vc6.dll
    extension=php_pdo_sqlsrv_53_ts_vc6.dll
    ...
    

 

RIS Database configuration for MS SQL

  1. Open the databases configuration file: C:\htdocs\ris\config\databases.yml
  2. Make sure to change host, dbname, username and password to match your account.
    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
    
  3. Open the propel configuration file: C:\htdocs\ris\config\propel.ini
  4. Make sure to change host, dbname, user and password to match your account.
    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
    ...
    
Categories: Rillsoft Tags:

How to install RIS (Win 7)

December 24, 2010 admin No comments

Install the MySQL 5.1

  1. Download the MySQL Win32 installer to the Desktop: ftp://ftp.fu-berlin.de/unix/databases/mysql/Downloads/MySQL-5.1/mysql-essential-5.1.54-win32.msi
  2. Run the MySQL installer. (double-click on the icon).
  3. A warning “The publisher could not be verified” will appear. Click “Run” to start the MySQL installer.
  4. On the “Welcome to the Setup Wizard for MySQL Server 5.1″ screen, click “Next”.
  5. On the next window, click the radio button “Typical”, and then click “Next”.
  6. Click “Install”. (Be patient, this can take up to several minutes).
  7. Click “Next”.
  8. Click “Next”.
  9. Make sure “Configure the MySQL Server now” is checked and click “Finish”.
  10. On the “Welcome to the MySQL Instance Configuration Wizard 1.0.17.0″ screen, click “Next”.
  11. On the next window, click the radio button “Standard Configuration”, and then click “Next”.
  12. Check “Install As Windows Service”, set the Service Name to “MySQL”, and check “Launch the MySQL Server automatically”. Make sure that the “Include Bin Directory in Windows Path” is NOT checked. Click “Next”.
  13. On the next screen, check the box that says “Modify Security Settings”. Enter a password for the default “root” account, and confirm the password in the box below. Do NOT check the boxes “Enable root access from remote machines” or “Create An Anonymous Account”. Click “Next”.
  14. Click “Execute”. (This may take a few minutes. Be patient).
  15. Click “Finish”.

Create RIS database (MySQL)

  1. Go to: Start > All Programs > MySQL > MySQL Server 5.1 > MySQL Command Line Client.
  2. It will ask you for a password. Enter the password you created in step 14 Install the MySQL 5.1. (If you enter an incorrect password MySQL will automatically close the command line)
  3. Next, type in the commands shown below:
    CREATE DATABASE ris CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE USER 'ris'@'localhost' IDENTIFIED BY 'myPassword';
    GRANT ALL ON ris.* TO 'ris'@'localhost';
    

 

Install the Apache 2.2 webserver

  1. Download the Apache Win32 installer to the Desktop: http://apache.prosite.de/httpd/binaries/win32/httpd-2.2.17-win32-x86-openssl-0.9.8o.msi
  2. Run the Apache installer (double-click on the icon)
  3. A warning “The publisher could not be verified” will appear. Click “Run” to start the Apache installer.
  4. On the “Welcome to the Installation Wizard for Apache HTTP Server 2.2.4″ screen, click “Next”
  5. Accept the terms and conditions (Apache License) , and click “Next”.
  6. On the “Read This first” screen, click “Next”
  7. On the “Server Information” screen, make sure the Network Domain, Server Name and Administrator’s Email Address are valid/correct. Install Apache for all users, on Port 80, as a Service. Click “Next”.
  8. On the Setup Type screen, choose “Typical”, and click “Next”.
  9. Install dir: C:\Program Files\Apache Software Foundation\Apache2.2
  10. Click “Next”.
  11. Click “Install” (This may take a few minutes. Be patient).
  12. Click “Finish” to close the Apache installation Wizard.
  13. Test the Apache installation by entering http://localhost/. A successful installation will display a page containing “It Works!”).

 

Install PHP 5.3

  1. Download the PHP Win32 installer to the Desktop: http://windows.php.net/downloads/releases/php-5.3.6-Win32-VC9-x86.msi
  2. Run the installer (php-5.3.6-win32-installer) (double-click on the icon)
  3. A warning “The publisher could not be verified” will appear. Click “Run” to start the PHP installer.
  4. On the “Welcome to the PHP 5.3.6 Setup Wizard” screen, click “Next”
  5. Accept the PHP License and click “Next”
  6. Choose the default value for installing PHP: C:\Program Files\PHP and click “Next”
  7. In the “Web Server Setup” screen, choose “Apache 2.2.x Module” and click “Next”
  8. In the “Apache Configuration Directory” screen, click on “Browse” and browse to C:\Program Files\Apache Software Foundation\Apache2.2\conf for the Apache Configuration Directory. Click “Next”.
  9. On the “Choose Items To Install” screen, accept the default selection and click “Next”.
  10. Click “Install” to start the installation of PHP.
  11. Click “Finish” to close the PHP installation Wizard.
  12. In order to read the PHP settings, restart the Apache webserver: locate the Apache icon in the right of the task bar (a red feather and a white dot), left-click on it, follow “Apache 2″ and choose “Restart”.
  13. Test the PHP installation
    • Create a text file named info.php in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs and write the following PHP code in it:
            		<?php phpinfo(); ?>
      
    • Save this file, and browse to http://localhost/info.php. If you see a lengthy web page showing the status of the PHP installation (PHP Version 5.3.6), the Apache/PHP installation was successful.

Configure PHP

  1. Open the PHP configuration file: C:\Program Files\PHP\php.ini
  2. Check the following configuration parameters:
    ...
    upload_max_filesize = 200M
    ...
    memory_limit = 1024M
    max_execution_time = 300
    max_input_time = 600
    ...
    

Install the RIS

  1. Download the RIS to the Desktop:
  2. Extract zip files to C:/htdocs/ris.

RIS Database configuration

  1. Open the databases configuration file: C:\htdocs\ris\config\databases.yml
  2. Make sure to change host, dbname, username and password to match your account.
    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: 'mysql:host=localhost;dbname=ris'
          username: myUser
          password: myPassword
          encoding: utf8
          persistent: true
          pooling: true
    
  3. Open the propel configuration file: C:\htdocs\ris\config\propel.ini
  4. Make sure to change host, dbname, user and password to match your account.
    propel.targetPackage       = lib.model
    propel.packageObjectModel  = true
    propel.project             = ris
    propel.database            = mysql
    propel.database.driver     = mysql
    propel.database.createUrl  = ${propel.database.url}
    propel.database.url        = mysql:host=localhost;dbname=ris
    propel.database.user       = myUser
    propel.database.password   = myPassword
    propel.database.encoding   = utf8
    ...
    
  5. RIS Configuration for Swift Mailer

    1. Open the factories configuration file: C:\htdocs\ris\apps\frontend\config\factories.yml
    2. Make sure to change host, port, username and password to match your account.
      ...
        mailer:
          class: sfMailer
          param:
            logging:            %SF_LOGGING_ENABLED%
            charset:            %SF_CHARSET%
            delivery_strategy:  realtime
            transport:
              class:            Swift_SmtpTransport
              param:
                host:           mySmtpHost
                port:           mySmtpPort
                encryption:     ssl
                username:       mySmtpUser
                password:       mySmtpPassword
      ...
      

     

    RIS Initialize database

    Run the following symfony tasks:

    C:\Users\Administrator>cd C:\htdocs\ris
    C:\htdocs\ris>php symfony cc
    C:\htdocs\ris>php symfony propel:insert-sql --no-confirmation
    C:\htdocs\ris>php symfony propel:data-load --trace --env=dev --application=frontend
    

    Configure Apache

    1. Open the Apache configuration file: C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf
    2. #DocumentRoot "C:/Program Files/Apache Software Foundation/Apache2.2/htdocs"
      
    3. DocumentRoot "C:/htdocs/ris/web"
      DirectoryIndex index.php
      <Directory "C:/htdocs/ris/web">
      	Options +FollowSymLinks -Indexes
      	AllowOverride All
      	Order Deny,Allow
      </Directory>
      
      Alias /sf "C:/htdocs/ris/lib/vendor/symfony/data/web/sf
      <Directory "C:/htdocs/ris/lib/vendor/symfony/data/web/sf">
         AllowOverride All
         Allow from All
      </Directory>
      

    Ports 80, 443 freigeben

    http://webcyclus.de/windows-7-ports-freigeben/

    RIS Floating License modul installation

    1. Download the RIS Floating License modul(Win 32 Bit, PHP 5.3.6 VC9 x86 Thread Safe) to the Desktop: http://www.rillsoft.com/download/src/win32/PHP_5.3.6/VC9/x86/php_ris.dll
    2. Copy php_ris.dll to C:\Program Files\PHP\ext\
    3. Open the PHP configuration file: C:\Program Files\PHP\php.ini
    4. Add the following configuration parameters:
      extension=php_ris.dll
      
    5. Test the RIS Floating License modul
      C:\Users\Administrator>php -m
      
    6.  

Categories: Rillsoft Tags:

How to use floating license & RIS

May 13, 2010 admin No comments

RIS License modul installation (CentOS 5.4)

# cd /usr/lib/php/modules/
# wget --http-user=*** --http-passwd=*** http://www.rillsoft.de/download/src/centos/5.4/i386/PHP_5.2.10/ris.so
# echo "extension=ris.so" > /etc/php.d/ris.ini
# /etc/init.d/httpd restart

For CentOS 5.4 64 Bit http://www.rillsoft.de/download/src/centos/5.4/x86_64/PHP_5.2.10/ris.so
For Ubuntu 10.04 32 Bit + PHP 5.3.2 http://www.rillsoft.de/download/src/ubuntu/10.04/i386/PHP_5.3.2/ris.so
For Ubuntu 10.04 64 Bit + PHP 5.3.2 http://www.rillsoft.de/download/src/ubuntu/10.04/amd64/PHP_5.3.2/ris.so

Verify it using the following command

# php -i | grep ris

 

Categories: CentOS, Rillsoft Tags:

How to install RIS (CentOS 5.4)

May 7, 2010 admin No comments

RIS installation

# cd /var/www/html
# rm ris_mysql.zip
# wget --http-user=*** --http-passwd=*** http://www.rillsoft.com/download/src/ris_mysql.zip
# unzip -uo ris_mysql.zip -d /var/www/html/ris
# chmod -R 777 cache log blob
# chown -R apache:apache /var/www/html
# php symfony cc

 

Configure Apache 2

Open httpd.conf

# vi /etc/httpd/conf/httpd.conf

At the end of your config file you’ll need to add the following code:

DocumentRoot /var/www/html/web
<Directory /var/www/html/web>
   <IfModule sapi_apache2.c>
      php_admin_flag engine on
      php_admin_flag safe_mode off
      php_admin_value open_basedir none
   </IfModule>
   <IfModule mod_php5.c>
      php_admin_flag engine on
      php_admin_flag safe_mode off
      php_admin_value open_basedir none
   </IfModule>
   Options +FollowSymLinks -Indexes
   AllowOverride All
</Directory>

Alias /sf /var/www/html/lib/vendor/symfony/data/web/sf
<Directory /var/www/html/lib/vendor/symfony/data/web/sf>
   AllowOverride All
   Allow from All
</Directory>
# /etc/init.d/httpd restart

 

PHP configuration check

Execute the check script.

# cd /var/www/html
# php lib/vendor/symfony/data/bin/check_configuration.php

You will see the following results:

********************************
*                              *
*  symfony requirements check  *
*                              *
********************************

php.ini used by PHP: /etc/php.ini

** WARNING **
*  The PHP CLI can use a different php.ini file
*  than the one used with your web server.
*  If this is the case, please launch this
*  utility from your web server.
** WARNING **

** Mandatory requirements **

  OK        PHP version is at least 5.2.4 (5.2.10)

** Optional checks **

  OK        PDO is installed
  OK        PDO has some drivers installed: mysql, odbc, sqlite
  OK        PHP-XML module is installed
  OK        XSL module is installed
  OK        The token_get_all() function is available
  OK        The mb_strlen() function is available
  OK        The iconv() function is available
  OK        The utf8_decode() is available
  OK        A PHP accelerator is installed
  OK        php.ini has short_open_tag set to off
  OK        php.ini has magic_quotes_gpc set to off
  OK        php.ini has register_globals set to off
  OK        php.ini has session.auto_start set to off
  OK        PHP version is not 5.2.9

 

Database configuration

Open databases.yml

# vi  /var/www/html/config/databases.yml

Make sure to change host, dbname, myUser and myPassword to match your account.

dev:
  propel:
    param:
      classname: DebugPDO
      debug: { realmemoryusage: true, details: { time: { enabled: true }, slow: { enabled: true, threshold: 0.1 }, mem: { enabled: true }, mempeak: { enabled: true }, memdelta: { enabled: true } } }
test:
  propel:
    param:
      classname: DebugPDO
all:
  propel:
    class: sfPropelDatabase
    param:
      classname: PropelPDO
      dsn: 'mysql:host=localhost;dbname=ris'
      username: myUser
      password: myPassword
      encoding: utf8
      persistent: true
      pooling: true

 

# vi  /var/www/html/config/propel.ini
propel.targetPackage       = lib.model
propel.packageObjectModel  = true
propel.project             = ris
propel.database            = mysql
propel.database.driver     = mysql
propel.database.createUrl  = ${propel.database.url}
propel.database.url        = mysql:host=localhost;dbname=ris
propel.database.user       = myUser
propel.database.password   = myPassword
propel.database.encoding   = utf8
...

 

Configuration for Swift_FailoverTransport

# vi  /var/www/html/apps/frontend/config/factories.yml
...
  mailer:
    class: sfMailer
    param:
      logging:            %SF_LOGGING_ENABLED%
      charset:            %SF_CHARSET%
      delivery_strategy:  realtime
      transport:
        class:            Swift_SmtpTransport
        param:
          host:           smtp.googlemail.com
          port:           465
          encryption:     ssl
          username:       myUser
          password:       myPassword
...

 

Initialize database

Run the following symfony tasks:

# cd /var/www/html
# php symfony cc
# php symfony propel:insert-sql --no-confirmation
# php symfony propel:data-load --trace --env=dev --application=frontend
Categories: CentOS, Rillsoft Tags: