11. Spring Cloud OAuth2 （2刷）

悠悠 2022-09-08 03:40 210阅读 0赞

## oath2 ##

### 基础知识 ###

> 授权节点 /oauth/authorize
> 
> 获得token节点 /oauth/token

1.  浏览器 — 向 授权服务器 请求token
2.  授权服务器 返回token

授权服务器为 auth-service

1.  浏览器携带这 token去请求
2.  service-hi 拿着 token去 授权服务器认证
3.  授权服务器，返回用户信息，包括权限
4.  service-hi，判断后：返回结果

### Oauth支持的5类 grant\_type 及说明 ###

1.  authorization\_code — 授权码模式(即先登录获取code,再获取token)
2.  password — 密码模式(将用户名,密码传过去,直接获取token)
3.  client\_credentials — 客户端模式(无用户,用户向客户端注册,然后客户端以自己的名义向’服务端’获取资源)
4.  implicit — 简化模式(在redirect\_uri 的Hash传递token; Auth客户端运行在浏览器中,如JS,Flash)
5.  refresh\_token — 刷新access\_token

### spring-cloud-auth.sql ###

/* Navicat MySQL Data Transfer Source Server : ddddd Source Server Version : 50718 Source Host : localhost Source Database : spring-cloud-auth Target Server Version : 50718 File Encoding : utf-8 Date: 03/29/2018 15:45:17 PM */
    
    SET NAMES utf8;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for `clientdetails`
    -- ----------------------------
    DROP TABLE IF EXISTS `clientdetails`;
    CREATE TABLE `clientdetails` (
      `appId` varchar(128) NOT NULL,
      `resourceIds` varchar(256) DEFAULT NULL,
      `appSecret` varchar(256) DEFAULT NULL,
      `scope` varchar(256) DEFAULT NULL,
      `grantTypes` varchar(256) DEFAULT NULL,
      `redirectUrl` varchar(256) DEFAULT NULL,
      `authorities` varchar(256) DEFAULT NULL,
      `access_token_validity` int(11) DEFAULT NULL,
      `refresh_token_validity` int(11) DEFAULT NULL,
      `additionalInformation` varchar(4096) DEFAULT NULL,
      `autoApproveScopes` varchar(256) DEFAULT NULL,
      PRIMARY KEY (`appId`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for `oauth_access_token`
    -- ----------------------------
    DROP TABLE IF EXISTS `oauth_access_token`;
    CREATE TABLE `oauth_access_token` (
      `token_id` varchar(256) DEFAULT NULL,
      `token` blob,
      `authentication_id` varchar(128) NOT NULL,
      `user_name` varchar(256) DEFAULT NULL,
      `client_id` varchar(256) DEFAULT NULL,
      `authentication` blob,
      `refresh_token` varchar(256) DEFAULT NULL,
      PRIMARY KEY (`authentication_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of `oauth_access_token`
    -- ----------------------------
    BEGIN;
    INSERT INTO `oauth_access_token` VALUES ('13c046a71f01b27244b0d5b7835ee14b', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015c616265da787372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e71007e0002787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c756571007e0005787074002466666630306564362d316238642d346261302d386465362d3365356239323964323436357371007e000977080000015cb055bd0e78737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000023f4000000000000174000275697874000662656172657274002435636632303331302d306661332d346130352d613434332d626535616638333965316638, '1389f9cf1a9245e9f35d11bcb33cd7dd', 'fzp', 'browser', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000277040000000273720016636f6d2e666f72657a702e646f6d61696e2e526f6c658ae30b1d0923c48a0200024c000269647400104c6a6176612f6c616e672f4c6f6e673b4c00046e616d657400124c6a6176612f6c616e672f537472696e673b78707372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000000000001740009524f4c455f555345527371007e000d7371007e0011000000000000000274000a524f4c455f41444d494e7871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000f4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e001b787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e00194c000573636f706571007e001b787074000762726f77736572737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00197870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d65740003667a7078737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f40000000000001740002756978017371007e002a770c000000103f40000000000000787371007e00213f40000000000000770800000010000000007870707371007e002a770c000000103f40000000000000787371007e002a770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000277040000000271007e001071007e00157871007e0034737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e00213f400000000000067708000000080000000271007e002371007e002471007e002571007e002678007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c0002696471007e000e4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e003b787000ffffffff00010071007e001371007e0038740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b0000000277040000000271007e001071007e0015787371007e000b0000000277040000000271007e001071007e00157871007e001374003c24326124313024726c4d2e2f51346468357158596d78467855716b5265744d5066364a6577562f486a2f73347142672f3655312e6d7a637565326f4b740003667a70, '9a4381a1ddef62d8b11e89caa8245e78'), ('350fb3d7996e2d7a8556765957e00a03', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015c6699371c787372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e71007e0002787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c756571007e0005787074002433376238626161662d363336352d346566632d386565662d3339376131303339663536647371007e000977080000015cb0671c9178737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f400000000000017400067365727665727874000662656172657274002439366338323030332d616336342d343731312d626137302d363364373630393465376434, '2e73bfd5530b326ddeab575c9fbfcde2', 'fzp', 'service-hi', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000277040000000273720016636f6d2e666f72657a702e646f6d61696e2e526f6c658ae30b1d0923c48a0200024c000269647400104c6a6176612f6c616e672f4c6f6e673b4c00046e616d657400124c6a6176612f6c616e672f537472696e673b78707372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000000000001740009524f4c455f555345527371007e000d7371007e0011000000000000000274000a524f4c455f41444d494e7871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000f4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e001b787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e00194c000573636f706571007e001b787074000a736572766963652d6869737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00197870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d65740003667a7078737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000174000673657276657278017371007e002a770c000000103f40000000000000787371007e00213f40000000000000770800000010000000007870707371007e002a770c000000103f40000000000000787371007e002a770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000277040000000271007e001071007e00157871007e0034737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e00213f400000000000067708000000080000000271007e002371007e002471007e002571007e002678007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c0002696471007e000e4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e003b787000ffffffff00010071007e001371007e0038740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b0000000277040000000271007e001071007e0015787371007e000b0000000277040000000271007e001071007e00157871007e001374003c24326124313024726c4d2e2f51346468357158596d78467855716b5265744d5066364a6577562f486a2f73347142672f3655312e6d7a637565326f4b740003667a70, '3743d13137974569702be6a75b7a55fe'), ('db912cf35401cf72f018e2c253f607c2', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015c668b8f0e787372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e71007e0002787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c756571007e0005787074002433623761346138392d623562382d343363342d626233642d3561333831373163616635627371007e000977080000015cfe77290e78737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000023f400000000000017400067365727665727874000662656172657274002462616561396564302d313937302d346664342d623631362d666465326137356134316565, '7617498f43f6d907639b8154c0b7e750', 'miya', 'service-hi', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000177040000000173720016636f6d2e666f72657a702e646f6d61696e2e526f6c658ae30b1d0923c48a0200024c000269647400104c6a6176612f6c616e672f4c6f6e673b4c00046e616d657400124c6a6176612f6c616e672f537472696e673b78707372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000000000000274000a524f4c455f41444d494e7871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000f4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0018787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e00164c000573636f706571007e0018787074000a736572766963652d6869737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00167870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d657400046d69796178737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000174000673657276657278017371007e0027770c000000103f40000000000000787371007e001e3f40000000000000770800000010000000007870707371007e0027770c000000103f40000000000000787371007e0027770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e00107871007e0031737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e001e3f400000000000067708000000080000000271007e002071007e002171007e002271007e002378007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c0002696471007e000e4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e0038787000ffffffff0001007371007e0011000000000000000471007e0035740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b0000000177040000000171007e0010787371007e000b0000000177040000000171007e00107871007e003a74003c243261243130244259736c595273654a6d6664426c2e534b744f443265313358635a3639652e6a3443556270532e48784b756661544b4774704551477400046d697961, '19a05550dec3c0e4123e36952e464128'), ('e55492891bc839042565408a7f3774b4', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015c1bd3e567787372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e71007e0002787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c756571007e0005787074002437653964386266362d663866322d346130632d386239302d3965363530356532393961617371007e000977080000015cb3bf7f6778737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000023f4000000000000174000275697874000662656172657274002436363164323932382d373837332d343064302d623632612d363138306332336432363931, 'eb13f5b711165ffc1df8ce781ed02700', 'sss', 'browser', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a657870000000007704000000007871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b72656469726563745572697400124c6a6176612f6c616e672f537472696e673b4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0011787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e000e4c000573636f706571007e0011787074000762726f77736572737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e000e7870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d6574000373737378737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f40000000000001740002756978017371007e0020770c000000103f40000000000000787371007e00173f40000000000000770800000010000000007870707371007e0020770c000000103f40000000000000787371007e0020770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b000000007704000000007871007e002a737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e00173f400000000000067708000000080000000271007e001971007e001a71007e001b71007e001c78007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c000269647400104c6a6176612f6c616e672f4c6f6e673b4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e0032787000ffffffff0001007372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000000000000271007e002f740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b00000000770400000000787371007e000b000000007704000000007871007e003674003c24326124313024354b53526f45526d71624b4b3332454a467133304d4f557273766945686b52315a7a667a794a72322f4f7262554843675268654753740003737373, '252508957a00f8d88ea15afea81a5f43');
    COMMIT;
    
    -- ----------------------------
    -- Table structure for `oauth_approvals`
    -- ----------------------------
    DROP TABLE IF EXISTS `oauth_approvals`;
    CREATE TABLE `oauth_approvals` (
      `userId` varchar(256) DEFAULT NULL,
      `clientId` varchar(256) DEFAULT NULL,
      `scope` varchar(256) DEFAULT NULL,
      `status` varchar(10) DEFAULT NULL,
      `expiresAt` datetime DEFAULT NULL,
      `lastModifiedAt` datetime DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for `oauth_client_details`
    -- ----------------------------
    DROP TABLE IF EXISTS `oauth_client_details`;
    CREATE TABLE `oauth_client_details` (
      `client_id` varchar(256) NOT NULL,
      `resource_ids` varchar(256) DEFAULT NULL,
      `client_secret` varchar(256) DEFAULT NULL,
      `scope` varchar(256) DEFAULT NULL,
      `authorized_grant_types` varchar(256) DEFAULT NULL,
      `web_server_redirect_uri` varchar(256) DEFAULT NULL,
      `authorities` varchar(256) DEFAULT NULL,
      `access_token_validity` int(11) DEFAULT NULL,
      `refresh_token_validity` int(11) DEFAULT NULL,
      `additional_information` varchar(4096) DEFAULT NULL,
      `autoapprove` varchar(256) DEFAULT NULL,
      PRIMARY KEY (`client_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for `oauth_client_token`
    -- ----------------------------
    DROP TABLE IF EXISTS `oauth_client_token`;
    CREATE TABLE `oauth_client_token` (
      `token_id` varchar(256) DEFAULT NULL,
      `token` blob,
      `authentication_id` varchar(128) NOT NULL,
      `user_name` varchar(256) DEFAULT NULL,
      `client_id` varchar(256) DEFAULT NULL,
      PRIMARY KEY (`authentication_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for `oauth_code`
    -- ----------------------------
    DROP TABLE IF EXISTS `oauth_code`;
    CREATE TABLE `oauth_code` (
      `code` varchar(256) DEFAULT NULL,
      `authentication` blob
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for `oauth_refresh_token`
    -- ----------------------------
    DROP TABLE IF EXISTS `oauth_refresh_token`;
    CREATE TABLE `oauth_refresh_token` (
      `token_id` varchar(256) DEFAULT NULL,
      `token` blob,
      `authentication` blob
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of `oauth_refresh_token`
    -- ----------------------------
    BEGIN;
    INSERT INTO `oauth_refresh_token` VALUES ('252508957a00f8d88ea15afea81a5f43', 0xaced00057372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c75657400124c6a6176612f6c616e672f537472696e673b787074002437653964386266362d663866322d346130632d386239302d3965363530356532393961617372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015cb3bf7f6778, 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a657870000000007704000000007871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b72656469726563745572697400124c6a6176612f6c616e672f537472696e673b4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0011787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e000e4c000573636f706571007e0011787074000762726f77736572737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e000e7870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d6574000373737378737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f40000000000001740002756978017371007e0020770c000000103f40000000000000787371007e00173f40000000000000770800000010000000007870707371007e0020770c000000103f40000000000000787371007e0020770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b000000007704000000007871007e002a737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e00173f400000000000067708000000080000000271007e001971007e001a71007e001b71007e001c78007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c000269647400104c6a6176612f6c616e672f4c6f6e673b4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e0032787000ffffffff0001007372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000000000000271007e002f740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b00000000770400000000787371007e000b000000007704000000007871007e003674003c24326124313024354b53526f45526d71624b4b3332454a467133304d4f557273766945686b52315a7a667a794a72322f4f7262554843675268654753740003737373), ('9a4381a1ddef62d8b11e89caa8245e78', 0xaced00057372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c75657400124c6a6176612f6c616e672f537472696e673b787074002466666630306564362d316238642d346261302d386465362d3365356239323964323436357372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015cb055bd0e78, 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000177040000000173720016636f6d2e666f72657a702e646f6d61696e2e526f6c658ae30b1d0923c48a0200024c000269647400104c6a6176612f6c616e672f4c6f6e673b4c00046e616d657400124c6a6176612f6c616e672f537472696e673b78707372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000000000001740009524f4c455f555345527871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000f4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0018787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e00164c000573636f706571007e0018787074000762726f77736572737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00167870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d65740003667a7078737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f40000000000001740002756978017371007e0027770c000000103f40000000000000787371007e001e3f40000000000000770800000010000000007870707371007e0027770c000000103f40000000000000787371007e0027770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e00107871007e0031737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e001e3f400000000000067708000000080000000271007e002071007e002171007e002271007e002378007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c0002696471007e000e4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e0038787000ffffffff00010071007e001371007e0035740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b0000000177040000000171007e0010787371007e000b0000000177040000000171007e00107871007e001374003c24326124313024726c4d2e2f51346468357158596d78467855716b5265744d5066364a6577562f486a2f73347142672f3655312e6d7a637565326f4b740003667a70), ('19a05550dec3c0e4123e36952e464128', 0xaced00057372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c75657400124c6a6176612f6c616e672f537472696e673b787074002433623761346138392d623562382d343363342d626233642d3561333831373163616635627372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015cfe77290e78, 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a657870000000007704000000007871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b72656469726563745572697400124c6a6176612f6c616e672f537472696e673b4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0011787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e000e4c000573636f706571007e0011787074000a736572766963652d6869737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e000e7870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d657400046d69796178737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000174000673657276657278017371007e0020770c000000103f40000000000000787371007e00173f40000000000000770800000010000000007870707371007e0020770c000000103f40000000000000787371007e0020770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b000000007704000000007871007e002a737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e00173f400000000000067708000000080000000271007e001971007e001a71007e001b71007e001c78007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c000269647400104c6a6176612f6c616e672f4c6f6e673b4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e0032787000ffffffff0001007372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000000000000471007e002f740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b00000000770400000000787371007e000b000000007704000000007871007e003674003c243261243130244259736c595273654a6d6664426c2e534b744f443265313358635a3639652e6a3443556270532e48784b756661544b4774704551477400046d697961), ('3743d13137974569702be6a75b7a55fe', 0xaced00057372004c6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744578706972696e674f417574683252656672657368546f6b656e2fdf47639dd0c9b70200014c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b787200446f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f417574683252656672657368546f6b656e73e10e0a6354d45e0200014c000576616c75657400124c6a6176612f6c616e672f537472696e673b787074002433376238626161662d363336352d346566632d386565662d3339376131303339663536647372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000015cb0671c9178, 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000277040000000273720016636f6d2e666f72657a702e646f6d61696e2e526f6c658ae30b1d0923c48a0200024c000269647400104c6a6176612f6c616e672f4c6f6e673b4c00046e616d657400124c6a6176612f6c616e672f537472696e673b78707372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000000000001740009524f4c455f555345527371007e000d7371007e0011000000000000000274000a524f4c455f41444d494e7871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200075a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000f4c00077265667265736874003b4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f546f6b656e526571756573743b4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e001b787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000f4c001172657175657374506172616d657465727371007e00194c000573636f706571007e001b787074000a736572766963652d6869737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00197870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000040000000274000a6772616e745f7479706574000870617373776f7264740008757365726e616d65740003667a7078737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000174000673657276657278017371007e002a770c000000103f40000000000000787371007e00213f40000000000000770800000010000000007870707371007e002a770c000000103f40000000000000787371007e002a770c000000103f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001a40200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000277040000000271007e001071007e00157871007e0034737200176a6176612e7574696c2e4c696e6b6564486173684d617034c04e5c106cc0fb0200015a000b6163636573734f726465727871007e00213f400000000000067708000000080000000271007e002371007e002471007e002571007e002678007073720016636f6d2e666f72657a702e646f6d61696e2e557365726d9ebb753e7c6e0a0200044c000b617574686f72697469657371007e00084c0002696471007e000e4c000870617373776f726471007e000f4c0008757365726e616d6571007e000f78707372002f6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e50657273697374656e74426167464a645c192e1ec40200014c000362616771007e00087872003e6f72672e68696265726e6174652e636f6c6c656374696f6e2e696e7465726e616c2e416273747261637450657273697374656e74436f6c6c656374696f6e627400d05f55733c02000a5a001b616c6c6f774c6f61644f7574736964655472616e73616374696f6e49000a63616368656453697a655a000564697274795a000b696e697469616c697a65645a000d697354656d7053657373696f6e4c00036b65797400164c6a6176612f696f2f53657269616c697a61626c653b4c00056f776e657271007e00054c0004726f6c6571007e000f4c001273657373696f6e466163746f72795575696471007e000f4c000e73746f726564536e617073686f7471007e003b787000ffffffff00010071007e001371007e0038740022636f6d2e666f72657a702e646f6d61696e2e557365722e617574686f726974696573707371007e000b0000000277040000000271007e001071007e0015787371007e000b0000000277040000000271007e001071007e00157871007e001374003c24326124313024726c4d2e2f51346468357158596d78467855716b5265744d5066364a6577562f486a2f73347142672f3655312e6d7a637565326f4b740003667a70);
    COMMIT;
    
    -- ----------------------------
    -- Table structure for `role`
    -- ----------------------------
    DROP TABLE IF EXISTS `role`;
    CREATE TABLE `role` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of `role`
    -- ----------------------------
    BEGIN;
    INSERT INTO `role` VALUES ('1', 'ROLE_USER'), ('2', 'ROLE_ADMIN');
    COMMIT;
    
    -- ----------------------------
    -- Table structure for `user`
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `password` varchar(255) DEFAULT NULL,
      `username` varchar(255) NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `UK_sb8bbouer5wak8vyiiy4pf2bx` (`username`)
    ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of `user`
    -- ----------------------------
    BEGIN;
    INSERT INTO `user` VALUES ('1', '$2a$10$rlM./Q4dh5qXYmxFxUqkRetMPf6JewV/Hj/s4qBg/6U1.mzcue2oK', 'fzp'), ('2', '$2a$10$5KSRoERmqbKK32EJFq30MOUrsviEhkR1ZzfzyJr2/OrbUHCgRheGS', 'sss'), ('3', '123456', 'forezp'), ('4', '$2a$10$BYslYRseJmfdBl.SKtOD2e13XcZ69e.j4CUbpS.HxKufaTKGtpEQG', 'miya'), ('5', '$2a$10$d.ETlomhatNDxO4Olhx9C.qa6dviEEVeAZ9RsUHbqYWp4jnPCdVYK', 'miyaregistera'), ('6', '$2a$10$2Bm8iTeU.83YicFtfIE3But9fcMdgi7p8HyKN9kX9B4LWs5NORKg.', 'miyaa');
    COMMIT;
    
    -- ----------------------------
    -- Table structure for `user_role`
    -- ----------------------------
    DROP TABLE IF EXISTS `user_role`;
    CREATE TABLE `user_role` (
      `user_id` bigint(20) NOT NULL,
      `role_id` bigint(20) NOT NULL,
      KEY `FKa68196081fvovjhkek5m97n3y` (`role_id`),
      KEY `FK859n2jvi8ivhui0rl0esws6o` (`user_id`),
      CONSTRAINT `FK859n2jvi8ivhui0rl0esws6o` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
      CONSTRAINT `FKa68196081fvovjhkek5m97n3y` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of `user_role`
    -- ----------------------------
    BEGIN;
    INSERT INTO `user_role` VALUES ('1', '1'), ('3', '2'), ('1', '2'), ('4', '2'), ('6', '1'), ('6', '2');
    COMMIT;
    
    SET FOREIGN_KEY_CHECKS = 1;

## 编写 eureka，还是那些 ##

eureka:
      instance:
        hostname: localhost
      client:
        registerWithEureka: false
        fetchRegistry: false
        serviceUrl:
          defaultZone: http://${ eureka.instance.hostname}:${ server.port}/eureka/

## 最新的 驱动 ##

Loading class `com.mysql.jdbc.Driver'. This is deprecated. 
    The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
    加载类“com.mysql.jdbc.Driver”。这是弃用。新的驱动类是' com.mysql.cj.jdbc.Driver'。驱动程序通过SPI自动注册，手动加载驱动程序类通常是不必要的。
    
    com.mysql.cj.jdbc.Driver

## 编写Uaa授权服务 ##

> User Account and Authentication 用户帐号及认证

### 引入pom ###

# cloud security
    			<dependency>
    				<groupId>org.springframework.cloud</groupId>
    				<artifactId>spring-cloud-starter-security</artifactId>
    				<version>2.0.0.RELEASE</version>
    			</dependency>
    			自动配置，oauth2-autoconfigure
    			<dependency>
    				<groupId>org.springframework.security.oauth.boot</groupId>
    				<artifactId>spring-security-oauth2-autoconfigure</artifactId>
    				<version>2.0.0.RELEASE</version>
    			</dependency>
    
    			boot security，都是用这个
    		   <dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-security</artifactId>
    		   </dependency>
    
    
    		   <artifactId>spring-boot-starter-data-jpa</artifactId>
    
    
    		#书中还引用了这个，但是 G版代码，没有引用
    		<dependency>
    			<groupId>org.springframework.cloud</groupId>
    			<artifactId>spring-cloud-starter-oauth2</artifactId>
    			<version>2.0.0.RELEASE</version>
    		</dependency>

### yaml ###

logging:
      level:
        org.springframework.security: DEBUG #日志
    
    spring:
      application:
        name: service-auth
        
      main:
        allow-bean-definition-overriding: true #bean重写
        
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/spring-cloud-auth?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&serverTimezone=GMT%2B8
        username: root
        password: 123456
      jpa:
        hibernate:
          ddl-auto: update
        show-sql: true #数据库 和 JPA
    
    server:
      servlet:
        context-path: /uaa #path前缀
      port: 5000 #端口
    
    
    #security:
    # oauth2:
    # resource:
    # filter-order: 3
    # basic:
    # enabled: false
    
    
    eureka:
      client:
        serviceUrl:
          defaultZone: http://localhost:8761/eureka/

### Web Security Configurer Adapter ###

@Configuration
    //@EnableWebSecurity;
    public class WebSecurityConfig extends WebSecurityConfigurerAdapter { 
    
    
        @Autowired
        private UserServiceDetail userServiceDetail;
    
        @Override
        protected void configure(HttpSecurity http) throws Exception { 
            // @formatter:off
            //所有请求 都要认证，csrf 开启拦截，跨域请求
            http
                    .authorizeRequests().anyRequest().authenticated()
                    .and()
                    .csrf().disable();
            // @formatter:on
        }
    	
        //userServiceDetail 赋值
        //使用 BCrypt Password Encoder 解析 
        //跨平台的文件加密工具
        @Override
        protected void configure(AuthenticationManagerBuilder auth) throws Exception { 
            auth.userDetailsService(userServiceDetail)
                    .passwordEncoder(new BCryptPasswordEncoder());
        }
    
        @Override
        @Bean //创建 authentication Manager Bean
        public AuthenticationManager authenticationManagerBean() throws Exception { 
            return super.authenticationManagerBean();
        }
    
    }

### UserDetailsService 和 JpaRepository ###

public interface UserDao extends JpaRepository<User, Long> { 
    
    	User findByUsername(String username);
    }
    
    
    @Service
    public class UserServiceDetail implements UserDetailsService { 
    
        @Autowired
        private UserDao userRepository;
        @Override
        public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException { 
            return userRepository.findByUsername(username);
        }
    }

### 创建用户 service ###

public interface UserService { 
    
    	void create(User user);
    
    }
    
    
    @Service
    public class UserServiceImpl implements UserService { 
    
    	//private final Logger log = LoggerFactory.getLogger(getClass());
    
    	private static final BCryptPasswordEncoder encoder = new BCryptPasswordEncoder();
    
    	@Autowired
    	private UserDao userDao;
    
    	@Override
    	public void create(User user) { 
    
    		User existing = userDao.findByUsername(user.getUsername());
    	
    		String hash = encoder.encode(user.getPassword());
    		user.setPassword(hash);
    		userDao.save(user);
    
    	}
    }

### OAuth2配置 ###

**Qualifier的意思是合格者，通过这个标示，表明了哪个实现类才是我们所需要的，添加@Qualifier注解，需要注意的是@Qualifier的参数名称为我们之前定义@Service注解的名称之一。**

*  如两个类都实线了一个接口。注入接口时候，就要用这个，标志是注册的哪个类
    
        @Service（“a1”）
        public class a1 implements Abc
        
        a2 同理
        
        @Qualifier("a1") //注入a1
        private Abc abc;

@SpringBootApplication
    @EnableResourceServer //开启 资源服务
    @EnableDiscoveryClient
    @EnableGlobalMethodSecurity(prePostEnabled = true) //security 前置配置
    public class ServiceAuthApplication { 
        @Autowired
        @Qualifier("dataSource") //唯一的，这里写法，个人感觉意义不大
        private DataSource dataSource;
    
        //main方法
    	
        @Configuration
        @EnableAuthorizationServer //开启权限 server
        protected class OAuth2AuthorizationConfig extends AuthorizationServerConfigurerAdapter { 
    
            private TokenStore tokenStore = new InMemoryTokenStore();
    
           //JdbcTokenStore tokenStore = new JdbcTokenStore(dataSource);
    
            @Autowired //authentication Manager
            @Qualifier("authenticationManagerBean")
            private AuthenticationManager authenticationManager;
    
            @Autowired
            private UserServiceDetail userServiceDetail;
    
    
            @Override//Client Details Service Configurer
            public void configure(ClientDetailsServiceConfigurer clients) throws Exception { 
    
                clients.inMemory()
                    
                        .withClient("browser")
                        .authorizedGrantTypes("refresh_token", "password")
                        .scopes("ui")
                    
                        .and()
                    
                        .withClient("service-hi")
                        .secret("123456")
                        .authorizedGrantTypes("client_credentials", "refresh_token", "password")
                        .scopes("server");
    
            }
    
            @Override //Authorization Server Endpoints Configurer
            public void configure(AuthorizationServerEndpointsConfigurer endpoints) throws Exception { 
                endpoints
                        .tokenStore(tokenStore)
                        .authenticationManager(authenticationManager)
                        .userDetailsService(userServiceDetail);
            }
    
            @Override //Authorization Server SecurityCon figurer
            public void configure(AuthorizationServerSecurityConfigurer oauthServer) throws Exception { 
                oauthServer
                        .tokenKeyAccess("permitAll()")
                        .checkTokenAccess("isAuthenticated()").allowFormAuthenticationForClients()
                        .passwordEncoder(NoOpPasswordEncoder.getInstance());
    
            }
        }
    }

### 暴露远程 token service接口 ###

@RestController
    @RequestMapping("/users")
    public class UserController { 
    
    	@RequestMapping(value = "/current", method = RequestMethod.GET)
    	public Principal getUser(Principal principal) { 
    		return principal;
    	}
    
    
    }

http://localhost:5000/uaa/users/current 打印principal
    header头 和值，值是 token接口获得的。每个接口 都要加上这些信息
    Authorization
    Bearer 21a38b58-d8af-4a6f-8fb5-77f5fb128237
    //current 接口返回
    { 
        "authorities": [
            { 
                "id": 2,
                "authority": "ROLE_ADMIN"
            }
        ],
        "details": { 
            "remoteAddress": "0:0:0:0:0:0:0:1",
            "sessionId": null,
            "tokenValue": "21a38b58-d8af-4a6f-8fb5-77f5fb128237",
            "tokenType": "Bearer",
            "decodedDetails": null
        },
        "authenticated": true,
        "userAuthentication": { 
            "authorities": [
                { 
                    "id": 2,
                    "authority": "ROLE_ADMIN"
                }
            ],
            "details": { 
                "grant_type": "password",
                "username": "miya2"
            },
            "authenticated": true,
            "principal": { 
                "id": 10,
                "username": "miya2",
                "password": "$2a$10$gzkGPXp05IAGDsoCBMjkP.aF1zY2xTQcaZftkoCn/yb2GMWUANrZi",
                "authorities": [
                    { 
                        "id": 2,
                        "authority": "ROLE_ADMIN"
                    }
                ],
                "enabled": true,
                "accountNonExpired": true,
                "accountNonLocked": true,
                "credentialsNonExpired": true
            },
            "credentials": null,
            "name": "miya2"
        },
        "oauth2Request": { 
            "clientId": "service-hi",
            "scope": [
                "server"
            ],
            "requestParameters": { 
                "grant_type": "password",
                "username": "miya2"
            },
            "resourceIds": [],
            "authorities": [],
            "approved": true,
            "refresh": false,
            "redirectUri": null,
            "responseTypes": [],
            "extensions": { },
            "grantType": "password",
            "refreshTokenRequest": null
        },
        "principal": { 
            "id": 10,
            "username": "miya2",
            "password": "$2a$10$gzkGPXp05IAGDsoCBMjkP.aF1zY2xTQcaZftkoCn/yb2GMWUANrZi",
            "authorities": [
                { 
                    "id": 2,
                    "authority": "ROLE_ADMIN"
                }
            ],
            "enabled": true,
            "accountNonExpired": true,
            "accountNonLocked": true,
            "credentialsNonExpired": true
        },
        "credentials": "",
        "clientOnly": false,
        "name": "miya2"
    }

### 获取token测试 ###

service-hi:123456 base64加密：c2VydmljZS1oaToxMjM0NTY=
    
    post请求：
    http://localhost:5000/uaa/oauth/token?grant_type=password&username=fzp&password=123456
    
    heardert头：Authorization 
    hearder值：Basic c2VydmljZS1oaToxMjM0NTY=

{ 
        "access_token": "dddca5e5-5176-4562-bc63-7cc77b859e0d",
        "token_type": "bearer",
        "refresh_token": "e80c68a0-26ef-4fe3-aabc-dffba3bcb3ed",
        "expires_in": 43185,
        "scope": "server"
    }

## service-hi 资源服务 ##

### pom ###

<dependency>
    			<groupId>org.springframework.cloud</groupId>
    			<artifactId>spring-cloud-starter-security</artifactId>
    			<version>2.0.0.RELEASE</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.security.oauth.boot</groupId>
    			<artifactId>spring-security-oauth2-autoconfigure</artifactId>
    			<version>2.0.0.RELEASE</version>
    		</dependency>
    
    //eureka web feign jpa mysql驱动

### yaml ###

eureka:
      client:
        serviceUrl:
          defaultZone: http://localhost:8761/eureka/ #eureka
    server:
      port: 8762
    spring:
      application:
        name: service-hi
      main:
        allow-bean-definition-overriding: true #允许 重新定义bean
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/spring-cloud-auth?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&serverTimezone=GMT%2B8
        username: root
        password: 123456 #数据库
    
      jpa:
        hibernate:
          ddl-auto: update #jpa
        show-sql: true
    
    security:
      oauth2:
        resource:
          user-info-uri: http://localhost:5000/uaa/users/current #获取用户信息地址
        client:
          clientId: service-hi
          clientSecret: 123456 #资源的密码
          accessTokenUri: http://localhost:5000/uaa/oauth/token #获取的token地址
          grant-type: client_credentials,password #grant-type 类型
          scope: server #作用域

grant_type=client_credentials时，请求的响应中不包含refresh_token:
    
    
    什么时候用client_credentials(客户端模式)作为grant_type?
    Account creation这个API，从业务上说我们期望它可以通过一个未认证过的用户调用，因为在Account创建之前，不存在authenticated user，这种场景下用grant_type=credentails比较合适。
    
    password 模式：
    客户端需要用户的用户名和密码，然后将客户端自己的client_id和client_secret发送给认证服务器，换取access token. 适用于受信客户端，比如一种服务对应的移动客户端。

grant 
    英 /ɡrɑːnt/  美 /ɡrænt/  全球(美国)  
    简明 牛津 新牛津  韦氏  柯林斯 例句  百科
    v. （合法地）授予，允许；（勉强）承认，同意
    n. （政府）拨款，补助金；授予，给予；合法转让，正式授予

### 配置 Resource Server ###

@Configuration
    @EnableResourceServer
    @EnableGlobalMethodSecurity(prePostEnabled = true)
    public class ResourceServerConfigurer extends ResourceServerConfigurerAdapter { 
    
        @Override
        public void configure(HttpSecurity http) throws Exception { 
    
            http.authorizeRequests()
                    .antMatchers("/user/registry").permitAll()
                    .anyRequest().authenticated();
        }
    
    }

### 配置 OAuth2 Client ###

@EnableOAuth2Client
    @EnableConfigurationProperties //开启 属性配置文件
    @Configuration
    public class OAuth2ClientConfig { 
    
    
        @Bean //server-id 密码等，都读取出来了
        @ConfigurationProperties(prefix = "security.oauth2.client") //读取属性的信息
        public ClientCredentialsResourceDetails clientCredentialsResourceDetails() { 
            return new ClientCredentialsResourceDetails();
        }
    
        /** * @EnableOAuth2Client. * 1.oauth2ClientContextFilter * 2.AccessTokenRequest */
        @Bean
        public RequestInterceptor oauth2 FeignRequest Interceptor(){ 
            return new OAuth2FeignRequestInterceptor(new Default OAuth2 ClientContext(), client Credentials ResourceDetails());
        }
    
        @Bean
        public OAuth2RestTemplate clientCredentialsRestTemplate() { 
            return new OAuth2 RestTemplate(clientCredentialsResourceDetails());
        }
    }

### 编写用户注册接口 ###

#### user不变 ####

@Entity
    public class User implements UserDetails, Serializable { 
    	@Id
    	@GeneratedValue(strategy = GenerationType.IDENTITY)
    	private Long id;
    
    	@Column(nullable = false,  unique = true)
    	private String username;
    
    	@Column
    	private String password;
    
    	@ManyToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
    	@JoinTable(name = "user_role", joinColumns = @JoinColumn(name = "user_id", referencedColumnName = "id"),
    			inverseJoinColumns = @JoinColumn(name = "role_id", referencedColumnName = "id"))
    	private List<Role> authorities;
    
    	@Override
    	public Collection<? extends GrantedAuthority> getAuthorities() { 
    		return authorities;
    	}
    
    	public void setAuthorities(List<Role> authorities) { 
    		this.authorities = authorities;
    	}
    
    }

#### dao service不变 ####

public interface UserDao extends JpaRepository<User, Long> { 
    
    	User findByUsername(String username);
    }
    
    @Service
    public class UserServiceImpl   { 
    
    	private static final BCryptPasswordEncoder encoder = new BCryptPasswordEncoder();
    
    	@Autowired
    	private UserDao userDao;
    
    
    	public User create(String username, String password) { 
    
    		User user=new User();
    		user.setUsername(username);
    		String hash = encoder.encode(password);
    		user.setPassword(hash);
    		User u=userDao.save(user);
    		return u;
    
    	}
    }

#### hiController ####

@RestController
    public class HiController { 
        Logger logger= LoggerFactory.getLogger(HiController.class);
    
        @Value("${server.port}")
        String port;
    
    
        @RequestMapping("/hi")
        public String home() { 
            return "hi :"+",i am from port:" +port;
        }
    
        @PreAuthorize("hasAuthority('ROLE_ADMIN')")  // 需要ADMIN
        @RequestMapping("/hello")
        public String hello (){ 
            return "hello you!";
        }
        
        //注意了调用 这些接口的时候，会先调用 Uaa授权服务器的 /current 接口，获得 principal 的
        //OAuth2Authentication 和 principal 里面都有 Authentication
        //获得 oAuth2Authentication。 参数为：OAuth2Authentication principal Authentication
        @GetMapping("/getPrinciple")
        public OAuth2Authentication getPrinciple(OAuth2Authentication oAuth2Authentication, Principal principal,
                                 Authentication authentication){ 
         
                    logger.info(oAuth2Authentication.getUserAuthentication().getAuthorities().toString());//[ROLE_ADMIN]
            
            logger.info(oAuth2Authentication.toString());
            
            logger.info("principal.toString()"+principal.toString());
            
            //miya2
            logger.info("principal.getName()"+principal.getName());
            
            //authentication:[ROLE_ADMIN]
            logger.info("authentication:"+authentication.getAuthorities().toString());
    
            return oAuth2Authentication;
    
        }
    }

authentication 
    英 /ɔːˌθentɪˈkeɪʃn/  美 /ɔːˌθentɪˈkeɪʃn/  全球(美国)  
    简明 例句  百科
    n. 证明；鉴定；证实

logger.info(oAuth2Authentication.toString()); 的结果：
        
    org.springframework.security.oauth2.provider.OAuth2Authentication@ca439b0b: Principal: miya2; Credentials: [PROTECTED]; Authenticated: true; Details: remoteAddress=0:0:0:0:0:0:0:1, sessionId=<SESSION>, tokenType=BearertokenValue=<TOKEN>; Granted Authorities: ROLE_ADMIN
        
    logger.info("principal.toString()"+principal.toString()); 
        
    principal.toString()org.springframework.security.oauth2.provider.OAuth2Authentication@ca439b0b: Principal: miya2; Credentials: [PROTECTED]; Authenticated: true; Details: remoteAddress=0:0:0:0:0:0:0:1, sessionId=<SESSION>, tokenType=BearertokenValue=<TOKEN>; Granted Authorities: ROLE_ADMIN

authentication 
    英 /ɔːˌθentɪˈkeɪʃn/  美 /ɔːˌθentɪˈkeɪʃn/  全球(美国)  
    简明 例句  百科
    n. 证明；鉴定；证实
    
    principal 
    英 /ˈprɪnsəpl/  美 /ˈprɪnsəpl/  全球(英国)  
    简明 牛津 新牛津  韦氏  柯林斯 例句  百科
    adj. 主要的；资本的
    n. 首长；校长；资本；当事人

@GetMapping("/getPrinciple")
       OAuth2Authentication 对象的返回
    
    { 
        "authorities": [
            { 
                "authority": "ROLE_ADMIN"
            }
        ],
        "details": { 
            "remoteAddress": "0:0:0:0:0:0:0:1",
            "sessionId": "AE0D972E76622AB0C66BEC3C7DC36B02",
            "tokenValue": "f7b5d09e-8511-4f26-af22-a6d32befc79d",
            "tokenType": "Bearer",
            "decodedDetails": null
        },
        "authenticated": true,
        "userAuthentication": { 
            "authorities": [
                { 
                    "authority": "ROLE_ADMIN"
                }
            ],
            "details": { 
                "authorities": [
                    { 
                        "id": 2,
                        "authority": "ROLE_ADMIN"
                    }
                ],
                "details": { 
                    "remoteAddress": "127.0.0.1",
                    "sessionId": null,
                    "tokenValue": "f7b5d09e-8511-4f26-af22-a6d32befc79d",
                    "tokenType": "Bearer",
                    "decodedDetails": null
                },
                "authenticated": true,
                "userAuthentication": { 
                    "authorities": [
                        { 
                            "id": 2,
                            "authority": "ROLE_ADMIN"
                        }
                    ],
                    "details": { 
                        "grant_type": "password",
                        "username": "miya2"
                    },
                    "authenticated": true,
                    "principal": { 
                        "id": 10,
                        "username": "miya2",
                        "password": "$2a$10$gzkGPXp05IAGDsoCBMjkP.aF1zY2xTQcaZftkoCn/yb2GMWUANrZi",
                        "authorities": [
                            { 
                                "id": 2,
                                "authority": "ROLE_ADMIN"
                            }
                        ],
                        "enabled": true,
                        "credentialsNonExpired": true,
                        "accountNonExpired": true,
                        "accountNonLocked": true
                    },
                    "credentials": null,
                    "name": "miya2"
                },
                "credentials": "",
                "principal": { 
                    "id": 10,
                    "username": "miya2",
                    "password": "$2a$10$gzkGPXp05IAGDsoCBMjkP.aF1zY2xTQcaZftkoCn/yb2GMWUANrZi",
                    "authorities": [
                        { 
                            "id": 2,
                            "authority": "ROLE_ADMIN"
                        }
                    ],
                    "enabled": true,
                    "credentialsNonExpired": true,
                    "accountNonExpired": true,
                    "accountNonLocked": true
                },
                "oauth2Request": { 
                    "clientId": "service-hi",
                    "scope": [
                        "server"
                    ],
                    "requestParameters": { 
                        "grant_type": "password",
                        "username": "miya2"
                    },
                    "resourceIds": [],
                    "authorities": [],
                    "approved": true,
                    "refresh": false,
                    "redirectUri": null,
                    "responseTypes": [],
                    "extensions": { },
                    "refreshTokenRequest": null,
                    "grantType": "password"
                },
                "clientOnly": false,
                "name": "miya2"
            },
            "authenticated": true,
            "principal": "miya2",
            "credentials": "N/A",
            "name": "miya2"
        },
        "clientOnly": false,
        "principal": "miya2",
        "credentials": "",
        "oauth2Request": { 
            "clientId": "service-hi",
            "scope": [],
            "requestParameters": { },
            "resourceIds": [],
            "authorities": [],
            "approved": true,
            "refresh": false,
            "redirectUri": null,
            "responseTypes": [],
            "extensions": { },
            "grantType": null,
            "refreshTokenRequest": null
        },
        "name": "miya2"
    }

#### UserController ####

@RestController
    @RequestMapping("/user")
    public class UserController { 
    
    	@Autowired
    	private UserServiceImpl userService;
    	
        //注册，参数为 用户名 和 密码
    	@RequestMapping(value = "/registry",method = RequestMethod.POST)
    	public User createUser( @RequestParam("username") String username
    	, @RequestParam("password") String password) { 
    		return userService.create(username,password);
    	}
    
    }

### 测试 ###

#### 注册用户 ####

post请求：
    http://localhost:8762/user/registry?username=miya2&password=123456

{ 
        "id": 10,
        "username": "miya2",
        "password": "$2a$10$gzkGPXp05IAGDsoCBMjkP.aF1zY2xTQcaZftkoCn/yb2GMWUANrZi",
        "authorities": null,
        "enabled": true,
        "accountNonExpired": true,
        "credentialsNonExpired": true,
        "accountNonLocked": true
    }

#### 获取token ####

post
    http://localhost:5000/uaa/oauth/token?grant_type=password&username=miya2&password=123456
    
    hearder 头 和 velue
    Authorization
    Basic c2VydmljZS1oaToxMjM0NTY=

{ 
        "access_token": "107ceaa2-cd9a-427e-8cd4-fe055075131a",
        "token_type": "bearer",
        "refresh_token": "39e59340-6daf-49af-b918-c639e454c97e",
        "expires_in": 43199,
        "scope": "server"
    }

#### 访问权限的接口 ####

/hi

Get请求：
    http://localhost:8762/hi
    
    header信息：
    Authorization 
    Bearer 107ceaa2-cd9a-427e-8cd4-fe055075131a
    
    可以访问成功
    访问：
    http://localhost:8762/hello
    
    返回：
    { 
        "error": "access_denied",
        "error_description": "不允许访问"
    }

增加 用户_角色 的关联。 10（用户ID） 2（管理员角色ID）
    
    再次访问 获得token的接口：得到最新的token，访问，访问成功
    
    http://localhost:8762/hello
    
    Authorization
    Bearer 107ceaa2-cd9a-427e-8cd4-fe055075131a
    
    hello you!