Pyora Updates

Hello all, If you used Pyora in the past, today I made some updates. Now it supports Python3 and the template was also updated to work with Zabbix 5.0, the 5.0 template is zabbix-template/Pyora.xml More info: https://github.com/danilochilene/Pyora

January 6, 2022 · 1 min · Danilo Fernando Chilene

Monitoring Microsoft SQL Server File Groups with Zabbix

In a previous post we installed the tools necessary to access Microsoft SQL Server, continuing our quest I needed to monitor some filegroups and decided to create something like Pyora. It only monitors filegroups (Primary used and Log used), but I plan to add more items like datasize, logcachehit, etc. The idea is pretty simple, ./pyssql.py fetch data from SQL Server via Zabbix. Follow the instructions below to install and use it:...

April 30, 2015 · 2 min · Danilo Fernando Chilene

Install Virtualenv and Virtualenvwrapper on Ubuntu 14.04

Virtualenv helps a lot when you work with various Python projects or when you have to use specific packages or different Python versions. In this tutorial, we are going to install Virtualenv on Ubuntu 14.04 and configure it on zsh. Install pip, virtualenv and virtualenvwrapper sudo apt-get install -y python-pip python-virtualenv virtualenvwrapper Create the directory for our virtual environments mkdir ~/.venvs Configure ZSH - .zshrc Edit the file ~/.zshrc and paste the content below:...

February 10, 2015 · 1 min · Danilo Fernando Chilene

Pyramboia - a simple way to test webservices

I’m learning Django 1.7 lately and nothing better than practice and create something from scratch. I have a bunch of scripts to tests webservices(XML, soap, etc.) in python using requests library, it works well so far. It returns the time it spent running, the result in an XML format and based on these data I make decisions(send email, feed it to a monitoring tool, etc.). When it’s 1 or 2 scripts is easy to admin and make changes like the XML request, headers and so on....

September 29, 2014 · 5 min · Danilo Fernando Chilene

Using Python to access SQL Server

Install the required packages UnixODBC and FreeTDS packages yum install -y unixODBC unixODBC-devel freetds Configure unixODBC Add the content below to the file /etc/odbcinst.ini [FreeTDS] Description=ODBC for SQL Server Driver=/usr/lib/libtdsodbc.so Setup=/usr/lib/libtdsS.so FileUsage=1 Configure FreeTDS Add the content below to the file /etc/freetds.conf tds version = 8 client charset = UTF-8 Install pypyodbc to Python handle ODBC connections pypyodc is a pure python ODBC interface. For more information access https://code.google.com/p/pypyodbc/ I’m using pip to install it....

August 7, 2014 · 2 min · Danilo Fernando Chilene