INSERT INTO BANKS VALUES('2ebf6b62-069b-496b-89f1-c4b4b08e04ae','Lion','Lion','Lion Bank Ltd.','/netbank/images/bank/lion.svg','https://api.lion.mlabs.dpc.hu:8243/token','https://api.lion.mlabs.dpc.hu:8243/open-banking/v3.1/aisp/v3.1.2','Jg7O55zbOOlJiSJOaG9Qm5nq7qsa','rEpxSqsEJUUGrJt8dcWsvAxIhx8a','https://acefintech.mlabs.dpc.hu/netbank/customer/banks/authorize','acefintech','https://api.lion.mlabs.dpc.hu:8243/authorize','https://api.lion.mlabs.dpc.hu:8243/open-banking/v3.1/pisp/v3.1.2');INSERT INTO BANKS VALUES('7a807744-a081-4da7-ba67-00a4936b9133','Elephant','Elephant','Elephant Bank Ltd.','/netbank/images/bank/elephant.svg','https://api.elephant.mlabs.dpc.hu:8243/token','https://api.elephant.mlabs.dpc.hu:8243/open-banking/v3.1/aisp/v3.1.2','W1q6iz4uygm1O9zFWJhc20xEpV8a','s301JImQb0aRuLndn6kKpf67cQUa','https://acefintech.mlabs.dpc.hu/netbank/customer/banks/authorize','acefintech','https://api.elephant.mlabs.dpc.hu:8243/authorize','https://api.elephant.mlabs.dpc.hu:8243/open-banking/v3.1/pisp/v3.1.2');
BANKS table structure
id
UUID for identify a bank
eg: 2293e2cf-1c54-38cf-9934-6be4e94e60f8
Use only internally. We just generate random UUID value.
name
Name of the bank
eg: Lion
shortName
Short name of the bank
eg: Lion
longName
Long name of the bank
eg: Lion Bank Ltd.
logoUrl
url for the bank logo.
eg: /images/bank/lion.svg
Bank logo images can found at GUI application.
accounts_url
Accounts API url, defined via Bank at Publisher site.
eg: https://api.lion.mlabs.dpc.hu:8243/open-banking/v3.1/aisp/v3.1.2
client_id
LionFintech application OAuth client id (consumer key).
eg: PttPN26uJLQgvRjSrhmh5ShaqZga
You can find at API Store. This value must be identical with WSO2 API Store values.
client_secret
LionFintech application OAuth client secret (consumer secret).
eg: gUPRoq7QUgkuBkdLIkLc1d6fJhka
You can find at API Store. This value must be identical with WSO2 API Store values.
callback_url
LionFintech OAuth callback url. After user OAuth authorization, the WSO2 call this url. In OAuth calls we must provide this information too, based on OAuth standard.
eg: https://acefintech.mlabs.dpc.hu/lionfintech/customer/banks/authorize
You can find at API Store. This value must be identical with WSO2 API Store values.
userName
LionFintech username at WSO2 API Store. This username must be identical that user which signed up at API Store.
eg: lionfintech
INSERT INTO USERS
VALUES ('tppuser', '{bcrypt}$2a$10$FgRPdjDFcfxrCzWzVO/mZuWwVEm8CxqRNx4qQAOGVjzh/983lUPJy', TRUE);
INSERT INTO AUTHORITIES
VALUES ('tppuser', 'ROLE_USER');
We defined "tppuser" with "password" password.
Create environment
cd ~
mkdir acefintech
mkdir acefintech/db
mkdir acefintech/config
Create and edit application.properties
acefintech/config/application.properties
#
# This Source Code Form is subject to the terms of the Mozilla
# Public License, v. 2.0. If a copy of the MPL was not distributed
# with this file, You can obtain one at
#
# https://mozilla.org/MPL/2.0/.
#
server.port=8080
server.servlet.context-path=/
####Jetty specific properties########
# Number of acceptor threads to use.
server.jetty.acceptors=1
# Maximum size in bytes of the HTTP post or put content.
server.jetty.max-http-post-size=32768
# Number of selector threads to use.
server.jetty.selectors=1
spring.datasource.url=jdbc:hsqldb:file:/home/ec2-user/acefintech/db/
spring.datasource.username=SA
spring.datasource.password=
spring.datasource.tomcat.max-wait=20000
spring.datasource.tomcat.max-active=50
spring.datasource.tomcat.max-idle=20
spring.datasource.tomcat.min-idle=15
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.HSQLDialect
spring.jpa.properties.hibernate.id.new_generator_mappings = false
spring.jpa.properties.hibernate.format_sql = true
spring.jpa.hibernate.ddl-auto=none
logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
spring.liquibase.enabled=true
logging.level.org.springframework.web.filter.CommonsRequestLoggingFilter=DEBUG
