gusdev-gusdev

[Gusdev-gusdev] grantPermissions.pl - dbport parameter

[Arnaud K. <ax...@sa...>]

  Hi

Would it be possible to add an extra parameter, dbPort, to the script 
grantPermissions.pl and pass it to GUS::DBAdmin::Database constructor?

The connection fails unless we give a port number. Here the dbi_dsn 
which works for us : 'dbi:Oracle:host=ocs3;sid=tpat;port=1532'

Thanks
Arnaud

-- 
Arnaud Kerhornou

The Wellcome Trust Sanger Institute
The Pathogen Sequencing Unit
Wellcome Trust Genome Campus, Hinxton, Cambridge, CB10 1SA, UK
Work: +44 (0) 1223 494955
Fax:  +44 (0) 1223 494919

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

[steve f. <sfi...@pc...>]

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

steve


Arnaud Kerhornou wrote:

>  Hi
>
> Would it be possible to add an extra parameter, dbPort, to the script 
> grantPermissions.pl and pass it to GUS::DBAdmin::Database constructor?
>
> The connection fails unless we give a port number. Here the dbi_dsn 
> which works for us : 'dbi:Oracle:host=ocs3;sid=tpat;port=1532'
>
> Thanks
> Arnaud
>

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

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

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

On Thu, 20 Feb 2003, Arnaud Kerhornou wrote:
> Would it be possible to add an extra parameter, dbPort, to the script
> grantPermissions.pl and pass it to GUS::DBAdmin::Database constructor?

Arnaud-

This should be fixed now.  I also had to update
DBAdmin/lib/perl/Database.pm due to a bug in the code that was
constructing the DBI_DSN string.

Jonathan