LogStory - Updated UI

Hi All, 

I am still working on new functionality of the logstory and still keen to hear feedbacks and input. 

For now I have updated the UI a little bit. Enjoy!!!

Feel free to contact me at davidtio at fosstech dot biz 

You can view it live in http://tableau.fosstech.biz/ServerConn2.html

Username: logstory

Password: A1r0plan3

Tableau + syslog-ng - Let's the story begins

In Linux world, syslog has been doing a great job logging most of system and user activities. However finding information from log is not easy at all. With so much data in the log files, it can be a daunting task to just understand the log. 

So with Tableau + syslog-ng, I decide to begin my journey of telling the story from log files. I called this project LogStory. 

This first visualization is capturing when the user login, logout and the duration spent in the session. It will also show when the session is active and refreshed every 3 second. 

You can view it live in http://tableau.fosstech.biz/ServerConn.html

Username: logstory

Password: A1r0plan3

What story should I tell next ? 

ldapsearch over ssl (ldaps) to Active Directory

In order for Linux to perform ldapsearch over ssl, you need to import Active Directory CA certificate.

On ActiveDirectory run the following command:
> certutil -ca.cert adca.der

Copy adca.der into the Linux server and convert the cert into Linux friendly cert
#  openssl x509 -inform DER -in adca.der -out adca.crt

Move the file into the default ca-trust directory
# cp adca.crt /etc/pki/ca-trust/source/anchors/
# update-ca-trust

You are ready to run ldapsearch over ssl to Active Directory

Assuming you ad server is adsvr.fosstech.biz for fosstech.biz domain, you can run ldapsearch as follow

# ldapsearch -x -W -H ldaps://adsvr.fosstech.biz  -D "administrator@fosstech.biz" -b "dc=fosstech,dc=biz" *

Cheers!!!

RHEL 7 AD Authentication

RHEL 7 authentication to AD is quite straight forward

If you are using minimal server setup, install the following package:

# yum install realmd sssd samba-common-tools

The following command is assuming you have AD with domain fosstech.biz setup.

# authconfig --enablesssd --update
# realm join fosstech.biz

Key in the administrator password and your system should be joined to the domain server.

Edit /etc/sssd/sssd.conf if you need to fine tune the configuration. I personally like to have the home directory with the following format: /home/username@domain.com, so I would update the following config

fallback_homedir = /home/%f

Restart sssd and have fun trying

Note: The above are tested on RHEL 7.8

Cheers

SupportConfig Analysis for SLES 12

SLES comes with tools to analyse supportconfig data called Support Config Analysis (SCA). This tool is not installed by default, but it is quite simple to install and run. 

All you need are the next few commands and you are on the way to see how you can tune your SLES.

# zypper in sca-server-report sca-patterns-sle12
# scatool -s

The report will be generated at /var/log/nts_XXX.html and is viewable via your favourite web browser.

It will look something like the following screenshot

There are links that you can follow to see the solutions details.

Happy Tuning!!!

COVID-19 Country Comparison