Search This Blog

Tuesday, June 2, 2020

Postgresql 12 with PGAdmin4 Installation in Linux Ubuntu 16 18 20

 Install Postgresql 12

1. sudo apt-get install postgresql-12

2.  sudo -u postgres psql postgres

3. \password postgres

         Enter new and confirm password : xxxxx

Install PGAdmin 4

1. apt clean

2. apt autoclean

3. sudo apt update

4. sudo apt install pgadmin4 pgadmin4-apache2
                   #. username : postgres@localhost
                   #. pwd : xxxxx

5. sudo ufw allow http

6. sudo ufw allow https

7. In Browser : http://localhost/pgadmin4/

8. 4th point credentials

9. Type again http://localhost/pgadmin4/browser/ if you see apache2 default page.

10. Connect with new server -> Postgres user/pwd.

Thursday, May 28, 2020

Linux Ubuntu How to add Eclipse or Other Applications to Desktop Favourite or In Desktop Grid

1. create a file name with /usr/share/applications/filename.desktop extension
2. add the exec=, icon= key value in that file.
3. give the execute permission
4. click the Grid ::: in desktop, see your added .desktop application is will show. right click and select Add to favourite. 

ex 1:

#> gedit /usr/share/applications/eclipse.desktop

[Desktop Entry]

ex 2:
[Desktop Entry]
Exec=wine /home/drvijay/.wine/drive_c/windows/mspaint.exe

#run the below cmd for execute.

#> chmod a+x ~/.local/share/applications/.desktop

Linux Ubuntu Change Complexity Length & Strong Password

vim /etc/pam.d/common-password

#Remove obscure word and add minlen=1

password    [success=1 default=ignore] minlen=1 sha512

Ubuntu Disable Each time Password Entering

sudo nano -w /etc/sudoers

%sudo  ALL=(ALL) ALL 

- Enjoy

Tuesday, May 19, 2020

Linux Ubuntu - OpenJdk Java 13 Install Setup

Install > 1.9 JDK 1.3

> sudo apt install -y curl

> curl -O

> tar xvf openjdk-13_linux-x64_bin.tar.gz

> sudo mv jdk-13 /usr/java/

> sudo nano /etc/profile
     # Go to after fi end and paste the below lines
    export JAVA_HOME
    export JRE_HOME
    export PATH

# Configure Java Alternatives
> sudo update-alternatives --install "/usr/bin/java" "java" "/usr/java/jdk-13.0.2/bin/java" 1

# Configure Javac Alternatives
> sudo update-alternatives --install "/usr/bin/javac" "javac" "/usr/java/jdk-13.0.2/bin/javac" 1

# Check version
> java -version

# Use only in case of multiple JDKs installed

# Configure Java
> sudo update-alternatives --config java

# Configure Java Compiler
> sudo update-alternatives --config javac

>javac -version

>java version

Friday, May 8, 2020

Cassandra GUI Clien for windows - DataStax DevCenter

1. Go to Datastax Devcenter, download the latest for windows.
2. Extract it.
3. Go to bin folder and double click DevCenter.exe

4. Create Connection
5. Create KeySpace [ it is like database or schema ]
6. Create a table.
7. Use cql editor and do DML commands.

Hit Counter

View My Stats