Here I want to describe tutorial which works on my Mac. MySQL version: mysql Ver 14.14 Distrib 5.7.20, for macos10.12 (x86_64) using EditLine wrapper Mac OS version: Sierra 10.12.6 Please take care about root access in production environment. I’m feel free to connect to my MySQL db using root because it is Read more…
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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | server { listen 80; server_name phpmyadmin; root /var/www/phpmyadmin/; index index.php index.html index.htm; access_log /usr/local/etc/nginx/logs/phpmyadmin.access.log; error_log /usr/local/etc/nginx/logs/phpmyadmin.error.log; location ~ \.php$ { try_files $uri = 404; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; } error_page 404 /404.html; error_page 403 /403.html; } |
Edit hosts 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
1 | export PATH=/usr/local/mysql/bin:$PATH |
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
1 | ssh-keygen |
Output:
1 2 | Generating public/private rsa key pair. Enter file in which to save the key (/home/igor/.ssh/id_rsa): |
Hit ENTER and enter passphrase for your 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
1 | xcode-select --install |
Install Nginx using Homebrew
1 2 | brew tap homebrew nginx brew install nginx |
Test Installation
1 2 3 4 5 | ## Start Nginx sudo nginx ## Check if Nginx is running on 8080 port curl -IL http://127.0.0.1:8080 |
Output should look like this
1 2 3 4 5 6 7 8 9 | HTTP/1.1 200 OK Server: nginx/1.12.1 Date: Sat, 11 Nov 2017 21:11:39 GMT Content-Type: text/html Content-Length: 138 Last-Modified: Sat, 11 Nov 2017 19:49:46 GMT Connection: keep-alive ETag: "5a07545a-8a" Accept-Ranges: bytes |
Also you 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:
1 2 3 4 5 6 | #!/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. Job for running every day at 3:15AM will be next:
1 | 15 3 * * * /root/certrenew.sh >> /var/log/le-renew.log |
/var/log/le-renew.log Read more…