How to find the latest queries run in MySQL
Run the following queries – SET GLOBAL log_output = 'TABLE'; SET GLOBAL general_log = 'ON'; After the latest 100 queries executed after this is done can be foun...
Category: notes
Activate password authentication on Ubuntu VMs on Amazon EC2
ssh -i [path to private-key-file] [target IP] # In the host shell sudo adduser [username] # Add a new user; this command also prompts for setting the passwo...
Extract .gz file using gzip without deleting the original file
Extract the .gz file to standard output (option -c) and pipe this to target file. # example <pre><code>gzip -c inputfile.gz > outputfile</code...
Find the files contained in/provided by an Ubuntu/Debian package
On console, run dpkg -L [package name] Sreekumar KjSreekumar (KJ) has been a hobby programmer from school days. Codemarvels is his personal blog from the year 2...
Find the list of installed packages in Ubuntu/Debian
To find the list of installed packages on ubuntu/debian, on console run <pre>dpkg --get-selections</pre> To find if a specific package is installed ...
Temporarily enable SSH password authentication on RHEL/Centos VMs.
To enable password based authentication on RHEL/Centos machines, login as root to the target host. ( sudo the commands below if you are not logging in as root) ...
Public key authentication not working on RHEL/CentOS
Problem: SSH asks for password even after updating the .ssh/authorized_keys in target host with user’s public key. Reason: A permission issue Fix: Login with pa...
Fix Vim editor on Ubuntu
Problem: The arrow keys insert characters, no status message at the bottom etc. Reason : The default Vim on Ubuntu is vim-tiny, a skeleton version. Fix: Install...
Eclipse Compilation error: [function/type] is not accessible due to restriction on required library … rt.jar
Problem : Eclipse gives the error – “[function/type] is not accessible due to restriction on required library … rt.jar” when building a project. Reason: Project...
Ubuntu Error: Unable to lock the administration directory (/var/lib/dpkg/)
Problem: Ubuntu gives error “Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?” when using apt-get. Reason: Another apt...