Click here for "Error Codes for Commercial Air Conditioners".(Japanese Version)

OracleLinux9.3_en

OracleLinux9.3_en

OracleLinux9.3 ; OS Install

OracleLinux9.3 Oracle Linux provides a 100% application binary compatible alternative to Red Hat Enterprise Linux and  CentOS Linux for both hybrid and multi-cloud environments. Since 2006, Oracle Linux has been completely free to download and use. Source code, binaries and updates are provided free of charge. It is freely redistributable. Free for use in production environments. This time, we will proceed with the latest Oracle Linux 9.3.(November 15, 2023 Release) 1.Oracle Linux9.3 Download Oracle Linux 9.3 installation image (OracleLinux-R9-U3-x86_64-dvd.iso ) can be downloaded from the following site https://www.oracle.com/linux/
OracleLinux9.3_en

OracleLinux9.3 ; Initial settings after OS installation

1. Install bash completion extension package # dnf -y install bash-completion # reboot 2. Disabling SELinux First, disable selinux. selinux is a feature that improves auditing and security in Linux, but when enabled, it can limit the behavior of services and the contents of the configuration considerably. Therefore, it is basically a case of invalidation in many cases. SELinux operating modes Enforcing : SELinux functionality is enabled and access control is enabled Permissive : SElinux will warn, but no access restrictions will be placed disabled : Both SElinux function and access control are
OracleLinux9.3_en

OracleLinux9.3 ; SSH Remote connection , Firewalld , NTP Server

1. Setting up a remote connection via SSH SSH is a service for connecting remotely to a server and is basically running immediately after the OS is installed, but the default settings are somewhat insecure. Here we will configure the default settings to increase the security of SSH connections. 1.1 SSH service configuration file changes The SSH service configuration file is "/etc/ssh/sshd_config". 2. Firewall (Firewalld) settings In Oracle, the firewall is firewalld configured by default and enabled during OS installation. To briefly explain "firewalld," when setting communication control policies, communication permission/blocking rules are applied to predefined zones, and these zones are then assigned to each NIC (network adapter). 3. Remote connection from Windows Configuration in Windows Start the setup for remote connection from Windows, using "Tera Term" as the terminal emulator. Start Tera Term, cancel the startup screen, and then select "New Connection" from "File" in the Tera Term menu.
OracleLinux9.3_en

OracleLinux9.3 ; SSH connection with SSH key pair

SSH connection with authentication using public key  Creation of public and private key pairs Create a public/private key pair for a user connecting to the Linux server using OpenSSH. Use ssh-keygen to create key pairs. Creation of public/private key pairs is performed with remote login user privileges. If you do not specify the destination and file name, id_ed25519 and id_ed25519.pub will be created in /home/(user name)/.ssh/. On the way, enter the password for the key.
OracleLinux9.3_en

OracleLinux9.3 ; FTP Server , Samba FileServer Install

1. FTP Server 1.1 Vsftpd Install # dnf -y install vsftpd 1.2 Vsftpd configuration Save vsftpd.conf with .bak # cp /etc/vsftpd/vsftpd.conf /home/huong/vsftpd.conf.bak 2. vsftpd SSL/TLS Configure Vsftpd to use SSL/TLS 2.1 Create self-signed certificates This work is not required if you are using a trusted, legitimate certificate such as Let's Encrypt. 3. File server installation with Samba Build a file server with access rights that requires user authentication with Samba. Installation Procedure ①Create shared folders with access rights that require user authentication ②Accessible group creation ③Creation of users belonging to accessible groups ④Configuration File Edit
OracleLinux9.3_en

OracleLinux9.3; WEB Server (Apache)

1.Apache2 Install 1.1 httpd Install # dnf -y install httpd 1.3 Virtual Host Settings Assign and configure the domain name [FQDN] to the document root [/var/www/html/[FQDN]] directory for virtual host operation 2. Confirmation of CGI Script Usage ①Confirmation of CGI availability 3. PHP installation and configuration ①Install # dnf -y install php php-mbstring php-pear 4. Digest authentication with Apache2 Since Basic Authentication, a well-known authentication authorization method for http, sends authentication information in plain text, there is a risk of ID and password leakage if the packet is intercepted. On the other hand, Digest Authentication encrypts and transmits authentication information, so there is almost no risk of information leakage.
OracleLinux9.3_en

OracleLinux9.3 ; Clamav(anti-virus) , Mail Server

clamav(anti-virus) 1.Clam AntiVirus Install # dnf -y install clamav clamd clamav-update 2.Edit Clam AntiVirus configuration file Mail Server Installation 1. Postfix 1.1 Install Install Postfix and build an SMTP server # dnf -y install postfix Mail Server : Postfix + Clamav + clamav-milter+SpamAssassin 1.Real-time scanning of e-mails ①clamav-milter Install Virus checks are performed on the mail server side using Clam AntiVirus. The mail server and Clam AntiVirus are linked using clamav-milter.
OracleLinux9.3_en

OracleLinux9.3 ; SSL Certificate Acquisition( Let's Encrypt ) , WEB/Mail server SSL

1. SSL Certificate Acquisition ( Let's Encrypt ) Install the latest open ssl # dnf install openssl-devel 1.1 advance preparation 1.Package management system Snappy installation Since the SSL certificate issuing tool "certbot" of Let's Encrypt is recommended to be installed using "snap" after 2021, install Snapd first.(Can also be installed the traditional way with dnf or yum) 2. Converting Apache to https Install the following # dnf -y install mod_ssl 2.1 Edit ssl.conf file 3. SSL/TLS (Let's Encrypt) settings on the mail server 3.1 Obtaining a certificate for the mail server Obtain a certificate for the mail server, but it cannot be obtained in the same way as above, so the following with the "--standalone" option fails.
OracleLinux9.3_en

OracleLinux9.3 ; MySQL8 , WordPress Install

Mysql8 Install # dnf -y install mysql-server Create a new charset.cnf with the following contents WordPress Install 1. Create database for Word Press As an example, assume database [wp_db] database user [wp_user] password [?W123456]
OracleLinux9.3_en

OracleLinux9.3 ; Suricata , SNORT3 Install

Suricata SURICATA IDS/IPS is an open source IDS that monitors communications on the network and detects suspicious traffic. The basic mechanism is signature-based, so it can detect predefined unauthorized communications. Suricata is also characterized by its ability to provide protection as well as detection. SNORT3  Snort is an open source network intrusion detection system that can perform real-time traffic analysis and packet logging on IP networks. It can perform "protocol analysis," "content search," and "matching" and can be used to detect a variety of attacks such as buffer overflows, stealth port scans, CGI attacks, SMB probes, OS fingerprinting attempts, semantic URL attacks, and server message block probes. detection.
OracleLinux9.3_en

OracleLinux9.3 ; Tripwire , Chkrootkit , Logwatch , Disk Usage Check Script

Tripwire 1.Download and installation # cd /usr/local/src # wget https://rpmfind.net/linux/epel/9/Everything/x86_64/Packages/t/tripwire-2.4.3.7-13.el9.x86_64.rpm # rpm -Uvh tripwire-2.4.3.7-13.el9.x86_64.rpm Chkrootkit ①Download and install chkrootkit # cd /usr/local/src # wget https://launchpad.net/chkrootkit/main/0.55/+download/chkrootkit-0.55.tar.gz # tar xvf chkrootkit-0.55.tar.gz Logwatch ①Install # dnf install logwatch Introduce disk usage check script 1. Script Creation # cd /var/www/system # vi disk_capacity_check.sh
OracleLinux9.3_en

OracleLinux9.3 ; System Backup and Restore

1.Website data backup 1-1.Backup under /var/www/html ①Create backup script file 2.MySQL database backup ①Create backup script file # cd /var/www/system # vi db_my_backup.sh 3.Restore backup files under html ① Store HTML backup files in "/ (root)" directory # cd /var/www/backup/html_bak # cp html_back_20220610.tar.gz / ←Specify the backup file with the latest date 4.Restore Mysql backup file ①Save the database backup file to any directory and (In the example, the directory is "/var/www/backup/db_bak".)Extracting data # cd /var/www/backup/db_bak