fatal: Authentication failed for リモートURL

git config remote.origin.url https://username@github.com/username/repository.git

substring_index(分割対象の文字列, 区切り文字, 返す文字列の数)

mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2);
+------------------------------------------+
| SUBSTRING_INDEX('www.mysql.com', '.', 2) |
+------------------------------------------+
| www.mysql                                |
+------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', -2);
+-------------------------------------------+
| SUBSTRING_INDEX('www.mysql.com', '.', -2) |
+-------------------------------------------+
| mysql.com                                 |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT SUBSTRING_INDEX('user@mysql.com', '@', -1);
+--------------------------------------------+
| SUBSTRING_INDEX('user@mysql.com', '@', -1) |
+--------------------------------------------+
| mysql.com                                  |
+--------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('www.mysql.com', '.', 2), '.', -1);
+--------------------------------------------------------------------+
| SUBSTRING_INDEX(SUBSTRING_INDEX('www.mysql.com', '.', 2), '.', -1) |
+--------------------------------------------------------------------+
| mysql                                                              |
+--------------------------------------------------------------------+
1 row in set (0.00 sec)

SELECT
  SUBSTRING_INDEX(email, '@', -1) as domain,
  COUNT(*)
FROM
  users
GROUP BY
  domain
;

http://ftp.scientificlinux.org/linux/scientific/6.5/x86_64/os/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"

# more /etc/redhat-release
Scientific Linux release 6.5 (Carbon)

# ls /etc/yum.repos.d/
epel-testing.repo  mirrors-rpmforge-extras   sl-other.repo
epel.repo          mirrors-rpmforge-testing  sl.repo
mirrors-rpmforge   rpmforge.repo             sl6x.repo

# yum update
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
 * sl: ftp.scientificlinux.org
 * sl-security: ftp.scientificlinux.org
 * sl6x: ftp.scientificlinux.org
 * sl6x-security: ftp.scientificlinux.org

http://ftp.scientificlinux.org/linux/scientific/6.5/x86_64/os/repodata/repomd.xml

baseurl=http://ftp.scientificlinux.org/linux/scientific/$releasever/$basearch/os/

:%s/\/scientific\//\/scientific\/obsolete\//g

# yum update
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
 * sl: ftp.scientificlinux.org
 * sl-security: ftp.scientificlinux.org
 * sl6x: ftp.scientificlinux.org
 * sl6x-security: ftp.scientificlinux.org
sl                                                       | 3.6 kB     00:00
sl-security                                              | 2.9 kB     00:00
sl6x                                                     | 3.7 kB     00:00
sl6x-security                                            | 2.9 kB     00:00
Setting up Update Process
Resolving Dependencies
...
（省略）
...
Is this ok [y/N]: N
Exiting on user Command

This is a restricted browser page.
React devtools cannot access this page.

If you opened a local html file in your browser (file://...) then you must first open chrome extensions and check off "Allow access to file URLs".

Traceback (most recent call last):
	2: from /usr/local/bin/bundle:23:in `<main>'
	1: from /usr/local/lib/ruby/2.6.0/rubygems.rb:302:in `activate_bin_path'
/usr/local/lib/ruby/2.6.0/rubygems.rb:283:in `find_spec_for_exe': Could not find 'bundler' (2.2.15) required by your /app/Gemfile.lock. (Gem::GemNotFoundException)
To update to the latest version installed on your system, run `bundle update --bundler`.
To install the missing version, run `gem install bundler:2.2.15`
!! exit status 1

$ docker-compose run --rm web gem install bundler
Creating app_web_run ... done
Traceback (most recent call last):
	2: from /usr/local/bin/bundle:23:in `<main>'
	1: from /usr/local/lib/ruby/2.6.0/rubygems.rb:302:in `activate_bin_path'
/usr/local/lib/ruby/2.6.0/rubygems.rb:283:in `find_spec_for_exe': Could not find 'bundler' (2.2.15) required by your /app/Gemfile.lock. (Gem::GemNotFoundException)
To update to the latest version installed on your system, run `bundle update --bundler`.
...
（中略）
...
To install the missing version, run `gem install bundler:2.2.15`
!! exit status 1

$ docker-compose run --rm web bundle update --bundler
Creating app_web_run ... done
Traceback (most recent call last):
	2: from /usr/local/bin/bundle:23:in `<main>'
	1: from /usr/local/lib/ruby/2.6.0/rubygems.rb:302:in `activate_bin_path'
/usr/local/lib/ruby/2.6.0/rubygems.rb:283:in `find_spec_for_exe': Could not find 'bundler' (2.2.15) required by your /app/Gemfile.lock. (Gem::GemNotFoundException)
To update to the latest version installed on your system, run `bundle update --bundler`.
To install the missing version, run `gem install bundler:2.2.15`
!! exit status 1

$ ruby -v
ruby 2.7.2p137 (2020-10-01 revision 5445e04352) [x86_64-darwin17]
$ cat .ruby-version
2.7.2

$ bundler --version
Bundler version 2.1.4

$ bundle update --bundler
Warning: the running version of Bundler (2.1.4) is older than the version that created the lockfile (2.2.15). We suggest you to upgrade to the version that created the lockfile by running `gem install bundler:2.2.15`.

$ docker-compose down --rmi all --volumes
Removing app_web_1 ... done
Removing app_db_1  ... done
Removing network app_default
Removing volume app_mysql-data
Removing volume app_bundle
Removing image mysql:5.7
Removing image app_web

docker-compose up
Creating network "app_default" with the default driver
Creating volume "app_mysql-data" with default driver
Creating volume "app_bundle" with default driver
Pulling db (mysql:5.7)...
5.7: Pulling from library/mysql
...
（中略）
...
Step 1/14 : FROM ruby:2.7.2
2.7.2: Pulling from library/ruby
004f1eed87df: Pull complete
5d6f1e8117db: Pull complete

docker-compose down --rmi all --volumes

docker-compose build

background: image-url("test/test.png") no-repeat;

@import 'test';

NoMethodError: undefined method `[]' for nil:NilClass

stack level too deep

$ mv test.scss _test.scss

[
  {
    "name": "id",
    "type": "STRING",
    "mode": "REQUIRED"
  },
  {
    "name": "created_date",
    "type": "DATE",
    "mode": "REQUIRED"
  }
]

$ bq mk --table --schema test.json --time_partitioning_field created_date project:dataset.test
Table 'project:dataset.test' successfully created.

テーブルタイプ　　　　　    分割
パーティショニングの基準    Day
フィールドで分割　　　　    created_date
パーティション フィルタ     不要

Selenium::WebDriver::Error::SessionNotCreatedError:
        session not created: This version of ChromeDriver only supports Chrome version 84

RUN yum install -y unzip \
    https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm && \
    sed -i 's|HERE/chrome"|HERE/chrome" --disable-dev-shm-usage --disable-setuid-sandbox --no-sandbox|g' \
    "/opt/google/chrome/google-chrome" && \
    cd /usr/local/src/ && \
    wget https://chromedriver.storage.googleapis.com/84.0.4147.30/chromedriver_linux64.zip && \
    unzip chromedriver_linux64.zip && \
    install chromedriver /usr/local/bin/

RUN yum install -y unzip \
    https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm && \
    sed -i 's|HERE/chrome"|HERE/chrome" --disable-dev-shm-usage --disable-setuid-sandbox --no-sandbox|g' \
    "/opt/google/chrome/google-chrome" && \
    cd /usr/local/src/ && \
    wget -O LATEST_RELEASE_ "https://chromedriver.storage.googleapis.com/LATEST_RELEASE_$(rpm -q --queryformat='%{Version}' google-chrome-stable | sed -e 's/[.][0-9]*$//')" && \
    wget "https://chromedriver.storage.googleapis.com/$(cat LATEST_RELEASE_)/chromedriver_linux64.zip" && \
    rm LATEST_RELEASE_ && \
    unzip chromedriver_linux64.zip && \
    install chromedriver /usr/local/bin/

wget -O LATEST_RELEASE_ "https://chromedriver.storage.googleapis.com/LATEST_RELEASE_$(rpm -q --queryformat='%{Version}' google-chrome-stable | sed -e 's/[.][0-9]*$//')" && \
wget "https://chromedriver.storage.googleapis.com/$(cat LATEST_RELEASE_)/chromedriver_linux64.zip" && \
rm LATEST_RELEASE_ && \

rpm -q --queryformat='%{Version}' google-chrome-stable

検索オプション
    rpm 検索の一般的な形式は:

    rpm {-q|--query} [select-options] [query-options]

    表示されるパッケージ情報の書式を指定することができる。   そうするために
    は、

      --qf|--queryformat QUERYFMT

    オプションを使う。 QUERYFMT  が書式文字列である。検索の書式は、標準的な
    printf(3)  の書式の修正である。書式は静的な文字列 (改行・タブ・その他の
    特殊文字の、C 言語の標準的な文字エスケープを含む)と、 printf(3)  型の書
    式文字列からなる。  しかし rpm は表示する型を既に知っているので、型指定
    は省略されるべきである。 代わりに {} で囲まれた、表示されるへッダーのタ
    グ名が使用される。    タグ名に大文字/小文字の区別はなく、タグ名の先頭の
    RPMTAG_ 部分も省略することができる。

# rpm -q --queryformat='%{Version}' google-chrome-stable
86.0.4240.75

# rpm -q google-chrome-stable
google-chrome-stable-86.0.4240.75-1.x86_64

's/[.][0-9]*$//'

$ echo '86.0.4240.75' | sed -e 's/[.][0-9]*$//'
86.0.4240

wget -O LATEST_RELEASE_ "https://chromedriver.storage.googleapis.com/LATEST_RELEASE_$(rpm -q --queryformat='%{Version}' google-chrome-stable | sed -e 's/[.][0-9]*$//')"

wget -O LATEST_RELEASE_ "https://chromedriver.storage.googleapis.com/LATEST_RELEASE_86.0.4240"

$ wget -O LATEST_RELEASE_ "https://chromedriver.storage.googleapis.com/LATEST_RELEASE_86.0.4240"
--2021-02-22 21:01:33--  https://chromedriver.storage.googleapis.com/LATEST_RELEASE_86.0.4240
接続要求を送信しました、応答を待っています... 200 OK
長さ: 12 [text/plain]
`LATEST_RELEASE_' に保存中

LATEST_RELEASE_                                        100%[=========================================================================================================================>]      12  --.-KB/s 時間 0s       

2021-02-22 21:01:33 (186 KB/s) - `LATEST_RELEASE_' へ保存完了 [12/12]

$ cat LATEST_RELEASE_ 
86.0.4240.22

$ wget "https://chromedriver.storage.googleapis.com/$(cat LATEST_RELEASE_)/chromedriver_linux64.zip"
--2021-02-22 21:14:24--  https://chromedriver.storage.googleapis.com/86.0.4240.22/chromedriver_linux64.zip
接続要求を送信しました、応答を待っています... 200 OK
長さ: 5456932 (5.2M) [application/zip]
`chromedriver_linux64.zip' に保存中

chromedriver_linux64.zip                               100%[=========================================================================================================================>]   5.20M  3.17MB/s 時間 1.6s     

2021-02-22 21:14:26 (3.17 MB/s) - `chromedriver_linux64.zip' へ保存完了 [5456932/5456932]

log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                  '$status $body_bytes_sent "$http_referer" '
                  '"$http_user_agent" "$http_x_forwarded_for" "$upstream_response_time" "$request_time"';

[12/Feb/2021:03:20:08 +0900]

require 'csv'

class NginxLog
  def initialize(raw)
    tmp = raw.gsub(' [', ' "').gsub('] ', '" ')
    @log = CSV.parse(tmp, col_sep: ' ', liberal_parsing: true).flatten
  end

  def remote_addr
    @log[0]
  end

  def x_forwarded_for_ips
    ips = @log[9].split(',').map &:strip
    ips.reject { |ip| ['-', 'unknown'].include? ip }
  end

  def remote_ips
    x_forwarded_for_ips << remote_addr
  end
end

log = '1.1.1.1 - - [12/Feb/2021:23:48:48 +0900] "GET / HTTP/1.1" 200 38485 "https://book-reviews.blog/" "Mozilla/5.0 (iPhone; CPU iPhone OS 14_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.2 Mobile/15E148 Safari/604.1" "2.2.2.2" "0.403" "0.404"'
nginx_log = NginxLog(log)
puts nginx_log.remote_ips
=> ["1.1.1.1", "2.2.2.2"]