pgsql & freeside

Ivan Kohler ivan at
Thu Sep 17 19:05:58 PDT 1998

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

	$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:


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


Hope that helps.

Ivan Kohler <ivan at> - finger for PGP key
Silicon Interactive Software Design - - 888-670-SISD
Open-source billing and administration for ISPs -
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/ line 65.
> Use of uninitialized value at /usr/local/lib/perl5/site_perl/DBD/ line 65.
> ERROR: PQconnectdb() - Missing '=' after 'freeside' in conninfo
>  at /usr/local/lib/perl5/site_perl/FS/ 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

More information about the freeside-users mailing list