2018-07-16

Service worker and 401 authorization

What happens


  • The website area (/admin) is protected by an `htpasswd` authorization (Apache: AuthType Basic, Require valid-user, etc.).
  • A "standard" service worker script is loaded at the home page, doing its usual stuff (install, fetch, cache).
  • When you go to the protected page, you are not asked for the user/password, but see the "Not Authorized" message immediately.
  • If you clear the service worker (in Chrome, F12 - Application - Clear storage), you can enter the admin area.

One way to cure

Your service-worker.js script probably has a piece of code that looks like:

self.addEventListener('fetch', event => {
    // Let the browser do its default thing
    // for non-GET requests.
    if (event.request.method !== 'GET') {
        return;
    }

Add the following lines immediately after that part:

    // Exclude admin panel.
    if (0 === event.request.url.indexOf("https://www.my-site.com/admin")) {
        return;
    }

It should help.

2018-06-21

Currency conversion in Google Sheets using the GoogleFinance function

Formula:


[A2] --> =INDEX(GoogleFinance("CURRENCY:USDCAD","price",A2),2,2)

Example:




2018-03-06

ACE Editor: submit, beautify and minify

A code example to use ACE Editor in HTML form, submit minified JS and CSS and beautify it.
This is just a sketch. The server side is not shown.

Developed for use in the WPGlobus Multilingual WordPress plugin's options panel.



2018-01-04

Cygwin: Permissions 0660 for '~/.ssh/id_rsa' are too open.

Environment:

  • MS Windows 8.1
  • Cygwin 64bit
  • ssh keys copied from somewhere and placed to ~/.ssh/

Problem:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@         WARNING: UNPROTECTED PRIVATE KEY FILE!          @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Permissions 0660 for '~/.ssh/id_rsa' are too open.
It is required that your private key files are NOT accessible by others.
This private key will be ignored.
bad permissions: ignore key: ~/.ssh/id_rsa

Did not work:

  • chmod 600 id_rsa
  • chmod 700 .ssh
  • Playing with Windows security panels
  • Setting group to SYSTEM
  • Everything else

Solution:

Found on Vineet Gupta's blog http://vineetgupta.com/blog/cygwin-permissions-bug-on-windows-8

chgrp Users id_rsa
chmod 600 id_rsa

Now, all works. Thank you, Vineet!