Re: [Gusdev-gusdev] grantPermissions.pl - dbport parameter

[Jonathan C. <cra...@pc...>]

steve fischer wrote:
> Arnaud-
> 
> i think you can provide this in your .gus.properties file:
> 
> it has this proprerty:
> dbiDsn=dbi:Oracle:host=erebus.pcbi.upenn.edu;sid=gusdev

That's true, but it doesn't fix the problem Arnaud mentioned, which
is that grantPermissions.pl is constructing the DBI DSN string itself
(using the Database.pm module) and is not giving the user the chance
to specify a non-standard port for the Oracle server.  I think that
what I want to do here is to fix grantPermissions.pl as Arnaud described
(rather than force it to use the standardized dbiDsn).  The reason for
this is that we can then use grantPermissions.pl on an Oracle instance
that differs from the one specified in the properties file.  I think
this is a reasonable thing to do for the DBA utilities, not all of which
are as tightly tied to GUS as, for example, the Perl object layer and
other parts of the system.

Jonathan

-- 
Jonathan Crabtree
Center for Bioinformatics, University of Pennsylvania
1406 Blockley Hall, 423 Guardian Drive Philadelphia, PA 19104-6021
215-573-3115