How to make phpmyadmin publicly available in aws ec2 bitnami ubuntu 16.04

admin Linux Leave a comment

Introduction

This article will be helpful for those who is using Ubuntu 16.04 – bitnami based server on amazon aws EC2 instance only. In this post i’m explaining how make phpmyadmin publicly available in bitnami based servers.

 

nano /opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf

Use the following rules

<IfVersion < 2.3 >
Order allow,deny
Allow from All
Satisfy all
</IfVersion>
<IfVersion >= 2.3>
Require all granted
</IfVersion>

 

restart apache

sudo /opt/bitnami/ctlscript.sh restart apache

 

After doing the above step phpmyadmin will be accessible using the following url pattern

http://<your domian OR ip>/phpmyadmin

 

 

 

 

Integrate Let’s Encrypt on an Amazon Linux AMI EC2 Instance Using Certbot

admin Linux Leave a comment

I’m using some latest Amazon Machine Image ( AMI ) called LAMP Stack PHP 5.3 LTS, Actually i was using some old AMI that released in 2013 and the instance also created at that time. It was almost impossible for me to integrate certbot in it, so that i finally decided to migrate my codeignitor app into new instance that support php 5.3

Here also i struggled so much to integrate certbot but finally i did it by the following steps.

  1. cd /tmp
  2. git clone https://github.com/certbot/certbot
  3. cd certbot
  4. chmod a+x certbot-auto
  5. ./certbot-auto certonly --webroot -w /var/www/html/ -d <domainName> --debug
  6. sudo ln -s /etc/letsencrypt/live/<domainName>/fullchain.pem /jet/etc/apache//server.crt
    sudo ln -s /etc/letsencrypt/live/<domainName>/privkey.pem /jet/etc/apache//server.key
  7. cd /jet/etc/apache
  8.  nano httpd.conf
  9. uncomment the following line of code in httpd.conf file
  10. Include /jet/etc/apache//extra/httpd-ssl.conf
  11. nano extra/httpd-ssl.conf     // uncomment and set the following things with newly created crt and key file paths
  12. DocumentRoot
  13. ServerName
  14. SSLCertificateFile
  15. SSLCertificateKeyFile
  16. restart service by using the following command
  17. /jet/enter restart

Auto-renew your SSL certificates.

You are all set now. But take a note, Let’s Encrypt’s certificates are only valid for 90 days. This is to encourage users to automate their certificate renewal process. You can setup a cron job which will run everyday at a particular time to renew certificates. Certificates are renewed only when they expire.

  • To test the renewal process, you can do a dry run with certbot:
sudo /tmp/certbot/certbot-auto renew --dry-run
  • Then update the crontab:
sudo crontab -e
  • Then, add the following line to crontab:
12 3 * * *   /tmp/certbot/certbot-auto renew --post-hook "sudo /jet/enter restart" >> /etc/letsencrypt/log/renew.log

This runs the renew everyday at 3:12 am. Remember that certs don’t get renewed unless they are near to expiration, and monthly/weekly cron job would cause your existing certs to occasionally be expired already before they get renewed.

 

You can contact me in case you need any help to setup the above things, I will providing premium support

 

How to use SSL pinning with cordova-plugin-advanced-http ?

admin Ionic3 Leave a comment

Introduction

It’s little bit complex task for the new programmers to use SSL pinning with cordova-plugin-advanced-http plugin. Plugin installation and usage is not so complex, but most of the people have no idea about how to obtain the .cer file for SSL pinning purpose.

I have already published a blog post about how to generate the .cer file, You may just read this blog post first.

In my project i just want to use an HTTPs based url from my ionic application, My client told me its very important for him because we are transferring some sensitive data through this API.

Firstly, I just installed the cordova-plugin-advanced-http plugin and its npm module in our ionic project and then i search on google to find how to generate .cer file. Most of the results just showing some results about how to convert a .pem file to .crt file and actually not solving my issues.

Example ionic application

I have created a git repository to share my sample application

Git URL https://github.com/sijovijayan/SSL-pinning-with-ionic-cordova-example

Or

Download

SSL Pinning may not work properly with Live Reload mode

Thanks

 

How to integrate SSL in ionic 3 using cordova plugin

admin Ionic3 Leave a comment

Introduction

It was a little bit hard task for me to integrate SSL in my Ionic 3 app using Cordova due to my lack of knowledge in SSL certificates. As usual i just landed in the HTTP native plugin section under ionic frameworks documentation section. It was not so helpful for me, because neither  this page or its official github page not explaining how to generate the .cer file for SSL pinning, finally i found the solution by reading lots of Stackoverflow answers and other articles.

Procedure

Install the plugin as per the instruction on the documentation section

How to get the .cer file ?

I’m assuming that you need to make https requests to a single domain only

Method 1

It works only if you had chrome browser on a windows machine with no active antivirus software ( In my case kaspersky using a personal root certificate – that mask the actual SSL certificate keyfile from the user  )

In this case, we can generate .cer file from your chrome browser on windows machine. Just access one of your public api url via chrome browser address bar and then click on the green padlock icon of your https url. then you can export the ssl public key as a .cer file

Watch this video to get clear understanding

 

Method 2 ( recommended one )

If you have a Linux or Mac machine or use you Linux server terminal – If your machine must have an installation of openssl.

Use the following linux command to obtain the .cer file

openssl s_client -showcerts -connect <domain name>:443 -servername <domain name>:443 </dev/null | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > certificate.pem

Convert .pem file into .cer file

openssl x509 -inform PEM -in certificate.pem -outform DER -out certificate.cer

Download the certificate.cer file to your local machine and then include a copy on your ionic/cordova project root directory

You must call enableSSLPinning or setSSLCertMode method on your components.ts file based on the version of the installed plugin

That’s all!

subdomain-virtual-host-on-bitnami-ubuntu-aws-ec2

How to setup subdomain and virtual host in ubuntu 16.04 bitnami server

admin Linux Leave a comment

Introduction

This article will be helpful for those who is using Ubuntu 16.04 – bitnami based server on amazon aws EC2 instance only. I’m writing this blog post because, i did’t find any best blogs which explain how to create a subdomain in aws ec2 instance and which also using bitnami based image to configure the instance. I can see, so many blogs and stackoverflow results about this topic, but most of those are talking about creation of virtual host on the standard ubuntu server only. Actually creation of the virtual host was the complex task for me at first and subdomain creation is almost easy.

subdomain-virtual-host-on-bitnami-ubuntu-aws-ec2

Steps to create virtual host and create subdomain in bitnami based ubuntu server

  1. Login on your sever via terminal window with bitnami as the user
  2. Copy demo directory from /home/bitnami/stack/docs/demo to a new location ( You may rename the directory “demo” as something else )
  3. Change the path and hostname on the config files on the new demo directory with new file paths ( in my example, it is located in /home/bitnami/htdocs/demo )
  4. Include the path /home/bitnami/htdocs/demo/conf/httpd-vhosts.conf  on the /home/bitnami/stack/apache2/conf/bitnami/bitnami-apps-vhosts.conf file
  5. Restart the apache2 server ( sudo /opt/bitnami/ctlscript.sh restart )
    (  Virtual host creatio has been completed )
  6. Create a subdomain record ( ‘A’ Record ) on aws route53
  7. Check the sub domain on the browser after 5 minutes
  8. Upload your files to your subdomain root directory
  9. Hire me if you need more help ( optional  🙂

Please watch this video to get more clarity on this.

how to connect to aws ec2 instance from windows computer without putty

admin windows Leave a comment

Hello Techies,

I don’t really like to use putty because i’m a linux user for development. Recently i wanted to connect to an AWS EC2 instance from my windows 10 pc, AWS recommended to use Putty or their CLI. But I don’t like none of those methods, we cannot use windows command prompt or power shell to accomplish the same without doing some modification on the system. So that i connected to aws using GitBash tools.

 

Use GitBash

It is very easy to use for a linux user, because GitBash support some linux commands like ls, ls -la , whoami etc..

First of all we need to locate our  private key file (.pem) file on our pc, I have already downloaded the pem file from aws when i created my ec2 instance. Right now its located in my ‘downloads’ folder so that, i just changed the current directory of gitbash to ‘downloads’ folder using cd command.

As i said before, my pem file is located in downloads folder, so that now i can run the command to connect to aws using my pem file called sijo.pem

ssh -i “SIJO.pem” ubuntu@ec2-54-202-69-35.us-west-2.compute.amazonaws.com

Now, my gitbash connected to my aws ec2 instance as show in the following picture.

gitbash

 

This is how to use SSH connection from windows machine without PUTTY. You can also connect to a linux server from gitbash without pem file as well.

I hope this post will be helpful for someone.

 

Thanks

cms-view

How to download all files from a web server using your linux machine

admin Linux Leave a comment

If you have enough experience in linux server or similar things then only use the following solution.

The Problem,

I have an Australian client, she want to migrate her websites to another hosting company, ixwebhosting.com was her old hosting company. There were not supporting her for anything related with web server problems like changing php versions and this server blocking suddenly stopped working and not supporting HTTP POST request sometimes. Actually I was working fine before. Finally I suggested to migrate to another hosting company called A2Host, they have some cool pricing plans and almost good technical support.

Actual problem starts when i try to using their ( ixwebhosting ) website control panel, It was not user friendly and don’t have most of the features available in CPanel, There was an Option for zip the project directory in their control panel, but it was not working anyway.  It is not possible to download all the files to my local machine using filezilla and again upload the same to the new service provider.

So, how can i solve this issue ?

Solution

1. I logged in the new webserver ( A2host ) via SSH

Find your webserver host, port number,  username and password , in case of A2H, username and password will be different than your usual login credentials of the control panel

login to the server via linux terminal or user putty in windows

2. Connecting to the old webserver from the current terminal window

Choose your directory you want to save the files being downloaded

use cd <your directory>

connect to the old server via FTP

use

lftp <hostname your using in you desktop ftp client such as filezilla>

ex: lftp web111.ixwebhosting.com

after doing this you have to login to FTP server

use

user <your ftp username>

ex: user webuser

now enter your password

Probably you will be logged in to the FTP server.

use the ls command to list all the directories and files

use the following command to download a particular directory to your new server

mirror <source directory> <target directory>

That’s it

NB: Please use experts help to do the same, otherwise it might cases server issues or data loss

 

preflight response issue with ionic3 app on ios build only [ resolved ]

admin Ionic3 Leave a comment

Problem

I was running with the same problem, My ionic 3 app with ASP.net backend was working just fine, it was not working with IOS ( Iphone x – IoS 11 simulator ). I got some errors like the following.

[Error] failed to load resource: Preflight response is not successful.

[Error] Failed to load resource: Origin http://localhost:8080 is not allowed by Access-Control-Allow-Origin.

I’m not seeing this issue from the Android version of the application. Is there a setting or something that can be enabled within the Ionic app to fix the CORS issue?

Solution/Workaround

Workaround only – Not a perfect solution

I changed the `web view` option of my ionic app.
WKWebView ===> UIWebView

First, open config.xml and add the following properties

<feature name="CDVWKWebViewEngine">
<param name="ios-package" value="CDVWKWebViewEngine" />
</feature>
<preference name="CordovaWebViewEngine" value="CDVWKWebViewEngine" />

then run the following commands – I hope you are familiar with this commands

ionic cordova plugin remove cordova cordova-plugin-ionic-webview --save
rm -rf platforms/
rm -rf plugins/
ionic cordova build ios

 



Note:

In iOS, there have been two webviews for a few years now, UIWebView and WKWebView. Historically, Ionic apps have used UIWebView, but no longer. Ionic now uses WKWebview by default when building for iOS.

We strongly believe WKWebview is the best option for any app, as it features many improvements over the older, legacy webview (UIWebView). These features include:

  • JIT conversion of JS code down to machine code, which runs much faster
  • Improved rendering performance
  • Less memory consumption
  • Better adherence to web standards
  • Reliable scroll events (important for virtual-list)

We wanted to make sure that people could easily switch to WKWebView without many issues, but there are still some things that you’ll need to consider.

Reference : Ionic wkwebview

Firestore

admin Tutorials Leave a comment

Google Cloud Firestore is database service from google and is has very similar features like firebase realtime data base. It is a NoSQL database like MongoDB and it will sync the data with all connected applications automatically in real time.

It has some cool properties like multi regional data replication, multi document transaction and much more..

Key features of Cloud Firestore include:

  • Documents and collections with powerful querying
  • iOS, Android, and Web SDKs with offline data access
  • Real-time data synchronization
  • Automatic, multi-region data replication with strong consistency
  • Node, Python, Go, and Java server SDKs

Right now it is available for the developers in BETA mode, however google may release the stable version with in few months.

What is the difference between Firebase Realtime Database and FireStore ?

Firebase realtime db does not offer the actual NoSQL database however can be store data like a tree structure.

This is a best tutorial for some one who would like to get started with Google Cloud Firestore SDK.