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

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

  483  openssl genrsa -out privatekey.pem 1024
  484  openssl req -new -x509 -key privatekey.pem -out publickey.cer -days 1825
  485  ls -l *pem
  486  openssl req -new -x509 -key privatekey.pem -out publickey.cer -days 1825
  487  ls *.cer
  488  openssl pkcs12 -export -out public_privatekey.pfx -inkey privatekey.pem -in publickey.cer

gvsrini

04090875 2017-07-15 12:19:00
156171021 2017-07-22 13:22:24
20644205 2017-07-20 09:37:07
20644207 2017-07-20 09:37:33
20644223 2017-07-21 08:18:32
20644229 2017-07-21 09:27:02
20644240 2017-07-21 10:54:22
20644241 2017-07-21 10:57:33
04090875 2017-07-15 12:19:00
09956780 2017-07-25 13:35:57

gvsrini

<?xml version="1.0"?>
<!-- 
    Note: As an alternative to hand editing this file you can use the 
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in 
    machine.config.comments usually located in 
    \Windows\Microsoft.Net\Framework\v2.x\Config 
-->
<configuration>

gvsrini

.Helper.LogSoapExtension - QX420TRVV9:<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><postTransactionResponse xmlns="http://microsoft.com/webservices/"><postTransactionResult>00/03559505/2308G012-PEO, RAIGHAR(FPS:2308G012)/RAIGHAR/NAWARANGPUR/2308G012-PEO, RAIGHAR(FPS:2308G012)/Priority Household/0</postTransactionResult></postTransactionResponse></soap:Body></soap:Envelope>
2017-07-26 15:18:15,150 INFO WSTest.Helper.LogSoapExtension - NCGWO0BKE5:<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><postTransactionOffline xmlns="http://microsoft.com/webservices/"><objTransactions><DeviceTxnNo>04090875</DeviceTxnNo><CardNo>25010312472</CardNo><UID>0</UID><OrderStatus>-2</OrderStat

gvsrini

ALTER DATABASE [FPSA]
    ADD FILE 
    (
    NAME = [PartTxnJan],
    FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\JanTxnFPSA.ndf',
        SIZE = 3072 KB, 
        MAXSIZE = UNLIMITED, 
        FILEGROWTH = 1024 KB
    ) TO FILEGROUP [January]

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

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

TIW <-> MaxCom data exchange API

API of MaxCom service

Payment initialization

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

Request data