Support Oracle as a backend database about puppet-stash HOT 5 CLOSED

The documentation reads as follows "Stash requires a relational database to store its configuration data. This module currently supports PostgreSQL 8.4 to 9.x and MySQL 5.x. We suggest using puppetlabs-postgresql/puppetlabs-mysql modules to configure/manage the database. The module uses PostgreSQL as a default."

I don't believe it indicates that these are the only databases that stash supports, it only implies that these are the databases that this module supports.

I think you are spot on with whats required to implement (plus tests). It should be rather trivial. It would be nice to have acceptance tests for oracle too, that may prove more challenging however and I do not think it is a must have for oracle support to be added.

from puppet-stash.

maybe there's a vagrant box somewhere out there with a pre-installed oracle db?

from puppet-stash.

@igalic probably not because oracledb is closed. Same problem with mssql. If we can find one I can add it to pcci though.

from puppet-stash.

I was able to install against Oracle with stash 3.8 and the following db settings with no module changes:

---
  stash::dburl: 'jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.example.lan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = stash)))'
  stash::dbuser: 'stash'
  stash::dbpassword: 'stash_password'
  stash::dbdriver: 'oracle.jdbc.driver.OracleDriver'

It did not prompt for db settings during setup, and appears to connect after installation. Acceptance test will be non trivial even with biemond-oracle module. This can be documented, but promising module support for Oracle is another level of challenge altogether.

from puppet-stash.

@jfautley sounds like you've got your answer. If someone wants to they can sumarize nan's experience as a sidebar in the readme.

from puppet-stash.