Helpful Linux Commands Find whats on port running on a particular port : ex port 8098 $ sudo netstat -apn | grep 8098 tcp 0 0 10.224.35.187:8098 0.0.0.0:* LISTEN 19666/beam.smp Find status of a particular process : ex status of riak $ sudo /etc/init.d/riak status …
Git Cheat Sheet
Git Quick Reference Adding the ShortCut: $ git config –global alias.add-commit ‘!git add -A && git commit’ $ git add-commit $ git config –global –edit [user] name = Raju email = [email protected] [gui] recentrepo = C:/Git [alias] add-comment = !git add -A && git commit …
MySQL and phpMyAdmin Setup
MySQL and phpMyAdmin Setup sudo yum install mysql sudo yum install mysql-server sudo yum install mysql-devel sudo chgrp -R mysql /var/lib/mysql sudo chmod -R 770 /var/lib/mysql sudo service mysqld start sudo yum install phpmyadmin Errors: # tail -f error.log 2014/03/06 20:11:05 [error] 2833#0: *1 directory …
Install S3CMD tools on EC2 Instance.
Install S3CMD tools on EC2 Instance. SSH Into your EC2 Box and you run the following command to install S3CMD. $ sudo yum install s3cmd Loaded plugins: priorities, update-motd, upgrade-helper Bad id for repo: datastax , byte = 8 amzn-main/latest | 2.1 kB 00:00 amzn-updates/latest …
Setup EC2 Instance with NGINX and PHP-FPM
Setup EC2 Instance with NGINX and PHP-FPM Login into AWS Console and launch default Amazon Instance. Security Group: Create your security group and download your key. Restrict the permissions on your key. sudo chmod 400 Kaizen.pem SSH into your Machine: ssh -i Kaizen.pem [email protected] Update …
SQL Server – Interview Questions
Database Professional – Interview Questions What factors do you usually consider for your datastore selection ? Data Volume , Variety and Velocity. Whats CAP Theorem?. Consistency , Availability and Partition Tolerance and you can’t all three together. In theoretical computer science, the CAP theorem, also known …
NGINX – SSL Certificate Setup
Create the Server Key and Certificate Signing Request Start off by creating the 1024 rsa private key. sudo openssl genrsa -des3 -out /etc/nginx/conf.d/i90runner.key 1024 sudo openssl req -new -key /etc/nginx/conf.d/i90runner.key -out /etc/nginx/conf.d/i90runner.csr Remove the Passphrase sudo cp /etc/nginx/conf.d/i90runner.key /etc/nginx/conf.d/i90runner.key.org sudo openssl rsa -in /etc/nginx/conf.d/i90runner.key.org -out …
xp_cmdshell command to Add User
Add user to Admin Group through SQL Server Its absolutely bad practice to turn on xp_cmdshell without comprehensive security audit and security testing. By default this feature is turned off. If you end up having the permission to execute xp_cmdshell, you can do all kind …
Connect to SQL Server When SA or Service Account Credentials not Available
Connect to SQL Server When SA Account or Service Account Credentials not Available : I recently inherited the SQL Serer which was running under a user account who left the company and no one knows the password for sa account. My task was to fix …
Move SQL Server Database to Different Location
Move SQL Server Database to Different Location : There are several way to do this but I find this option being simple.Sometimes we face the issue with Drive being full. It happens when we have Database on C Drive and we usually don’t allocate much …