How to log all sudo commands

11. January 2017 RHEL 0
How to log all sudo commands
Sometimes it’s necessary to log all the sudo commands run in your environment. Let”s see how to achieve this. Edit the sudoers file by running visudo visudo Add the below line to the Defaults section Defaults logfile=/var/log/sudo   Now all the commands from a sudo user will be logged in /var/log/sudo file. [root@awsadminz ~]# cat /var/log/sudo Jan 11 ...

How to clear Memcache and redis without restarting the service

30. November 2016 SysAdmin 0
How to clear Memcache and redis without restarting the service
How to clear memcache and redis without restarting service. Clear Memcache telnet 172.25.16.191 11211 Trying 172.25.16.191... Connected to 172.25.16.191. Escape character is '^]'. flush_all OK quit Connection to localhost closed by foreign host. Clear Redis Cache [root@memcache ~]# redis-cli  -h 172.25.16.191 172.25.16.191:6379 > flushall OK Jobin Josephnixhive.com/

Last_SQL_Error: Error Table is marked as crashed and should be repaired

30. September 2016 MySQL, SysAdmin 0
Last_SQL_Error: Error Table is marked as crashed and should be repaired
Today we had an issue with our Master-Master replication. Master2 was throwing the below error and the replication was stopped Last_SQL_Errno: 145 Last_SQL_Error: Error 'Table './exampledb/exampletable' is marked as crashed and should be repaired' on query. Default database: 'livewbmy_db'. Query: 'INSERT INTO `exampletable` (`challenge`, `response`, `hashkey`, `expiration`) VALUES ('XBUL', 'xbul', 'a9e0f4e3dxxxxxccccccc0c8f8f1', '2016-09-29 21:10:03')' Since its ...

Got fatal error 1236 from master – MySQL – Broken Master – Master Replication

29. September 2016 MySQL, SysAdmin 0
Got fatal error 1236 from master – MySQL – Broken Master – Master Replication
Scenario You have a MySQL Master-Master replication setup, Lets say Master1 (LIVE) and Master2 (DR Warm Standby) Master2 server has been restarted for some reason. Now Master1 LIVE (the slave of DR) slave status is stopped with the below error. Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not ...

How to install native BASH on Windows 10 – Not a VM ;)

18. September 2016 SysAdmin 0
How to install native BASH on Windows 10 – Not a VM ;)
Native Bash is available now in Windows 10 as Windows 10’s Anniversary Update . Lets see how we can install it. Enable Developer mode in Windows 10 from settings >> Home, or search for Developer Mode from the Windows Menu. Now enable Windows Subsystem For Linux Users from the Turn Windows features on or off menu. Once the installation ...

httpd.service: main process exited kill: cannot find process “”

15. September 2016 CentOS, RHEL, SysAdmin 1
httpd.service: main process exited kill: cannot find process “”
Today apache was stuck with the below error and it was not starting at all. Sep 15 06:18:24 server.example.com systemd[1]: Starting The Apache HTTP Server... Sep 15 06:18:24 server.example.com httpd[15037]: [Thu Sep 15 06:18:24.591424 2016] [so:warn] [pid 15037] AH01574: module ruid2_module is alread...skipping Sep 15 06:18:33 server.example.com systemd[1]: httpd.service: main process exited, code=exited, status=1/FAILURE Sep 15 06:18:33 ...

How to set custom DNS on CentOS7 AWS

30. August 2016 AWS, CentOS 0
How to set custom DNS on CentOS7 AWS
There may be scenarios, when you need to use a custom DNS server for your Instances. So if you are deploying your application on an CentOS 7 on AWS, lets see how can set a custom DNS server such as 8.8.8.8 and 8.8.4.4 Edit the following file, vim /etc/sysconfig/network-scripts/ifcfg-eth0 change the line PEERDNS="yes" to PEERDNS="no" Now, Edit the ...

fatal: parameter inet_interfaces: no local interface found for ::1

11. June 2016 RHEL 13
fatal: parameter inet_interfaces: no local interface found for ::1
Issue You are note able to restart / start postfix and getting the below error. fatal: parameter inet_interfaces: no local interface found for ::1 Solution Edit the file /etc/postfix/main.cf vim /etc/postfix/main.cf search for the line inet_interfaces = all And change it to: inet_interfaces = 127.0.0.1, 10.10.11.12 10.10.11.12 is your local IP address :wq! Save and ...