pgsql & freeside

[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);

My guess is 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.

-- 
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 Thu, 17 Sep 1998, Mark wrote:

> I really hope this isn't a redundant question, but here's an error I'm
> getting while attempting to use:
> 
> PostgreSQL 6.3.2
> DBI-1.02
> DBD-Pg-0.73
> perl5.004_04
> ---
> %id
> uid=1018(freeside) gid=20(staff) groups=20(staff)
> %bin/fs-setup 
> 
> Enter the maximum username length: 8
> 
> Freeside tracks the RADIUS attributes User-Name, Password and
> Framed-IP-Address
> for each user.  Enter any additional RADIUS attributes you need to track
> for
> each user, separated by whitespace.
> :Port-Limit
> Use of uninitialized value at /usr/local/lib/perl5/site_perl/DBD/Pg.pm line 65.
> Use of uninitialized value at /usr/local/lib/perl5/site_perl/DBD/Pg.pm line 65.
> ERROR: PQconnectdb() - Missing '=' after 'freeside' in conninfo
>  at /usr/local/lib/perl5/site_perl/FS/UID.pm line 72
> DBI->connect error: ERROR: PQconnectdb() - Missing '=' after 'freeside' in conninfo
> 
> As a newbie to this program, and pgsql for that matter, I tried attaching
> a = to the end of freeside/conf/secrets and it didn't like that too well
> either. Need more information? Let me know, and please help if you can.
> Thanks in advance,
> -Mark
> 
>