PQconnectdb() error...

[Ivan Kohler]

/var/spool/freeside/conf/secrets contains three lines, which correspond to
the first three arguements for the DBI connect method (see the DBI
manpage):

	$dbh = DBI->connect($data_source, $username, $auth);
	$dbh = DBI->connect($data_source, $username, $auth, \%attr);

The interpretation of $data_source is driver-specific.  The syntax for
DBD::Pg (see the DBD::Pg manpage) is:

	$dbh = DBI->connect("dbi:Pg:dbname=$dbname", $user, $passwd);

You have:

DBI:Pg:freeside
freeside
your_password

in /var/spool/freeside/conf/secrets, and you should have:

DBI:Pg:dbname=freeside
freeside
your_password

Hope that helps.

I'll try to make this more clear in the documentation.

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key
Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too

On Wed, 30 Sep 1998, Robert Davidson wrote:

> 
> Hello,
> 
> I hope I am sending this to the right E-mail address, but if not I guess I'll
> find out soon.
> 
> I have a problem with Freeside during the fs-setup program. The output is
> below, I've tryed many things to get around it but with no success.
> I am using Freeside 1.1.2 but 1.1.1 did the same thing anyway.
> 
> ERROR: PQconnectdb() - Missing '=' after 'freeside' in conninfo
> at /usr/lib/perl5/site_perl/FS/UID.pm line 72
> DBI->connect error: ERROR: PQconnectdb() - Missing '=' after 'freeside' in
> conninfo
> 
> The contents of my /var/spool/freeside/secrets file is this:
> DBI:Pg:freeside
> freeside
> abcdefgh
> 
> (that isn't the real password though).
> 
> Any ideas anyone?
> 
> Regards,
> Robert Davidson.
> roblo at ebbs.com.au
> 
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key
Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too