Re: halinquirytest.halw.com Cert – Checking SSL Certs

Command Executed:

Preeti-Fnus-MacBook-Pro:security root# openssl s_client -connect halinquirytest.halw.com:443 -showcerts
CONNECTED(00000003)
depth=0 /OU=Domain Control Validated/CN=halinquirytest.halw.com
verify error:num=20:unable to get local issuer certificate
verify return:1
depth=0 /OU=Domain Control Validated/CN=halinquirytest.halw.com
verify error:num=27:certificate not trusted
verify return:1
depth=0 /OU=Domain Control Validated/CN=halinquirytest.halw.com
verify error:num=21:unable to verify the first certificate
verify return:1

---
Certificate chain
0 s:/OU=Domain Control Validated/CN=halinquirytest.halw.com
i:/C=US/ST=Arizona/L=Scottsdale/O=GoDaddy.com, Inc./OU=http://certs.godaddy.com/repository//CN=Go Daddy Secure Certificate Authority - G2
-----BEGIN CERTIFICATE-----
MIIFRzCCBC+gAwIBAgIJAOuSdfQd4EJsMA0GCSqGSIb3DQEBCwUAMIG0MQswCQYD
VQQGEwJVUzEQMA4GA1UECBMHQXJpem9uYTETMBEGA1UEBxMKU2NvdHRzZGFsZTEa
MBgGA1UEChMRR29EYWRkeS5jb20sIEluYy4xLTArBgNVBAsTJGh0dHA6Ly9jZXJ0
cy5nb2RhZGR5LmNvbS9yZXBvc2l0b3J5LzEzMDEGA1UEAxMqR28gRGFkZHkgU2Vj
dXJlIENlcnRpZmljYXRlIEF1dGhvcml0eSAtIEcyMB4XDTE1MDgyNTIxNTUzOFoX
DTE2MDgyNTIxNTUzOFowRTEhMB8GA1UECxMYRG9tYWluIENvbnRyb2wgVmFsaWRh
dGVkMSAwHgYDVQQDExdoYWxpbnF1aXJ5dGVzdC5oYWx3LmNvbTCCASIwDQYJKoZI
hvcNAQEBBQADggEPADCCAQoCggEBALi26qE3lUt3aEKs23PnGlsi55ZYs0lItmoE
sRBbm4WTnuGV3wnogNOOij0SvVcIqUvWsFmnWlOb3Yp1leW0htAsUgz0COF2Jy7N
9PejmgRUQ9Kl9MamifH0nRQaFD9V41JxHawGIbtoxC6Ub6STagNAt7HJZqqz6SBM
wJVuoBLL4jkV4CVFUvo+xICB+9TVE+r5I5ZtnKwt9YpLb7fSQjRAgy+9BfGZt6iX
sD/SY7E+FlWYsK9ENamUnt+BVY6uXtN1DpIPVc0Quy5bJ4r0mV4URchouzb38iG5
ypD7h96OHNCrIgS6h7xVBaZeYnfrc+dRRSRgU+dGeS5PYuLiE7MCAwEAAaOCAcgw
ggHEMAwGA1UdEwEB/wQCMAAwHQYDVR0lBBYwFAYIKwYBBQUHAwEGCCsGAQUFBwMC
MA4GA1UdDwEB/wQEAwIFoDA3BgNVHR8EMDAuMCygKqAohiZodHRwOi8vY3JsLmdv
ZGFkZHkuY29tL2dkaWcyczEtMTEzLmNybDBTBgNVHSAETDBKMEgGC2CGSAGG/W0B
BxcBMDkwNwYIKwYBBQUHAgEWK2h0dHA6Ly9jZXJ0aWZpY2F0ZXMuZ29kYWRkeS5j
b20vcmVwb3NpdG9yeS8wdgYIKwYBBQUHAQEEajBoMCQGCCsGAQUFBzABhhhodHRw
Oi8vb2NzcC5nb2RhZGR5LmNvbS8wQAYIKwYBBQUHMAKGNGh0dHA6Ly9jZXJ0aWZp
Y2F0ZXMuZ29kYWRkeS5jb20vcmVwb3NpdG9yeS9nZGlnMi5jcnQwHwYDVR0jBBgw
FoAUQMK9J47MNIMwojPX+2yz8LQsgM4wPwYDVR0RBDgwNoIXaGFsaW5xdWlyeXRl
c3QuaGFsdy5jb22CG3d3dy5oYWxpbnF1aXJ5dGVzdC5oYWx3LmNvbTAdBgNVHQ4E
FgQUp9Cg4a7eWhkr09m9lV/DMKCvDbswDQYJKoZIhvcNAQELBQADggEBACuAbo68
SOrL7Ak4CRPde9m2Dqwx1ViHK4fe+lz3lAXOlfuRXwnIA6KNMzEScIsW8YCyIr7K
VGN3++FaRrlDlIHlajn7uEr2UsCN+vpFW/0XPVDoESO0FDoGILgvh/IbIUwiW9TA
p+rcfJjeM2uGRTQY3YWo0bWNc0RC4YpUo2nmdvV35I/ga3U50ER60mYmThMWvXb3
LMU9Sw36XKkvSBPGLr1rJWu/rzQKtuwWMWXw8CuhxTCgKxROMzhnw4jUbtAI+oyd
a0+6rmOb9HAmraqRZW2/qjOqseo+Ld5np7c8rxPXb2JtLwN7hYQnlI0/YefQ4kBX
YRcEyQvMJ+d1j5s=
-----END CERTIFICATE-----

---
Server certificate
subject=/OU=Domain Control Validated/CN=halinquirytest.halw.com
issuer=/C=US/ST=Arizona/L=Scottsdale/O=GoDaddy.com, Inc./OU=http://certs.godaddy.com/repository//CN=Go Daddy Secure Certificate Authority - G2
---
No client certificate CA names sent
---
SSL handshake has read 1498 bytes and written 440 bytes
---
New, TLSv1/SSLv3, Cipher is RC4-MD5
Server public key is 2048 bit
Secure Renegotiation IS supported
Compression: NONE
Expansion: NONE
SSL-Session:
Protocol : TLSv1
Cipher : RC4-MD5
Session-ID: 982500008C3CC53F4FDF7678FCD3A2EF83F01834E69EF11B3746A0F63CC9265B
Session-ID-ctx:
Master-Key: C6EE7071AE8731E7554122713C6D81FB3415EB75BE83E6D9CFB039F2030739D77D9A98196993F82A8AA69129967B5EC9
Key-Arg : None
Start Time: 1463000757
Timeout : 300 (sec)
Verify return code: 21 (unable to verify the first certificate)
---

Install SQL*Plus on MacBook

Refer: https://tomeuwork.wordpress.com/2014/05/12/how-to-install-oracle-sqlplus-and-oracle-client-in-mac-os/
Refer: https://halpjira01.flagship.hal.com:9443/confluence/pages/viewpage.action?pageId=46664178

Instructions for this setup were taken from this blog post and massaged to reflect the current version number of the Oracle application.

Download the following two files from the Oracle website: http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html

"Instant Client Package - Basic"
"Instant Client Package - SQL*Plus"
Extract the files and create the proper directory structure

Open the terminal and unzip the downloaded files
$ unzip -qq instantclient-basic-macos.x64-12.1.0.2.0.zip
$ unzip -qq instantclient-sqlplus-macos.x64-12.1.0.2.0.zip
These will be extracted into a single directory: instantclient_12_1

Create the expected directory structure
$ mkdir -p /Applications/oracle/product/instantclient_64/12.1.0.2.0/{bin,lib,jdbc/lib,rdbms/jlib,sqlplus/admin,network/admin}

Transfer files over to the new directory
$ ORACLE=/Applications/oracle/product/instantclient_64/12.1.0.2.0
mv ojdbc* $ORACLE/jdbc/lib/
mv x*.jar $ORACLE/rdbms/jlib
mv glogin.sql $ORACLE/sqlplus/admin
mv *dylib* $ORACLE/lib/
mv *README $ORACLE
mv ./* $ORACLE/bin/

Add tnsnames.ora to /Applications/oracle/product/instantclient_64/12.1.0.2.0/network/admin/
You should be able to get this file from another dev

Set up the environment variables
$ cd ~ && vi ~/.bash_profile

Add the following exports to .bash_profile
export ORACLE_HOME=/Applications/oracle/product/instantclient_64/12.1.0.2.0
export PATH=$ORACLE_HOME/bin:$PATH
export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib

Update .bash_profile
$ source ~/.bash_profile

After all that, you should now be able to run SQL*Plus from the command line.

Windows Activation through Command Line

Windows 10 Udate Activation Key

Refer: http://www.tenforums.com/tutorials/35979-product-key-uninstall-deactivate-windows-10-a.html

Remove the old activation key
C:> slmgr /upk

Clear the registory
C:> slmgr /cpky

Enter the new key - you may need to do through GUI today
C:> slmgr /ipk XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

Activate the key
C:> slmgr /ato

Remove Windows 10 OneDrive

Refer: http://lifehacker.com/how-to-completely-uninstall-onedrive-in-windows-10-1725363532

To completely uninstall OneDrive:

Open Command Prompt in Administrator mode: Right-click on the Windows icon in the taskbar and select Command Prompt (Admin).

Type in taskkill /f /im OneDrive.exe to terminate any OneDrive processes and hit Enter.

64-Bit Installation
C:> %SystemRoot%\SysWOW64\OneDriveSetup.exe /uninstall

32-Bit Installation
C:> %SystemRoot%\System32\OneDriveSetup.exe /uninstall

Installing Wine in Ubuntu 16.04

Installing Wine 3.0

Refer: https://linuxconfig.org/how-to-play-world-of-warcraft-on-linux-with-wine

If you are getting black buttons, use winecfg and change default setting to Windows XP instead of Windows 7

$ winecfg
$ sudo apt install winetricks
$ winetricks, launch, and choose option install corefonts
$ wine uninstaller

Refer: http://www.omgubuntu.co.uk/2017/04/how-to-add-wine-repository-ubuntu

You might want to install from /tmp, because your going to download a Release.key

Instructions: install-wine-on-ubuntu.txt

Older Install Wine in Ubuntu 16.04

Refer: http://linuxg.net/install-wine-1-8-on-ubuntu/

Install with the following:

$ sudo add-apt-repository ppa:ubuntu-wine/ppa
$ sudo apt-get update
$ sudo apt-get install wine1.8 winetricks

Remove with
$ sudo apt-get uninstall wine1.8 winetricks