Thursday, 1 November 2018

How to change timezone?

›
-> Determine your timezone # cd /usr/share/zoneinfo # tzselect e.g. Europe/Istanbul -> Remove current localtime soft link # rm ...
Wednesday, 31 October 2018

How to connect into local VM via SSH?

›
* Set a new Port Forwarding Rule in Network Settings Step 1: Settings -> Network -> Adapter 1 -> Advanced -> Adapter Type -...

WSREP "Failed to open channel" solution

›
Error ERROR WSREP "Failed to open channel 'my_mariadb_cluster'" Detailed Error WSREP: gcs/src/gcs.cpp:gcs_open():1458:...
Monday, 8 October 2018

How to find/follow postgresql server logs?

›
-> Check log level from config file # cat /var/lib/pgsql/data/postgresql.conf e.g. log_min_messages= 'ERROR' (default value) ...
Thursday, 4 October 2018

How to setup/configure/use mailx for Office365 account?

›
-> Update the OS # yum -y update or (y -> yes) # yum update -> Install mailx # yum install -y mailx -> Define soft link ...

How to solve "restarting/pending pod repeatedly" problem?

›
-> Check the pods status e.g. # kubectl get pods --all-namespaces NAMESPACE     NAME                            READY     STATUS kube...
Tuesday, 2 October 2018

How to enable Hyper-V in Windows 10?

›
Press Windows key -> Type "Turn Windows features on or off" then click it -> Select " Hyper-V" check box then c...
Tuesday, 18 September 2018

How to install/configure/enable NTP service?

›
-> Install ntp service # yum install ntp -> Once NTP server  pool zones are taking e.g. check from  https://www.pool.ntp.org/zone...
Thursday, 9 August 2018

How to check linux operating system info?

›
-> show kernel version and other info # uname -a -> show machine info #  hostnamectl -> show specific release version # rpm -...

How to check available yum packages?

›
e.g. install/update ansible by yum -> Go to repo path # cd /etc/yum.repos.d/ -> Add source paths into repo file to be able to ins...

How to install/configure/run ansible?

›
-> Set hostname # hostnamectl set-hostname ansible_host -> Add remote hosts into /etc/hosts file # vi /etc/hosts 10.10.10.2 remo...
Tuesday, 7 August 2018

usage of "run_once: true" option

›
If you want to run only once a specific task during all playbook execution, you may add " run_once: true " option into your task t...
Monday, 30 July 2018

How to know last login info on the system?

›
-> show all records $ last -> show all records page by page $ last | more -> show first 10 records $ last | head -> sho...
Wednesday, 18 July 2018

How to change service name?

›
e.g. current service name: postgresql.service desired service name: postgresql-9.1.service Run following commands to change service name...
Friday, 13 July 2018

How to solve remote connection error cause of iptables/firewalld service?

›
Case Machine A (192.168.1.2) wants to connect on Machine B (192.168.1.5) by database port. Action In Machine A; # su - postgres $ psql...

How to solve database module error?

›
Action # ansible-playbook -i myhosts example.yml -v Error TASK [example role : example task] ******************* fatal: [local]: FAILED...
Friday, 6 July 2018

How to prevent sleep mode on laptop when lid closes?

›
Press Window Key then type "Power Options" and click on it -> Click  "Choose what closing the lid does" -> Set ...
Friday, 29 June 2018

How to run a SQL query/statement in a task?

›
You are able to run a SQL query/statement with "echo" command by  shell module for the ansible task. # an example task for sql ...

benefit of "gather_facts: no" setting

›
If you do not need any facts for your variables, you can run your playbook more fast via gather_facts setting. For this, just add followi...
Friday, 18 May 2018

"database "example" is being accessed by other users" solution

›
Action postgres=# drop database example ; Error ERROR:  database " example " is being accessed by other users DETAIL:  There ...