All,

I am at the end of my rope.  I have searched the web and the archives and 
have seen no solution to this posted, but I have seen some similar posts 
out there.  My proxy seems to be working just fine as long as I connect 
from the local host.  It fails when I try to connect from anywhere else. I 
have been running with the proxy server in debug mode and can see it 
connecting and logging in ok.  But then just terminates.  Can anyone tell 
me if I am overlooking something or doing something dumb?

Thanks,

Drew 

Code
#########################################################################
use DBI;


my $dbh = DBI->connect(
'dbi:Proxy:hostname=xxx.xxx.xxx.xxx;port=9001;dsn=dbi:ODBC:Master Log', 
'user',
'passwd', { RaiseError => 1, PrintError => 1 } ) or die $DBI::errstr;


my $sth = $dbh->prepare( 'select * from master' );


$sth->execute;


DBI::dump_results($sth);


$sth->finish;


$dbh->disconnect;

exit 0;

#################################################################################
Config file
*********************************************************************************
{
        # Access control
        'clients' => [
            # Accept the local
            {
                'mask' => '^10\.\d+\.\d+\.\d+$',
                'accept' => 1
            },
            {
                'mask' => '127.0.0.1',
                'accept' => 1
            },
            # Accept myhost.company.com
            {
                'mask' => '.aholdusa\.com$',
                'accept' => 1
            },
            # Deny everything else
            {
                'mask' => '.*',
                'accept' => 0
            }
        ]
    }
**********************************************************************************
Error
----------------------------------------------------------------------------------
Error while connecting to remote DSN: Error while reading server reply: 
Expected
 array at new_db.pl line 6  

Debug output from server
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Mon May 13 14:57:43 2002 debug, Connection from xxx.xxx.xxx.xxx, port 
37971
Mon May 13 14:57:43 2002 debug, Child clone: 
DBI::ProxyServer=HASH(0x1c3f704)

Mon May 13 14:57:43 2002 debug, New child starting 
(DBI::ProxyServer=HASH(0x1c3f
704)).
Mon May 13 14:57:43 2002 debug, Accepting client from xxx.xxx.xxx.xxx, 
port 37971

Mon May 13 14:57:43 2002 debug, Client logs in: Application 
dbi:ODBC:Master Log,
 version 0.1004, user user
Mon May 13 14:57:43 2002 debug, Connecting to dbi:ODBC:Master Log as user
Mon May 13 14:57:43 2002 debug, Accepting client
Mon May 13 14:57:43 2002 debug, Child terminating.

Reply via email to