DEV Community: Ahmad Ya'kob Ubaidullah

typescript eslint with RubyMine

Ahmad Ya'kob Ubaidullah — Thu, 24 Nov 2022 07:29:19 +0000

Files to Watch:
File type: TypeScript

Tool to Run on Changes
Program: $ProjectFileDir$\node_modules.bin\eslint
Arguments: --fix -c $ProjectFileDir$/config/.eslintrc.json $/FilePathRelativeToProjectRoot$
Output paths to refresh: $FilePathRelativeToProjectRoot$
Working Directory: $ProjectFileDir$

tomo deploy. Deploy rails app in one command. Heroku alike.

Ahmad Ya'kob Ubaidullah — Thu, 24 Mar 2022 03:07:56 +0000

tomo deploy allow user to deploy with just one command. Tomo will do both setup and deploy processes. Tomo deploy will allow Heroku alike features to be install onto your own server

for the tomo setup command it will:
run "env:setup"
run "core:setup_directories"
run "git:clone"
run "git:create_release"
run "core:symlink_shared"
run "bundler:upgrade_bundler"
run "bundler:config"
run "bundler:install"
# run "rails:db_create"
run "rails:db_schema_load"
run "rails:db_seed"
run "puma:setup_systemd"
run 'sidekiq:setup_systemd'

for the tomo deploy command it will:
run "env:update"
run "git:create_release"
run "core:symlink_shared"
run "core:write_release_json"
run "bundler:install"
run 'yarn:check_files'
run "rails:db_migrate"
run "rails:assets_precompile"
run "core:symlink_current"
run "puma:restart"
run "puma:check_active"
run "core:clean_releases"
run "bundler:clean"
run "core:log_revision"
run 'sidekiq:restart'

of course we can secify our own task in these processes by adding plugin to it. eg:

plugin './plugins/yarn.rb'

./plugins/yarn.rb

def check_files
  remote.chdir(paths.release) do
    remote.run('yarn', 'install', '--check-files')
  end
end

then we can add run 'yarn:check_files' to our process.

This is the part that I love about tomo deploy.

git:create_release source: tomo-deploy.com
Fetches the latest commits from git_branch (or git_ref) and creates a release by copying the contents of that branch of repository into a new release inside the releases_path. Releases are numbered based on the timestamp of when the deploy takes place.

git:create_release is intended for use as a deploy task.

TOP 3 TOMO COMMANDS

There are tons of goodness when it comes to tomo commands. We browse all commands through tomo tasks command.

To see running log on remote deploy server, we can use this command: tomo puma:tail_log

To access remote server data-via-activerecord we can always use our handy rails console but to do it remotely with tomo, we can use tomo rails:console.
tomo sidekiq:log

WARNING:

Do not use set env_vars to update your PATH. We cannot use like export "PATH=$PATH:/our/bin" in env_vars, as it will break our path. I have break it once and I suggest other people to do it on to the remote(deploy server) shell it self.
To allow message encryptor to work properly, we need to make sure:
a. master.key content from our local machine are the same RAILS_MASTER_KEY that we enter onto the remote server via tomo setup.
b. we add and commit+push our local credentials.yml.enc.

thank you for reading.

Postgres pre modify data before inserts

Ahmad Ya'kob Ubaidullah — Mon, 22 Feb 2021 11:08:29 +0000

Let say we want to modify data with only matching text *redirect* in the rpz_zone column, we first create the function like below:

CREATE OR REPLACE FUNCTION public.update_redirect_rpz()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
BEGIN
IF NEW.rpz_zone like '%redirect%' THEN
    NEW.redirect = true;
END IF;
RETURN NEW;
END;

then we can check the function with \ef update_redirect_rpz

after this we create a trigger to hook this method to an event like below:

   CREATE TRIGGER bind_rpz_log_redirect_flag
   BEFORE INSERT ON bind_rpz_log
   FOR EACH ROW EXECUTE PROCEDURE update_redirect_rpz();

Incase something went wrong, you can always check your log like in my case it is like this tail -f -n100 /var/log/messages.

Feb 22 19:02:13 dnsvgitnlognode postgres[39307]: [28-1] 2021-02-22 19:02:13.682 +08 [39307] ERROR:  syntax error at or near "update_redirect_rpz" at character 1
Feb 22 19:02:13 dnsvgitnlognode postgres[39307]: [28-2] 2021-02-22 19:02:13.682 +08 [39307] STATEMENT:  update_redirect_rpz
Feb 22 19:02:13 dnsvgitnlognode postgres[39307]: [28-3]     ();
Feb 22 19:02:18 dnsvgitnlognode postgres[39307]: [29-1] 2021-02-22 19:02:18.202 +08 [39307] ERROR:  syntax error at or near "function" at character 1
Feb 22 19:02:18 dnsvgitnlognode postgres[39307]: [29-2] 2021-02-22 19:02:18.202 +08 [39307] STATEMENT:  function update_redirect_rpz();

how to make rackup sinatra as systemd and auto restart on failure

Ahmad Ya'kob Ubaidullah — Fri, 19 Feb 2021 20:04:10 +0000

sinatra app

#acc-server.rb
require 'sinatra/base'

class MyApp < Sinatra::Base
  set :bind, '0.0.0.0'
  set :port, 3333

  get '/' do
    "Hello #{params[:name]}"
  end
  run! if app_file == $0
end

rackup

require './acc-server'
run MyApp

shell script server.sh

#!/bin/bash
cd /root/server && /usr/local/bin/rackup -p 3333 -P /root/server/server.pid </dev/null &>>/root/server/log

systemd conf /etc/systemd/system/pserver.service

[Unit]
Description=Prosody http server

[Service]
ExecStart=/root/server/server.sh
Restart=on-failure

[Install]
WantedBy=multi-user.target

start the service

systemctl start pserver.service

then enable it on startup

systemctl enable pserver.service

How to deploy production environment rails 6

Ahmad Ya'kob Ubaidullah — Thu, 18 Feb 2021 05:06:01 +0000

at other server run :
EDITOR=vim rails credentials:edit

add and commit
config/secrets.yml.enc

then push and pull to production server.

copy master key and put into production server ENV using config/application.yml which will be loaded using figaro gem. The format is like this :

RAILS_MASTER_KEY: masterkeyhere

then start your server in production environment.

Note that not to commit application.yml , and better to add it to gitignore.

sudo service cron start

Ahmad Ya'kob Ubaidullah — Mon, 25 Jan 2021 23:48:24 +0000

crontab is also a service, its need to be started.
Especially when you are running in WSL.

sudo service cron start

https://stackoverflow.com/a/58608597/610987

JITSI restart all and debugging all log

Ahmad Ya'kob Ubaidullah — Fri, 22 Jan 2021 02:48:09 +0000

https://jochen.kirstaetter.name/authentication-jitsi-meet/

RUN SQL FILE in postgres

Ahmad Ya'kob Ubaidullah — Mon, 18 Jan 2021 03:38:09 +0000

https://kb.objectrocket.com/postgresql/how-to-run-an-sql-file-in-postgres-846

Tracking long queries into csv

Ahmad Ya'kob Ubaidullah — Mon, 28 Dec 2020 07:13:05 +0000

If you have tons of queries executed in a Job or in a method, and you want to monitor which queries are slow and need attention, how do you track them ?

I was wondering what really dragging my cache job running time. The job supposed to be done in under 4 minutes suddenly spiked to 22 minutes.

I found query_tracker gem which displays all the info I needed. It also allows slack integration. In my case, I wanted it to store query informations into CSV. Fortunately the gem allows custom handlers.

Below is how I did my custom handlers :

QueryTrack::Settings.configure do |config|
  config.duration = 0.5
  config.notifications.custom_handler = -> (sql, duration, trace) {
    CSV.open("log/query_tracker.csv", "a+") do |csv|
      csv << [Time.now, duration, sql, trace]
    end
  }
end

notice the a+ open type, that will prepend the file.

Now all the queries information are visible for your next action :

You can always use the sort function to get more insights :

In my case, this is my queries that needs attention :

Thank you :)

net::ERR_INCOMPLETE_CHUNKED_ENCODING nginx

Ahmad Ya'kob Ubaidullah — Mon, 21 Dec 2020 10:33:16 +0000

Weird error that never show up in your life. This is it. The thing that scrutinize me for hourss.

answer re: net::ERR_INCOMPLETE_CHUNKED_ENCODING nginx

Mar 5 '18

Bumped into this issue on AWS and found that adding a few proxy_buffer directives to the site config file fixed the issues:

server {
    ...

    location / {
        ...
        proxy_buffers 8 1024k;  
        proxy_buffer_size 1024k;
    }
}

Open Full Answer

Answer: postgresql - get count by value ranges

Ahmad Ya'kob Ubaidullah — Mon, 21 Dec 2020 03:04:24 +0000

how to count specific range of number

answer re: postgresql - get count by value ranges

Oct 9 '14

select name
       count(case when value <= 5 then 1 end) as "0-5",
       count(case when value > 5 and value <= 10 then 1 end) as "5-10",
       count(case when value > 10 and value <= 15 then 1 end) as "10-15"
from the_table
group by name;

With the upcoming version 9.4…

Open Full Answer

How to get qname from bind log by specific ip

Ahmad Ya'kob Ubaidullah — Wed, 16 Dec 2020 06:38:13 +0000

cat query-2020-12-* | grep "10.22.70.195" | awk '{print $11}' | sort | uniq -c | sort -r > analytic

then the result is :

head -n100 analytic
2504 flora.web.telegram.org
1736 ib.sin1.geoadnxs.com
1467 astro2.rastream.com
1188 dns.msftncsi.com
1079 d3k3v8arhuq5l2.cloudfront.net
1021 settingsfd-geo.trafficmanager.net
1013 cu.sni.jns.swiftserve.com
1004 global.vortex.data.trafficmanager.net
 979 v10-win.vortex.data.trafficmanager.net
 974 global.asimov.events.data.trafficmanager.net
 919 rtm.ced.jns.swiftserve.com
 894 prod.pinterest.global.map.fastly.net
 763 star-mini.c10r.facebook.com
 707 sippoolks00f02.koreasouth.cloudapp.azure.com
 705 e15275.g.akamaiedge.net
 625 web.telegram.org
 546 mmx-ds.cdn.whatsapp.net
 539 webpoolks00f02.koreasouth.cloudapp.azure.com
 534 webdir0f.online.lync.com
 528 sipfed0f.online.lync.com
 502 sjc-bid-bgp.contextweb.com
 490 webdir.online.lync.com
 456 sippoolKS00F02.infra.lync.com
 451 www.tm.a.prd.aadg.akadns.net
 445 excel.officeapps.live.com
 439 www.agoda.com
 427 play.google.com
 409 webpoolks00f02.infra.lync.com
 402 7.client-channel.google.com
 395 col-rrs-prod-pub.trafficmanager.net
 389 waws-prod-bay-023.cloudapp.net
 387 sy.eu.angsrvr.com
 367 26.client-channel.google.com
 366 www3.l.google.com
 361 e10663.dscg.akamaiedge.net
 351 www.cjwowshop.com.my
 345 www.addthis.com
 331 ssl.gstatic.com