Home > database >  Cas server connection mysqlshi 'bai
Cas server connection mysqlshi 'bai

Time:10-11

Before using the default account login password is ok

Then add the database after failure;

The new configuration:
Pom. XML:

Org. Apereo. Cas
Cas server - support - jdbc
${cas. Version} & lt;/version>




Org. Apereo. Cas
Cas server - support - JDBC - drivers
${cas. Version} & lt;/version>


The new properties:
# Query the Database Authentication Database Query check username start
# password SQL query account, must contain password field
Cas. Authn. JDBC. The query [0]. SQL=select * from casuser where username=?
# specifies the SQL query above the field name (must)
Cas. Authn. JDBC. The query [0]. FieldPassword=password
# database driven
Cas. Authn. JDBC. The query [0]. DriverClass=com. Mysql.. JDBC Driver
# database connection
Cas. Authn. JDBC. The query [0]. Url=JDBC: mysql://localhost: 3306/cas? UseUnicode=true& CharacterEncoding=utf-8 & amp; UseSSL=false& ServerTimezone=GMT& AllowPublicKeyRetrieval=true
# database user name
Cas. Authn. JDBC. The query [0]. User=root
# database password
Cas. Authn. JDBC. The query [0]. Password=XXXXX

# Query the Database Authentication Database Query check end user name
Database and table are right
After add these input account close cannot login:
WHO: audit: unknown
WHAT: [event=success, timestamp=Fri May 29 18:48:31 CST 2020, source=RankedAuthenticationProviderWebflowEventResolver]
ACTION: AUTHENTICATION_EVENT_TRIGGERED
APPLICATION: CAS
The WHEN: Fri May 29 18:48:31 CST 2020
The CLIENT IP ADDRESS: 127.0.0.1
SERVER IP ADDRESS: 127.0.0.1
=============================================================


The 2020-05-29 18:48:41, WARN 201 [org. Apereo. Cas. The authentication. PolicyBasedAuthenticationManager] - & lt; Authentication has failed. The Credentials may be incorrect or CAS always find the Authentication handler that supports [liaozeyu] of type [UsernamePasswordCredential], which suggests a configuration problem. J & gt;
The 2020-05-29 18:48:41, 210 INFO [. Org. Apereo inspektr. Audit. Support. Slf4jLoggingAuditTrailManager] - & lt; Audit trail record BEGIN
=============================================================
WHO: liaozeyu
WHAT: the Supplied credentials: [liaozeyu]
ACTION: AUTHENTICATION_FAILED
APPLICATION: CAS
The WHEN: Fri May 29 18:48:41 CST 2020
The CLIENT IP ADDRESS: 127.0.0.1
SERVER IP ADDRESS: 127.0.0.1
  • Related