AJANTHA SCHOOL OF ARTS :: அஜந்தா ஸ்கூல் ஆஃப் ஆர்ட்ஸ் ::

https://www.instagram.com/ajanthaschoolofartschennai/

https://www.instagram.com/prasunfinearts/

Courses from https://www.domestika.org/

For an example lets take Microsoft Teams web view sends notification to your laptop's chrome and you wish to receive this notification on your smart phone ( here we considered android)

To get Microsoft Teams Chrome desktop notifications from a different Chrome profile on your Android phone, follow these steps:

Solution 1: Use Pushbullet for Cross-Device Notifications

Pushbullet can forward desktop notifications to your Android device.

Steps to Set Up Pushbullet:

1. Install Pushbullet on Chrome (Different Profile)
   • Open Chrome in the profile where Teams notifications appear.
   • Install Pushbullet Extension → Chrome Web Store
   • Sign in using Google.
2. Install Pushbullet on Android
   • Download from Google Play Store.
   • Log in with the same Google account.
3. Enable Notification Mirroring
   • Open the Pushbullet Android app → Settings → Enable Notification Mirroring.
   • Select Chrome as a source app.
4. Test by Receiving a Teams Notification
   • When Teams sends a notification in Chrome, it should automatically appear on your Android device.

Solution 2: Use KDE Connect (Open Source Alternative)

If you prefer an open-source method, KDE Connect can sync notifications between devices.

Steps to Set Up KDE Connect:

1. Install KDE Connect Chrome Extension
   • Open Chrome in the required profile.
   • Install KDE Connect Extension → KDE Connect Chrome
2. Install KDE Connect on Android
   • Download from Google Play Store.
3. Pair Your Devices
   • Open the Android app → Find & pair your PC.
   • Approve the connection on both devices.
4. Enable Notification Sync
   • On Android: Go to Settings → Notification Sync → Enable.
   • Select Chrome as a source.

Now, Chrome notifications (including Microsoft Teams) will be forwarded to your Android device.

Solution 3: Use Microsoft's "Your Phone" App (Windows Users)

If you're using Windows, Microsoft’s Phone Link (Your Phone Companion) can sync Teams notifications to Android.

Steps:

1. Install "Your Phone" on Windows
   • Download from Microsoft Store → Your Phone
   • Log in with the same Microsoft account.
2. Install "Link to Windows" on Android
   • Download from Google Play Store.
3. Enable Notification Sync
   • Open "Your Phone" on PC → Settings → Enable Notifications.

You will now receive Teams notifications from your Chrome profile on your Android device.

I have been searching the internet since very long and used some of the providers hosting raja, host gator and few others in the past. But recently i figured out Milesweb.com is a perfect fit for me and it serves my purpose of local routing which giver better response time and my clients are happy.

Link : www.milesweb.com

Their shared hosting Plan starts for ₹59/m upto ₹599/m when you buy for three years together and it will be beneficial , if you are planning for multiple site hosting.

The most effective plan i think is Elite ₹119/m

All of a sudden one of my wordpress site went down and a got a down status alert from betterstack. My first suspicion goes as some attack happened.

By drilling down the logs and status of the services I figured out that almost 10+ processes untilising high CPU and those are from wordpress file locations with daemon as the user and these process are running as daemons .

Eventhough i have a crontab to restart all services once in a day , irrespective of that the apache php-fpm mariadb services were down.

Realised that the high utlising process are ELF executable files and it needs to removed and the process to be killed.

Now this is started repeating and i am cleaning it up now , but how about for future ? Working on finding a permanent solution...

Found ELF file:

rate_accept03
xml_domit_xpath
sp_config
AttrTypes
lib_ajax_admin
viva_zoom
config_clicks
forgot_mail
phocagallerycos
livehelp_step1
project.inc
database.mysqli
com_wrapper
mygroupperm
core.rm_auto

daemon     17812  0.0  0.0   2576     0 ?        S    Dec10   0:00 sh -c /opt/bitnami/wordpress/wp-includes/art/bandarqq/sp_config > /dev/null 2>&1
daemon     17813  3.2  0.0  22048     4 ?        R    Dec10 434:50 /opt/bitnami/wordpress/wp-includes/art/bandarqq/sp_config
daemon     19632  0.0  0.0   2576     0 ?        S    Dec10   0:00 sh -c /opt/bitnami/wordpress/wp-includes/l10n/viva_zoom > /dev/null 2>&1
daemon     19633  3.0  0.0  22704     4 ?        R    Dec10 416:21 /opt/bitnami/wordpress/wp-includes/l10n/viva_zoom
daemon     92992  0.0  0.0   2576     0 ?        S    Dec10   0:00 sh -c /opt/bitnami/wordpress/wp-includes/php-compat/database.mysqli > /dev/null 2>&1
daemon     92993  3.1  0.0  23360     4 ?        R    Dec10 427:14 /opt/bitnami/wordpress/wp-includes/php-compat/database.mysqli
daemon    111178  0.0  0.0   2576     0 ?        S    Dec10   0:00 sh -c /opt/bitnami/wordpress/wp-includes/images/crystal/core.rm_auto > /dev/null 2>&1
daemon    111179  3.3  0.0  21392     4 ?        R    Dec10 441:18 /opt/bitnami/wordpress/wp-includes/images/crystal/core.rm_auto
daemon    549029  0.0  0.0   2576     0 ?        S    Dec11   0:00 sh -c /opt/bitnami/wordpress/wp-includes/js/swfupload/AttrTypes > /dev/null 2>&1
daemon    549030  2.9  0.0  20408     4 ?        R    Dec11 380:10 /opt/bitnami/wordpress/wp-includes/js/swfupload/AttrTypes
daemon   2177938  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-includes/blocks/column/phocagallerycos > /dev/null 2>&1
daemon   2177939 10.4  0.0    564     4 ?        R    Dec18 306:48 /opt/bitnami/wordpress/wp-includes/blocks/column/phocagallerycos
daemon   2224076  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks > /dev/null 2>&1
daemon   2224077 10.6  0.0  18932     4 ?        R    Dec18 310:11 /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks
daemon   2346064  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks > /dev/null 2>&1
daemon   2346065 17.3  0.0   2696     4 ?        R    Dec18 493:15 /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks
daemon   2427842  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-includes/blocks/column/phocagallerycos > /dev/null 2>&1
daemon   2427843 15.5  0.0    400     4 ?        R    Dec18 434:56 /opt/bitnami/wordpress/wp-includes/blocks/column/phocagallerycos
daemon   2431072  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-admin/css/colors/ocean/xml_domit_xpath > /dev/null 2>&1
daemon   2431074 15.6  0.0   5484     4 ?        R    Dec18 435:14 /opt/bitnami/wordpress/wp-admin/css/colors/ocean/xml_domit_xpath
daemon   2439593  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-admin/css/colors/ocean/xml_domit_xpath > /dev/null 2>&1
daemon   2439594 15.6  0.0   7124     4 ?        R    Dec18 435:22 /opt/bitnami/wordpress/wp-admin/css/colors/ocean/xml_domit_xpath
daemon   2481396  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks > /dev/null 2>&1
daemon   2481397 15.7  0.0   2860     4 ?        R    Dec18 435:03 /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks
daemon   2548247  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-includes/blocks/table/forgot_mail > /dev/null 2>&1
daemon   2548248 11.2  0.0   3844     4 ?        R    Dec18 307:55 /opt/bitnami/wordpress/wp-includes/blocks/table/forgot_mail
daemon   2633592  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-admin/css/colors/ocean/xml_domit_xpath > /dev/null 2>&1
daemon   2633593 14.5  0.0   2204     4 ?        R    Dec18 388:36 /opt/bitnami/wordpress/wp-admin/css/colors/ocean/xml_domit_xpath
daemon   2633907  0.0  0.0   2576     0 ?        S    Dec18   0:00 sh -c /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks > /dev/null 2>&1
daemon   2633908 14.5  0.0   2696     4 ?        R    Dec18 388:39 /opt/bitnami/wordpress/wp-includes/blocks/columns/config_clicks

Oh My ZSH for ITerm 2

Setup Zsh + Oh my Zsh + Powerlevel10k + Dracula theme with auto-suggestions and syntax-higlighting

Zsh (The Z shell) is an Unix shell that can be used as an interactive login shell and as a command interpreter for shell scripting. Zsh is…

MediumSatria Janaka

asdf , for multiple runtime manager like nodejs, ruby, python

Let's say you have the following data in Sheet1:

You want to filter this data to show only the rows where the Country is "USA".

In FilteredSheet, enter the following formula in cell A1:

FILTER(Sheet1!A:C, Sheet1!C:C = "USA")

This will filter and display only the rows where the Country is "USA" in the FilteredSheet.

Explanation:

• FILTER(range, condition): The FILTER function takes two arguments: the range of data to filter and the condition to apply.
• Sheet1!A:C: This specifies the range of data in Sheet1 from columns A to C.
• Sheet1!C:C = "USA": This specifies the condition to filter the data where the values in column C are "USA".

One of my wordpress site went down 20 days back and it is in the construction phase so i was less cared and didn't check for a while.

Last weekend I just tried to ssh the server and could not connect to it which is hosted in aws lightsail. I restarted the server and after 5 mins I got into the server and checked all the services like webmin, mysqld etc. Everything looks fine and the site came up and was able to browse the pages. But, after 5 mins again it went down and I went and checked I was able to ssh and was curious is there any malicious script is blocking the site or keeping the server busy, got no clue.

Finally today I found in the access log of the site and understood that it was under attack by crawlers and bots of facebookexternalhit and mj12bot . With the below given links I was not able to bring down the traffic. Like htaccess or robots.txt file did not help.

85.208.96.204 - - [03/Jul/2024:04:41:48 +0000] "GET /shop/page/1/?filter_flavor=robust%2Chigh%2Cvery-low%2Coriginal%2Csugar-free%2Clow&lay_style=3&query_typ
e_flavor=or&shop_layout=4 HTTP/1.1" 301 4326 "-" "Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)"
95.91.111.56 - - [03/Jul/2024:04:41:47 +0000] "GET /size/5-5oz-20-servings/?filter_flavor=sugar-free,very-low&query_type_flavor=or&lay_style=1 HTTP/1.1" 200
 252260 "-" "Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)"

https://webmasters.stackexchange.com/questions/129316/trying-to-determine-if-bot-crawling-my-site-is-malicious-mj12bot

https://wordpress.org/support/topic/facebookexternalhit-1-1-thousands-of-requests/

https://stackoverflow.com/questions/9773954/why-facebook-is-flooding-my-site

https://developers.facebook.com/community/threads/974370274080457/

We hosted our dns in cloudflare and it sparked the idea to explore and see any option for this. Found the WAF rules will help to sort the issue . Configured the custom rules to block the useragent of above mentioned bots. Still the traffic did not came down. After a while understood that to use the cloudflare rules , I should enable the proxy in DNS entries. Soon after this the traffic literally came down and I could see there are no entries anymore regarding the bots. Uff !!!

If any of you face such issues do let me know in the comments how did you solve or even you can suggest good solutions to the above said issue.

In the recent days I always wanted to have a Sample app or an example app which should expose Rest API and also it should be dockerised.

Eventhough there are many source codes available in github it hardly works as certain dependencies might have been outdated. Hence I found a recent code , forked and created my own dockerfile and tested with a docker compose.

So anyone can use this source code to test RestAPI , docker deployments for CICD, or practise for ECS and Kuberenetes deployments with any managed services like EKS, AKS, GKE

Repo Url: https://github.com/reyparthi/springboot_crud_postgres

From the Readme

Prerequisite

Docker Desktop

Test in Local

docker compose up -d

By using postman or curl you can verify the app,

GET: http://localhost:8080/api/v1/employees

POST: http://localhost:8080/api/v1/employees

{
    "firstName" : “Test”,
    "lastName" : “User”,
    "email" : “testemail@example.app"
}

If the Post creation works , then you can also verify the postgres db for entries in the employee table.

If you have any queries do post in the comment , I am happy to help.

Disposable email addresses are temporary email addresses that self-destruct after a certain period or after a single use. They serve various purposes:

1. Spam Prevention: Disposable emails can be used to avoid spam. When you need to register for a service or website that you suspect might send unwanted emails, a disposable email can keep your primary inbox clean.
2. Privacy Protection: Using a disposable email can help protect your identity and personal information. If you don't trust a website or service with your real email, a disposable email provides an extra layer of privacy.
3. Testing and Development: Developers and testers use disposable emails to test applications, especially those that require email verification. This avoids cluttering real email accounts with test data.
4. Temporary Use: For one-time transactions or short-term engagements, such as signing up for a newsletter to get a discount code, a disposable email is convenient and practical.
5. Reducing Digital Footprint: By using disposable emails, you can reduce your digital footprint and avoid having your personal email address stored in numerous databases, which could be vulnerable to data breaches.
6. Avoiding Subscription Overload: When signing up for multiple services or newsletters, disposable emails can help manage and limit the influx of emails to your main inbox.

Despite these advantages, it's important to note that some services block or limit the use of disposable emails to ensure genuine sign-ups and reduce misuse.

Some of the famous service I use are

1. https://wowmail.app
2. https://yopmail.com

Heroku Alternatives

Dokku - The smallest PaaS implementation you’ve ever seen

Dokku

CapRover · Scalable, Free and Self-hosted PaaS!

Scalable, Free and Self-hosted PaaS!

Sql Based Api

Latitude | Developer-first embedded analytics

Latitude is an embedded analytics framework designed with developers in mind. It integrates seamlessly with your database or data warehouse, leveraging SQL and straightforward frontend components.

Developer-first embedded analytics

Open source Schedulers

GitHub - jhuckaby/Cronicle: A simple, distributed task scheduler and runner with a web based UI.

A simple, distributed task scheduler and runner with a web based UI. - jhuckaby/Cronicle

GitHubjhuckaby

Cronicle

A simple distributed task scheduler and runner.

Joseph Huckaby

https://dolphinscheduler.apache.org/en-us

Apache DolphinScheduler is a distributed and extensible open-source workflow orchestration platform with powerful DAG visual interfaces

Getting Started — Luigi 3.5.0 documentation

Luigi

Luigi is a Python (3.6, 3.7, 3.8, 3.9, 3.10, 3.11, 3.12 tested) package that helps you build complex pipelines of batch jobs. It handles dependency resolution, workflow management, visualization, handling failures, command line integration, and much more

Github Action gives my this error for the last "run: npm run build"

FATAL ERROR: Reached heap limit Allocation failed - JavaScript heap out of memory
Error: Process completed with exit code 1.

Solution is to update the workflow with these additional details

run

jobs:
  make-love:
    steps:
      - name: "Just do it"
        run: |
        export NODE_OPTIONS="--max_old_space_size=4096"
        npm start

env

jobs:
  make-love:
    steps:
      - name: "Nothing is impossible"
        env:
          NODE_OPTIONS: "--max_old_space_size=4096"
        run: npm start

gzip for mac - https://support.apple.com/en-in/guide/terminal/apdc52250ee-4659-4751-9a3a-8b7988150530/mac

For the below list of values I want to group by Coin(Market) and Average the values ( Price) of each coin .

First I have to get the Coins in Unique and we can use the below formula

=UNIQUE(B7:B14)

The result is

Now I have to calculate the average of each coins that i purchased, for that I can apply the below formulat using AVERAGEIF

=AVERAGEIF($B$7:$B$14, H7, $D$7:$D$14)