Create only read only with limited access to PostgreSQL Database. This user can only SELECT table data and also restricted by schema access.
More and more people reconfigured their sites to ssl connection. So I decided to use ssl certificate and secure connection on my blogs too.
The Chinese CA WoSign offers free SSL certificates which are valid for 2 years and may contain up to 100 domains each (multi-domain/SAN/UCC) which is very useful to host various domains on one single IP address (Better option than SNI if you still have Windows XP clients). Before you stop reading because you don't trust a Chinese company for your website encryption please keep in mind that you don't have to trust them at all! You generate the SSL key on your server and only send them the CSR (certificate signing request) which doesn't contain any private information.
1. Installing Recommended Packages
There are few developemnt libraries required to run Ruby on Linux. Use following command to install recommended packages on your server using yum.
# yum install gcc-c++ patch readline readline-devel zlib zlib-devel # yum install libyaml-devel libffi-devel openssl-devel make # yum install bzip2 autoconf automake libtool bison iconv-devel
When I tried to make auto start for mysql on Centos 7 I just received such message: