Re: [GUSDEV] dbiDsn weirdness

[Chris S. <sto...@pc...>]

Hi Fernan,
Not doing much here on the postgres side of things so can't offer  
much help. Hopefully one of the other groups using postgres will  
reply. Certainly file a bug report and if no one says anything I  
would certainly welcome your contributing to software.
Cheers,
Chris

Chris Stoeckert, Ph.D.
Research Associate Professor, Dept. of Genetics
1415 Blockley Hall, Center for Bioinformatics
423 Guardian Dr., University of Pennsylvania
Philadelphia, PA 19104
Ph: 215-573-4409 FAX: 215-573-3111

On Apr 12, 2006, at 5:12 PM, Fernan Aguero wrote:

> Hello, again,
>
> I'm having a problem with my gus.config file, and more
> specifically with the dbiDsn string.
>
> I have a test database (testdb) and I can connect to this
> database either using perl or java (using minimal programs
> that just connect to the DB) or in a terminal using psql.
>
> However, the dbiDsn that I use succesfully in my scripts
> (dbi:Pg:dbname=testdb) doesn't work when used in the
> gus.config file.
>
> The details are below. Should I file a bug report?
>
> Fernan
>
> ======================================================================
> Details
> ======================================================================
> perl: 5.8.8
> DBI: 1.5.0
> DBD-Pg: 1.43
> GUS: SVN snapshot from 11.Apr.2006
>
> dbiDsn in gus.config:
> dbiDsn=dbi:Pg:dbname=testdb
>
> output of 'build GUS install -append':
> [exec] Can't connect to data source "dbi:Pg:dbname=testdb", no  
> database driver specified and DBI_DSN env var not set at /scratch/ 
> shared/GUS-11.Apr.2006/gus_home/lib/perl/GUS/ObjRelP/DbiDatabase.pm  
> line 173
>
> Just to test, I tried the following dbiDsn, which I found
> mentioned in one bug report
> dbiDsn=dbi:Pg:dbname=testdb;port=5432
>
> and now 'build GUS install -append' went through without
> errors. 5432 is the default port for postgres, so it
> shouldn't need to be set explicitly. This made me think that
> the problem was the missing ';' and so I tried the following:
> dbiDsn=dbi:Pg:dbname=testdb;
>
> which also worked quite nicely. Which brings us to the question:
> is this a documentation bug? Or a software bug?
>
> I can file a bug report and either fix it (documentation) or
> help as much as I can (software).
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting  
> language
> that extends applications into web and mobile media. Attend the  
> live webcast
> and join the prime developer group breaking into this new coding  
> territory!
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev