Friday, April 6, 2012

IBM Connections 3.0.1 on RHEL - how to install - 8. Install Connections

Create IBM Connections DBs

Here we will prepare DB and populate profiles from LDAP
You will need:
  • CZVR1ML  IBM Connections 3.0.1 wizards for Linux x86
  • CZVQ0ML IBM Connections 3.0.1 for Linux x86
  • CZVQ0ML  IBM_Connections301_LinAIX_CZVQ0ML.tar
  1. On database server save these package
    1. Create folder: [root@icdb ~]# cd /opt/install/
    2. [root@icdb install]# mkdir LCWizards
    3. [root@icdb install]# cd /opt/install/LCWizards
    4. [root@icdb LCWizards ]# tar xvf IBM_Connection301_Wzd_zLinux_CZVR1ML.tar
  2. Log-in as db2inst1 (in to graphic xserver)
    1. [root@db2inst1 ~]# cd /opt/install/LCWizards/Wizards/
    2. [root@db2inst1 ~]# ./dbWizard30.sh
      1. Wizard is open click NEXT > select Create click NEXT
      2. in Default installation location: /opt/ibm/db2/V9.7
      3. in database instance: db2inst1 > NEXT
      4. Select all > NEXT > CREATE > EXECUTE
      5. All DBs should finished without no errors, is there any error, try to run the wizard again and select only DB where your error occurred. Note: In my installation I had some error during Bookmarks db creation, so I run wizard again only for Bookmarks DB with success.
  3. We will populate Lotus Connections Profiles from the Domino LDAP directory in next steps:
    1. As root user, go to 
    2. [root@icdb ~]# /opt/install/LCWizards/Wizards
    3. [root@icdb  Wizards]#./populationWizard.sh
    4. Profile population wizard is launched
      1. Click NEXT
      2. Select DB2 Universal Database(TM)
      3. In Profiles database properties set
        1. Host name: icdb.ys.cz  - it is hostname of your db server
        2. Port: 50000
        3. Database name: PEOPLEDB
        4. JDBC driver library path: /home/db2inst1/sqllib/java
        5. User ID: db2inst1
        6. Password: <db2inst1 password>
        7. Click NEXT
      4. In LDAP server connection
        1. LDAP server name: <your ldap hostname>
        2. LDAP server port: 389
        3. Do not check Use SSL communication if it is not configured on LDAP
        4. Click NEXT
      5. LDAP autentication propertise
        1. Bind distinguished name (DN): bind user  / do not put name in format CN=<name>,O=<org>,C=<country>
        2. Enter bind password
        3. Click NEXT
      6. In Base distinguished name and filter for search  enter:
        1. LDAP user search base: c<yourcompany>,o=cz
        2. LDAP user search base: (&(uid=*)(objectclass=inetOrgPerson))
        3. Click NEXT
      7. In Profile database mapping leave all in default, or change mapping as you need. Click NEXT
      8. In Optional database tasks  leave all in default, or change as you need.
        1. select Yes to run the task
        2. Click NEXT 
      9. Click CONFIGURE
      10. Summary could contain some errors ... to determinate what is going on see logs in /opt/install/LCWizards/Wizards/TDIPopulation/TDISOL/linux/logs/PopulateDBFromDNFile.log  or in ibmdi.log


In my case, I had 23 success, 116 duplicate records  (because I run it again - so db table already had users 116 entries), and there is  one failure record (after some investigation, I found there is a wrong value in my Domino filed named "Office Number"). 

I had this in my PopulateDBFromDNFile.log :

CLFRN0209W: WARNING: Validation failed for field officeName. Value is BlablalaSomethingLongerThan32Characters
WARNING: Validation failed for entry CN=Tomas Marny,ou=kotelna,o=ys,c=cz

The value is longer then created column for  officeName  in DB2 ... PROF_PHYSICAL_DELIVERY_OFFICE   is   VARCHAR   with Length 32

To show database description run as db2inst1 this command
  • [root@db2inst1 ~]# db2
  • db2 => connect to database peopledb
  • db2 => describe table empinst.employee

Install IBM Lotus Connections

You should have done: 
  • Installed and fixed DB2 server v9.7.0.2
  • Installed TDI
  • Installed WAS 7.0 with FP 19 and IHS and plugin too 
  • WAS is configured with LDAP (federated repositories)
  • Configured DB2 
  • You must have already populated LDAP profiles to DB2 database
  • It is good idea to make a backup of servers
  • Now we will install Lotus Connections
  1. Start dmgr and node agent
  2. login to application server as root and 
    1. [root@ic ~]# /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/startManager.sh 
    2. [root@ic ~]# /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startNode.sh
  3. Try to ping your db server ... if you are unable to resolve db server hostname, add in to /etc/hosts a new line <ip od db server> <FQND> <hostname> and save file. Try again.
  4. Copy JDBC drivers from db server to application server
    1. [root@ic ~]# cd /opt/IBM/
    2. [root@ic ~]# mkdir JDBC
    3. [root@ic IBM]# cd JDBC/
    4. [root@ic JDBC]# scp -r root@192.168.50.128:/home/db2inst1/sqllib/java/* .
  5. Start Connection installer
    1. On application server unpack installer package 
    2. [root@ic CONN]# tar xvf IBM_Connections301_LinAIX_CZVQ0ML.tar
    3. [root@ic CONN]# cd Lotus_Connections_Install/
    4. [root@ic Lotus_Connections_Install]# ./launchpad.sh
    5. In launchpad click Install Lotus Connection 3.0.1
      1. Click Launch the Lotus Connection 3.0.1 install wizard
      2. Ensure that Lotus Connection and  Installation Manager are selected
      3. Click NEXT and click agree license > NEXT
      4. Leave Install Packages in default (/opt/IBM/...) click NEXT > click NEXT
      5. Install all Features click NEXT
      6. Websphere applicatiopn server configuration 
        • Click Browse and  select /opt/IBM/WebSphere/AppServer/
        • Select Dmgr01
        • Enter hostname of application server 
        • Enter Administrator user ID: wasadmin
        • Enter Administrator password: <your password>
        • SOAP port number: 8879
        • Click Validate > in Validation successful dialog Click OK
        • Click NEXT
      7. Topology Configuration
        1. Select SmallDeployment - for production it is recommended to use Medium or Large Deployment
        2. Write in to select list Cluster Name: LCCluster
        3. In Node selection Select your node
        4. Click NEXT
      8. Database Configuration
        1. Enter Database server hostname: <your db host name>
        2. Port: 50000
        3. Specify JDBC Driver to folder from previous step 4 (/opt/IBM/JDBC)
        4. Specify users and  passwords for all DBs (we used db2inst1 user)
        5. Click Validate > in Validation successful dialog Click OK
        6. Click NEXT
      9. Content Store Configuration
        1. Leave in defaults and click Validate
      10. Notification configurations
        1. We will used our Domino as SMTP server too. Configure your SMTP and click NEXT
      11. See summary and click INSTALL
        1. You can watch detailed log:  /opt/IBM/LotusConnections/logs/
        2. After about 30-60 min it should finished vith success and click FINISH
  6. Go to  http://ic.ys.cz:9060/admin
    1. Navigate to  System administration > Nodes > check icNode01 and click Full Resynchronize
      1. to watch status  
      2. [root@ic bin]# tail -f /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/nodeagent/SystemOut.log
  7. Restart DMGR
    1. [root@ic bin]# /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/stopNode.sh
    2. [root@ic bin]# /opt/IBM/WebSphere/AppServer/bin/stopManager.sh
    3. [root@ic bin]# /opt/IBM/WebSphere/AppServer/bin/startManager.sh
    4. [root@ic bin]# /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startNode.sh
Next post is about important post-installation tasks

No comments:

Post a Comment