Create IBM Connections DBs
Here we will prepare DB and populate profiles from LDAP
You will need:
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
 
- On database server save these package
 - Create folder: [root@icdb ~]# cd /opt/install/
 - [root@icdb install]# mkdir LCWizards
 - [root@icdb install]# cd /opt/install/LCWizards
 - [root@icdb LCWizards ]# tar xvf IBM_Connection301_Wzd_zLinux_CZVR1ML.tar
 - Log-in as db2inst1 (in to graphic xserver)
 - [root@db2inst1 ~]# cd /opt/install/LCWizards/Wizards/
 - [root@db2inst1 ~]# ./dbWizard30.sh
 - Wizard is open click NEXT > select Create click NEXT >
 - in Default installation location: /opt/ibm/db2/V9.7
 - in database instance: db2inst1 > NEXT
 - Select all > NEXT > CREATE > EXECUTE
 - 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.
 - We will populate Lotus Connections Profiles from the Domino LDAP directory in next steps:
 - As root user, go to
 - [root@icdb ~]# /opt/install/LCWizards/Wizards
 - [root@icdb Wizards]#./populationWizard.sh
 - Profile population wizard is launched
 - Click NEXT
 - Select DB2 Universal Database(TM)
 - In Profiles database properties set
 - Host name: icdb.ys.cz - it is hostname of your db server
 - Port: 50000
 - Database name: PEOPLEDB
 - JDBC driver library path: /home/db2inst1/sqllib/java
 - User ID: db2inst1
 - Password: <db2inst1 password>
 - Click NEXT
 - In LDAP server connection
 - LDAP server name: <your ldap hostname>
 - LDAP server port: 389
 - Do not check Use SSL communication if it is not configured on LDAP
 - Click NEXT
 - LDAP autentication propertise
 - Bind distinguished name (DN): bind user  / do not put name in format 
CN=<name>,O=<org>,C=<country> - Enter bind password
 - Click NEXT
 - In Base distinguished name and filter for search enter:
 - LDAP user search base: c<yourcompany>,o=cz
 - LDAP user search base: (&(uid=*)(objectclass=inetOrgPerson))
 - Click NEXT
 - In Profile database mapping leave all in default, or change mapping as you need. Click NEXT
 - In Optional database tasks leave all in default, or change as you need.
 - select Yes to run the task
 - Click NEXT
 - Click CONFIGURE
 - 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
 
- Start dmgr and node agent
 - login to application server as root and
 - [root@ic ~]# /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/startManager.sh
 - [root@ic ~]# /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startNode.sh
 - 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.
 - Copy JDBC drivers from db server to application server
 - [root@ic ~]# cd /opt/IBM/
 - [root@ic ~]# mkdir JDBC
 - [root@ic IBM]# cd JDBC/
 - [root@ic JDBC]# scp -r root@192.168.50.128:/home/db2inst1/sqllib/java/* .
 - Start Connection installer
 - On application server unpack installer package
 - [root@ic CONN]# tar xvf IBM_Connections301_LinAIX_CZVQ0ML.tar
 - [root@ic CONN]# cd Lotus_Connections_Install/
 - [root@ic Lotus_Connections_Install]# ./launchpad.sh
 - In launchpad click Install Lotus Connection 3.0.1
 - Click Launch the Lotus Connection 3.0.1 install wizard
 - Ensure that Lotus Connection and Installation Manager are selected
 - Click NEXT and click agree license > NEXT
 - Leave Install Packages in default (/opt/IBM/...) click NEXT > click NEXT
 - Install all Features click NEXT
 - 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
 - Topology Configuration
 - Select SmallDeployment - for production it is recommended to use Medium or Large Deployment
 - Write in to select list Cluster Name: LCCluster
 - In Node selection Select your node
 - Click NEXT
 - Database Configuration
 - Enter Database server hostname: <your db host name>
 - Port: 50000
 - Specify JDBC Driver to folder from previous step 4 (/opt/IBM/JDBC)
 - Specify users and passwords for all DBs (we used db2inst1 user)
 - Click Validate > in Validation successful dialog Click OK
 - Click NEXT
 - Content Store Configuration
 - Leave in defaults and click Validate
 - Notification configurations
 - We will used our Domino as SMTP server too. Configure your SMTP and click NEXT
 - See summary and click INSTALL
 - You can watch detailed log: /opt/IBM/LotusConnections/logs/
 - After about 30-60 min it should finished vith success and click FINISH
 - Go to http://ic.ys.cz:9060/admin
 - Navigate to System administration > Nodes > check icNode01 and click Full Resynchronize
 - to watch status
 - [root@ic bin]# tail -f /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/nodeagent/SystemOut.log
 - Restart DMGR
 - [root@ic bin]# /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/stopNode.sh
 - [root@ic bin]# /opt/IBM/WebSphere/AppServer/bin/stopManager.sh
 - [root@ic bin]# /opt/IBM/WebSphere/AppServer/bin/startManager.sh
 - [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