Browsed by
Author: Ricky Adams

Generate a CSR from Windows Server using the certificate MMC

Generate a CSR from Windows Server using the certificate MMC

Generate a CSR from Windows Server using the certificate MMC Certificate MMC access Run the MMC either from the start menu or via the run tool accessible fom the WIN+R shortcut. Click on File – Add/Remove Snap-in. Select Certificats in the left panel and click on Add. In the new window, click on Computer Account. Select Local Computer then click on Finish. Complete the adding dialog by clicking OK. Request generation In the certificate management console, select in the folder…

Read More Read More

CRON Jobs, Notation and Examples

CRON Jobs, Notation and Examples

Linux Crontab: 15 Awesome Cron Job Examples by SathiyaMoorthy on June 11, 2009 An experienced Linux sysadmin knows the importance of running the routine maintenance jobs in the background automatically. Linux Cron utility is an effective way to schedule a routine background job at a specific time and/or day on an on-going basis. This article is part of the on-going Productivity Tips For Geeks series. In this article, let us review 15 awesome examples of crontab job scheduling. Linux Crontab…

Read More Read More

Checking Oracle Table Stats

Checking Oracle Table Stats

If you do not run stats on Oracle database the performance degrades over time.  The statements below will show the last stats update date/time.  You must change the OWNER to match your schema of course. select min(STATS_UPDATE_TIME) from ALL_TAB_STATS_HISTORY where OWNER = ‘ADMUSER’ select * from ALL_TAB_STATS_HISTORY where OWNER = ‘ADMUSER’ order by STATS_UPDATE_TIME ASC

Building a Simple Chatbot from Scratch in Python (using NLTK)

Building a Simple Chatbot from Scratch in Python (using NLTK)

Building a Simple Chatbot from Scratch in Python (using NLTK) SOURCE: https://medium.com/analytics-vidhya/building-a-simple-chatbot-in-python-using-nltk-7c8c8215ac6e Source: eWeek Gartner estimates that by 2020, chatbots will be handling 85 percent of customer-service interactions; they are already handling about 30 percent of transactions now. I am sure you’ve heard about Duolingo: a popular language-learning app, which gamifies practicing a new language. It is quite popular due to its innovative styles of teaching a foreign language.The concept is simple: five to ten minutes of interactive training a day…

Read More Read More

Why use Terraform and not Chef, Puppet, Ansible, SaltStack, or CloudFormation

Why use Terraform and not Chef, Puppet, Ansible, SaltStack, or CloudFormation

Why use Terraform and not Chef, Puppet, Ansible, SaltStack, or CloudFormation (by Gruntwork) SOURCE: https://blog.gruntwork.io/why-we-use-terraform-and-not-chef-puppet-ansible-saltstack-or-cloudformation-7989dad2865c Update: we took this blog post series, expanded it, and turned it into a book called Terraform: Up & Running! This is Part 1 of the Comprehensive Guide to Terraform series. In the intro to the series, we discussed why every company should be using infrastructure-as-code (IAC). In this post, we’re going to discuss why we picked Terraform as our IAC tool of choice. If…

Read More Read More

RHEL7: Provide SMB network shares to specific clients.

RHEL7: Provide SMB network shares to specific clients.

RHEL7: Provide SMB network shares to specific clients. Configuration Procedure Install the Samba packages: # yum groupinstall -y “file-server” # yum install -y samba-client samba-winbind Create a new /etc/samba/smb.conf file and add the following lines (for a workgroup named MYGROUP, a server called MYSERVER, a local network with IP addresses in 192.168.1.0/24, a user named user01 and a share called shared): workgroup = MYGROUP server string = Samba Server Version %v netbios name = MYSERVER interfaces = lo eth0 192.168.1.0/24 hosts allow = 127. 192.168.1. log file = /var/log/samba/log.%m max…

Read More Read More

Retrieve Server Name and Instance from MS SQL Server (TSQL)

Retrieve Server Name and Instance from MS SQL Server (TSQL)

SELECT SERVERPROPERTY(‘MachineName’) AS [ServerName], SERVERPROPERTY(‘ServerName’) AS [ServerInstanceName], SERVERPROPERTY(‘InstanceName’) AS [Instance], SERVERPROPERTY(‘Edition’) AS [Edition], SERVERPROPERTY(‘ProductVersion’) AS [ProductVersion], Left(@@Version, Charindex(‘-‘, @@version) – 2) As VersionName

Jira Copy Custom Field to Another Customer Field

Jira Copy Custom Field to Another Customer Field

(Backup your data first, use at your own risk) set @rank=0; INSERT INTO jiradb.customfieldvalue SELECT 12101 + @rank:=@rank+1 as ID, a.ISSUE, 10308 as CUSTOMFIELD, a.UPDATED, a.PARENTKEY,a.STRINGVALUE, a.NUMBERVALUE,a.TEXTVALUE, a.DATEVALUE, a.VALUETYPE FROM jiradb.customfieldvalue a left join jiradb.customfieldvalue b on a.ISSUE = b.ISSUE and b.CUSTOMFIELD = 10308 where a.CUSTOMFIELD = 10800 and a.ISSUE = 11763; where 12101 is the max(ID) of the table to insert into 10308 is the new customerfieldID to be inserted 10800 is the from customfieldID to get the data…

Read More Read More

Verification and Validation

Verification and Validation

The Verification and Validation process areas are similar, but they address different issues. Validation demonstrates that the product, as provided (or as it will be provided), will fulfill its intended use, whereas Verification addresses whether the work product properly reflects the specified requirements. In other words, verification ensures that you built it right; whereas, validation ensures that you built the right thing. (from CMMI-Dev V1.3 Model) Verification is a testing which ensures that the product and product components meets the requirement…

Read More Read More

SQL Server (TSQL) vs. Oracle (PLSQL) Data Types

SQL Server (TSQL) vs. Oracle (PLSQL) Data Types

SQL Server Oracle Exact Numerics TINYINT NUMBER(3) SMALLINT NUMBER(5) INTEGER NUMBER(10) BIGINT NUMBER(19) DECIMAL(p,s) NUMBER(p,s) NUMERIC(p,s) NUMBER(p,s) SMALLMONEY NUMBER(10,4) MONEY NUMBER(19,4) Approximate Numerics REAL BINARY_FLOAT FLOAT BINARY_DOUBLE Date Time SMALLDATETIME TIMESTAMP(3) DATETIME TIMESTAMP(3) DATETIME2(fs) TIMESTAMP(fs) DATETIMEOFFSET(fs) TIMESTAMP (fs) WITH TIME ZONE DATETIMEOFFSET(fs) TIMESTAMP (fs) WITH LOCAL TIME ZONE Character strings CHAR(x) CHAR(x) VARCHAR(x) ARCHAR2(x) VARCHAR(MAX) CLOB TEXT LONG Binary strings BINARY(n) RAW(n) VARBINARY(n) LONG RAW VARBINARY(MAX) LONG RAW or BLOB IMAGE LONG RAW Binary strings XML XMLTYPE BIT NUMBER(1) TIMESTAMP…

Read More Read More

Using Special Keys in Selenium IDE

Using Special Keys in Selenium IDE

Using Special Keys in Selenium IDE – Part 1 Posted on September 25, 2013 by Samit Badle I added special keys support to the sendKeys command in Selenium IDE v2.3.0. Not just in normal playback, but also in Webdriver playback. Along with this, I added special keys support to all the officially supported formatters for Java, Ruby, Python and C#. And also the Perl Webdriver formatter. Yes, the Perl Webdriver formatter, it exists and will be released soon. It is…

Read More Read More

Wildfly Notes

Wildfly Notes

Everything should be done into your <$JBOSS_HOME>/bin folder: Start Linux: $ ./standalone.sh & Windows: > standalone.bat Stop Linux: $ ./jboss-cli.sh –connect command=:shutdown Windows: > jboss-cli.bat –connect command=:shutdown Restart Linux: $ ./jboss-cli.sh –connect command=:reload Windows: > jboss-cli.bat –connect command=:reload Start in domain mode Linux: $ ./domain.sh & Windows: > domain.bat

Installing Oracle Weblogic

Installing Oracle Weblogic

What is Weblogic? Oracle WebLogic Server is a Java EE 6 compatible application server that is part of Oracle Fusion Middleware suite of products. The WebLogic Server complete implementation of the Java EE 6 specification provides a standard set of APIs for creating distributed Java applications that can access a wide variety of services, such as databases, messaging services and connections to external Enterprise systems. End-user clients can access these applications using Web browser or standalone Java clients. It also…

Read More Read More

KeyTool (Java Keystore SSL)

KeyTool (Java Keystore SSL)

Java SSL (keytool) Import a CA cert into a java keystore keytool -import -file ca-cert.pem -keystore /path/to/keystore -trustcacerts (-trustcacerts is important when adding a CA cert as it will add the CA cert to the keystore trust chain) The root CA cert should be all that’s necessary for Java cert verification; it doesn’t seem to require the intermediate CA certs like OpenSSL does. List the certs in a keystore keytool -list -v -keystore /path/to/keystore     Working with JCE keystores If…

Read More Read More

DER vs. CRT vs. CER vs. PEM Certificates and How To Convert Them

DER vs. CRT vs. CER vs. PEM Certificates and How To Convert Them

DER vs. CRT vs. CER vs. PEM Certificates and How To Convert Them Certificates and Encodings At its core an X.509 certificate is a digital document that has been encoded and/or digitally signed according to RFC 5280. In fact, the term X.509 certificate usually refers to the IETF’s PKIX Certificate and CRL Profile of the X.509 v3 certificate standard, as specified in RFC 5280, commonly referred to as PKIX for Public Key Infrastructure (X.509). X509 File Extensions The first thing…

Read More Read More

Common Java Keytool Keystore Commands

Common Java Keytool Keystore Commands

Java Keytool is a key and certificate management utility. It allows users to manage their own public/private key pairs and certificates. It also allows users to cache certificates. Java Keytool stores the keys and certificates in what is called a keystore. By default the Java keystore is implemented as a file. It protects private keys with a password. A Keytool keystore contains the private key and any certificates necessary to complete a chain of trust and establish the trustworthiness of…

Read More Read More

Virtual Desktops Using KVM (KVM-VDI)

Virtual Desktops Using KVM (KVM-VDI)

KVM-VDI This project aims to provide fully functional VDI solution by using open source virtualization. Project supports two types of virtualization backend: plain QEMU-KVM and OpenStack (still in development). KVM-VDI KVM backend Aim of this module is to provide fully functional VDI solution by using QEMU-KVM hypervisor. Module consists of three parts: Dashboard. A webservice, which provides virtual machine control. Thin client. A collection of scripts (thin_clients directory), which are run from thin client side (must be copied /usr/local/bin on…

Read More Read More