[freeside] DBI connect error in UID.pm line 82 running fs-setup

[ivan]

On Fri, Jun 01, 2001 at 08:43:43PM -0400, Robert Haskins wrote:
> I have no idea where it is getting that munged DBI data source from; 

Neither do I.  Run under the Perl debugger and find out.

> this is what I have in my secretfile, copied verbatim (except of course 
> for the dbusername and dbpassword) from the freeside config.html:
> 
> bash-2.05$ more /usr/local/etc/freeside/secretfile
> DBI:Pg:host=localhost;dbname=freeside
> freeside
> freeside
> 
> I'm obviously missing something here. Is the DBI data source in some 
> other file besides the /usr/local/etc/freeside/secretfile?

Nope.

> Thanks very 
> much for your help.
> 
> ivan wrote:
> 
> > `host=localhost;dbname=freeside' is not a valid DBI data source.
> > 
> > See htdocs/docs/config.html, the DBI manpage
> > http://search.cpan.org/doc/TIMB/DBI-1.15/DBI.pm and the manpage for your
> > DBD (in your case, the DBD::Pg manpage:
> > http://search.cpan.org/doc/MERGL/DBD-Pg-1.00/dbd-pg.pod)
> > 
> > As per htdocs/docs/config.html, an example of a valid DBI data source is:
> > DBI:Pg:host=localhost;dbname=freeside
> > 
> > 
> > On Fri, Jun 01, 2001 at 07:22:42PM -0400, Robert Haskins wrote:
> > 
> >> I'm trying to install Freeside 1.3.0 for the first time on a Sun Blade 
> >> 100 running Solaris 8 (uname -a reports "SunOS pegasus 5.8 
> >> Generic_108528-08 sun4u sparc SUNW,Sun-Blade-100") with PostgreSQL 7.1.1 
> >> and Perl 5.6.1. All of the required Perl modules have been installed and 
> >> tested with their respective installation scripts. I installed DBD 
> >> version 0.98 for PostgreSQL and DBI version 1.15.
> >> 
> >> The error message I am receiving when I run the command "./fs-setup 
> >> freeside" as user freeside from the freeside source directory is the 
> >> following:
> >> 
> >> DBI->connect(host=localhost;dbname=freeside) failed: 1 at 
> >> /usr/local/lib/perl5/site_perl/5.6.1/FS/UID.pm line 82
> >> DBI->connect error: 1
> >> 
> >> I've read all of the freeside configuration documentation, all of the 
> >> related PostgreSQL web pages and all of the related Perl module 
> >> documentation. I've also searched the archives of this mailing list and 
> >> cannot find this error anywhere. I can connect to the PG freeside 
> >> database as the freeside user, but I just cannot seem to get this setup 
> >> script to work! I also am unable locate what "DBI->connect error: 1" means.
> >> 
> >>  From everything I've read and seen from the online demo, it looks like 
> >> freeside is an *awesome* system. I hope someone can give me a hand, I 
> >> know I must be missing something really basic and simple. I'm really 
> >> looking forward to moving my customers over to freeside. The 
> >> functionality is amazing!
> >> 
> >> Feel free to email me directly, and I'll summarize and post what I find 
> >> back to the list. Thanks in advance for your help.
> >> -- 
> >> Robert D. Haskins
> >> WorldNET
> >> mailto:rhaskins at wn.net
> >> http://www.ziplink.net/~rhaskins
> >> 
> 
> 
> -- 
> Robert D. Haskins
> WorldNET
> mailto:rhaskins at wn.net
> http://www.ziplink.net/~rhaskins
> 

-- 
meow
_ivan