As you know, in MySQL/MariaDB there is no native function for splitting string column by comma or by some regex into a table. In PostgreSQL we a great function regexp_split_to_table for this, but in mysql compatible world it was not possible (till some time ago) to do this without complicated workarounds. Fortunately with introduction of […]
Postfix sender_bcc_maps will not work if PostSRSd (or similar SRS software) is used, because it rewrites all sender addresses to internal format that looks like this and therefore the per-user / per-domain rules will never match. Fortunately, in case that you are using Postfix with mysql table, you can modify the query like this: to […]
SOLR is great search server, and in some cases I prefer it over Elasticsearch, because it is possible to execute powerful queries very easily via simple GET requests. This way, you don’t need some front-facing app, that translates input requests to search queries.
If you’ve seen following error while emerging some package, than be sure this is a bug in portage. Just append to make.conf, and it should work again.
When adding new node to Proxmox Cluster, local system might pickup invalid local IP (usually public IP instead of internal, or IPV6 instead of IPv4) and use it in .members file, what results in 595 network problem error messages. Fix is simple: correct /etc/hosts file on affected node check with ping that node name returns […]
Simple function that compares two JSON structures (on 1st level only), and returns old values for changed keys. I’m using it to track table changes via before update trigger.
This is MariaDB (MySQL) checklist for setting up Master-Slave replication.
Getting filesystem quotas work inside of a LXC unprivileged container is relatively a big problem, because linux kernel and LXC currently play against us (= they do not support this yet). But, workaround exists !
Quick how-to for registering and unregistering partitions on LVM logical volume (yes, event that is possible ;).
VPN in container requires tun/tap device – if you don’t have one you have to create it with mknod command. But, there is the problem – in the LXC (Proxmox) unprivileged container is mknod (as syscall) not allowed, because this would introduce possible security problems (see this article).