Friday, November 16, 2018

Install TeamViewer on Centos7

1. Get the RPM Package

    wget https://download.teamviewer.com/download/linux/teamviewer-host.x86_64.rpm

2.  Install EPEL Repository

    sudo yum -y install epel-release

3. Install TeamViewer

    sudo yum -y install ./teamviewer-host*.rpm

That's all folks!  3 steps only.

Fyi, I referred to https://community.teamviewer.com/t5/Knowledge-Base/How-to-install-TeamViewer-on-Red-Hat-and-CentOS/ta-p/30708 for this.
Install FileZilla FTP Client on Centos7

1. Enable EPEL Repository

    sudo yum -y install epel-release

2. Install FileZilla

    sudo yum -y install filezilla


That's all folks.  2 steps only.

Fyi, i referred to http://sysadmindata.com/install-filezilla-centos-7/ for this.
Install Google Chrome on Centos7

1. Enable Yum Repository

    sudo vi /etc/yum.repos.d/google-chrome.repo

    Add the following:

    [google-chrome]
    name=google-chrome
    baseurl=http://dl.google.com/linux/chrome/rpm/stable/x86_64
    enabled=1
    gpgcheck=1
    gpgkey=https://dl.google.com/linux/linux_signing_key.pub


2. Install Google Chrome

    sudo yum install google-chrome-stable

That's all folks.  2 steps only.

Fyi, I referred to https://www.cyberciti.biz/faq/howto-install-google-chrome-on-redhat-rhel-fedora-centos-linux/ for this.
Installing Visual Studio Code on Centos7

1. Enable Yum Repository

     sudo vi /etc/yum.repos.d/vscode.repo

     Add the below:

    
[vscode]
     name=Visual Studio Code
     baseurl=https://packages.microsoft.com/yumrepos/vscode
     enabled=1
     gpgcheck=1
     gpgkey=https://packages.microsoft.com/keys/microsoft.asc


2. Import the package signing GPG key

     sudo rpm --import https://packages.microsoft.com/keys/microsoft.asc 

3. Install Visual Studio Code


     sudo yum check-update
     sudo yum install code



That's all folks! 3 steps only.


Fyi, I referred to https://tecadmin.net/install-visual-studio-code-editor-in-fedora/ for this.

Thursday, September 27, 2018

Drop database and then restore (Postgresql 10.4.0):

1. su as postgres

2. run psql at command prompt

3. First, find the activities that are taken place against the target database, you can query the pg_stat_activity view with the following query:

SELECT
 *
FROM
 pg_stat_activity
WHERE
 datname = 'target_database';


4. Second, terminate the active connections by issuing the following query:

SELECT
 pg_terminate_backend (pg_stat_activity.pid)
FROM
 pg_stat_activity
WHERE
 pg_stat_activity.datname = 'target_database';


5. Third, execute the DROP DATABASE statement:

DROP DATABASE target_database;

6. Create database:

CREATE DATABASE target_database;

7. Copy file from host to docker container:

docker cp src/. mycontainer:/target

8. Go into docker container and restore database:

docker container exec -it mycontainer bash
su postgres
psql target_database < infile

That's all folks!

After Jenkins successfully shutdown, my Gitlab CE is now using port 8080 so I need to shut it down also to make way for my WildFly Application Server.  Command issued to shutdown Gitlab CE are as follows:

1.  su as root

2. At command prompt: gitlab-ctl stop

Referred from here: https://docs.gitlab.com/omnibus/maintenance/

That's all folks!
My Jenkins Server automatically starts upon Centos 7 server starts, so I need to stop it to make way for my WildFly Application Server.  What I did to stop it are as follows:

1. On my Firefox browser, go to this url : http://localhost:8080/exit

2. It will ask me to login then i have to click some button to initiate the shutdown process

I saw someone also asking about the same thing at stackoverflow: https://stackoverflow.com/questions/10238604/how-to-shutdown-my-jenkins-safely/35922474

It's that easy folks!

Wednesday, September 5, 2018

Install PgAdmin4 on Centos 7

Install PgAdmin4 on Centos7

PgAdmin4 is GUI Tool to manage PostgreSQL database.  I have a problem installing the latest PgAdmin4 which is v3.2 in Windows 10 on my HP EliteBook x360 so I made the decision to install it on my VMware Virtualised Centos 7 server.
This is what I did to install PgAdmin4 on Centos 7:

1. Get the yum repository installed on my server

  • Install the yum repo

    sudo rpm -ivh pgdg-centos96-9.6-3.noarch.rpm

  • Install PgAdmin4

    sudo yum -y install pgadmin4

  • Configure PgAdmin4

    cd /usr/pgadmin4/bin/
    su

    ./pgadmin4-web-setup.sh

    NOTE: Configuring authentication for SERVER mode.
    Enter the email address and password to use for the initial pgAdmin user account: Email address: edyzairani@gmail.com
    Password:
    Retype password:
    pgAdmin 4 - Application Initialisation
    ======================================
    We can now configure the Apache Web server for you. This will create the pgAdmin4 conf file under /etc/httpd/conf.d/. Do you wish to continue?
    1) Yes
    2) No
    #? 1
    pgAdmin4 Apache config file is created as /etc/httpd/conf.d/pgadmin4.conf
    Apache web server is not running. We can start the web server for you to finish pgAdmin4 installation. Would you like to continue?
    1) Yes
    2) No
    #? 1

    Apache successfully started. You can now start using pgAdmin4 in web mode

2. Install PgAdmin4 Desktop Gnome

    sudo yum -y install pgadmin4-desktop-gnome

That's all folks.
Fyi, I referred to https://people.planetpostgresql.org/devrim/index.php?/archives/96-Installing-pgAdmin4-3.X-on-RHEL-CentOS-7-and-Fedora-27.html for this.

Install MySQL 8.0 on Centos 7

Steps to install MySQL 8.0 Community Edition in Centos 7 1. Enable MySQL 8.0 Repository sudo yum localinstall https://dev.mysql.com...