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

DROWN – Cross-protocol attack on TLS using SSLv2

DROWN – Cross-protocol attack on TLS using SSLv2
Its the time for another openssl update, Update your openssl and openssl-libs packages with below commands. RHEL / CentOS / OEL (rpm based) yum update openssl Ubuntu / Debian Based (apt based) apt-get update openssl Check your installation at https://drownattack.com For more details : https://access.redhat.com/security/vulnerabilities/drown Jobin Josephhttps://nixhive.com/