Platform To Build And Manage Your Project Team

Create Google Form Via Google OAuth 2.0 Playground In this blog, I would like to help you with generating the google forms using the Google Appscript and running the app script code via Google OAuth 2.0 Playground. For this, first, we need to set write code to generate a form via app script. Kindlyfollow the following steps. 1. Create the app script project and give it a name. Write the following code to create a form athttps://script.google.com Make sure that the .gs file name and the function name is also the same. function myFunction() { var form = FormApp.create('New Form'); var item = form.addCheckboxItem(); item.setTitle('What condiments would you like on your hot dog?'); item.setChoices([ item.createChoice('Ketchup'), item.createChoice('Mustard'), item.createChoice('Relish') ]); form.addMultipleChoiceItem() .setTitle('Do you prefer cats or dogs?') .setChoiceValues(['Cats','Dogs']) .showOtherOption(true); form.addPageBreakItem() .setTitle('Getting to know you'); form.addDateItem() .setTitle('When were you born?'); form.addGridItem() .setTitle('Rate your interests') .setRows(['Cars', 'Computers', 'Celebrities']) .setColumns(['Boring', 'So-so', 'Interesting']); Logger.log('Published URL: ' + form.getPublishedUrl()); Logger.log('Editor URL: ' + form.getEditUrl()); } 2. Run the Script to test if the script is running fine or not. 3. On Run, it may ask you to authorize the app. Authorize the application and then open the Google Forms to test if the sample form is created or not. 4. Next, we need to create credentials so as to access this project viaGoogle OAuth 2.0 Playground and run the script. For this go to Resource -> Could Platform project -> View API console, and do "Create Credentials" and retrieved client ID and client secret. You can also access the project by clicking on the created project from the pop-up Or you can directly visit the consolehttps://console.developers.google.comand select your project (Named in the app script). 5. Next, enable the App Script API Make sure while enabling you have selected the newly created project. 6. Next, you need to create the credentials to access the script from Google OAuth 2.0 Playground. In the "Authorised JavaScript origins" set "http://localhost" In the "Authorised redirect URIs" set "https://developers.google.com/oauthplayground" as currently, we will be requiring the authentication response on the Google OAuth Playground. And click on Create. 7. Now visithttps://developers.google.com/oauthplaygroundand click on the Settings Gear. In the drop-down menu, check the "Use your own OAuth credentials" and enter the "OAuth Client ID" and "OAuth Client Secret" received on the step 6 8. Next, in the "Step 1 Select & authorize APIs" section, select the "Apps Script API v1" and further select the "https://www.googleapis.com/auth/forms" option and click Authorize 9.Next, it will ask for the Authorization of the account of whose you wanna access the selected scope. In this, I am using the same account on which the "App Script" for for creation code is created and the same from which the "Client ID" and "Client Secret" is generated. 10.The above step will generate the "Authorization code" and further you can generate the "Refresh token" and the "Access token". 11.Next, we have to consume the services to execute the google app script code. Click on the "List Possible Operations" and then select "Run Scripts" 12.Next, a Syntax will be generated, asking for the script ID which you can find from the google app script project. For this, on the Google App Script project, Click on File > Project Properties and finally, a pop-up will open referring the script ID 13. Enter the script ID in the PlayGround and then set the request Body by clicking on the "Enter Request Body" button. To understand the request body parameters, refer to the documenthttps://developers.google.com/apps-script/api/reference/rest/v1/scripts/run 14. Now click on the "Send Request". On thesuccessful run, a form will be generated the way it generated in step 3 Hope the above information is useful. References: https://developers.google.com/apps-script/reference/forms/ https://stackoverflow.com/questions/53010287/how-to-run-google-app-script-function-from-google-oauth-2-0-playground-the-cal

Kamaldeep Singh

31 Dec 2018

Importing Site Certificate Into Java Runtime Certificate Store Hi guys, We must have faced problems to connect to a server that has an invalid self-signed SSL certificate, resulting our application throws following such errors: SunCertPathBuilderException occurred when processing request: [GET] /requestURL - parameters: unable to find valid certification path to requested target. Stacktrace follows: Message: unable to find valid certification path to requested target OR javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Hence to make your Java runtime environment trust the certificate, you need to import it into the JRE certificate store explicitly. Today in this blog I will help you how you can do this into your system. Step 1 - Extract the connecting site certificate from your browser. In google chrome browser, open the site, and then press F12. Now navigate to the "Security" tab and then click on view certificate. A pop-up screen will open showing you "General" details of the certificate. Now click on the "Details" tab and in the bottom you will find the "Export" option. Click on Export. a saving pop-up will get open asking you for the saving location. Make sure to select the "DER-Encoding" format before you click on the save. Step 2 - Import the certificate into the Java Key Store Now, as we have extracted the certificate and saved it into the system, hence the next step is to import the certificate into the Jave key store. Make sure you have write access to your JRE and use thekeytoolutility to import on Ubuntu. In my case the JRE is installed on the following location: /usr/lib/jvm/jdk1.7.0_80 Hence the certificate file in which we have to add the extracted certificate is located at: /usr/lib/jvm/jdk1.7.0_80/jre/lib/security/cacerts Now to import the certificate using key store, use the following command: keytool -import -alias test_certificate -keystore /usr/lib/jvm/jdk1.7.0_80/jre/lib/security/cacerts -file /home/kamaldeep/Desktop/test.site.com Where: test_certificate : is the unique alias name to denote the imported certificate /usr/lib/jvm/jdk1.7.0_80/jre/lib/security/cacerts : is the location of the Java default certificate /home/kamaldeep/Desktop/test.site.com : is the location of the extracted certificate. You will be prompted for thekeystorepassword, which is by defaultchangeit. Step 3 - Import the certificate into the Java application Now before you make any connections from your Java application, you may also be required to import the certificate explicitly into the application by setting the system property in the following manner System.setProperty("javax.net.ssl.trustStore", "/usr/lib/jvm/jdk1.7.0_80/jre/lib/security/cacerts"); System.setProperty("javax.net.ssl.trustStorePassword", "changeit"); That's all we have to do to resolve.

Kamaldeep Singh

31 Dec 2017

Lazy Load Images Plugin for jQuery Hi.. Does your site take too much time to get loaded because of way too many images? And what about those images which are at the bottom of your site which user hardly went up to but still getting loaded in page load? Yeah, thats the problem!! What if your image get loaded only when you scroll to that particular section/viewport where your image is. Does seems Nice :) ? In this blog I will tell you how you can implement the Lazy Load plugin in your jQuery application to load the images only when required making your page load lightening faster. Images outside of viewport are not loaded until user scrolls to them. This is opposite of image preloading. This also helps in reducing the server load as well. Before we get into this implementation lets have a demo of it by clicking on the following links: Basic Option Fade-In Effect The plugin only works with jQuery. To implement the plugin follow these steps: Step 1: Download the LazyLoad plugin from the following link: https://www.appelsiini.net/projects/lazyload/jquery.lazyload.js Step 2: Make sure to include both jQuery and LazyLoad plugin in your HTML code: <script src="jquery.js"></script> <script src="jquery.lazyload.js"></script> Step 3: Alter your image tags by adding the address of the image in the data-original attribute. And add a class to your images so that you can easily control to which images plugin isbound to. <img class="lazy" data-original="img/example.jpg"> Step 4: Initialize the lazy loading of images by calling this function in the JavaScript $(function() { $("img.lazy").lazyload(); }); This will cause all images of class lazy to be lazy loaded. See the Basic Optionsdemo. Thats all you have to do. Along with this there are certain properties which you can set to handle the loading of images as per your need: Setting Threshold If you want images to load earlier before actually going to the view port, use threshold parameter. Setting threshold to 400 will causes image to load 400 pixels before it appears on viewport. Example: $("img.lazy").lazyload({ threshold : 400 }); Setting Event to Trigger Loading You can use jQuery event such as click or mouseover to load the images. Default is to wait until user scrolls down and image appears on the viewport. To load images only when user clicks them you could do: $("img.lazy").lazyload({ event : "click" }); Using Effects To add the fadeIn effect, use the following sample code. By default plugin waits for image to fully load and calls show() function. $("img.lazy").lazyload({ effect : "fadeIn" }); For more details checkout this link Thanks

Kamaldeep Singh

12 Jan 2017

Change MySql ROOT password Hi.. If you ever forgot the MySQL root user password and can’t remember and wanna break, then you can reset the MySQL database password from the command line. But make sure you must know any of the user and password of the system you are on, this is for MySQL 5.7 onwards: Step 1: First stop the MySQL using the following command: sudo service mysql stop Step 2: Start the MySQL in safe mode: sudo mysqld_safe --skip-grant-tables Step 3: This will be an ongoing command until the process is finished so open another shell/terminal window, and log in without a password as root: myself -u root Step 4: Flush all the privileges as: FLUSH PRIVILEGES; Step 5: Alter the root user password: ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; Step 6: Quit the MySQL terminal: \q step 7: Restart the MySQL services: sudo service MySQL restart Thats all you need to do. Now your root user's password will be updated with what you have provided. Thanks

Kamaldeep Singh

12 Jan 2017

Install Custom Java version in Linux Hi folks, I have seen many a times that there is project requirement to use some old java version installation but as your system is already upgraded to the latest version you find it difficult to install it in one go. Most important, you don't need to worry about your default installation. So follow the below steps to install the required version of java in your system: Step 1: Download the required version of JDK from the following link: http://www.oracle.com/technetwork/java/archive-139210.html#javase Here select the major version of JDK and on the next page download the specific minor version of the selected major version like "Java SE Development Kit 7u51" to download JDK 7u51. Make sure to accept the License Agreement and then download the .tar.gz extension file against the Linux platform. I assume that you have downloaded the JDK in the /home/user/Downloads directory. Step 2: Now extract the .tar using the following command in your /home/user/Downloads directory tar -xvzf [your_file_name] Example: tar -xvzf jdk-8-linux-x64.tar.gz Step 3: Create jvm folder in /usr/lib, if jvm folder doesn't exist using the following command: sudo mkdir /usr/lib/jvm Step 4: Move the extracted jdk folder to /usr/lib/jvm location. Follow the command being in your /home/user/Downloads directory sudo mv {your_folder_name} /usr/lib/jvm Step 5: Install the java source in system: sudo update-alternatives --install /usr/bin/javac javac /usr/lib/jvm/{your_folder_name}/bin/javac 1 sudo update-alternatives --install /usr/bin/java java /usr/lib/jvm/{your_folder_name}/bin/java 1 sudo update-alternatives --install /usr/bin/javaws javaws /usr/lib/jvm/{your_folder_name}/bin/javaws 1 Example: sudo update-alternatives --install /usr/bin/javac javac /usr/lib/jvm/jdk1.8.0/bin/javac 1 sudo update-alternatives --install /usr/bin/java java /usr/lib/jvm/jdk1.8.0/bin/java 1 sudo update-alternatives --install /usr/bin/javaws javaws /usr/lib/jvm/jdk1.8.0/bin/javaws 1 Step 6: Now following are the major steps which help you to switch your java version at any point of time. To choose the default java follow these commands to select the java, javac or the javaws version: sudo update-alternatives --config javac sudo update-alternatives --config java sudo update-alternatives --config javaws Running these individual commands will ask you for the version of java. Type in the number against the java version which you want and press enter. Make sure that you select the same java version in all the configuration selection. Step 7: Test the java version by running the following command: java -version It will give you the default version of java used by the system. Step 8: Configure JAVA_HOME. Type the following command in your terminal: sudo gedit /etc/profile Add following lines in end: JAVA_HOME=/usr/lib/jvm/{your_folder_name} export JAVA_HOME Example: JAVA_HOME=/usr/lib/jvm/jdk1.7.0 export JAVA_HOME Step 9: Restart your system or you can load your updated source file by running the below command source /etc/profile Thats all for now. Write comments for any queries. Thanks

Kamaldeep Singh

12 Jan 2017

Monitor Linux server from Android Hi, folks. In my previous blog, I focused on how you can establish an ssh connection using a private key. In this tutorial, I will guide how you can monitor your server statistics live using an android device. Yes true via your Android device using "JuiceSSH Performance" an application from "Sonelli Ltd" which is a plugin app for "JuiceSSH Client" application. To use this you need to have installed JuiceSSH Client on your mobile and also have the connection established to the server. For connection, establishment read my previous blog. To monitor the server, install the "JuiceSSH Performance" on your android device by clicking here. After you have installed, open the application and allow it to use the JuiceSSH to make connections to the server. Now to view the real-time server stats, select the connection from the top drop-down which you have already established in the "JuiceSSH - SSH Client" and then click "Connect". With this a connection will be established to the server and will display you the following logs: CPU Usage Free RAM Average Load Network Traffic Disc Usage You can even fork this plugin on GitHub to customize it according to your needs. Here is thelink THANKS

Kamaldeep Singh

12 Jan 2017

SSH connection to linux server from Android device Hi, developers. Hope you are doing well!! But think about a situation in which you are not in reach of your computer and unfortunately you get a phone call informing server issues. Suppose if everything gets down on a live server machine and you don't have a laptop with you to have an SSH. Well, the solution to the above problem is now available. All you need is an Android phone and install the app named "JuiceSSH - SSH Client". The app is build by "Sonelli Ltd". Click hereto download In this tutorial, I will guide you how you can build up an SSH connection to your remote Linux server using the pem file. Make sure that your server accepts public logins instead of just the whitelisted IP or you can only access via a whitelisted IP connection. In order to set up a new SSH connection you will need the following details from your server: Public address SSH Port (22 by default) Username Private Key or Password A working internet connection Step 1: Install the Juice SSH on your Android device by clicking here Step 2: Open the app and click on Connections at the top Step 3: Click on the plus icon on the bottom right and then provide the server details starting with providing the nickname to this connection. For this example we'll assume that your server's address is myserver.example.com, the SSH service is running on port 92, your username is testuser and your private key file has been copied to the SD-Card of your Android device. With these assumptions, the data will be filled in the following way: Step 4: To provide the username and the pem file/password details, click on Identity and select new and define the new identity. Identities contain authentication details and can be reused for multiple connections. Step 5: To provide the password to the user click on "Password" or to provide the Pem file click on "Private Key". In this example, I have set the private key. To import the private key, click on "Smart Search". The interface will automatically search the pem file from your mobile storage. Select the file and click OK. After you have successfully set the private key, you will see the following screen Close the window by clicking on the tick icon on the top right of your screen. Step 6: After following the above steps, you will see a new connection created under the connections tab. Select the connection to establish the connection to the server. A connection window will open showing you the progress of connection. That's all for now. In my next blog, I will share how you can see monitor the server performance via SSH on Android. Thanks

Kamaldeep Singh

09 Jan 2017

How to Revert a Commit Already Pushed to a Remote Repository How to Revert a Commit Already Pushed to a Remote Repository In this blog I would like to tell you how to revert your last commit from git hub. There may be a case when you realize that one of the commits should not be there, or that there was some unacceptable typo in it. So that isn't a big problem. All you need to take care of is that you should do it fast before anyone fetches the bad commits. This can be done in two ways :- Correct the mistake in a new commit Revert the full commit Correct the mistake in a new commit This is simple as you just need to remove or fix the bad file in a new commit and push it to the remote repository. This is the most natural way to fix an error, always safe and totally non-destructive, and how you should do it 99% of the time. Yet the bad commit remains there and accessible, but this is usually not a big deal. Revert the full commit In this case, instead of going through all the changes manually your whole previous commit will be reverted. Reverting a commit means to create a new commit that undoes all changes that were made in the bad commit. Just like above, the bad commit remains there, but it no longer affects the the current master and any future commits on top of it. To do this, first reset the branch to the parent of the current commit, then force-push it to the remote as follows. $git reset HEAD^ --hard $git push -f For more details, Click Here THANKS

Kamaldeep Singh

31 Dec 2015

Configure Nginx web server Configure Nginx web server NGINX is a free, open-source, high-performance HTTP server which is designed to deliver large amounts of static content quickly with efficiently. Nginx uses an asynchronous and scalable event-driven model which provides more predictable performance under load. But before proceeding further, I would like you to know about installation. Installing NGINX:- The simplest way to install Nginx in Ubuntu is by downloading it from Debian’s repositories. Run the following command in terminal to install NGINX sudo apt-get install nginx After successful installation, you can loacte the NGINX files in the "/etc/nginx/" directory. The primary configuration file is "/etc/nginx/nginx.conf" Now before proceeding further, let me tell you about some of the basic commands. sudo service nginx start To start the NGINX server. sudo service nginx stop To stop the NGINX server. sudo service nginx restart To restart the NGINX server. sudo nginx -t To test the NGINX configuration for syntax errors. Now you’re ready to make changes to your Nginx configuration. Whenever you make a change to the nginx.conf file, you need to reload your configuration before the change will take effect. Here is the sample code which I will explain. server { listen 80 default_server; listen [::]:80 default_server ipv6only=on; root /usr/share/nginx/html; index index.html index.htm; # Make site accessible from http://localhost/ server_name localhost; location / { # First attempt to serve request as file, then # as directory, then fall back to displaying a 404. try_files $uri $uri/ /index.html; } } server Tells this is the start of server configuration. listen Tells Nginx the hostname/IP and the TCP port where it should listen user requests for HTTP connections. By default, Nginx will listen on port 80 for HTTP connections root This describes where is the path to the project files. In the above example, the index.htm is saved in /usr/share/nginx/html/index.html index Tells Nginx which file to serve if none is specified server_name The domain name is specified in the server_name variable location Tells Nginx what to respond to requests for resources within the server THANKS So this was all about NGINX installation and configuration. Hope this thing works. For detailed information, visit the following link https://www.nginx.com/resources/wiki/

Kamaldeep Singh

31 Dec 2015

How to detect browser window close action In my previous blog I have explained how to Prevent Internet Explorer from caching http calls so that each time you can get fresh data from the server. Here is its link: Prevent Internet Explorer from caching http calls Now in this blog, I will let you know how to detect browser window close action. Now this action may be sometimes required where you want to perform some kind of function on window close. Say you may be required to call Logout function on a secured website. Now this functionality can be done by the following line of javascript code <html> <head> <title>Hello</title> <script type="text/javascript" language="Javascript"> function DetectBrowserExit() { alert('Here you can execute task you want'); } window.onbeforeunload = function() { DetectBrowserExit(); } </script> </head> <body> Close this browser to notice the browser close event </body> </html> And if we talk about its browser compatibility, I have tested this in following browsers:- Google Chrome Internet Explorer Mozilla Firefox Safari Thats all for now. THANKS

Kamaldeep Singh

30 Sep 2015

Kamaldeep Singh (Manager-Technical Project Manager)

Kamaldeep Singh
(Technical Project Manager)

Languages

Skills

Work Experience / Trainings / Internship

Education

Top Blog Posts

Kamaldeep Singh (Manager-Technical Project Manager)

Kamaldeep Singh (Technical Project Manager)

Languages

Skills

Work Experience / Trainings / Internship

Education

Top Blog Posts

Kamaldeep Singh
(Technical Project Manager)