eusonlito

#
# Delete previous function definition (if exists)
#
DROP FUNCTION IF EXISTS before_update_updated_at() CASCADE;

#
# Create function to update updated_at timestamp if changed values on update
#
CREATE OR REPLACE FUNCTION before_update_updated_at() RETURNS trigger AS
$BODY$

eusonlito

pm disable-user --user 0 com.caf.fmradio
pm disable-user --user 0 com.coloros.activation
pm disable-user --user 0 com.coloros.activation.overlay.common
pm disable-user --user 0 com.coloros.alarmclock
pm disable-user --user 0 com.coloros.appmanager
pm disable-user --user 0 com.coloros.assistantscreen
pm disable-user --user 0 com.coloros.athena
pm disable-user --user 0 com.coloros.avastofferwall
pm disable-user --user 0 com.coloros.backuprestore
pm disable-user --user 0 com.coloros.backuprestore.remoteservice

eusonlito

#!/bin/bash

APP="php"
CURRENT_HIGHEST=$(ps -eo pid,comm --sort=-%mem | grep "$APP" | head -n 2 | tail -n 1)
CURRENT_HIGHEST_PID=$(echo $CURRENT_HIGHEST | awk '{print $1'})
LAST_PID_FILE="/tmp/oom-kill-previous"

if [ -f "$LAST_PID_FILE" ]; then
    LAST_PID=$(cat $LAST_PID_FILE)

eusonlito

This is an example of a web that uses a remote API as a database wrapper.

The remote API is stateless and the web uses cookies to maintain session persistence.

The API authentication endpoint returns a TOKEN that allows the web to make each request to the API with the user authentication header.

---

Este es un ejemplo de web que usa una API remota como wrapper de base de datos.

eusonlito

#!/bin/bash

if [ "`whoami`" != 'root' ]; then
    echo ""
    echo "This script only can be executed by root"
    echo ""

    exit 1
fi

eusonlito

SELECT
    "s"."relname" AS "table_name",
    pg_total_relation_size("s"."schemaname" || '.' || "s"."relname") / 1024 / 1024 AS "total_size",
    pg_relation_size("s"."schemaname" || '.' || "s"."relname") / 1024 / 1024 AS "table_size",
    (pg_total_relation_size("s"."schemaname" || '.' || "s"."relname") - pg_relation_size("s"."schemaname" || '.' || "s"."relname")) / 1024 / 1024 AS "index_size",
    "s"."n_live_tup" AS "table_rows"
FROM
    "pg_stat_user_tables" "s"
JOIN
    "pg_class" "c" ON "s"."relid" = "c"."oid"

eusonlito

Protect your server with a strong iptables rules and ipset lists.

1. Install ipset to manage ipstables lists

apt install ipset

2. Install iptables-persistent to preserve iptables rules on reboot

eusonlito

ps -eo comm,rss | awk '{arr[$1]+=$2} END {for (i in arr) print arr[i], i}' | sort -nr | head

eusonlito

<?php

protected static function generateUniqueSlug(string $title): string
{
    $slug = str_slug($title);

    if (static::query()->where('slug', $slug)->doesntExist()) {
        return $slug;
    }

eusonlito

ip="XXX.XXX.XXX.XXX"

for set in $(ipset list -n); do
    ipset test $set $ip &> /dev/null && echo "IP $ip found in $set"
done