Visualizing what we talked about on the phone with Grafana

Well, in this post we will see something as always different and that we can simply add to our Grafana installation, and it is nothing more than exploiting the usage data of our phone calls. I've been using it for a long time and I wanted to share it in case you're interested, I was curious how much I talked on my mobile phone, with whom, what they called me and I called, See it by schedules, people… with nougat!

Visualizing IP addresses on a world map with Grafana

Well, This document is something particular, since it had a series of public IP addresses in a MySQL table, that I would like to visualize it in Grafana. Basically I'm talking about the visits to the blog 🙂 I have a WordPress and I don't have the database in my possession since it's on an external hosting… I leave you the steps I followed to achieve it, I hope it can be useful for other ideas.

Put the Home Assistant DB in MariaDB

Call me meticulous, but I usually put the Home Assistant database on an external server with MariaDB or MySQL, since I usually make remote queries to the DB with some system, or for the issue of backup, robustness, etc… It is not something usual to do, But I'll leave you the steps in case you need it!

Moving Microsoft Exchange Databases 2003

To help you understand how Exchange databases work, We have two databases in principle, one would be the private DB and the other the public DB, There are two files: priv1.edb and pub1.edb respectively. These files grow as users' mailboxes grow, are by default in: “C:Program FilesExchsrvrMDBDATA“, What I usually do is take them out of the system partition and put them in the data partition which is really the one I'm interested in in case one day I have to format a server. To do this,: “Beginning” > “All Programs” > “Microsoft Exchange” > “System Administrator”