May 2022 – IT Maddy

May 27, 2022

ranganathan.madan Linux

Installing phpMyAdmin integrating with Apache on CentOS 7 / RHEL 7

For phpMyAdmin is available with EPEL. we can install with EPEL repository rpm, run given below rpm to download #rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm #yum install -y --enablerepo=remi-php73 phpmyadmin For phpMyAdmin, we…

May 26, 2022

ranganathan.madan Linux

Installing MariaDB on CentOS 7 / RHEL 7

Given below MariaDB repository to the system that MariaDB for CentOS 7 / RHEL 7. For CentOS 7 cat <> /etc/yum.repos.d/mariadb.reponame = MariaDBbaseurl = http://yum.mariadb.org/10.6/centos7-amd64gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDBgpgcheck=1EOF For RHEL 7 cat <>…

May 24, 2022

ranganathan.madan Linux

Installing JDK on Linux

We can install JDK with the binary file (.tar.gz). We need to make directory, where we need to install Java. For global access for all users, preferably in the directory…

May 24, 2022

ranganathan.madan Linux, Web Servers

SSL Keytool with OpenSSL Commands

Given below set of commands that allows to generate CSRs, Certificates, Private Keys. Generate a Certificate Signing Request (CSR) and new private key #openssl req -out maddy-CSR.csr -new -newkey rsa:2048…

May 24, 2022

ranganathan.madan Linux, Web Servers

Install SSL Certificates on Linux Server

To install the SSL Certificate on Linux servers, need to make sure we have completed with the following steps. We need to buy/renew SSL CertificateWe need to Generate CSR with…

May 23, 2022

ranganathan.madan Hadoop

Hadoop Yarn Application Master Exceeding – Physical Memory Limit Error

When we are running a Hadoop job, we may get given below errors in the ApplicationMaster’s physical memory limit. Application application_ failed 1 times due to AM Container for appattempt_…

May 23, 2022

ranganathan.madan Hadoop, Uncategorized

Downloading entire bucket from AWS S3

If we want to download entire bucket or folder inside the bucket with AWS CLI. To copy entire folder from S3 BucketUse cp command to download the folder inside bucket…

May 23, 2022

ranganathan.madan Hadoop

Hadoop Job History Server Memory Issues

when we are running Hadoop jobs and some times we get the org.apache.hadoop.ipc.RemoteException, which is as mentioned below. Caused by: org.apache.hadoop.ipc.RemoteException(java.lang.OutOfMemoryError): GC overhead limit exceededat org.apache.hadoop.ipc.Client.call(Client.java:1371)at org.apache.hadoop.ipc.Client.call(Client.java:1302)at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:242)at com.sun.proxy.$Proxy48.getJobReport(Unknown Source)at…

May 23, 2022

ranganathan.madan Uncategorized

Moving Hive table from one database to another

Now we are in currently inside a database named madan-hv2-table. To list the tables under the madan-hv2-table. 0: jdbc:hive2://itmaddy.in:2181,madan-hv1> show tables; +-----------+--+| tab_name |+-----------+--+| mdy_emp |+-----------+--+We are seeing one table…

May 23, 2022

ranganathan.madan Hadoop

Hive recursively read files

Hive table and the Hive table is pointing at a location or directory which has several sub directories and each sub directories has files underneath it. When you query the…

Welcome to IT Maddy

Month: May 2022