Openfiler 2.99.2 & USB boot & Large Volumes & iSCSI & Samba

November 26, 2011 admin 1 comment

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.

  • At the installer screen, type ‘linux text’.
  • Partition your drive as follows:
    • /boot, ext2, 100MB, primary
    • /, ext3, 4096MB , primary
    • /var/log, ext3, Fill to max, not primary

 

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

  • Click on Volumes tab
  • Click on Block Devices to access the Physical Volume creation page

Volumes Volume Groups

  • Click on the disk you want to create the Volume on (Example: /dev/sdb)

Volumes Block Devices

  • Adjust the start and end cylinders to determine the size of physical volume and when satisfied press the ‘Create’ button

Volumes Block Devices Edit Partitions

But it only uses 95% of the free space.
Volumes Block Devices Edit Partitions

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
Volumes Block Devices Edit Partitions
 

Openfiler 2.99.2 & iSCSI & Samba

Create a New Volume Group

  • Click on Volumes tab
  • Click Volume Groups to create a volume group.
  • Name your volume group and add your partitions.
  • Click Add volume group

Volumes Volume Groups

You should now be presented with a new Volume Group that looks like this
Volumes Volume Groups

Add New Volume for iSCSI

  • Click on Volumes tab
  • Click Add Volume
  • Enter in a volume name: no spaces, no fancy characters
  • Enter in the amount of space in MB required
  • Select the type ‘block’
  • Click Create

Volumes Add Volume Mozilla

You should now be presented with a new Volume for iSCSI that looks like this:
Volumes Manage Volumes
 

Add New Volume for Samba
You will need to setup Volumes with either XFS or EXT3 filesystems (you cannot create shares from iSCSI volumes).

  • Click on Volumes tab
  • Click Add Volume
  • Enter in a volume name: no spaces, no fancy characters
  • Enter in the amount of space in MB required
  • Select the type ‘ext3′
  • Click Create

Volumes Add Volume

You should now be presented with a new Volume for Samba that looks like this
Volumes Manage Volumes

Enable the iSCSI and Samba Target Service

  • Click on Services -> CIFS server -> Enable
  • Click on Services -> CIFS server -> Start
  • Click on Services -> iSCSI target -> Enable
  • Click on Services -> iSCSI target -> Start

Services Section

Network Access Configuration

  • Click on System tab
  • Click Network Setup
  • In the Network Access Configuration section
    • Name: The name of the host or the network
    • Single machine example(Crossover Cable ESX Network)
      • Network/Host: 192.168.182.177
      • Netmask: 255.255.255.255
    • Network example
      • Network/Host: 192.168.181.0
      • Netmask: 255.255.255.0

System Network Setup

Add iSCSI Target

  • Click on Volumes tab
  • Click iSCSI Targets
  • In the Add new iSCSI Target section
    • Click Add

Map the LUN
You now need to map a LUN to your iSCSI target

  • Click on Volumes tab
  • Click iSCSI Targets
  • Select the Target Configuration tab
    • In the Select iSCSI Target section, select the iSCSI target that you want to work on from the drop-down and click Change
      • Select the LUN Mapping tab
        • Click Map

      Volumes iSCSI Targets

      Allow access to the iSCSI Target:
      Volumes iSCSI Targets

      Use LDAP

      • Click on Accounts / Authentication
      • Check Use LDAP
      • Check Use Local LDAP
      • Server: 127.0.0.1
      • Base DN: dc=openfiler,dc=nas
      • Root bind DN: cn=Manager,dc=openfiler,dc=nas
      • Root bind password: your_root_password

      Accounts Authentication

      Add Network Shares

      • Click on Shares
      • Click on the link for your volume and create a sub-folder.
      • Click on the link for your new sub-folder and Make Share
      • Scroll down to “Group Access Configuration”
        • Select a group to be your primary group.
        • Select permissions for the rest of your groups
      • Scroll down to “Host Access Configuration”
        • Select the MAXIMUM ALLOWABLE permissions for your networks

      Shares Section

      Shares Edit Share
      Shares Section

      Synchronise Time

      • Click on System tab
      • Click Clock Setup
      • Server: 1.pool.ntp.org
      • Click Setup synchronization

      System Clock Setup

      Links

      Using Openfiler and vSphere ESX / ESXi 4

Categories: Openfiler Tags:

How to install graphviz & Redmine 1.2 (CentOS 5.6)

November 2, 2011 admin No comments

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

 

Categories: CentOS, Redmine Tags:

PHPUnit & Symfony functional test

April 11, 2011 admin No comments
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.

Categories: Troubleshooting Tags:

Microsoft Dynamics NAV & SQL Server 2008 R2 Express

February 28, 2011 admin No comments
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
Categories: NAV Tags:

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 Redmine 1.4 (CentOS 5.8)

January 17, 2011 admin 2 comments

Install the Apache

Install the MySQL 5.1

# yum install mysql mysql-devel mysql-server
# chkconfig --levels 235 mysqld on
# /etc/init.d/mysqld start

Create database for Redmine:

# mysql -u root -p
CREATE DATABASE redmine CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'redmine'@'localhost' IDENTIFIED BY 'redmine';
GRANT ALL ON redmine.* TO 'redmine'@'localhost';

 

Installing Ruby

# yum install gcc-c++ openssl openssl-devel zlib zlib-devel mysql-devel postgresql-devel subversion wget
# wget ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.7.tar.gz
# tar zxvf ruby-1.8.7.tar.gz
# cd ruby-1.8.7
# ./configure
# make && make install

math.c:37:13: error: missing binary operator before token "("
make: *** [math.o] Error 1
Just open math.c [Don’t locate any where just use vi math.c from the same same location where you are executing the command ‘make’]
And look at the line
“#elif define(ERANGE)” it should be “#elif defined(ERANGE)”
Note: not “define”, it is “defined” => d is missing in this phrase

 

Installing RubyGems

# wget http://production.cf.rubygems.org/rubygems/rubygems-1.8.7.tgz
# tar zxvf rubygems-1.8.7.tgz
# cd rubygems-1.8.7
# ruby setup.rb

 

Installing Redmine

# cd /opt
# svn co http://redmine.rubyforge.org/svn/branches/1.4-stable redmine-1.4

Installing Bundler

# gem install bundler

Installing Rails

# cd /opt/redmine-1.4
# bundle install --without development test postgresql sqlite rmagick

 

Created lets configure our database settings for Redmine:

# cd /opt/redmine-1.4
# cp  config/database.yml.example config/database.yml

Edit config/database.yml and set your settings:

# vi config/database.yml
 production:
    adapter: mysql
    database: redmine
    host: localhost
    username: redmine
    password: redmine

Generate a session store secret:

# cd /opt/redmine-1.4
# rake config/initializers/session_store.rb

Create the database structure:

# RAILS_ENV=production rake db:migrate
# RAILS_ENV=production rake redmine:load_default_data

Configure email settings:

cd /opt/redmine-1.4
cp config/email.yml.example config/email.yml

 

Option 1. Running under Apache

# yum install httpd-devel curl-devel apr-devel gcc gcc-c++
# gem install passenger
# passenger-install-apache2-module
# cd /opt/redmine-1.4
# chown -R root:root .
# chown -R apache:apache files log tmp public/plugin_assets
# chmod -R 755 files log tmp public/plugin_assets
# chown -R apache:apache config/environment.rb
# vi /etc/httpd/conf.d/passenger.conf
LoadModule passenger_module /usr/local/lib/ruby/gems/1.8/gems/passenger-3.0.12/ext/apache2/mod_passenger.so
PassengerRoot /usr/local/lib/ruby/gems/1.8/gems/passenger-3.0.12
PassengerRuby /usr/local/bin/ruby

# delete HTTP header which would be added by Passenger
Header always unset "X-Powered-By"
Header always unset "X-Rack-Cache"
Header always unset "X-Content-Digest"
Header always unset "X-Runtime"

# for passenger tuning
PassengerLogLevel 0
RailsAutoDetect On
PassengerMaxPoolSize 20
PassengerMaxInstancesPerApp 4
PassengerPoolIdleTime 3600
PassengerUseGlobalQueue on
#PassengerHighPerformance on !!! conflict with DAV svn
PassengerStatThrottleRate 10
RailsSpawnMethod smart
RailsAppSpawnerIdleTime 86400
RailsFrameworkSpawnerIdleTime 0
PassengerUserSwitching On
PassengerDefaultUser apache
PassengerMaxRequests 3000
PassengerMinInstances 3
# vi /etc/httpd/conf/httpd.conf
DocumentRoot "/opt/redmine-1.4/public"
# ln -sf /opt/redmine-1.4/public /var/www/html/redmine

Redmine under a subdirectory

# vi /etc/httpd/conf/httpd.conf
RailsAutoDetect off
PassengerAppRoot /opt/redmine-1.4
RailsBaseURI  /redmine
Alias "/redmine" /opt/redmine-1.4/public

Check disable SElinux !!!
[error] *** Passenger could not be initialized because of this error: Unable to start the Phusion Passenger watchdog (/usr/local/lib/ruby/gems/1.8/gems/passenger-3.0.11/agents/PassengerWatchdog): Permission denied (13)
How to disable SElinux

Option 2. Running under Apache

# yum install yum-priorities
# rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
# rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm
# yum update
# yum install curl-devel apr-devel
# yum install openssl openssl-devel
# yum install zlib zlib-devel
# yum install gcc gcc-c++
# yum install subversion mod_dav_svn
# yum install perl-HTML-Parser perl-SVN-Notify

Installing Thin

# gem install thin
# thin install
# chkconfig --levels 235 thin on

Configure Thin

# thin config -C /etc/thin/redmine.yml -c /opt/redmine --servers 3 -e production
# service thin start

 

Configure Apache and add a Redmine config file

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

Uncomment

NameVirtualHost *:80
# vi /etc/httpd/conf.d/redmine.conf
<VirtualHost *:80>
        DocumentRoot /opt/redmine-1.4
        ServerName redmine.how2centos.com
        <Proxy balancer://redminecluster>
                 BalancerMember http://127.0.0.1:3000
                 BalancerMember http://127.0.0.1:3001
                 BalancerMember http://127.0.0.1:3002
        </Proxy>
        ProxyPass / balancer://redminecluster/
        ProxyPassReverse / balancer://redminecluster/
        ErrorLog /var/log/httpd/redmine_error.log
        CustomLog /var/log/httpd/redmine_access.log combined
</VirtualHost>

(13)Permission denied: proxy: HTTP: attempt to connect
# setsebool -P httpd_can_network_connect=1

Option 3. Starting Redmine on built-in WEBrick web server

# cd /opt/redmine-1.4
# ruby script/server webrick -p 8000 -e production

Change IPTables

# vi /etc/sysconfig/iptables

Includes the following before the REJECT line:

-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 8000 -j ACCEPT
# service iptables restart

 
After its started you can access Redmine on the following URL:

http://your.ser.ver.ip:8000/

Use default administrator account to log in:

    * login: admin
    * password: admin

 

Optional Intall ImageMagick

# yum install ImageMagick ImageMagick-devel libpng libpng-devel freetype freetype-devel giflib giflib-devel
# yum erase ImageMagick ImageMagick-devel
# wget ftp://ftp.imagemagick.org/pub/ImageMagick/ImageMagick.tar.gz
# tar -xzvf ImageMagick.tar.gz
# cd ImageMagick-6.6.7-6
# ./configure --without-perl
# make
# make install
gem install rmagick

 
Can’t install RMagick 2.13.1. Can’t find MagickWand.h.

C_INCLUDE_PATH=/usr/src/ImageMagick-6.7.4-8 gem install rmagick

 

Optional Imtall SVN

# yum install mod_dav_svn subversion
# mkdir /opt/svn
# chown root:apache /opt/svn
# chmod 0750 /opt/svn
# ln -s /opt/redmine/extra/svn/Redmine.pm /usr/lib/perl5/5.8.8/Redmine.pm

 

# vi /etc/httpd/conf.d/svn.conf
PerlLoadModule Redmine
<Location /svn>
    DAV svn
    SVNParentPath "/opt/svn"
    AuthType Basic
    AuthName "Redmine SVN Repository"
    Require valid-user

    PerlAccessHandler Apache::Authn::Redmine::access_handler
    PerlAuthenHandler Apache::Authn::Redmine::authen_handler

    RedmineDSN "DBI:mysql:database=redmine;host=localhost"

    RedmineDbUser "redmine"
    RedmineDbPass "redmine"
</Location>

 

Optional Autocreate Subversion Repositories

Go to Administration -> Settings -> Repositoryand check Enable WS for repository management.

# vi /etc/cron.d/redmine
*/10 * * * * root ruby /opt/redmine/extra/svn/reposman.rb --redmine localhost --svn-dir /opt/svn/ --owner apache --url file:///opt/svn/ --verbose >> /var/log/reposman.log

 

Trac to Redmine migration

# yum install ruby-devel sqlite sqlite-devel ruby-rdoc
# gem install sqlite3-ruby --version=1.2.5
# rake redmine:migrate_from_trac RAILS_ENV=production --trace

Upgrade 1.3 to 1.4

A key is required to write a cookie containing the session data. Use config.action_controller.session = { :key => “_myapp_session”, :secret => “some secret phrase” } in config/environment.rb

#rake config/initializers/session_store.rb
Categories: CentOS, Redmine 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:

Undefined offset: 0 in ..\SOAP\Transport\HTTP.php on line 341

December 13, 2010 admin No comments
'HTTP/1.1 200 OK
Date: Mon, 13 Dec 2010 19:42:59 GMT
Server: Apache/2.2.16 (Win32) PHP/5.3.3
X-Powered-By: PHP/5.3.3
Set-Cookie: symfony=c7negjfjla0njaej17lo89hjl2; path=/
Content-Length: 2701
Connection: close
Content-Type: text/xml; charset=UTF-8
X-Pad: avoid browser bug'

 

SOAP\Transport\HTTP.php

    /**
     * Parses the headers.
     *
     * @param array $headers  The headers.
     */
    function _parseHeaders($headers)
    {
        /* Largely borrowed from HTTP_Request. */
        $this->result_headers = array();
        $headers = explode("\r?\n", $headers);
        foreach ($headers as $value) {
            if (strpos($value,':') === false) {
                $this->result_headers[0] = $value;
                continue;
            }
            list($name, $value) = explode(':', $value);
            $headername = strtolower($name);
            $headervalue = trim($value);
            $this->result_headers[$headername] = $headervalue;

 

    /**
     * Parses the headers.
     *
     * @param array $headers  The headers.
     */
    function _parseHeaders($headers)
    {
        /* Largely borrowed from HTTP_Request. */
        $this->result_headers = array();
        $headers = str_replace("\r","",$headers);
        $headers = explode("\n",$headers);
        foreach ($headers as $value) {
            if (strpos($value,':') === false) {
                $this->result_headers[0] = $value;
                continue;
            }
            list($name, $value) = explode(':', $value);
            $headername = strtolower($name);
            $headervalue = trim($value);
            $this->result_headers[$headername] = $headervalue;

 

Categories: SOAP, Troubleshooting Tags:

-bash: ./configure: Permission denied

June 2, 2010 admin No comments
chmod u+x configure
Categories: Troubleshooting Tags: