Rozdiely
Tu môžete vidieť rozdiely medzi vybranou verziou a aktuálnou verziou danej stránky.
Obojstranná predošlá revízia Predchádzajúca revízia Nasledujúca revízia | Predchádzajúca revízia | ||
install:idp:konfiguracia_a_instalacia_databazy_mysql [30. 03. 2021 09:45] jnamesny@umb.sk |
— (aktuálne) | ||
---|---|---|---|
Riadok 1: | Riadok 1: | ||
- | ====== Konfigurácia a inštalácia databázy MySQL ====== | ||
- | |||
- | > V tomto návode použijeme databázu MySQL, pracujeme s verziou MySQL server 8.0.21 | ||
- | >> https:// | ||
- | |||
- | <alert type=" | ||
- | Pracujeme pod používateľom " | ||
- | </ | ||
- | |||
- | |||
- | < | ||
- | dnf makecache | ||
- | dnf -y install mysql-server | ||
- | systemctl enable mysqld | ||
- | systemctl start mysqld | ||
- | </ | ||
- | |||
- | Pokračujeme základnými nastaveniami: | ||
- | |||
- | < | ||
- | mysql_secure_installation | ||
- | </ | ||
- | |||
- | Pre zjednodušenie prístupu vytvoríme nasledovný súbor: | ||
- | |||
- | < | ||
- | vim / | ||
- | </ | ||
- | |||
- | S obsahom: | ||
- | |||
- | < | ||
- | [client] | ||
- | user=root | ||
- | password=" | ||
- | </ | ||
- | |||
- | <alert type=" | ||
- | Heslo-do-mysql = Heslo, ktoré sme zvolili pri procese mysql_secure_installation | ||
- | </ | ||
- | |||
- | |||
- | Nastavíme oprávnenia: | ||
- | |||
- | < | ||
- | chmod go-rwx / | ||
- | </ | ||
- | |||
- | Pre zobrazenie informácii o verzii zadáme príkaz: | ||
- | |||
- | < | ||
- | mysqladmin -u root -p version | ||
- | </ | ||
- | |||
- | <alert type=" | ||
- | Je potrebné nastaviť v konfigurácii / | ||
- | </ | ||
- | |||
- | |||
- | < | ||
- | vim / | ||
- | </ | ||
- | |||
- | < | ||
- | # | ||
- | # This group are read by MySQL server. | ||
- | # Use it for options that only the server (but not clients) should see | ||
- | # | ||
- | # For advice on how to change settings please see | ||
- | # http:// | ||
- | |||
- | # Settings user and group are ignored when systemd is used. | ||
- | # If you need to run mysqld under a different user or group, | ||
- | # customize your systemd unit file for mysqld according to the | ||
- | # instructions in http:// | ||
- | |||
- | [mysqld] | ||
- | datadir=/ | ||
- | socket=/ | ||
- | log-error=/ | ||
- | pid-file=/ | ||
- | |||
- | default-time-zone=' | ||
- | </ | ||
- | |||
- | Po zmene a uložení konfigurácie reštartujeme službu: | ||
- | |||
- | < | ||
- | systemctl restart mysqld | ||
- | </ | ||
- | |||
- | Prístup do príkazového riadku klienta: | ||
- | |||
- | < | ||
- | mysql | ||
- | </ | ||
- | |||
- | Pre opustenie príkazového riadku klienta zvolíme " | ||
- | |||
- | **Vytvorenie databázy a používateľa** | ||
- | |||
- | Prihlásime sa do príkazového riadku klienta. | ||
- | Spúšťame príkazy pre vytvorenie databázy a používateľa, | ||
- | |||
- | < | ||
- | mysql | ||
- | </ | ||
- | |||
- | <code sql> | ||
- | SET GLOBAL default_storage_engine = ' | ||
- | </ | ||
- | |||
- | <code sql> | ||
- | SET NAMES ' | ||
- | SET CHARACTER SET utf8; | ||
- | CHARSET utf8; | ||
- | CREATE DATABASE IF NOT EXISTS shibboleth CHARACTER SET=utf8; | ||
- | CREATE USER ' | ||
- | GRANT ALL ON shibboleth.* TO ' | ||
- | FLUSH PRIVILEGES; | ||
- | </ | ||
- | |||
- | Môžeme skontrolovať pomocou: | ||
- | |||
- | < | ||
- | mysql> SELECT user FROM mysql.user; | ||
- | mysql> SHOW DATABASES; | ||
- | </ | ||
- | |||
- | Vytvoríme novú tabuľku v databáze shibboleth: | ||
- | |||
- | <code sql> | ||
- | USE shibboleth; | ||
- | CREATE TABLE IF NOT EXISTS `shibpid` ( | ||
- | `localEntity` VARCHAR(255) NOT NULL, | ||
- | `peerEntity` VARCHAR(255) NOT NULL, | ||
- | `principalName` VARCHAR(255) NOT NULL DEFAULT '', | ||
- | `localId` VARCHAR(255) NOT NULL, | ||
- | `persistentId` VARCHAR(50) NOT NULL, | ||
- | `peerProvidedId` VARCHAR(255) DEFAULT NULL, | ||
- | `creationDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | ||
- | `deactivationDate` TIMESTAMP NULL DEFAULT NULL, | ||
- | PRIMARY KEY (localEntity, | ||
- | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
- | </ | ||
- | |||
- | Môžeme skontrolovať pomocou: | ||
- | |||
- | < | ||
- | mysql> USE shibboleth | ||
- | mysql> DESCRIBE shibpid; | ||
- | </ | ||
- | |||
- | Výstup by mal zodpovedať: | ||
- | |||
- | <code mysql> | ||
- | +------------------+--------------+------+-----+-------------------+-----------------------------------------------+ | ||
- | | Field | Type | Null | Key | Default | ||
- | +------------------+--------------+------+-----+-------------------+-----------------------------------------------+ | ||
- | | localEntity | ||
- | | peerEntity | ||
- | | principalName | ||
- | | localId | ||
- | | persistentId | ||
- | | peerProvidedId | ||
- | | creationDate | ||
- | | deactivationDate | timestamp | ||
- | +------------------+--------------+------+-----+-------------------+-----------------------------------------------+ | ||
- | 8 rows | ||
- | </ | ||
- | |||
- | V databáze shibboleth ďalej vytvoríme tabuľku " | ||
- | |||
- | > StorageConfiguration - ClientStorageService | ||
- | >> https:// | ||
- | |||
- | <code sql> | ||
- | USE shibboleth; | ||
- | CREATE TABLE IF NOT EXISTS `StorageRecords` ( | ||
- | `context` varchar(255) NOT NULL, | ||
- | `id` varchar(255) NOT NULL, | ||
- | `expires` bigint(20) DEFAULT NULL, | ||
- | `value` longtext NOT NULL, | ||
- | `version` bigint(20) NOT NULL, | ||
- | PRIMARY KEY (`context`, | ||
- | )ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
- | </ | ||
- | |||
- | Výstup by mal zodpovedať: | ||
- | |||
- | < | ||
- | mysql> DESCRIBE StorageRecords; | ||
- | </ | ||
- | |||
- | <code mysql> | ||
- | +---------+--------------+------+-----+---------+-------+ | ||
- | | Field | Type | Null | Key | Default | Extra | | ||
- | +---------+--------------+------+-----+---------+-------+ | ||
- | | context | varchar(255) | NO | PRI | NULL | | | ||
- | | id | varchar(255) | NO | PRI | NULL | | | ||
- | | expires | bigint | ||
- | | value | longtext | ||
- | | version | bigint | ||
- | +---------+--------------+------+-----+---------+-------+ | ||
- | 5 rows | ||
- | </ | ||
- | |||
- | **MySQL JDBC connector** | ||
- | |||
- | > MySQL Connector/J is the official JDBC driver for MySQL. | ||
- | > MySQL Connector/J 8.0 is compatible with all MySQL versions starting with MySQL 5.6. Additionally, | ||
- | > MySQL Connector/J 8.0 supports the new X DevAPI for development with MySQL Server 8.0. | ||
- | >> https:// | ||
- | > Changes in the Connector/J API | ||
- | >> https:// | ||
- | |||
- | <alert type=" | ||
- | MySQL Connector/J nebudeme inštalovať pomocou správcu balíkov " | ||
- | </ | ||
- | |||
- | |||
- | > MySQL Community Downloads: https:// | ||
- | |||
- | <alert type=" | ||
- | V návode ďalej pracujeme s verziou mysql-connector-java-8.0.22 | ||
- | </ | ||
- | |||
- | |||
- | > Vybrali sme: Platform Independent (Architecture Independent), | ||
- | >> https:// | ||
- | |||
- | Stiahneme a rozbalíme archív s konektorom: | ||
- | |||
- | < | ||
- | wget https:// | ||
- | tar -xzf mysql-connector-java-8.0.22.tar.gz | ||
- | </ | ||
- | |||
- | Skopírujeme konektor do adresára Jetty / | ||
- | |||
- | < | ||
- | cd mysql-connector-java-8.0.22 | ||
- | cp mysql-connector-java-8.0.22.jar / | ||
- | chown idp:idp / | ||
- | </ | ||
- | |||
- | Reštartujeme Jetty: | ||
- | |||
- | < | ||
- | systemctl restart jetty | ||
- | </ |