oauthserver

oauthserver

Domestic users can access gitee and synchronize code with github.

Introduction

oauthserver is a complete independent Oauth2 Server microservice based on Spring Boot Oauth2. The purpose of the project is that you only need to create relevant data tables and modify the database connection information, and you can get an Oauth2 Server microservice.
For the convenience of development, the project is split into 6 modules, eureka-server, oauth, common, api, web, old-task:

1. eureka-server is the eureka service module;
2. oauth is the Authentication Server module, used to authorize other modules (mainly modules that provide API interfaces).
3. Common is a public tool module, including the Service and Model layers. Currently, api, web, and old-task all depend on this module.
4. The api module is a service that provides an api interface;
5. The web is a management backend based on Element UI;
6. old-task is a Quartz distributed scheduled task module that supports clusters.

Supported relational databases:

• MySQL
• Oracle
• PostgreSQL
• Microsoft SQL Server

Feature overview

api

1. Oauth token service supports 3 login methods: mobile phone number + verification code, mobile phone number + password, email + password (for the usage process, please refer to the oauth interface calling example. If you need to use the SMS verification code service, please go to Alibaba and Cloud News SMS service Purchase SMS verification code service and configure relevant parameters in application.properties);
2. SMS verification code service supports three types: Alibaba, Tencent Cloud SMS service, and Yunzhixun SMS service;
3. WeChat and Alipay payment;
4. Qiniu Cloud Storage;
5. Code generator.

common

Public tool module

web

1. Home page
   1. Learn about OauthServer
   2. News management
   3. Order management
2. System management
   1. scheduled tasks
   2. Menu management
   3. User management
   4. Permission management
   5. data dictionary
3. system tools
   1. code generation
   2. swagger
   3. druid
   4. Log management

Change log

2.0.20190909-alpha

1. Remove the oauth authorization code from the api module, leaving only the controller layer code;
2. The oauth authorization code removed from the api module becomes an independent oauth module, which serves as an authorization server and provides authorization services to the api module.

2.0.20190904-alpha

1. Added eureka-server module;
2. Remove some duplicate dependencies;
3. Update Dockerfile.

2.0.20190805-alpha

1. Supports SQL Server.

2.0.20190802-alpha

1. The code generator supports sql server;
2. General implementation of service reduces a lot of redundant serviceImpl code.

For more historical update logs, view CHANGE_LOG.md

Usage process

Prepare

For IntelliJ IDEA or Eclipse, please install the lombok plug-in first.

• For IntelliJ IDEA installation, please refer to https://projectlombok.org/setup/intellij;
• For Eclipse installation, please refer to https://projectlombok.org/setup/eclipse.

1. Install jar

Some self-built jars are not available in the central warehouse and need to be installed locally using mvn install . Execute install.bat installation in the "jars that need to be installed" folder.

2. Create table

Note: Databases ignore case. All SQL files are in the "SQL Initialization" directory.

• MySQL
  Please execute schema-mysql.sql to complete the creation of the data table and the import of test data. After that, execute the corresponding incremental update SQL.
• Oracle
  Please execute schema-oracle.sql to complete the creation of the data table and the import of test data. After that, execute the corresponding incremental update SQL.
• PostgreSQL
  Please execute schema-postgresql.sql to complete the creation of the data table and the import of test data. After that, execute the corresponding incremental update SQL.
• SQL Server
  Please execute schema-sqlserver.sql to complete the creation of the data table and the import of test data. After that, execute the corresponding incremental update SQL.

3. Modify database connection information

• MySQL
  The connection information is in application-mysql.yml . After modifying the database connection information, you also need to set spring.profiles.active=mysql in application-common.yml .
• Oracle
  The connection information is in application-oracle.yml . After modifying the database connection information, you also need to set spring.profiles.active=oracle in application-common.yml .
• PostgreSQL
  The connection information is in application-pg.yml . After modifying the database connection information, you also need to set spring.profiles.active=pg in application-common.yml .
• Microsoft SQL Server
  The connection information is in application-sqlserver.yml . After modifying the database connection information, you also need to set spring.profiles.active=sqlserver in application-common.yml .

4. Run

Start eureka-server first, and then start the oauth authorization module. There is no fixed startup order for other modules. But if you need to use the scheduled task function of the web module, you need to start the old-task module first.

api test

oauth interface calling example

Management page

Test account: mobile phone number 18800000000, password 1234567890c

Share and communicate

If you have any questions or problems during use, please submit an issue and I will reply as soon as possible.