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.
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.
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.
Convert wildcard SSL to Java Keystore Format (JKS)
Today we need to get a wildcard SSL certificate into a Java Keystore format. First copy everything you need to a /tmp folder. There are gd_bundle.crt , domain.com.crt and domain.com.key
Migrate vmware vm to proxmox
Hi. One of my clients use proxmox virtualization in Production. So I need to move one service machine created for them from vmware to proxmox. As for me the most simple way is to use VMWare Converter. Lets try.
My vm configuration on esxi.