OpenVPN with CSF firewall rules

02. February 2017 CentOS, RHEL, SysAdmin 0
OpenVPN with CSF firewall rules
We are a big fan of OpenVPN when it comes to security. Many organizations have already switched to OpenVPN from PPTP etc. NixVPN is my favorite VPN software to host it on a standalone instance. But what if, if you already have a server protected with CSF firewall, and you want to install OpenVPN by ...

Disable SU access for sudo users

11. January 2017 AWS, CentOS, RHEL 0
Disable SU access for sudo users
Some times you need to disable sudo su – access on your environment so that the users will use sudo command always and they will not switch to any other users account unnecessarily Lets see how to do it Edit the /etc/suoders by running visudo visudo Add the below Command Alias Cmnd_Alias BLOCKSU = /bin/su ...

How to log all sudo commands

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

AWS Announces Immediate Availability of London Region

14. December 2016 Hot News 0
AWS Announces Immediate Availability of London Region
AWS has announced immediate availability of the new Europe (London) Region. The London Region joins Ireland and Frankfurt as AWS’ third European location, and provides the customer with a new option for hosting applications benefiting from infrastructure located in Europe. AWS is now operating sixteen regions worldwide, bringing the total number of AWS Availability Zones ...

Dropbox and iCloud compatibility issue

09. October 2016 Hot News 0
Dropbox and iCloud compatibility issue
Dropbox is sending out the below email to all Dropbox users with new MacOS Sierra. The mail is received by those who are using Dropbox folder in MacOS Documents. You have 2 options to avoid any dataloss. Disable iCloud Sync of Documents Folder Move your Dropbox folder from Documents to home directory. Sample email below   Hi Admin, ...

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 ...

Wait is Over – macOS Sierra is now available to download

20. September 2016 Hot News 0
Wait is Over – macOS Sierra is now available to download
The much awaited macOS Sierra is now available to Download. Lets see how we can upgrade as soon as possible. Steps Login to your OSX and open App Store. If App Store is not showing the update, just search for “macOS” in App Store. This will take you to the download page and click Get / Download to proceed ...