Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.
| Obě strany předchozí revize Předchozí verze Následující verze | Předchozí verze | ||
|
cs:tech:idp:mariadb:new [2020/03/26 21:17] jan.oppolzer@cesnet.cz [Databáze] |
cs:tech:idp:mariadb:new [2020/03/27 14:31] jan.oppolzer@cesnet.cz odstraněno |
||
|---|---|---|---|
| Řádek 53: | Řádek 53: | ||
| </code> | </code> | ||
| - | Vytvoříme databázi //shibboleth// a v ní tabulky //shibpid// a //StorageRecords//. | + | Vytvoříme databázi //shibboleth// a v ní tabulku //shibpid//. |
| <code mysql> | <code mysql> | ||
| - | # Vytvoříme databázi 'shibboleth' a tabulky 'shibpid' a 'StorageRecords' | + | # Vytvoříme databázi 'shibboleth' a tabulku 'shibpid' |
| SET NAMES 'utf8'; | SET NAMES 'utf8'; | ||
| SET CHARACTER SET utf8; | SET CHARACTER SET utf8; | ||
| Řádek 72: | Řádek 72: | ||
| `deactivationDate` TIMESTAMP NULL DEFAULT NULL, | `deactivationDate` TIMESTAMP NULL DEFAULT NULL, | ||
| PRIMARY KEY (`localEntity`, `peerEntity`, `persistentId`) | PRIMARY KEY (`localEntity`, `peerEntity`, `persistentId`) | ||
| - | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| - | CREATE TABLE IF NOT EXISTS `StorageRecords` ( | ||
| - | `context` VARCHAR(255) NOT NULL, | ||
| - | `id` VARCHAR(255) NOT NULL, | ||
| - | `expires` BIGINT DEFAULT NULL, | ||
| - | `value` LONGTEXT NOT NULL, | ||
| - | `version` BIGINT NOT NULL, | ||
| - | PRIMARY KEY (`context`, `id`) | ||
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| </code> | </code> | ||
| - | Pomocí příkazu ''DESCRIBE'' si můžeme zobrazit, jak tabulky vypadají. | + | Pomocí příkazu ''DESCRIBE'' si můžeme zobrazit, jak tabulka vypadá. |
| <code mysql> | <code mysql> | ||
| - | # Zobrazení definice tabulek 'shibpid' a 'StorageRecords' | + | # Zobrazení definice tabulky 'shibpid' |
| DESCRIBE shibpid; | DESCRIBE shibpid; | ||
| - | DESCRIBE StorageRecords; | ||
| </code> | </code> | ||
| Řádek 94: | Řádek 85: | ||
| <code mysql> | <code mysql> | ||
| - | +------------------+--------------+------+-----+-------------------+-----------------------------+ | + | +------------------+--------------+------+-----+---------------------+-------------------------------+ |
| - | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
| - | +------------------+--------------+------+-----+-------------------+-----------------------------+ | + | +------------------+--------------+------+-----+---------------------+-------------------------------+ |
| - | | localEntity | varchar(255) | NO | PRI | NULL | | | + | | localEntity | varchar(255) | NO | PRI | NULL | | |
| - | | peerEntity | varchar(255) | NO | PRI | NULL | | | + | | peerEntity | varchar(255) | NO | PRI | NULL | | |
| - | | principalName | varchar(255) | NO | | | | | + | | principalName | varchar(255) | NO | | | | |
| - | | localId | varchar(255) | NO | | NULL | | | + | | localId | varchar(255) | NO | | NULL | | |
| - | | persistentId | varchar(50) | NO | PRI | NULL | | | + | | persistentId | varchar(50) | NO | PRI | NULL | | |
| - | | peerProvidedId | varchar(255) | YES | | NULL | | | + | | peerProvidedId | varchar(255) | YES | | NULL | | |
| - | | creationDate | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | + | | creationDate | timestamp | NO | | current_timestamp() | on update current_timestamp() | |
| - | | deactivationDate | timestamp | YES | | NULL | | | + | | deactivationDate | timestamp | YES | | NULL | | |
| - | +------------------+--------------+------+-----+-------------------+-----------------------------+ | + | +------------------+--------------+------+-----+---------------------+-------------------------------+ |
| - | 8 rows in set (0.00 sec) | + | 8 rows in set (0.002 sec) |
| - | + | ||
| - | + | ||
| - | FIXME | + | |
| - | + | ||
| - | + | ||
| - | +---------+--------------+------+-----+---------+-------+ | + | |
| - | | Field | Type | Null | Key | Default | Extra | | + | |
| - | +---------+--------------+------+-----+---------+-------+ | + | |
| - | | context | varchar(255) | NO | PRI | NULL | | | + | |
| - | | id | varchar(255) | NO | PRI | NULL | | | + | |
| - | | expires | bigint(20) | YES | | NULL | | | + | |
| - | | value | longtext | NO | | NULL | | | + | |
| - | | version | bigint(20) | NO | | NULL | | | + | |
| - | +---------+--------------+------+-----+---------+-------+ | + | |
| - | 5 rows in set (0.001 sec) | + | |
| </code> | </code> | ||
| Řádek 137: | Řádek 113: | ||
| GRANT ALL PRIVILEGES ON shibboleth.* | GRANT ALL PRIVILEGES ON shibboleth.* | ||
| TO 'shibboleth'@'localhost' | TO 'shibboleth'@'localhost' | ||
| - | IDENTIFIED BY 'f6603c2fd2a48bc722c14ca88bb08a762f3478c4'; | + | IDENTIFIED BY '___SILNE_HESLO_VYGENEROVANE_VYSE___'; |
| FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
| </code> | </code> | ||
CESNET, z. s. p. o.
Generála Píky 26
16000 Praha 6
info@cesnet.cz
Tel: +420 234 680 222
GSM: +420 602 252 531
support@cesnet.cz