Tuesday, April 23, 2019

Update SSH Config to accept ssh-dss Key

Add the following lines of code to the file called config under .ssh folder, If you don't find a file with the name config create one,

.ssh\config

Host *
HostkeyAlgorithms +ssh-dss
PubkeyAcceptedKeyTypes +ssh-dss

Note: When server respond with ssh-dss some ssh clients don't accept the connection. If you get ssh returns “Bad owner or permissions on ~/.ssh/config” then please change the permissions as follows,

chmod 600 ~/.ssh/config

Thursday, March 21, 2019

Generate Self-Sign Certificate with SHA512

openssl req -newkey rsa:2048 -sha512 -nodes -keyout key.pem -x509 -days 365 -out certificate.pem
openssl x509 -text -noout -in certificate.pem
openssl pkcs12 -inkey key.pem -in certificate.pem -export -out certificate.p12
openssl pkcs12 -in certificate.p12 -noout -info
openssl pkcs12 -inkey key.pem -in certificate.pem -export -out certificate.p12
openssl pkcs12 -in certificate.p12 -noout -info
openssl pkcs12 -in /tmp/certificate.p12 -nokeys -out sirish_test.cer

Friday, November 2, 2018

Sterling Integrator User, Workflow Queries

Active Worksflows in Sterling Integrator

select DISTINCT NAME , WC2.WORKFLOW_ID, sysdate - START_T AS TIMEDIFF
From WORKFLOW_CONTEXT WC,
(
SELECT MAX(STEP_ID) STEP_ID , MIN(START_TIME) START_T, WORKFLOW_ID
FROM WORKFLOW_CONTEXT
GROUP BY WORKFLOW_ID
) WC2,
WFD
WHERE WC.WORKFLOW_ID = WC2.WORKFLOW_ID
AND WC.STEP_ID = WC2.STEP_ID
AND WC.NEXT_AI_ID != -1
AND WC.WFD_ID = WFD.WFD_ID
AND WC.WFD_VERSION = WFD.WFD_VERSION
AND BASIC_STATUS = 0

Sterling Integrator User & User Associated Groups List 

select YFS_USER.LOGINID, YFS_USER_GROUP.USERGROUP_NAME from YFS_USER, YFS_USER_GROUP, YFS_USER_GROUP_LIST
where YFS_USER.USER_KEY=YFS_USER_GROUP_LIST.USER_KEY
and YFS_USER_GROUP.USERGROUP_KEY=YFS_USER_GROUP_LIST.USERGROUP_KEY

Tuesday, June 5, 2018

SSHKeyGrabber in Sterling Integrator not working

http://www-01.ibm.com/support/docview.wss?uid=swg21628336

Sometimes SSHKeyGrabber don't work when we trying to extract Known Host Key from Sterling Integrator UI. The work around for this is disable StrictHostKeyChecking and download the Key from Linux/Windows and Check in the key to Sterling Integrator.

$ssh -o StrictHostKeyChecking=no user@sftp.host.com -p 22

Above command will save host key to known_hosts file located .~/.ssh/known_hosts

Note: Remove excess content from host key and just keep the key from ssh-rsa followed the key. 

Tuesday, May 22, 2018

B2BI MESA API/JAR's for Custom Service Development

asset.jar
b2b_aee.jar
b2b_base.jar
b2b_oba.jar
ebics.jar
entities.jar
gis.jar
install_foundation.jar
mailbox.jar
maverick-all.jar
perimeter.jar
platform_activemq.jar
platform_activity.jar
platform_afc.jar
platform_afc_security.jar
platform_aop.jar
platform_asi.jar
platform_baseutils.jar
platform_dv.jar
platform_ifcbase.jar
platform_ifcui.jar
platform_osgi.jar
platform_security.jar
platform_services.jar
resources.jar
soap.jar
standards.jar
translator.jar

Saturday, April 7, 2018

Launching ikeyman from IBM JDK

Navigate to IBM JDK bin directory and execute the following command,

C:\Sirish\Softwares\ibm_sdk80\bin>java com.ibm.gsk.ikeyman.Ikeyman

Tuesday, September 12, 2017

Integration Concepts

Amazon EC2 (Amazon Elastic Compute Cloud)?
Amazon Elastic Compute Cloud (Amazon EC2) provides scalable computing capacity in the Amazon Web Services (AWS) cloud. Using Amazon EC2 eliminates your need to invest in hardware up front, so you can develop and deploy applications faster. You can use Amazon EC2 to launch as many or as few virtual servers as you need, configure security and networking, and manage storage. Amazon EC2 enables you to scale up or down to handle changes in requirements or spikes in popularity, reducing your need to forecast traffic.

Amazon S3?
Amazon Simple Storage Service is storage for the Internet. It is designed to make web-scale computing easier for developers.
Amazon S3 has a simple web services interface that you can use to store and retrieve any amount of data, at any time, from anywhere on the web. It gives any developer access to the same highly scalable, reliable, fast, inexpensive data storage infrastructure that Amazon uses to run its own global network of web sites. The service aims to maximize benefits of scale and to pass those benefits on to developers.

Amazon DynamoDB & Amazon RDS databases?

DynamoDB makes it simple and cost-effective to store and retrieve any amount of data, as well as serve any level of request traffic. All data items are stored on solid-state drives, which provide high I/O performance and can more efficiently handle high-scale requests. An AWS user interacts with the service by using the AWS Management Console or a DynamoDB API.

DynamoDB uses a NoSQL database model, which is nonrelational, allowing documents, graphs and columnar among its data models. A user stores data in DynamoDB tables, then interacts with it via GET and PUT queries, which are read and write operations, respectively.

Amazon CloudFront CDN?

Amazon CloudFront is a content delivery network (CDN) offered by Amazon Web Services. Content delivery networks provide a globally-distributed network of proxy servers which cache content, such as web videos or other bulky media, more locally to consumers, thus improving access speed for downloading the content.

Cloud vs Hybrid Cloud?
It's inclusion of Public and Private.

How will you stop a dos attack?

how will you troubleshoot a process in linux?

Answer was using, netstat, ps, lsof, gdb, top. the answer he was expecting was thread dump. this was troubleshooting httpd. you can only thread dump on java but i didn't want to argue with the guy, i just said I dont use that. He thinks he can do thread dump on any process obviously he never really troubleshooted any process in linux

What is error 500?

What is the difference between rdb and nosql?

how would you set up a server with db, no downtime, redundant, resilient, multi location, ..etc?

how will you troubleshoot issues on linux, like network, process..etc?

Lots of S.T.A.R. questions?

tell me a time when you have failed, achieved something more than you think?

stressed, ...etc how did you deal with it, what did you do...etc ?

when you enter a domain name into browser , what happens?

What is proxy?

What is the difference proxy and routing?

how CDN works?

What is IDS/IPS, which layer in osi does it work?

how would you do a sql replication?

What is NAT?

What is PAT?

how does load balancer works? which brand would you use? (I5)

how would you connect to your servers for administration and troubleshooting, linux and windows?

what are the differences between windows and linux?

what is error 500 on a web page?

esxi hosts?

VMWare Servers?

physical supermicro superservers?

Why HP?

The frustration was that in-person interview was mostly questions about what I like to do on weekends, what are my hobbies?

Design a fully redundant web solution in AWS?

Complicated Customer support and escalation scenarios?

How do you scale your 2 web and 1 DB app to 1000s of users and accept ordering system. Load Balancer, CDN, Storage?

Describe for us your process for working through a customer issue resolution cycle and your approach to customer communication?

SAN/NAS differences?

Troubleshooting in a "hybrid cloud" environments?

RAID basics?

My interest in cloud and any personal or professional experience there?

SQL/NoSQL, architectural questions?

Tell me about a time" questions, etc?

Technical questions - being to the point, architectural - discussed a lot, thought out loud, with pros and cons, multiple solutions and why. In behavior questions, emphasized on "I" and what I did as individual with STAR approach?

What is the difference between DoS and DDoS?
The Difference Between DoS and DDos Attacks. A Denial of Service (DoS) attack is different from a DDoS attack. The DoS attack typically uses one computer and one Internet connection to flood a targeted system or resource. The DDoS attack uses multiple computers and Internet connections to flood the targeted resource.

Networking (DNS, IPsec, BGP, VPN, Load Balancing)

Database (MySQL, SQL, Oracle)

Tools for Operations Automation and Configuration Management (e.g. Chef/Puppet)

Continuous Integration?











Friday, July 21, 2017

Wake up before your competition do!

Some inspiration from 5AM group on Facebook

You might not have a competitive advantage over your competition and maybe you don't have all the tools and resources to play with the big boys in your industry.
~
But one thing you do have is the ability to out work your competition!
~
You don't need to come up with anymore excuses about why you aren't where you want to be, what you need to do is get up earlier, show up and show the world you're not here to make up the numbers and be another statistic!
~
If you're not prepared to out work your competition and wake up before 5am every single day then maybe it's time to ask yourself how serious you are about your goals and dreams!
~
Stop doing normal things and stop performing at average levels because that is exactly why you aren't where you want to be...
~
Be unusual, be abnormal, be obsessed, be prepared to wake up at 4:00am and work harder than anyone you've ever met because that is the only way you're ever going to become exceptional, renowned, world class and successful.
~
You've tried normal and you know where that gets you so now it's time to try crazy, obsessive, intense and exceptional and once you commit to that path....your life will never be the same again!

Wednesday, July 12, 2017

Grab Known Host Key From Remote SFTP Server in OpenSSH Format

1. Get the host key by running this command: ssh-keyscan > /tmp/ssh_out.openssh

2. Convert the host key format by running this command: ssh-keygen -l -f /tmp/ssh_out.openssh

Wednesday, March 8, 2017

Determine Which version of Windows Installer is installed

To determine which version of Windows Installer is installed on a computer, follow these steps:

1) Click Start, click Run, type %systemroot%\system32, and then click. OK.
2) Right-click Msi.dll, and then click. Properties.
3) Click the Version tab, and then note the File version number.

Wednesday, November 2, 2016

JMeter SSH Sampler

https://github.com/linkeshkanna/Jmeter.SSH.FTP.Request

Jmeter Custom Sampler to make SFTP Request
To Create SSH FTP Requests in JMeter, we need this custom Sampler. This contains two jar files. 1. jmeter-ssh-sampler-1.0.2-SNAPSHOT.jar 2. jsch-0.1.53.jar We can generate this by downloading the source and building it using Maven.
I just built it using maven and checked in the jar files here.
To install this in Jmeter, 1. Copy the jmeter-ssh-sampler-1.0.2-SNAPSHOT.jar to the "Jmeter/Lib/ext" directory. 2. Copy the "jsch-0.1.53.jar" to the "Jmeter/Lib" directory 3. Restart Jmeter.
I have also added a sample test to list of the directory contents in a Public SFTP Server.