Fading Coder

An Old Coder’s Final Dance

Fixing pycurl.so “undefined symbol: CRYPTO_num_locks” Breaking yum on RHEL/CentOS

This error typical indicates that pycurl is loading a libcurl linked against an incompatible OpenSSL version. The dynamic linker is likely picking up the wrong libcurl (often from a leftover custom install, such as a MySQL bundle), instead of the system one. Symptom Running yum (or any Python that i...

Designing Alertmanager Templates for Prometheus Notifications

This guide explains how to craft Alertmanager templates to format alert messages, improving clarity and presentation. Alertmanager uses Go’s text/template engine with additional helper functions. Alerting rules reference: https://www.dogfei.cn/archives/alertmanager-rule Prometheus configuration over...

Resolve PhpStorm “Interpreter is not specified or invalid” on WAMP (Windows)

Symptom PhpStorm displays: “Interpreter is not specified or invalid. Press ‘Fix’ to edit your project configuration.” This occurs when the IDE cannot locate a valid PHP CLI executable or when the debugger extension is missing from the selected runtime. Target environment Windows with WAMP installed...

Oracle Regular Expressions: Comprehensive Guide and SQL Patterns

Regular expressions describe text patterns using literal characters and metacharacters. In Oracle Database (10g and later), SQL gains native regex support through a set of REGEXP_* functions that implement a POSIX-style dialect with several Perl-like features. This guide summarizes the syntax, optio...

Resolving ORA-01653 for SYS.AUD$ Exhaustion in the SYSTEM Tablespace

When connecting with sqlplus user/password@service you may see a stack similar to: ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM ORA-02002: error while writing to audit trail ORA-00604 indicates a failure in an internal (re...

Fixing OPatch Error 135 (ZOP-51): Invalid Patch Location During Apply on Oracle 11.2

This note walks through diagnosing and resolving OPatch error code 135 (ZOP-51: "The patch location is not valid for apply") encountered while applying a patch bundle on an AIX single-instance environment. Symptom Running opatch apply from the patch directory fails immediately with ZOP-51:...

.NET MVC: Resolve JavaScriptSerializer maxJsonLength for Large JSON Request Bodies

When posting large JSON payloads to an ASP.NET MVC action, model binding may fail with an ArgumentException similar to: An error occurred during JSON JavaScriptSerializer serialization or deserialization. The length of the string exceeds the value set on the maxJsonLength property Stack shows System...

LeetCode 100: Determine If Two Binary Trees Are Identical

Problem Given the roots p and q of two binary trees, determine whether the trees are identical. Two tree are identical if they have the same structure and every corresponding node has the same value. Examples Example 1 Input: p = [1,2,3], q = [1,2,3] Output: true Example 2 Input: p = [1,2], q = [1,n...

Core NASM Instructions: Moves, Arithmetic, Branching, and String Operations

Data Movement mov Moves data between registers and/or memory. ; register to register a mov eax, ebx ; memory to register (base + displacement) mov edx, [ecx + 8] ; register to memory mov [edi + 4], eax Only one operand may be a memory location (memory-to-memory moves are not allowed with mov). movsx...

Fixing “mysql-community-server depends on libmecab2” During MySQL Installation on Ubuntu

When installing MySQL from Oracle’s .deb packages on Ubuntu, dpkg can leave the server unconfigured if a required library (libmecab2) isn’t present. This typically shows up when installing multiple local packages in one go. Example install command (local .deb files): sudo dpkg -i ./mysql-common_*.de...