(Steps taken from: https://www.baeldung.com/x-509-authentication-in-spring-security)
All passwords: changeit
openssl req -x509 -sha256 -days 3650 -newkey rsa:4096 -keyout rootCA.key -out rootCA.crt
gvsrini
gvsrini
/ create_x509_certs.md
Created
October 5, 2023 04:34
— forked from dasniko/create_x509_certs.md
Creating self signed tls certificates with self-signed root CA
gvsrini
/ postgres_queries_and_commands.sql
Created
November 14, 2018 11:46
— forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 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
/ delete data from transactions
Created
May 22, 2017 08:44
— forked from BhargaviTelpunuri/delete data from transactions
delete data from transactions
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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-api.md
Created
July 4, 2014 14:09
— forked from medikoo/tiw-maxcom-api.md
Shared Secret string used to validate requests: B117F156FDFEE0AEF47AC2D2B9743057DFA1A75A999B76221AB3FC0A9862792E
POST https://online.maxcomafrica.com/???
gvsrini
/ tiw-maxcom-api.md
Last active
May 29, 2021 13:31
— forked from medikoo/tiw-maxcom-api.md
gvsrini
/ tiw-maxcom-api.md
Last active
August 29, 2015 14:02
— forked from medikoo/tiw-maxcom-api.md