DOB blog

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

Author: root

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

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