Create only read only with limited access to PostgreSQL Database. This user can only SELECT table data and also restricted by schema access.
Monitor Logs in Real-Time with “Log.io” on CentOS 6/7
How to install Python 2.7.6 on CentOS 6.3
How to install Python 2.7.6 on CentOS 6.3
(6.2 and 6.4 okay too, probably others)
CentOS 6.2 ships with Python 2.6.6 and depends on that specific version. Be careful not to replace it or bad things will happen. If you need access to a newer version of Python you must compile it yourself and install it side-by-side with the system version.
Here are the steps necessary to install Python 2.7.6. Execute all the commands below as root. Either log in as root temporarily or use sudo.
Restart Unicorn with Capistrano
The following tasks is what I use for starting, stopping, restarting and my unicorn server:
desc "Start unicorn"
task :start, :except => { :no_release => true } do
run "cd #{current_path} ; bundle exec unicorn_rails -c config/unicorn.rb -D -E production"
end
desc "Stop unicorn"
task :stop, :except => { :no_release => true } do
run "kill -s QUIT `cat #{shared_path}/pids/unicorn.pid`"
end
desc "Zero-downtime restart of Unicorn"
task :restart, :except => { :no_release => true } do
run "kill -s USR2 `cat #{shared_path}/pids/unicorn.pid`"
end
Installing workstation for managing Chef server
A workstation is a computer that is configured to run knife, to synchronize with the chef-repo, and interact with a single Chef server. The workstation is the location from which most users will do most of their work.
We need ti install on our workstation:
- knife
- chef-sdk
- chef-repo
- ruby
Installing Chef on Centos 6
Today we will install chef server in our home lab based on proxmox 3.4.6. So we have installed server 2cpu, 2Gb memory, Centos 6.7
First of all I switched off selinux, and configured hostname of server in /etc/sysconfig/network and /etc/hosts
Let's go on:
#wget https://web-dl.packagecloud.io/chef/stable/packages/el/6/chef-server-core-12.1.2-1.el6.x86_64.rpm
# rpm -Uvh chef-server-core-12.1.2-1.el6.x86_64.rpm
# chef-server-ctl reconfigure
Passwordless command line scripts with MySQL 5.6
I have several command line scripts to MySQL databases for zabbix statistic. These scripts set the password on the command line using the -p option.
With MySQL 5.6, a new warning is displayed every time my scripts run:
How to monitor sql queries with zabbix
If you want to monitor some parameters in mysql database, you can do it with ODBC monitoring in Zabbix.
ODBC monitoring corresponds to the Database monitor item type in the Zabbix frontend.
ODBC is a C programming language middle-ware API for accessing database management systems (DBMS). The ODBC concept was developed by Microsoft and later ported to other platforms.
Cooking with Chef: How to deploy instance on AWS with knife
Today I want to try provisioning and configuring Amazon AWS instances with Chef. To do that I have:
- Free tier account on AWS
- Open Source Chef Server 12
- Ubuntu Workstation with knife
Free SSL certificate for 3 years and up to 100 domains
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.