cbandy / travis-oracle Goto Github PK

if oracle website have problems, the script don't show the problem, and process continue.

Thanks for providing travis-oracle. Not every time but I'm seeing Archive: oracle-xe-11.2.0-1.0.x86_64.rpm.zip End-of-central-directory signature not found. errors.

• Error message

Archive:  oracle-xe-11.2.0-1.0.x86_64.rpm.zip
  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
unzip:  cannot find zipfile directory in one of oracle-xe-11.2.0-1.0.x86_64.rpm.zip or
        oracle-xe-11.2.0-1.0.x86_64.rpm.zip.zip, and cannot find oracle-xe-11.2.0-1.0.x86_64.rpm.zip.ZIP, period.
The command ".travis/oracle/install.sh" failed and exited with 9 during .
Your build has been stopped.

• Full output
  https://travis-ci.org/rsim/oracle-enhanced/jobs/119416269

It does not reproduce every time. Also when the same commit pushed to my origin repository, it works fine.

• Push the same commit to my origin repository
  https://travis-ci.org/yahonda/oracle-enhanced/jobs/119414739

I'd like to address this since there is no work around found yet.

Even with the fix for #10, a failed login (e.g. bad or missing password) will manifest as an error during install about a bad archive file. It would be nicer to detect this and relay an informative message to the user.

Can you help me with my Travis setup?
The download fails for some reasons.
https://travis-ci.org/utPLSQL/utPLSQL-demo-project/builds/222538724#L238

Error: Cannot find module '/home/travis/download.js'

    at Function.Module._resolveFilename (module.js:338:15)

    at Function.Module._load (module.js:280:25)

    at Function.Module.runMain (module.js:497:10)

    at startup (node.js:119:16)

    at node.js:929:3

When I'm running my Travis builds, most of them fail with the above error message.
The build is passing however when I go to Oracle site and re-approve the license agreement.
https://travis-ci.org/utPLSQL/utPLSQL-demo-project/builds/222647318

I've accepted the Oracle License and have managed to get the file download locally using IE, Chrome and Firefox.

Did Oracle change something on their end that made the download solution unstable?

Apparently, need to replace https://edelivery.oracle.com/akam/otn/linux/ with https://edelivery.oracle.com/otn/linux/ (remove "/akam") in download.js

Secondly, a different default for ORACLE_FILE=oracle18c/xe/oracle-database-xe-18c-1.0-1.x86_64.rpm

Also, it is downloaded as .rpm, not as .zip anymore,

Not figured out yet, why sometimes download fails sometimes not, perhaps Oracle website has some limits set.

Include only the readme, license and scripts (no tests, gemfile, etc.)

• https://help.github.com/articles/creating-releases/

My download.js is not modified, and while running many builds I encountered this error on one of them.

+exec node download.js
{ errorCode: 299,
  errorString: 'Error downloading https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_login?Site2pstoreToken=v1.2~CA55CD32~... - server replied: Bad Request',
  id: 2,
  url: 'https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_login?Site2pstoreToken=v1.2~CA55CD32~A...' }
Unable to connect to oracle.com

https://travis-ci.org/jayvdb/travis-oracle/jobs/119102903

Consider caching and --unless-exists argument as well.

$ shasum -a 256 oracle-xe-11.2.0-1.0.x86_64.rpm.zip
b5039fad2e4f92c68778dcabbd0b4622a6cb025f25f7d6222f9e9de53ebab531  oracle-xe-11.2.0-1.0.x86_64.rpm.zip

The container-based infrastructure disallows sudo. Either

1. Find a way to install without sudo, or
2. Document the required .travis.yml settings.

error: .cache/oracle/oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm: not an rpm package (or package manifest):

Here are a few ways this can be done : https://blogs.oracle.com/opal/entry/the_easiest_way_to_enable

The Oracle db part should be a fairly straight forward mix of installing VirtualBox , finding a slim-ish VM image that is sufficient for Oracle XE, and the Oracle rpm that we're already downloading.

Then installing the Oracle client on OSX and configuring the tunnelling..

It would be good to include a unicode test

In order to get unicode to work properly with an nvarchar2 using pythons cx_Oracle, I needed to set NLS_LANG=American_America.UTF8. I dont know for sure that it is a cx_Oracle specific problem, but I suspect it may also be a problem for other clients, in which case the documentation should mention this.

Also it would be good to note in the documentation that LD_LIBRARY_PATH may need to be set for some clients to work. (again, this was needed to get it to work with cx_Oracle).

If it is of interest, my successful use of cx_Oracle is at https://github.com/jayvdb/era_data .
If it is useful, I'd be happy to create a set of sample cx_Oracle python files for this repo .

First, thanks for the downloader. It's been awesome, great time sver.

In SOCI project, we used it with great success (eg. https://travis-ci.org/SOCI/soci/jobs/281665636).
Lately, our builds stopped working due to incomplete downloads (eg. https://travis-ci.org/SOCI/soci/jobs/291261632) and I'm unclear what is the reason. If I sign in to the Oracle website via web browser using the downloader's credentials, all works.

I noticed a difference in the downloader output - now it prints:

Unable to use all ORACLE_LOGIN environment variables: ["password","ssousername"]

What does this message mean?

Does it mean anything changed in Travis CI and I have to re-add the environment variables with credentials to re-hash them?

Has Oracle changed their login form?

Unfortunately, my JS fu is running very short to figure out from the download.js :(
I'd appreciate any insights.