un1ko85

server {
    listen       80;
    server_name  site.dev;
    index        index.php;
    root         /Users/balkon_smoke/Sites/site.dev/web;

    error_log   /Users/balkon_smoke/Sites/site.dev/logs/error.log;
    access_log  /Users/balkon_smoke/Sites/site.dev/logs/access.log;

    location / {

un1ko85

CREATE OR REPLACE FUNCTION pnorm(z double precision) RETURNS double precision AS $$
  SELECT CASE 
  	WHEN $1 >= 0 THEN 1 - POWER(((((((0.000005383*$1+0.0000488906)*$1+0.0000380036)*$1+0.0032776263)*$1+0.0211410061)*$1+0.049867347)*$1+1),-16)/2
  	ELSE 1 - pnorm(-$1)
  END;
$$ LANGUAGE SQL IMMUTABLE STRICT;

un1ko85

import plotly.graph_objects as go
import pandas as pd

def serp_heatmap(df, num_domains=10, select_domain=None):
    df = df.rename(columns={'domain': 'displayLink',
                            'searchTerms': 'keyword'})
    top_domains = df['displayLink'].value_counts()[:num_domains].index.tolist()
    top_domains = df['displayLink'].value_counts()[:num_domains].index.tolist()
    top_df = df[df['displayLink'].isin(top_domains) & df['displayLink'].ne('')]

un1ko85

    #### First declare a couple of variables ####
    ### Outgoing tcp / udp port ####
    ### 43 - whois, 22 - ssh ###
    tcp_services = "{ ssh, smtp, domain, www, https, 22, ntp, 43, 587}"
    udp_services = "{ domain, ntp }"
    ### allow ping / pong ####
    icmp_types = "{ echoreq, unreach }"
    ### Allow IP
    enabled_ip = "{ 188.231.230.23, 188.231.222.49, 134.249.151.49 }"

un1ko85

Intro

This is an example configuration to have nginx output JSON logs to make it easier for Logstash processing. I was trying to get nginx > Filebeat > Logstash > ES working and it wasn't until I connected Filebeat directly to Elasticsearch that I saw the expected data. Google led me to ingest-convert.sh and I realized filebeat setup works for Filebeat > ES but not Filebeat > Logstash > ES. This is because Logstash does not use ingest pipelines by default. You have to enable them in the elasticsearch output block.

Having nginx log JSON in the format required for Elasticsearch means there's very little processing (i.e. grok) to be done in Logstash. nginx can only output JSON for access logs; the error_log format cannot be changed.

Extra fields are output and not used by the Kibana dashboards. I included them in case they might be useful. Since they are not declared in the filebeat setup, their default is "string" when yo

un1ko85

version: "2.1"
services:
  apm-server:
    image: docker.elastic.co/apm/apm-server:${STACK_VERSION:-6.5.0}
    ports:
      - "127.0.0.1:${APM_SERVER_PORT:-8200}:8200"
      - "127.0.0.1:${APM_SERVER_MONITOR_PORT:-6060}:6060"
    command: >
      apm-server -e
        -E apm-server.rum.enabled=true

un1ko85

-- Продажи товаров с атрибутами
SELECT
    orders.created_at AS created_at,
    products.id,
    -- Категории
       (
       SELECT string_agg(c.title, ' / ')
       FROM hm_taxonomies_category_product c_p
              JOIN hm_taxonomies_categories c ON c_p.category_id = c.id
       WHERE c_p.product_id = products.id -- todo: order

un1ko85

-- Сравнение продаж текущий год с предыдущим

SELECT
    -- Категории
       (
       SELECT string_agg(c.title, ' / ')
       FROM hm_taxonomies_category_product c_p
              JOIN hm_taxonomies_categories c ON c_p.category_id = c.id
       WHERE c_p.product_id = s.product_id -- todo: order
       ) AS categories,

un1ko85

Docker compose as a systemd unit

Create file /etc/systemd/system/docker-compose@.service

[Unit]
Description=%i service with docker compose
Requires=docker.service
After=docker.service

un1ko85

#! /bin/bash
MYSQL="/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper"
NGINX="/opt/local/sbin/nginx"
PHPFPM="/opt/local/sbin/php-fpm"
PIDPATH="/opt/local/var/run"
MEMCACHED="/opt/local/bin/memcached -m 24 -P /opt/local/var/run/memcached.pid -u root"

if [ $1 = "start" ]; then
    sudo $MYSQL start
    echo "Starting php-fpm ..."