gcleaves

ffmpeg -i input.mp4 -c copy -metadata:s:v:0 rotate=180 output.mp4

gcleaves

[{
		"domain": "amazon.sa",
		"detection": "warning",
		"monitor": "ok",
		"tdt": "severe",
		"issues": "images are not being extracted, things are not working"
	},
	{
		"domain": "amazon.es",
		"detection": "ok",

gcleaves

PUT _ingest/pipeline/laravel
{
    "description": "Parses Laravel log files.",
    "processors": [
        {
          "rename": {
            "field": "message",
            "target_field": "event.original"
          }
        },

gcleaves

# attempt 6, success
# relies on Magisk auto start script
# pause script to give wireguard time to autostart
bullhead:/ # cat /data/adb/service.d/prep_gateway.sh
#!/system/bin/sh
sleep 2m
su -c 'iptables -F tetherctrl_FORWARD'
su -c 'sysctl -w net.ipv4.ip_forward=1'
su -c 'iptables -A FORWARD -i tun0 -j ACCEPT'
su -c 'iptables -t nat -A POSTROUTING -o rmnet_data0 -j MASQUERADE'

gcleaves

# This throws an error
[OfferRevenueSuspicion]
type=filter
module=regexfilter
options=ignorecase
match=INNER JOIN\s*\(\s*SELECT `fact_susp_conversions`.`offer_id` AS `offer_id`,\s*SUM\(`fact_susp_conversions`.`revenue`\) AS `__measure__0`\s*FROM `fact_susp_conversions`\s*LEFT JOIN `dim_conversion_suspicion` ON \(`fact_susp_conversions`.`impression_id` = `dim_conversion_suspicion`.`impression_id`\)\s*LEFT JOIN `dim_offer_suspicion` ON \(\(`fact_susp_conversions`.`offer_id` = `dim_offer_suspicion`.`offer_id`\) AND \(`dim_conversion_suspicion`.`suspicion_code` = `dim_offer_suspicion`.`suspicion_code`\)\)\s*LEFT JOIN `dim_advertiser_suspicion` ON \(\(`fact_susp_conversions`.`advertiser_id` = `dim_advertiser_suspicion`.`advertiser_id`\) AND \(`dim_conversion_suspicion`.`suspicion_code` = `dim_advertiser_suspicion`.`suspicion_code`\)\)\s*LEFT JOIN `dim_offer` ON \(`fact_susp_conversions`.`offer_id` = `dim_offer`.`natural_key`\)\s*LEFT JOIN `dim_advertiser` ON \(`fact_susp_conversions`.`advertiser_id` = `dim_adverti

gcleaves

DATE_TRUNC('week', now())  === STR_TO_DATE(CONCAT(YEARWEEK(now(), 2), ' Sunday'), '%X%V %W')
DATE_TRUNC('month', now()) === DATE_FORMAT(now(), '%Y-%m-01')