Using MySQL TIMESTAMPDIFF to delete unverified user records

Building a public website with user registration and email verification is typical. It will require users to validate their email by clicking a unique generated URL link. Sometimes, user registration with pending verification will grow exponentially and needs an automated cleanup of records. In this example I created a simple MySQL stored procedure to delete […]

Continue Reading…

How to connect to a Cisco VPN in Ubuntu 18.04 LTS

Here’s the simple steps for you to connect to a Cisco VPN in Ubuntu 18.04 LTS. Cisco, an American company is the leading provider and manufacturer of enterprise network devices, telecommunication hardware, networking security and networking software. According to computer profile as of April 2018, Cisco holds a 73.9% market which makes it the undisputed […]

Continue Reading…

Bash string manipulation in program arguments

In this code snippet, I would like to run an application with a URL payload based on date and time. This code will be executed in a specific schedule everyday and I would like to dynamically inject the date and time in the program argument when the program executes. ./json2csv rules.json “ncp” “http://localhost:8080/api/zget?eid=get-ncp-mv-by-starttime-endtime&starttime=$(date –date=’yesterday’ +\%Y-\%m-\%d)+00:00:00&endtime=$(date […]

Continue Reading…

Standardizing SQLite in Spring framework Project

My approach in standardizing SQLite in a Spring framework project In a software development world were rapid project delivery is needed. The only way for us, developer having a sense of sanity is to build standardize code for future development. In doing so, it shortens the development time but having tested and functioning code base. […]

Continue Reading…

Golang MongoDB sort number inside a string

// Get List func (z *DocumentTagService) GetDocumentTags() ([]models.DocumentTag, error) { z.DatabaseService.Connect() var o []models.DocumentTag err := (*z.DatabaseService.Db).C(z.Collection).Find(bson.M{}).Sort(“-$natural”, “-documentReference”).All(&o) return o, err } Result [ { “idDocumentTag”: “5b1390f29ebea41854dcc0dc”, “documenReference”: “MCTU/2018/16”, “company”: “MCTU” }, { “idDocumentTag”: “5b1390f09ebea41854dcc0db”, “documenReference”: “MCTU/2018/15”, “company”: “MCTU” }, { “idDocumentTag”: “5b1390d19ebea41854dcc0da”, “documenReference”: “MCTU/2018/14”, “company”: “MCTU” }, { “idDocumentTag”: “5b1390d09ebea41854dcc0d9”, “documenReference”: “MCTU/2018/13”, “company”: “MCTU” […]

Continue Reading…

A simple firewall-cmd cheatsheet

Get Default Zone Get Active Zones List Zone Services Add a permanent port into a zone Remove a permanent port from a zone Firewall-cmd reload I tested this using CentOS 7 with firewalld service running. Get Default Zone To know the default zone, use this command firewall-cmd –get-default-zone Get Active Zones firewall-cmd –get-active-zones List Zone […]

Continue Reading…

How to use Cloudflare as Dynamic DNS

In this post I will share how I use Cloudflare as Dynamic DNS. I was previously using dynamic DNS service from No-IP for three years until a colleague of mine mentioned about Cloudflare’s really fast global DNS. Initially, I thought that Cloudflare was just a CDN and an Internet company that protects websites from Distributed […]

Continue Reading…