gvsrini

TIW <-> MaxCom data exchange API

API of MaxCom service

Payment initialization

GET https://online.maxcomafrica.com/EbsPrePG

Request data

gvsrini

TIW <-> MaxCom data exchange API

API of MaxCom service

Payment initialization

GET https://online.maxcomafrica.com/EbsPrePG

Request data

gvsrini

TIW <-> MaxCom data exchange API

Shared Secret string used to validate requests: B117F156FDFEE0AEF47AC2D2B9743057DFA1A75A999B76221AB3FC0A9862792E

API of MaxCom service

Initialization of payment transaction

POST https://online.maxcomafrica.com/???

gvsrini

delete from TRANSACTION_DETAILS_P where TR_SEQ_NO in(select TR_SEQ_NO from TRANSACTION_MASTER_P where ard_no='101101')

delete from TRANSACTION_MASTER_P where ard_no='101101'

delete from FAILED_TRANSACTIONS_TRAILER_P where TR_SEQ_NO in(select TR_SEQ_NO from FAILED_TRANSACTIONS_P where SHOP_NO	='101101')

delete from FAILED_TRANSACTIONS_P where SHOP_NO	='101101'

delete from STOCK_TRAILER_P where DN_SEQ_NO in(select DN_SEQ_NO from STOCK_HEADER_P where shop_no='101101')

gvsrini

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

gvsrini

Create X.509 certificates

(Steps taken from: https://www.baeldung.com/x-509-authentication-in-spring-security)

All passwords: changeit

RootCA

openssl req -x509 -sha256 -days 3650 -newkey rsa:4096 -keyout rootCA.key -out rootCA.crt