Jeffry Smith writes:
> Slap self. Checked the log files, it's showing that index.cgi is
> dying because:
> DBI->connect failed: ERROR: PQQconnectdb() - Missing '=' after
> 'tuxbiz:localhost.localdomain:5432' in conninfo at
> home/httpd/tuxbiz/index.cgi line 138.
It would be helpful if you could tell us which line was line 138.
> Relevant line(s) say:
>
>$q="DBI:$site->{'datadriver'}:$site->{'table'}:$site->{'table_serv'};$site->{'table_port'}";
> $dbh=DBI->connect($q, $site->{'store_dbiuser'},
> $site-.['store_dbipwd'} );
^^^
|
|
This doesn't look like legal Perl code to me.
Wouldn't you want that first line to look something like this?:
$q= "DBI:" .
"$site->{'datadriver'}:" .
"database=$site->{'table'}:" .
"host=$site->{'table_serv'};" .
"port=$site->{'table_port'}";
(I reformatted this for clarity)
> This, despite the error saying not having access. Misleading error.
> I think the "=" goes after the 'datadriver', or does it go after the
> $q on the second line? Why?
Remind us of which DB backend you're using, willya? Because that
affects how the string that is passed to the connect() method should
look.
> Ideas welcome.
You're not calling the connect method with a valid specifier, and DBI
is blowing up. It's that simple.
I hope this helps,
--kevin
--
Kevin D. Clark | | Will hack Perl for
[EMAIL PROTECTED] | [email protected] | fine food, good beer,
Cabletron Systems, Inc. | PGP Key Available | or fun.
Durham, N.H. (USA) | |
