#2 SPAN DBI connect failure

[Mikhail Bezruchko]

Original submission information:

Date: 7/16/03
Submitted by: Arlin
Submitted to:
Status (open/fixed): open

Problem involves configuration implemented by current version of SPAN.pm
failing to adapt to how DBI makes connections.

I have seen this before, but Chengzhi has sent me his notes so I will
use them. He notes that in span-export.pl:

DBI->connect("dbi:$dbiDriver:dbname=$dbName; host=$dbHost",
"$dbUser","$dbPassword", {RaiseError => 1, AutoCommit => 1})

gives error message :
DBI connect('dbname=spanw; host=localhost','liangc',...) failed: could not
connect to server: Connection refused at /usr/local/bin/span-export.pl line
30

but after removing dbhost from above line, this command:
DBI->connect("dbi:$dbiDriver:dbname=$dbName", "$dbUser","$dbPassword",
{RaiseError => 1, AutoCommit => 1})

works correctly.

Also the original version works correctly for a remote host, because
Daniel has used it in this way. However, when the host is local,
using host="localhost" raises an error, as above. I don't know
about using an empty hostname. We should check this.

Possibly the use of localhost causes DBI to request a TCP/IP
socket to the local in question was not offering psql services
via TCP/IP, but only via UNIX socket. We should check this.