In previous post I’ve talked about installing MySQL in Mac OS X. Today I want to talk about PhpMyAdmin. Tool which help work with MySQL databases. Here steps how to install it and configure under Nginx webserver. 1. Create virtualhost for PhpMyAdmin. Create /usr/local/etc/nginx/sites-available/phpmyadmin file with next content server { listen Read more…
Here is instructions how to install MySQL and PhpMyAdmin on Mac OS X 1. Download and install DMG file. Link for downloading : https://dev.mysql.com/downloads/mysql/ 2. Installer will generate temporary root password. Save it in text file for next steps. 3. Add /usr/local/mysql/bin to PATH If you use ZSH open ~/.zshrc file and add export Read more…
For better security we should use public key authentication on the server. Here is steps how to do it. 1. Generate SSH key pair on your local computer. Skip if you already have ssh key pair in your local computer ssh-keygen Output: Generating public/private rsa key pair. Enter file in Read more…
Here I want to talk about mock responses for your Retrofit. Sometimes we should continue mobile development even backend not ready. We can be never blocked on it if will use mock responses. Sure we need specify JSON response before starting. But we need only JSON format of the backend Read more…
Before starting installation PHP-FPM and configurations you should have Nginx installed and configured. If you don’t have it ready please follow my previous post about installing and configuring Nginx on Mac OS X. Here is the link https://www.hrupin.com/2017/11/how-to-install-nginx-webserver-on-mac-os-x So, here we have installed and configured NGinx. Let’s install and configure PHP-FPM. Read more…
Before start you should ensure that you have Command Line Tools installed in your mac. It is part of XCode. You should have it installed and updated. Install Command Line Tools if not exist xcode-select –install Install Nginx using Homebrew brew tap homebrew nginx brew install nginx Test Installation ## Start Read more…
Operations which will be described can be done normally using mouse or trackpad. But if you want to make your working process really fast and productive then you in the right place. I’ll tell you about the most common shortcuts which you probably already know. Hope this page will help Read more…
Below you can find code which help you find if SIM card available in the device. There two solutions. One for Android API less than 22 and for Android API greater than or equal to 22. Problem that dualsim support added in API-22. And we should deal with devices which Read more…
To make automatic renew you Letsencrypt certificates you need create crontab job. Here is simple instructions 1. Create /root/certrenew.sh file with content: #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin sudo service nginx stop /home/igor/letsencrypt/letsencrypt-auto renew service nginx start exit 0 2. Make it executable `chmod +x /root/certrenew.sh` 3. `sudo crontab -e` 4. Add crontab job. Read more…
Here is instruction how to launch MySQL server after close unexpectedly. 1. Create /root/mysqlfix.sh file with next content: #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin if [[ ! “$(/usr/sbin/service mysql status)” =~ “active (running)” ]] then echo $(date -u) “MySQL service on the server has been stopped. It has now been restarted.” sudo service mysql Read more…