APM으로 게시판 만들기
Rocky os 8.9 APM 설치 - mysql(mariadb) 설치
파워레인저
2024. 6. 5. 11:06
아래의 사이트를 보고 진행했습니다.
정확한 정보를 보고 싶으면 아래 사이트로 가주세요.
APM 최신버전 설치 yum ( apache 2.4.37 / php 8.3.2 / mariadb 11.3.1 )
os/ : rocky linux 8.x서비스 등록 및 시작[crayon-665fc3dd9114f55818...
xinet.kr
웹서버를 먼저 만들어 보기로 했다.
가상으로 리눅스를 먼저 올리고..
뭔지도 모를 명령어를 복사하여 실행해봤다.
# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-11.3.1"
| [root@localhost etc]# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-11.3.1" # [info] Checking for script prerequisites. # [info] MariaDB Server version 11.3.1 is valid # [info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo # [info] Adding trusted package signing keys... /etc/pki/rpm-gpg /etc /etc # [info] Successfully added trusted package signing keys # [info] Cleaning package cache... 25 파일이 삭제되었습니다 |
# yum install MariaDB-client MariaDB-connect-engine mariadb-devel mariadb-server
| Rocky Linux 8 - AppStream 1.0 MB/s | 10 MB 00:10 Rocky Linux 8 - BaseOS 1.9 MB/s | 2.9 MB 00:01 Rocky Linux 8 - Extras 14 kB/s | 14 kB 00:01 MariaDB Server 113 kB/s | 312 kB 00:02 MariaDB MaxScale 3.2 kB/s | 6.9 kB 00:02 MariaDB Tools 34 kB/s | 25 kB 00:00 종속성이 해결되었습니다. ========================================================================================================================================================== 꾸러미 구조 버전 저장소 크기 ========================================================================================================================================================== 설치 중: MariaDB-client x86_64 11.3.1-1.el8 mariadb-main 17 M MariaDB-connect-engine x86_64 11.3.1-1.el8 mariadb-main 2.6 M MariaDB-server x86_64 11.3.1-1.el8 mariadb-main 27 M mariadb-devel x86_64 3:10.3.39-1.module+el8.8.0+1452+2a7eab68 appstream 1.1 M 향상 중: glibc x86_64 2.28-251.el8_10.2 baseos 2.2 M glibc-all-langpacks x86_64 2.28-251.el8_10.2 baseos 26 M glibc-common x86_64 2.28-251.el8_10.2 baseos 1.0 M ................ ................ ................ 향상되었습니다: glibc-2.28-251.el8_10.2.x86_64 glibc-all-langpacks-2.28-251.el8_10.2.x86_64 glibc-common-2.28-251.el8_10.2.x86_64 glibc-gconv-extra-2.28-251.el8_10.2.x86_64 glibc-langpack-en-2.28-251.el8_10.2.x86_64 glibc-langpack-ko-2.28-251.el8_10.2.x86_64 krb5-libs-1.18.2-27.el8_10.x86_64 openssl-1:1.1.1k-12.el8_9.x86_64 openssl-libs-1:1.1.1k-12.el8_9.x86_64 zlib-1.2.11-26.el8.x86_64 설치되었습니다: MariaDB-client-11.3.1-1.el8.x86_64 MariaDB-client-compat-11.3.1-1.el8.noarch MariaDB-common-11.3.1-1.el8.x86_64 MariaDB-compat-11.3.1-1.el8.x86_64 MariaDB-connect-engine-11.3.1-1.el8.x86_64 MariaDB-server-11.3.1-1.el8.x86_64 MariaDB-server-compat-11.3.1-1.el8.noarch compat-openssl10-1:1.0.2o-4.el8_6.x86_64 galera-4-26.4.16-1.el8.x86_64 keyutils-libs-devel-1.5.10-9.el8.x86_64 krb5-devel-1.18.2-27.el8_10.x86_64 libcom_err-devel-1.45.6-5.el8.x86_64 libkadm5-1.18.2-27.el8_10.x86_64 libnsl-2.28-251.el8_10.2.x86_64 libselinux-devel-2.9-8.el8.x86_64 libsepol-devel-2.9-3.el8.x86_64 libverto-devel-0.3.2-2.el8.x86_64 make-1:4.2.1-11.el8.x86_64 mariadb-connector-c-3.1.11-2.el8_3.x86_64 mariadb-connector-c-devel-3.1.11-2.el8_3.x86_64 mariadb-devel-3:10.3.39-1.module+el8.8.0+1452+2a7eab68.x86_64 openssl-devel-1:1.1.1k-12.el8_9.x86_64 pcre2-devel-10.32-3.el8_6.x86_64 pcre2-utf16-10.32-3.el8_6.x86_64 pcre2-utf32-10.32-3.el8_6.x86_64 socat-1.7.4.1-1.el8.x86_64 unixODBC-2.3.7-1.el8.x86_64 zlib-devel-1.2.11-26.el8.x86_64 완료되었습니다! |
뭔지는 모르겠지만 "향상"이 되고 "설치"가 하여 "완료"가 되었다.
# vi /etc/my.cnf.d/server.cnf
다 알려고 하지말고, 시키는대로만 해보자. 설정 파일을 수정해보자.
set nu 로 확인해보니.. 48 line으로 된 짧은 설정파일이다.
[mysqld] 부분에 몇 줄 더 추가해줘야 한다.
| [mysqld] character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake #connection max_connections = 1000 max_connect_errors = 1000 wait_timeout= 60 # sqlmode sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
열심히 타이핑 후 set list로 공백까지 확인했다. 완벽. 퍼풱. 그 잡채.
# systemctl enable mariadb
| Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service. |
서비스에 등록은 OK
# systemctl start mariadb
| Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. |
영어가 잼뱅이라도 failed는 무슨 뜻인지 알겠다.
뭐가 문제인지 확인해보자
# systemctl status mariadb.service
| ● mariadb.service - MariaDB 11.3.1 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Wed 2024-06-05 07:00:09 EDT; 1min 46s ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Process: 51153 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 51119 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] &&> Process: 51117 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 51153 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" 6월 05 07:00:09 jk_test systemd[1]: Starting MariaDB 11.3.1 database server... 6월 05 07:00:09 jk_test mariadbd[51153]: 2024-06-05 7:00:09 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 33032) 6월 05 07:00:09 jk_test mariadbd[51153]: 2024-06-05 7:00:09 0 [ERROR] Unknown collation: 'utf_unicode_ci' 6월 05 07:00:09 jk_test mariadbd[51153]: 2024-06-05 7:00:09 0 [ERROR] Aborting 6월 05 07:00:09 jk_test systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 6월 05 07:00:09 jk_test systemd[1]: mariadb.service: Failed with result 'exit-code'. 6월 05 07:00:09 jk_test systemd[1]: Failed to start MariaDB 11.3.1 database server. |
[ERROR] Unknown collation: 'utf_unicode_ci'
얘가 문제라는데... 위의 설정을 다시 짚어보자.
'utf_unicode_ci' -> 'utf8_unicode_ci' 로 수정
난 퍼풱하지 않았음. 다시
# systemctl start mariadb
별 다른 프롬프트가 뜨지 않았다.
# mysql
| mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 11.3.1-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> |
오예, 성공