DEV Community: Noriko Yamamoto

How to Remove Trailing Slashes in SlimPHP Routes Using Middlewares\TrailingSlash

Noriko Yamamoto — Wed, 14 May 2025 18:28:07 +0000

composer require middlewares/trailing-slash

use Middlewares\TrailingSlash;

$app->add(new TrailingSlash()->redirect($app->getResponseFactory()));

FYI: https://github.com/middlewares/trailing-slash

How to use Application Default Credentials on CGP Cloud Run for Google Drive API

Noriko Yamamoto — Tue, 26 Dec 2023 18:55:21 +0000

Step 1. Create service account.

Step 2. Set the service account to Cloud Run security settings.

Step 3. Share a Google Drive folder (or a file) to the service account email address.

see also :
- https://developers.google.com/identity/protocols/application-default-credentials
- (for PHP) https://github.com/googleapis/google-api-php-client

What to do when you receive a message from GitHub saying WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!

Noriko Yamamoto — Sun, 26 Mar 2023 23:56:01 +0000

If you pish to GitHub and receive a message like this:

% git push
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@    WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that a host key has just been changed.
The fingerprint for the RSA key sent by the remote host is
SHA256:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.
Please contact your system administrator.
Add correct host key in /Users/xxxx/.ssh/known_hosts to get rid of this message.
Offending RSA key in /Users/xxxx/.ssh/known_hosts:2
Host key for github.com has changed and you have requested strict checking.
Host key verification failed.
fatal: Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.

By using the following command, you can remove all keys belonging to GitHub from the known_hosts file.

$ ssh-keygen -R github.com

After that, you will have a successful push.

How to switch multiple accounts for GCP gcloud command

Noriko Yamamoto — Sat, 15 Oct 2022 20:49:05 +0000

If you have two accounts below:

Sample account 1
- config name: account1
- project ID: hoge-fuga-123
- account: sample@account1.sample
Sample account 2
- config name: account2
- project ID: hoge-fuga-456
- account: sample@account2.sample

STEP 1. create configuration set for account1

% gcloud config configurations create account1
Created [account1].
Activated [account1].

% gcloud config set project hoge-fuga-123
Updated property [core/project].

% gcloud config set account sample@account1.sample
Updated property [core/account].

STEP 2. create configuration set for account2

% gcloud config configurations create account2
Created [account2].
Activated [account2].

% gcloud config set project hoge-fuga-456
Updated property [core/project].

% gcloud config set account sample@account2.sample
Updated property [core/account].

STEP 3. switch to account1 and check config

% gcloud config configurations activate account1
Activated [account1].

% gcloud config list
[core]
account = sample@account1.sample
disable_usage_reporting = False
project = hoge-fuga-123

Your active configuration is: [account1]

STEP 4. switch to account2 and check config

% gcloud config configurations activate account2
Activated [account2].

% gcloud config list
[core]
account = sample@account2.sample
disable_usage_reporting = False
project = hoge-fuga-456

Your active configuration is: [account2]

GCP original reference page: https://cloud.google.com/sdk/gcloud/reference/config/configurations/

How to install ImageMagick to Cloud Functions PHP

Noriko Yamamoto — Tue, 26 Jul 2022 11:16:42 +0000

Put the php.ini file with extension=imagick.so.
That's it!

And also, you can install Memcached, gRPC, protobuf, MongoDB, OpenCensus and PHPRedis to Cloud Functions PHP in the same way😉
https://cloud.google.com/appengine/docs/standard/php-gen2/runtime#dynamically_loadable_extensions

How to create my SlideShare URL

Noriko Yamamoto — Wed, 06 Jan 2021 17:26:52 +0000

These days the SlideShare account is created by LinkedIn account.
And they create my SlideShare URL from my name of LinkedIn automatically.
But I wanted to create my SlideShare URL with my username ( nauleyco ).

At first, I changed my name on LinkedIn with below.
First name : nau
Last name : leyco

And then, I sign up to SlideShare with my LinkedIn account.

I could see my SlideShare URL as below.
https://www.slideshare.net/nauleyco

After that, I changed my name on LinedIn back.
(*) Don't forget!!!

How to convert your name to Japanese Katakana.

Noriko Yamamoto — Thu, 24 Sep 2020 02:15:52 +0000

If you want to convert your name to Japanese Katakana ( same meaning as Kana, カタカナ, カナ ), you can use the Google translate.

Input your name on the Google translate, and then check the pronounce by the Speaker icon.

i.g. ) John Smith -> ジョンスミス
https://translate.google.com/#view=home&op=translate&sl=auto&tl=ja&text=John%0ASmith

How to write the original IP in the Apache log even via Cloudflare and Google Cloud Load Balancing (GCP LB)

Noriko Yamamoto — Mon, 14 Sep 2020 03:07:28 +0000

Follow the Cloudflare Document below.

Restoring original visitor IPs: Logging visitor IP addresses with mod_cloudflare
https://support.cloudflare.com/hc/en-us/articles/200170786-Restoring-original-visitor-IPs-Logging-visitor-IP-addresses-with-mod-cloudflare-

And then, Add 35.191.0.0/16 and 130.211.0.0/22 for CloudFlareRemoteIPTrustedProxy.

<IfModule cloudflare_module>
    CloudFlareRemoteIPHeader X-Forwarded-For
    CloudFlareRemoteIPTrustedProxy 35.191.0.0/16
    CloudFlareRemoteIPTrustedProxy 130.211.0.0/22
    CloudFlareRemoteIPTrustedProxy [your load balancer’s IP]
</IfModule>

After restart httpd, You will see the original visitor IPs on your apache access logs.

FYI: GCP Document of External HTTP(S) Load Balancing Source IP addresses
https://cloud.google.com/load-balancing/docs/https#source_ip_addresses

How to connect to MS SQL Server 2000 in PHP7 PDO on CentOS 7

Noriko Yamamoto — Wed, 17 Jun 2020 16:21:50 +0000

As a premise, php and pdo are installed.

At first, install nixODBC-devel and freetds and php-odbc.

$ sudo yum -y install unixODBC-devel
$ sudo yum -y install freetds
$ sudo yum -y install php-odbc

And then, edit /etc/odbcinst.ini

$ sudo vi /etc/odbcinst.ini

[/etc/odbcinst.ini]:

[FreeTDS]
Description = ODBC for FreeTDS
Driver64    = /usr/lib64/libtdsodbc.so
Setup64     = /usr/lib64/libtdsodbc.so
FileUsage   = 1

Finally, create an PDO object as follows.

<?php
    $host = 'xxx.xxx.xxx.xxx';
    $port = '1433';
    $dbname = 'database-name';
    $username = 'username';
    $password = 'password';

    $dsn = "odbc:Driver=FreeTDS;" . 
        "SERVER={$host};PORT={$port};DATABASE={$dbname};" . 
        "ClientCharset=UTF-8";
    $pdo = new \PDO($dsn, $username, $password);

How to download a CSV file with Slim 4

Noriko Yamamoto — Fri, 13 Mar 2020 15:32:44 +0000

It's a sample code for CSV download with Slim 4.

<?php
declare(strict_types=1);

use Psr\Http\Message\ResponseInterface;
use Psr\Http\Message\ServerRequestInterface;

class DownloadCsvFIle extends Action
{
    public function __invoke(ServerRequestInterface $request, ResponseInterface $response, $args): ResponseInterface
    {
        $csv_file = '/path-to-the-csv-file/csvfilename.csv';

        $response = $response
            ->withHeader('Content-Type', 'application/octet-stream')
            ->withHeader('Content-Disposition', 'attachment; filename=csvfilename.csv')
            ->withAddedHeader('Cache-Control', 'no-store, no-cache, must-revalidate, max-age=0')
            ->withHeader('Cache-Control', 'post-check=0, pre-check=0')
            ->withHeader('Pragma', 'no-cache')
            ->withBody((new \Slim\Psr7\Stream(fopen($csv_file, 'rb'))));

        return $response;
    }
}

keyword: slim, slim4, psr-7, csv, download, file download, stream