mysql> select count from XOOPSDB__session;🆑
ERROR 145 (HY000): Table './XOOPSDB/XOOPSDB__session' is marked as crashed and should be repaired
mysql>

mysql> REPAIR TABLE XOOPSDB__session;🆑
+------------------------+--------+----------+----------+
| Table                  | Op     | Msg_type | Msg_text |
+------------------------+--------+----------+----------+
| xoops.xoopsdb__session | repair | status   | OK       |
+------------------------+--------+----------+----------+
1 row in set (0.09 sec)

mysql>

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

% 
% echo >> /Users/ujpadmin/.zprofile
% echo 'eval "$(/usr/local/bin/brew shellenv)"' >> /Users/ujpadmin/.zprofile
% eval "$(/usr/local/bin/brew shellenv)"
%

brew update
brew install tree
brew install wget
brew install coreutils
brew install imagemagick
brew install fontconfig
brew install nkf
brew install curl
brew install mrtg
brew install cowsay
brew install sl
brew install neofetch
brew install figlet

brew install cask
brew install --cask iTerm2
brew install smartmontools
brew install testdisk
brew install nginx
brew install telnet

brew install certbot

brew install rdfind

brew install gcc

brew install --cask temurin

brew install gnu-sed
brew install findutils

brew install exiftool
brew install ffmpeg
brew install cask makemkv
brew install cask iina
brew install vlc

brew install findomain
brew install iperf3
brew install masscan
brew install netcat
brew install nmap
brew install socat
brew install gobuster
brew install zap
brew install cask maltego

brew install --cask temurin@11

brew install --cask xquartz

sudo gem install iStats -n /usr/local/bin
cd
mkdir -p bin
cd bin
git clone http://github.com/possatti/pokemonsay
cd pokemonsay/
./install.sh

落札金額：4,400円
送料：910円
支払金額：5,310円

APN:sbm4glte
ユーザ名:data
パスワード:softbank

※5Gの場合は，APNをsb4gdualで設定すれば良い模様．

$ cat Softbank5G.mobileconfig🆑 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>ConsentText</key>
	<dict>
		<key>default</key>
		<string>ASEINet APN構成プロファイル</string>
	</dict>
	<key>PayloadContent</key>
	<array>
		<dict>
			<key>AttachAPN</key>
			<dict>
				<key>Name</key>
				<string>sb4gdual</string>🈁
				<key>AuthenticationType</key>
				<string>CHAP</string>
				<key>Username</key>
				<string>data</string>🈁
				<key>Password</key>
				<string>softbank</string>🈁
			</dict>
			<key>APNs</key>
			<array>
				<dict>
					<key>Name</key>
					<string>sb4gdual</string>🈁
					<key>AuthenticationType</key>
					<string>CHAP</string>
					<key>Username</key>
					<string>data</string>🈁
					<key>Password</key>
					<string>softbank</string>🈁
				</dict>
			</array>
			<key>PayloadDisplayName</key>
			<string>SoftBank / iPad（4G契約, sbm4glte）</string>
			<key>PayloadIdentifier</key>
			<string>com.aseinet.cellular</string>
			<key>PayloadOrganization</key>
			<string>ASEINet.NE.JP</string>
			<key>PayloadType</key>
			<string>com.apple.cellular</string>
			<key>PayloadUUID</key>
			<string>6B08253E-D5BB-4FC4-A5CD-825FB965B5AA</string>
			<key>PayloadVersion</key>
			<integer>1</integer>
		</dict>
	</array>
	<key>PayloadDisplayName</key>
	<string>ASEINet APN Profile (Ver. 1.2)</string>
	<key>PayloadDescription</key>
	<string>Apply APN-setting to your iOS device. iOSにAPN設定の適用を行います。</string>
	<key>PayloadIdentifier</key>
	<string>com.aseinet</string>
	<key>PayloadOrganization</key>
	<string>ASEINet.NE.JP</string>
	<key>PayloadRemovalDisallowed</key>
	<false/>
	<key>PayloadType</key>
	<string>Configuration</string>
	<key>PayloadUUID</key>
	<string>560EB0FF-BE89-46C7-8DC9-6CA77E1A4453</string>
	<key>PayloadVersion</key>
	<integer>1</integer>
</dict>
</plist>
$ 

#!/bin/bash

input_file="medialist.org"
success_file="seiko.txt"
error_file="shippai.txt"

# ファイルの初期化
> "$success_file"
> "$error_file"

# ファイルが存在するか確認
if [ ! -f "$input_file" ]; then
    echo "入力ファイルが見つかりません: $input_file"
    exit 1
fi

# 1行ずつ読み込み、NFDをUTF-8に変換
while IFS= read -r line; do
    if normalized_line=$(echo "$line" | iconv -f UTF-8-MAC -t UTF-8 2>/dev/null); then
        echo "$normalized_line" >> "$success_file"
    else
        echo "$line" >> "$error_file"
    fi
done < "$input_file"

echo "変換が完了しました。成功したデータは $success_file に、エラーになったデータは $error_file に保存されました。"

juno:Copilot ujpadmin$ bash henkan.sh
変換が完了しました。成功したデータは seiko.txt に、エラーになったデータは shippai.txt に保存されました。
juno:Copilot ujpadmin$

sh-3.2# DBbackup.sh
mysqldump: Got error: 145: Table './WEBDB/WEBDB__session' is marked as crashed and should be repaired when using LOCK TABLES
sh-3.2#

mysql> check table WEBDB__session;🆑
+------------------------+-------+----------+-------------------------------------------------------------------------------------------+
| Table                  | Op    | Msg_type | Msg_text                                                                                  |
+------------------------+-------+----------+-------------------------------------------------------------------------------------------+
| WEBDB.WEBDB__session | check | warning  | Table is marked as crashed                                                                |
| WEBDB.WEBDB__session | check | warning  | 13 clients are using or haven't closed the table properly                                 |
| WEBDB.WEBDB__session | check | warning  | Size of indexfile is: 913408      Should be: 659456                                       |
| WEBDB.WEBDB__session | check | error    | Invalid key block position: 270216091030151533  key block size: 1024  file_length: 659456 |
| WEBDB.WEBDB__session | check | error    | key delete-link-chain corrupted                                                           |
| WEBDB.WEBDB__session | check | error    | Corrupt                                                                                   |
+------------------------+-------+----------+-------------------------------------------------------------------------------------------+
6 rows in set (2.97 sec)

mysql>

mysql> repair table WEBDB__session;🆑
+------------------------+--------+----------+------------------------------------------+
| Table                  | Op     | Msg_type | Msg_text                                 |
+------------------------+--------+----------+------------------------------------------+
| WEBDB.WEBDB__session | repair | warning  | Number of rows changed from 1800 to 1797 |
| WEBDB.WEBDB__session | repair | status   | OK                                       |
+------------------------+--------+----------+------------------------------------------+
2 rows in set (0.29 sec)

mysql>

mysql> check table WEBDB__session;🆑
+------------------------+-------+----------+----------+
| Table                  | Op    | Msg_type | Msg_text |
+------------------------+-------+----------+----------+
| WEBDB.WEBDB__session | check | status   | OK       |
+------------------------+-------+----------+----------+
1 row in set (0.01 sec)

mysql>

$ sudo /Applications/Install\ macOS\ High\ Sierra.app/Contents/Resou
rces/createinstallmedia --volume /Volumes/HighSierra/🆑
Password:🔑
Ready to start.
To continue we need to erase the volume at /Volumes/HighSierra/.
If you wish to continue type (Y) then press return: y
Erasing Disk: 0%... 10%...
Error erasing disk error number (-69888, 0)
A error occurred erasing the disk.
$

$  sudo /Applications/Install\ macOS\ High\ Sierra.app/Contents/Resou
rces/createinstallmedia --volume /Volumes/HighSierra/🆑
Ready to start.
To continue we need to erase the volume at /Volumes/HighSierra/.
If you wish to continue type (Y) then press return: y
Erasing Disk: 0%... 10%... 20%... 30%...100%...
Copying installer files to disk...
Copy complete.
Making disk bootable...
Copying boot files...
Copy complete.
Done.
$

$ brew info inetutils🆑
==> inetutils: stable 2.5 (bottled)
GNU utilities for networking
https://www.gnu.org/software/inetutils/
Conflicts with:
  telnet (because both install `telnet` binaries)
  tnftp (because both install `ftp` binaries)
Not installed
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/i/inetutils.rb
License: GPL-3.0-or-later
==> Dependencies
Build: help2man ✘
Required: libidn2 ✔
==> Caveats
Only the following commands have been installed without the prefix 'g'.

    dnsdomainname
    ftp
    rcp
    rexec
    rlogin
    rsh
    telnet

If you really need to use other commands with their normal names,
you can add a "gnubin" directory to your PATH from your bashrc like:

    PATH="/usr/local/opt/inetutils/libexec/gnubin:$PATH"
==> Analytics
install: 2,235 (30 days), 5,250 (90 days), 11,931 (365 days)
install-on-request: 2,230 (30 days), 5,234 (90 days), 11,904 (365 days)
build-error: 0 (30 days)
$