Saturday, May 29, 2021

Disaster Recovery Planning and Business Continuity Planning | Webinar | ...


Skynetclouds is a managed multi cloud service provider having experienced cloud professionals from AWS, Azure, Google Cloud and Oracle Cloud. 

As per ISO 27001, Information Security Management Systems – Disaster Recovery and BCP are one of the main topics. In this digital era, we should be well equipped to face any disaster and as business owners, we should focus more on the mitigation plans. As you know we can’t control the occurrence of this disaster, but we can plan and implement a good recovery plan.

Different types of disasters are:

Operational failures
  • Power failures
  • IT hardware failures
  • N/W failures
  • Software failures

Natural Disasters
  • Flood
  • Storm
  • Earthquakes

Human-caused Events
  • Human error
  • Malicious insider
  • Unknowing errors
RTO = Recovery Time Objective (How quickly can my application be running again?)
RPO = Recovery Point Objective (How many transactions can I stand to lose?)

  • Managed Cloud Service Provider
  • Cloud Architects who are certified in Azure, AWS, GCP & Oracle
  • 24/7 * 365 Availability
  • DevOps as Service
  • Focused on Security, Cost Deduction and Automation



Tuesday, May 11, 2021

authentication plugin caching_sha2_password is not supported

 Getting the below error message when you connect to mysql8

authentication plugin caching_sha2_password is not supported

In MySQL 8.0, caching_sha2_password is the default authentication plugin rather than mysql_native_password.

Login to Mysql as root

Check whether the mysql user plugin is mysql_native_password or caching_sha2_password

select Host,User,plugin from mysql.user;

If its caching_sha2_password, change to mysql_native_password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '{Password}';


Try now!

Saturday, April 24, 2021

How to extend ebs volume in aws

 How to extend ebs volume in aws

I need to add an additional 20GB to /db2inst1. I know this is a EBS volume.

/dev/xvdh       7.8G  7.4G     0 100% /db2inst1

1. Login to AWS --> EBS
2. Identify the volume from EBS page
3. Select and modify
4. Give 20GB
5. Login to server
6. resize2fs /dev/xvdh
7. df -h

Now you can the space got extended

/dev/xvdh        20G  7.4G   12G  40% /db2inst1

Thursday, April 15, 2021

Attaching Block Volume Storage in Oracle Cloud Infrastructure Instance

 Attaching Block Volume Storage in Oracle Cloud Infrastructure Instance

1. Login to your OCI console, search for block volume or from the left hamburger menu, select "Storage" then "Block Volume" then "Create Block Volume"


2. Input your block volume name, compartment, AD, block volume size etc.


3. Once it is created, go to your instance and from left side you can see "Attach Block Volumes"  Then you need to make sure the attach type, compartment.



4. At the right of the side, you can see "iSCSI Commands & Information", click on that, you will see the commands to attach the volume to the instance.


5. Login to the linux instance. Issue the above commands. You can see a successful message.

6. Now to identify attach volume or device use unix command lsblk. This command helps you to identify the device for me its /dev/sbd

7. Format the disk using unix command fdisk and make file system using unix commnd  mkfs as you want in this case i am gong to make it as ext4 command is mkfs.ext4 /dev/sbb.

8. Create a folder directory for the mount mkdir /data

9. For permanent mounting you need to add an entry in /etc/fstab

/dev/sbd1 /data ext4 defaults,noatime,_netdev 0 2

10. Now we are going to mount. mount /dev/sdb1 /data

That's it. You can verify it using the command df -h

Thursday, April 8, 2021

Office365 as SMTP

 How to configure Office365 as SMTP

You need to note that the from address and the authentication user should be same.

Port to be used is 25 (not 587)

sendmail sending email slow

 sendmail sending email slow

I have a linux box, which I configured sendmail and it is working fine. But the sending email is slow.

While checking the /var/log/maillogs I saw the following 

My unqualified host name (hostname) unknown; sleeping for retry

Sendmail is expecting a FQDN to start cleanly.

You need to set the hostname like <your_hostname>.localdomain and update /etc/hosts.

/etc/hosts

127.0.0.1   your_hostname.localdomain your_hostname localhost





Wednesday, March 31, 2021

Application Express Limitations in APEX Service

  • Application authentication schemes not supported : LDAP, SSO, HTTP Header variable etc.
  • OCI Web Application Firewall (WAF) service is not natively supported.
  • Deployment of customer managed Oracle REST Data Services is not supported.
  • Custom domain names are not natively supported.
  • Oracle APEX runtime environment is not supported.
  • Option to make a Service Request in Workspace Administration is DISABLED.
  • Option to set SMTP parameters by using the APEX_INSTANCE_ADMIN package only.
  • Limited support of procedures and functions for APEX_INSTANCE_ADMIN
  • Disabled REST Administration interface, Workspace Purge Settings etc.

How to install JDK on linux

 Login to the server

wget https://files-cdn.liferay.com/mirrors/download.oracle.com/otn-pub/java/jdk/8u121-b13/jdk-8u121-linux-x64.rpm

rpm -ivh jdk-8u121-linux-x64.rpm

java -version

vi /etc/profile.d/java.sh

#!/bin/bash

JAVA_HOME=/usr/java/jdk1.8.0_121/

PATH=$JAVA_HOME/bin:$PATH

export PATH JAVA_HOME

export CLASSPATH=.


chmod +x /etc/profile.d/java.sh

source /etc/profile.d/java.sh

java -version

Wednesday, March 24, 2021

How to check which users logged and its time in linux server

 Someone in the server deleted a file. I need to know which user logged in also I need the IP


cat /var/log/secure | grep Accepted | awk '{print $1,$2,$3,$6,$11}'

Mar 22 03:52:19 Accepted 157.49.207.225

Mar 22 04:23:55 Accepted 202.83.59.155

Friday, March 12, 2021

Auto redirection of urls from http to https

Normally when a site is enabled with SSL, we need to auto redirect urls from http to https

Go to your web site's default document root folder.

Open your .httaccess file or create one ( I assume mod redirect is enabled in your web server)

Paste the below code.

RewriteEngine On 
RewriteCond %{HTTPS}  !=on 
RewriteRule ^/?(.*) https://%{SERVER_NAME}/$1 [R,L] 

Test your domain without http, it will automatically redirect to https

Wednesday, February 10, 2021

The server requested authentication method unknown to the client

 Mysql Version : 8.0.23

PHP version : 5.6.40

CentOS Linux release 7.9.2009 (Core)

Take a backup of /etc/my.cnf

[mysqld]

default_authentication_plugin= mysql_native_password

Restart Mysql service

systemctl restart mysqld

Login to Mysql root prompt

alter user 'user'@'localhost' identified with mysql_native_password by 'your_password';

After this, if you get an error "If it is FULL_GROUP_GROUP_BY exist, then we need to disable it:"

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Failed to connect to MySQL: Server sent charset unknown to the client. Please, report to the developers

 Mysql Version : 8.0.23

PHP version : 5.6.40

CentOS Linux release 7.9.2009 (Core)


Take a backup of /etc/my.cnf

[mysqld]
character-set-server=utf8

Restart Mysql service

systemctl restart mysqld