--- type: "blog_post_list" url: "https://www.ytyng.com/en" page: 9 per_page: 20 total: 344 lang: "en" --- # Blog posts - [Display the Number of Upgradable Packages in Ubuntu (apt)](https://www.ytyng.com/en/blog/ubuntu-apt-show-updatable-package-number) _2021-01-10T07:50:50Z_ When you log in to Ubuntu via SSH, you see the following message: "10 packages can be updated. 5 updates are security updates." - [Connecting to MySQL 8.0 with SSL Mode Disabled (ERROR 2026 (HY000): SSL Connection Error: Error Handling)](https://www.ytyng.com/en/blog/mysql-error-2026-hy000-ssl-connection-error) _2021-01-01T12:28:03Z / MySQL_ When trying to connect MySQL Client 8.0 to MySQL 5.6, DataGrip displays an error message: "[08S01] Communications link failure java.io.EOFException: SSL peer shut down incorrectly," and the connection fails. - [Import the p12 Certificate from App Store Connect by Dragging and Dropping into Keychain Access.](https://www.ytyng.com/en/blog/xcode-cert-keychain-import-drag-and-drop) _2020-11-30T05:37:50Z / mac_ Distinguish 'draft' vs 'published' state for a Mezzanine BlogPost while editing — handling in both Admin and templates. - [Installing k3s Kubernetes on Raspberry Pi (Raspbian)](https://www.ytyng.com/en/blog/raspberry-pi-raspbian-install-k3s-kubernetes) _2020-11-23T07:58:10Z / Raspberry-Pi, kubernetes_ Install k3s (a lightweight Kubernetes distribution) on a Raspberry Pi (Raspbian) and bring up a single-node cluster — step-by-step. - [mysql django.db.utils.InterfaceError: (0, '')](https://www.ytyng.com/en/blog/mysql-djangodbutilsinterfaceerror-0) _2020-11-08T10:53:38Z / Django, MySQL_ If you encounter the django.db.utils.InterfaceError: "(0, '')" error When this error occurs intermittently during get operations depending on the table or record, it might be due to a mismatch in the connection character encoding. - [NameError: name '_mysql' is not defined in Python (Django) (Especially During Local Development)](https://www.ytyng.com/en/blog/python-name-error-mysql-_mysql-is-not-defined) _2020-10-11T02:52:50Z / Django, MySQL, Python_ If a Django project that has been working until now fails to start after a long time with the following error: ``` version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined ``` - [A TypeScript Decorator to Show a Toast When $axios.$get Fails in an Async Method with Nuxt](https://www.ytyng.com/en/blog/nuxt-でasync-メソッド内の-axiosget-が失敗した時トーストを表示する-typescript-デコレーター) _2020-10-07T12:49:56Z / Javascript, nuxt_ This article introduces a TypeScript decorator code that displays a toast notification when the $axios.$get method fails within an async method in a Nuxt.js application. - [Starting Django on Docker Alpine Results in django.db.utils.OperationalError: (2000, 'Unknown MySQL error')](https://www.ytyng.com/en/blog/docker-alpine-djangodbutilsoperationalerror-2000-unknown-mysql-error) _2020-09-13T06:57:54Z / Django_ When running `python3 ./manage.py runserver 8080`, I encountered the error `django.db.utils.OperationalError: (2000, 'Unknown MySQL error')`. This error occurs when the `OPTIONS` setting includes `'charset': 'utf8mb4'`. - [Logging in via Jump Host with i2cssh](https://www.ytyng.com/en/blog/i2cssh-bastion-xt) _2020-08-21T08:19:48Z / mac_ Configure `~/.i2csshrc` so the `i2cssh` command can fan out SSH connections through a bastion / jump host to multiple servers. - [mkmf.rb can't find header files for ruby (Error while trying to install i2cssh)](https://www.ytyng.com/en/blog/mkmfrb-cant-find-header-files-for-ruby-i2cssh-をインストールしようとしてエラー) _2020-07-24T05:36:19Z / mac_ Resolve `mkmf.rb can't find header files for ruby` when installing the `i2cssh` Ruby gem — install `ruby-dev` (or `ruby-headers`) and retry the gem install. - [Python Script for Storing ECR Login Information as Kubernetes Secrets](https://www.ytyng.com/en/blog/ecrのログイン情報をkubernetes-の-secrets-として保存する-pythonスクリプト) _2020-07-13T11:39:22Z_ Introduction to Python Script Code - [Git Checkout Using Partial Branch Name Matching](https://www.ytyng.com/en/blog/git-checkout-contains) _2020-07-13T07:07:48Z_ Pitfalls when running a local server with `php -S` on macOS Big Sur or later, and how to terminate SSL with a separate proxy. - [Upgrading to Ubuntu 20 Results in ERROR 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol](https://www.ytyng.com/en/blog/ubuntu-mysql-ssl-failed) _2020-06-01T01:18:08Z_ I upgraded Ubuntu to version 20.04, and when I tried to connect to MySQL, I encountered the following error: ERROR 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol. As a result, I was unable to connect to MySQL. - [Manually Operating Viewsets in Django Rest Framework to Retrieve Serialized Data](https://www.ytyng.com/en/blog/django-rest-framework-の-viewset-を手動で動かしてシリアライズ済みデータを取得する) _2020-05-19T06:34:41Z / Django_ Introduction to Python Code for APIView. - [対応方法 When MySQL AutoIncrement Runs Out](https://www.ytyng.com/en/blog/mysql-autoincrement-failed-to-read) _2020-05-18T02:16:05Z / Django_ MySQLdb._exceptions.OperationalError: (1467, 'Failed to read auto-increment value from storage engine') In Django, when you specify an implicit id, the above error occurs if the auto increment value reaches its upper limit. - [Outputting Request Headers in Nginx Logs](https://www.ytyng.com/en/blog/nginx-log-request-headers) _2020-05-06T14:24:27Z / nginx_ Output every request header and response info to the nginx access log via a custom `log_format`, with an Ansible playbook to deploy it. - [The App Crashes When Using FlutterDownloader.initialize() with flutter_downloader](https://www.ytyng.com/en/blog/flutter-downloader-crashed-when-initialize) _2020-02-12T06:35:41Z_ While using flutter_downloader 1.3.4 with Flutter, the app crashes at await FlutterDownloader.initialize() when debugging from Android Studio. However, the app does not crash when launched from XCode. If anyone knows how to fix this, please let me know. - [HTTP 413 Error When Uploading Files in Kubernetes Environment](https://www.ytyng.com/en/blog/kubernetes-環境でファイルアップロード時http413になる) _2020-01-14T06:34:10Z / kubernetes_ Open a specific 1Password item directly from the Mac terminal with `open 'onepassword://...'` — also how to get the item URL. - [When Using Nuxt Axios Proxy Mode, Axios Config's httpsAgent Injection Cannot Handle Self-Signed Certificates on the Proxy Server](https://www.ytyng.com/en/blog/nuxt-axios-https-self-signed) _2020-01-02T11:53:39Z / nuxt_ Fix `ssl.SSLCertVerificationError` in Django `send_mail` — check `EMAIL_USE_SSL` / `EMAIL_USE_TLS` and certificate trust chain. - [対応方法 for Cross-Origin Session Cookies Not Being Sent After Upgrading to Django 3](https://www.ytyng.com/en/blog/django3-cross-origin-session-cookie-no-send) _2019-12-30T12:27:56Z_ Hide apps that an `is_staff` user has no permission for in the Django admin — override `get_app_list` to filter the visible app list.