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.