Wednesday, 26 August 2020

Sametime 11 with MongoDB chat history query samples

Sometimes I meet end users who complain about missing/lost information in Sametime chat history. If you use Sametime with MongoDB you can run some useful queries to check/find data. I used the next queries in my test environment. Please consider character sets (iso-XXXX). To run these queries you do not need Sametime server. You need MongoDB only. MongoDB server/service must run. All components run on one Linux machine in my test environment and I did everything on that Linux machine.

*Considerations:

- You can use Mongo client and server on different machine. That case you have to add server connection parameters to the command on your client machine.

- There is no strict security in my test environment. In your environment, you may need username and password. Please remember MongoDB installation (Sametime user and password).

This query creates a json file and export all chats.

/usr/bin/mongoexport --db chatlogging --collection CONVOMAP --out /opt/mongobackup/chatlogging_CONVOMAP_26_August.json

You can create a CSV file, too to use it in MS Excel, Notepad++, etc. CSV export always requires --fields option! In this query I selected uid,name,with,msg fields.

/usr/bin/mongoexport --db chatlogging --collection CONVOMAP --fields uid,name,with,msg --type csv --out /opt/mongobackup/chatlogging_CONVOMAP_26_August.csv

To collect information for a specific user, you can create filters. In this query I am the chat initiator.

/usr/bin/mongoexport --db chatlogging --collection CONVOMAP --query "{ 'name' : 'CN=Andras Gabor Horvath/O=andrasst'}"

In this query I was invited to chat:

/usr/bin/mongoexport --db chatlogging --collection CONVOMAP --query "{ 'with' : 'CN=Andras Gabor Horvath/O=andrasst'}"

In this query I invited Daniel Szalai to chat with me:

/usr/bin/mongoexport --db chatlogging --collection CONVOMAP --query "{ 'name' : 'CN=Andras Gabor Horvath/O=andrasst' , 'with' : 'CN=Daniel Szalai/O=andrasst' }"

*Comments:

you can use name or uid. Some cases uid is better.

if you have character conversion issues (you can not read content) you can use character conversion tools. Examples:

file --mime-encoding chatlogging_CONVOMAP_26_August.csv

iconv -f utf-8 -t iso-8859-1 chatlogging_CONVOMAP_26_August.csv > chatlogging_CONVOMAP_26_August_ISO_8859-1.csv

iconv -f utf-8 -t iso-8859-2 chatlogging_CONVOMAP_26_August.csv > chatlogging_CONVOMAP_26_August_ISO_8859-2.csv

Thursday, 2 July 2020

HCL Sametime 11 including Mongo DB

The main goal of this document is to show HCL Sametime 11 installation on RHEL7 for test purposes, including MONGO DB installation and Linux configuration.

Operating system: redhat-release-server-7.7-10.el7.x86_64

Kernel: 3.10.0-1062.el7.x86_64

CPU: 4 Core

Memory: 6 Gbyte

Disc: 35 Gbyte

Host: st11.andras.demo

IP: 192.168.0.168

User: root

Important: If you see this “–” (one long), please replace it with “--" (two short)

Preparations

Internet access is required. Without it you must download and copy all required packages manually.

RHEL7 Keymap

Because I use Hungarian keyboard, I change keymap to Hungarian. *Comment: You can list available keymaps: localectl list-keymaps

localectl set-keymap hu

RHEL7 Firewall

Required ports to setup and access HCL Domino server:

· 80 HTTP

· 443 HTTPS

· 1352 HCL Notes client

· 8585 HCL Domino Server Remote Setup

On my RHEL7 server 80,443 and 1352 port are part of basic settings. I add 8585.

vim /etc/services

Check and modify as required

http 80/tcp #WorldWideWeb HTTP

http 80/udp #HyperTextTransferProtocol

https 443/tcp #WorldWideWeb HTTPS over TLS/SSL

https 443/udp #HyperTextTransferProtocol over TLS/SSL

lotusnote 1352/tcp #Lotus Notes or HCL Notes

lotusnote 1352/udp #Lotus Notes or HCL Notes

lotusnote 8585/tcp #Lotus Domino or HCL Domino Remote Setup

lotusnote 8585/udp #Lotus Domino or HCL Domino Remote Setup

Save and close file

Because I added only 8585, I need only these commands below:

firewall-cmd –zone=public –add-port=8585/tcp –permanent

firewall-cmd –zone=public –add-port=8585/udp –permanent

firewall-cmd --reload

RHEL7 hosts file

Because I do not use DHCP/DNS servers I add fully qualified host name and IP to hosts file. *Comment: I must add fully qualified host name and IP to host file on my test client, too.

vim /etc/hosts

192.168.0.168 st11.andras.demo st11

*Comment: If you use DNS/DHCP you do not need this configuration.

*Comment: Change it as you want. This is a demo environment.

Save and close. Test it with ping.

ping st11.andras.demo

*Comment: Do not continue if it does not work with the fully qualified host name and correct IP address!

RHEL7 limits

HCL Domino server requires changes in limits.conf to run properly. Because I use root and notes11 users I will change it for everyone.

vim /etc/security/limits.conf

* hard nofile 65535

* soft nofile 65535

Save and close the file.

I create folder for installation and other packages.

mkdir -p /opt/install

RHEL7 .bash_profile

I change history settings. It is very useful for learning but it is not mandatory.

cd $HOME

vim ./.bash_profile

HISTFILESIZE=10000

HISTSIZE=1000

HISTCONTROL=ignorespace:ignoredumps

export HISTFILESIZE

export HISTSIZE

export HISTCONTROL

Save and close the file.

Mongo DB

> cd /etc/yum.repos.d

vim mongodb-org-3.6.repo

[mongodb-org-3.6]

name=MongoDB Repository

baseurl=https://repo.mongodb.org/yum/redhat/$releasever/mongodb-org/3.6/x86_64/

gpgcheck=1

enabled=1

gpgkey=https://www.mongodb.org/static/pgp/server-3.6.asc

Save and close file.

yum repolist enabled

yum -y install mongodb-org

ls -hal /var/log/mongodb

ls -hal /var/lib/mongo

RHEL7 aliases

I create some useful aliases, but they are not mandatory.

cd $HOME

vim ./.bash_profile

alias mongostart=’service mongod start’

alias mongostop=’service mongod stop’

alias mongostatus=’systemctl status mongod’

Save and close the file.

source ./.bash_profile

The environment is ready to install HCL Sametime 11 Community server.

HCL Sametime 11 Community Server installation

You can see some “not found” messages in the list. For example:

libwinux.so => not found

Create link for all missing files as the example here:

ln -s /opt/hcl/domino/notes/latest/linux/libwinux.so /usr/lib64/libwinux.so

Stop Domino server

Run check again:

ldd /opt/hcl/domino/notes/latest/linux/libstchatloggingmongodb.so

All files must be available. Don’t start Domino server if you have “not found” entry in the result!

Useful links

https://help.hcltechsw.com/sametime/11.0.0/admin/installing_domino_linux.html

https://help.hcltechsw.com/sametime/11.0.0/admin/configuring_domino_for_sametime.html

https://help.hcltechsw.com/sametime/11.0.0/admin/installing_sametime_community_linux.html

https://help.hcltechsw.com/sametime/11.0.0/admin/configuring_chat_logging_mongodb.html

https://www.mindwatering.com/SupportRef.nsf/All/8c2e814de98ab6f2852584dd007475da

https://blog.darrenduke.net/darren/ddbz.nsf

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&ved=2ahUKEwi_k8T6-rDqAhVMecAKHYbKDI4QFjABegQIAhAB&url=https%3A%2F%2Fhclpnpsupport.hcltech.com%2Fsys_attachment.do%3Fsys_id%3D87d6ab301b62c41c83cb86e9cd4bcbc9&usg=AOvVaw0TuaOQC24NzoG747LF7qwE

HCL formerly IBM formerly Lotus products - practical experience

Hasznos linkek

Wednesday, 26 August 2020

Sametime 11 with MongoDB chat history query samples

Thursday, 2 July 2020

HCL Sametime 11 including Mongo DB

Preparations

RHEL7 Keymap

RHEL7 Firewall

RHEL7 hosts file

RHEL7 limits

RHEL7 .bash_profile

Mongo DB

RHEL7 aliases

HCL Sametime 11 Community Server installation

Installing Domino on Linux

Configuring Domino for Sametime

Installing Sametime Community on Linux

Configuring Sametime Community Chat Logging with MongoDB

Manage library issue

Useful links

LinkedIn

About Me

Linkjeim