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