Skip to content

Instantly share code, notes, and snippets.

View gvsrini's full-sized avatar

gvsrini

8 followers · 7 following
View GitHub Profile
@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
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
-- 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
gvsrini / Generate Public Private key and corresponding pfx
Created October 17, 2018 15:36
Generate Public Private key and corresponding pfx
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
gvsrini / Empty txns
Created July 26, 2017 12:48
Empty txns
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
gvsrini / chart
Last active July 26, 2017 11:17
chart
<?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
gvsrini / exception
Created July 26, 2017 10:06
exception
.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
gvsrini / gist:ba840c81ee8dba87c2015c2e2a514969
Created July 11, 2017 12:18
TxnPartitions
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
gvsrini / delete data from transactions
Created May 22, 2017 08:44 — forked from BhargaviTelpunuri/delete data from transactions
delete data from transactions
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
gvsrini / tiw-maxcom-api.md
Created July 4, 2014 14:09 — forked from medikoo/tiw-maxcom-api.md

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
gvsrini / tiw-maxcom-api.md
Last active May 29, 2021 13:31 — forked from medikoo/tiw-maxcom-api.md