NOK Configuration for the Linthal 2015 Project

Contents

  1. NOK Configuration for the Linthal 2015 Project
  2. Notes
  3. Terminology
  4. Contact Information
    1. Contact Addresses
      1. Main Office
      2. Axpo Informatik
      3. Construction Site
    2. Contact Names
  5. Documentation and Notes on System Updates for Axpo
  6. Discussions and Input Data from NOK
    1. 2009.10.13: Email from GMM
    2. 2009.10.16: AH/GMM/etc. Meeting in Baden to discuss classification system and workflows
    3. 2009.10.23: Emails from GMM for Training
    4. 2009.10.23: Phone call AH/GMM
    5. 2009.10.30: Email from GMM: Configuration Corrections
    6. 2009.11.02: Email from GMM: Corrected !ToDo List
    7. 2009.11.03: Conference Call AH/GMM
    8. 2009.11.03: Email from GMM: Updated Configuration Files
    9. 2009.11.03: Updated NOK ToDo List
    10. 2009.11.19: Phone call AH/GMM
    11. 2009.11.24: Email from GMM and phone call AH/GMM
    12. 2009.12.18: Email from GMM
    13. 2010.01.15: Phone call AH/GMM
    14. 2010.01.18: Email GMM
    15. 2010.01.29: Email GMM
  7. Training Sessions - List of Attendees
    1. Session 1: 2009-11-10, 13:00, Tuesday, Baden
    2. Session 2: 2009-11-11, 13:00, Wednesday, Tierfeld
    3. Session 3: 2009-11-10, 09:00, Friday, Baden
  8. Project to DrawMGT Configuration Mapping
  9. NOK Document Coding System
    1. Drawing and Revision Code Format
  10. Generated SQL Configuration Files
  11. Access to Axpo CentOS System
    1. Access to Axpo External CentOS System
    2. Access to Axpo Internal CentOS System
    3. Using CVS on the Axpo CentOS External System
    4. Using CVS on the Axpo CentOS Internal System
  12. Changes to the default httpd.conf
  13. Installing DrawMGT on drawmgt-pswlimmern.axpo.ch
  14. Switchover lu.softxs.ch --> drawmgt.pswlimmern.axpo.ch Servers
    1. Status of 2009-01-10 17:30
    2. Implementation Steps
  15. Deleting Users
  16. Changing UserRoles

Notes

  1. The official project name is PSW Limmern (Linthal 2015 is a project above, which include PSW Limmern)

  2. NOK is being renamed as Axpo

  3. Axpo Informatic will host our server. They seem to be quite independent of NOK and the Linthal project

  4. This page describes a configuration method for the Linthal project, which could become a model
    • for configuring other project too.

Terminology

  1. Zust. = Approval (Zustimmung)
  2. Indextyp = Document code type

Contact Information

Contact Addresses

Main Office

Axpo Informatik

Construction Site

Contact Names

Documentation and Notes on System Updates for Axpo

  1. AxpoTaskEmailImplementation - Notes set to Axpo describing the task email updates requested May 2011

Discussions and Input Data from NOK

2009.10.13: Email from GMM

  1. Bewilligungsauflagen Erfassung DrawMGT v02.xlsx - Example spreadsheet for Bewilligungsauflagen

  2. Request for management of milestone dates, that can be assigned to tasks as due dates. This includes the ability
    • change the dates for milestones and have them automatically change the due dates of the tasks.

2009.10.16: AH/GMM/etc. Meeting in Baden to discuss classification system and workflows

  1. Request for feature (for document/revision security): New flag in Drawings and/or Revision record:
    • Public to Bereich
    • Public to entire system
  2. Request for feature: New workflow step F Freigabe, a final approval that is performed after all the

    • other Z (Zustimmung) approvals, and before the Submit workflow step. To be called Release in English.

  3. New ApprovalStatus: Nicht efforderlich (e.g. N/A - Not Required). Rules:

    • Plan date: optional

    • Complete date: must be empty

    • Initials: optional

  4. Summary of German language approval steps:
    • Offen
    • Erteilt
    • Erteilt mit Kommentar
    • Abgelehnt
  5. Implement new workflows:
    • DCAAAAR - Design-Check-App1-App2-App3-App4-Release

    • DCAAAARS - Design-Check-App1-App2-App3-App4-Release-Submit

    • RCAAAAR - Receive-Check-App1-App2-App3-App4-Release

    • RCAAAARS - Receive-Check-App1-App2-App3-App4-Release-Submit

  6. Request for improved event history to see exactly what was changed in workflows.
  7. Idea for new Comment field for each Approval and Release workflow step

    • Did not commit to implementing this feature
    • NOK agreed to use tasks/comments for recording comments associated with approvals

New configuration files sent after the meeting from GMM:

  1. 2009.10.19 DrawMGT PSW Limmern Struktur v01.xls -- Master configuration file for classifications

    • Worksheet Indextyp -- describe drawing code format and file names
    • Worksheet Attribute PSW Limmern -- list of all the classification and other reference data
  2. 2009.10.19 DrawMGT Indextyp-Attribute v01.xlsx -- List of document code types and their components

  3. 2009.10.19 DrawMGT Doktypen-Prozesstyp v01.xlsx -- List of (project) document types and their

    • corresponding document code types and workflow types. Note that we will implement the project document type as a classification field, and separate from the documentTypeId.
  4. 2009.10.19 DrawMGT Prozesstypen Tabelle v01.xlsx -- List of desired workflows

Note that that attribute lists in the file 2009.10.19 DrawMGT PSW Limmern Struktur v01.xls generally have a set of code letters. E.g. Bereich has code aa. These same codes also appear in the document code definition and the names of the .txt and .sql files (see below).

2009.10.23: Emails from GMM for Training

  1. Training schedule: mails: 10/23/09 8:42 AM and 10/23/09 11:37 AM
    1. Montag, 9. November 2009, 13:00 - 16:00, Axpo AG Baden, Teilnehmer: 6 Neue, E. Bieri, M. Gmür Rescheduled to Dri 13th (see below)

    2. Dienstag, 10. November 2009, 13:00 - 16:00, Axpo AG Baden, Teilnehmer: 5 Neue, M. Hase, M. Gmür
    3. Mittwoch, 11. November 2009, 13:00 - 16:00, Bauleitung Tierfehd (Linthal), Teilnehmer: 4 Neue, M. Hase, M. Gmür
    4. Freitag, 13.11.2009, 9-12 Uhr, Axpo AG Baden, Teilnehmer: 6 Neue, E. Bieri, M. Gmür

2009.10.23: Phone call AH/GMM

  1. Official project name is PSW Limmern.

  2. Change workflow step name E (Erhalten/Receive) to B (Bekommen).

  3. The old (original) test system test is to be kept.

    • The new update of the data from the meeting or 2009.10.16 should go in the beta system.

  4. OK to delay deployment of production system to the Axpo hosted server to the end of the year

2009.10.30: Email from GMM: Configuration Corrections

New/Updated files included in the email:

  1. L2015 DrawMGT Indextyp-Attribute v02.xlsx -- Updated system classifications

    • Worksheet with document code definition (unchanged)
    • Worksheet with updates classification lists (updates marked in red)
      • Some corrections have already been made (Kontakt 571, 572)
      • Need to suppress the display of the Code for Lage and Tätigkeit
        • See cfg/linthal/site/config/Settings-CacheFieldDisplay.php

  2. L2015 DrawMGT PSW Limmern Struktur v02.xls -- Contract/Group structure

    • Contract and Group structure
    • Should map to the ContractRef and Groups worksheets in linthal-configuration.xls

  3. L2015 DrawMGT Testsystem Korrekturliste v01.xlsx -- List of ToDo items (See below)

    • Review items:
      • State which items easy/difficult to implement
      • Separate into translation/programming/configuration

2009.11.02: Email from GMM: Corrected !ToDo List

  1. L2015 DrawMGT Testsystem Korrekturliste v02.xlsx -- List of ToDo items, with priorities added. (See below)

Most corrections should be made in the worksheets in cfg/linthal/site/config/linthal-configuration.xls, and then then loaded into the linthal system and described below.

2009.11.03: Conference Call AH/GMM

  1. L2015 DrawMGT Testsystem Korrekturliste v02-AH1.xls -- Updated from conference call with AH/TN remarks

Discussion of system configuration ToDo list (attached above). See column 'AH/TN Bemerkungen', for the list of to do items. We need to:

  1. Discuss the PROBLEM (bright-pink) items, and decide how to proceed.
  2. Implement the configuration changes, easy fixes and bugs (light-pink) items.
  3. Implement the translation (yellow) items.

I hope we can implement all of these by the end of the week.

2009.11.03: Email from GMM: Updated Configuration Files

  1. linthal-configuration v02.xls -- File returned from GMM. Only the Users worksheet appears to be updated.

  2. L2015 DrawMGT Rollen v01.xlsx -- List of user roles, and DE names for the roles.

  3. L2015 DrawMGT PSW Limmern Struktur v02b.xls -- Updates to contract & group codes, marked in red. (File renamed to v02b from v02)

2009.11.03: Updated NOK ToDo List

  1. L2015 DrawMGT Testsystem Korrekturliste v02-AH3.xls - Includes new columns AH/TN Remarks & Status

2009.11.19: Phone call AH/GMM

  1. Update test system with latest CVS updates
  2. Create new task type Bewilligungsauflagen

  3. Update L2015 DrawMGT Testsystem Korrekturliste v02-AH4.xls

    1. Update with input collected during training sessions
    2. Sent to GMM
  4. Check Auflagen spreadsheet: check fields can fit in the Comments table
    1. (Bewilligungsauflagen Erfassung DrawMGT v02.xlsx) -- see email from 2009.10.13 above)

  5. Suggestion for allowing task subscribers to download documents attached to a task, regardless of their user roles. E.g.
    • making some a subscriber to a task, would automatically give them viewing rights to all documents attached to the task.

2009.11.24: Email from GMM and phone call AH/GMM

  1. Corrected ToDo List L2015 DrawMGT Testsystem Korrekturliste v03.xls

  2. We should respond with our status and mark items that will not be complete when going live

2009.12.18: Email from GMM

  1. Deadline for going live: 2009.01.08 -- Axpo personnel only
  2. Deadline for going live: 2009.01.15 -- All project partners
  3. Final to do items:
    1. DrawMGT Handbook - translate into German
    2. Schritt-für-Schritt Dokumentation - To be implemented in wiki
    3. Set user passwords and send emails to them
    4. Implement configuration for new Bereich LUe TN done (date?)

    5. Update user roles TN done (date?)

  4. Anleitung_Bestellungserfassung_EBanf v1.2.pdf -- Example Schritt-für-Schritt documetation

  5. L2015 DrawMGT PSW Limmern Struktur v05.xls -- Updated Project Structure

  6. L2015-DrawMGT-Rollen-v07.xls -- Updated User Roles

2010.01.15: Phone call AH/GMM

  1. Go live next week!
  2. Four key users / system administrators:
    • Michael Schlegel
    • Adele Grandhi
    • Hans Matter
    • Daniela Kuhn
  3. Set and send passwords to all users on Monday 18-Jan
    1. Can we force users to change password on first login?
  4. Documentation requirements:
    1. Urgently need: CHecklist for login and password change
    2. Urgently need: General DE documentation for Document Transmission
    3. Need checklist for: Sitzung Protocol verschicken
    4. Need checklist for: Metedata upload
  5. Agreed to send:
    1. Link for Wiki's:
      1. Linthal wiki: checklist, FAQ
      2. General DE documentation
    2. Copy of example WebCast

  6. They want a Sicherheits Eklärung
    1. How passwords stored/managed
    2. Possibilities for improving security
      1. Force password change after first-login
      2. Block account after n failed logins
      3. Integration with Axpo/IT secure ID system (LDAP based?)

2010.01.18: Email GMM

  1. Corrected ToDo List in XLSX and PDF formats:

  2. He has set all priorities to 1 & 2, and set completion deadlines for all items.

  3. He requests us to tell him ASAP when deadlines can not be met.

2010.01.29: Email GMM

  1. Request for updating the transmittals template, to include Axpo colors/logos

Training Sessions - List of Attendees

Session 1: 2009-11-10, 13:00, Tuesday, Baden

As seated at table, from Martin's left:

Session 2: 2009-11-11, 13:00, Wednesday, Tierfeld

As seated at table, from Martin's left:

Session 3: 2009-11-10, 09:00, Friday, Baden

As seated at table, from Martin's left:

Project to DrawMGT Configuration Mapping

This section describes how the mapping from the NOK spreadsheet 2009.10.19 DrawMGT PSW Limmern Struktur v01.xls and the DrawMGT database tables.

A workaround is applied to fullfill NOK requieremnt 9.1 in L2015 DrawMGT Testsystem Korrekturliste v02.xls. NOK's Kontakt information will be copied also to table Companies to allow to select the same information in feld Requestor.

NOK Document Coding System

Drawing and Revision Code Format

Note: NOK calls the drawing code Indextyp

Drawing Code

Component Description

Generated SQL Configuration Files

The NOK configuration information lives in the drawmgt-cfg configuration tree:

Most of the configuration is generated from an Excel file:

The initial worksheet called Overview lists the mappings from the NOK attribute lists to their corresponding DrawMGT classification tables. Note that DrawMGT V11.3 has four extra classification tables SiteClassification1-4.

The generation is perform by saving each separate worksheet in the Excel file, in tab-separated format, into a file of the same in the data directory. The saving can be mad manually as described below or automatically with an OpenOffice macro export2Csv.bas in the same directory.

Then run a script to generate SQL files:

This script reads the .txt files and outputs .sql files

Then load the SQL into the database and run genMeta.pl

  cd cfg/linthal/site/data

  mysql -u... -p...
    create database linthal113dev;
    use linthal113dev;

    source ../../../../app/schema/drawmgt-schema.sql
    source ../../../../app/schema/id-table-schema.sql
    source ../../../../app/schema/data/refdata.sql

    source linthal-configuration.sql

    source ../../../../app/schema/id-table-setup.sql
    quit

  cd ../../../../app/etc
  ./genMeta.pl

Access to Axpo CentOS System

Contact is Jörg Leppin. See contacts above.

Access to Axpo External CentOS System

  1. Access via private RSA 1024 bit key that we supplied
    • Public and private key stored at: lu.softxs.ch:/root/axpo-ssh

      • id_rsa
      • id_rsa.pub -- sent to Jörg Leppin, to be installed on their server.
  2. Still to be defined:
    • System hostname/ip address of CentOS system
    • User name
  3. Access will be possible from the following IP addresses:
    • 81.221.23.33 (softxs.ch)

    • 80.254.184.33 (sz.softxs.ch) Joseph Kaelin's home network

  4. Typical access:
    •        ssh root@lu.softxs.ch
             ssh -i /root/axpo-ssh/id_rsa user@centos.axpo.ch

Access to Axpo Internal CentOS System

  1. Access to the internal CentOS system is performed direcly through Citrix Access Gateway (See SUP-2073 in SoftXS Tracking System).
  2. Once you logged in successfully through Citrix Access Gateway you can start an ssh tunneling to the external system to allow to use ssh login from the external system and start a small script to generate network traffic to disable timeout on the tunneling:
    •       root@SABDN471 ~]# ssh -R5556:localhost:22 root@sabdn470
            [root@sabdn470 ~]# while [ 1 ]; do sleep 60; echo -n "."; done
      
            [root@sabdn470 ~]# ssg -p5556 localhost     # log in from external to internal in any terminal

Using CVS on the Axpo CentOS External System

  1. The only network connection can be used is an incoming SSH on the Axpo system. Therefore ssh tunneling is used to allow access CVS on honir from the Axpo system. The port 2401 (pserver) will be forwarded to the ssh port on honir. The typical usage:
    honir# ssh -R 2401:localhost:22 -i ~/axpo-ssh/id_rsa root@axpo
    [root@sabdn470 ~]# su - linthal
    [linthal@sabdn470 ~]$ cd www/shtml/delta/app/etc
    [linthal@sabdn470 etc]$ cvs -q up
  2. The following settings was made to allow to use CVS so simply as above:
    1. A .cvsrc file was created in the home directory of linthal on the Axpo system with the content below, to allow the access to the CVS repository through ssh on localhost

      cvs -z9 -d linthal@localhost:/home/cvsroot
    2. A section was made in /etc/ssh/ssh_config on the Axpo system (above section 'Host *'), to use port 2401 automatically on ssh connection to localhost:

      Host localhost
          Port 2401
    3. An ssh key pair was generated on the Axpo system as user linthal and the content of the public key was copied to .ssh/authorized_keys on honir to allow to use cvs without password.

      [linthal@sabdn470 etc]$ ssh-keygen -t rsa
      [linthal@sabdn470 .ssh]$ view ~/.ssh/id_rsa.pub
      
      linthal@honir (~) 499$ vi ~/.ssh/authorized_keys

Using CVS on the Axpo CentOS Internal System

  1. If the tunneling mentioned in the section above is up, start an other tunneling from the internal to the external server to use cvs:
    [root@SABDN471 ~]# ssh -L2401:localhost:2401 sabdn470
    ...
    [linthal@SABDN471 ~]$ cd www/shtml/beta1
    [linthal@SABDN471 beta1]$ cvs -q up app lib
  2. The same configuration is set on the internal server as on the external one (.cvsrc, /etc/ssh/ssh_config, ssh key pair)

Changes to the default httpd.conf

Note that ssl authentication is made by the Axpo, we don't get htpps but http connection. However - I don't understand (TN) - if NameVirtualHost *:443 is commented out virtual hosting doesn't work. Thw following settings are changed:

  1. Set explicit server name
  2. Disable default character settings to allow using of meta tag charset:

  3. Set virtual hosting
  4. All changes:
    [root@sabdn470 ~]# diff  /etc/httpd/conf/httpd.conf.091229-1738.orig /etc/httpd/conf/httpd.conf
    265a266
    > ServerName drawmgt.axpo.ch:80
    747c748
    < AddDefaultCharset UTF-8
    ---
    > #AddDefaultCharset UTF-8
    972c973,974
    < #NameVirtualHost *:80
    ---
    > NameVirtualHost *:80
    > NameVirtualHost *:443
    991a994,1013
    >
    > <VirtualHost *:80>
    >         DocumentRoot /home/linthal/www/shtml
    >         ServerName drawmgt-pswlimmern.axpo.ch
    >       ServerAlias drawmgt-pswlimmern
    >       ServerAlias drawmgt-pswlimmern-localhost
    >         Options       -Indexes
    > </VirtualHost>
    >
    > #<VirtualHost *:443>
    > #        SSLEngine on
    > #        SSLCertificateFile /etc/pki/tls/certs/ca.crt
    > #        SSLCertificateKeyFile /etc/pki/tls/private/ca.key
    > #        <Directory /home/linthal/www/shtml>
    > #        AllowOverride All
    > #        </Directory>
    > #        DocumentRoot /home/linthal/www/shtml
    > #        ServerName drawmgt-pswlimmern.axpo.ch
    > #        Options       -Indexes
    > #</VirtualHost>

Installing DrawMGT on drawmgt-pswlimmern.axpo.ch

  1. To make the CVS checkout easy, install a modified version of app/lib/etc/checkout.pl from CVS V12.0:
    • # On honir as root
      cd /home/met/www/html/prod/app/etc
      scp -i ~/axpo-ssh/id_rsa checkout.pl root@axpo:/home/linthal/bin
      
      # On drawmgt-pswlimmern.axpo.ch as root
      cd /home/linthal/bin
      chown linthal:linthal checkout.pl
    • Modify checkout.pl to use a different cvsroot:
    • # Change the following line:
      my $CVS_ROOT = $USER . '@lu.softxs.ch:/home/cvsroot';
      # To:
      my $CVS_ROOT = $USER . '@localhost:/home/cvsroot';
  2. Checkout and setup drawmgt-pswlimmern.axpo.ch-prod
    • # As user linthal
      cd ~/bin
      ./checkout.pl \
        -v -q \
        -r 113 \
        -u linthal \
        -d /home/linthal/www/shtml \
        -s prod \
        -w apache \
        linthal \
        drawmgt-pswlimmern.axpo.ch-prod
      
      # As root:
      cd /home/linthal/www/shtml/prod/app/install
      ./setup.sh linthal drawmgt-pswlimmern.axpo.ch-prod apache linthal
  3. Checkout and setup drawmgt-pswlimmern.axpo.ch-prod (as user linthal)
    • # As user linthal
      cd ~/bin
      ./checkout.pl \
        -v -q \
        -r 113 \
        -u linthal \
        -d /home/linthal/www/shtml \
        -s test \
        -w apache \
        linthal \
        drawmgt-pswlimmern.axpo.ch-test
      
      # As root:
      cd /home/linthal/www/shtml/test/app/install
      ./setup.sh linthal drawmgt-pswlimmern.axpo.ch-test apache linthal

Switchover lu.softxs.ch --> drawmgt.pswlimmern.axpo.ch Servers

Status of 2009-01-10 17:30

Implementation Steps

Note: See previous sectino for CVS installation and setup of prod & test instances.

  1. On lu.softxs.ch Done

    • Enable redirect pages
            cd /home/linthal/www/html/beta
            mv index-DISABLED.html index.html
            mv index.php index-DISABLED.php
      
            cd /home/linthal/www/html/delta
            mv index-DISABLED.html index.html
            mv index.php index-DISABLED.php
    • Backup delta database.
    • Copy delta database backup to Axpo server.
    • Rsync delta system files from lu.softxs.ch server to Axpo server.
  2. Desired end state lu.softxs.ch server

    • Attempts to access the beta/delta systems on lu.softxs.ch are automatically redirected to the Axpo server, to the main page. (the redirect pages are configured for this).
  3. On Axpo server: drawmgt-pswlimmern.axpo.ch

    • Backup database
    • Setup and install new 'prod' instance (done)

      • cfg/..../InstanceSettings.php exists & is checked-into CVS, but needs checking/testing

      • Note the email test mode is set to false

    • Setup and install new 'test' instance (done)

      • cfg/..../InstanceSettings.php exists & is checked-into CVS, but needs checking/testing

      • Note the email test mode is set to true

    • Update main page and links to prod and test systems (add note to say that delta and beta systems Sind nicht mehr aktuell (or something like that).

    • Setup event daemon jobs for prod and test systems
    • Setup copy prod --> test job

  4. Desired end state: Axpo server

    • Initial page http://drawmgt-pswlimmern.axpo.ch has new links to the prod and test systems, and warnings that the beta and delta systems are not to be used.

    • Data from the lu.softxs.ch delta system loaded in the prod and test systems on the Axpo server.

Deleting Users

  1. Check first, if a User is used anywhere in the system
    $ mysql -uroot -psqladmin linthal113prod
    set @u='userId';  -- Use the actual userId
    select count(*) from Revisions where checkResponsibleId = @u;
    select count(*) from Revisions where startResponsibleId = @u;
    select count(*) from Revisions where designResponsibleId = @u;
    select count(*) from Revisions where drafterResponsibleId = @u;
    select count(*) from Revisions where approver1Id = @u;
    select count(*) from Revisions where approver2Id = @u;
    select count(*) from Revisions where approver3Id = @u;
    select count(*) from Revisions where approver4Id = @u;
    select count(*) from Revisions where releaserId = @u;
    select count(*) from Revisions where requesterUserId = @u;
    select count(*) from Revisions where receiverId = @u;
    select count(*) from Submittals where submitterId = @u;
    select count(*) from Comments where issuerUserId = @u;
    select count(*) from Comments where assignedToUserId = @u;
    select count(*) from Comments where delegatedToUserId = @u;
    select count(*) from SubmittalRecipients where userId = @u;

    If any of the select above gives other than 0, than the appropriate Users and UserRoles record can not be deleted. Set the user locked instead.

Changing UserRoles

Axpo follows users and user roles in excel table. The user roles are stored in the Linthal-DrawMGT system as document Prj-E-6-01-610-221-00_0014. The procedure described here allows you reload user roles in Axpo server.

  1. Create a new database for testing the changes and load tables ContractRef, Groups, Roles, Users and UserRoles from the production system

    # export tables Users and UserRoles from the internal production system
    [linthal@sabdn470 ~]$ mysqldump --triggers=false -uroot -psqladmin linthal115prod1 ContractRef Companies Groups Roles Users UserRoles > /home/backup/linthal115prod1_UserRoles_20100430-1550.sql
    #
    # copy the export to the development machine
    $ scp .... /tmp
    #
    # load the export into a new database
    $ mysql -uroot -psqladmin
    set names utf8;
    create database linthal115_users;
    use linthal115_users;
    source /tmp/linthal115prod1_UserRoles_20100430-1550.sql;
    quit;
  2. Export Data from Excel Sheet
    • UserRoles

      • Export the sheet 'UserRoles...' as TAB separated CSV file with charset UTF-8 to cfg/linthal/site/data/L2015-DrawMGT-Rollen.txt

    • Note that Excel (on the Mac at least) is unable to save CSV in UTF-8 format. Use OpenOffice instead. Select File->Save As and select the Edit filter settings checkbox. Then before you save the file a dialog appears where you can select the field and text delimiters. Select the following:

      • Field delimiter: {tab}

      • Text delimiter: (empty, go in the field, press BS and TAB to clear it)

  3. Create SQL files to update/create UserRoles records

    $ cd cfg/linthal/site/data
    # Create UserRoles.sql
    $ ../../../../app/etc/genRoles.pl -f 3 -l -uroot -psqladmin -dlinthal115_users L2015-DrawMGT-Rollen.txt > UserRoles.sql
  4. Check in the changes
    cvs ci -m'Updating User Roles Axpo according to "Prj-E-6-01-610-221-00_0014-v09"' \
    L2015-DrawMGT-Rollen.txt UserRoles.sql
  5. Run the SQL file on the Axpo internal system

    The script UpdateUserRoles.sql loads the new UserRoles.sql into a temporary database and deletes, inserts records into the production database optimizing the number of affected records to minimize mirroring work. CAUTION: in the script UpdateUserRoles.sql is the database name linthal115prod1 hard coded.

    [linthal@sabdn470 ~]$ cd www/shtml/prod/cfg/linthal/site/data/
    [linthal@sabdn470 data]$ cvs -q up
    [linthal@sabdn470 data]$ mysql -uroot -psqladmin
    mysql> source UpdateUserRoles.sql

NokConfiguration (last edited 2012-01-31 15:51:02 by sleightholm)

Copyright 2008-2014, SoftXS GmbH, Switzerland