Perl DBI and remote host connections

[Alma J Wetzker]

David Bandel wrote:
> On Wed, 10 Nov 2004 10:04:27 -0800, Bill Campbell
> <linux-sxs at celestial.com> wrote:
> 
>>On Wed, Nov 10, 2004, David Bandel wrote:
>>
>>>Folks,
>>>
>>>I have done a lot of local web <--> local db work without a problem
>>>using Perl DBI.  However, this time, the db is remote.  So I went
>>>through the motions of putting in the necessary dbi parameters:
>>>
>>>$dbh = DBI???>connect("dbi:Sybase:database=$database;host=$host;port=$port",
>>>$username, $passwd);
> 
> 
> This is weird (and not what I sent).  
> 
> 
>>Your post had some funny characters that may just be typical
>>Microshaft formatting.
> 
> 
> No, this came nowhere near any M$ system (Google runs on Linux), so I
> have no idea how it got corrupted _after_ I sent it.
> 
> 
>>
>>
>>>I have all the variables properly defined like so:
>>>my $host=192.168.7.59;
>>>my $port=1433;
>>>
>>>Using tcpdump, I get no outgoing connection attempts to the remote
>>>server.  My || die 'message' $! ; tells me no db connection (duh).  Of
>>>course not, there's not even an arp who-has looking for the remote
>>>host.
>>>
>>>What have I missed?  Don't believe I need to include all the
>>>networking modules, but I may be wrong.
>>
>>Firewall blocking?  Can you telnet to port 1433 on the remote system?
> 
> 
> No firewall between the two systems.  They're on the same subnet
> (192.168.7.0/24) and connected via a hub.  The second system can be
> accessed from another Linux system using a PHP app.
> 
> It just looks like nothing is hitting the wire outbound.
> 
> Ciao,
> 
> David A. Bandel
FWIW, the original came through with font information.  I use Mozilla and most 
of David's emails come through as text only displayed with the default font 
and size.  The original message in this thread displayed with a different font 
and a smaller font size than my default.  I could read the original just fine.

     -- Alma