DOB blog

Skip to content
  • Home
  • About
  • Contact
  • Hire Me

MySQL/MariaDB Split Comma Separated String Into Table

root2019-11-112019-11-11

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 […]

mysql, rdbms, SQL, Uncategorized

Fixing Postfix sender_bcc_maps not working with PostSRSd

root2019-06-072019-06-07

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 […]

admin, mail server, MariaDB

Exposing SOLR search API securely with Nginx and Lua

root2019-03-152019-03-19

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.

devel, lua, nginx, solr

Fix for Gentoo: The ebuild phase ‘die_hooks’ has been aborted

root2019-03-012019-03-15

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.

admin, how-to, time saver

Fix invalid node IP in /etc/pve/.members

root2018-07-092018-07-09

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 […]

admin, Proxmox, time saver, virtualization

MySQL JSON diff

root2017-10-222019-11-11

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.

devel, how-to, mysql, rdbms, SQL

MariaDB Master-Slave replication checklist

b0001o0001u780782017-04-15

This is MariaDB (MySQL) checklist for setting up Master-Slave replication.

admin, how-to, MariaDB

Quotas in LXC unprivileged container

b0001o0001u780782017-03-30

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 !

admin, security, time saver, virtualization

Partitions of LVM logical volume

b0001o0001u780782017-01-23

Quick how-to for registering and unregistering partitions on LVM logical volume (yes, event that is possible ;).

admin, how-to, LVM, time saver, Uncategorized

TUN in LXC unprivileged container

b0001o0001u780782017-01-22

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).

admin, how-to, network, virtualization, vpn
Posts navigation
1 2 3 4 5 6 Next →

Recent Posts

  • MySQL/MariaDB Split Comma Separated String Into Table
  • Fixing Postfix sender_bcc_maps not working with PostSRSd
  • Exposing SOLR search API securely with Nginx and Lua
  • Fix for Gentoo: The ebuild phase ‘die_hooks’ has been aborted
  • Fix invalid node IP in /etc/pve/.members

Archives

  • November 2019
  • June 2019
  • March 2019
  • July 2018
  • October 2017
  • April 2017
  • March 2017
  • January 2017
  • December 2016
  • September 2016
  • February 2016
  • December 2015
  • October 2015
  • September 2015
  • April 2015
  • November 2014
  • July 2014
  • June 2014
  • March 2014
  • March 2013
  • May 2012
  • April 2012
  • February 2012
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • January 2011
  • April 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009

Categories

  • admin
  • c/c++
  • cm
  • devel
  • dmlquery
  • eldap
  • how-to
  • log-malloc2
  • lua
  • LVM
  • mail server
  • MariaDB
  • mysql
  • network
  • nginx
  • pager
  • passwd-exp
  • performance
  • perl
  • personal
  • Proxmox
  • rdbms
  • security
  • solr
  • solr
  • SQL
  • time saver
  • tinc
  • Uncategorized
  • virtualization
  • vpn
  • web
  • xml
  • xsl

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Theme: FlatBox by Wpbars, Powered by WordPress