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

[Robert Haskins]

I have no idea where it is getting that munged DBI data source from; 
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? 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