Java Summer Workshop

Java Summer Workshop for Oracle kids

VirtualBox : Update Extension Pack failed, 0x80004005, VERR_ALREADY_EXIST

 

Failed to install the Extension Pack ~~/Oracle_VM_VirtualBox_Extension_Pack-4.1.10.vbox-extpack.

The installer failed with exit code 1: VBoxExtPackHelperApp.exe: error: Failed to rename the extension pack directory: VERR_ALREADY_EXISTS

rcExit=1.

Result Code:
E_FAIL (0x80004005)

Component:
ExtPackManager

Interface:
IExtPackManager {3295e6ce-b051-47b2-9514-2c588bfe7554}

 

 

The work around was to delete the folder:

~~\VirtualBox\ExtensionPacks\Oracle_VM_VirtualBox_Extension_Pack-_-uninst

After that all went well, uninstall and install the new extension pack of latest version.

Installing Insight on CloudFoundry

Enter the insight application token <not shown>

Since I was reaching the memory limit I had to delete applications.

 

Enabling Insight for application

NationalGrid error exposing the complete SQL

MySQL Exception : Duplicate entry '65535' for key 1

If you have auto-increment integer key in MySQL you might hit the upper  limit for SMALLINT when total rows = 65535 and get an error like :-


#1062 - Duplicate entry '65535' for key 1 


In such cases just change the structure of the table and change the datatype to MEDIUMINT or BIGINT

HTTPS github access

Error:
error: SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed while accessing

* SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
* Expire cleared
* Closing connection #0
error: SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed while accessing https://github.com/oharab/ExcelANT.git/info/refs

fatal: HTTP request failed

Solution:

export GIT_SSL_NO_VERIFY=true

git config --global http.sslVerify false

1. In Firefox, go to the github page (any)



2. click on the github icon on the address bar to display the certificate



3. Click through "more information" -> "display certificate" --> "details" and select each node in the hierarchy beginning with the uppermost one; for each of them click on "Export" and select the PEM format:
   
   
   
   • GTECyberTrustGlobalRoot.pem
   
   
   
   • DigiCertHighAssuranceEVRootCA.pem
   
   
   
   • DigiCertHighAssuranceEVCA-1.pem
   
   
   
   • github.com.pem
   
   
   
   



4. Save the above files somewhere in your local drive, change the extension to .pem and move them to /usr/ssl/certs



5. Run c_rehash from the bash. For find c_rehash run the following command
   

   locate c_rehash

   
   

Installing git on Oracle Linux/RHEL

There is no direct way of installing git on Oracle Linux/RHEL as yum repositories do not have git and git-core packages and there is no rpm package available.
Start terminal and download tar bundle of git from here :-
http://kernel.org/pub/software/scm/git/
In my case,

wget http://kernel.org/pub/software/scm/git/git-0.7.tar.gz

wget http://kernel.org/pub/software/scm/git/git-core-0.99.6.tar.gz

Then extract the two files using following commands (or via the graphical shell)

tar xvfz git-0.7.tar.gz

tar xvfz git-core-0.99.6.tar.gz

build the packages using

cd git-0.7

make

And install using

make install

Similarly for git-core

cd git-core-0.99.6

make

make install

If make install complains that /home/<home directory>/bin is not found create the bin directory inside your home directory and then run make install. Later in /home/<home directory>/bin use sudo make install /bin

git error: cannot handle https

Error:
git clone https://xxx I got the following error
I don't handle protocol 'https'

Solution:
Version 0.99.9i of git does not support https protocol.
Try to install a more recent version of git. The easiest solution would be to install it via apt-get:

$ apt-get update
$ apt-get install git

After that check that the correct version is used:

$ hash -r
$ which git
/usr/bin/git

If the returned string is not /usr/bin/git, then you have another older version of git in your PATH that is masking the more recent one. Remove it by moving it to some other place

---

If you do not want to install git via apt-get or if you do not have administrator privilege on your machine, you can built it from source. You can download them from git website, and compilation should be as simple as:

$ tar -xvfj git-1.7.8.4.tar.bz2
$ cd git-1.7.8.4
$ ./configure --prefix=$HOME/install
$ make && make install

After that, you'll have to add $HOME/install/bin to your PATH.

$ hash -r
$ PATH="$HOME/install/bin:${PATH}"
$ git --version
git version 1.7.8.4

Update to Comcast DTA self-install kit

Points to remember:-

1. Tune your TV to the same channel number as you have selected on the DTA box. DTA box is tuned to channel 3 by default. Once TV is tuned you may use your Comcast cable for channel selection
2. You will lose all HD channels and all you will get is Analog channels  unless you have HD package from Comcast

Staples Software Delivery

Surprizingly I could not download my software purchased through Staples for download on Chrome or Firefox. On clicking the download link "nothing happens"

It seems only Microsoft Internet Explorer works for Software Delivery.