Welcome to my devblog where I discuss about devops and game dev. It is mainly a personal stash for notes and issues I have solved but hopefully you’ll find something interesting in there.
Migrate Grafana from SQLite to Postgres
So you have a Grafana with the default storage backend (SQLite) and you want to move it to PostgreSQL ? You鈥檝e come to the right place. Preparing First we need to dump the SQLite database, since it鈥檚 just a single file simply shut down Grafana to avoid any corruption and copy the grafana.db somewhere safe. It is usually located at /var/lib/grafana. In your Postgres DB create a grafana user and database then edit your Grafana configuration file to enable postgres storage....
How to read the results of fio commands
fio is a versatile tool for measuring I/O performance, and it can produce a lot of output, which can sometimes be difficult to interpret. When fio reports IOPS (Input/Output Operations Per Second), it often provides separate results for read and write operations, as well as an aggregate total. The output from fio might look something like this: read: IOPS=10k, BW=40MiB/s (42MB/s)(1000MiB/25003msec) write: IOPS=15k, BW=60MiB/s (63MB/s)(1500MiB/25003msec) In this example: The read: IOPS=10k means that the system was able to perform 10,000 read operations per second....
Enabling TouchID for sudo commands
Got a Macbook or desktop Apple computer equipped with the TouchID sensor and wondering how you could stop having to input your admin password for every sudo prompt ? look no further! The pam_tid plugin Shipped with MacOS is the pam_tid.so PAM plugin allowing you to invoke the TouchID authentication method in any PAM flow. Since authenticating the access to the sudo executable depends on PAM we simply need to add pam_tid....
Making your Scaleway S3 bucket public with Minio/mc
A common use case for S3 buckets is to act as the backend for a CDN or some kind of caching service. Here鈥檚 how to make files inside your Scaleway S3 bucket visible with or without allowing file listing using Minio鈥檚 mc client. While creating a new bucket you will be asked if you want to make it public or not, this can be a little bit confusing if you鈥檙e used to other object storage providers like OVH鈥檚....
The curious case of the Unity Input System mouse stutter
In effort to learn more about Unity and become rich making games I started building a new project with the intent of having a third person camera and player controller. Since I didn鈥檛 want to re-invent the wheel I browsed the various demo assets Unity has and found one called Starter Assets - Third Person Character Controller. How convenient! I imported the asset into my project and started playing around with it....